summaryrefslogtreecommitdiffstats
path: root/create/schema
diff options
context:
space:
mode:
authorsasha <sasha@97f52cf1-0a1b-0410-bd0e-c28be96e8082>2008-07-29 09:43:53 +0000
committersasha <sasha@97f52cf1-0a1b-0410-bd0e-c28be96e8082>2008-07-29 09:43:53 +0000
commitf7cd0be8cdcedcc34656ced6982dd7abadca01fc (patch)
treea6aa538b83fd84824e8a8431bd9c2ecc694dafc3 /create/schema
parente3248ce4bc1b34d8623359d5333cfa9712b5eb73 (diff)
downloadzabbix-f7cd0be8cdcedcc34656ced6982dd7abadca01fc.tar.gz
zabbix-f7cd0be8cdcedcc34656ced6982dd7abadca01fc.tar.xz
zabbix-f7cd0be8cdcedcc34656ced6982dd7abadca01fc.zip
- [DEV-196] improved performance of server module
git-svn-id: svn://svn.zabbix.com/trunk@5848 97f52cf1-0a1b-0410-bd0e-c28be96e8082
Diffstat (limited to 'create/schema')
-rw-r--r--create/schema/schema.sql3
1 files changed, 1 insertions, 2 deletions
diff --git a/create/schema/schema.sql b/create/schema/schema.sql
index dcd4c434..ef481942 100644
--- a/create/schema/schema.sql
+++ b/create/schema/schema.sql
@@ -235,8 +235,7 @@ INDEX |1 |itemid,clock
TABLE|proxy_history|id|0
FIELD |id |t_serial | |NOT NULL |0
-FIELD |host |t_varchar(64) |'' |NOT NULL |0
-FIELD |key_ |t_varchar(255) |'' |NOT NULL |0
+FIELD |itemid |t_id |'0' |NOT NULL |0
FIELD |clock |t_time |'0' |NOT NULL |0
FIELD |timestamp |t_time |'0' |NOT NULL |0
FIELD |source |t_varchar(64) |'' |NOT NULL |0