blob: d6d37fc1b3f85b2dc71146741eeeb6f82423d419 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
|
CREATE TABLE items_applications_tmp (
itemappid bigint unsigned NOT NULL auto_increment,
applicationid bigint unsigned DEFAULT '0' NOT NULL,
itemid bigint unsigned DEFAULT '0' NOT NULL,
PRIMARY KEY (itemappid)
) ENGINE=InnoDB;
CREATE INDEX items_applications_1 on items_applications_tmp (applicationid,itemid);
insert into items_applications_tmp select NULL,applicationid,itemid from items_applications;
drop table items_applications;
alter table items_applications_tmp rename items_applications;
CREATE TABLE items_applications_tmp (
itemappid bigint unsigned DEFAULT '0' NOT NULL,
applicationid bigint unsigned DEFAULT '0' NOT NULL,
itemid bigint unsigned DEFAULT '0' NOT NULL,
PRIMARY KEY (itemappid)
) ENGINE=InnoDB;
CREATE INDEX items_applications_1 on items_applications_tmp (applicationid,itemid);
CREATE INDEX items_applications_2 on items_applications_tmp (itemid);
insert into items_applications_tmp select * from items_applications;
drop table items_applications;
alter table items_applications_tmp rename items_applications;
|
