diff options
Diffstat (limited to 'upgrades/dbpatches/1.3/postgresql/patch/items_applications.sql')
-rw-r--r-- | upgrades/dbpatches/1.3/postgresql/patch/items_applications.sql | 23 |
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; |