diff options
Diffstat (limited to 'create/mysql/schema.sql')
| -rw-r--r-- | create/mysql/schema.sql | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/create/mysql/schema.sql b/create/mysql/schema.sql index 2e66493b..8feeb2b7 100644 --- a/create/mysql/schema.sql +++ b/create/mysql/schema.sql @@ -617,3 +617,18 @@ CREATE TABLE escalations ( PRIMARY KEY (escalationid), UNIQUE (name) ) type=InnoDB; + +-- +-- Table structure for table 'hosts_templates' +-- + +CREATE TABLE hosts_templates ( + hostid int(4) DEFAULT '0' NOT NULL, + templateid int(4) DEFAULT '0' NOT NULL, + items int(1) DEFAULT '0' NOT NULL, + triggers int(1) DEFAULT '0' NOT NULL, + actions int(1) DEFAULT '0' NOT NULL, + graphs int(1) DEFAULT '0' NOT NULL, + screens int(1) DEFAULT '0' NOT NULL, + PRIMARY KEY (hostid, templateid) +) type=InnoDB; |