"Fossies" - the Fresh Open Source Software Archive  

Source code changes of the file "docs/audit_schema.sql" between
cacti-1.2.21.tar.gz and cacti-1.2.22.tar.gz

About: Cacti is a complete network graphing solution designed to harness the power of RRDTool’s data storage and graphing functionality.

audit_schema.sql  (cacti-1.2.21):audit_schema.sql  (cacti-1.2.22)
skipping to change at line 58 skipping to change at line 58
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates',5,'gprint_format ','char(2)','YES','','',''); INSERT INTO `table_columns` VALUES ('aggregate_graph_templates',5,'gprint_format ','char(2)','YES','','','');
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates',6,'graph_type',' int(10) unsigned','NO','',NULL,''); INSERT INTO `table_columns` VALUES ('aggregate_graph_templates',6,'graph_type',' int(10) unsigned','NO','',NULL,'');
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates',7,'total','int(1 0) unsigned','NO','',NULL,''); INSERT INTO `table_columns` VALUES ('aggregate_graph_templates',7,'total','int(1 0) unsigned','NO','',NULL,'');
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates',8,'total_type',' int(10) unsigned','NO','',NULL,''); INSERT INTO `table_columns` VALUES ('aggregate_graph_templates',8,'total_type',' int(10) unsigned','NO','',NULL,'');
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates',9,'total_prefix' ,'varchar(64)','NO','',NULL,''); INSERT INTO `table_columns` VALUES ('aggregate_graph_templates',9,'total_prefix' ,'varchar(64)','NO','',NULL,'');
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates',10,'order_type', 'int(10) unsigned','NO','',NULL,''); INSERT INTO `table_columns` VALUES ('aggregate_graph_templates',10,'order_type', 'int(10) unsigned','NO','',NULL,'');
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates',11,'created','ti mestamp','NO','','current_timestamp()',''); INSERT INTO `table_columns` VALUES ('aggregate_graph_templates',11,'created','ti mestamp','NO','','current_timestamp()','');
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates',12,'user_id','in t(10) unsigned','NO','MUL',NULL,''); INSERT INTO `table_columns` VALUES ('aggregate_graph_templates',12,'user_id','in t(10) unsigned','NO','MUL',NULL,'');
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',1,'aggrega te_template_id','int(10) unsigned','NO','PRI',NULL,''); INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',1,'aggrega te_template_id','int(10) unsigned','NO','PRI',NULL,'');
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',2,'t_image _format_id','char(2)','YES','','',''); INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',2,'t_image _format_id','char(2)','YES','','','');
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',3,'image_f ormat_id','tinyint(1)','NO','','0',''); INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',3,'image_f ormat_id','tinyint(3) unsigned','NO','','0','');
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',4,'t_heigh t','char(2)','YES','','',''); INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',4,'t_heigh t','char(2)','YES','','','');
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',5,'height' ,'mediumint(8)','NO','','0',''); INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',5,'height' ,'mediumint(8)','NO','','0','');
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',6,'t_width ','char(2)','YES','','',''); INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',6,'t_width ','char(2)','YES','','','');
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',7,'width', 'mediumint(8)','NO','','0',''); INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',7,'width', 'mediumint(8)','NO','','0','');
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',8,'t_upper _limit','char(2)','YES','','',''); INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',8,'t_upper _limit','char(2)','YES','','','');
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',9,'upper_l imit','varchar(20)','NO','','0',''); INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',9,'upper_l imit','varchar(20)','NO','','0','');
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',10,'t_lowe r_limit','char(2)','YES','','',''); INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',10,'t_lowe r_limit','char(2)','YES','','','');
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',11,'lower_ limit','varchar(20)','NO','','0',''); INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',11,'lower_ limit','varchar(20)','NO','','0','');
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',12,'t_vert ical_label','char(2)','YES','','',''); INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',12,'t_vert ical_label','char(2)','YES','','','');
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',13,'vertic al_label','varchar(200)','YES','','',''); INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',13,'vertic al_label','varchar(200)','YES','','','');
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',14,'t_slop e_mode','char(2)','YES','','',''); INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',14,'t_slop e_mode','char(2)','YES','','','');
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',15,'slope_ mode','char(2)','YES','','on',''); INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',15,'slope_ mode','char(2)','YES','','on','');
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',16,'t_auto _scale','char(2)','YES','','',''); INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',16,'t_auto _scale','char(2)','YES','','','');
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',17,'auto_s cale','char(2)','YES','','',''); INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',17,'auto_s cale','char(2)','YES','','','');
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',18,'t_auto _scale_opts','char(2)','YES','','',''); INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',18,'t_auto _scale_opts','char(2)','YES','','','');
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',19,'auto_s cale_opts','tinyint(1)','NO','','0',''); INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',19,'auto_s cale_opts','tinyint(3) unsigned','NO','','0','');
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',20,'t_auto _scale_log','char(2)','YES','','',''); INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',20,'t_auto _scale_log','char(2)','YES','','','');
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',21,'auto_s cale_log','char(2)','YES','','',''); INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',21,'auto_s cale_log','char(2)','YES','','','');
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',22,'t_scal e_log_units','char(2)','YES','','',''); INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',22,'t_scal e_log_units','char(2)','YES','','','');
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',23,'scale_ log_units','char(2)','YES','','',''); INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',23,'scale_ log_units','char(2)','YES','','','');
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',24,'t_auto _scale_rigid','char(2)','YES','','',''); INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',24,'t_auto _scale_rigid','char(2)','YES','','','');
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',25,'auto_s cale_rigid','char(2)','YES','','',''); INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',25,'auto_s cale_rigid','char(2)','YES','','','');
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',26,'t_auto _padding','char(2)','YES','','',''); INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',26,'t_auto _padding','char(2)','YES','','','');
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',27,'auto_p adding','char(2)','YES','','',''); INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',27,'auto_p adding','char(2)','YES','','','');
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',28,'t_base _value','char(2)','YES','','',''); INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',28,'t_base _value','char(2)','YES','','','');
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',29,'base_v alue','mediumint(8)','NO','','0',''); INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',29,'base_v alue','mediumint(8)','NO','','0','');
skipping to change at line 120 skipping to change at line 120
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',55,'dynami c_labels','char(2)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',55,'dynami c_labels','char(2)','YES','',NULL,'');
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',56,'t_forc e_rules_legend','char(2)','YES','','',''); INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',56,'t_forc e_rules_legend','char(2)','YES','','','');
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',57,'force_ rules_legend','char(2)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',57,'force_ rules_legend','char(2)','YES','',NULL,'');
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',58,'t_lege nd_position','char(2)','YES','','',''); INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',58,'t_lege nd_position','char(2)','YES','','','');
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',59,'legend _position','varchar(10)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',59,'legend _position','varchar(10)','YES','',NULL,'');
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',60,'t_lege nd_direction','char(2)','YES','','',''); INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',60,'t_lege nd_direction','char(2)','YES','','','');
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',61,'legend _direction','varchar(10)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_graph',61,'legend _direction','varchar(10)','YES','',NULL,'');
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_item',1,'aggregat e_template_id','int(10) unsigned','NO','PRI',NULL,''); INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_item',1,'aggregat e_template_id','int(10) unsigned','NO','PRI',NULL,'');
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_item',2,'graph_te mplates_item_id','int(10) unsigned','NO','PRI',NULL,''); INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_item',2,'graph_te mplates_item_id','int(10) unsigned','NO','PRI',NULL,'');
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_item',3,'sequence ','mediumint(8) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_item',3,'sequence ','mediumint(8) unsigned','NO','','0','');
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_item',4,'color_te mplate','int(11)','NO','',NULL,''); INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_item',4,'color_te mplate','int(10) unsigned','NO','',NULL,'');
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_item',5,'t_graph_ type_id','char(2)','YES','','',''); INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_item',5,'t_graph_ type_id','char(2)','YES','','','');
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_item',6,'graph_ty pe_id','tinyint(3)','NO','','0',''); INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_item',6,'graph_ty pe_id','tinyint(3) unsigned','NO','','0','');
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_item',7,'t_cdef_i d','char(2)','YES','','',''); INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_item',7,'t_cdef_i d','char(2)','YES','','','');
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_item',8,'cdef_id' ,'mediumint(8) unsigned','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_item',8,'cdef_id' ,'mediumint(8) unsigned','YES','',NULL,'');
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_item',9,'item_ski p','char(2)','NO','',NULL,''); INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_item',9,'item_ski p','char(2)','NO','',NULL,'');
INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_item',10,'item_to tal','char(2)','NO','',NULL,''); INSERT INTO `table_columns` VALUES ('aggregate_graph_templates_item',10,'item_to tal','char(2)','NO','',NULL,'');
INSERT INTO `table_columns` VALUES ('aggregate_graphs',1,'id','int(10) unsigned' ,'NO','PRI',NULL,'auto_increment'); INSERT INTO `table_columns` VALUES ('aggregate_graphs',1,'id','int(10) unsigned' ,'NO','PRI',NULL,'auto_increment');
INSERT INTO `table_columns` VALUES ('aggregate_graphs',2,'aggregate_template_id' ,'int(10) unsigned','NO','MUL',NULL,''); INSERT INTO `table_columns` VALUES ('aggregate_graphs',2,'aggregate_template_id' ,'int(10) unsigned','NO','MUL',NULL,'');
INSERT INTO `table_columns` VALUES ('aggregate_graphs',3,'template_propogation', 'char(2)','NO','','',''); INSERT INTO `table_columns` VALUES ('aggregate_graphs',3,'template_propogation', 'char(2)','NO','','','');
INSERT INTO `table_columns` VALUES ('aggregate_graphs',4,'local_graph_id','int(1 0) unsigned','NO','MUL',NULL,''); INSERT INTO `table_columns` VALUES ('aggregate_graphs',4,'local_graph_id','int(1 0) unsigned','NO','MUL',NULL,'');
INSERT INTO `table_columns` VALUES ('aggregate_graphs',5,'title_format','varchar (128)','NO','MUL',NULL,''); INSERT INTO `table_columns` VALUES ('aggregate_graphs',5,'title_format','varchar (128)','NO','MUL',NULL,'');
INSERT INTO `table_columns` VALUES ('aggregate_graphs',6,'graph_template_id','in t(10) unsigned','NO','',NULL,''); INSERT INTO `table_columns` VALUES ('aggregate_graphs',6,'graph_template_id','in t(10) unsigned','NO','',NULL,'');
skipping to change at line 145 skipping to change at line 145
INSERT INTO `table_columns` VALUES ('aggregate_graphs',9,'graph_type','int(10) u nsigned','NO','',NULL,''); INSERT INTO `table_columns` VALUES ('aggregate_graphs',9,'graph_type','int(10) u nsigned','NO','',NULL,'');
INSERT INTO `table_columns` VALUES ('aggregate_graphs',10,'total','int(10) unsig ned','NO','',NULL,''); INSERT INTO `table_columns` VALUES ('aggregate_graphs',10,'total','int(10) unsig ned','NO','',NULL,'');
INSERT INTO `table_columns` VALUES ('aggregate_graphs',11,'total_type','int(10) unsigned','NO','',NULL,''); INSERT INTO `table_columns` VALUES ('aggregate_graphs',11,'total_type','int(10) unsigned','NO','',NULL,'');
INSERT INTO `table_columns` VALUES ('aggregate_graphs',12,'total_prefix','varcha r(64)','NO','',NULL,''); INSERT INTO `table_columns` VALUES ('aggregate_graphs',12,'total_prefix','varcha r(64)','NO','',NULL,'');
INSERT INTO `table_columns` VALUES ('aggregate_graphs',13,'order_type','int(10) unsigned','NO','',NULL,''); INSERT INTO `table_columns` VALUES ('aggregate_graphs',13,'order_type','int(10) unsigned','NO','',NULL,'');
INSERT INTO `table_columns` VALUES ('aggregate_graphs',14,'created','timestamp', 'NO','','current_timestamp()','on update current_timestamp()'); INSERT INTO `table_columns` VALUES ('aggregate_graphs',14,'created','timestamp', 'NO','','current_timestamp()','on update current_timestamp()');
INSERT INTO `table_columns` VALUES ('aggregate_graphs',15,'user_id','int(10) uns igned','NO','MUL',NULL,''); INSERT INTO `table_columns` VALUES ('aggregate_graphs',15,'user_id','int(10) uns igned','NO','MUL',NULL,'');
INSERT INTO `table_columns` VALUES ('aggregate_graphs_graph_item',1,'aggregate_g raph_id','int(10) unsigned','NO','PRI',NULL,''); INSERT INTO `table_columns` VALUES ('aggregate_graphs_graph_item',1,'aggregate_g raph_id','int(10) unsigned','NO','PRI',NULL,'');
INSERT INTO `table_columns` VALUES ('aggregate_graphs_graph_item',2,'graph_templ ates_item_id','int(10) unsigned','NO','PRI',NULL,''); INSERT INTO `table_columns` VALUES ('aggregate_graphs_graph_item',2,'graph_templ ates_item_id','int(10) unsigned','NO','PRI',NULL,'');
INSERT INTO `table_columns` VALUES ('aggregate_graphs_graph_item',3,'sequence',' mediumint(8) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('aggregate_graphs_graph_item',3,'sequence',' mediumint(8) unsigned','NO','','0','');
INSERT INTO `table_columns` VALUES ('aggregate_graphs_graph_item',4,'color_templ ate','int(11) unsigned','NO','',NULL,''); INSERT INTO `table_columns` VALUES ('aggregate_graphs_graph_item',4,'color_templ ate','int(10) unsigned','NO','',NULL,'');
INSERT INTO `table_columns` VALUES ('aggregate_graphs_graph_item',5,'t_graph_typ e_id','char(2)','YES','','',''); INSERT INTO `table_columns` VALUES ('aggregate_graphs_graph_item',5,'t_graph_typ e_id','char(2)','YES','','','');
INSERT INTO `table_columns` VALUES ('aggregate_graphs_graph_item',6,'graph_type_ id','tinyint(3)','NO','','0',''); INSERT INTO `table_columns` VALUES ('aggregate_graphs_graph_item',6,'graph_type_ id','tinyint(3) unsigned','NO','','0','');
INSERT INTO `table_columns` VALUES ('aggregate_graphs_graph_item',7,'t_cdef_id', 'char(2)','YES','','',''); INSERT INTO `table_columns` VALUES ('aggregate_graphs_graph_item',7,'t_cdef_id', 'char(2)','YES','','','');
INSERT INTO `table_columns` VALUES ('aggregate_graphs_graph_item',8,'cdef_id','m ediumint(8) unsigned','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('aggregate_graphs_graph_item',8,'cdef_id','m ediumint(8) unsigned','YES','',NULL,'');
INSERT INTO `table_columns` VALUES ('aggregate_graphs_graph_item',9,'item_skip', 'char(2)','NO','',NULL,''); INSERT INTO `table_columns` VALUES ('aggregate_graphs_graph_item',9,'item_skip', 'char(2)','NO','',NULL,'');
INSERT INTO `table_columns` VALUES ('aggregate_graphs_graph_item',10,'item_total ','char(2)','NO','',NULL,''); INSERT INTO `table_columns` VALUES ('aggregate_graphs_graph_item',10,'item_total ','char(2)','NO','',NULL,'');
INSERT INTO `table_columns` VALUES ('aggregate_graphs_items',1,'aggregate_graph_ id','int(10) unsigned','NO','PRI',NULL,''); INSERT INTO `table_columns` VALUES ('aggregate_graphs_items',1,'aggregate_graph_ id','int(10) unsigned','NO','PRI',NULL,'');
INSERT INTO `table_columns` VALUES ('aggregate_graphs_items',2,'local_graph_id', 'int(10) unsigned','NO','PRI',NULL,''); INSERT INTO `table_columns` VALUES ('aggregate_graphs_items',2,'local_graph_id', 'int(10) unsigned','NO','PRI',NULL,'');
INSERT INTO `table_columns` VALUES ('aggregate_graphs_items',3,'sequence','mediu mint(8) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('aggregate_graphs_items',3,'sequence','mediu mint(8) unsigned','NO','','0','');
INSERT INTO `table_columns` VALUES ('automation_devices',1,'id','bigint(20) unsi gned','NO','PRI',NULL,'auto_increment'); INSERT INTO `table_columns` VALUES ('automation_devices',1,'id','bigint(20) unsi gned','NO','PRI',NULL,'auto_increment');
INSERT INTO `table_columns` VALUES ('automation_devices',2,'network_id','int(10) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('automation_devices',2,'network_id','int(10) unsigned','NO','','0','');
INSERT INTO `table_columns` VALUES ('automation_devices',3,'hostname','varchar(1 00)','NO','MUL','',''); INSERT INTO `table_columns` VALUES ('automation_devices',3,'hostname','varchar(1 00)','NO','MUL','','');
INSERT INTO `table_columns` VALUES ('automation_devices',4,'ip','varchar(17)','N O','UNI','',''); INSERT INTO `table_columns` VALUES ('automation_devices',4,'ip','varchar(17)','N O','UNI','','');
INSERT INTO `table_columns` VALUES ('automation_devices',5,'snmp_community','var char(100)','NO','','',''); INSERT INTO `table_columns` VALUES ('automation_devices',5,'snmp_community','var char(100)','NO','','','');
INSERT INTO `table_columns` VALUES ('automation_devices',6,'snmp_version','tinyi INSERT INTO `table_columns` VALUES ('automation_devices',6,'snmp_version','tinyi
nt(1) unsigned','NO','','1',''); nt(3) unsigned','NO','','1','');
INSERT INTO `table_columns` VALUES ('automation_devices',7,'snmp_port','mediumin INSERT INTO `table_columns` VALUES ('automation_devices',7,'snmp_port','mediumin
t(5) unsigned','NO','','161',''); t(8) unsigned','NO','','161','');
INSERT INTO `table_columns` VALUES ('automation_devices',8,'snmp_username','varc har(50)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('automation_devices',8,'snmp_username','varc har(50)','YES','',NULL,'');
INSERT INTO `table_columns` VALUES ('automation_devices',9,'snmp_password','varc har(50)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('automation_devices',9,'snmp_password','varc har(50)','YES','',NULL,'');
INSERT INTO `table_columns` VALUES ('automation_devices',10,'snmp_auth_protocol' ,'char(6)','YES','','',''); INSERT INTO `table_columns` VALUES ('automation_devices',10,'snmp_auth_protocol' ,'char(6)','YES','','','');
INSERT INTO `table_columns` VALUES ('automation_devices',11,'snmp_priv_passphras e','varchar(200)','YES','','',''); INSERT INTO `table_columns` VALUES ('automation_devices',11,'snmp_priv_passphras e','varchar(200)','YES','','','');
INSERT INTO `table_columns` VALUES ('automation_devices',12,'snmp_priv_protocol' ,'char(6)','YES','','',''); INSERT INTO `table_columns` VALUES ('automation_devices',12,'snmp_priv_protocol' ,'char(6)','YES','','','');
INSERT INTO `table_columns` VALUES ('automation_devices',13,'snmp_context','varc har(64)','YES','','',''); INSERT INTO `table_columns` VALUES ('automation_devices',13,'snmp_context','varc har(64)','YES','','','');
INSERT INTO `table_columns` VALUES ('automation_devices',14,'snmp_engine_id','va rchar(64)','YES','','',''); INSERT INTO `table_columns` VALUES ('automation_devices',14,'snmp_engine_id','va rchar(64)','YES','','','');
INSERT INTO `table_columns` VALUES ('automation_devices',15,'sysName','varchar(1 00)','NO','','',''); INSERT INTO `table_columns` VALUES ('automation_devices',15,'sysName','varchar(1 00)','NO','','','');
INSERT INTO `table_columns` VALUES ('automation_devices',16,'sysLocation','varch ar(255)','NO','','',''); INSERT INTO `table_columns` VALUES ('automation_devices',16,'sysLocation','varch ar(255)','NO','','','');
INSERT INTO `table_columns` VALUES ('automation_devices',17,'sysContact','varcha r(255)','NO','','',''); INSERT INTO `table_columns` VALUES ('automation_devices',17,'sysContact','varcha r(255)','NO','','','');
INSERT INTO `table_columns` VALUES ('automation_devices',18,'sysDescr','varchar( 255)','NO','','',''); INSERT INTO `table_columns` VALUES ('automation_devices',18,'sysDescr','varchar( 255)','NO','','','');
INSERT INTO `table_columns` VALUES ('automation_devices',19,'sysUptime','bigint( 20) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('automation_devices',19,'sysUptime','bigint( 20) unsigned','NO','','0','');
INSERT INTO `table_columns` VALUES ('automation_devices',20,'os','varchar(64)',' NO','','',''); INSERT INTO `table_columns` VALUES ('automation_devices',20,'os','varchar(64)',' NO','','','');
INSERT INTO `table_columns` VALUES ('automation_devices',21,'snmp','tinyint(4)', INSERT INTO `table_columns` VALUES ('automation_devices',21,'snmp','tinyint(3) u
'NO','','0',''); nsigned','NO','','0','');
INSERT INTO `table_columns` VALUES ('automation_devices',22,'known','tinyint(4)' INSERT INTO `table_columns` VALUES ('automation_devices',22,'known','tinyint(3)
,'NO','','0',''); unsigned','NO','','0','');
INSERT INTO `table_columns` VALUES ('automation_devices',23,'up','tinyint(4)','N INSERT INTO `table_columns` VALUES ('automation_devices',23,'up','tinyint(3) uns
O','','0',''); igned','NO','','0','');
INSERT INTO `table_columns` VALUES ('automation_devices',24,'time','int(11)','NO INSERT INTO `table_columns` VALUES ('automation_devices',24,'time','int(10) unsi
','','0',''); gned','NO','','0','');
INSERT INTO `table_columns` VALUES ('automation_graph_rule_items',1,'id','medium int(8) unsigned','NO','PRI',NULL,'auto_increment'); INSERT INTO `table_columns` VALUES ('automation_graph_rule_items',1,'id','medium int(8) unsigned','NO','PRI',NULL,'auto_increment');
INSERT INTO `table_columns` VALUES ('automation_graph_rule_items',2,'rule_id','m ediumint(8) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('automation_graph_rule_items',2,'rule_id','m ediumint(8) unsigned','NO','','0','');
INSERT INTO `table_columns` VALUES ('automation_graph_rule_items',3,'sequence',' smallint(3) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('automation_graph_rule_items',3,'sequence',' smallint(3) unsigned','NO','','0','');
INSERT INTO `table_columns` VALUES ('automation_graph_rule_items',4,'operation', 'smallint(3) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('automation_graph_rule_items',4,'operation', 'smallint(3) unsigned','NO','','0','');
INSERT INTO `table_columns` VALUES ('automation_graph_rule_items',5,'field','var char(255)','NO','','',''); INSERT INTO `table_columns` VALUES ('automation_graph_rule_items',5,'field','var char(255)','NO','','','');
INSERT INTO `table_columns` VALUES ('automation_graph_rule_items',6,'operator',' smallint(3) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('automation_graph_rule_items',6,'operator',' smallint(3) unsigned','NO','','0','');
INSERT INTO `table_columns` VALUES ('automation_graph_rule_items',7,'pattern','v archar(255)','NO','','',''); INSERT INTO `table_columns` VALUES ('automation_graph_rule_items',7,'pattern','v archar(255)','NO','','','');
INSERT INTO `table_columns` VALUES ('automation_graph_rules',1,'id','mediumint(8 ) unsigned','NO','PRI',NULL,'auto_increment'); INSERT INTO `table_columns` VALUES ('automation_graph_rules',1,'id','mediumint(8 ) unsigned','NO','PRI',NULL,'auto_increment');
INSERT INTO `table_columns` VALUES ('automation_graph_rules',2,'name','varchar(2 55)','NO','MUL','',''); INSERT INTO `table_columns` VALUES ('automation_graph_rules',2,'name','varchar(2 55)','NO','MUL','','');
INSERT INTO `table_columns` VALUES ('automation_graph_rules',3,'snmp_query_id',' smallint(3) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('automation_graph_rules',3,'snmp_query_id',' smallint(3) unsigned','NO','','0','');
skipping to change at line 242 skipping to change at line 242
INSERT INTO `table_columns` VALUES ('automation_networks',28,'recur_every','int( 10) unsigned','YES','','1',''); INSERT INTO `table_columns` VALUES ('automation_networks',28,'recur_every','int( 10) unsigned','YES','','1','');
INSERT INTO `table_columns` VALUES ('automation_networks',29,'day_of_week','varc har(45)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('automation_networks',29,'day_of_week','varc har(45)','YES','',NULL,'');
INSERT INTO `table_columns` VALUES ('automation_networks',30,'month','varchar(45 )','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('automation_networks',30,'month','varchar(45 )','YES','',NULL,'');
INSERT INTO `table_columns` VALUES ('automation_networks',31,'day_of_month','var char(45)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('automation_networks',31,'day_of_month','var char(45)','YES','',NULL,'');
INSERT INTO `table_columns` VALUES ('automation_networks',32,'monthly_week','var char(45)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('automation_networks',32,'monthly_week','var char(45)','YES','',NULL,'');
INSERT INTO `table_columns` VALUES ('automation_networks',33,'monthly_day','varc har(45)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('automation_networks',33,'monthly_day','varc har(45)','YES','',NULL,'');
INSERT INTO `table_columns` VALUES ('automation_networks',34,'last_runtime','dou ble','NO','','0',''); INSERT INTO `table_columns` VALUES ('automation_networks',34,'last_runtime','dou ble','NO','','0','');
INSERT INTO `table_columns` VALUES ('automation_networks',35,'last_started','tim estamp','NO','','0000-00-00 00:00:00',''); INSERT INTO `table_columns` VALUES ('automation_networks',35,'last_started','tim estamp','NO','','0000-00-00 00:00:00','');
INSERT INTO `table_columns` VALUES ('automation_networks',36,'last_status','varc har(128)','NO','','',''); INSERT INTO `table_columns` VALUES ('automation_networks',36,'last_status','varc har(128)','NO','','','');
INSERT INTO `table_columns` VALUES ('automation_networks',37,'rerun_data_queries ','char(2)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('automation_networks',37,'rerun_data_queries ','char(2)','YES','',NULL,'');
INSERT INTO `table_columns` VALUES ('automation_processes',1,'pid','int(8) unsig ned','NO','PRI',NULL,''); INSERT INTO `table_columns` VALUES ('automation_processes',1,'pid','int(10) unsi gned','NO','PRI',NULL,'');
INSERT INTO `table_columns` VALUES ('automation_processes',2,'poller_id','int(10 ) unsigned','YES','','1',''); INSERT INTO `table_columns` VALUES ('automation_processes',2,'poller_id','int(10 ) unsigned','YES','','1','');
INSERT INTO `table_columns` VALUES ('automation_processes',3,'network_id','int(1 0) unsigned','NO','PRI','0',''); INSERT INTO `table_columns` VALUES ('automation_processes',3,'network_id','int(1 0) unsigned','NO','PRI','0','');
INSERT INTO `table_columns` VALUES ('automation_processes',4,'task','varchar(20) ','YES','','',''); INSERT INTO `table_columns` VALUES ('automation_processes',4,'task','varchar(20) ','YES','','','');
INSERT INTO `table_columns` VALUES ('automation_processes',5,'status','varchar(2 0)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('automation_processes',5,'status','varchar(2 0)','YES','',NULL,'');
INSERT INTO `table_columns` VALUES ('automation_processes',6,'command','varchar( 20)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('automation_processes',6,'command','varchar( 20)','YES','',NULL,'');
INSERT INTO `table_columns` VALUES ('automation_processes',7,'up_hosts','int(10) unsigned','YES','','0',''); INSERT INTO `table_columns` VALUES ('automation_processes',7,'up_hosts','int(10) unsigned','YES','','0','');
INSERT INTO `table_columns` VALUES ('automation_processes',8,'snmp_hosts','int(1 0) unsigned','YES','','0',''); INSERT INTO `table_columns` VALUES ('automation_processes',8,'snmp_hosts','int(1 0) unsigned','YES','','0','');
INSERT INTO `table_columns` VALUES ('automation_processes',9,'heartbeat','timest amp','NO','','0000-00-00 00:00:00',''); INSERT INTO `table_columns` VALUES ('automation_processes',9,'heartbeat','timest amp','NO','','0000-00-00 00:00:00','');
INSERT INTO `table_columns` VALUES ('automation_snmp',1,'id','int(10) unsigned', 'NO','PRI',NULL,'auto_increment'); INSERT INTO `table_columns` VALUES ('automation_snmp',1,'id','int(10) unsigned', 'NO','PRI',NULL,'auto_increment');
INSERT INTO `table_columns` VALUES ('automation_snmp',2,'name','varchar(100)','N O','','',''); INSERT INTO `table_columns` VALUES ('automation_snmp',2,'name','varchar(100)','N O','','','');
INSERT INTO `table_columns` VALUES ('automation_snmp_items',1,'id','int(10) unsi gned','NO','PRI',NULL,'auto_increment'); INSERT INTO `table_columns` VALUES ('automation_snmp_items',1,'id','int(10) unsi gned','NO','PRI',NULL,'auto_increment');
INSERT INTO `table_columns` VALUES ('automation_snmp_items',2,'snmp_id','int(10) unsigned','NO','PRI','0',''); INSERT INTO `table_columns` VALUES ('automation_snmp_items',2,'snmp_id','int(10) unsigned','NO','PRI','0','');
INSERT INTO `table_columns` VALUES ('automation_snmp_items',3,'sequence','int(10 ) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('automation_snmp_items',3,'sequence','int(10 ) unsigned','NO','','0','');
INSERT INTO `table_columns` VALUES ('automation_snmp_items',4,'snmp_version','ti nyint(1) unsigned','NO','','1',''); INSERT INTO `table_columns` VALUES ('automation_snmp_items',4,'snmp_version','ti nyint(3) unsigned','NO','','1','');
INSERT INTO `table_columns` VALUES ('automation_snmp_items',5,'snmp_community',' varchar(100)','NO','',NULL,''); INSERT INTO `table_columns` VALUES ('automation_snmp_items',5,'snmp_community',' varchar(100)','NO','',NULL,'');
INSERT INTO `table_columns` VALUES ('automation_snmp_items',6,'snmp_port','mediu mint(5) unsigned','NO','','161',''); INSERT INTO `table_columns` VALUES ('automation_snmp_items',6,'snmp_port','mediu mint(8) unsigned','NO','','161','');
INSERT INTO `table_columns` VALUES ('automation_snmp_items',7,'snmp_timeout','in t(10) unsigned','NO','','500',''); INSERT INTO `table_columns` VALUES ('automation_snmp_items',7,'snmp_timeout','in t(10) unsigned','NO','','500','');
INSERT INTO `table_columns` VALUES ('automation_snmp_items',8,'snmp_retries','ti INSERT INTO `table_columns` VALUES ('automation_snmp_items',8,'snmp_retries','ti
nyint(1) unsigned','NO','','3',''); nyint(3) unsigned','NO','','3','');
INSERT INTO `table_columns` VALUES ('automation_snmp_items',9,'max_oids','int(12 INSERT INTO `table_columns` VALUES ('automation_snmp_items',9,'max_oids','int(10
) unsigned','YES','','10',''); ) unsigned','YES','','10','');
INSERT INTO `table_columns` VALUES ('automation_snmp_items',10,'bulk_walk_size', 'int(11)','YES','','-1',''); INSERT INTO `table_columns` VALUES ('automation_snmp_items',10,'bulk_walk_size', 'int(11)','YES','','-1','');
INSERT INTO `table_columns` VALUES ('automation_snmp_items',11,'snmp_username',' varchar(50)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('automation_snmp_items',11,'snmp_username',' varchar(50)','YES','',NULL,'');
INSERT INTO `table_columns` VALUES ('automation_snmp_items',12,'snmp_password',' varchar(50)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('automation_snmp_items',12,'snmp_password',' varchar(50)','YES','',NULL,'');
INSERT INTO `table_columns` VALUES ('automation_snmp_items',13,'snmp_auth_protoc ol','char(6)','YES','','',''); INSERT INTO `table_columns` VALUES ('automation_snmp_items',13,'snmp_auth_protoc ol','char(6)','YES','','','');
INSERT INTO `table_columns` VALUES ('automation_snmp_items',14,'snmp_priv_passph rase','varchar(200)','YES','','',''); INSERT INTO `table_columns` VALUES ('automation_snmp_items',14,'snmp_priv_passph rase','varchar(200)','YES','','','');
INSERT INTO `table_columns` VALUES ('automation_snmp_items',15,'snmp_priv_protoc ol','char(6)','YES','','',''); INSERT INTO `table_columns` VALUES ('automation_snmp_items',15,'snmp_priv_protoc ol','char(6)','YES','','','');
INSERT INTO `table_columns` VALUES ('automation_snmp_items',16,'snmp_context','v archar(64)','YES','','',''); INSERT INTO `table_columns` VALUES ('automation_snmp_items',16,'snmp_context','v archar(64)','YES','','','');
INSERT INTO `table_columns` VALUES ('automation_snmp_items',17,'snmp_engine_id', 'varchar(64)','YES','','',''); INSERT INTO `table_columns` VALUES ('automation_snmp_items',17,'snmp_engine_id', 'varchar(64)','YES','','','');
INSERT INTO `table_columns` VALUES ('automation_templates',1,'id','int(8)','NO', INSERT INTO `table_columns` VALUES ('automation_templates',1,'id','int(10) unsig
'PRI',NULL,'auto_increment'); ned','NO','PRI',NULL,'auto_increment');
INSERT INTO `table_columns` VALUES ('automation_templates',2,'host_template','in INSERT INTO `table_columns` VALUES ('automation_templates',2,'host_template','in
t(8)','NO','','0',''); t(10) unsigned','NO','','0','');
INSERT INTO `table_columns` VALUES ('automation_templates',3,'availability_metho d','int(10) unsigned','YES','','2',''); INSERT INTO `table_columns` VALUES ('automation_templates',3,'availability_metho d','int(10) unsigned','YES','','2','');
INSERT INTO `table_columns` VALUES ('automation_templates',4,'sysDescr','varchar (255)','YES','','',''); INSERT INTO `table_columns` VALUES ('automation_templates',4,'sysDescr','varchar (255)','YES','','','');
INSERT INTO `table_columns` VALUES ('automation_templates',5,'sysName','varchar( 255)','YES','','',''); INSERT INTO `table_columns` VALUES ('automation_templates',5,'sysName','varchar( 255)','YES','','','');
INSERT INTO `table_columns` VALUES ('automation_templates',6,'sysOid','varchar(6 0)','YES','','',''); INSERT INTO `table_columns` VALUES ('automation_templates',6,'sysOid','varchar(6 0)','YES','','','');
INSERT INTO `table_columns` VALUES ('automation_templates',7,'sequence','int(10) unsigned','YES','','0',''); INSERT INTO `table_columns` VALUES ('automation_templates',7,'sequence','int(10) unsigned','YES','','0','');
INSERT INTO `table_columns` VALUES ('automation_tree_rule_items',1,'id','mediumi nt(8) unsigned','NO','PRI',NULL,'auto_increment'); INSERT INTO `table_columns` VALUES ('automation_tree_rule_items',1,'id','mediumi nt(8) unsigned','NO','PRI',NULL,'auto_increment');
INSERT INTO `table_columns` VALUES ('automation_tree_rule_items',2,'rule_id','me diumint(8) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('automation_tree_rule_items',2,'rule_id','me diumint(8) unsigned','NO','','0','');
INSERT INTO `table_columns` VALUES ('automation_tree_rule_items',3,'sequence','s mallint(3) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('automation_tree_rule_items',3,'sequence','s mallint(3) unsigned','NO','','0','');
INSERT INTO `table_columns` VALUES ('automation_tree_rule_items',4,'field','varc har(255)','NO','','',''); INSERT INTO `table_columns` VALUES ('automation_tree_rule_items',4,'field','varc har(255)','NO','','','');
INSERT INTO `table_columns` VALUES ('automation_tree_rule_items',5,'sort_type',' smallint(3) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('automation_tree_rule_items',5,'sort_type',' smallint(3) unsigned','NO','','0','');
skipping to change at line 300 skipping to change at line 300
INSERT INTO `table_columns` VALUES ('automation_tree_rules',6,'host_grouping_typ e','smallint(3) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('automation_tree_rules',6,'host_grouping_typ e','smallint(3) unsigned','NO','','0','');
INSERT INTO `table_columns` VALUES ('automation_tree_rules',7,'enabled','char(2) ','YES','','',''); INSERT INTO `table_columns` VALUES ('automation_tree_rules',7,'enabled','char(2) ','YES','','','');
INSERT INTO `table_columns` VALUES ('cdef',1,'id','mediumint(8) unsigned','NO',' PRI',NULL,'auto_increment'); INSERT INTO `table_columns` VALUES ('cdef',1,'id','mediumint(8) unsigned','NO',' PRI',NULL,'auto_increment');
INSERT INTO `table_columns` VALUES ('cdef',2,'hash','varchar(32)','NO','MUL','', ''); INSERT INTO `table_columns` VALUES ('cdef',2,'hash','varchar(32)','NO','MUL','', '');
INSERT INTO `table_columns` VALUES ('cdef',3,'system','mediumint(8) unsigned','N O','','0',''); INSERT INTO `table_columns` VALUES ('cdef',3,'system','mediumint(8) unsigned','N O','','0','');
INSERT INTO `table_columns` VALUES ('cdef',4,'name','varchar(255)','NO','MUL','' ,''); INSERT INTO `table_columns` VALUES ('cdef',4,'name','varchar(255)','NO','MUL','' ,'');
INSERT INTO `table_columns` VALUES ('cdef_items',1,'id','mediumint(8) unsigned', 'NO','PRI',NULL,'auto_increment'); INSERT INTO `table_columns` VALUES ('cdef_items',1,'id','mediumint(8) unsigned', 'NO','PRI',NULL,'auto_increment');
INSERT INTO `table_columns` VALUES ('cdef_items',2,'hash','varchar(32)','NO','', '',''); INSERT INTO `table_columns` VALUES ('cdef_items',2,'hash','varchar(32)','NO','', '','');
INSERT INTO `table_columns` VALUES ('cdef_items',3,'cdef_id','mediumint(8) unsig ned','NO','MUL','0',''); INSERT INTO `table_columns` VALUES ('cdef_items',3,'cdef_id','mediumint(8) unsig ned','NO','MUL','0','');
INSERT INTO `table_columns` VALUES ('cdef_items',4,'sequence','mediumint(8) unsi gned','NO','','0',''); INSERT INTO `table_columns` VALUES ('cdef_items',4,'sequence','mediumint(8) unsi gned','NO','','0','');
INSERT INTO `table_columns` VALUES ('cdef_items',5,'type','tinyint(2)','NO','',' 0',''); INSERT INTO `table_columns` VALUES ('cdef_items',5,'type','tinyint(3) unsigned', 'NO','','0','');
INSERT INTO `table_columns` VALUES ('cdef_items',6,'value','varchar(150)','NO',' ','',''); INSERT INTO `table_columns` VALUES ('cdef_items',6,'value','varchar(150)','NO',' ','','');
INSERT INTO `table_columns` VALUES ('color_template_items',1,'color_template_ite m_id','int(12) unsigned','NO','PRI',NULL,'auto_increment'); INSERT INTO `table_columns` VALUES ('color_template_items',1,'color_template_ite m_id','int(10) unsigned','NO','PRI',NULL,'auto_increment');
INSERT INTO `table_columns` VALUES ('color_template_items',2,'color_template_id' ,'mediumint(8) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('color_template_items',2,'color_template_id' ,'mediumint(8) unsigned','NO','','0','');
INSERT INTO `table_columns` VALUES ('color_template_items',3,'color_id','mediumi nt(8) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('color_template_items',3,'color_id','mediumi nt(8) unsigned','NO','','0','');
INSERT INTO `table_columns` VALUES ('color_template_items',4,'sequence','mediumi nt(8) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('color_template_items',4,'sequence','mediumi nt(8) unsigned','NO','','0','');
INSERT INTO `table_columns` VALUES ('color_templates',1,'color_template_id','med iumint(8) unsigned','NO','PRI',NULL,'auto_increment'); INSERT INTO `table_columns` VALUES ('color_templates',1,'color_template_id','med iumint(8) unsigned','NO','PRI',NULL,'auto_increment');
INSERT INTO `table_columns` VALUES ('color_templates',2,'name','varchar(255)','N O','','',''); INSERT INTO `table_columns` VALUES ('color_templates',2,'name','varchar(255)','N O','','','');
INSERT INTO `table_columns` VALUES ('colors',1,'id','mediumint(8) unsigned','NO' ,'PRI',NULL,'auto_increment'); INSERT INTO `table_columns` VALUES ('colors',1,'id','mediumint(8) unsigned','NO' ,'PRI',NULL,'auto_increment');
INSERT INTO `table_columns` VALUES ('colors',2,'name','varchar(40)','YES','','', ''); INSERT INTO `table_columns` VALUES ('colors',2,'name','varchar(40)','YES','','', '');
INSERT INTO `table_columns` VALUES ('colors',3,'hex','varchar(6)','NO','UNI','', ''); INSERT INTO `table_columns` VALUES ('colors',3,'hex','varchar(6)','NO','UNI','', '');
INSERT INTO `table_columns` VALUES ('colors',4,'read_only','char(2)','YES','','' ,''); INSERT INTO `table_columns` VALUES ('colors',4,'read_only','char(2)','YES','','' ,'');
INSERT INTO `table_columns` VALUES ('data_debug',1,'id','int(11) unsigned','NO', INSERT INTO `table_columns` VALUES ('data_debug',1,'id','int(10) unsigned','NO',
'PRI',NULL,'auto_increment'); 'PRI',NULL,'auto_increment');
INSERT INTO `table_columns` VALUES ('data_debug',2,'started','int(11)','NO','MUL INSERT INTO `table_columns` VALUES ('data_debug',2,'started','int(10) unsigned',
','0',''); 'NO','MUL','0','');
INSERT INTO `table_columns` VALUES ('data_debug',3,'done','int(11)','NO','MUL',' INSERT INTO `table_columns` VALUES ('data_debug',3,'done','int(10) unsigned','NO
0',''); ','MUL','0','');
INSERT INTO `table_columns` VALUES ('data_debug',4,'user','int(11)','NO','MUL',' INSERT INTO `table_columns` VALUES ('data_debug',4,'user','int(10) unsigned','NO
0',''); ','MUL','0','');
INSERT INTO `table_columns` VALUES ('data_debug',5,'datasource','int(11)','NO',' INSERT INTO `table_columns` VALUES ('data_debug',5,'datasource','int(10) unsigne
MUL','0',''); d','NO','MUL','0','');
INSERT INTO `table_columns` VALUES ('data_debug',6,'info','text','NO','',NULL,'' ); INSERT INTO `table_columns` VALUES ('data_debug',6,'info','text','NO','',NULL,'' );
INSERT INTO `table_columns` VALUES ('data_debug',7,'issue','text','NO','',NULL,' '); INSERT INTO `table_columns` VALUES ('data_debug',7,'issue','text','NO','',NULL,' ');
INSERT INTO `table_columns` VALUES ('data_input',1,'id','mediumint(8) unsigned', 'NO','PRI',NULL,'auto_increment'); INSERT INTO `table_columns` VALUES ('data_input',1,'id','mediumint(8) unsigned', 'NO','PRI',NULL,'auto_increment');
INSERT INTO `table_columns` VALUES ('data_input',2,'hash','varchar(32)','NO','', '',''); INSERT INTO `table_columns` VALUES ('data_input',2,'hash','varchar(32)','NO','', '','');
INSERT INTO `table_columns` VALUES ('data_input',3,'name','varchar(200)','NO','M UL','',''); INSERT INTO `table_columns` VALUES ('data_input',3,'name','varchar(200)','NO','M UL','','');
INSERT INTO `table_columns` VALUES ('data_input',4,'input_string','varchar(512)' ,'YES','',NULL,''); INSERT INTO `table_columns` VALUES ('data_input',4,'input_string','varchar(512)' ,'YES','',NULL,'');
INSERT INTO `table_columns` VALUES ('data_input',5,'type_id','tinyint(2)','NO',' ','0',''); INSERT INTO `table_columns` VALUES ('data_input',5,'type_id','tinyint(3) unsigne d','NO','','0','');
INSERT INTO `table_columns` VALUES ('data_input_data',1,'data_input_field_id','m ediumint(8) unsigned','NO','PRI','0',''); INSERT INTO `table_columns` VALUES ('data_input_data',1,'data_input_field_id','m ediumint(8) unsigned','NO','PRI','0','');
INSERT INTO `table_columns` VALUES ('data_input_data',2,'data_template_data_id', 'int(10) unsigned','NO','PRI','0',''); INSERT INTO `table_columns` VALUES ('data_input_data',2,'data_template_data_id', 'int(10) unsigned','NO','PRI','0','');
INSERT INTO `table_columns` VALUES ('data_input_data',3,'t_value','char(2)','YES ','MUL',NULL,''); INSERT INTO `table_columns` VALUES ('data_input_data',3,'t_value','char(2)','YES ','MUL',NULL,'');
INSERT INTO `table_columns` VALUES ('data_input_data',4,'value','text','YES','', NULL,''); INSERT INTO `table_columns` VALUES ('data_input_data',4,'value','text','YES','', NULL,'');
INSERT INTO `table_columns` VALUES ('data_input_fields',1,'id','mediumint(8) uns igned','NO','PRI',NULL,'auto_increment'); INSERT INTO `table_columns` VALUES ('data_input_fields',1,'id','mediumint(8) uns igned','NO','PRI',NULL,'auto_increment');
INSERT INTO `table_columns` VALUES ('data_input_fields',2,'hash','varchar(32)',' NO','','',''); INSERT INTO `table_columns` VALUES ('data_input_fields',2,'hash','varchar(32)',' NO','','','');
INSERT INTO `table_columns` VALUES ('data_input_fields',3,'data_input_id','mediu mint(8) unsigned','NO','MUL','0',''); INSERT INTO `table_columns` VALUES ('data_input_fields',3,'data_input_id','mediu mint(8) unsigned','NO','MUL','0','');
INSERT INTO `table_columns` VALUES ('data_input_fields',4,'name','varchar(200)', 'NO','','',''); INSERT INTO `table_columns` VALUES ('data_input_fields',4,'name','varchar(200)', 'NO','','','');
INSERT INTO `table_columns` VALUES ('data_input_fields',5,'data_name','varchar(5 0)','NO','','',''); INSERT INTO `table_columns` VALUES ('data_input_fields',5,'data_name','varchar(5 0)','NO','','','');
INSERT INTO `table_columns` VALUES ('data_input_fields',6,'input_output','char(3 )','NO','MUL','',''); INSERT INTO `table_columns` VALUES ('data_input_fields',6,'input_output','char(3 )','NO','MUL','','');
INSERT INTO `table_columns` VALUES ('data_input_fields',7,'update_rra','char(2)' ,'YES','','0',''); INSERT INTO `table_columns` VALUES ('data_input_fields',7,'update_rra','char(2)' ,'YES','','0','');
INSERT INTO `table_columns` VALUES ('data_input_fields',8,'sequence','smallint(5 )','NO','','0',''); INSERT INTO `table_columns` VALUES ('data_input_fields',8,'sequence','smallint(5 )','NO','','0','');
INSERT INTO `table_columns` VALUES ('data_input_fields',9,'type_code','varchar(4 0)','YES','MUL',NULL,''); INSERT INTO `table_columns` VALUES ('data_input_fields',9,'type_code','varchar(4 0)','YES','MUL',NULL,'');
INSERT INTO `table_columns` VALUES ('data_input_fields',10,'regexp_match','varch ar(200)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('data_input_fields',10,'regexp_match','varch ar(200)','YES','',NULL,'');
INSERT INTO `table_columns` VALUES ('data_input_fields',11,'allow_nulls','char(2 )','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('data_input_fields',11,'allow_nulls','char(2 )','YES','',NULL,'');
INSERT INTO `table_columns` VALUES ('data_local',1,'id','int(10) unsigned','NO', 'PRI',NULL,'auto_increment'); INSERT INTO `table_columns` VALUES ('data_local',1,'id','int(10) unsigned','NO', 'PRI',NULL,'auto_increment');
INSERT INTO `table_columns` VALUES ('data_local',2,'data_template_id','mediumint (8) unsigned','NO','MUL','0',''); INSERT INTO `table_columns` VALUES ('data_local',2,'data_template_id','mediumint (8) unsigned','NO','MUL','0','');
INSERT INTO `table_columns` VALUES ('data_local',3,'host_id','mediumint(8) unsig ned','NO','MUL','0',''); INSERT INTO `table_columns` VALUES ('data_local',3,'host_id','mediumint(8) unsig ned','NO','MUL','0','');
INSERT INTO `table_columns` VALUES ('data_local',4,'snmp_query_id','mediumint(8) ','NO','MUL','0',''); INSERT INTO `table_columns` VALUES ('data_local',4,'snmp_query_id','mediumint(8) ','NO','MUL','0','');
INSERT INTO `table_columns` VALUES ('data_local',5,'snmp_index','varchar(255)',' NO','MUL','',''); INSERT INTO `table_columns` VALUES ('data_local',5,'snmp_index','varchar(255)',' NO','MUL','','');
INSERT INTO `table_columns` VALUES ('data_local',6,'orphan','tinyint(1) unsigned ','NO','','0',''); INSERT INTO `table_columns` VALUES ('data_local',6,'orphan','tinyint(3) unsigned ','NO','','0','');
INSERT INTO `table_columns` VALUES ('data_source_profiles',1,'id','mediumint(8) unsigned','NO','PRI',NULL,'auto_increment'); INSERT INTO `table_columns` VALUES ('data_source_profiles',1,'id','mediumint(8) unsigned','NO','PRI',NULL,'auto_increment');
INSERT INTO `table_columns` VALUES ('data_source_profiles',2,'hash','varchar(32) ','NO','','',''); INSERT INTO `table_columns` VALUES ('data_source_profiles',2,'hash','varchar(32) ','NO','','','');
INSERT INTO `table_columns` VALUES ('data_source_profiles',3,'name','varchar(255 )','NO','MUL','',''); INSERT INTO `table_columns` VALUES ('data_source_profiles',3,'name','varchar(255 )','NO','MUL','','');
INSERT INTO `table_columns` VALUES ('data_source_profiles',4,'step','int(10) uns igned','NO','','300',''); INSERT INTO `table_columns` VALUES ('data_source_profiles',4,'step','int(10) uns igned','NO','','300','');
INSERT INTO `table_columns` VALUES ('data_source_profiles',5,'heartbeat','int(10 ) unsigned','NO','','600',''); INSERT INTO `table_columns` VALUES ('data_source_profiles',5,'heartbeat','int(10 ) unsigned','NO','','600','');
INSERT INTO `table_columns` VALUES ('data_source_profiles',6,'x_files_factor','d ouble','YES','','0.5',''); INSERT INTO `table_columns` VALUES ('data_source_profiles',6,'x_files_factor','d ouble','YES','','0.5','');
INSERT INTO `table_columns` VALUES ('data_source_profiles',7,'default','char(2)' ,'YES','','',''); INSERT INTO `table_columns` VALUES ('data_source_profiles',7,'default','char(2)' ,'YES','','','');
INSERT INTO `table_columns` VALUES ('data_source_profiles_cf',1,'data_source_pro file_id','mediumint(8) unsigned','NO','PRI','0',''); INSERT INTO `table_columns` VALUES ('data_source_profiles_cf',1,'data_source_pro file_id','mediumint(8) unsigned','NO','PRI','0','');
INSERT INTO `table_columns` VALUES ('data_source_profiles_cf',2,'consolidation_f unction_id','smallint(5) unsigned','NO','PRI','0',''); INSERT INTO `table_columns` VALUES ('data_source_profiles_cf',2,'consolidation_f unction_id','smallint(5) unsigned','NO','PRI','0','');
INSERT INTO `table_columns` VALUES ('data_source_profiles_rra',1,'id','mediumint (8) unsigned','NO','PRI',NULL,'auto_increment'); INSERT INTO `table_columns` VALUES ('data_source_profiles_rra',1,'id','mediumint (8) unsigned','NO','PRI',NULL,'auto_increment');
INSERT INTO `table_columns` VALUES ('data_source_profiles_rra',2,'data_source_pr ofile_id','mediumint(8) unsigned','NO','MUL','0',''); INSERT INTO `table_columns` VALUES ('data_source_profiles_rra',2,'data_source_pr ofile_id','mediumint(8) unsigned','NO','MUL','0','');
INSERT INTO `table_columns` VALUES ('data_source_profiles_rra',3,'name','varchar (255)','NO','','',''); INSERT INTO `table_columns` VALUES ('data_source_profiles_rra',3,'name','varchar (255)','NO','','','');
INSERT INTO `table_columns` VALUES ('data_source_profiles_rra',4,'steps','int(10 ) unsigned','YES','','1',''); INSERT INTO `table_columns` VALUES ('data_source_profiles_rra',4,'steps','int(10 ) unsigned','YES','','1','');
INSERT INTO `table_columns` VALUES ('data_source_profiles_rra',5,'rows','int(10) unsigned','NO','','700',''); INSERT INTO `table_columns` VALUES ('data_source_profiles_rra',5,'rows','int(10) unsigned','NO','','700','');
INSERT INTO `table_columns` VALUES ('data_source_profiles_rra',6,'timespan','int (10) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('data_source_profiles_rra',6,'timespan','int (10) unsigned','NO','','0','');
INSERT INTO `table_columns` VALUES ('data_source_purge_action',1,'id','int(10) u nsigned','NO','PRI',NULL,'auto_increment'); INSERT INTO `table_columns` VALUES ('data_source_purge_action',1,'id','int(10) u nsigned','NO','PRI',NULL,'auto_increment');
INSERT INTO `table_columns` VALUES ('data_source_purge_action',2,'name','varchar (128)','NO','UNI','',''); INSERT INTO `table_columns` VALUES ('data_source_purge_action',2,'name','varchar (128)','NO','UNI','','');
INSERT INTO `table_columns` VALUES ('data_source_purge_action',3,'local_data_id' ,'int(10) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('data_source_purge_action',3,'local_data_id' ,'int(10) unsigned','NO','','0','');
INSERT INTO `table_columns` VALUES ('data_source_purge_action',4,'action','tinyi nt(2)','NO','','0',''); INSERT INTO `table_columns` VALUES ('data_source_purge_action',4,'action','tinyi nt(3) unsigned','NO','','0','');
INSERT INTO `table_columns` VALUES ('data_source_purge_temp',1,'id','int(10) uns igned','NO','PRI',NULL,'auto_increment'); INSERT INTO `table_columns` VALUES ('data_source_purge_temp',1,'id','int(10) uns igned','NO','PRI',NULL,'auto_increment');
INSERT INTO `table_columns` VALUES ('data_source_purge_temp',2,'name_cache','var char(255)','NO','','',''); INSERT INTO `table_columns` VALUES ('data_source_purge_temp',2,'name_cache','var char(255)','NO','','','');
INSERT INTO `table_columns` VALUES ('data_source_purge_temp',3,'local_data_id',' int(10) unsigned','NO','MUL','0',''); INSERT INTO `table_columns` VALUES ('data_source_purge_temp',3,'local_data_id',' int(10) unsigned','NO','MUL','0','');
INSERT INTO `table_columns` VALUES ('data_source_purge_temp',4,'name','varchar(1 28)','NO','UNI','',''); INSERT INTO `table_columns` VALUES ('data_source_purge_temp',4,'name','varchar(1 28)','NO','UNI','','');
INSERT INTO `table_columns` VALUES ('data_source_purge_temp',5,'size','int(10) u nsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('data_source_purge_temp',5,'size','int(10) u nsigned','NO','','0','');
INSERT INTO `table_columns` VALUES ('data_source_purge_temp',6,'last_mod','times tamp','NO','','0000-00-00 00:00:00',''); INSERT INTO `table_columns` VALUES ('data_source_purge_temp',6,'last_mod','times tamp','NO','','0000-00-00 00:00:00','');
INSERT INTO `table_columns` VALUES ('data_source_purge_temp',7,'in_cacti','tinyi nt(4)','NO','MUL','0',''); INSERT INTO `table_columns` VALUES ('data_source_purge_temp',7,'in_cacti','tinyi nt(3) unsigned','NO','MUL','0','');
INSERT INTO `table_columns` VALUES ('data_source_purge_temp',8,'data_template_id ','mediumint(8) unsigned','NO','MUL','0',''); INSERT INTO `table_columns` VALUES ('data_source_purge_temp',8,'data_template_id ','mediumint(8) unsigned','NO','MUL','0','');
INSERT INTO `table_columns` VALUES ('data_source_stats_daily',1,'local_data_id', 'int(10) unsigned','NO','PRI',NULL,''); INSERT INTO `table_columns` VALUES ('data_source_stats_daily',1,'local_data_id', 'int(10) unsigned','NO','PRI',NULL,'');
INSERT INTO `table_columns` VALUES ('data_source_stats_daily',2,'rrd_name','varc har(19)','NO','PRI',NULL,''); INSERT INTO `table_columns` VALUES ('data_source_stats_daily',2,'rrd_name','varc har(19)','NO','PRI',NULL,'');
INSERT INTO `table_columns` VALUES ('data_source_stats_daily',3,'average','doubl e','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('data_source_stats_daily',3,'average','doubl e','YES','',NULL,'');
INSERT INTO `table_columns` VALUES ('data_source_stats_daily',4,'peak','double', 'YES','',NULL,''); INSERT INTO `table_columns` VALUES ('data_source_stats_daily',4,'peak','double', 'YES','',NULL,'');
INSERT INTO `table_columns` VALUES ('data_source_stats_hourly',1,'local_data_id' ,'int(10) unsigned','NO','PRI',NULL,''); INSERT INTO `table_columns` VALUES ('data_source_stats_hourly',1,'local_data_id' ,'int(10) unsigned','NO','PRI',NULL,'');
INSERT INTO `table_columns` VALUES ('data_source_stats_hourly',2,'rrd_name','var char(19)','NO','PRI',NULL,''); INSERT INTO `table_columns` VALUES ('data_source_stats_hourly',2,'rrd_name','var char(19)','NO','PRI',NULL,'');
INSERT INTO `table_columns` VALUES ('data_source_stats_hourly',3,'average','doub le','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('data_source_stats_hourly',3,'average','doub le','YES','',NULL,'');
INSERT INTO `table_columns` VALUES ('data_source_stats_hourly',4,'peak','double' ,'YES','',NULL,''); INSERT INTO `table_columns` VALUES ('data_source_stats_hourly',4,'peak','double' ,'YES','',NULL,'');
INSERT INTO `table_columns` VALUES ('data_source_stats_hourly_cache',1,'local_da ta_id','int(10) unsigned','NO','PRI',NULL,''); INSERT INTO `table_columns` VALUES ('data_source_stats_hourly_cache',1,'local_da ta_id','int(10) unsigned','NO','PRI',NULL,'');
skipping to change at line 435 skipping to change at line 435
INSERT INTO `table_columns` VALUES ('data_template_rrd',8,'t_rrd_minimum','char( 2)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('data_template_rrd',8,'t_rrd_minimum','char( 2)','YES','',NULL,'');
INSERT INTO `table_columns` VALUES ('data_template_rrd',9,'rrd_minimum','varchar (20)','NO','','0',''); INSERT INTO `table_columns` VALUES ('data_template_rrd',9,'rrd_minimum','varchar (20)','NO','','0','');
INSERT INTO `table_columns` VALUES ('data_template_rrd',10,'t_rrd_heartbeat','ch ar(2)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('data_template_rrd',10,'t_rrd_heartbeat','ch ar(2)','YES','',NULL,'');
INSERT INTO `table_columns` VALUES ('data_template_rrd',11,'rrd_heartbeat','medi umint(6)','NO','','0',''); INSERT INTO `table_columns` VALUES ('data_template_rrd',11,'rrd_heartbeat','medi umint(6)','NO','','0','');
INSERT INTO `table_columns` VALUES ('data_template_rrd',12,'t_data_source_type_i d','char(2)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('data_template_rrd',12,'t_data_source_type_i d','char(2)','YES','',NULL,'');
INSERT INTO `table_columns` VALUES ('data_template_rrd',13,'data_source_type_id' ,'smallint(5)','NO','','0',''); INSERT INTO `table_columns` VALUES ('data_template_rrd',13,'data_source_type_id' ,'smallint(5)','NO','','0','');
INSERT INTO `table_columns` VALUES ('data_template_rrd',14,'t_data_source_name', 'char(2)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('data_template_rrd',14,'t_data_source_name', 'char(2)','YES','',NULL,'');
INSERT INTO `table_columns` VALUES ('data_template_rrd',15,'data_source_name','v archar(19)','NO','','',''); INSERT INTO `table_columns` VALUES ('data_template_rrd',15,'data_source_name','v archar(19)','NO','','','');
INSERT INTO `table_columns` VALUES ('data_template_rrd',16,'t_data_input_field_i d','char(2)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('data_template_rrd',16,'t_data_input_field_i d','char(2)','YES','',NULL,'');
INSERT INTO `table_columns` VALUES ('data_template_rrd',17,'data_input_field_id' ,'mediumint(8) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('data_template_rrd',17,'data_input_field_id' ,'mediumint(8) unsigned','NO','','0','');
INSERT INTO `table_columns` VALUES ('external_links',1,'id','int(11)','NO','PRI' INSERT INTO `table_columns` VALUES ('external_links',1,'id','int(10) unsigned','
,NULL,'auto_increment'); NO','PRI',NULL,'auto_increment');
INSERT INTO `table_columns` VALUES ('external_links',2,'sortorder','int(11)','NO INSERT INTO `table_columns` VALUES ('external_links',2,'sortorder','int(10) unsi
','','0',''); gned','NO','','0','');
INSERT INTO `table_columns` VALUES ('external_links',3,'enabled','char(2)','YES' ,'','on',''); INSERT INTO `table_columns` VALUES ('external_links',3,'enabled','char(2)','YES' ,'','on','');
INSERT INTO `table_columns` VALUES ('external_links',4,'contentfile','varchar(25 5)','NO','','',''); INSERT INTO `table_columns` VALUES ('external_links',4,'contentfile','varchar(25 5)','NO','','','');
INSERT INTO `table_columns` VALUES ('external_links',5,'title','varchar(20)','NO ','','',''); INSERT INTO `table_columns` VALUES ('external_links',5,'title','varchar(20)','NO ','','','');
INSERT INTO `table_columns` VALUES ('external_links',6,'style','varchar(10)','NO ','','',''); INSERT INTO `table_columns` VALUES ('external_links',6,'style','varchar(10)','NO ','','','');
INSERT INTO `table_columns` VALUES ('external_links',7,'extendedstyle','varchar( 50)','NO','','',''); INSERT INTO `table_columns` VALUES ('external_links',7,'extendedstyle','varchar( 50)','NO','','','');
INSERT INTO `table_columns` VALUES ('external_links',8,'refresh','int(10) unsign ed','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('external_links',8,'refresh','int(10) unsign ed','YES','',NULL,'');
INSERT INTO `table_columns` VALUES ('graph_local',1,'id','int(10) unsigned','NO' ,'PRI',NULL,'auto_increment'); INSERT INTO `table_columns` VALUES ('graph_local',1,'id','int(10) unsigned','NO' ,'PRI',NULL,'auto_increment');
INSERT INTO `table_columns` VALUES ('graph_local',2,'graph_template_id','mediumi nt(8) unsigned','NO','MUL','0',''); INSERT INTO `table_columns` VALUES ('graph_local',2,'graph_template_id','mediumi nt(8) unsigned','NO','MUL','0','');
INSERT INTO `table_columns` VALUES ('graph_local',3,'host_id','mediumint(8) unsi gned','NO','MUL','0',''); INSERT INTO `table_columns` VALUES ('graph_local',3,'host_id','mediumint(8) unsi gned','NO','MUL','0','');
INSERT INTO `table_columns` VALUES ('graph_local',4,'snmp_query_id','mediumint(8 )','NO','MUL','0',''); INSERT INTO `table_columns` VALUES ('graph_local',4,'snmp_query_id','mediumint(8 )','NO','MUL','0','');
INSERT INTO `table_columns` VALUES ('graph_local',5,'snmp_query_graph_id','mediu mint(8)','NO','MUL','0',''); INSERT INTO `table_columns` VALUES ('graph_local',5,'snmp_query_graph_id','mediu mint(8)','NO','MUL','0','');
INSERT INTO `table_columns` VALUES ('graph_local',6,'snmp_index','varchar(255)', 'NO','MUL','',''); INSERT INTO `table_columns` VALUES ('graph_local',6,'snmp_index','varchar(255)', 'NO','MUL','','');
INSERT INTO `table_columns` VALUES ('graph_template_input',1,'id','mediumint(8) unsigned','NO','PRI',NULL,'auto_increment'); INSERT INTO `table_columns` VALUES ('graph_template_input',1,'id','mediumint(8) unsigned','NO','PRI',NULL,'auto_increment');
INSERT INTO `table_columns` VALUES ('graph_template_input',2,'hash','varchar(32) ','NO','','',''); INSERT INTO `table_columns` VALUES ('graph_template_input',2,'hash','varchar(32) ','NO','','','');
INSERT INTO `table_columns` VALUES ('graph_template_input',3,'graph_template_id' ,'mediumint(8) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('graph_template_input',3,'graph_template_id' ,'mediumint(8) unsigned','NO','','0','');
INSERT INTO `table_columns` VALUES ('graph_template_input',4,'name','varchar(255 )','NO','','',''); INSERT INTO `table_columns` VALUES ('graph_template_input',4,'name','varchar(255 )','NO','','','');
INSERT INTO `table_columns` VALUES ('graph_template_input',5,'description','text ','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('graph_template_input',5,'description','text ','YES','',NULL,'');
INSERT INTO `table_columns` VALUES ('graph_template_input',6,'column_name','varc har(50)','NO','','',''); INSERT INTO `table_columns` VALUES ('graph_template_input',6,'column_name','varc har(50)','NO','','','');
INSERT INTO `table_columns` VALUES ('graph_template_input_defs',1,'graph_templat e_input_id','int(10) unsigned','NO','PRI','0',''); INSERT INTO `table_columns` VALUES ('graph_template_input_defs',1,'graph_templat e_input_id','int(10) unsigned','NO','PRI','0','');
INSERT INTO `table_columns` VALUES ('graph_template_input_defs',2,'graph_templat e_item_id','int(12) unsigned','NO','PRI','0',''); INSERT INTO `table_columns` VALUES ('graph_template_input_defs',2,'graph_templat e_item_id','int(10) unsigned','NO','PRI','0','');
INSERT INTO `table_columns` VALUES ('graph_templates',1,'id','mediumint(8) unsig ned','NO','PRI',NULL,'auto_increment'); INSERT INTO `table_columns` VALUES ('graph_templates',1,'id','mediumint(8) unsig ned','NO','PRI',NULL,'auto_increment');
INSERT INTO `table_columns` VALUES ('graph_templates',2,'hash','char(32)','NO',' ','',''); INSERT INTO `table_columns` VALUES ('graph_templates',2,'hash','char(32)','NO',' ','','');
INSERT INTO `table_columns` VALUES ('graph_templates',3,'name','char(255)','NO', 'MUL','',''); INSERT INTO `table_columns` VALUES ('graph_templates',3,'name','char(255)','NO', 'MUL','','');
INSERT INTO `table_columns` VALUES ('graph_templates',4,'multiple','char(2)','NO ','MUL','',''); INSERT INTO `table_columns` VALUES ('graph_templates',4,'multiple','char(2)','NO ','MUL','','');
INSERT INTO `table_columns` VALUES ('graph_templates',5,'test_source','char(2)', 'NO','','',''); INSERT INTO `table_columns` VALUES ('graph_templates',5,'test_source','char(2)', 'NO','','','');
INSERT INTO `table_columns` VALUES ('graph_templates_gprint',1,'id','mediumint(8 ) unsigned','NO','PRI',NULL,'auto_increment'); INSERT INTO `table_columns` VALUES ('graph_templates_gprint',1,'id','mediumint(8 ) unsigned','NO','PRI',NULL,'auto_increment');
INSERT INTO `table_columns` VALUES ('graph_templates_gprint',2,'hash','varchar(3 2)','NO','','',''); INSERT INTO `table_columns` VALUES ('graph_templates_gprint',2,'hash','varchar(3 2)','NO','','','');
INSERT INTO `table_columns` VALUES ('graph_templates_gprint',3,'name','varchar(1 00)','NO','MUL','',''); INSERT INTO `table_columns` VALUES ('graph_templates_gprint',3,'name','varchar(1 00)','NO','MUL','','');
INSERT INTO `table_columns` VALUES ('graph_templates_gprint',4,'gprint_text','va rchar(255)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('graph_templates_gprint',4,'gprint_text','va rchar(255)','YES','',NULL,'');
INSERT INTO `table_columns` VALUES ('graph_templates_graph',1,'id','int(10) unsi gned','NO','PRI',NULL,'auto_increment'); INSERT INTO `table_columns` VALUES ('graph_templates_graph',1,'id','int(10) unsi gned','NO','PRI',NULL,'auto_increment');
INSERT INTO `table_columns` VALUES ('graph_templates_graph',2,'local_graph_templ ate_graph_id','int(10) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('graph_templates_graph',2,'local_graph_templ ate_graph_id','int(10) unsigned','NO','','0','');
INSERT INTO `table_columns` VALUES ('graph_templates_graph',3,'local_graph_id',' int(10) unsigned','NO','MUL','0',''); INSERT INTO `table_columns` VALUES ('graph_templates_graph',3,'local_graph_id',' int(10) unsigned','NO','MUL','0','');
INSERT INTO `table_columns` VALUES ('graph_templates_graph',4,'graph_template_id ','mediumint(8) unsigned','NO','MUL','0',''); INSERT INTO `table_columns` VALUES ('graph_templates_graph',4,'graph_template_id ','mediumint(8) unsigned','NO','MUL','0','');
INSERT INTO `table_columns` VALUES ('graph_templates_graph',5,'t_image_format_id ','char(2)','YES','','',''); INSERT INTO `table_columns` VALUES ('graph_templates_graph',5,'t_image_format_id ','char(2)','YES','','','');
INSERT INTO `table_columns` VALUES ('graph_templates_graph',6,'image_format_id', 'tinyint(1)','NO','','0',''); INSERT INTO `table_columns` VALUES ('graph_templates_graph',6,'image_format_id', 'tinyint(3) unsigned','NO','','0','');
INSERT INTO `table_columns` VALUES ('graph_templates_graph',7,'t_title','char(2) ','YES','','',''); INSERT INTO `table_columns` VALUES ('graph_templates_graph',7,'t_title','char(2) ','YES','','','');
INSERT INTO `table_columns` VALUES ('graph_templates_graph',8,'title','varchar(2 55)','NO','','',''); INSERT INTO `table_columns` VALUES ('graph_templates_graph',8,'title','varchar(2 55)','NO','','','');
INSERT INTO `table_columns` VALUES ('graph_templates_graph',9,'title_cache','var char(255)','NO','MUL','',''); INSERT INTO `table_columns` VALUES ('graph_templates_graph',9,'title_cache','var char(255)','NO','MUL','','');
INSERT INTO `table_columns` VALUES ('graph_templates_graph',10,'t_height','char( 2)','YES','','',''); INSERT INTO `table_columns` VALUES ('graph_templates_graph',10,'t_height','char( 2)','YES','','','');
INSERT INTO `table_columns` VALUES ('graph_templates_graph',11,'height','mediumi nt(8)','NO','','0',''); INSERT INTO `table_columns` VALUES ('graph_templates_graph',11,'height','mediumi nt(8)','NO','','0','');
INSERT INTO `table_columns` VALUES ('graph_templates_graph',12,'t_width','char(2 )','YES','','',''); INSERT INTO `table_columns` VALUES ('graph_templates_graph',12,'t_width','char(2 )','YES','','','');
INSERT INTO `table_columns` VALUES ('graph_templates_graph',13,'width','mediumin t(8)','NO','','0',''); INSERT INTO `table_columns` VALUES ('graph_templates_graph',13,'width','mediumin t(8)','NO','','0','');
INSERT INTO `table_columns` VALUES ('graph_templates_graph',14,'t_upper_limit',' char(2)','YES','','',''); INSERT INTO `table_columns` VALUES ('graph_templates_graph',14,'t_upper_limit',' char(2)','YES','','','');
INSERT INTO `table_columns` VALUES ('graph_templates_graph',15,'upper_limit','va rchar(20)','NO','','0',''); INSERT INTO `table_columns` VALUES ('graph_templates_graph',15,'upper_limit','va rchar(20)','NO','','0','');
INSERT INTO `table_columns` VALUES ('graph_templates_graph',16,'t_lower_limit',' char(2)','YES','','',''); INSERT INTO `table_columns` VALUES ('graph_templates_graph',16,'t_lower_limit',' char(2)','YES','','','');
INSERT INTO `table_columns` VALUES ('graph_templates_graph',17,'lower_limit','va rchar(20)','NO','','0',''); INSERT INTO `table_columns` VALUES ('graph_templates_graph',17,'lower_limit','va rchar(20)','NO','','0','');
INSERT INTO `table_columns` VALUES ('graph_templates_graph',18,'t_vertical_label ','char(2)','YES','','',''); INSERT INTO `table_columns` VALUES ('graph_templates_graph',18,'t_vertical_label ','char(2)','YES','','','');
INSERT INTO `table_columns` VALUES ('graph_templates_graph',19,'vertical_label', 'varchar(200)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('graph_templates_graph',19,'vertical_label', 'varchar(200)','YES','',NULL,'');
INSERT INTO `table_columns` VALUES ('graph_templates_graph',20,'t_slope_mode','c har(2)','YES','','',''); INSERT INTO `table_columns` VALUES ('graph_templates_graph',20,'t_slope_mode','c har(2)','YES','','','');
INSERT INTO `table_columns` VALUES ('graph_templates_graph',21,'slope_mode','cha r(2)','YES','','on',''); INSERT INTO `table_columns` VALUES ('graph_templates_graph',21,'slope_mode','cha r(2)','YES','','on','');
INSERT INTO `table_columns` VALUES ('graph_templates_graph',22,'t_auto_scale','c har(2)','YES','','',''); INSERT INTO `table_columns` VALUES ('graph_templates_graph',22,'t_auto_scale','c har(2)','YES','','','');
INSERT INTO `table_columns` VALUES ('graph_templates_graph',23,'auto_scale','cha r(2)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('graph_templates_graph',23,'auto_scale','cha r(2)','YES','',NULL,'');
INSERT INTO `table_columns` VALUES ('graph_templates_graph',24,'t_auto_scale_opt s','char(2)','YES','','',''); INSERT INTO `table_columns` VALUES ('graph_templates_graph',24,'t_auto_scale_opt s','char(2)','YES','','','');
INSERT INTO `table_columns` VALUES ('graph_templates_graph',25,'auto_scale_opts' ,'tinyint(1)','NO','','0',''); INSERT INTO `table_columns` VALUES ('graph_templates_graph',25,'auto_scale_opts' ,'tinyint(3) unsigned','NO','','0','');
INSERT INTO `table_columns` VALUES ('graph_templates_graph',26,'t_auto_scale_log ','char(2)','YES','','',''); INSERT INTO `table_columns` VALUES ('graph_templates_graph',26,'t_auto_scale_log ','char(2)','YES','','','');
INSERT INTO `table_columns` VALUES ('graph_templates_graph',27,'auto_scale_log', 'char(2)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('graph_templates_graph',27,'auto_scale_log', 'char(2)','YES','',NULL,'');
INSERT INTO `table_columns` VALUES ('graph_templates_graph',28,'t_scale_log_unit s','char(2)','YES','','',''); INSERT INTO `table_columns` VALUES ('graph_templates_graph',28,'t_scale_log_unit s','char(2)','YES','','','');
INSERT INTO `table_columns` VALUES ('graph_templates_graph',29,'scale_log_units' ,'char(2)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('graph_templates_graph',29,'scale_log_units' ,'char(2)','YES','',NULL,'');
INSERT INTO `table_columns` VALUES ('graph_templates_graph',30,'t_auto_scale_rig id','char(2)','YES','','',''); INSERT INTO `table_columns` VALUES ('graph_templates_graph',30,'t_auto_scale_rig id','char(2)','YES','','','');
INSERT INTO `table_columns` VALUES ('graph_templates_graph',31,'auto_scale_rigid ','char(2)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('graph_templates_graph',31,'auto_scale_rigid ','char(2)','YES','',NULL,'');
INSERT INTO `table_columns` VALUES ('graph_templates_graph',32,'t_auto_padding', 'char(2)','YES','','',''); INSERT INTO `table_columns` VALUES ('graph_templates_graph',32,'t_auto_padding', 'char(2)','YES','','','');
INSERT INTO `table_columns` VALUES ('graph_templates_graph',33,'auto_padding','c har(2)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('graph_templates_graph',33,'auto_padding','c har(2)','YES','',NULL,'');
INSERT INTO `table_columns` VALUES ('graph_templates_graph',34,'t_base_value','c har(2)','YES','','',''); INSERT INTO `table_columns` VALUES ('graph_templates_graph',34,'t_base_value','c har(2)','YES','','','');
INSERT INTO `table_columns` VALUES ('graph_templates_graph',35,'base_value','med iumint(8)','NO','','0',''); INSERT INTO `table_columns` VALUES ('graph_templates_graph',35,'base_value','med iumint(8)','NO','','0','');
skipping to change at line 541 skipping to change at line 541
INSERT INTO `table_columns` VALUES ('graph_templates_graph',66,'t_legend_directi on','char(2)','YES','','',''); INSERT INTO `table_columns` VALUES ('graph_templates_graph',66,'t_legend_directi on','char(2)','YES','','','');
INSERT INTO `table_columns` VALUES ('graph_templates_graph',67,'legend_direction ','varchar(10)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('graph_templates_graph',67,'legend_direction ','varchar(10)','YES','',NULL,'');
INSERT INTO `table_columns` VALUES ('graph_templates_item',1,'id','int(10) unsig ned','NO','PRI',NULL,'auto_increment'); INSERT INTO `table_columns` VALUES ('graph_templates_item',1,'id','int(10) unsig ned','NO','PRI',NULL,'auto_increment');
INSERT INTO `table_columns` VALUES ('graph_templates_item',2,'hash','varchar(32) ','NO','','',''); INSERT INTO `table_columns` VALUES ('graph_templates_item',2,'hash','varchar(32) ','NO','','','');
INSERT INTO `table_columns` VALUES ('graph_templates_item',3,'local_graph_templa te_item_id','int(10) unsigned','NO','MUL','0',''); INSERT INTO `table_columns` VALUES ('graph_templates_item',3,'local_graph_templa te_item_id','int(10) unsigned','NO','MUL','0','');
INSERT INTO `table_columns` VALUES ('graph_templates_item',4,'local_graph_id','i nt(10) unsigned','NO','MUL','0',''); INSERT INTO `table_columns` VALUES ('graph_templates_item',4,'local_graph_id','i nt(10) unsigned','NO','MUL','0','');
INSERT INTO `table_columns` VALUES ('graph_templates_item',5,'graph_template_id' ,'mediumint(8) unsigned','NO','MUL','0',''); INSERT INTO `table_columns` VALUES ('graph_templates_item',5,'graph_template_id' ,'mediumint(8) unsigned','NO','MUL','0','');
INSERT INTO `table_columns` VALUES ('graph_templates_item',6,'task_item_id','int (10) unsigned','NO','MUL','0',''); INSERT INTO `table_columns` VALUES ('graph_templates_item',6,'task_item_id','int (10) unsigned','NO','MUL','0','');
INSERT INTO `table_columns` VALUES ('graph_templates_item',7,'color_id','mediumi nt(8) unsigned','NO','MUL','0',''); INSERT INTO `table_columns` VALUES ('graph_templates_item',7,'color_id','mediumi nt(8) unsigned','NO','MUL','0','');
INSERT INTO `table_columns` VALUES ('graph_templates_item',8,'alpha','char(2)',' YES','','FF',''); INSERT INTO `table_columns` VALUES ('graph_templates_item',8,'alpha','char(2)',' YES','','FF','');
INSERT INTO `table_columns` VALUES ('graph_templates_item',9,'graph_type_id','ti nyint(3)','NO','','0',''); INSERT INTO `table_columns` VALUES ('graph_templates_item',9,'graph_type_id','ti nyint(3) unsigned','NO','','0','');
INSERT INTO `table_columns` VALUES ('graph_templates_item',10,'line_width','deci mal(4,2)','YES','','0.00',''); INSERT INTO `table_columns` VALUES ('graph_templates_item',10,'line_width','deci mal(4,2)','YES','','0.00','');
INSERT INTO `table_columns` VALUES ('graph_templates_item',11,'dashes','varchar( 20)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('graph_templates_item',11,'dashes','varchar( 20)','YES','',NULL,'');
INSERT INTO `table_columns` VALUES ('graph_templates_item',12,'dash_offset','med iumint(4)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('graph_templates_item',12,'dash_offset','med iumint(4)','YES','',NULL,'');
INSERT INTO `table_columns` VALUES ('graph_templates_item',13,'cdef_id','mediumi nt(8) unsigned','NO','MUL','0',''); INSERT INTO `table_columns` VALUES ('graph_templates_item',13,'cdef_id','mediumi nt(8) unsigned','NO','MUL','0','');
INSERT INTO `table_columns` VALUES ('graph_templates_item',14,'vdef_id','mediumi nt(8) unsigned','NO','MUL','0',''); INSERT INTO `table_columns` VALUES ('graph_templates_item',14,'vdef_id','mediumi nt(8) unsigned','NO','MUL','0','');
INSERT INTO `table_columns` VALUES ('graph_templates_item',15,'shift','char(2)', 'YES','',NULL,''); INSERT INTO `table_columns` VALUES ('graph_templates_item',15,'shift','char(2)', 'YES','',NULL,'');
INSERT INTO `table_columns` VALUES ('graph_templates_item',16,'consolidation_fun ction_id','tinyint(2)','NO','','0',''); INSERT INTO `table_columns` VALUES ('graph_templates_item',16,'consolidation_fun ction_id','tinyint(3) unsigned','NO','','0','');
INSERT INTO `table_columns` VALUES ('graph_templates_item',17,'textalign','varch ar(10)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('graph_templates_item',17,'textalign','varch ar(10)','YES','',NULL,'');
INSERT INTO `table_columns` VALUES ('graph_templates_item',18,'text_format','var char(255)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('graph_templates_item',18,'text_format','var char(255)','YES','',NULL,'');
INSERT INTO `table_columns` VALUES ('graph_templates_item',19,'value','varchar(2 55)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('graph_templates_item',19,'value','varchar(2 55)','YES','',NULL,'');
INSERT INTO `table_columns` VALUES ('graph_templates_item',20,'hard_return','cha r(2)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('graph_templates_item',20,'hard_return','cha r(2)','YES','',NULL,'');
INSERT INTO `table_columns` VALUES ('graph_templates_item',21,'gprint_id','mediu mint(8) unsigned','NO','MUL','0',''); INSERT INTO `table_columns` VALUES ('graph_templates_item',21,'gprint_id','mediu mint(8) unsigned','NO','MUL','0','');
INSERT INTO `table_columns` VALUES ('graph_templates_item',22,'sequence','medium int(8) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('graph_templates_item',22,'sequence','medium int(8) unsigned','NO','','0','');
INSERT INTO `table_columns` VALUES ('graph_tree',1,'id','smallint(5) unsigned',' NO','PRI',NULL,'auto_increment'); INSERT INTO `table_columns` VALUES ('graph_tree',1,'id','smallint(5) unsigned',' NO','PRI',NULL,'auto_increment');
INSERT INTO `table_columns` VALUES ('graph_tree',2,'enabled','char(2)','YES','', 'on',''); INSERT INTO `table_columns` VALUES ('graph_tree',2,'enabled','char(2)','YES','', 'on','');
INSERT INTO `table_columns` VALUES ('graph_tree',3,'locked','tinyint(4)','YES',' ','0',''); INSERT INTO `table_columns` VALUES ('graph_tree',3,'locked','tinyint(3) unsigned ','YES','','0','');
INSERT INTO `table_columns` VALUES ('graph_tree',4,'locked_date','timestamp','NO ','','0000-00-00 00:00:00',''); INSERT INTO `table_columns` VALUES ('graph_tree',4,'locked_date','timestamp','NO ','','0000-00-00 00:00:00','');
INSERT INTO `table_columns` VALUES ('graph_tree',5,'sort_type','tinyint(3) unsig ned','NO','','1',''); INSERT INTO `table_columns` VALUES ('graph_tree',5,'sort_type','tinyint(3) unsig ned','NO','','1','');
INSERT INTO `table_columns` VALUES ('graph_tree',6,'name','varchar(255)','NO','M UL','',''); INSERT INTO `table_columns` VALUES ('graph_tree',6,'name','varchar(255)','NO','M UL','','');
INSERT INTO `table_columns` VALUES ('graph_tree',7,'sequence','int(10) unsigned' ,'YES','MUL','1',''); INSERT INTO `table_columns` VALUES ('graph_tree',7,'sequence','int(10) unsigned' ,'YES','MUL','1','');
INSERT INTO `table_columns` VALUES ('graph_tree',8,'user_id','int(10) unsigned', 'YES','','1',''); INSERT INTO `table_columns` VALUES ('graph_tree',8,'user_id','int(10) unsigned', 'YES','','1','');
INSERT INTO `table_columns` VALUES ('graph_tree',9,'last_modified','timestamp',' NO','','0000-00-00 00:00:00',''); INSERT INTO `table_columns` VALUES ('graph_tree',9,'last_modified','timestamp',' NO','','0000-00-00 00:00:00','');
INSERT INTO `table_columns` VALUES ('graph_tree',10,'modified_by','int(10) unsig ned','YES','','1',''); INSERT INTO `table_columns` VALUES ('graph_tree',10,'modified_by','int(10) unsig ned','YES','','1','');
INSERT INTO `table_columns` VALUES ('graph_tree_items',1,'id','bigint(20) unsign ed','NO','PRI',NULL,'auto_increment'); INSERT INTO `table_columns` VALUES ('graph_tree_items',1,'id','bigint(20) unsign ed','NO','PRI',NULL,'auto_increment');
INSERT INTO `table_columns` VALUES ('graph_tree_items',2,'parent','bigint(20) un signed','YES','MUL',NULL,''); INSERT INTO `table_columns` VALUES ('graph_tree_items',2,'parent','bigint(20) un signed','YES','MUL',NULL,'');
INSERT INTO `table_columns` VALUES ('graph_tree_items',3,'position','int(10) uns igned','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('graph_tree_items',3,'position','int(10) uns igned','YES','',NULL,'');
skipping to change at line 587 skipping to change at line 587
INSERT INTO `table_columns` VALUES ('host',1,'id','mediumint(8) unsigned','NO',' PRI',NULL,'auto_increment'); INSERT INTO `table_columns` VALUES ('host',1,'id','mediumint(8) unsigned','NO',' PRI',NULL,'auto_increment');
INSERT INTO `table_columns` VALUES ('host',2,'poller_id','int(10) unsigned','NO' ,'MUL','1',''); INSERT INTO `table_columns` VALUES ('host',2,'poller_id','int(10) unsigned','NO' ,'MUL','1','');
INSERT INTO `table_columns` VALUES ('host',3,'site_id','int(10) unsigned','NO',' MUL','1',''); INSERT INTO `table_columns` VALUES ('host',3,'site_id','int(10) unsigned','NO',' MUL','1','');
INSERT INTO `table_columns` VALUES ('host',4,'host_template_id','mediumint(8) un signed','NO','','0',''); INSERT INTO `table_columns` VALUES ('host',4,'host_template_id','mediumint(8) un signed','NO','','0','');
INSERT INTO `table_columns` VALUES ('host',5,'description','varchar(150)','NO',' ','',''); INSERT INTO `table_columns` VALUES ('host',5,'description','varchar(150)','NO',' ','','');
INSERT INTO `table_columns` VALUES ('host',6,'hostname','varchar(100)','YES','MU L',NULL,''); INSERT INTO `table_columns` VALUES ('host',6,'hostname','varchar(100)','YES','MU L',NULL,'');
INSERT INTO `table_columns` VALUES ('host',7,'location','varchar(40)','YES','',N ULL,''); INSERT INTO `table_columns` VALUES ('host',7,'location','varchar(40)','YES','',N ULL,'');
INSERT INTO `table_columns` VALUES ('host',8,'notes','text','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('host',8,'notes','text','YES','',NULL,'');
INSERT INTO `table_columns` VALUES ('host',9,'external_id','varchar(40)','YES',' MUL',NULL,''); INSERT INTO `table_columns` VALUES ('host',9,'external_id','varchar(40)','YES',' MUL',NULL,'');
INSERT INTO `table_columns` VALUES ('host',10,'snmp_community','varchar(100)','Y ES','',NULL,''); INSERT INTO `table_columns` VALUES ('host',10,'snmp_community','varchar(100)','Y ES','',NULL,'');
INSERT INTO `table_columns` VALUES ('host',11,'snmp_version','tinyint(1) unsigne d','NO','','1',''); INSERT INTO `table_columns` VALUES ('host',11,'snmp_version','tinyint(3) unsigne d','NO','','1','');
INSERT INTO `table_columns` VALUES ('host',12,'snmp_username','varchar(50)','YES ','',NULL,''); INSERT INTO `table_columns` VALUES ('host',12,'snmp_username','varchar(50)','YES ','',NULL,'');
INSERT INTO `table_columns` VALUES ('host',13,'snmp_password','varchar(50)','YES ','',NULL,''); INSERT INTO `table_columns` VALUES ('host',13,'snmp_password','varchar(50)','YES ','',NULL,'');
INSERT INTO `table_columns` VALUES ('host',14,'snmp_auth_protocol','char(6)','YE S','','',''); INSERT INTO `table_columns` VALUES ('host',14,'snmp_auth_protocol','char(6)','YE S','','','');
INSERT INTO `table_columns` VALUES ('host',15,'snmp_priv_passphrase','varchar(20 0)','YES','','',''); INSERT INTO `table_columns` VALUES ('host',15,'snmp_priv_passphrase','varchar(20 0)','YES','','','');
INSERT INTO `table_columns` VALUES ('host',16,'snmp_priv_protocol','char(6)','YE S','','',''); INSERT INTO `table_columns` VALUES ('host',16,'snmp_priv_protocol','char(6)','YE S','','','');
INSERT INTO `table_columns` VALUES ('host',17,'snmp_context','varchar(64)','YES' ,'','',''); INSERT INTO `table_columns` VALUES ('host',17,'snmp_context','varchar(64)','YES' ,'','','');
INSERT INTO `table_columns` VALUES ('host',18,'snmp_engine_id','varchar(64)','YE S','','',''); INSERT INTO `table_columns` VALUES ('host',18,'snmp_engine_id','varchar(64)','YE S','','','');
INSERT INTO `table_columns` VALUES ('host',19,'snmp_port','mediumint(5) unsigned ','NO','','161',''); INSERT INTO `table_columns` VALUES ('host',19,'snmp_port','mediumint(8) unsigned ','NO','','161','');
INSERT INTO `table_columns` VALUES ('host',20,'snmp_timeout','mediumint(8) unsig ned','NO','','500',''); INSERT INTO `table_columns` VALUES ('host',20,'snmp_timeout','mediumint(8) unsig ned','NO','','500','');
INSERT INTO `table_columns` VALUES ('host',21,'snmp_sysDescr','varchar(300)','NO ','','',''); INSERT INTO `table_columns` VALUES ('host',21,'snmp_sysDescr','varchar(300)','NO ','','','');
INSERT INTO `table_columns` VALUES ('host',22,'snmp_sysObjectID','varchar(128)', 'NO','','',''); INSERT INTO `table_columns` VALUES ('host',22,'snmp_sysObjectID','varchar(128)', 'NO','','','');
INSERT INTO `table_columns` VALUES ('host',23,'snmp_sysUpTimeInstance','bigint(2 0) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('host',23,'snmp_sysUpTimeInstance','bigint(2 0) unsigned','NO','','0','');
INSERT INTO `table_columns` VALUES ('host',24,'snmp_sysContact','varchar(300)',' NO','','',''); INSERT INTO `table_columns` VALUES ('host',24,'snmp_sysContact','varchar(300)',' NO','','','');
INSERT INTO `table_columns` VALUES ('host',25,'snmp_sysName','varchar(300)','NO' ,'','',''); INSERT INTO `table_columns` VALUES ('host',25,'snmp_sysName','varchar(300)','NO' ,'','','');
INSERT INTO `table_columns` VALUES ('host',26,'snmp_sysLocation','varchar(300)', 'NO','','',''); INSERT INTO `table_columns` VALUES ('host',26,'snmp_sysLocation','varchar(300)', 'NO','','','');
INSERT INTO `table_columns` VALUES ('host',27,'availability_method','smallint(5) unsigned','NO','','1',''); INSERT INTO `table_columns` VALUES ('host',27,'availability_method','smallint(5) unsigned','NO','','1','');
INSERT INTO `table_columns` VALUES ('host',28,'ping_method','smallint(5) unsigne d','YES','','0',''); INSERT INTO `table_columns` VALUES ('host',28,'ping_method','smallint(5) unsigne d','YES','','0','');
INSERT INTO `table_columns` VALUES ('host',29,'ping_port','int(12) unsigned','YE INSERT INTO `table_columns` VALUES ('host',29,'ping_port','int(10) unsigned','YE
S','','0',''); S','','0','');
INSERT INTO `table_columns` VALUES ('host',30,'ping_timeout','int(12) unsigned', INSERT INTO `table_columns` VALUES ('host',30,'ping_timeout','int(10) unsigned',
'YES','','500',''); 'YES','','500','');
INSERT INTO `table_columns` VALUES ('host',31,'ping_retries','int(12) unsigned', INSERT INTO `table_columns` VALUES ('host',31,'ping_retries','int(10) unsigned',
'YES','','2',''); 'YES','','2','');
INSERT INTO `table_columns` VALUES ('host',32,'max_oids','int(12) unsigned','YES INSERT INTO `table_columns` VALUES ('host',32,'max_oids','int(10) unsigned','YES
','','10',''); ','','10','');
INSERT INTO `table_columns` VALUES ('host',33,'bulk_walk_size','int(11)','YES',' ','-1',''); INSERT INTO `table_columns` VALUES ('host',33,'bulk_walk_size','int(11)','YES',' ','-1','');
INSERT INTO `table_columns` VALUES ('host',34,'device_threads','tinyint(2) unsig INSERT INTO `table_columns` VALUES ('host',34,'device_threads','tinyint(3) unsig
ned','NO','','1',''); ned','NO','','1','');
INSERT INTO `table_columns` VALUES ('host',35,'deleted','char(2)','YES','','','' INSERT INTO `table_columns` VALUES ('host',35,'deleted','char(2)','NO','','','')
); ;
INSERT INTO `table_columns` VALUES ('host',36,'disabled','char(2)','YES','MUL',N INSERT INTO `table_columns` VALUES ('host',36,'disabled','char(2)','NO','MUL',''
ULL,''); ,'');
INSERT INTO `table_columns` VALUES ('host',37,'status','tinyint(2)','NO','MUL',' INSERT INTO `table_columns` VALUES ('host',37,'status','tinyint(3) unsigned','NO
0',''); ','MUL','0','');
INSERT INTO `table_columns` VALUES ('host',38,'status_event_count','mediumint(8) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('host',38,'status_event_count','mediumint(8) unsigned','NO','','0','');
INSERT INTO `table_columns` VALUES ('host',39,'status_fail_date','timestamp','NO ','','0000-00-00 00:00:00',''); INSERT INTO `table_columns` VALUES ('host',39,'status_fail_date','timestamp','NO ','','0000-00-00 00:00:00','');
INSERT INTO `table_columns` VALUES ('host',40,'status_rec_date','timestamp','NO' ,'','0000-00-00 00:00:00',''); INSERT INTO `table_columns` VALUES ('host',40,'status_rec_date','timestamp','NO' ,'','0000-00-00 00:00:00','');
INSERT INTO `table_columns` VALUES ('host',41,'status_last_error','varchar(255)' ,'YES','','',''); INSERT INTO `table_columns` VALUES ('host',41,'status_last_error','varchar(255)' ,'YES','','','');
INSERT INTO `table_columns` VALUES ('host',42,'min_time','decimal(10,5)','YES',' ','9.99999',''); INSERT INTO `table_columns` VALUES ('host',42,'min_time','decimal(10,5)','YES',' ','9.99999','');
INSERT INTO `table_columns` VALUES ('host',43,'max_time','decimal(10,5)','YES',' ','0.00000',''); INSERT INTO `table_columns` VALUES ('host',43,'max_time','decimal(10,5)','YES',' ','0.00000','');
INSERT INTO `table_columns` VALUES ('host',44,'cur_time','decimal(10,5)','YES',' ','0.00000',''); INSERT INTO `table_columns` VALUES ('host',44,'cur_time','decimal(10,5)','YES',' ','0.00000','');
INSERT INTO `table_columns` VALUES ('host',45,'avg_time','decimal(10,5)','YES',' ','0.00000',''); INSERT INTO `table_columns` VALUES ('host',45,'avg_time','decimal(10,5)','YES',' ','0.00000','');
INSERT INTO `table_columns` VALUES ('host',46,'polling_time','double','YES','',' 0',''); INSERT INTO `table_columns` VALUES ('host',46,'polling_time','double','YES','',' 0','');
INSERT INTO `table_columns` VALUES ('host',47,'total_polls','int(12) unsigned',' INSERT INTO `table_columns` VALUES ('host',47,'total_polls','int(10) unsigned','
YES','','0',''); YES','','0','');
INSERT INTO `table_columns` VALUES ('host',48,'failed_polls','int(12) unsigned', INSERT INTO `table_columns` VALUES ('host',48,'failed_polls','int(10) unsigned',
'YES','','0',''); 'YES','','0','');
INSERT INTO `table_columns` VALUES ('host',49,'availability','decimal(8,5)','NO' ,'','100.00000',''); INSERT INTO `table_columns` VALUES ('host',49,'availability','decimal(8,5)','NO' ,'','100.00000','');
INSERT INTO `table_columns` VALUES ('host',50,'last_updated','timestamp','NO','' ,'current_timestamp()','on update current_timestamp()'); INSERT INTO `table_columns` VALUES ('host',50,'last_updated','timestamp','NO','' ,'current_timestamp()','on update current_timestamp()');
INSERT INTO `table_columns` VALUES ('host_graph',1,'host_id','mediumint(8) unsig ned','NO','PRI','0',''); INSERT INTO `table_columns` VALUES ('host_graph',1,'host_id','mediumint(8) unsig ned','NO','PRI','0','');
INSERT INTO `table_columns` VALUES ('host_graph',2,'graph_template_id','mediumin t(8) unsigned','NO','PRI','0',''); INSERT INTO `table_columns` VALUES ('host_graph',2,'graph_template_id','mediumin t(8) unsigned','NO','PRI','0','');
INSERT INTO `table_columns` VALUES ('host_snmp_cache',1,'host_id','mediumint(8) unsigned','NO','PRI','0',''); INSERT INTO `table_columns` VALUES ('host_snmp_cache',1,'host_id','mediumint(8) unsigned','NO','PRI','0','');
INSERT INTO `table_columns` VALUES ('host_snmp_cache',2,'snmp_query_id','mediumi nt(8) unsigned','NO','PRI','0',''); INSERT INTO `table_columns` VALUES ('host_snmp_cache',2,'snmp_query_id','mediumi nt(8) unsigned','NO','PRI','0','');
INSERT INTO `table_columns` VALUES ('host_snmp_cache',3,'field_name','varchar(50 )','NO','PRI','',''); INSERT INTO `table_columns` VALUES ('host_snmp_cache',3,'field_name','varchar(50 )','NO','PRI','','');
INSERT INTO `table_columns` VALUES ('host_snmp_cache',4,'field_value','varchar(5 12)','YES','MUL',NULL,''); INSERT INTO `table_columns` VALUES ('host_snmp_cache',4,'field_value','varchar(5 12)','YES','MUL',NULL,'');
INSERT INTO `table_columns` VALUES ('host_snmp_cache',5,'snmp_index','varchar(25 5)','NO','PRI','',''); INSERT INTO `table_columns` VALUES ('host_snmp_cache',5,'snmp_index','varchar(25 5)','NO','PRI','','');
INSERT INTO `table_columns` VALUES ('host_snmp_cache',6,'oid','text','NO','',NUL L,''); INSERT INTO `table_columns` VALUES ('host_snmp_cache',6,'oid','text','NO','',NUL L,'');
INSERT INTO `table_columns` VALUES ('host_snmp_cache',7,'present','tinyint(4)',' NO','MUL','1',''); INSERT INTO `table_columns` VALUES ('host_snmp_cache',7,'present','tinyint(3) un signed','NO','MUL','1','');
INSERT INTO `table_columns` VALUES ('host_snmp_cache',8,'last_updated','timestam p','NO','MUL','current_timestamp()','on update current_timestamp()'); INSERT INTO `table_columns` VALUES ('host_snmp_cache',8,'last_updated','timestam p','NO','MUL','current_timestamp()','on update current_timestamp()');
INSERT INTO `table_columns` VALUES ('host_snmp_query',1,'host_id','mediumint(8) unsigned','NO','PRI','0',''); INSERT INTO `table_columns` VALUES ('host_snmp_query',1,'host_id','mediumint(8) unsigned','NO','PRI','0','');
INSERT INTO `table_columns` VALUES ('host_snmp_query',2,'snmp_query_id','mediumi nt(8) unsigned','NO','PRI','0',''); INSERT INTO `table_columns` VALUES ('host_snmp_query',2,'snmp_query_id','mediumi nt(8) unsigned','NO','PRI','0','');
INSERT INTO `table_columns` VALUES ('host_snmp_query',3,'sort_field','varchar(50 )','NO','','',''); INSERT INTO `table_columns` VALUES ('host_snmp_query',3,'sort_field','varchar(50 )','NO','','','');
INSERT INTO `table_columns` VALUES ('host_snmp_query',4,'title_format','varchar( 50)','NO','','',''); INSERT INTO `table_columns` VALUES ('host_snmp_query',4,'title_format','varchar( 50)','NO','','','');
INSERT INTO `table_columns` VALUES ('host_snmp_query',5,'reindex_method','tinyin t(3) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('host_snmp_query',5,'reindex_method','tinyin t(3) unsigned','NO','','0','');
INSERT INTO `table_columns` VALUES ('host_template',1,'id','mediumint(8) unsigne d','NO','PRI',NULL,'auto_increment'); INSERT INTO `table_columns` VALUES ('host_template',1,'id','mediumint(8) unsigne d','NO','PRI',NULL,'auto_increment');
INSERT INTO `table_columns` VALUES ('host_template',2,'hash','varchar(32)','NO', '','',''); INSERT INTO `table_columns` VALUES ('host_template',2,'hash','varchar(32)','NO', '','','');
INSERT INTO `table_columns` VALUES ('host_template',3,'name','varchar(100)','NO' ,'MUL','',''); INSERT INTO `table_columns` VALUES ('host_template',3,'name','varchar(100)','NO' ,'MUL','','');
INSERT INTO `table_columns` VALUES ('host_template_graph',1,'host_template_id',' mediumint(8) unsigned','NO','PRI','0',''); INSERT INTO `table_columns` VALUES ('host_template_graph',1,'host_template_id',' mediumint(8) unsigned','NO','PRI','0','');
INSERT INTO `table_columns` VALUES ('host_template_graph',2,'graph_template_id', 'mediumint(8) unsigned','NO','PRI','0',''); INSERT INTO `table_columns` VALUES ('host_template_graph',2,'graph_template_id', 'mediumint(8) unsigned','NO','PRI','0','');
INSERT INTO `table_columns` VALUES ('host_template_snmp_query',1,'host_template_ id','mediumint(8) unsigned','NO','PRI','0',''); INSERT INTO `table_columns` VALUES ('host_template_snmp_query',1,'host_template_ id','mediumint(8) unsigned','NO','PRI','0','');
INSERT INTO `table_columns` VALUES ('host_template_snmp_query',2,'snmp_query_id' ,'mediumint(8) unsigned','NO','PRI','0',''); INSERT INTO `table_columns` VALUES ('host_template_snmp_query',2,'snmp_query_id' ,'mediumint(8) unsigned','NO','PRI','0','');
INSERT INTO `table_columns` VALUES ('plugin_config',1,'id','mediumint(8) unsigne d','NO','PRI',NULL,'auto_increment'); INSERT INTO `table_columns` VALUES ('plugin_config',1,'id','mediumint(8) unsigne d','NO','PRI',NULL,'auto_increment');
INSERT INTO `table_columns` VALUES ('plugin_config',2,'directory','varchar(32)', 'NO','MUL','',''); INSERT INTO `table_columns` VALUES ('plugin_config',2,'directory','varchar(32)', 'NO','MUL','','');
INSERT INTO `table_columns` VALUES ('plugin_config',3,'name','varchar(64)','NO', '','',''); INSERT INTO `table_columns` VALUES ('plugin_config',3,'name','varchar(64)','NO', '','','');
INSERT INTO `table_columns` VALUES ('plugin_config',4,'status','tinyint(2)','NO' ,'MUL','0',''); INSERT INTO `table_columns` VALUES ('plugin_config',4,'status','tinyint(3) unsig ned','NO','MUL','0','');
INSERT INTO `table_columns` VALUES ('plugin_config',5,'author','varchar(64)','NO ','','',''); INSERT INTO `table_columns` VALUES ('plugin_config',5,'author','varchar(64)','NO ','','','');
INSERT INTO `table_columns` VALUES ('plugin_config',6,'webpage','varchar(255)',' NO','','',''); INSERT INTO `table_columns` VALUES ('plugin_config',6,'webpage','varchar(255)',' NO','','','');
INSERT INTO `table_columns` VALUES ('plugin_config',7,'version','varchar(10)','N O','','',''); INSERT INTO `table_columns` VALUES ('plugin_config',7,'version','varchar(10)','N O','','','');
INSERT INTO `table_columns` VALUES ('plugin_db_changes',1,'id','mediumint(8) uns igned','NO','PRI',NULL,'auto_increment'); INSERT INTO `table_columns` VALUES ('plugin_db_changes',1,'id','mediumint(8) uns igned','NO','PRI',NULL,'auto_increment');
INSERT INTO `table_columns` VALUES ('plugin_db_changes',2,'plugin','varchar(16)' ,'NO','MUL','',''); INSERT INTO `table_columns` VALUES ('plugin_db_changes',2,'plugin','varchar(16)' ,'NO','MUL','','');
INSERT INTO `table_columns` VALUES ('plugin_db_changes',3,'table','varchar(64)', 'NO','','',''); INSERT INTO `table_columns` VALUES ('plugin_db_changes',3,'table','varchar(64)', 'NO','','','');
INSERT INTO `table_columns` VALUES ('plugin_db_changes',4,'column','varchar(64)' ,'NO','',NULL,''); INSERT INTO `table_columns` VALUES ('plugin_db_changes',4,'column','varchar(64)' ,'NO','',NULL,'');
INSERT INTO `table_columns` VALUES ('plugin_db_changes',5,'method','varchar(16)' ,'NO','MUL','',''); INSERT INTO `table_columns` VALUES ('plugin_db_changes',5,'method','varchar(16)' ,'NO','MUL','','');
INSERT INTO `table_columns` VALUES ('plugin_hooks',1,'id','mediumint(8) unsigned ','NO','PRI',NULL,'auto_increment'); INSERT INTO `table_columns` VALUES ('plugin_hooks',1,'id','mediumint(8) unsigned ','NO','PRI',NULL,'auto_increment');
INSERT INTO `table_columns` VALUES ('plugin_hooks',2,'name','varchar(32)','NO',' ','',''); INSERT INTO `table_columns` VALUES ('plugin_hooks',2,'name','varchar(32)','NO',' ','','');
INSERT INTO `table_columns` VALUES ('plugin_hooks',3,'hook','varchar(64)','NO',' MUL','',''); INSERT INTO `table_columns` VALUES ('plugin_hooks',3,'hook','varchar(64)','NO',' MUL','','');
INSERT INTO `table_columns` VALUES ('plugin_hooks',4,'file','varchar(255)','NO', '','',''); INSERT INTO `table_columns` VALUES ('plugin_hooks',4,'file','varchar(255)','NO', '','','');
INSERT INTO `table_columns` VALUES ('plugin_hooks',5,'function','varchar(128)',' NO','','',''); INSERT INTO `table_columns` VALUES ('plugin_hooks',5,'function','varchar(128)',' NO','','','');
INSERT INTO `table_columns` VALUES ('plugin_hooks',6,'status','int(8)','NO','MUL ','0',''); INSERT INTO `table_columns` VALUES ('plugin_hooks',6,'status','int(10) unsigned' ,'NO','MUL','0','');
INSERT INTO `table_columns` VALUES ('plugin_realms',1,'id','mediumint(8) unsigne d','NO','PRI',NULL,'auto_increment'); INSERT INTO `table_columns` VALUES ('plugin_realms',1,'id','mediumint(8) unsigne d','NO','PRI',NULL,'auto_increment');
INSERT INTO `table_columns` VALUES ('plugin_realms',2,'plugin','varchar(32)','NO ','MUL','',''); INSERT INTO `table_columns` VALUES ('plugin_realms',2,'plugin','varchar(32)','NO ','MUL','','');
INSERT INTO `table_columns` VALUES ('plugin_realms',3,'file','text','NO','',NULL ,''); INSERT INTO `table_columns` VALUES ('plugin_realms',3,'file','text','NO','',NULL ,'');
INSERT INTO `table_columns` VALUES ('plugin_realms',4,'display','varchar(64)','N O','','',''); INSERT INTO `table_columns` VALUES ('plugin_realms',4,'display','varchar(64)','N O','','','');
INSERT INTO `table_columns` VALUES ('poller',1,'id','smallint(5) unsigned','NO', 'PRI',NULL,'auto_increment'); INSERT INTO `table_columns` VALUES ('poller',1,'id','smallint(5) unsigned','NO', 'PRI',NULL,'auto_increment');
INSERT INTO `table_columns` VALUES ('poller',2,'disabled','char(2)','YES','MUL', '',''); INSERT INTO `table_columns` VALUES ('poller',2,'disabled','char(2)','YES','MUL', '','');
INSERT INTO `table_columns` VALUES ('poller',3,'name','varchar(30)','YES','MUL', NULL,''); INSERT INTO `table_columns` VALUES ('poller',3,'name','varchar(30)','YES','MUL', NULL,'');
INSERT INTO `table_columns` VALUES ('poller',4,'notes','varchar(1024)','YES','', '',''); INSERT INTO `table_columns` VALUES ('poller',4,'notes','varchar(1024)','YES','', '','');
INSERT INTO `table_columns` VALUES ('poller',5,'status','int(10) unsigned','NO', '','0',''); INSERT INTO `table_columns` VALUES ('poller',5,'status','int(10) unsigned','NO', '','0','');
INSERT INTO `table_columns` VALUES ('poller',6,'timezone','varchar(40)','YES','' ,'',''); INSERT INTO `table_columns` VALUES ('poller',6,'timezone','varchar(40)','YES','' ,'','');
skipping to change at line 715 skipping to change at line 715
INSERT INTO `table_columns` VALUES ('poller_command',3,'action','tinyint(3) unsi gned','NO','PRI','0',''); INSERT INTO `table_columns` VALUES ('poller_command',3,'action','tinyint(3) unsi gned','NO','PRI','0','');
INSERT INTO `table_columns` VALUES ('poller_command',4,'command','varchar(191)', 'NO','PRI','',''); INSERT INTO `table_columns` VALUES ('poller_command',4,'command','varchar(191)', 'NO','PRI','','');
INSERT INTO `table_columns` VALUES ('poller_command',5,'last_updated','timestamp ','NO','','current_timestamp()','on update current_timestamp()'); INSERT INTO `table_columns` VALUES ('poller_command',5,'last_updated','timestamp ','NO','','current_timestamp()','on update current_timestamp()');
INSERT INTO `table_columns` VALUES ('poller_data_template_field_mappings',1,'dat a_template_id','int(10) unsigned','NO','PRI','0',''); INSERT INTO `table_columns` VALUES ('poller_data_template_field_mappings',1,'dat a_template_id','int(10) unsigned','NO','PRI','0','');
INSERT INTO `table_columns` VALUES ('poller_data_template_field_mappings',2,'dat a_name','varchar(40)','NO','PRI','',''); INSERT INTO `table_columns` VALUES ('poller_data_template_field_mappings',2,'dat a_name','varchar(40)','NO','PRI','','');
INSERT INTO `table_columns` VALUES ('poller_data_template_field_mappings',3,'dat a_source_names','varchar(125)','NO','PRI','',''); INSERT INTO `table_columns` VALUES ('poller_data_template_field_mappings',3,'dat a_source_names','varchar(125)','NO','PRI','','');
INSERT INTO `table_columns` VALUES ('poller_data_template_field_mappings',4,'las t_updated','timestamp','NO','','current_timestamp()','on update current_timestam p()'); INSERT INTO `table_columns` VALUES ('poller_data_template_field_mappings',4,'las t_updated','timestamp','NO','','current_timestamp()','on update current_timestam p()');
INSERT INTO `table_columns` VALUES ('poller_item',1,'local_data_id','int(10) uns igned','NO','PRI','0',''); INSERT INTO `table_columns` VALUES ('poller_item',1,'local_data_id','int(10) uns igned','NO','PRI','0','');
INSERT INTO `table_columns` VALUES ('poller_item',2,'poller_id','int(10) unsigne d','NO','MUL','1',''); INSERT INTO `table_columns` VALUES ('poller_item',2,'poller_id','int(10) unsigne d','NO','MUL','1','');
INSERT INTO `table_columns` VALUES ('poller_item',3,'host_id','mediumint(8) unsi gned','NO','MUL','0',''); INSERT INTO `table_columns` VALUES ('poller_item',3,'host_id','mediumint(8) unsi gned','NO','MUL','0','');
INSERT INTO `table_columns` VALUES ('poller_item',4,'action','tinyint(2) unsigne INSERT INTO `table_columns` VALUES ('poller_item',4,'action','tinyint(3) unsigne
d','NO','MUL','1',''); d','NO','MUL','1','');
INSERT INTO `table_columns` VALUES ('poller_item',5,'present','tinyint(4)','NO', INSERT INTO `table_columns` VALUES ('poller_item',5,'present','tinyint(3) unsign
'MUL','1',''); ed','NO','MUL','1','');
INSERT INTO `table_columns` VALUES ('poller_item',6,'last_updated','timestamp',' NO','','current_timestamp()','on update current_timestamp()'); INSERT INTO `table_columns` VALUES ('poller_item',6,'last_updated','timestamp',' NO','','current_timestamp()','on update current_timestamp()');
INSERT INTO `table_columns` VALUES ('poller_item',7,'hostname','varchar(100)','N O','','',''); INSERT INTO `table_columns` VALUES ('poller_item',7,'hostname','varchar(100)','N O','','','');
INSERT INTO `table_columns` VALUES ('poller_item',8,'snmp_community','varchar(10 0)','NO','','',''); INSERT INTO `table_columns` VALUES ('poller_item',8,'snmp_community','varchar(10 0)','NO','','','');
INSERT INTO `table_columns` VALUES ('poller_item',9,'snmp_version','tinyint(1) u nsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('poller_item',9,'snmp_version','tinyint(3) u nsigned','NO','','0','');
INSERT INTO `table_columns` VALUES ('poller_item',10,'snmp_username','varchar(50 )','NO','','',''); INSERT INTO `table_columns` VALUES ('poller_item',10,'snmp_username','varchar(50 )','NO','','','');
INSERT INTO `table_columns` VALUES ('poller_item',11,'snmp_password','varchar(50 )','NO','','',''); INSERT INTO `table_columns` VALUES ('poller_item',11,'snmp_password','varchar(50 )','NO','','','');
INSERT INTO `table_columns` VALUES ('poller_item',12,'snmp_auth_protocol','char( 6)','NO','','',''); INSERT INTO `table_columns` VALUES ('poller_item',12,'snmp_auth_protocol','char( 6)','NO','','','');
INSERT INTO `table_columns` VALUES ('poller_item',13,'snmp_priv_passphrase','var char(200)','NO','','',''); INSERT INTO `table_columns` VALUES ('poller_item',13,'snmp_priv_passphrase','var char(200)','NO','','','');
INSERT INTO `table_columns` VALUES ('poller_item',14,'snmp_priv_protocol','char( 6)','NO','','',''); INSERT INTO `table_columns` VALUES ('poller_item',14,'snmp_priv_protocol','char( 6)','NO','','','');
INSERT INTO `table_columns` VALUES ('poller_item',15,'snmp_context','varchar(64) ','YES','','',''); INSERT INTO `table_columns` VALUES ('poller_item',15,'snmp_context','varchar(64) ','YES','','','');
INSERT INTO `table_columns` VALUES ('poller_item',16,'snmp_engine_id','varchar(6 4)','YES','','',''); INSERT INTO `table_columns` VALUES ('poller_item',16,'snmp_engine_id','varchar(6 4)','YES','','','');
INSERT INTO `table_columns` VALUES ('poller_item',17,'snmp_port','mediumint(5) u nsigned','NO','','161',''); INSERT INTO `table_columns` VALUES ('poller_item',17,'snmp_port','mediumint(8) u nsigned','NO','','161','');
INSERT INTO `table_columns` VALUES ('poller_item',18,'snmp_timeout','mediumint(8 ) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('poller_item',18,'snmp_timeout','mediumint(8 ) unsigned','NO','','0','');
INSERT INTO `table_columns` VALUES ('poller_item',19,'rrd_name','varchar(19)','N O','PRI','',''); INSERT INTO `table_columns` VALUES ('poller_item',19,'rrd_name','varchar(19)','N O','PRI','','');
INSERT INTO `table_columns` VALUES ('poller_item',20,'rrd_path','varchar(255)',' NO','','',''); INSERT INTO `table_columns` VALUES ('poller_item',20,'rrd_path','varchar(255)',' NO','','','');
INSERT INTO `table_columns` VALUES ('poller_item',21,'rrd_num','tinyint(2) unsig ned','NO','','0',''); INSERT INTO `table_columns` VALUES ('poller_item',21,'rrd_num','tinyint(3) unsig ned','NO','','0','');
INSERT INTO `table_columns` VALUES ('poller_item',22,'rrd_step','mediumint(8)',' NO','','300',''); INSERT INTO `table_columns` VALUES ('poller_item',22,'rrd_step','mediumint(8)',' NO','','300','');
INSERT INTO `table_columns` VALUES ('poller_item',23,'rrd_next_step','mediumint( 8)','NO','','0',''); INSERT INTO `table_columns` VALUES ('poller_item',23,'rrd_next_step','mediumint( 8)','NO','','0','');
INSERT INTO `table_columns` VALUES ('poller_item',24,'arg1','text','YES','',NULL ,''); INSERT INTO `table_columns` VALUES ('poller_item',24,'arg1','text','YES','',NULL ,'');
INSERT INTO `table_columns` VALUES ('poller_item',25,'arg2','varchar(255)','YES' ,'',NULL,''); INSERT INTO `table_columns` VALUES ('poller_item',25,'arg2','varchar(255)','YES' ,'',NULL,'');
INSERT INTO `table_columns` VALUES ('poller_item',26,'arg3','varchar(255)','YES' ,'',NULL,''); INSERT INTO `table_columns` VALUES ('poller_item',26,'arg3','varchar(255)','YES' ,'',NULL,'');
INSERT INTO `table_columns` VALUES ('poller_output',1,'local_data_id','int(10) u nsigned','NO','PRI','0',''); INSERT INTO `table_columns` VALUES ('poller_output',1,'local_data_id','int(10) u nsigned','NO','PRI','0','');
INSERT INTO `table_columns` VALUES ('poller_output',2,'rrd_name','varchar(19)',' NO','PRI','',''); INSERT INTO `table_columns` VALUES ('poller_output',2,'rrd_name','varchar(19)',' NO','PRI','','');
INSERT INTO `table_columns` VALUES ('poller_output',3,'time','timestamp','NO','P RI','0000-00-00 00:00:00',''); INSERT INTO `table_columns` VALUES ('poller_output',3,'time','timestamp','NO','P RI','0000-00-00 00:00:00','');
INSERT INTO `table_columns` VALUES ('poller_output',4,'output','varchar(512)','N O','','',''); INSERT INTO `table_columns` VALUES ('poller_output',4,'output','varchar(512)','N O','','','');
INSERT INTO `table_columns` VALUES ('poller_output_boost',1,'local_data_id','int (10) unsigned','NO','PRI','0',''); INSERT INTO `table_columns` VALUES ('poller_output_boost',1,'local_data_id','int (10) unsigned','NO','PRI','0','');
skipping to change at line 758 skipping to change at line 758
INSERT INTO `table_columns` VALUES ('poller_output_boost_processes',1,'sock_int_ value','bigint(20) unsigned','NO','PRI',NULL,'auto_increment'); INSERT INTO `table_columns` VALUES ('poller_output_boost_processes',1,'sock_int_ value','bigint(20) unsigned','NO','PRI',NULL,'auto_increment');
INSERT INTO `table_columns` VALUES ('poller_output_boost_processes',2,'status',' varchar(255)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('poller_output_boost_processes',2,'status',' varchar(255)','YES','',NULL,'');
INSERT INTO `table_columns` VALUES ('poller_output_realtime',1,'local_data_id',' int(10) unsigned','NO','PRI','0',''); INSERT INTO `table_columns` VALUES ('poller_output_realtime',1,'local_data_id',' int(10) unsigned','NO','PRI','0','');
INSERT INTO `table_columns` VALUES ('poller_output_realtime',2,'rrd_name','varch ar(19)','NO','PRI','',''); INSERT INTO `table_columns` VALUES ('poller_output_realtime',2,'rrd_name','varch ar(19)','NO','PRI','','');
INSERT INTO `table_columns` VALUES ('poller_output_realtime',3,'time','timestamp ','NO','PRI','0000-00-00 00:00:00',''); INSERT INTO `table_columns` VALUES ('poller_output_realtime',3,'time','timestamp ','NO','PRI','0000-00-00 00:00:00','');
INSERT INTO `table_columns` VALUES ('poller_output_realtime',4,'output','text',' NO','',NULL,''); INSERT INTO `table_columns` VALUES ('poller_output_realtime',4,'output','text',' NO','',NULL,'');
INSERT INTO `table_columns` VALUES ('poller_output_realtime',5,'poller_id','varc har(256)','NO','PRI','1',''); INSERT INTO `table_columns` VALUES ('poller_output_realtime',5,'poller_id','varc har(256)','NO','PRI','1','');
INSERT INTO `table_columns` VALUES ('poller_reindex',1,'host_id','mediumint(8) u nsigned','NO','PRI','0',''); INSERT INTO `table_columns` VALUES ('poller_reindex',1,'host_id','mediumint(8) u nsigned','NO','PRI','0','');
INSERT INTO `table_columns` VALUES ('poller_reindex',2,'data_query_id','mediumin t(8) unsigned','NO','PRI','0',''); INSERT INTO `table_columns` VALUES ('poller_reindex',2,'data_query_id','mediumin t(8) unsigned','NO','PRI','0','');
INSERT INTO `table_columns` VALUES ('poller_reindex',3,'action','tinyint(3) unsi gned','NO','','0',''); INSERT INTO `table_columns` VALUES ('poller_reindex',3,'action','tinyint(3) unsi gned','NO','','0','');
INSERT INTO `table_columns` VALUES ('poller_reindex',4,'present','tinyint(4)','N O','MUL','1',''); INSERT INTO `table_columns` VALUES ('poller_reindex',4,'present','tinyint(3) uns igned','NO','MUL','1','');
INSERT INTO `table_columns` VALUES ('poller_reindex',5,'op','char(1)','NO','','' ,''); INSERT INTO `table_columns` VALUES ('poller_reindex',5,'op','char(1)','NO','','' ,'');
INSERT INTO `table_columns` VALUES ('poller_reindex',6,'assert_value','varchar(1 00)','NO','','',''); INSERT INTO `table_columns` VALUES ('poller_reindex',6,'assert_value','varchar(1 00)','NO','','','');
INSERT INTO `table_columns` VALUES ('poller_reindex',7,'arg1','varchar(255)','NO ','PRI','',''); INSERT INTO `table_columns` VALUES ('poller_reindex',7,'arg1','varchar(255)','NO ','PRI','','');
INSERT INTO `table_columns` VALUES ('poller_resource_cache',1,'id','int(10) unsi gned','NO','PRI',NULL,'auto_increment'); INSERT INTO `table_columns` VALUES ('poller_resource_cache',1,'id','int(10) unsi gned','NO','PRI',NULL,'auto_increment');
INSERT INTO `table_columns` VALUES ('poller_resource_cache',2,'resource_type','v archar(20)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('poller_resource_cache',2,'resource_type','v archar(20)','YES','',NULL,'');
INSERT INTO `table_columns` VALUES ('poller_resource_cache',3,'md5sum','varchar( 32)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('poller_resource_cache',3,'md5sum','varchar( 32)','YES','',NULL,'');
INSERT INTO `table_columns` VALUES ('poller_resource_cache',4,'path','varchar(19 1)','YES','UNI',NULL,''); INSERT INTO `table_columns` VALUES ('poller_resource_cache',4,'path','varchar(19 1)','YES','UNI',NULL,'');
INSERT INTO `table_columns` VALUES ('poller_resource_cache',5,'update_time','tim estamp','NO','','0000-00-00 00:00:00',''); INSERT INTO `table_columns` VALUES ('poller_resource_cache',5,'update_time','tim estamp','NO','','0000-00-00 00:00:00','');
INSERT INTO `table_columns` VALUES ('poller_resource_cache',6,'contents','longbl ob','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('poller_resource_cache',6,'contents','longbl ob','YES','',NULL,'');
INSERT INTO `table_columns` VALUES ('poller_resource_cache',7,'attributes','int( 10) unsigned','YES','','0',''); INSERT INTO `table_columns` VALUES ('poller_resource_cache',7,'attributes','int( 10) unsigned','YES','','0','');
INSERT INTO `table_columns` VALUES ('poller_time',1,'id','bigint(20) unsigned',' NO','PRI',NULL,'auto_increment'); INSERT INTO `table_columns` VALUES ('poller_time',1,'id','bigint(20) unsigned',' NO','PRI',NULL,'auto_increment');
INSERT INTO `table_columns` VALUES ('poller_time',2,'pid','int(11) unsigned','NO ','','0',''); INSERT INTO `table_columns` VALUES ('poller_time',2,'pid','int(10) unsigned','NO ','','0','');
INSERT INTO `table_columns` VALUES ('poller_time',3,'poller_id','int(10) unsigne d','NO','MUL','1',''); INSERT INTO `table_columns` VALUES ('poller_time',3,'poller_id','int(10) unsigne d','NO','MUL','1','');
INSERT INTO `table_columns` VALUES ('poller_time',4,'start_time','timestamp','NO ','','0000-00-00 00:00:00',''); INSERT INTO `table_columns` VALUES ('poller_time',4,'start_time','timestamp','NO ','','0000-00-00 00:00:00','');
INSERT INTO `table_columns` VALUES ('poller_time',5,'end_time','timestamp','NO', '','0000-00-00 00:00:00',''); INSERT INTO `table_columns` VALUES ('poller_time',5,'end_time','timestamp','NO', '','0000-00-00 00:00:00','');
INSERT INTO `table_columns` VALUES ('processes',1,'id','bigint(20) unsigned','NO ','MUL',NULL,'auto_increment'); INSERT INTO `table_columns` VALUES ('processes',1,'id','bigint(20) unsigned','NO ','MUL',NULL,'auto_increment');
INSERT INTO `table_columns` VALUES ('processes',2,'pid','int(10) unsigned','NO', 'PRI','0',''); INSERT INTO `table_columns` VALUES ('processes',2,'pid','int(10) unsigned','NO', 'PRI','0','');
INSERT INTO `table_columns` VALUES ('processes',3,'tasktype','varchar(20)','NO', 'PRI','',''); INSERT INTO `table_columns` VALUES ('processes',3,'tasktype','varchar(20)','NO', 'PRI','','');
INSERT INTO `table_columns` VALUES ('processes',4,'taskname','varchar(40)','NO', 'PRI','',''); INSERT INTO `table_columns` VALUES ('processes',4,'taskname','varchar(40)','NO', 'PRI','','');
INSERT INTO `table_columns` VALUES ('processes',5,'taskid','int(10) unsigned','N O','PRI','0',''); INSERT INTO `table_columns` VALUES ('processes',5,'taskid','int(10) unsigned','N O','PRI','0','');
INSERT INTO `table_columns` VALUES ('processes',6,'timeout','int(11)','YES','',' 300',''); INSERT INTO `table_columns` VALUES ('processes',6,'timeout','int(10) unsigned',' YES','','300','');
INSERT INTO `table_columns` VALUES ('processes',7,'started','timestamp','NO','', 'current_timestamp()',''); INSERT INTO `table_columns` VALUES ('processes',7,'started','timestamp','NO','', 'current_timestamp()','');
INSERT INTO `table_columns` VALUES ('processes',8,'last_update','timestamp','NO' ,'','0000-00-00 00:00:00',''); INSERT INTO `table_columns` VALUES ('processes',8,'last_update','timestamp','NO' ,'','0000-00-00 00:00:00','');
INSERT INTO `table_columns` VALUES ('reports',1,'id','mediumint(8) unsigned','NO ','PRI',NULL,'auto_increment'); INSERT INTO `table_columns` VALUES ('reports',1,'id','mediumint(8) unsigned','NO ','PRI',NULL,'auto_increment');
INSERT INTO `table_columns` VALUES ('reports',2,'user_id','mediumint(8) unsigned ','NO','','0',''); INSERT INTO `table_columns` VALUES ('reports',2,'user_id','mediumint(8) unsigned ','NO','','0','');
INSERT INTO `table_columns` VALUES ('reports',3,'name','varchar(100)','NO','','' ,''); INSERT INTO `table_columns` VALUES ('reports',3,'name','varchar(100)','NO','','' ,'');
INSERT INTO `table_columns` VALUES ('reports',4,'cformat','char(2)','NO','','',' '); INSERT INTO `table_columns` VALUES ('reports',4,'cformat','char(2)','NO','','',' ');
INSERT INTO `table_columns` VALUES ('reports',5,'format_file','varchar(255)','NO ','','',''); INSERT INTO `table_columns` VALUES ('reports',5,'format_file','varchar(255)','NO ','','','');
INSERT INTO `table_columns` VALUES ('reports',6,'font_size','smallint(2) unsigne d','NO','','0',''); INSERT INTO `table_columns` VALUES ('reports',6,'font_size','smallint(2) unsigne d','NO','','0','');
INSERT INTO `table_columns` VALUES ('reports',7,'alignment','smallint(2) unsigne d','NO','','0',''); INSERT INTO `table_columns` VALUES ('reports',7,'alignment','smallint(2) unsigne d','NO','','0','');
INSERT INTO `table_columns` VALUES ('reports',8,'graph_linked','char(2)','NO','' ,'',''); INSERT INTO `table_columns` VALUES ('reports',8,'graph_linked','char(2)','NO','' ,'','');
INSERT INTO `table_columns` VALUES ('reports',9,'intrvl','smallint(2) unsigned', 'NO','','0',''); INSERT INTO `table_columns` VALUES ('reports',9,'intrvl','smallint(2) unsigned', 'NO','','0','');
INSERT INTO `table_columns` VALUES ('reports',10,'count','smallint(2) unsigned', 'NO','','0',''); INSERT INTO `table_columns` VALUES ('reports',10,'count','smallint(2) unsigned', 'NO','','0','');
INSERT INTO `table_columns` VALUES ('reports',11,'offset','int(12) unsigned','NO ','','0',''); INSERT INTO `table_columns` VALUES ('reports',11,'offset','int(10) unsigned','NO ','','0','');
INSERT INTO `table_columns` VALUES ('reports',12,'mailtime','bigint(20) unsigned ','NO','MUL','0',''); INSERT INTO `table_columns` VALUES ('reports',12,'mailtime','bigint(20) unsigned ','NO','MUL','0','');
INSERT INTO `table_columns` VALUES ('reports',13,'subject','varchar(64)','NO','' ,'',''); INSERT INTO `table_columns` VALUES ('reports',13,'subject','varchar(64)','NO','' ,'','');
INSERT INTO `table_columns` VALUES ('reports',14,'from_name','varchar(40)','NO', '',NULL,''); INSERT INTO `table_columns` VALUES ('reports',14,'from_name','varchar(40)','NO', '',NULL,'');
INSERT INTO `table_columns` VALUES ('reports',15,'from_email','text','NO','',NUL L,''); INSERT INTO `table_columns` VALUES ('reports',15,'from_email','text','NO','',NUL L,'');
INSERT INTO `table_columns` VALUES ('reports',16,'email','text','NO','',NULL,'') ; INSERT INTO `table_columns` VALUES ('reports',16,'email','text','NO','',NULL,'') ;
INSERT INTO `table_columns` VALUES ('reports',17,'bcc','text','NO','',NULL,''); INSERT INTO `table_columns` VALUES ('reports',17,'bcc','text','NO','',NULL,'');
INSERT INTO `table_columns` VALUES ('reports',18,'attachment_type','smallint(2) unsigned','NO','','1',''); INSERT INTO `table_columns` VALUES ('reports',18,'attachment_type','smallint(2) unsigned','NO','','1','');
INSERT INTO `table_columns` VALUES ('reports',19,'graph_height','smallint(2) uns igned','NO','','0',''); INSERT INTO `table_columns` VALUES ('reports',19,'graph_height','smallint(2) uns igned','NO','','0','');
INSERT INTO `table_columns` VALUES ('reports',20,'graph_width','smallint(2) unsi gned','NO','','0',''); INSERT INTO `table_columns` VALUES ('reports',20,'graph_width','smallint(2) unsi gned','NO','','0','');
INSERT INTO `table_columns` VALUES ('reports',21,'graph_columns','smallint(2) un signed','NO','','0',''); INSERT INTO `table_columns` VALUES ('reports',21,'graph_columns','smallint(2) un signed','NO','','0','');
INSERT INTO `table_columns` VALUES ('reports',22,'thumbnails','char(2)','NO','', '',''); INSERT INTO `table_columns` VALUES ('reports',22,'thumbnails','char(2)','NO','', '','');
INSERT INTO `table_columns` VALUES ('reports',23,'lastsent','bigint(20) unsigned ','NO','','0',''); INSERT INTO `table_columns` VALUES ('reports',23,'lastsent','bigint(20) unsigned ','NO','','0','');
INSERT INTO `table_columns` VALUES ('reports',24,'enabled','char(2)','YES','','' ,''); INSERT INTO `table_columns` VALUES ('reports',24,'enabled','char(2)','YES','','' ,'');
INSERT INTO `table_columns` VALUES ('reports_items',1,'id','int(10) unsigned','N O','PRI',NULL,'auto_increment'); INSERT INTO `table_columns` VALUES ('reports_items',1,'id','int(10) unsigned','N O','PRI',NULL,'auto_increment');
INSERT INTO `table_columns` VALUES ('reports_items',2,'report_id','int(10) unsig ned','NO','MUL','0',''); INSERT INTO `table_columns` VALUES ('reports_items',2,'report_id','int(10) unsig ned','NO','MUL','0','');
INSERT INTO `table_columns` VALUES ('reports_items',3,'item_type','tinyint(1) un signed','NO','','1',''); INSERT INTO `table_columns` VALUES ('reports_items',3,'item_type','tinyint(3) un signed','NO','','1','');
INSERT INTO `table_columns` VALUES ('reports_items',4,'tree_id','int(10) unsigne d','NO','','0',''); INSERT INTO `table_columns` VALUES ('reports_items',4,'tree_id','int(10) unsigne d','NO','','0','');
INSERT INTO `table_columns` VALUES ('reports_items',5,'branch_id','int(10) unsig ned','NO','','0',''); INSERT INTO `table_columns` VALUES ('reports_items',5,'branch_id','int(10) unsig ned','NO','','0','');
INSERT INTO `table_columns` VALUES ('reports_items',6,'tree_cascade','char(2)',' NO','','',''); INSERT INTO `table_columns` VALUES ('reports_items',6,'tree_cascade','char(2)',' NO','','','');
INSERT INTO `table_columns` VALUES ('reports_items',7,'graph_name_regexp','varch ar(128)','NO','','',''); INSERT INTO `table_columns` VALUES ('reports_items',7,'graph_name_regexp','varch ar(128)','NO','','','');
INSERT INTO `table_columns` VALUES ('reports_items',8,'site_id','int(11)','NO',' ','-1',''); INSERT INTO `table_columns` VALUES ('reports_items',8,'site_id','int(11)','NO',' ','-1','');
INSERT INTO `table_columns` VALUES ('reports_items',9,'host_template_id','int(11 )','NO','','-1',''); INSERT INTO `table_columns` VALUES ('reports_items',9,'host_template_id','int(11 )','NO','','-1','');
INSERT INTO `table_columns` VALUES ('reports_items',10,'host_id','int(11)','NO', '','-1',''); INSERT INTO `table_columns` VALUES ('reports_items',10,'host_id','int(11)','NO', '','-1','');
INSERT INTO `table_columns` VALUES ('reports_items',11,'graph_template_id','int( 11)','NO','','-1',''); INSERT INTO `table_columns` VALUES ('reports_items',11,'graph_template_id','int( 11)','NO','','-1','');
INSERT INTO `table_columns` VALUES ('reports_items',12,'local_graph_id','int(10) unsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('reports_items',12,'local_graph_id','int(10) unsigned','NO','','0','');
INSERT INTO `table_columns` VALUES ('reports_items',13,'timespan','int(10) unsig ned','NO','','0',''); INSERT INTO `table_columns` VALUES ('reports_items',13,'timespan','int(10) unsig ned','NO','','0','');
INSERT INTO `table_columns` VALUES ('reports_items',14,'align','tinyint(1) unsig ned','NO','','1',''); INSERT INTO `table_columns` VALUES ('reports_items',14,'align','tinyint(3) unsig ned','NO','','1','');
INSERT INTO `table_columns` VALUES ('reports_items',15,'item_text','text','NO',' ',NULL,''); INSERT INTO `table_columns` VALUES ('reports_items',15,'item_text','text','NO',' ',NULL,'');
INSERT INTO `table_columns` VALUES ('reports_items',16,'font_size','smallint(2) unsigned','NO','','10',''); INSERT INTO `table_columns` VALUES ('reports_items',16,'font_size','smallint(2) unsigned','NO','','10','');
INSERT INTO `table_columns` VALUES ('reports_items',17,'sequence','smallint(5) u nsigned','NO','','0',''); INSERT INTO `table_columns` VALUES ('reports_items',17,'sequence','smallint(5) u nsigned','NO','','0','');
INSERT INTO `table_columns` VALUES ('sessions',1,'id','varchar(32)','NO','PRI',N ULL,''); INSERT INTO `table_columns` VALUES ('sessions',1,'id','varchar(32)','NO','PRI',N ULL,'');
INSERT INTO `table_columns` VALUES ('sessions',2,'remote_addr','varchar(25)','NO ','','',''); INSERT INTO `table_columns` VALUES ('sessions',2,'remote_addr','varchar(25)','NO ','','','');
INSERT INTO `table_columns` VALUES ('sessions',3,'access','int(10) unsigned','YE S','',NULL,''); INSERT INTO `table_columns` VALUES ('sessions',3,'access','int(10) unsigned','YE S','',NULL,'');
INSERT INTO `table_columns` VALUES ('sessions',4,'data','mediumblob','YES','',NU LL,''); INSERT INTO `table_columns` VALUES ('sessions',4,'data','mediumblob','YES','',NU LL,'');
INSERT INTO `table_columns` VALUES ('sessions',5,'user_id','int(10) unsigned','N O','','0',''); INSERT INTO `table_columns` VALUES ('sessions',5,'user_id','int(10) unsigned','N O','','0','');
INSERT INTO `table_columns` VALUES ('sessions',6,'user_agent','varchar(128)','NO ','','',''); INSERT INTO `table_columns` VALUES ('sessions',6,'user_agent','varchar(128)','NO ','','','');
INSERT INTO `table_columns` VALUES ('sessions',7,'start_time','timestamp','NO',' ','current_timestamp()',''); INSERT INTO `table_columns` VALUES ('sessions',7,'start_time','timestamp','NO',' ','current_timestamp()','');
INSERT INTO `table_columns` VALUES ('sessions',8,'transactions','int(10) unsigne d','NO','','1',''); INSERT INTO `table_columns` VALUES ('sessions',8,'transactions','int(10) unsigne d','NO','','1','');
INSERT INTO `table_columns` VALUES ('settings',1,'name','varchar(50)','NO','PRI' ,'',''); INSERT INTO `table_columns` VALUES ('settings',1,'name','varchar(50)','NO','PRI' ,'','');
INSERT INTO `table_columns` VALUES ('settings',2,'value','varchar(2048)','NO','' ,'',''); INSERT INTO `table_columns` VALUES ('settings',2,'value','varchar(2048)','NO','' ,'','');
INSERT INTO `table_columns` VALUES ('settings_tree',1,'user_id','mediumint(8) un signed','NO','PRI','0',''); INSERT INTO `table_columns` VALUES ('settings_tree',1,'user_id','mediumint(8) un signed','NO','PRI','0','');
INSERT INTO `table_columns` VALUES ('settings_tree',2,'graph_tree_item_id','int( 10) unsigned','NO','PRI','0',''); INSERT INTO `table_columns` VALUES ('settings_tree',2,'graph_tree_item_id','int( 10) unsigned','NO','PRI','0','');
INSERT INTO `table_columns` VALUES ('settings_tree',3,'status','tinyint(1)','NO' ,'','0',''); INSERT INTO `table_columns` VALUES ('settings_tree',3,'status','tinyint(3) unsig ned','NO','','0','');
INSERT INTO `table_columns` VALUES ('settings_user',1,'user_id','smallint(8) uns igned','NO','PRI','0',''); INSERT INTO `table_columns` VALUES ('settings_user',1,'user_id','smallint(8) uns igned','NO','PRI','0','');
INSERT INTO `table_columns` VALUES ('settings_user',2,'name','varchar(50)','NO', 'PRI','',''); INSERT INTO `table_columns` VALUES ('settings_user',2,'name','varchar(50)','NO', 'PRI','','');
INSERT INTO `table_columns` VALUES ('settings_user',3,'value','varchar(2048)','N O','','',''); INSERT INTO `table_columns` VALUES ('settings_user',3,'value','varchar(2048)','N O','','','');
INSERT INTO `table_columns` VALUES ('settings_user_group',1,'group_id','smallint (8) unsigned','NO','PRI','0',''); INSERT INTO `table_columns` VALUES ('settings_user_group',1,'group_id','smallint (8) unsigned','NO','PRI','0','');
INSERT INTO `table_columns` VALUES ('settings_user_group',2,'name','varchar(50)' ,'NO','PRI','',''); INSERT INTO `table_columns` VALUES ('settings_user_group',2,'name','varchar(50)' ,'NO','PRI','','');
INSERT INTO `table_columns` VALUES ('settings_user_group',3,'value','varchar(204 8)','NO','','',''); INSERT INTO `table_columns` VALUES ('settings_user_group',3,'value','varchar(204 8)','NO','','','');
INSERT INTO `table_columns` VALUES ('sites',1,'id','int(10) unsigned','NO','PRI' ,NULL,'auto_increment'); INSERT INTO `table_columns` VALUES ('sites',1,'id','int(10) unsigned','NO','PRI' ,NULL,'auto_increment');
INSERT INTO `table_columns` VALUES ('sites',2,'name','varchar(100)','NO','MUL',' ',''); INSERT INTO `table_columns` VALUES ('sites',2,'name','varchar(100)','NO','MUL',' ','');
INSERT INTO `table_columns` VALUES ('sites',3,'address1','varchar(100)','YES','' ,'',''); INSERT INTO `table_columns` VALUES ('sites',3,'address1','varchar(100)','YES','' ,'','');
INSERT INTO `table_columns` VALUES ('sites',4,'address2','varchar(100)','YES','' ,'',''); INSERT INTO `table_columns` VALUES ('sites',4,'address2','varchar(100)','YES','' ,'','');
skipping to change at line 902 skipping to change at line 902
INSERT INTO `table_columns` VALUES ('snmpagent_cache',8,'value','varchar(255)',' NO','','',''); INSERT INTO `table_columns` VALUES ('snmpagent_cache',8,'value','varchar(255)',' NO','','','');
INSERT INTO `table_columns` VALUES ('snmpagent_cache',9,'description','varchar(5 000)','NO','','',''); INSERT INTO `table_columns` VALUES ('snmpagent_cache',9,'description','varchar(5 000)','NO','','','');
INSERT INTO `table_columns` VALUES ('snmpagent_cache_notifications',1,'name','va rchar(50)','NO','PRI',NULL,''); INSERT INTO `table_columns` VALUES ('snmpagent_cache_notifications',1,'name','va rchar(50)','NO','PRI',NULL,'');
INSERT INTO `table_columns` VALUES ('snmpagent_cache_notifications',2,'mib','var char(50)','NO','PRI',NULL,''); INSERT INTO `table_columns` VALUES ('snmpagent_cache_notifications',2,'mib','var char(50)','NO','PRI',NULL,'');
INSERT INTO `table_columns` VALUES ('snmpagent_cache_notifications',3,'attribute ','varchar(50)','NO','PRI',NULL,''); INSERT INTO `table_columns` VALUES ('snmpagent_cache_notifications',3,'attribute ','varchar(50)','NO','PRI',NULL,'');
INSERT INTO `table_columns` VALUES ('snmpagent_cache_notifications',4,'sequence_ id','smallint(6)','NO','PRI',NULL,''); INSERT INTO `table_columns` VALUES ('snmpagent_cache_notifications',4,'sequence_ id','smallint(6)','NO','PRI',NULL,'');
INSERT INTO `table_columns` VALUES ('snmpagent_cache_textual_conventions',1,'nam e','varchar(50)','NO','PRI',NULL,''); INSERT INTO `table_columns` VALUES ('snmpagent_cache_textual_conventions',1,'nam e','varchar(50)','NO','PRI',NULL,'');
INSERT INTO `table_columns` VALUES ('snmpagent_cache_textual_conventions',2,'mib ','varchar(50)','NO','PRI',NULL,''); INSERT INTO `table_columns` VALUES ('snmpagent_cache_textual_conventions',2,'mib ','varchar(50)','NO','PRI',NULL,'');
INSERT INTO `table_columns` VALUES ('snmpagent_cache_textual_conventions',3,'typ e','varchar(50)','NO','PRI','',''); INSERT INTO `table_columns` VALUES ('snmpagent_cache_textual_conventions',3,'typ e','varchar(50)','NO','PRI','','');
INSERT INTO `table_columns` VALUES ('snmpagent_cache_textual_conventions',4,'des cription','varchar(5000)','NO','','',''); INSERT INTO `table_columns` VALUES ('snmpagent_cache_textual_conventions',4,'des cription','varchar(5000)','NO','','','');
INSERT INTO `table_columns` VALUES ('snmpagent_managers',1,'id','int(8)','NO','P RI',NULL,'auto_increment'); INSERT INTO `table_columns` VALUES ('snmpagent_managers',1,'id','int(10) unsigne d','NO','PRI',NULL,'auto_increment');
INSERT INTO `table_columns` VALUES ('snmpagent_managers',2,'hostname','varchar(1 00)','NO','MUL',NULL,''); INSERT INTO `table_columns` VALUES ('snmpagent_managers',2,'hostname','varchar(1 00)','NO','MUL',NULL,'');
INSERT INTO `table_columns` VALUES ('snmpagent_managers',3,'description','varcha r(255)','NO','',NULL,''); INSERT INTO `table_columns` VALUES ('snmpagent_managers',3,'description','varcha r(255)','NO','',NULL,'');
INSERT INTO `table_columns` VALUES ('snmpagent_managers',4,'disabled','char(2)', 'YES','',NULL,''); INSERT INTO `table_columns` VALUES ('snmpagent_managers',4,'disabled','char(2)', 'YES','',NULL,'');
INSERT INTO `table_columns` VALUES ('snmpagent_managers',5,'max_log_size','tinyi INSERT INTO `table_columns` VALUES ('snmpagent_managers',5,'max_log_size','tinyi
nt(1)','NO','',NULL,''); nt(4)','NO','',NULL,'');
INSERT INTO `table_columns` VALUES ('snmpagent_managers',6,'snmp_version','tinyi INSERT INTO `table_columns` VALUES ('snmpagent_managers',6,'snmp_version','tinyi
nt(1) unsigned','NO','','1',''); nt(3) unsigned','NO','','1','');
INSERT INTO `table_columns` VALUES ('snmpagent_managers',7,'snmp_community','var char(100)','NO','','',''); INSERT INTO `table_columns` VALUES ('snmpagent_managers',7,'snmp_community','var char(100)','NO','','','');
INSERT INTO `table_columns` VALUES ('snmpagent_managers',8,'snmp_username','varc har(50)','NO','',NULL,''); INSERT INTO `table_columns` VALUES ('snmpagent_managers',8,'snmp_username','varc har(50)','NO','',NULL,'');
INSERT INTO `table_columns` VALUES ('snmpagent_managers',9,'snmp_password','varc har(50)','NO','',NULL,''); INSERT INTO `table_columns` VALUES ('snmpagent_managers',9,'snmp_password','varc har(50)','NO','',NULL,'');
INSERT INTO `table_columns` VALUES ('snmpagent_managers',10,'snmp_auth_protocol' ,'char(6)','NO','',NULL,''); INSERT INTO `table_columns` VALUES ('snmpagent_managers',10,'snmp_auth_protocol' ,'char(6)','NO','',NULL,'');
INSERT INTO `table_columns` VALUES ('snmpagent_managers',11,'snmp_priv_passphras e','varchar(200)','NO','',NULL,''); INSERT INTO `table_columns` VALUES ('snmpagent_managers',11,'snmp_priv_passphras e','varchar(200)','NO','',NULL,'');
INSERT INTO `table_columns` VALUES ('snmpagent_managers',12,'snmp_priv_protocol' ,'char(6)','NO','',NULL,''); INSERT INTO `table_columns` VALUES ('snmpagent_managers',12,'snmp_priv_protocol' ,'char(6)','NO','',NULL,'');
INSERT INTO `table_columns` VALUES ('snmpagent_managers',13,'snmp_engine_id','va rchar(64)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('snmpagent_managers',13,'snmp_engine_id','va rchar(64)','YES','',NULL,'');
INSERT INTO `table_columns` VALUES ('snmpagent_managers',14,'snmp_port','mediumi INSERT INTO `table_columns` VALUES ('snmpagent_managers',14,'snmp_port','mediumi
nt(5) unsigned','NO','','161',''); nt(8) unsigned','NO','','161','');
INSERT INTO `table_columns` VALUES ('snmpagent_managers',15,'snmp_message_type', INSERT INTO `table_columns` VALUES ('snmpagent_managers',15,'snmp_message_type',
'tinyint(1)','NO','',NULL,''); 'tinyint(4)','NO','',NULL,'');
INSERT INTO `table_columns` VALUES ('snmpagent_managers',16,'notes','text','YES' ,'',NULL,''); INSERT INTO `table_columns` VALUES ('snmpagent_managers',16,'notes','text','YES' ,'',NULL,'');
INSERT INTO `table_columns` VALUES ('snmpagent_managers_notifications',1,'manage r_id','int(8)','NO','PRI',NULL,''); INSERT INTO `table_columns` VALUES ('snmpagent_managers_notifications',1,'manage r_id','int(10) unsigned','NO','PRI',NULL,'');
INSERT INTO `table_columns` VALUES ('snmpagent_managers_notifications',2,'notifi cation','varchar(50)','NO','PRI',NULL,''); INSERT INTO `table_columns` VALUES ('snmpagent_managers_notifications',2,'notifi cation','varchar(50)','NO','PRI',NULL,'');
INSERT INTO `table_columns` VALUES ('snmpagent_managers_notifications',3,'mib',' varchar(50)','NO','PRI',NULL,''); INSERT INTO `table_columns` VALUES ('snmpagent_managers_notifications',3,'mib',' varchar(50)','NO','PRI',NULL,'');
INSERT INTO `table_columns` VALUES ('snmpagent_mibs',1,'id','int(8)','NO','PRI', NULL,'auto_increment'); INSERT INTO `table_columns` VALUES ('snmpagent_mibs',1,'id','int(10) unsigned',' NO','PRI',NULL,'auto_increment');
INSERT INTO `table_columns` VALUES ('snmpagent_mibs',2,'name','varchar(50)','NO' ,'','',''); INSERT INTO `table_columns` VALUES ('snmpagent_mibs',2,'name','varchar(50)','NO' ,'','','');
INSERT INTO `table_columns` VALUES ('snmpagent_mibs',3,'file','varchar(255)','NO ','','',''); INSERT INTO `table_columns` VALUES ('snmpagent_mibs',3,'file','varchar(255)','NO ','','','');
INSERT INTO `table_columns` VALUES ('snmpagent_notifications_log',1,'id','int(12 )','NO','PRI',NULL,'auto_increment'); INSERT INTO `table_columns` VALUES ('snmpagent_notifications_log',1,'id','int(10 ) unsigned','NO','PRI',NULL,'auto_increment');
INSERT INTO `table_columns` VALUES ('snmpagent_notifications_log',2,'time','int( 24)','NO','MUL',NULL,''); INSERT INTO `table_columns` VALUES ('snmpagent_notifications_log',2,'time','int( 24)','NO','MUL',NULL,'');
INSERT INTO `table_columns` VALUES ('snmpagent_notifications_log',3,'severity',' INSERT INTO `table_columns` VALUES ('snmpagent_notifications_log',3,'severity','
tinyint(1)','NO','MUL',NULL,''); tinyint(4)','NO','MUL',NULL,'');
INSERT INTO `table_columns` VALUES ('snmpagent_notifications_log',4,'manager_id' INSERT INTO `table_columns` VALUES ('snmpagent_notifications_log',4,'manager_id'
,'int(8)','NO','MUL',NULL,''); ,'int(10) unsigned','NO','MUL',NULL,'');
INSERT INTO `table_columns` VALUES ('snmpagent_notifications_log',5,'notificatio n','varchar(190)','NO','',NULL,''); INSERT INTO `table_columns` VALUES ('snmpagent_notifications_log',5,'notificatio n','varchar(190)','NO','',NULL,'');
INSERT INTO `table_columns` VALUES ('snmpagent_notifications_log',6,'mib','varch ar(50)','NO','',NULL,''); INSERT INTO `table_columns` VALUES ('snmpagent_notifications_log',6,'mib','varch ar(50)','NO','',NULL,'');
INSERT INTO `table_columns` VALUES ('snmpagent_notifications_log',7,'varbinds',' varchar(5000)','NO','',NULL,''); INSERT INTO `table_columns` VALUES ('snmpagent_notifications_log',7,'varbinds',' varchar(5000)','NO','',NULL,'');
INSERT INTO `table_columns` VALUES ('table_columns',1,'table_name','varchar(50)' ,'NO','PRI',NULL,''); INSERT INTO `table_columns` VALUES ('table_columns',1,'table_name','varchar(50)' ,'NO','PRI',NULL,'');
INSERT INTO `table_columns` VALUES ('table_columns',2,'table_sequence','int(10) unsigned','NO','PRI',NULL,''); INSERT INTO `table_columns` VALUES ('table_columns',2,'table_sequence','int(10) unsigned','NO','PRI',NULL,'');
INSERT INTO `table_columns` VALUES ('table_columns',3,'table_field','varchar(50) ','NO','PRI',NULL,''); INSERT INTO `table_columns` VALUES ('table_columns',3,'table_field','varchar(50) ','NO','PRI',NULL,'');
INSERT INTO `table_columns` VALUES ('table_columns',4,'table_type','varchar(50)' ,'YES','',NULL,''); INSERT INTO `table_columns` VALUES ('table_columns',4,'table_type','varchar(50)' ,'YES','',NULL,'');
INSERT INTO `table_columns` VALUES ('table_columns',5,'table_null','varchar(10)' ,'YES','',NULL,''); INSERT INTO `table_columns` VALUES ('table_columns',5,'table_null','varchar(10)' ,'YES','',NULL,'');
INSERT INTO `table_columns` VALUES ('table_columns',6,'table_key','varchar(4)',' YES','',NULL,''); INSERT INTO `table_columns` VALUES ('table_columns',6,'table_key','varchar(4)',' YES','',NULL,'');
INSERT INTO `table_columns` VALUES ('table_columns',7,'table_default','varchar(5 0)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('table_columns',7,'table_default','varchar(5 0)','YES','',NULL,'');
skipping to change at line 963 skipping to change at line 963
INSERT INTO `table_columns` VALUES ('user_auth',3,'password','varchar(256)','NO' ,'','',''); INSERT INTO `table_columns` VALUES ('user_auth',3,'password','varchar(256)','NO' ,'','','');
INSERT INTO `table_columns` VALUES ('user_auth',4,'realm','mediumint(8)','NO','M UL','0',''); INSERT INTO `table_columns` VALUES ('user_auth',4,'realm','mediumint(8)','NO','M UL','0','');
INSERT INTO `table_columns` VALUES ('user_auth',5,'full_name','varchar(100)','YE S','','0',''); INSERT INTO `table_columns` VALUES ('user_auth',5,'full_name','varchar(100)','YE S','','0','');
INSERT INTO `table_columns` VALUES ('user_auth',6,'email_address','varchar(128)' ,'YES','',NULL,''); INSERT INTO `table_columns` VALUES ('user_auth',6,'email_address','varchar(128)' ,'YES','',NULL,'');
INSERT INTO `table_columns` VALUES ('user_auth',7,'must_change_password','char(2 )','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('user_auth',7,'must_change_password','char(2 )','YES','',NULL,'');
INSERT INTO `table_columns` VALUES ('user_auth',8,'password_change','char(2)','Y ES','','on',''); INSERT INTO `table_columns` VALUES ('user_auth',8,'password_change','char(2)','Y ES','','on','');
INSERT INTO `table_columns` VALUES ('user_auth',9,'show_tree','char(2)','YES','' ,'on',''); INSERT INTO `table_columns` VALUES ('user_auth',9,'show_tree','char(2)','YES','' ,'on','');
INSERT INTO `table_columns` VALUES ('user_auth',10,'show_list','char(2)','YES',' ','on',''); INSERT INTO `table_columns` VALUES ('user_auth',10,'show_list','char(2)','YES',' ','on','');
INSERT INTO `table_columns` VALUES ('user_auth',11,'show_preview','char(2)','NO' ,'','on',''); INSERT INTO `table_columns` VALUES ('user_auth',11,'show_preview','char(2)','NO' ,'','on','');
INSERT INTO `table_columns` VALUES ('user_auth',12,'graph_settings','char(2)','Y ES','',NULL,''); INSERT INTO `table_columns` VALUES ('user_auth',12,'graph_settings','char(2)','Y ES','',NULL,'');
INSERT INTO `table_columns` VALUES ('user_auth',13,'login_opts','tinyint(1)','NO INSERT INTO `table_columns` VALUES ('user_auth',13,'login_opts','tinyint(3) unsi
','','1',''); gned','NO','','1','');
INSERT INTO `table_columns` VALUES ('user_auth',14,'policy_graphs','tinyint(1) u INSERT INTO `table_columns` VALUES ('user_auth',14,'policy_graphs','tinyint(3) u
nsigned','NO','','1',''); nsigned','NO','','1','');
INSERT INTO `table_columns` VALUES ('user_auth',15,'policy_trees','tinyint(1) un INSERT INTO `table_columns` VALUES ('user_auth',15,'policy_trees','tinyint(3) un
signed','NO','','1',''); signed','NO','','1','');
INSERT INTO `table_columns` VALUES ('user_auth',16,'policy_hosts','tinyint(1) un INSERT INTO `table_columns` VALUES ('user_auth',16,'policy_hosts','tinyint(3) un
signed','NO','','1',''); signed','NO','','1','');
INSERT INTO `table_columns` VALUES ('user_auth',17,'policy_graph_templates','tin INSERT INTO `table_columns` VALUES ('user_auth',17,'policy_graph_templates','tin
yint(1) unsigned','NO','','1',''); yint(3) unsigned','NO','','1','');
INSERT INTO `table_columns` VALUES ('user_auth',18,'enabled','char(2)','NO','MUL ','on',''); INSERT INTO `table_columns` VALUES ('user_auth',18,'enabled','char(2)','NO','MUL ','on','');
INSERT INTO `table_columns` VALUES ('user_auth',19,'lastchange','int(12)','NO',' INSERT INTO `table_columns` VALUES ('user_auth',19,'lastchange','int(11)','NO','
','-1',''); ','-1','');
INSERT INTO `table_columns` VALUES ('user_auth',20,'lastlogin','int(12)','NO','' INSERT INTO `table_columns` VALUES ('user_auth',20,'lastlogin','int(11)','NO',''
,'-1',''); ,'-1','');
INSERT INTO `table_columns` VALUES ('user_auth',21,'password_history','varchar(4 096)','NO','','-1',''); INSERT INTO `table_columns` VALUES ('user_auth',21,'password_history','varchar(4 096)','NO','','-1','');
INSERT INTO `table_columns` VALUES ('user_auth',22,'locked','varchar(3)','NO','' ,'',''); INSERT INTO `table_columns` VALUES ('user_auth',22,'locked','varchar(3)','NO','' ,'','');
INSERT INTO `table_columns` VALUES ('user_auth',23,'failed_attempts','int(5)','N O','','0',''); INSERT INTO `table_columns` VALUES ('user_auth',23,'failed_attempts','int(5)','N O','','0','');
INSERT INTO `table_columns` VALUES ('user_auth',24,'lastfail','int(12)','NO','', INSERT INTO `table_columns` VALUES ('user_auth',24,'lastfail','int(10) unsigned'
'0',''); ,'NO','','0','');
INSERT INTO `table_columns` VALUES ('user_auth',25,'reset_perms','int(12) unsign INSERT INTO `table_columns` VALUES ('user_auth',25,'reset_perms','int(10) unsign
ed','NO','','0',''); ed','NO','','0','');
INSERT INTO `table_columns` VALUES ('user_auth_cache',1,'id','int(10) unsigned', 'NO','PRI',NULL,'auto_increment'); INSERT INTO `table_columns` VALUES ('user_auth_cache',1,'id','int(10) unsigned', 'NO','PRI',NULL,'auto_increment');
INSERT INTO `table_columns` VALUES ('user_auth_cache',2,'user_id','int(10) unsig ned','NO','MUL','0',''); INSERT INTO `table_columns` VALUES ('user_auth_cache',2,'user_id','int(10) unsig ned','NO','MUL','0','');
INSERT INTO `table_columns` VALUES ('user_auth_cache',3,'hostname','varchar(100) ','NO','MUL','',''); INSERT INTO `table_columns` VALUES ('user_auth_cache',3,'hostname','varchar(100) ','NO','MUL','','');
INSERT INTO `table_columns` VALUES ('user_auth_cache',4,'last_update','timestamp ','NO','MUL','current_timestamp()',''); INSERT INTO `table_columns` VALUES ('user_auth_cache',4,'last_update','timestamp ','NO','MUL','current_timestamp()','');
INSERT INTO `table_columns` VALUES ('user_auth_cache',5,'token','varchar(191)',' NO','UNI','',''); INSERT INTO `table_columns` VALUES ('user_auth_cache',5,'token','varchar(191)',' NO','UNI','','');
INSERT INTO `table_columns` VALUES ('user_auth_group',1,'id','int(10) unsigned', 'NO','PRI',NULL,'auto_increment'); INSERT INTO `table_columns` VALUES ('user_auth_group',1,'id','int(10) unsigned', 'NO','PRI',NULL,'auto_increment');
INSERT INTO `table_columns` VALUES ('user_auth_group',2,'name','varchar(20)','NO ','',NULL,''); INSERT INTO `table_columns` VALUES ('user_auth_group',2,'name','varchar(20)','NO ','',NULL,'');
INSERT INTO `table_columns` VALUES ('user_auth_group',3,'description','varchar(2 55)','NO','','',''); INSERT INTO `table_columns` VALUES ('user_auth_group',3,'description','varchar(2 55)','NO','','','');
INSERT INTO `table_columns` VALUES ('user_auth_group',4,'graph_settings','varcha r(2)','YES','',NULL,''); INSERT INTO `table_columns` VALUES ('user_auth_group',4,'graph_settings','varcha r(2)','YES','',NULL,'');
INSERT INTO `table_columns` VALUES ('user_auth_group',5,'login_opts','tinyint(1) ','NO','','1',''); INSERT INTO `table_columns` VALUES ('user_auth_group',5,'login_opts','tinyint(3) unsigned','NO','','1','');
INSERT INTO `table_columns` VALUES ('user_auth_group',6,'show_tree','varchar(2)' ,'YES','','on',''); INSERT INTO `table_columns` VALUES ('user_auth_group',6,'show_tree','varchar(2)' ,'YES','','on','');
INSERT INTO `table_columns` VALUES ('user_auth_group',7,'show_list','varchar(2)' ,'YES','','on',''); INSERT INTO `table_columns` VALUES ('user_auth_group',7,'show_list','varchar(2)' ,'YES','','on','');
INSERT INTO `table_columns` VALUES ('user_auth_group',8,'show_preview','varchar( 2)','NO','','on',''); INSERT INTO `table_columns` VALUES ('user_auth_group',8,'show_preview','varchar( 2)','NO','','on','');
INSERT INTO `table_columns` VALUES ('user_auth_group',9,'policy_graphs','tinyint INSERT INTO `table_columns` VALUES ('user_auth_group',9,'policy_graphs','tinyint
(1) unsigned','NO','','1',''); (3) unsigned','NO','','1','');
INSERT INTO `table_columns` VALUES ('user_auth_group',10,'policy_trees','tinyint INSERT INTO `table_columns` VALUES ('user_auth_group',10,'policy_trees','tinyint
(1) unsigned','NO','','1',''); (3) unsigned','NO','','1','');
INSERT INTO `table_columns` VALUES ('user_auth_group',11,'policy_hosts','tinyint INSERT INTO `table_columns` VALUES ('user_auth_group',11,'policy_hosts','tinyint
(1) unsigned','NO','','1',''); (3) unsigned','NO','','1','');
INSERT INTO `table_columns` VALUES ('user_auth_group',12,'policy_graph_templates INSERT INTO `table_columns` VALUES ('user_auth_group',12,'policy_graph_templates
','tinyint(1) unsigned','NO','','1',''); ','tinyint(3) unsigned','NO','','1','');
INSERT INTO `table_columns` VALUES ('user_auth_group',13,'enabled','char(2)','NO ','','on',''); INSERT INTO `table_columns` VALUES ('user_auth_group',13,'enabled','char(2)','NO ','','on','');
INSERT INTO `table_columns` VALUES ('user_auth_group_members',1,'group_id','int( 10) unsigned','NO','PRI',NULL,''); INSERT INTO `table_columns` VALUES ('user_auth_group_members',1,'group_id','int( 10) unsigned','NO','PRI',NULL,'');
INSERT INTO `table_columns` VALUES ('user_auth_group_members',2,'user_id','int(1 0) unsigned','NO','PRI',NULL,''); INSERT INTO `table_columns` VALUES ('user_auth_group_members',2,'user_id','int(1 0) unsigned','NO','PRI',NULL,'');
INSERT INTO `table_columns` VALUES ('user_auth_group_perms',1,'group_id','medium int(8) unsigned','NO','PRI','0',''); INSERT INTO `table_columns` VALUES ('user_auth_group_perms',1,'group_id','medium int(8) unsigned','NO','PRI','0','');
INSERT INTO `table_columns` VALUES ('user_auth_group_perms',2,'item_id','mediumi nt(8) unsigned','NO','PRI','0',''); INSERT INTO `table_columns` VALUES ('user_auth_group_perms',2,'item_id','mediumi nt(8) unsigned','NO','PRI','0','');
INSERT INTO `table_columns` VALUES ('user_auth_group_perms',3,'type','tinyint(2) unsigned','NO','PRI','0',''); INSERT INTO `table_columns` VALUES ('user_auth_group_perms',3,'type','tinyint(3) unsigned','NO','PRI','0','');
INSERT INTO `table_columns` VALUES ('user_auth_group_realm',1,'group_id','int(10 ) unsigned','NO','PRI',NULL,''); INSERT INTO `table_columns` VALUES ('user_auth_group_realm',1,'group_id','int(10 ) unsigned','NO','PRI',NULL,'');
INSERT INTO `table_columns` VALUES ('user_auth_group_realm',2,'realm_id','int(10 ) unsigned','NO','PRI',NULL,''); INSERT INTO `table_columns` VALUES ('user_auth_group_realm',2,'realm_id','int(10 ) unsigned','NO','PRI',NULL,'');
INSERT INTO `table_columns` VALUES ('user_auth_perms',1,'user_id','mediumint(8) unsigned','NO','PRI','0',''); INSERT INTO `table_columns` VALUES ('user_auth_perms',1,'user_id','mediumint(8) unsigned','NO','PRI','0','');
INSERT INTO `table_columns` VALUES ('user_auth_perms',2,'item_id','mediumint(8) unsigned','NO','PRI','0',''); INSERT INTO `table_columns` VALUES ('user_auth_perms',2,'item_id','mediumint(8) unsigned','NO','PRI','0','');
INSERT INTO `table_columns` VALUES ('user_auth_perms',3,'type','tinyint(2) unsig ned','NO','PRI','0',''); INSERT INTO `table_columns` VALUES ('user_auth_perms',3,'type','tinyint(3) unsig ned','NO','PRI','0','');
INSERT INTO `table_columns` VALUES ('user_auth_realm',1,'realm_id','mediumint(8) unsigned','NO','PRI','0',''); INSERT INTO `table_columns` VALUES ('user_auth_realm',1,'realm_id','mediumint(8) unsigned','NO','PRI','0','');
INSERT INTO `table_columns` VALUES ('user_auth_realm',2,'user_id','mediumint(8) unsigned','NO','PRI','0',''); INSERT INTO `table_columns` VALUES ('user_auth_realm',2,'user_id','mediumint(8) unsigned','NO','PRI','0','');
INSERT INTO `table_columns` VALUES ('user_domains',1,'domain_id','int(10) unsign ed','NO','PRI',NULL,'auto_increment'); INSERT INTO `table_columns` VALUES ('user_domains',1,'domain_id','int(10) unsign ed','NO','PRI',NULL,'auto_increment');
INSERT INTO `table_columns` VALUES ('user_domains',2,'domain_name','varchar(20)' ,'NO','',NULL,''); INSERT INTO `table_columns` VALUES ('user_domains',2,'domain_name','varchar(20)' ,'NO','',NULL,'');
INSERT INTO `table_columns` VALUES ('user_domains',3,'type','int(10) unsigned',' NO','','0',''); INSERT INTO `table_columns` VALUES ('user_domains',3,'type','int(10) unsigned',' NO','','0','');
INSERT INTO `table_columns` VALUES ('user_domains',4,'enabled','char(2)','NO','' ,'on',''); INSERT INTO `table_columns` VALUES ('user_domains',4,'enabled','char(2)','NO','' ,'on','');
INSERT INTO `table_columns` VALUES ('user_domains',5,'defdomain','tinyint(3)','N O','','0',''); INSERT INTO `table_columns` VALUES ('user_domains',5,'defdomain','tinyint(3) uns igned','NO','','0','');
INSERT INTO `table_columns` VALUES ('user_domains',6,'user_id','int(10) unsigned ','NO','','0',''); INSERT INTO `table_columns` VALUES ('user_domains',6,'user_id','int(10) unsigned ','NO','','0','');
INSERT INTO `table_columns` VALUES ('user_domains_ldap',1,'domain_id','int(10) u nsigned','NO','PRI',NULL,''); INSERT INTO `table_columns` VALUES ('user_domains_ldap',1,'domain_id','int(10) u nsigned','NO','PRI',NULL,'');
INSERT INTO `table_columns` VALUES ('user_domains_ldap',2,'server','varchar(128) ','NO','',NULL,''); INSERT INTO `table_columns` VALUES ('user_domains_ldap',2,'server','varchar(128) ','NO','',NULL,'');
INSERT INTO `table_columns` VALUES ('user_domains_ldap',3,'port','int(10) unsign ed','NO','',NULL,''); INSERT INTO `table_columns` VALUES ('user_domains_ldap',3,'port','int(10) unsign ed','NO','',NULL,'');
INSERT INTO `table_columns` VALUES ('user_domains_ldap',4,'port_ssl','int(10) un signed','NO','',NULL,''); INSERT INTO `table_columns` VALUES ('user_domains_ldap',4,'port_ssl','int(10) un signed','NO','',NULL,'');
INSERT INTO `table_columns` VALUES ('user_domains_ldap',5,'proto_version','tinyi nt(3) unsigned','NO','',NULL,''); INSERT INTO `table_columns` VALUES ('user_domains_ldap',5,'proto_version','tinyi nt(3) unsigned','NO','',NULL,'');
INSERT INTO `table_columns` VALUES ('user_domains_ldap',6,'encryption','tinyint( 3) unsigned','NO','',NULL,''); INSERT INTO `table_columns` VALUES ('user_domains_ldap',6,'encryption','tinyint( 3) unsigned','NO','',NULL,'');
INSERT INTO `table_columns` VALUES ('user_domains_ldap',7,'referrals','tinyint(3 ) unsigned','NO','',NULL,''); INSERT INTO `table_columns` VALUES ('user_domains_ldap',7,'referrals','tinyint(3 ) unsigned','NO','',NULL,'');
INSERT INTO `table_columns` VALUES ('user_domains_ldap',8,'mode','tinyint(3) uns igned','NO','',NULL,''); INSERT INTO `table_columns` VALUES ('user_domains_ldap',8,'mode','tinyint(3) uns igned','NO','',NULL,'');
INSERT INTO `table_columns` VALUES ('user_domains_ldap',9,'dn','varchar(128)','N O','',NULL,''); INSERT INTO `table_columns` VALUES ('user_domains_ldap',9,'dn','varchar(128)','N O','',NULL,'');
skipping to change at line 1034 skipping to change at line 1034
INSERT INTO `table_columns` VALUES ('user_domains_ldap',13,'group_member_type',' tinyint(3) unsigned','NO','',NULL,''); INSERT INTO `table_columns` VALUES ('user_domains_ldap',13,'group_member_type',' tinyint(3) unsigned','NO','',NULL,'');
INSERT INTO `table_columns` VALUES ('user_domains_ldap',14,'search_base','varcha r(128)','NO','',NULL,''); INSERT INTO `table_columns` VALUES ('user_domains_ldap',14,'search_base','varcha r(128)','NO','',NULL,'');
INSERT INTO `table_columns` VALUES ('user_domains_ldap',15,'search_filter','varc har(512)','NO','',NULL,''); INSERT INTO `table_columns` VALUES ('user_domains_ldap',15,'search_filter','varc har(512)','NO','',NULL,'');
INSERT INTO `table_columns` VALUES ('user_domains_ldap',16,'specific_dn','varcha r(128)','NO','',NULL,''); INSERT INTO `table_columns` VALUES ('user_domains_ldap',16,'specific_dn','varcha r(128)','NO','',NULL,'');
INSERT INTO `table_columns` VALUES ('user_domains_ldap',17,'specific_password',' varchar(128)','NO','',NULL,''); INSERT INTO `table_columns` VALUES ('user_domains_ldap',17,'specific_password',' varchar(128)','NO','',NULL,'');
INSERT INTO `table_columns` VALUES ('user_domains_ldap',18,'cn_full_name','varch ar(50)','YES','','',''); INSERT INTO `table_columns` VALUES ('user_domains_ldap',18,'cn_full_name','varch ar(50)','YES','','','');
INSERT INTO `table_columns` VALUES ('user_domains_ldap',19,'cn_email','varchar(5 0)','YES','','',''); INSERT INTO `table_columns` VALUES ('user_domains_ldap',19,'cn_email','varchar(5 0)','YES','','','');
INSERT INTO `table_columns` VALUES ('user_log',1,'username','varchar(50)','NO',' PRI','0',''); INSERT INTO `table_columns` VALUES ('user_log',1,'username','varchar(50)','NO',' PRI','0','');
INSERT INTO `table_columns` VALUES ('user_log',2,'user_id','mediumint(8)','NO',' PRI','0',''); INSERT INTO `table_columns` VALUES ('user_log',2,'user_id','mediumint(8)','NO',' PRI','0','');
INSERT INTO `table_columns` VALUES ('user_log',3,'time','timestamp','NO','PRI',' 0000-00-00 00:00:00',''); INSERT INTO `table_columns` VALUES ('user_log',3,'time','timestamp','NO','PRI',' 0000-00-00 00:00:00','');
INSERT INTO `table_columns` VALUES ('user_log',4,'result','tinyint(1)','NO','',' 0',''); INSERT INTO `table_columns` VALUES ('user_log',4,'result','tinyint(3) unsigned', 'NO','','0','');
INSERT INTO `table_columns` VALUES ('user_log',5,'ip','varchar(40)','NO','','',' '); INSERT INTO `table_columns` VALUES ('user_log',5,'ip','varchar(40)','NO','','',' ');
INSERT INTO `table_columns` VALUES ('vdef',1,'id','mediumint(8) unsigned','NO',' PRI',NULL,'auto_increment'); INSERT INTO `table_columns` VALUES ('vdef',1,'id','mediumint(8) unsigned','NO',' PRI',NULL,'auto_increment');
INSERT INTO `table_columns` VALUES ('vdef',2,'hash','varchar(32)','NO','MUL','', ''); INSERT INTO `table_columns` VALUES ('vdef',2,'hash','varchar(32)','NO','MUL','', '');
INSERT INTO `table_columns` VALUES ('vdef',3,'name','varchar(255)','NO','MUL','' ,''); INSERT INTO `table_columns` VALUES ('vdef',3,'name','varchar(255)','NO','MUL','' ,'');
INSERT INTO `table_columns` VALUES ('vdef_items',1,'id','mediumint(8) unsigned', 'NO','PRI',NULL,'auto_increment'); INSERT INTO `table_columns` VALUES ('vdef_items',1,'id','mediumint(8) unsigned', 'NO','PRI',NULL,'auto_increment');
INSERT INTO `table_columns` VALUES ('vdef_items',2,'hash','varchar(32)','NO','', '',''); INSERT INTO `table_columns` VALUES ('vdef_items',2,'hash','varchar(32)','NO','', '','');
INSERT INTO `table_columns` VALUES ('vdef_items',3,'vdef_id','mediumint(8) unsig ned','NO','MUL','0',''); INSERT INTO `table_columns` VALUES ('vdef_items',3,'vdef_id','mediumint(8) unsig ned','NO','MUL','0','');
INSERT INTO `table_columns` VALUES ('vdef_items',4,'sequence','mediumint(8) unsi gned','NO','','0',''); INSERT INTO `table_columns` VALUES ('vdef_items',4,'sequence','mediumint(8) unsi gned','NO','','0','');
INSERT INTO `table_columns` VALUES ('vdef_items',5,'type','tinyint(2)','NO','',' 0',''); INSERT INTO `table_columns` VALUES ('vdef_items',5,'type','tinyint(3) unsigned', 'NO','','0','');
INSERT INTO `table_columns` VALUES ('vdef_items',6,'value','varchar(150)','NO',' ','',''); INSERT INTO `table_columns` VALUES ('vdef_items',6,'value','varchar(150)','NO',' ','','');
INSERT INTO `table_columns` VALUES ('version',1,'cacti','char(20)','NO','PRI','' ,''); INSERT INTO `table_columns` VALUES ('version',1,'cacti','char(20)','NO','PRI','' ,'');
/*!40000 ALTER TABLE `table_columns` ENABLE KEYS */; /*!40000 ALTER TABLE `table_columns` ENABLE KEYS */;
UNLOCK TABLES; UNLOCK TABLES;
-- --
-- Table structure for table `table_indexes` -- Table structure for table `table_indexes`
-- --
DROP TABLE IF EXISTS `table_indexes`; DROP TABLE IF EXISTS `table_indexes`;
 End of changes. 63 change blocks. 
142 lines changed or deleted 142 lines changed or added

Home  |  About  |  Features  |  All  |  Newest  |  Dox  |  Diffs  |  RSS Feeds  |  Screenshots  |  Comments  |  Imprint  |  Privacy  |  HTTP(S)