Changeset 2502 for alternc/trunk

Timestamp:

04/22/09 20:50:55 (4 years ago)

Author:

benjamin

Message:

add ` everywhere on sql upgrades scripts

Location:

alternc/trunk/install/upgrades

Files:

• 0.9.3.sql (modified) (2 diffs)
• 0.9.4.sql (modified) (1 diff)
• 0.9.5.sql (modified) (1 diff)
• 0.9.6.sql (modified) (1 diff)

alternc/trunk/install/upgrades/0.9.3.sql

@@ -1 +1 @@
 -- add support for .it
-INSERT IGNORE INTO tld VALUES ('it', 1);
-INSERT IGNORE INTO tld VALUES ('ws', 1);
+INSERT IGNORE INTO `tld` VALUES ('it', 1);
+INSERT IGNORE INTO `tld` VALUES ('ws', 1);
 
 -- remove the old "estelle" default mx in older tables
@@ -11 +11 @@
 -- if comment is null, then the variable is internal and will not show
 -- up in the generic configuration panel
-CREATE TABLE IF NOT EXISTS variable (
-  name varchar(48) NOT NULL default '',
-  value longtext NOT NULL,
-  comment mediumtext NULL,
-  PRIMARY KEY  (name),
-  KEY name (name)
+CREATE TABLE IF NOT EXISTS `variable` (
+  `name` varchar(48) NOT NULL default '',
+  `value` longtext NOT NULL,
+  `comment` mediumtext NULL,
+  PRIMARY KEY  (`name`)
 ) TYPE=MyISAM;
 
 -- hosting_tld: only used, for now, in bureau/admin/adm_*add.php
-INSERT IGNORE INTO `variable` (name, value, comment) VALUES ('hosting_tld', 0,
+INSERT IGNORE INTO `variable` (`name`, `value`, `comment`) VALUES ('hosting_tld', 0,
 'This is a FQDN that designates the main hostname of the service.
 

alternc/trunk/install/upgrades/0.9.4.sql

@@ -1 +1 @@
 -- Ajout du champ 'type' pour les membres
-ALTER TABLE membres ADD COLUMN type varchar(128) default 'default' AFTER admlist;
+ALTER TABLE `membres` ADD COLUMN `type` varchar(128) default 'default' AFTER `admlist`;
 
 -- Ajout du champ 'type' pour les quotas par défaut
-ALTER TABLE defquotas ADD COLUMN type varchar(128) default 'default' AFTER value;
+ALTER TABLE `defquotas` ADD COLUMN `type` varchar(128) default 'default' AFTER `value`;
 
 -- we don't store cleartext passwords anymore, we use saslauthd

alternc/trunk/install/upgrades/0.9.5.sql

@@ -1 +1 @@
 -- Pour les durées de comptes
-ALTER IGNORE TABLE membres ADD COLUMN created datetime default NULL AFTER type;
-ALTER IGNORE TABLE membres ADD COLUMN renewed datetime default NULL AFTER created;
-ALTER IGNORE TABLE membres ADD COLUMN duration int(4) default NULL AFTER renewed;
+ALTER IGNORE TABLE `membres` ADD COLUMN `created` datetime default NULL AFTER `type`;
+ALTER IGNORE TABLE `membres` ADD COLUMN `renewed` datetime default NULL AFTER `created`;
+ALTER IGNORE TABLE `membres` ADD COLUMN `duration` int(4) default NULL AFTER `renewed`;
 
 -- Pour l'encryptage des mots de passe ftp
-ALTER IGNORE TABLE ftpusers ADD COLUMN encrypted_password VARCHAR(32) default NULL AFTER password;
-UPDATE ftpusers SET encrypted_password=ENCRYPT(password) WHERE password!='';
+ALTER IGNORE TABLE `ftpusers` ADD COLUMN `encrypted_password` VARCHAR(32) default NULL AFTER `password`;
+UPDATE `ftpusers` SET `encrypted_password`=ENCRYPT(`password`) WHERE `password`!='';
 
 -- --------------------------------------------------------

alternc/trunk/install/upgrades/0.9.6.sql

@@ -7 +7 @@
 
 # On met les quota par defaut du nombre d'utilisateurs mysql
-INSERT IGNORE INTO defquotas (quota,value) VALUES ('mysql_users',1);
+INSERT IGNORE INTO defquotas (`quota`,`value`) VALUES ('mysql_users',1);