summaryrefslogtreecommitdiffstats
path: root/upgrades/dbpatches/1.3/postgresql/patch/applications.sql
diff options
context:
space:
mode:
Diffstat (limited to 'upgrades/dbpatches/1.3/postgresql/patch/applications.sql')
-rw-r--r--upgrades/dbpatches/1.3/postgresql/patch/applications.sql10
1 files changed, 5 insertions, 5 deletions
diff --git a/upgrades/dbpatches/1.3/postgresql/patch/applications.sql b/upgrades/dbpatches/1.3/postgresql/patch/applications.sql
index 97ff0845..13d05bd3 100644
--- a/upgrades/dbpatches/1.3/postgresql/patch/applications.sql
+++ b/upgrades/dbpatches/1.3/postgresql/patch/applications.sql
@@ -1,14 +1,14 @@
CREATE TABLE applications_tmp (
- applicationid bigint unsigned DEFAULT '0' NOT NULL,
- hostid bigint unsigned DEFAULT '0' NOT NULL,
+ applicationid bigint DEFAULT '0' NOT NULL,
+ hostid bigint DEFAULT '0' NOT NULL,
name varchar(255) DEFAULT '' NOT NULL,
- templateid bigint unsigned DEFAULT '0' NOT NULL,
+ templateid bigint DEFAULT '0' NOT NULL,
PRIMARY KEY (applicationid)
-) ENGINE=InnoDB;
+);
CREATE INDEX applications_1 on applications_tmp (templateid);
CREATE UNIQUE INDEX applications_2 on applications_tmp (hostid,name);
insert into applications_tmp select * from applications;
drop table applications;
-alter table applications_tmp rename applications;
+alter table applications_tmp rename to applications;