join: update library paths, install to new location

[hcoop/portal.git] / tables.sql

diff --git a/tables.sql b/tables.sql
index 8ff5251..ccaca80 100644 (file)
--- a/tables.sql
+++ b/tables.sql
@@ -104,6 +104,8 @@ CREATE TABLE Poll(
        starts DATE NOT NULL,
        ends DATE NOT NULL,
        votes INTEGER NOT NULL,
+       official BOOL NOT NULL,
+       ready BOOL NOT NULL,
        FOREIGN KEY (usr) REFERENCES WebUser(id) ON DELETE CASCADE);
 
 CREATE SEQUENCE PollSeq START 1;
@@ -346,6 +348,18 @@ CREATE TABLE Cert(
 
 CREATE SEQUENCE CertSeq START 1;
 
+CREATE TABLE Sign(
+       id INTEGER PRIMARY KEY,
+       usr INTEGER NOT NULL,
+       data TEXT NOT NULL,
+       msg TEXT NOT NULL,
+       status INTEGER NOT NULL,
+       stamp TIMESTAMP NOT NULL,
+       cstamp TIMESTAMP,
+       FOREIGN KEY (usr) REFERENCES WebUser(id) ON DELETE CASCADE);
+
+CREATE SEQUENCE SignSeq START 1;
+
 CREATE TABLE Quota(
        id INTEGER PRIMARY KEY,
        usr INTEGER NOT NULL,