Changeset 962

Timestamp:

04/02/06 05:07:50 (7 years ago)

Author:

joe

Message:

Renomé les champs conformément aux specs.

Location:

branches/joe-validation-comptes/install

Files:

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

branches/joe-validation-comptes/install/mysql.sql

@@ -225 +225 @@
   type varchar(128) default 'default',
   created datetime default NULL, 
-  valid_until datetime default NULL, 
-  last_renew datetime default NULL, 
+  renewed datetime default NULL, 
+  duration int(4) default NULL,
   PRIMARY KEY  (uid),
   UNIQUE KEY k_login (login)

branches/joe-validation-comptes/install/upgrades/0.9.5.sql

@@ -1 +1 @@
 -- Pour les durées de comptes
 ALTER TABLE MEMBRES ADD COLUMN created datetime default NULL AFTER type;
-ALTER TABLE MEMBRES ADD COLUMN valid_until datetime default NULL AFTER created;
-ALTER TABLE MEMBRES ADD COLUMN last_renew datetime default NULL AFTER valid_until;
+ALTER TABLE MEMBRES ADD COLUMN renewed datetime default NULL AFTER created;
+ALTER TABLE MEMBRES ADD COLUMN duration int(4) default NULL AFTER renewed;