INSERT INTO `interface_types` (`id`, `description`, `autodiscovery_validate`, `autodiscovery_enabled`, `autodiscovery_function`, `autodiscovery_parameters`, `autodiscovery_default_poller`, `have_graph`, `rrd_structure_rra`, `rrd_structure_res`, `rrd_structure_step`, `graph_default`, `break_by_card`, `update_handler`, `allow_manual_add`, `sla_default`, `have_tools`) VALUES (10010,'PDU',1,1,'pdu','',10010,0,'RRA:AVERAGE:0.5:1:<resolution>','103680',300,1,0,'none',0,1,0),(10011,'PDU Banks',0,1,'pdu_banks','',10011,1,'RRA:AVERAGE:0.5:1:<resolution>','103680',300,10011,0,'none',0,1,0);
INSERT INTO `interface_types_fields` (`id`, `description`, `name`, `pos`, `itype`, `ftype`, `showable`, `overwritable`, `tracked`, `default_value`) VALUES (10001,'UPS Type','upstype',50,40,7,1,0,1,''),(10002,'UPS Type','upstype',50,41,7,1,0,1,''),(10003,'Power','power',50,41,20,0,0,0,'DS:power:GAUGE:600:0:100000'),(10010,'Description','description',20,10010,7,1,0,0,''),(10011,'Index','index',10,10010,3,0,0,0,''),(10012,'Index','index',10,10011,3,0,0,0,''),(10013,'Banks','banks',50,10010,7,1,0,0,''),(10014,'Power Rating (Amps)','powerrating',40,10011,7,1,0,0,''),(10015,'Load (Amps)','load',50,10011,20,0,0,0,'DS:load:GAUGE:600:0:100'),(10016,'Overload Threshold','threshold',50,10011,7,1,0,0,'');
INSERT INTO `graph_types` (`id`, `description`, `type`, `graph1`, `graph2`, `sizex1`, `sizey1`, `sizex2`, `sizey2`, `allow_aggregation`) VALUES (10001,'UPS Power',41,'ups_power','',500,150,0,0,1),(10011,'PDU Load',10011,'pdu_load','',500,150,0,0,1);
INSERT INTO `slas` (`id`, `description`, `state`, `info`, `event_type`, `threshold`, `interface_type`) VALUES (10001,'Cisco Router Temperature',3,'Router:',12,100,17);
INSERT INTO `slas_sla_cond` (`id`, `pos`, `sla`, `cond`, `show_in_result`) VALUES (10001,1,1,10001,0),(10002,40,1,10002,0),(10004,10,10001,10002,1);
INSERT INTO `pollers` (`id`, `name`, `description`, `command`, `parameters`) VALUES (10001,'power','UPS Lines Power','ups_line',''),(10010,'status','PDU Load Status','snmp_status','.1.3.6.1.4.1.318.1.1.12.2.3.1.1.3.<index>,1=load normal|2=load low|3=load near overload|4=load ove'),(10011,'load','PDU Banks Load','pdu_banks','');
INSERT INTO `pollers_groups` (`id`, `description`, `interface_type`) VALUES (10010,'PDU',10010),(10011,'PDU Banks',10011);
INSERT INTO `pollers_poller_groups` (`id`, `poller_group`, `pos`, `poller`, `backend`) VALUES (10001,42,50,10001,32),(10010,10010,10,10010,32),(10011,10011,10,10011,32);