diff options
| -rw-r--r-- | ChangeLog | 1 | ||||
| -rw-r--r-- | create/mysql/schema.sql | 1 | ||||
| -rw-r--r-- | create/postgresql/schema.sql | 1 | ||||
| -rw-r--r-- | upgrades/dbpatches/1.1beta6_to_1.1beta7/mysql/patch.sql | 1 | ||||
| -rw-r--r-- | upgrades/dbpatches/1.1beta6_to_1.1beta7/postgresql/patch.sql | 1 |
5 files changed, 5 insertions, 0 deletions
@@ -1,5 +1,6 @@ Changes for 1.1beta7: + - added triggers.templateid (Alexei) - fixed navigation bar for Sreens (Eugene) - fixed incorrect groupid error for actions (Eugene) - improved Templates logic (Eugene) diff --git a/create/mysql/schema.sql b/create/mysql/schema.sql index 71b95730..c2b2ddd8 100644 --- a/create/mysql/schema.sql +++ b/create/mysql/schema.sql @@ -414,6 +414,7 @@ CREATE TABLE triggers ( dep_level int(2) DEFAULT '0' NOT NULL, comments blob, error varchar(128) DEFAULT '' NOT NULL, + templateid int(4) DEFAULT '0' NOT NULL, PRIMARY KEY (triggerid), KEY (status), KEY (value) diff --git a/create/postgresql/schema.sql b/create/postgresql/schema.sql index ada6dfff..fdb13f36 100644 --- a/create/postgresql/schema.sql +++ b/create/postgresql/schema.sql @@ -143,6 +143,7 @@ CREATE TABLE triggers ( dep_level int2 DEFAULT '0' NOT NULL, comments text, error varchar(128) DEFAULT '' NOT NULL, + templateid int4 DEFAULT '0' NOT NULL, PRIMARY KEY (triggerid) ); diff --git a/upgrades/dbpatches/1.1beta6_to_1.1beta7/mysql/patch.sql b/upgrades/dbpatches/1.1beta6_to_1.1beta7/mysql/patch.sql index 1c030261..8c1382b4 100644 --- a/upgrades/dbpatches/1.1beta6_to_1.1beta7/mysql/patch.sql +++ b/upgrades/dbpatches/1.1beta6_to_1.1beta7/mysql/patch.sql @@ -1,2 +1,3 @@ alter table hosts add templateid int(4) DEFAULT '0' NOT NULL; alter table items add templateid int(4) DEFAULT '0' NOT NULL; +alter table triggers add templateid int(4) DEFAULT '0' NOT NULL; diff --git a/upgrades/dbpatches/1.1beta6_to_1.1beta7/postgresql/patch.sql b/upgrades/dbpatches/1.1beta6_to_1.1beta7/postgresql/patch.sql index c0efc643..682d2fc2 100644 --- a/upgrades/dbpatches/1.1beta6_to_1.1beta7/postgresql/patch.sql +++ b/upgrades/dbpatches/1.1beta6_to_1.1beta7/postgresql/patch.sql @@ -1,2 +1,3 @@ alter table hosts add templateid int4 DEFAULT '0' NOT NULL; alter table items add templateid int4 DEFAULT '0' NOT NULL; +alter table triggers add templateid int4 DEFAULT '0' NOT NULL; |