[Perfparse-cvs] _perfparse/scripts mysql_create.sql, 1.25, 1.26 mysql_delete.sql, 1.3, 1.4

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

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

Modified Files:
	mysql_create.sql mysql_delete.sql 
Log Message:
again changed db schema slightly and start work on del policies settings ui pages.


Index: mysql_delete.sql
===================================================================
RCS file: /cvsroot/perfparse/_perfparse/scripts/mysql_delete.sql,v
retrieving revision 1.3
retrieving revision 1.4
diff -C2 -d -r1.3 -r1.4
*** mysql_delete.sql	22 Aug 2006 13:37:50 -0000	1.3
--- mysql_delete.sql	3 Sep 2007 22:56:25 -0000	1.4
***************
*** 9,12 ****
--- 9,13 ----
  
  SET FOREIGN_KEY_CHECKS = 0;
+ DROP TABLE IF EXISTS perfdata_instances;
  DROP TABLE IF EXISTS perfdata_service_bin;
  DROP TABLE IF EXISTS perfdata_service_metric;
***************
*** 28,31 ****
--- 29,34 ----
  DROP TABLE IF EXISTS perfdata_prefs;
  DROP TABLE IF EXISTS perfdata_graphs;
+ DROP TABLE IF EXISTS perfdata_reports;
+ DROP TABLE IF EXISTS perfdata_report_graphs;
  SET FOREIGN_KEY_CHECKS = 1;
  

Index: mysql_create.sql
===================================================================
RCS file: /cvsroot/perfparse/_perfparse/scripts/mysql_create.sql,v
retrieving revision 1.25
retrieving revision 1.26
diff -C2 -d -r1.25 -r1.26
*** mysql_create.sql	25 Aug 2007 00:09:14 -0000	1.25
--- mysql_create.sql	3 Sep 2007 22:56:25 -0000	1.26
***************
*** 43,46 ****
--- 43,50 ----
  ) TYPE=InnoDB;
  
+ insert into perfdata_delete_policy (policy_id,policy_name,delete_policy_seconds,policy_comment,instance_id) values
+         (0,'__Default_Bin',-1,'Internal default bin policy.',0);
+ insert into perfdata_delete_policy (policy_id,policy_name,delete_policy_seconds,policy_comment,instance_id) values
+         (1,'__Default_Raw',-1,'Internal default raw policy.',0);
  
  # Was table perfdata_host_group. renamed for clarity
***************
*** 53,57 ****
    instance_id INT DEFAULT 0,
    FOREIGN KEY perfdata_groups_ibfk_1 (instance_id)
!   	REFERENCES perfdata_instances(instance_id)
  ) type=InnoDB;
  
--- 57,71 ----
    instance_id INT DEFAULT 0,
    FOREIGN KEY perfdata_groups_ibfk_1 (instance_id)
!   	REFERENCES perfdata_instances(instance_id),
!   raw_delete_policy_id INTEGER,
!   raw_delete_policy_individual INTEGER,
!   bin_delete_policy_id INTEGER,
!   bin__delete_policy_individual INTEGER
!   FOREIGN KEY perfdata_groups_ibfk_2 (bin_delete_policy_id)
! 	REFERENCES perfdata_delete_policy (policy_id)
! 	ON DELETE SET NULL,
!   FOREIGN KEY perfdata_groups_ibfk_3 (raw_delete_policy_id)
!         REFERENCES perfdata_delete_policy (policy_id)
! 	ON DELETE SET NULL
  ) type=InnoDB;