Commit | Line | Data |
---|---|---|
49056fe2 SJ |
1 | DROP TABLE IF EXISTS group_former_members; |
2 | ||
69d311a9 SJ |
3 | CREATE TABLE group_former_members ( |
4 | asso_id SMALLINT(5) UNSIGNED NOT NULL DEFAULT 0, | |
5 | uid INT(11) UNSIGNED NOT NULL DEFAULT 0, | |
49056fe2 | 6 | remember BOOLEAN NOT NULL DEFAULT FALSE, |
69d311a9 SJ |
7 | unsubsciption_date DATE NOT NULL, |
8 | PRIMARY KEY (asso_id, uid), | |
9 | KEY uid (uid), | |
10 | CONSTRAINT group_former_members_ibfk_1 FOREIGN KEY (uid) REFERENCES accounts (uid) ON DELETE CASCADE ON UPDATE CASCADE, | |
11 | CONSTRAINT group_former_members_ibfk_2 FOREIGN KEY (asso_id) REFERENCES groups (id) ON DELETE CASCADE ON UPDATE CASCADE | |
12 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; | |
13 | ||
14 | -- vim:set syntax=mysql: |