From 2f594bef2f7f5a5b75da2b78007c6db445e410da Mon Sep 17 00:00:00 2001 From: =?utf8?q?St=C3=A9phane=20Jacob?= Date: Wed, 8 Dec 2010 10:07:13 +0100 Subject: [PATCH] Fixes notification about phones. MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit Signed-off-by: Stéphane Jacob --- upgrade/1.0.2/03_phones.sql | 9 +++++++++ 1 file changed, 9 insertions(+) create mode 100644 upgrade/1.0.2/03_phones.sql diff --git a/upgrade/1.0.2/03_phones.sql b/upgrade/1.0.2/03_phones.sql new file mode 100644 index 0000000..3f48a67 --- /dev/null +++ b/upgrade/1.0.2/03_phones.sql @@ -0,0 +1,9 @@ +ALTER TABLE watch_profile MODIFY COLUMN field ENUM('search_names','freetext','mobile','nationality1','nationality2','nationality3','nick','networking','edus','addresses','section','binets','medals','cv','jobs','photo','corps','tels') NOT NULL DEFAULT 'search_names'; + +UPDATE watch_profile + SET field = 'tels' + WHERE field = 'mobile'; + +ALTER TABLE watch_profile MODIFY COLUMN field ENUM('search_names','freetext','nationality1','nationality2','nationality3','nick','networking','edus','addresses','section','binets','medals','cv','jobs','photo','corps','tels') NOT NULL DEFAULT 'search_names'; + +-- vim:set syntax=mysql: -- 2.1.4