diff options
Diffstat (limited to 'upgrades/dbpatches/1.3/postgresql/patch/applications.sql')
-rw-r--r-- | upgrades/dbpatches/1.3/postgresql/patch/applications.sql | 14 |
1 files changed, 0 insertions, 14 deletions
diff --git a/upgrades/dbpatches/1.3/postgresql/patch/applications.sql b/upgrades/dbpatches/1.3/postgresql/patch/applications.sql deleted file mode 100644 index 13d05bd3..00000000 --- a/upgrades/dbpatches/1.3/postgresql/patch/applications.sql +++ /dev/null @@ -1,14 +0,0 @@ -CREATE TABLE applications_tmp ( - applicationid bigint DEFAULT '0' NOT NULL, - hostid bigint DEFAULT '0' NOT NULL, - name varchar(255) DEFAULT '' NOT NULL, - templateid bigint DEFAULT '0' NOT NULL, - PRIMARY KEY (applicationid) -); - -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 to applications; |