Changeset 2504

Timestamp:

05/23/09 16:30:57 (4 years ago)

Author:

benjamin

Message:

les upgrades utilisent ` au maximum pour pouvoir etre compatible avec de futurs mots-cles de mysql

Location:

alternc/branches/benjamin-bureaubleu/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/branches/benjamin-bureaubleu/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`)
+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)
 ) 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/branches/benjamin-bureaubleu/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/branches/benjamin-bureaubleu/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/branches/benjamin-bureaubleu/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);