From 0f1c7d721abf23e57361459ce366f11acf86e437 Mon Sep 17 00:00:00 2001 From: Thomas Minvielle Date: Mon, 3 Mar 2014 16:50:36 +0100 Subject: [PATCH] Add profile_manageurs table to prepare the implementation Manageurs prefs. --- upgrade/1.1.12/07_create_profile_manageurs.sql | 14 ++++++++++++++ 1 file changed, 14 insertions(+) create mode 100644 upgrade/1.1.12/07_create_profile_manageurs.sql diff --git a/upgrade/1.1.12/07_create_profile_manageurs.sql b/upgrade/1.1.12/07_create_profile_manageurs.sql new file mode 100644 index 0000000..894995c --- /dev/null +++ b/upgrade/1.1.12/07_create_profile_manageurs.sql @@ -0,0 +1,14 @@ +CREATE TABLE profile_manageurs ( + pid INT(11) UNSIGNED NOT NULL DEFAULT 0, + title VARCHAR(255) NOT NULL DEFAULT '', + entry_year INT(4) NULL DEFAULT NULL, + project MEDIUMTEXT NULL DEFAULT NULL, + anonymity INT(1) UNSIGNED NOT NULL DEFAULT 0, + visibility ENUM('visible', 'visible_exceptions', 'blocked') NOT NULL DEFAULT 'blocked', + communication SET('novelties', 'nl', 'survey') NOT NULL DEFAULT '', + push ENUM('unique', 'weekly', 'never') NOT NULL DEFAULT 'never', + email VARCHAR(255) NOT NULL DEFAULT '', + network INT(1) UNSIGNED NOT NULL DEFAULT 0, + PRIMARY KEY (pid), + CONSTRAINT FOREIGN KEY (pid) REFERENCES profiles (pid) ON DELETE CASCADE ON UPDATE CASCADE +) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- 2.1.4