summaryrefslogtreecommitdiffstats
path: root/create/postgresql/schema.sql
diff options
context:
space:
mode:
authorhugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082>2003-06-20 10:41:20 +0000
committerhugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082>2003-06-20 10:41:20 +0000
commitccacb4ca973ed58f1392aef3365f838abdc1f012 (patch)
treef7e1f3e65a136774644254f11716731998bba1de /create/postgresql/schema.sql
parentf4959808757ef018273ffe82e6f9fa2267a39f4e (diff)
downloadzabbix-ccacb4ca973ed58f1392aef3365f838abdc1f012.tar.gz
zabbix-ccacb4ca973ed58f1392aef3365f838abdc1f012.tar.xz
zabbix-ccacb4ca973ed58f1392aef3365f838abdc1f012.zip
Updated DB patches.
git-svn-id: svn://svn.zabbix.com/trunk@836 97f52cf1-0a1b-0410-bd0e-c28be96e8082
Diffstat (limited to 'create/postgresql/schema.sql')
-rw-r--r--create/postgresql/schema.sql15
1 files changed, 15 insertions, 0 deletions
diff --git a/create/postgresql/schema.sql b/create/postgresql/schema.sql
index 8619d9dd..12868c56 100644
--- a/create/postgresql/schema.sql
+++ b/create/postgresql/schema.sql
@@ -508,6 +508,21 @@ CREATE TABLE screens_items (
);
--
+-- Table structure for table 'screens_graphs'
+--
+
+CREATE TABLE screens_graphs (
+ screengraphid serial,
+ screenid int4 DEFAULT '0' NOT NULL,
+ itemid int4 DEFAULT '0' NOT NULL,
+ width int4 DEFAULT '320' NOT NULL,
+ height int4 DEFAULT '200' NOT NULL,
+ x int4 DEFAULT '0' NOT NULL,
+ y int4 DEFAULT '0' NOT NULL,
+ PRIMARY KEY (screengraphid)
+);
+
+--
-- Table structure for table 'stats'
--