Group membership change requests

[bpt/portal.git] / tables.sql

diff --git a/tables.sql b/tables.sql
index 555d81b..97a890c 100644 (file)
--- a/tables.sql
+++ b/tables.sql
@@ -271,3 +271,14 @@ CREATE TABLE RollCallEntry(
        PRIMARY KEY (rol, usr),
        FOREIGN KEY (rol) REFERENCES RollCall(id) ON DELETE CASCADE,
        FOREIGN KEY (usr) REFERENCES WebUser(id) ON DELETE CASCADE);
+
+CREATE TABLE Sec(
+       id INTEGER PRIMARY KEY,
+       usr INTEGER NOT NULL,
+       data TEXT NOT NULL,
+       msg TEXT NOT NULL,
+       status INTEGER NOT NULL,
+       stamp TIMESTAMP NOT NULL,
+       FOREIGN KEY (usr) REFERENCES WebUser(id) ON DELETE CASCADE);
+
+CREATE SEQUENCE SecSeq START 1;