upgrade/1.1.2/01_groups.sql

   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: