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