[Perfparse-cvs] _perfparse/scripts mysql_create.sql,1.19,1.20

[Florian G. <re...@us...>]

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;