HCoop
/
hcoop
/
zz_old
/
portal.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
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');
(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,
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);
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;
+