summaryrefslogtreecommitdiffstats
path: root/upgrades/dbpatches/1.3/postgresql/patch/items_applications.sql
diff options
context:
space:
mode:
Diffstat (limited to 'upgrades/dbpatches/1.3/postgresql/patch/items_applications.sql')
-rw-r--r--upgrades/dbpatches/1.3/postgresql/patch/items_applications.sql23
1 files changed, 0 insertions, 23 deletions
diff --git a/upgrades/dbpatches/1.3/postgresql/patch/items_applications.sql b/upgrades/dbpatches/1.3/postgresql/patch/items_applications.sql
deleted file mode 100644
index 9c345851..00000000
--- a/upgrades/dbpatches/1.3/postgresql/patch/items_applications.sql
+++ /dev/null
@@ -1,23 +0,0 @@
-CREATE TABLE items_applications_tmp (
- itemappid bigint DEFAULT '0' NOT NULL,
- applicationid bigint DEFAULT '0' NOT NULL,
- itemid bigint DEFAULT '0' NOT NULL,
- PRIMARY KEY (itemappid)
-);
-CREATE INDEX items_applications_1 on items_applications_tmp (applicationid,itemid);
-
-insert into items_applications_tmp select NULL,applicationid,applicationid from items_applications;
-drop table items_applications;
-alter table items_applications_tmp rename to items_applications;
-
-CREATE TABLE items_applications_tmp (
- itemappid bigint DEFAULT '0' NOT NULL,
- applicationid bigint DEFAULT '0' NOT NULL,
- itemid bigint DEFAULT '0' NOT NULL,
- PRIMARY KEY (itemappid)
-);
-CREATE INDEX items_applications_1 on items_applications_tmp (applicationid,itemid);
-
-insert into items_applications_tmp select * from items_applications;
-drop table items_applications;
-alter table items_applications_tmp rename to items_applications;