diff options
| author | artem <artem@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2007-12-03 09:14:49 +0000 |
|---|---|---|
| committer | artem <artem@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2007-12-03 09:14:49 +0000 |
| commit | bde9b2e7b9eb5c5d18e89de32ae3033d2cc415d8 (patch) | |
| tree | 692baf5e75aa1b9409470a5bdb443c68fb1812b4 /create/schema | |
| parent | 7a9fe385773913d7feeb9cd60a19467f4526345b (diff) | |
| download | zabbix-bde9b2e7b9eb5c5d18e89de32ae3033d2cc415d8.tar.gz zabbix-bde9b2e7b9eb5c5d18e89de32ae3033d2cc415d8.tar.xz zabbix-bde9b2e7b9eb5c5d18e89de32ae3033d2cc415d8.zip | |
- [DEV-52] changes in schema.sql (Artem)
git-svn-id: svn://svn.zabbix.com/trunk@5127 97f52cf1-0a1b-0410-bd0e-c28be96e8082
Diffstat (limited to 'create/schema')
| -rw-r--r-- | create/schema/schema.sql | 12 |
1 files changed, 8 insertions, 4 deletions
diff --git a/create/schema/schema.sql b/create/schema/schema.sql index b6b02eb1..03c2a533 100644 --- a/create/schema/schema.sql +++ b/create/schema/schema.sql @@ -582,11 +582,15 @@ FIELD |linkid |t_id |'0' |NOT NULL |0 FIELD |sysmapid |t_id |'0' |NOT NULL |ZBX_SYNC FIELD |selementid1 |t_id |'0' |NOT NULL |ZBX_SYNC FIELD |selementid2 |t_id |'0' |NOT NULL |ZBX_SYNC +FIELD |drawtype |t_integer |'0' |NOT NULL |ZBX_SYNC +FIELD |color |t_varchar(32) |'Black'|NOT NULL |ZBX_SYNC + +TABLE|sysmaps_link_triggers|linkid|ZBX_SYNC +FIELD |linkid |t_id |'0' |NOT NULL |ZBX_SYNC FIELD |triggerid |t_id | | |ZBX_SYNC -FIELD |drawtype_off |t_integer |'0' |NOT NULL |ZBX_SYNC -FIELD |color_off |t_varchar(32) |'Black'|NOT NULL |ZBX_SYNC -FIELD |drawtype_on |t_integer |'0' |NOT NULL |ZBX_SYNC -FIELD |color_on |t_varchar(32) |'Red' |NOT NULL |ZBX_SYNC +FIELD |drawtype |t_integer |'0' |NOT NULL |ZBX_SYNC +FIELD |color |t_varchar(32) |'Black'|NOT NULL |ZBX_SYNC +INDEX |1 |linkid TABLE|sysmaps_elements|selementid|ZBX_SYNC FIELD |selementid |t_id |'0' |NOT NULL |0 |