Changeset 500 for install/scripts/upgrades/0.9.3.sql

Timestamp:

02/22/06 00:24:23 (7 years ago)

Author:

anarcat

Message:

[project @ alternc: changeset 2005-01-18 23:20:00 by anarcat]
put a request before the 'use mysql' so that it uses the right DB

Original author: anarcat
Date: 2005-01-18 23:20:00

File:

• install/scripts/upgrades/0.9.3.sql (modified) (2 diffs)

install/scripts/upgrades/0.9.3.sql

@@ -2 +2 @@
 INSERT IGNORE INTO tld VALUES ('it', 1);
 INSERT IGNORE INTO tld VALUES ('ws', 1);
+
+-- remove the old "estelle" default mx in older tables
+ALTER TABLE `domaines` MODIFY `mx` varchar(64) DEFAULT NULL;
+ALTER TABLE `domaines_standby` MODIFY `mx` varchar(64) DEFAULT NULL;
 
 -- add the new variable table
@@ -25 +29 @@
 -- make sure this has an effect at all.
 FLUSH PRIVILEGES;
-
--- remove the old "estelle" default mx in older tables
-ALTER TABLE `domaines` MODIFY `mx` varchar(64) DEFAULT NULL;
-ALTER TABLE `domaines_standby` MODIFY `mx` varchar(64) DEFAULT NULL;