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

[postrr.git] / src / postrr.sql.in

diff --git a/src/postrr.sql.in b/src/postrr.sql.in
index 01cd65f8a6be9b2c49339c629f6f0efcc72a6f4e..546a9dffa1b5003bf723fe6d1bac71012dca4887 100644 (file)
--- 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'