blob: 1d03e4064b2c3905ef664487c9b0c60ff538739e (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
|
CREATE TABLE triggers_tmp (
triggerid bigint unsigned DEFAULT '0' NOT NULL,
expression varchar(255) DEFAULT '' NOT NULL,
description varchar(255) DEFAULT '' NOT NULL,
url varchar(255) DEFAULT '' NOT NULL,
status integer DEFAULT '0' NOT NULL,
value integer DEFAULT '0' NOT NULL,
priority integer DEFAULT '0' NOT NULL,
lastchange integer DEFAULT '0' NOT NULL,
dep_level integer DEFAULT '0' NOT NULL,
comments blob ,
error varchar(128) DEFAULT '' NOT NULL,
templateid bigint unsigned DEFAULT '0' NOT NULL,
PRIMARY KEY (triggerid)
) ENGINE=InnoDB;
CREATE INDEX triggers_1 on triggers_tmp (status);
CREATE INDEX triggers_2 on triggers_tmp (value);
insert into triggers_tmp select * from triggers;
drop table triggers;
alter table triggers_tmp rename triggers;
|
