[Perfparse-cvs] _perfparse/scripts mysql_create.sql,1.21,1.22

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

Update of /cvsroot/perfparse/_perfparse/scripts
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv3408/scripts

Modified Files:
	mysql_create.sql 
Log Message:
start reports


Index: mysql_create.sql
===================================================================
RCS file: /cvsroot/perfparse/_perfparse/scripts/mysql_create.sql,v
retrieving revision 1.21
retrieving revision 1.22
diff -C2 -d -r1.21 -r1.22
*** mysql_create.sql	18 Jun 2007 22:12:38 -0000	1.21
--- mysql_create.sql	20 Jun 2007 22:25:11 -0000	1.22
***************
*** 345,348 ****
--- 345,369 ----
  
  #
+ # Reports are graph collections
+ #
+ 
+ CREATE TABLE IF NOT EXISTS perfdata_reports (
+ 	id INT PRIMARY KEY NOT NULL AUTO_INCREMENT,
+ 	title VARCHAR(80),
+ 	descript TEXT
+ ) type=InnoDB;
+ 
+ 
+ CREATE TABLE IF NOT EXISTS perfdata_report_graphs (
+ 	report_id INT
+ 		REFERENCES perfdata_reports(id)
+ 		ON DELETE RESTRICT,
+ 	graph_id INT
+ 		REFERENCES perfdata_graphs(id)
+ 		ON DELETE RESTRICT,
+ 	position INT NOT NULL default 0
+ ) type=InnoDB;
+ 
+ #
  # Remembers User Settings
  #