diff options
| author | alex <alex@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2007-03-16 08:46:44 +0000 |
|---|---|---|
| committer | alex <alex@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2007-03-16 08:46:44 +0000 |
| commit | 7aa815c71fb9382e11d5886e91fa36dfae80339d (patch) | |
| tree | 9d2649b2d2514bb2edaf8443b9c99860818d11ff /create/schema | |
| parent | 1f5a4a142c53921b74238aa93934be448be5e36f (diff) | |
| download | zabbix-7aa815c71fb9382e11d5886e91fa36dfae80339d.tar.gz zabbix-7aa815c71fb9382e11d5886e91fa36dfae80339d.tar.xz zabbix-7aa815c71fb9382e11d5886e91fa36dfae80339d.zip | |
- added events.source (Alexei)
- renamed events.triggerid -> events.sourceid (Alexei)
git-svn-id: svn://svn.zabbix.com/trunk@3891 97f52cf1-0a1b-0410-bd0e-c28be96e8082
Diffstat (limited to 'create/schema')
| -rw-r--r-- | create/schema/schema.sql | 5 |
1 files changed, 3 insertions, 2 deletions
diff --git a/create/schema/schema.sql b/create/schema/schema.sql index 29a62cf4..1aa6306f 100644 --- a/create/schema/schema.sql +++ b/create/schema/schema.sql @@ -201,11 +201,12 @@ INDEX |6 |userid TABLE|events|eventid|0 FIELD |eventid |t_id |'0' |NOT NULL |ZBX_SYNC -FIELD |triggerid |t_id |'0' |NOT NULL |ZBX_SYNC +FIELD |source |t_integer |'0' |NOT NULL |ZBX_SYNC +FIELD |sourceid |t_id |'0' |NOT NULL |ZBX_SYNC FIELD |clock |t_time |'0' |NOT NULL |ZBX_SYNC FIELD |value |t_integer |'0' |NOT NULL |ZBX_SYNC FIELD |acknowledged |t_integer |'0' |NOT NULL |ZBX_SYNC -INDEX |1 |triggerid,clock +INDEX |1 |triggerid,source,clock INDEX |2 |clock TABLE|history||0 |