upgrade/1.1.2/01_groups.sql

   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: