blob: afeb59aca83174ad6fc9cf098e1187ef182a00ef (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
|
CREATE TABLE mappings_tmp (
mappingid bigint unsigned DEFAULT '0' NOT NULL,
valuemapid bigint unsigned DEFAULT '0' NOT NULL,
value varchar(64) DEFAULT '' NOT NULL,
newvalue varchar(64) DEFAULT '' NOT NULL,
PRIMARY KEY (mappingid)
) ENGINE=InnoDB;
CREATE INDEX mappings_1 on mappings_tmp (valuemapid);
insert into mappings_tmp select * from mappings;
drop table mappings;
alter table mappings_tmp rename mappings;
|
