Changeset 1437

Timestamp:

03/08/07 16:27:05 (6 years ago)

Author:

ckb6

Message:

Changed the scheema to scale load average graphs and deal with setting scales and Y axis base's.
Fixes:#112

File:

• ccsd/trunk/dbschema/ccs_graphs.schema (modified) (3 diffs)

ccsd/trunk/dbschema/ccs_graphs.schema

@@ -51 +51 @@
     auto_comment    varchar(1) DEFAULT 'f',
     upper           integer DEFAULT NULL,
-    virtical_label  varchar(64)
+    virtical_label  varchar(64),
+    units           integer DEFAULT 1,
+    base           integer DEFAULT NULL
 );
 
@@ -322 +324 @@
 INSERT INTO graph_type VALUES (DEFAULT, 4, 2, 'Signal / Noise', 'wireless', DEFAULT, 't', DEFAULT,'-dbM');
 
-INSERT INTO graph_type VALUES (DEFAULT, 5, 4, 'Load Average', 'processor', DEFAULT, 't', DEFAULT,'');
+INSERT INTO graph_type VALUES (DEFAULT, 5, 4, 'Load Average', 'processor', DEFAULT, 't', DEFAULT,'',0);
 
 INSERT INTO graph_type VALUES (DEFAULT, 6, 5, 'Packets(0-250 bytes)', 'ratestats250', 't', DEFAULT, 100,'%');
@@ -393 +395 @@
 INSERT INTO graph_parts VALUES (DEFAULT, 9, 1, 'DEF', 0, '5-Min-Avg','5m_avg', 'AVERAGE');
 INSERT INTO graph_parts VALUES (DEFAULT, 9, 1, 'DEF', 0, '15-Min-Avg','15m_avg', 'AVERAGE');
-INSERT INTO graph_parts VALUES (DEFAULT, 9, 2, 'AREA', '19e319', '1 Min. Load Average', '1m_avg', '');
-INSERT INTO graph_parts VALUES (DEFAULT, 9, 3, 'STACK', 'ed2510', '5 Min. Load Average', '5m_avg', '');
-INSERT INTO graph_parts VALUES (DEFAULT, 9, 4, 'STACK', 'ffba14', '15 Min. Load Average', '15m_avg', '');
+INSERT INTO graph_parts VALUES (DEFAULT, 9, 2, 'CDEF', 0, '1m_avg,100,/','sc_1m_avg', '');
+INSERT INTO graph_parts VALUES (DEFAULT, 9, 2, 'CDEF', 0, '5m_avg,100,/','sc_5m_avg', '');
+INSERT INTO graph_parts VALUES (DEFAULT, 9, 2, 'CDEF', 0, '15m_avg,100,/','sc_15m_avg', '');
+INSERT INTO graph_parts VALUES (DEFAULT, 9, 3, 'AREA', '19e319', '1 Min. Load Average', 'sc_1m_avg', '');
+INSERT INTO graph_parts VALUES (DEFAULT, 9, 4, 'STACK', 'ed2510', '5 Min. Load Average', 'sc_5m_avg', '');
+INSERT INTO graph_parts VALUES (DEFAULT, 9, 5, 'STACK', 'ffba14', '15 Min. Load Average', 'sc_15m_avg', '');
 
 INSERT INTO graph_parts VALUES (DEFAULT, 10, 1, 'DEF', 0, 'Packets1','t1', 'AVERAGE');