blob: 72029fbc77eb46d89d7ce86cc3bffdbd9782ffd9 (
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)
);
CREATE INDEX mappings_1 on mappings_tmp (valuemapid);
insert into mappings_tmp select * from mappings;
drop table mappings;
alter table mappings_tmp rename mappings;
|
