blob: b357e8e82f4b97850da3a8a463aa09ad9d7bea4a (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
|
CREATE TABLE sysmaps_tmp (
sysmapid bigint unsigned DEFAULT '0' NOT NULL,
name varchar(128) DEFAULT '' NOT NULL,
width integer DEFAULT '0' NOT NULL,
height integer DEFAULT '0' NOT NULL,
backgroundid bigint unsigned DEFAULT '0' NOT NULL,
label_type integer DEFAULT '0' NOT NULL,
label_location integer DEFAULT '0' NOT NULL,
PRIMARY KEY (sysmapid)
) ENGINE=InnoDB;
CREATE INDEX sysmaps_1 on sysmaps_tmp (name);
insert into sysmaps_tmp select * from sysmaps;
drop table sysmaps;
alter table sysmaps_tmp rename sysmaps;
|
