X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=upgrade%2F0.9.10%2F02_tels.sql;h=4af773bee589ab8f09bdd18ec88fa24d11c47a78;hb=843a2191e4c76f0beb00c754f06974de76791238;hp=80221450cbb3cda01cd2d1fd9ce6282700b310d2;hpb=f42813b72118ff7bc0c6eaaf7c5052fa3544afb1;p=platal.git diff --git a/upgrade/0.9.10/02_tels.sql b/upgrade/0.9.10/02_tels.sql index 8022145..4af773b 100644 --- a/upgrade/0.9.10/02_tels.sql +++ b/upgrade/0.9.10/02_tels.sql @@ -6,8 +6,8 @@ CREATE TABLE `tels` ( `tel_pub` enum('private','ax','public') NOT NULL default 'private', `tel` varchar(30) NOT NULL default '', PRIMARY KEY (`uid`,`adrid`,`telid`) - ) + ); INSERT INTO tels SELECT uid, adrid, 0, 'Tél.', tel_pub, tel FROM adresses; INSERT INTO tels SELECT uid, adrid, 1, 'Fax', tel_pub, fax FROM adresses; DELETE FROM tels WHERE tel = ""; -ALTER TABLE `adresses` DROP `tel`, DROP `tel_pub`; \ No newline at end of file +ALTER TABLE `adresses` DROP `tel`, DROP `tel_pub`;