blob: add46772f785917a79b6c697b6580b97426a251b (
plain)
1
2
3
4
5
6
7
8
9
10
|
CREATE TABLE history_str_tmp (
itemid bigint unsigned DEFAULT '0' NOT NULL,
clock integer DEFAULT '0' NOT NULL,
value varchar(255) DEFAULT '' NOT NULL
) ENGINE=InnoDB;
CREATE INDEX history_str_1 on history_str_tmp (itemid,clock);
insert into history_str_tmp select * from history_str;
drop table history_str;
alter table history_str_tmp rename history_str;
|