From 69d311a9e667ba071af1070cfe9a6906a4f0ed32 Mon Sep 17 00:00:00 2001 From: =?utf8?q?St=C3=A9phane=20Jacob?= Date: Sat, 14 May 2011 15:35:37 +0200 Subject: [PATCH] I forgot to commit the sql script for last commits. MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit Signed-off-by: Stéphane Jacob --- upgrade/1.1.2/01_groups.sql | 11 +++++++++++ 1 file changed, 11 insertions(+) create mode 100644 upgrade/1.1.2/01_groups.sql diff --git a/upgrade/1.1.2/01_groups.sql b/upgrade/1.1.2/01_groups.sql new file mode 100644 index 0000000..4f999db --- /dev/null +++ b/upgrade/1.1.2/01_groups.sql @@ -0,0 +1,11 @@ +CREATE TABLE group_former_members ( + asso_id SMALLINT(5) UNSIGNED NOT NULL DEFAULT 0, + uid INT(11) UNSIGNED NOT NULL DEFAULT 0, + unsubsciption_date DATE NOT NULL, + PRIMARY KEY (asso_id, uid), + KEY uid (uid), + CONSTRAINT group_former_members_ibfk_1 FOREIGN KEY (uid) REFERENCES accounts (uid) ON DELETE CASCADE ON UPDATE CASCADE, + CONSTRAINT group_former_members_ibfk_2 FOREIGN KEY (asso_id) REFERENCES groups (id) ON DELETE CASCADE ON UPDATE CASCADE +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- vim:set syntax=mysql: -- 2.1.4