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