diff options
| author | alex <alex@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2007-08-15 07:29:34 +0000 |
|---|---|---|
| committer | alex <alex@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2007-08-15 07:29:34 +0000 |
| commit | b008b279d94b38f5ad2bde137352d456471e48b2 (patch) | |
| tree | ca6bf52e6fc9b69d0bb48d62a1b0d4a7ff628002 /create/schema/schema.sql | |
| parent | e526132acbbf45962855f93195f286e589a23e9b (diff) | |
| download | zabbix-b008b279d94b38f5ad2bde137352d456471e48b2.tar.gz zabbix-b008b279d94b38f5ad2bde137352d456471e48b2.tar.xz zabbix-b008b279d94b38f5ad2bde137352d456471e48b2.zip | |
- added missing index on items_applications.itemid (Alexei)
[svn merge -r4562:4565 svn://svn.zabbix.com/branches/1.4.2]
git-svn-id: svn://svn.zabbix.com/trunk@4566 97f52cf1-0a1b-0410-bd0e-c28be96e8082
Diffstat (limited to 'create/schema/schema.sql')
| -rw-r--r-- | create/schema/schema.sql | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/create/schema/schema.sql b/create/schema/schema.sql index 1c154c87..26fd43e8 100644 --- a/create/schema/schema.sql +++ b/create/schema/schema.sql @@ -476,6 +476,7 @@ FIELD |itemappid |t_id |'0' |NOT NULL |ZBX_SYNC FIELD |applicationid |t_id |'0' |NOT NULL |ZBX_SYNC FIELD |itemid |t_id |'0' |NOT NULL |ZBX_SYNC INDEX |1 |applicationid,itemid +INDEX |2 |itemid TABLE|mappings|mappingid|ZBX_SYNC FIELD |mappingid |t_id |'0' |NOT NULL |ZBX_SYNC |