diff options
Diffstat (limited to 'upgrades/dbpatches/1.4/postgresql/patch')
-rw-r--r-- | upgrades/dbpatches/1.4/postgresql/patch/autoreg.sql | 10 |
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; |