facilite l'upgrade

[platal.git] / upgrade / 0.9.10 / 02_tels.sql

diff --git a/upgrade/0.9.10/02_tels.sql b/upgrade/0.9.10/02_tels.sql
index 6314401..8022145 100644 (file)
--- a/upgrade/0.9.10/02_tels.sql
+++ b/upgrade/0.9.10/02_tels.sql
@@ -10,3 +10,4 @@ CREATE TABLE `tels` (
 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