From 92ef7bbf6a7c38984e4cd596dcb86b5e2a1faafb Mon Sep 17 00:00:00 2001
From: osmiy <osmiy@97f52cf1-0a1b-0410-bd0e-c28be96e8082>
Date: Thu, 8 Feb 2007 16:03:19 +0000
Subject: - 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
---
 create/schema/schema.sql | 22 +++++++++++-----------
 1 file changed, 11 insertions(+), 11 deletions(-)

(limited to 'create/schema/schema.sql')

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
-- 
cgit 

