From: Sebastian Harl <sh@tokkee.org>
Date: Tue, 23 Oct 2012 11:31:36 +0000 (+0200)
Subject: postrr.sql: Added 'postrr.rrarchives' table.
X-Git-Url: https://git.tokkee.org/?p=postrr.git;a=commitdiff_plain;h=355393a5307e37b13fc70ef84d651761d236c398;hp=5fcbb27b04ad6e208f034d79f824a52354f84a56

postrr.sql: Added 'postrr.rrarchives' table.

This table will be used to store "Round Robin Archive" definitions. Each
archive has a name which may be used to identify the archive and a description
of the table(s) that store the values of the archive. Each entry specifies the
table as well as the RRTimeslice and CData columns to be used for storing the
values.
---

diff --git a/src/postrr.sql.in b/src/postrr.sql.in
index 01cd65f..546a9df 100644
--- a/src/postrr.sql.in
+++ b/src/postrr.sql.in
@@ -45,6 +45,14 @@ CREATE TABLE postrr.rrtimeslices (
 	tsnum integer NOT NULL
 );
 
+CREATE TABLE postrr.rrarchives (
+	rraname text NOT NULL,
+	tbl name NOT NULL,
+	tscol name NOT NULL,
+	vcol name NOT NULL,
+	UNIQUE (rraname, tbl, tscol, vcol)
+);
+
 CREATE OR REPLACE FUNCTION PostRR_Version()
 	RETURNS cstring
 	AS 'postrr-@POSTRR_MAJOR_VERSION@.@POSTRR_MINOR_VERSION@', 'postrr_version'