diff options
| author | artem <artem@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2007-11-27 10:35:11 +0000 |
|---|---|---|
| committer | artem <artem@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2007-11-27 10:35:11 +0000 |
| commit | 1bd6dc62e58531f845b82f6192f7eb009aea400f (patch) | |
| tree | 40ffcda3f1b6a7ad9b53e19a81ea47aa907d1e7e /create/schema | |
| parent | 98ce4eb6a912de7878aa3632c8de0fecd22455c8 (diff) | |
| download | zabbix-1bd6dc62e58531f845b82f6192f7eb009aea400f.tar.gz zabbix-1bd6dc62e58531f845b82f6192f7eb009aea400f.tar.xz zabbix-1bd6dc62e58531f845b82f6192f7eb009aea400f.zip | |
- [NTT-66] merged rev. 5100:5102 of branches/1.4.j/ (Artem) [tuning performance for "Status of Triggers";changes in SCHEMA, index events_1 now: {object,objectid,eventid}]
git-svn-id: svn://svn.zabbix.com/trunk@5103 97f52cf1-0a1b-0410-bd0e-c28be96e8082
Diffstat (limited to 'create/schema')
| -rw-r--r-- | create/schema/schema.sql | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/create/schema/schema.sql b/create/schema/schema.sql index ec849d20..05d26368 100644 --- a/create/schema/schema.sql +++ b/create/schema/schema.sql @@ -203,7 +203,7 @@ FIELD |objectid |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 |object,objectid,clock +INDEX |1 |object,objectid,eventid INDEX |2 |clock TABLE|history||0 |