blob: 8c3d013d440aec6a9dbad8096e4d9b6db33f73e1 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
|
CREATE TABLE mappings_tmp (
mappingid bigint DEFAULT '0' NOT NULL,
valuemapid bigint 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 to mappings;
|
