diff options
Diffstat (limited to 'create/mysql/schema.sql')
| -rw-r--r-- | create/mysql/schema.sql | 6 |
1 files changed, 4 insertions, 2 deletions
diff --git a/create/mysql/schema.sql b/create/mysql/schema.sql index 3495d259..d775da16 100644 --- a/create/mysql/schema.sql +++ b/create/mysql/schema.sql @@ -156,7 +156,7 @@ CREATE TABLE alarms ( alarmid int(4) NOT NULL auto_increment, triggerid int(4) DEFAULT '0' NOT NULL, clock int(4) DEFAULT '0' NOT NULL, - istrue int(4) DEFAULT '0' NOT NULL, + value int(4) DEFAULT '0' NOT NULL, PRIMARY KEY (alarmid), KEY (triggerid,clock), KEY (clock) @@ -295,7 +295,9 @@ CREATE TABLE triggers ( expression varchar(255) DEFAULT '' NOT NULL, description varchar(255) DEFAULT '' NOT NULL, url varchar(255) DEFAULT '' NOT NULL, - istrue int(4) DEFAULT '0' NOT NULL, +-- istrue int(4) DEFAULT '0' NOT NULL, + status int(4) DEFAULT '0' NOT NULL, + value int(4) DEFAULT '0' NOT NULL, priority int(2) DEFAULT '0' NOT NULL, lastchange int(4) DEFAULT '0' NOT NULL, dep_level int(2) DEFAULT '0' NOT NULL, |