summaryrefslogtreecommitdiffstats
path: root/upgrades/dbpatches/1.3/mysql/patch/applications.sql
diff options
context:
space:
mode:
Diffstat (limited to 'upgrades/dbpatches/1.3/mysql/patch/applications.sql')
-rw-r--r--upgrades/dbpatches/1.3/mysql/patch/applications.sql12
1 files changed, 6 insertions, 6 deletions
diff --git a/upgrades/dbpatches/1.3/mysql/patch/applications.sql b/upgrades/dbpatches/1.3/mysql/patch/applications.sql
index 9b18bfb7..97ff0845 100644
--- a/upgrades/dbpatches/1.3/mysql/patch/applications.sql
+++ b/upgrades/dbpatches/1.3/mysql/patch/applications.sql
@@ -1,10 +1,10 @@
CREATE TABLE applications_tmp (
- applicationid bigint unsigned NOT NULL auto_increment,
- 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 ;
+ 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);