diff options
Diffstat (limited to 'create')
| -rw-r--r-- | create/data/data.sql | 12 | ||||
| -rw-r--r-- | create/schema/schema.sql | 2 |
2 files changed, 8 insertions, 6 deletions
diff --git a/create/data/data.sql b/create/data/data.sql index f53c1b18..eac0f302 100644 --- a/create/data/data.sql +++ b/create/data/data.sql @@ -27,7 +27,7 @@ INSERT INTO config VALUES (1,365,365,600,'1-5,00:00-24:00'); -- Dumping data for table `media_type` -- -INSERT INTO media_type VALUES (1,0,'Email','localhost','localhost','zabbix@localhost','',''); +INSERT INTO media_type VALUES (1,0,'Email','localhost','localhost','zabbix@localhost','','','',''); -- -- Dumping data for table `users` @@ -61,11 +61,11 @@ INSERT INTO rights VALUES (3,2,'Default permission','R',0); -- Dumping data for table `hosts` -- -INSERT INTO hosts VALUES (10001,'Unix_t',0,'',10050,3,0,'',0,0); -INSERT INTO hosts VALUES (10002,'Windows_t',0,'',10050,3,0,'',0,0); -INSERT INTO hosts VALUES (10004,'Standalone_t',0,'',10050,3,0,'',0,0); -INSERT INTO hosts VALUES (10003,'MySQL_t',0,'',10050,3,0,'',0,0); -INSERT INTO hosts VALUES (10007,'SNMP_t',0,'',161,3,0,'',0,0); +INSERT INTO hosts VALUES (10001,'Unix_t','Unix_t',0,'',10050,3,0,'',0,0); +INSERT INTO hosts VALUES (10002,'Windows_t','Windows_t',0,'',10050,3,0,'',0,0); +INSERT INTO hosts VALUES (10004,'Standalone_t','Standalone_t',0,'',10050,3,0,'',0,0); +INSERT INTO hosts VALUES (10003,'MySQL_t','MySQL_t',0,'',10050,3,0,'',0,0); +INSERT INTO hosts VALUES (10007,'SNMP_t','SNMP_t',0,'',161,3,0,'',0,0); -- -- Dumping data for table `groups` diff --git a/create/schema/schema.sql b/create/schema/schema.sql index 2d8edbb3..b2923e75 100644 --- a/create/schema/schema.sql +++ b/create/schema/schema.sql @@ -451,6 +451,8 @@ FIELD |smtp_helo |t_varchar(255) |'' |NOT NULL |ZBX_SYNC FIELD |smtp_email |t_varchar(255) |'' |NOT NULL |ZBX_SYNC FIELD |exec_path |t_varchar(255) |'' |NOT NULL |ZBX_SYNC FIELD |gsm_modem |t_varchar(255) |'' |NOT NULL |ZBX_SYNC +FIELD |username |t_varchar(255) |'' |NOT NULL |ZBX_SYNC +FIELD |passwd |t_varchar(255) |'' |NOT NULL |ZBX_SYNC TABLE|profiles|profileid|ZBX_SYNC FIELD |profileid |t_id |'0' |NOT NULL |ZBX_SYNC |