summaryrefslogtreecommitdiffstats
path: root/upgrades/dbpatches/1.4/postgresql/patch
diff options
context:
space:
mode:
Diffstat (limited to 'upgrades/dbpatches/1.4/postgresql/patch')
-rw-r--r--upgrades/dbpatches/1.4/postgresql/patch/autoreg.sql10
1 files changed, 0 insertions, 10 deletions
diff --git a/upgrades/dbpatches/1.4/postgresql/patch/autoreg.sql b/upgrades/dbpatches/1.4/postgresql/patch/autoreg.sql
index 5ef888dd..115c591c 100644
--- a/upgrades/dbpatches/1.4/postgresql/patch/autoreg.sql
+++ b/upgrades/dbpatches/1.4/postgresql/patch/autoreg.sql
@@ -1,11 +1 @@
-CREATE TABLE autoreg_tmp (
- id bigint DEFAULT '0' NOT NULL,
- priority integer DEFAULT '0' NOT NULL,
- pattern varchar(255) DEFAULT '' NOT NULL,
- hostid bigint DEFAULT '0' NOT NULL,
- PRIMARY KEY (id)
-);
-
-insert into autoreg_tmp select * from autoreg;
drop table autoreg;
-alter table autoreg_tmp rename to autoreg;