diff options
Diffstat (limited to 'create/mysql/schema.sql')
| -rw-r--r-- | create/mysql/schema.sql | 18 |
1 files changed, 2 insertions, 16 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' -- |