From 355393a5307e37b13fc70ef84d651761d236c398 Mon Sep 17 00:00:00 2001 From: Sebastian Harl Date: Tue, 23 Oct 2012 13:31:36 +0200 Subject: [PATCH] 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. --- src/postrr.sql.in | 8 ++++++++ 1 file changed, 8 insertions(+) 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' -- 2.30.2