Hosted site link database

[hcoop/zz_old/portal.git] / tables.sql

diff --git a/tables.sql b/tables.sql
index 1ffc2a4..b4996bb 100644 (file)
--- a/tables.sql
+++ b/tables.sql
@@ -33,18 +33,6 @@ INSERT INTO WebGroup
        (id, name) VALUES
        (0, 'root');
 
-INSERT INTO WebGroup
-       (id, name) VALUES
-       (1, 'money');
-
-INSERT INTO WebGroup
-       (id, name) VALUES
-       (2, 'paying');
-
-INSERT INTO WebGroup
-       (id, name) VALUES
-       (3, 'poll');
-
 CREATE TABLE Membership(
        grp INTEGER NOT NULL,
        usr INTEGER NOT NULL,
@@ -135,3 +123,14 @@ CREATE TABLE Lives(
        PRIMARY KEY (usr, loc),
        FOREIGN KEY (usr) REFERENCES WebUser(id) ON DELETE CASCADE,
        FOREIGN KEY (loc) REFERENCES Location(id) ON DELETE CASCADE);
+
+CREATE TABLE Link(
+       id INTEGER PRIMARY KEY,
+       usr INTEGER NOT NULL,
+       title TEXT NOT NULL,
+       url TEXT NOT NULL,
+       descr TEXT NOT NULL,
+       FOREIGN KEY (usr) REFERENCES WebUser(id) ON DELETE CASCADE);
+
+CREATE SEQUENCE LinkSeq START 1;
+