diff options
Diffstat (limited to 'create')
| -rw-r--r-- | create/mysql/schema.sql | 18 | ||||
| -rw-r--r-- | create/postgresql/schema.sql | 18 |
2 files changed, 4 insertions, 32 deletions
diff --git a/create/mysql/schema.sql b/create/mysql/schema.sql index 5c224dcd..d2635c25 100644 --- a/create/mysql/schema.sql +++ b/create/mysql/schema.sql @@ -490,7 +490,8 @@ CREATE TABLE screens ( CREATE TABLE screens_items ( screenitemid int(4) NOT NULL auto_increment, screenid int(4) DEFAULT '0' NOT NULL, - graphid int(4) DEFAULT '0' NOT NULL, + resource int(4) DEFAULT '0' NOT NULL, + resourceid int(4) DEFAULT '0' NOT NULL, width int(4) DEFAULT '320' NOT NULL, height int(4) DEFAULT '200' NOT NULL, x int(4) DEFAULT '0' NOT NULL, @@ -499,21 +500,6 @@ CREATE TABLE screens_items ( ) TYPE=InnoDB; -- --- Table structure for table 'screens_graphs' --- - -CREATE TABLE screens_graphs ( - screengraphid int(4) NOT NULL auto_increment, - screenid int(4) DEFAULT '0' NOT NULL, - itemid int(4) DEFAULT '0' NOT NULL, - width int(4) DEFAULT '320' NOT NULL, - height int(4) DEFAULT '200' NOT NULL, - x int(4) DEFAULT '0' NOT NULL, - y int(4) DEFAULT '0' NOT NULL, - PRIMARY KEY (screengraphid) -) TYPE=InnoDB; - --- -- Table structure for table 'stats' -- 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' -- |