diff options
author | alex <alex@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2008-05-22 14:07:00 +0000 |
---|---|---|
committer | alex <alex@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2008-05-22 14:07:00 +0000 |
commit | b0a86ef20a92d1243c7e32510a81b70705980fa4 (patch) | |
tree | 719622aa33404ad1f26bd9bd2098d37e74ea3100 /create/schema | |
parent | 0878829606af062244fbd1077fda07cb72af77e3 (diff) | |
download | zabbix-b0a86ef20a92d1243c7e32510a81b70705980fa4.tar.gz zabbix-b0a86ef20a92d1243c7e32510a81b70705980fa4.tar.xz zabbix-b0a86ef20a92d1243c7e32510a81b70705980fa4.zip |
- [DEV-137] added new index to table items, items.templateid (Alexei)
git-svn-id: svn://svn.zabbix.com/trunk@5723 97f52cf1-0a1b-0410-bd0e-c28be96e8082
Diffstat (limited to 'create/schema')
-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 6beb7cea..16397a8a 100644 --- a/create/schema/schema.sql +++ b/create/schema/schema.sql @@ -510,6 +510,7 @@ FIELD |params |t_item_param |'' |NOT NULL |ZBX_SYNC,ZBX_PROXY UNIQUE |1 |hostid,key_ INDEX |2 |nextcheck INDEX |3 |status +INDEX |4 |templateid TABLE|items_applications|itemappid|ZBX_SYNC FIELD |itemappid |t_id |'0' |NOT NULL |0 |