diff options
author | alex <alex@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2007-01-09 19:13:23 +0000 |
---|---|---|
committer | alex <alex@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2007-01-09 19:13:23 +0000 |
commit | 353ab2a2d5919afa631706646f0aa9f56d68d821 (patch) | |
tree | 88e73525a00ce88c2e41b2980297c79f28182840 | |
parent | eefc1995565a3d546bba27810583aa588d9124bd (diff) | |
download | zabbix-353ab2a2d5919afa631706646f0aa9f56d68d821.tar.gz zabbix-353ab2a2d5919afa631706646f0aa9f56d68d821.tar.xz zabbix-353ab2a2d5919afa631706646f0aa9f56d68d821.zip |
Minor changes.
git-svn-id: svn://svn.zabbix.com/trunk@3676 97f52cf1-0a1b-0410-bd0e-c28be96e8082
-rw-r--r-- | create/schema/schema.sql | 20 |
1 files changed, 13 insertions, 7 deletions
diff --git a/create/schema/schema.sql b/create/schema/schema.sql index b008e93f..feb52951 100644 --- a/create/schema/schema.sql +++ b/create/schema/schema.sql @@ -22,17 +22,17 @@ -- TABLE|httptest|httptestid|ZBX_SYNC -FIELD |httptestid |t_integer |'0' |NOT NULL |ZBX_SYNC +FIELD |httptestid |t_id |'0' |NOT NULL |ZBX_SYNC FIELD |name |t_varchar(64) |'' |NOT NULL |ZBX_SYNC -FIELD |hostid |t_id |'0' |NOT NULL |ZBX_SYNC -FIELD |nextcheck |t_id |'0' |NOT NULL |ZBX_SYNC -FIELD |delay |t_id |'0' |NOT NULL |ZBX_SYNC -FIELD |status |t_id |'0' |NOT NULL |ZBX_SYNC +FIELD |applicationid |t_id |'0' |NOT NULL |ZBX_SYNC +FIELD |nextcheck |t_integer |'0' |NOT NULL |ZBX_SYNC +FIELD |delay |t_integer |'60' |NOT NULL |ZBX_SYNC +FIELD |status |t_integer |'0' |NOT NULL |ZBX_SYNC INDEX |httptest_1 |hostid TABLE|httpstep|httpstepid|ZBX_SYNC -FIELD |httpstepid |t_integer |'0' |NOT NULL |ZBX_SYNC -FIELD |httptestid |t_integer |'0' |NOT NULL |ZBX_SYNC +FIELD |httpstepid |t_id |'0' |NOT NULL |ZBX_SYNC +FIELD |httptestid |t_id |'0' |NOT NULL |ZBX_SYNC FIELD |name |t_varchar(64) |'' |NOT NULL |ZBX_SYNC FIELD |no |t_integer |'0' |NOT NULL |ZBX_SYNC FIELD |url |t_varchar(128) |'' |NOT NULL |ZBX_SYNC @@ -40,6 +40,12 @@ FIELD |timeout |t_integer |'30' |NOT NULL |ZBX_SYNC FIELD |posts |t_blob |'' |NOT NULL |ZBX_SYNC INDEX |httpstep_1 |httptestid +TABLE|httpstepitem|httpstepitemid|ZBX_SYNC +FIELD |httpstepitemid |t_id |'0' |NOT NULL |ZBX_SYNC +FIELD |httptestid |t_id |'0' |NOT NULL |ZBX_SYNC +FIELD |itemid |t_id |'0' |NOT NULL |ZBX_SYNC +UNIQUE |httpstepitem_1 |httptestid,itemid + TABLE|nodes|nodeid| FIELD |nodeid |t_integer |'0' |NOT NULL |0 FIELD |name |t_varchar(64) |'0' |NOT NULL |0 |