diff options
| author | hugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2003-08-15 14:08:47 +0000 |
|---|---|---|
| committer | hugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2003-08-15 14:08:47 +0000 |
| commit | 345f9a1860e018a1395d5b52bef54437148039e2 (patch) | |
| tree | e91be9fa4e4dc503b4ec882f41394d5a70002d34 /create/postgresql/schema.sql | |
| parent | 0dd6639c30456074235350b28d0577add6fbdb43 (diff) | |
| download | zabbix-345f9a1860e018a1395d5b52bef54437148039e2.tar.gz zabbix-345f9a1860e018a1395d5b52bef54437148039e2.tar.xz zabbix-345f9a1860e018a1395d5b52bef54437148039e2.zip | |
Major rewrite of screen handling code.
git-svn-id: svn://svn.zabbix.com/trunk@918 97f52cf1-0a1b-0410-bd0e-c28be96e8082
Diffstat (limited to 'create/postgresql/schema.sql')
| -rw-r--r-- | create/postgresql/schema.sql | 18 |
1 files changed, 2 insertions, 16 deletions
diff --git a/create/postgresql/schema.sql b/create/postgresql/schema.sql index dcd40c6e..96273b11 100644 --- a/create/postgresql/schema.sql +++ b/create/postgresql/schema.sql @@ -501,7 +501,8 @@ CREATE TABLE screens ( CREATE TABLE screens_items ( screenitemid serial, screenid int4 DEFAULT '0' NOT NULL, - graphid int4 DEFAULT '0' NOT NULL, + resource int4 DEFAULT '0' NOT NULL, + resourceid int4 DEFAULT '0' NOT NULL, width int4 DEFAULT '320' NOT NULL, height int4 DEFAULT '200' NOT NULL, x int4 DEFAULT '0' NOT NULL, @@ -510,21 +511,6 @@ 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' -- |