diff options
Diffstat (limited to 'upgrades/dbpatches/1.3/postgresql/patch/config.sql')
| -rw-r--r-- | upgrades/dbpatches/1.3/postgresql/patch/config.sql | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/upgrades/dbpatches/1.3/postgresql/patch/config.sql b/upgrades/dbpatches/1.3/postgresql/patch/config.sql new file mode 100644 index 00000000..6f88f069 --- /dev/null +++ b/upgrades/dbpatches/1.3/postgresql/patch/config.sql @@ -0,0 +1,13 @@ +CREATE TABLE config_tmp ( + configid bigint unsigned DEFAULT '0' NOT NULL, + alert_history integer DEFAULT '0' NOT NULL, + event_history integer DEFAULT '0' NOT NULL, + refresh_unsupported integer DEFAULT '0' NOT NULL, + work_period varchar(100) DEFAULT '1-5,00:00-24:00' NOT NULL, + alert_usrgrpid bigint unsigned DEFAULT '0' NOT NULL, + PRIMARY KEY (configid) +) ENGINE=InnoDB; + +insert into config_tmp select 1,alert_history,alarm_history,refresh_unsupported,work_period,0 from config; +drop table config; +alter table config_tmp rename config; |