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, 0 insertions, 13 deletions
diff --git a/upgrades/dbpatches/1.3/postgresql/patch/config.sql b/upgrades/dbpatches/1.3/postgresql/patch/config.sql deleted file mode 100644 index b7f9e2a6..00000000 --- a/upgrades/dbpatches/1.3/postgresql/patch/config.sql +++ /dev/null @@ -1,13 +0,0 @@ -CREATE TABLE config_tmp ( - configid bigint 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 DEFAULT '0' NOT NULL, - PRIMARY KEY (configid) -); - -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 to config; |