diff options
| author | osmiy <osmiy@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2007-02-08 16:03:19 +0000 |
|---|---|---|
| committer | osmiy <osmiy@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2007-02-08 16:03:19 +0000 |
| commit | 92ef7bbf6a7c38984e4cd596dcb86b5e2a1faafb (patch) | |
| tree | 0c512d79a88744d2c6d6e5b15b8a6d0cd69ea6e2 /create/schema/schema.sql | |
| parent | 40d8696d1b58c0f76ee82ba8ebdb90e965efcd62 (diff) | |
| download | zabbix-92ef7bbf6a7c38984e4cd596dcb86b5e2a1faafb.tar.gz zabbix-92ef7bbf6a7c38984e4cd596dcb86b5e2a1faafb.tar.xz zabbix-92ef7bbf6a7c38984e4cd596dcb86b5e2a1faafb.zip | |
- improved configuration script
- added suport of 'make dist'
- fixed some bugs with DB supporting
git-svn-id: svn://svn.zabbix.com/trunk@3814 97f52cf1-0a1b-0410-bd0e-c28be96e8082
Diffstat (limited to 'create/schema/schema.sql')
| -rw-r--r-- | create/schema/schema.sql | 22 |
1 files changed, 11 insertions, 11 deletions
diff --git a/create/schema/schema.sql b/create/schema/schema.sql index bca11423..b2923e75 100644 --- a/create/schema/schema.sql +++ b/create/schema/schema.sql @@ -32,7 +32,7 @@ FIELD |curstep |t_integer |'0' |NOT NULL |ZBX_SYNC FIELD |lastfailedstep |t_id |'0' |NOT NULL |ZBX_SYNC FIELD |delay |t_integer |'60' |NOT NULL |ZBX_SYNC FIELD |status |t_integer |'0' |NOT NULL |ZBX_SYNC -FIELD |macros |t_text |'' |NOT NULL |ZBX_SYNC +FIELD |macros |t_blob |'' |NOT NULL |ZBX_SYNC FIELD |agent |t_varchar(255) |'' |NOT NULL |ZBX_SYNC FIELD |time |t_double(16,4) |'0' |NOT NULL |ZBX_SYNC FIELD |error |t_varchar(255) |'' |NOT NULL |ZBX_SYNC @@ -45,7 +45,7 @@ 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 FIELD |timeout |t_integer |'30' |NOT NULL |ZBX_SYNC -FIELD |posts |t_text |'' |NOT NULL |ZBX_SYNC +FIELD |posts |t_blob |'' |NOT NULL |ZBX_SYNC FIELD |required |t_varchar(255) |'' |NOT NULL |ZBX_SYNC INDEX |httpstep_1 |httptestid @@ -147,7 +147,7 @@ FIELD |clock |t_time |'0' |NOT NULL |ZBX_SYNC FIELD |mediatypeid |t_id |'0' |NOT NULL |ZBX_SYNC FIELD |sendto |t_varchar(100) |'' |NOT NULL |ZBX_SYNC FIELD |subject |t_varchar(255) |'' |NOT NULL |ZBX_SYNC -FIELD |message |t_text |'' |NOT NULL |ZBX_SYNC +FIELD |message |t_blob |'' |NOT NULL |ZBX_SYNC FIELD |status |t_integer |'0' |NOT NULL |ZBX_SYNC FIELD |retries |t_integer |'0' |NOT NULL |ZBX_SYNC FIELD |error |t_varchar(128) |'' |NOT NULL |ZBX_SYNC @@ -230,14 +230,14 @@ TABLE|actions|actionid|ZBX_SYNC FIELD |actionid |t_id |'0' |NOT NULL |ZBX_SYNC FIELD |userid |t_id |'0' |NOT NULL |ZBX_SYNC FIELD |subject |t_varchar(255) |'' |NOT NULL |ZBX_SYNC -FIELD |message |t_text |'' |NOT NULL |ZBX_SYNC +FIELD |message |t_blob |'' |NOT NULL |ZBX_SYNC FIELD |recipient |t_integer |'0' |NOT NULL |ZBX_SYNC FIELD |maxrepeats |t_integer |'0' |NOT NULL |ZBX_SYNC FIELD |repeatdelay |t_integer |'600' |NOT NULL |ZBX_SYNC FIELD |source |t_integer |'0' |NOT NULL |ZBX_SYNC FIELD |actiontype |t_integer |'0' |NOT NULL |ZBX_SYNC FIELD |status |t_integer |'0' |NOT NULL |ZBX_SYNC -FIELD |scripts |t_text |'' |NOT NULL |ZBX_SYNC +FIELD |scripts |t_blob |'' |NOT NULL |ZBX_SYNC TABLE|applications|applicationid|ZBX_SYNC FIELD |applicationid |t_id |'0' |NOT NULL |ZBX_SYNC @@ -353,11 +353,11 @@ FIELD |os |t_varchar(64) |'' |NOT NULL |ZBX_SYNC FIELD |serialno |t_varchar(64) |'' |NOT NULL |ZBX_SYNC FIELD |tag |t_varchar(64) |'' |NOT NULL |ZBX_SYNC FIELD |macaddress |t_varchar(64) |'' |NOT NULL |ZBX_SYNC -FIELD |hardware |t_text |'' |NOT NULL |ZBX_SYNC -FIELD |software |t_text |'' |NOT NULL |ZBX_SYNC -FIELD |contact |t_text |'' |NOT NULL |ZBX_SYNC -FIELD |location |t_text |'' |NOT NULL |ZBX_SYNC -FIELD |notes |t_text |'' |NOT NULL |ZBX_SYNC +FIELD |hardware |t_blob |'' |NOT NULL |ZBX_SYNC +FIELD |software |t_blob |'' |NOT NULL |ZBX_SYNC +FIELD |contact |t_blob |'' |NOT NULL |ZBX_SYNC +FIELD |location |t_blob |'' |NOT NULL |ZBX_SYNC +FIELD |notes |t_blob |'' |NOT NULL |ZBX_SYNC TABLE|hosts_templates|hosttemplateid|ZBX_SYNC FIELD |hosttemplateid |t_id |'0' |NOT NULL |ZBX_SYNC @@ -569,7 +569,7 @@ FIELD |value |t_integer |'0' |NOT NULL |ZBX_SYNC FIELD |priority |t_integer |'0' |NOT NULL |ZBX_SYNC FIELD |lastchange |t_integer |'0' |NOT NULL |ZBX_SYNC FIELD |dep_level |t_integer |'0' |NOT NULL |ZBX_SYNC -FIELD |comments |t_text | | |ZBX_SYNC +FIELD |comments |t_blob | | |ZBX_SYNC FIELD |error |t_varchar(128) |'' |NOT NULL |ZBX_SYNC FIELD |templateid |t_id |'0' |NOT NULL |ZBX_SYNC INDEX |1 |status |