From 60acf9d39e2337ffe440ab1f24cddd6a2fc24577 Mon Sep 17 00:00:00 2001
From: hugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082>
Date: Thu, 25 May 2006 16:02:17 +0000
Subject: Minor changes.

git-svn-id: svn://svn.zabbix.com/trunk@2910 97f52cf1-0a1b-0410-bd0e-c28be96e8082
---
 create/postgresql/schema.sql | 14 ++++++++++++++
 1 file changed, 14 insertions(+)

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

diff --git a/create/postgresql/schema.sql b/create/postgresql/schema.sql
index 18ce5039..8928549e 100644
--- a/create/postgresql/schema.sql
+++ b/create/postgresql/schema.sql
@@ -723,6 +723,20 @@ CREATE TABLE history_log (
 
 CREATE INDEX history_log_i_c on history_str (itemid, clock);
 
+--
+-- Table structure for table 'history_text'
+--
+
+CREATE TABLE history_text (
+  itemid		int4	DEFAULT '0' NOT NULL,
+  clock			int4	DEFAULT '0' NOT NULL,
+  value			text	DEFAULT '' NOT NULL,
+  KEY itemidclock (itemid, clock)
+);
+
+CREATE INDEX history_text_i_c on history_text (itemid, clock);
+
+
 --
 -- Table structure for table 'autoreg'
 --
-- 
cgit 

