blob: fa1b332317fd1ba8cf8efbe8c7ebd127d7003200 (
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 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 text ,
error varchar(128) DEFAULT '' NOT NULL,
templateid bigint DEFAULT '0' NOT NULL,
PRIMARY KEY (triggerid)
) with OIDS;
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 to triggers;
|
