summaryrefslogtreecommitdiffstats
path: root/create/postgresql/schema.sql
diff options
context:
space:
mode:
authorhugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082>2006-05-18 10:27:57 +0000
committerhugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082>2006-05-18 10:27:57 +0000
commitf9d1dc16f4be4db410cb9aeced999aeb68d35409 (patch)
treef53d2e46b8594da9ed0ff3bde715e7ebdafd701d /create/postgresql/schema.sql
parent39c24b061f617c4a405b14f8bbb432523517662b (diff)
downloadzabbix-f9d1dc16f4be4db410cb9aeced999aeb68d35409.tar.gz
zabbix-f9d1dc16f4be4db410cb9aeced999aeb68d35409.tar.xz
zabbix-f9d1dc16f4be4db410cb9aeced999aeb68d35409.zip
- new table 'help_items' (Alexei)
git-svn-id: svn://svn.zabbix.com/trunk@2853 97f52cf1-0a1b-0410-bd0e-c28be96e8082
Diffstat (limited to 'create/postgresql/schema.sql')
-rw-r--r--create/postgresql/schema.sql12
1 files changed, 12 insertions, 0 deletions
diff --git a/create/postgresql/schema.sql b/create/postgresql/schema.sql
index a895fd44..65988baf 100644
--- a/create/postgresql/schema.sql
+++ b/create/postgresql/schema.sql
@@ -811,4 +811,16 @@ CREATE TABLE items_applications (
FOREIGN KEY (itemid) REFERENCES items
);
+--
+-- Table structure for table 'help_items'
+--
+
+CREATE TABLE help_items (
+ itemtype int4 DEFAULT '0' NOT NULL,
+ key_ varchar(64) DEFAULT '' NOT NULL,
+ description varchar(255) DEFAULT '' NOT NULL,
+ PRIMARY KEY (itemtype, key_)
+);
+
+
VACUUM ANALYZE;