2 id INTEGER PRIMARY KEY,
6 CREATE SEQUENCE BalanceSeq
START 1;
9 (id, name, amount
) VALUES
13 id INTEGER PRIMARY KEY,
17 joined
TIMESTAMP NOT NULL,
18 FOREIGN KEY (bal
) REFERENCES Balance(id) ON DELETE CASCADE);
20 CREATE SEQUENCE WebUserSeq
START 1;
23 (id, name, bal
) VALUES
26 CREATE TABLE WebGroup(
27 id INTEGER PRIMARY KEY,
30 CREATE SEQUENCE WebGroupSeq
START 4;
36 CREATE TABLE Membership(
39 PRIMARY KEY (grp
, usr
),
40 FOREIGN KEY (grp
) REFERENCES WebGroup(id) ON DELETE CASCADE,
41 FOREIGN KEY (usr
) REFERENCES WebUser(id) ON DELETE CASCADE);
43 INSERT INTO Membership
47 CREATE TABLE Transaction(
48 id INTEGER PRIMARY KEY,
52 stamp
TIMESTAMP NOT NULL);
54 CREATE SEQUENCE TransactionSeq
START 1;
60 PRIMARY KEY (trn
, usr
),
61 FOREIGN KEY (trn
) REFERENCES Transaction(id) ON DELETE CASCADE,
62 FOREIGN KEY (usr
) REFERENCES WebUser(id) ON DELETE CASCADE);
65 id INTEGER PRIMARY KEY,
71 votes
INTEGER NOT NULL,
72 FOREIGN KEY (usr
) REFERENCES WebUser(id) ON DELETE CASCADE);
74 CREATE SEQUENCE PollSeq
START 1;
76 CREATE TABLE PollChoice(
77 id INTEGER PRIMARY KEY,
81 FOREIGN KEY (pol
) REFERENCES Poll(id) ON DELETE CASCADE);
83 CREATE SEQUENCE PollChoiceSeq
START 1;
88 PRIMARY KEY (usr
, cho
),
89 FOREIGN KEY (usr
) REFERENCES WebUser(id) ON DELETE CASCADE,
90 FOREIGN KEY (cho
) REFERENCES PollChoice(id) ON DELETE CASCADE);
92 CREATE TABLE ContactKind(
93 id INTEGER PRIMARY KEY,
99 CREATE SEQUENCE ContactKindSeq
START 1;
101 CREATE TABLE Contact(
102 id INTEGER PRIMARY KEY,
103 usr
INTEGER NOT NULL,
104 knd
INTEGER NOT NULL,
106 priv
INTEGER NOT NULL,
107 FOREIGN KEY (usr
) REFERENCES WebUser(id) ON DELETE CASCADE,
108 FOREIGN KEY (knd
) REFERENCES ContactKind(id) ON DELETE CASCADE);
110 CREATE SEQUENCE ContactSeq
START 1;
112 CREATE TABLE Location(
113 id INTEGER PRIMARY KEY,
116 FOREIGN KEY (parent
) REFERENCES Location(id) ON DELETE CASCADE);
118 CREATE SEQUENCE LocationSeq
START 1;
121 usr
INTEGER NOT NULL,
122 loc
INTEGER NOT NULL,
123 PRIMARY KEY (usr
, loc
),
124 FOREIGN KEY (usr
) REFERENCES WebUser(id) ON DELETE CASCADE,
125 FOREIGN KEY (loc
) REFERENCES Location(id) ON DELETE CASCADE);
128 id INTEGER PRIMARY KEY,
129 usr
INTEGER NOT NULL,
133 FOREIGN KEY (usr
) REFERENCES WebUser(id) ON DELETE CASCADE);
135 CREATE SEQUENCE LinkSeq
START 1;