Update of /cvsroot/perfparse/_perfparse/scripts
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv27476/scripts
Modified Files:
mysql_create.sql
Log Message:
saving graphs another way
Index: mysql_create.sql
===================================================================
RCS file: /cvsroot/perfparse/_perfparse/scripts/mysql_create.sql,v
retrieving revision 1.19
retrieving revision 1.20
diff -C2 -d -r1.19 -r1.20
*** mysql_create.sql 27 Apr 2007 20:54:03 -0000 1.19
--- mysql_create.sql 15 Jun 2007 23:34:30 -0000 1.20
***************
*** 320,332 ****
CREATE TABLE IF NOT EXISTS perfdata_graphs (
id INT PRIMARY KEY NOT NULL AUTO_INCREMENT,
- group_id INT,
- INDEX host_ix0 (group_id),
- FOREIGN KEY (group_id)
- REFERENCES perfdata_groups (group_id)
- ON DELETE SET NULL,
title VARCHAR(80),
descript TEXT,
! url TEXT,
! refresh_time INT NOT NULL DEFAULT 0
) type=InnoDB;
--- 320,345 ----
CREATE TABLE IF NOT EXISTS perfdata_graphs (
id INT PRIMARY KEY NOT NULL AUTO_INCREMENT,
title VARCHAR(80),
descript TEXT,
! refresh_time INT NOT NULL DEFAULT 0,
! metric_id INT
! REFERENCES perfdata_service_metric(metric_id)
! ON DELETE RESTRICT,
! scale INT,
! minin INT,
! maxin INT,
! timerange CHAR(1),
! relativetime INT,
! fromtime INT,
! totime INT,
! output CHAR(1),
! sizex INT,
! sizey INT,
! s_val BOOLEAN,
! s_war BOOLEAN,
! s_cri BOOLEAN,
! s_sta BOOLEAN,
! graphtitle VARCHAR(250),
! g_sigma INT
) type=InnoDB;
|
