Changeset 850

Timestamp:

03/02/06 14:48:08 (7 years ago)

Author:

olivier

Message:

Correction bug defquotas a l'install et prise en compte dans upgrade

Location:

trunk/install

Files:

• mysql.sql (modified) (1 diff)
• upgrades/0.9.4.sql (modified) (1 diff)

trunk/install/mysql.sql

@@ -304 +304 @@
   quota varchar(128),                           # Nom du quota
   value bigint(20) unsigned default '0',        # Valeur du quota
-  type  varchar(128) default 'default'          # Type de compte associée à ce quota
+  type  varchar(128) default 'default',         # Type de compte associée à ce quota
   PRIMARY KEY (quota,type)
 ) TYPE=MyISAM;

trunk/install/upgrades/0.9.4.sql

@@ -10 +10 @@
 -- We don't use "used" quota anymore.
 ALTER TABLE `quotas` DROP `used`; 
+
+-- Add a primary key to 'defquotas'
+ALTER TABLE `defquotas` ADD UNIQUE (`quota`,`type`);