1 DROP TABLE IF EXISTS group_former_members
;
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
),
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
;
14 -- vim:set syntax=mysql: