1 files changed, 14 insertions, 0 deletions
diff --git a/upgrades/dbpatches/1.3/postgresql/patch/applications.sql b/upgrades/dbpatches/1.3/postgresql/patch/applications.sql
new file mode 100644
index 00000000..97ff0845
--- /dev/null
+++ b/upgrades/dbpatches/1.3/postgresql/patch/applications.sql
@@ -0,0 +1,14 @@
+CREATE TABLE applications_tmp (
+        applicationid           bigint unsigned         DEFAULT '0'     NOT NULL,
+        hostid          bigint unsigned         DEFAULT '0'     NOT NULL,
+        name            varchar(255)            DEFAULT ''      NOT NULL,
+        templateid              bigint unsigned         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;