Changeset 962 for branches/joe-validation-comptes/install/upgrades/0.9.5.sql

Timestamp:

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

Author:

joe

Message:

Renomé les champs conformément aux specs.

File:

• branches/joe-validation-comptes/install/upgrades/0.9.5.sql (modified) (1 diff)

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;