| 1 | DROP TABLE IF EXISTS group_former_members; |
| 2 | |
| 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, |
| 6 | remember BOOLEAN NOT NULL DEFAULT FALSE, |
| 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: |