summaryrefslogtreecommitdiffstats
path: root/upgrades
diff options
context:
space:
mode:
authorhugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082>2006-02-14 07:36:43 +0000
committerhugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082>2006-02-14 07:36:43 +0000
commit618331bb4ca20c154b4f7cd7902eb170667535e7 (patch)
treebc5473290b09d97b4cf1ec6fc7b2ff6effa4b954 /upgrades
parent6472e22659b2e8eac37370541181b91b71976c50 (diff)
downloadzabbix-618331bb4ca20c154b4f7cd7902eb170667535e7.tar.gz
zabbix-618331bb4ca20c154b4f7cd7902eb170667535e7.tar.xz
zabbix-618331bb4ca20c154b4f7cd7902eb170667535e7.zip
- added triggers.templateid (Alexei)
git-svn-id: svn://svn.zabbix.com/trunk@2641 97f52cf1-0a1b-0410-bd0e-c28be96e8082
Diffstat (limited to 'upgrades')
-rw-r--r--upgrades/dbpatches/1.1beta6_to_1.1beta7/mysql/patch.sql1
-rw-r--r--upgrades/dbpatches/1.1beta6_to_1.1beta7/postgresql/patch.sql1
2 files changed, 2 insertions, 0 deletions
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;