- added table 'history_log' (Alexei)

git-svn-id: svn://svn.zabbix.com/trunk@1781 97f52cf1-0a1b-0410-bd0e-c28be96e8082

1 files changed, 14 insertions, 0 deletions

diff --git a/create/postgresql/schema.sql b/create/postgresql/schema.sql
index 1e019b88..81b8d52f 100644
--- a/create/postgresql/schema.sql
+++ b/create/postgresql/schema.sql
@@ -644,4 +644,18 @@ CREATE TABLE hosts_templates (
 
 CREATE UNIQUE INDEX hosts_templates_hostid_templateid on hosts_templates (hostid, templateid);
 
+--
+-- Table structure for table 'history_log'
+--
+
+CREATE TABLE history_log (
+  itemid                int4            DEFAULT '0' NOT NULL,
+  clock                 int4            DEFAULT '0' NOT NULL,
+  value                 varchar(255)    DEFAULT '' NOT NULL,
+--  PRIMARY KEY (itemid,clock),
+  FOREIGN KEY (itemid) REFERENCES items
+);
+
+CREATE INDEX history_log_i_c on history_str (itemid, clock);
+
 VACUUM ANALYZE;