blob: 0817aec5c508f44f0f4b9d6b8a23d43c03a879f8 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
|
CREATE TABLE functions_tmp (
functionid bigint unsigned DEFAULT '0' NOT NULL,
itemid bigint unsigned DEFAULT '0' NOT NULL,
triggerid bigint unsigned DEFAULT '0' NOT NULL,
lastvalue varchar(255) ,
function varchar(12) DEFAULT '' NOT NULL,
parameter varchar(255) DEFAULT '0' NOT NULL,
PRIMARY KEY (functionid)
);
CREATE INDEX functions_1 on functions_tmp (triggerid);
CREATE INDEX functions_2 on functions_tmp (itemid,function,parameter);
insert into functions_tmp select * from functions;
drop table functions;
alter table functions_tmp rename functions;
|