source: ccsd/trunk/dbschema/ccs_graphs.exampledata @ 1269

--
-- Test Data for rrdbot and graphs
--
-- Author:  Chris Browning  <ckb6@cs.waikato.ac.nz>
-- Version:  $Id$
--

-- rrdbot Classes
INSERT INTO rrdbot_class VALUES (DEFAULT, 'interface', 'ifNumber:count', 300, 'AVERAGE', '12/hour * 2 days, 1/hour * 1 month, 12/day * 1 year', 0);
INSERT INTO rrdbot_class VALUES (DEFAULT, 'wireless', 'lsIndex', 300, 'AVERAGE', '12/hour * 2 days, 1/hour * 1 month, 12/day * 1 year', 1);
INSERT INTO rrdbot_class VALUES (DEFAULT, 'solar', 'battVoltage:exist', 300, 'AVERAGE', '12/hour * 2 days, 1/hour * 1 month, 12/day * 1 year', 0);

INSERT INTO rrdbot_class_parts VALUES (DEFAULT, 1,'ifInOctets','ifInOctets','COUNTER',0,NULL);
INSERT INTO rrdbot_class_parts VALUES (DEFAULT, 1,'ifInUcastPkts','ifInUcastPkts','COUNTER',0,NULL);
INSERT INTO rrdbot_class_parts VALUES (DEFAULT, 1,'ifInDiscards','ifInDiscards','COUNTER',0,NULL);
INSERT INTO rrdbot_class_parts VALUES (DEFAULT, 1,'ifInErrors','ifInErrors','COUNTER',0,NULL);
INSERT INTO rrdbot_class_parts VALUES (DEFAULT, 1,'ifInUnknownProtos','ifInUnknownProtos','COUNTER',0,NULL);
INSERT INTO rrdbot_class_parts VALUES (DEFAULT, 1,'ifOutOctets','ifOutOctets','COUNTER',0,NULL);
INSERT INTO rrdbot_class_parts VALUES (DEFAULT, 1,'ifOutUcastPkts','ifOutUcastPkts','COUNTER',0,NULL);
INSERT INTO rrdbot_class_parts VALUES (DEFAULT, 1,'ifOutDiscards','ifOutDiscards','COUNTER',0,NULL);
INSERT INTO rrdbot_class_parts VALUES (DEFAULT, 1,'ifOutErrors','ifOutErrors','COUNTER',0,NULL);

INSERT INTO rrdbot_class_parts VALUES (DEFAULT, 2,'linkCurrentQuality','linkCurrentQuality','GAUGE',NULL,NULL);
INSERT INTO rrdbot_class_parts VALUES (DEFAULT, 2,'linkCurrentSignal','linkCurrentSignalLevel','GAUGE',NULL,NULL);
INSERT INTO rrdbot_class_parts VALUES (DEFAULT, 2,'linkCurrentNoise','linkCurrentNoiseLevel','GAUGE',NULL,NULL);
INSERT INTO rrdbot_class_parts VALUES (DEFAULT, 2,'linkChannel','linkChannel','GAUGE',0,NULL);
INSERT INTO rrdbot_class_parts VALUES (DEFAULT, 2,'linkBitRate','linkBitRate','GAUGE',0,NULL);


INSERT INTO rrdbot_class_parts VALUES (DEFAULT, 3,'battVoltage','battVoltage','GAUGE',0,NULL);
INSERT INTO rrdbot_class_parts VALUES (DEFAULT, 3,'battsenseVoltage','battsenseVoltage','GAUGE',0,NULL);
INSERT INTO rrdbot_class_parts VALUES (DEFAULT, 3,'arrayVoltage','arrayVoltage','GAUGE',0,NULL);
INSERT INTO rrdbot_class_parts VALUES (DEFAULT, 3,'refVoltage','refVoltage','GAUGE',0,NULL);
INSERT INTO rrdbot_class_parts VALUES (DEFAULT, 3,'loadCurrent','loadCurrent','GAUGE',0,NULL);
INSERT INTO rrdbot_class_parts VALUES (DEFAULT, 3,'chargeCurrent','chargeCurrent','GAUGE',0,NULL);
INSERT INTO rrdbot_class_parts VALUES (DEFAULT, 3,'hstemp','hstemp','GAUGE',0,NULL);
INSERT INTO rrdbot_class_parts VALUES (DEFAULT, 3,'battemp','battemp','GAUGE',0,NULL);


-- Graphs

INSERT INTO graph_group VALUES (DEFAULT, 'Traffic');
INSERT INTO graph_group VALUES (DEFAULT, 'Solar');
INSERT INTO graph_group VALUES (DEFAULT, 'SNR');

INSERT INTO graph_type VALUES (DEFAULT, 1, 1, 'ifOctets', 'interface','Bits per second');
INSERT INTO graph_type VALUES (DEFAULT, 1, 1, 'ifErrors', 'interface','Bits per second');
INSERT INTO graph_type VALUES (DEFAULT, 2, 3, 'Voltage', 'solar','Bits per second');

INSERT INTO graph_parts VALUES (DEFAULT, 1, 1, 'DEF', 0, 'ifInOctets','val1', 'AVERAGE');
INSERT INTO graph_parts VALUES (DEFAULT, 1, 1, 'DEF', 0, 'ifOutOctets','val2', 'AVERAGE');
INSERT INTO graph_parts VALUES (DEFAULT, 1, 2, 'CDEF', 0, 'val1,8,*','cval1', '');
INSERT INTO graph_parts VALUES (DEFAULT, 1, 2, 'CDEF', 0, 'val2,8,*','cval2', '');
INSERT INTO graph_parts VALUES (DEFAULT, 1, 3, 'LINE2', '0000FF', 'ifInOctets', 'cval1', '');
INSERT INTO graph_parts VALUES (DEFAULT, 1, 4, 'LINE2', 'FF0000', 'ifOutOctets', 'cval2', '');

INSERT INTO graph_parts VALUES (DEFAULT, 2, 1, 'DEF', 0, 'ifInErrors','val1', 'AVERAGE');
INSERT INTO graph_parts VALUES (DEFAULT, 2, 1, 'DEF', 0, 'ifOutErrors','val2', 'AVERAGE');
INSERT INTO graph_parts VALUES (DEFAULT, 2, 3, 'LINE2', '0000FF', 'Errors In', 'val1', '');
INSERT INTO graph_parts VALUES (DEFAULT, 2, 4, 'LINE2', 'FF0000', 'Errors out', 'val2', '');

INSERT INTO graph_parts VALUES (DEFAULT, 3, 1, 'DEF', 0, 'battVoltage','val1', 'AVERAGE');
INSERT INTO graph_parts VALUES (DEFAULT, 3, 1, 'DEF', 0, 'battsenseVoltage','val2', 'AVERAGE');
INSERT INTO graph_parts VALUES (DEFAULT, 3, 2, 'CDEF', 0, 'val1,1000,/','cval1', '');
INSERT INTO graph_parts VALUES (DEFAULT, 3, 2, 'CDEF', 0, 'val2,1000,/','cval2', '');
INSERT INTO graph_parts VALUES (DEFAULT, 3, 3, 'AREA', '0000FF', 'Batt Voltage', 'cval1', '');
INSERT INTO graph_parts VALUES (DEFAULT, 3, 4, 'LINE2', 'FF0000', 'Sense Voltage', 'cval2', '');

INSERT INTO graph_time VALUES ( DEFAULT, '-1h', 'now', 'Hour');
INSERT INTO graph_time VALUES ( DEFAULT, '-1d', 'now', 'Day');
INSERT INTO graph_time VALUES ( DEFAULT, '-1m', 'now', 'Month');
INSERT INTO graph_time VALUES ( DEFAULT, '-1y', 'now', 'Year');

INSERT INTO snmp_state VALUES ( 0);
-- vim: ft=sql