blob: 9febba47b1691102108ac8cb033656eebee04313 (
plain)
1
2
3
4
5
6
7
8
9
10
|
CREATE TABLE valuemaps_tmp (
valuemapid bigint unsigned DEFAULT '0' NOT NULL,
name varchar(64) DEFAULT '' NOT NULL,
PRIMARY KEY (valuemapid)
) ENGINE=InnoDB;
CREATE INDEX valuemaps_1 on valuemaps_tmp (name);
insert into valuemaps_tmp select * from valuemaps;
drop table valuemaps;
alter table valuemaps_tmp rename valuemaps;
|
