summaryrefslogtreecommitdiffstats
path: root/create/schema
diff options
context:
space:
mode:
authorsasha <sasha@97f52cf1-0a1b-0410-bd0e-c28be96e8082>2008-04-28 14:07:11 +0000
committersasha <sasha@97f52cf1-0a1b-0410-bd0e-c28be96e8082>2008-04-28 14:07:11 +0000
commit787911115963265dd4a9c8cae9178c4868c57e55 (patch)
tree355a02048d6a92659aa8b087a7c0b5bf34f5a3d7 /create/schema
parent87785a8fbcd71409cca2413cdefb7d8ffe686e82 (diff)
downloadzabbix-787911115963265dd4a9c8cae9178c4868c57e55.tar.gz
zabbix-787911115963265dd4a9c8cae9178c4868c57e55.tar.xz
zabbix-787911115963265dd4a9c8cae9178c4868c57e55.zip
- [DEV-166] DM - Problem with node syncing
git-svn-id: svn://svn.zabbix.com/trunk@5663 97f52cf1-0a1b-0410-bd0e-c28be96e8082
Diffstat (limited to 'create/schema')
-rw-r--r--create/schema/schema.sql7
1 files changed, 4 insertions, 3 deletions
diff --git a/create/schema/schema.sql b/create/schema/schema.sql
index afd8f952..6d270b17 100644
--- a/create/schema/schema.sql
+++ b/create/schema/schema.sql
@@ -627,12 +627,13 @@ FIELD |selementid2 |t_id |'0' |NOT NULL |ZBX_SYNC
FIELD |drawtype |t_integer |'0' |NOT NULL |ZBX_SYNC
FIELD |color |t_varchar(6) |'000000'|NOT NULL |ZBX_SYNC
-TABLE|sysmaps_link_triggers|linkid,triggerid|ZBX_SYNC
+TABLE|sysmaps_link_triggers|linktriggerid|ZBX_SYNC
+FIELD |linktriggerid |t_id |'0' |NOT NULL |0
FIELD |linkid |t_id |'0' |NOT NULL |ZBX_SYNC
-FIELD |triggerid |t_id | | |ZBX_SYNC
+FIELD |triggerid |t_id |'0' |NOT NULL |ZBX_SYNC
FIELD |drawtype |t_integer |'0' |NOT NULL |ZBX_SYNC
FIELD |color |t_varchar(6) |'000000'|NOT NULL |ZBX_SYNC
-INDEX |1 |linkid
+UNIQUE |1 |linkid,triggerid
TABLE|sysmaps_elements|selementid|ZBX_SYNC
FIELD |selementid |t_id |'0' |NOT NULL |0