diff options
Diffstat (limited to 'create')
| -rw-r--r-- | create/mysql/schema.sql | 20 |
1 files changed, 20 insertions, 0 deletions
diff --git a/create/mysql/schema.sql b/create/mysql/schema.sql index 85eaded7..c81d5e0a 100644 --- a/create/mysql/schema.sql +++ b/create/mysql/schema.sql @@ -691,3 +691,23 @@ CREATE TABLE history_log ( PRIMARY KEY (id), KEY itemidclock (itemid, clock) ) type=InnoDB; + +-- +-- Table structure for table 'hosts_profiles' +-- + +CREATE TABLE hosts_profiles ( + hostid int(4) DEFAULT '0' NOT NULL, + devicetype varchar(64) DEFAULT '' NOT NULL, + name varchar(64) DEFAULT '' NOT NULL, + os varchar(64) DEFAULT '' NOT NULL, + serialno varchar(64) DEFAULT '' NOT NULL, + tag varchar(64) DEFAULT '' NOT NULL, + macaddress varchar(64) DEFAULT '' NOT NULL, + hardware blob DEFAULT '' NOT NULL, + software blob DEFAULT '' NOT NULL, + contact blob DEFAULT '' NOT NULL, + location blob DEFAULT '' NOT NULL, + notes lob DEFAULT '' NOT NULL, + PRIMARY KEY (hostid) +) type=InnoDB; |