diff options
author | hugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2003-04-06 11:59:16 +0000 |
---|---|---|
committer | hugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2003-04-06 11:59:16 +0000 |
commit | 4d4eb2ca7581b62e0069d3701a2cad9e6ad520f0 (patch) | |
tree | 2ca4705bcdd92867585d828bbdfffaad4f79729e /create/mysql | |
parent | 87f979867288718684f72e2a5fb3a8d4bb3840c1 (diff) | |
download | zabbix-4d4eb2ca7581b62e0069d3701a2cad9e6ad520f0.tar.gz zabbix-4d4eb2ca7581b62e0069d3701a2cad9e6ad520f0.tar.xz zabbix-4d4eb2ca7581b62e0069d3701a2cad9e6ad520f0.zip |
Minor fixes.
git-svn-id: svn://svn.zabbix.com/trunk@746 97f52cf1-0a1b-0410-bd0e-c28be96e8082
Diffstat (limited to 'create/mysql')
-rw-r--r-- | create/mysql/schema.sql | 27 |
1 files changed, 27 insertions, 0 deletions
diff --git a/create/mysql/schema.sql b/create/mysql/schema.sql index 401a8a92..9365463d 100644 --- a/create/mysql/schema.sql +++ b/create/mysql/schema.sql @@ -442,3 +442,30 @@ CREATE TABLE profiles ( KEY (userid), UNIQUE (userid,idx) ) type=InnoDB; + +-- +-- Table structure for table 'screens' +-- + +CREATE TABLE screens ( + screenid int(4) NOT NULL auto_increment, + name varchar(255) DEFAULT 'Screen' NOT NULL, + cols int(4) DEFAULT '1' NOT NULL, + rows int(4) DEFAULT '1' NOT NULL, + PRIMARY KEY (screenid) +) TYPE=InnoDB; + +-- +-- Table structure for table 'screens_items' +-- + +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, + 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 (screenitemid) +) TYPE=InnoDB; |