blob: dad2810f6a87f7f42bc04195690c64883244dd23 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
|
CREATE TABLE history_text_tmp (
id bigint DEFAULT '0' NOT NULL,
itemid bigint DEFAULT '0' NOT NULL,
clock integer DEFAULT '0' NOT NULL,
value text DEFAULT '' NOT NULL,
PRIMARY KEY (id)
) with OIDS;
CREATE INDEX history_text_1 on history_text_tmp (itemid,clock);
insert into history_text_tmp select * from history_text;
drop table history_text;
alter table history_text_tmp rename to history_text;
|
