Changeset 2821 for alternc/trunk/install/upgrades/1.0.sql

Timestamp:

01/29/11 18:58:19 (2 years ago)

Author:

fufroma

Message:

Update domains, l'aventure continue

File:

• alternc/trunk/install/upgrades/1.0.sql (modified) (1 diff)

alternc/trunk/install/upgrades/1.0.sql

@@ -35 +35 @@
 alter table domaines add column dns_action enum ('OK','UPDATE','DELETE') NOT NULL default 'UPDATE';
 alter table domaines add column dns_result varchar(255) not null default '';
-alter table sub_domaines add column web_action enum ('OK','UPDATE','ENABLE','DISABLE','DELETE') NOT NULL default 'UPDATE';
-alter table sub add column dns_result varchar(255) not null default '';
+alter table sub_domaines add column web_action enum ('OK','UPDATE','DELETE') NOT NULL default 'UPDATE';
+alter table sub_domaines add column dns_result varchar(255) not null default '';
+alter table sub_domaines add column enable enum ('ENABLED', 'ENABLE', 'DISABLED', 'DISABLE') NOT NULL DEFAULT 'ENABLED';
 drop table sub_domaines_standby;
 drop table domaines_standby;