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
#
|
