blob: e4b02eaa05d6a0f9e35c5e66f4923e9e13a1e376 (
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)
) with OIDS;
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;
|
