[Perfparse-cvs] _perfparse/scripts mysql_create.sql,1.27,1.28

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

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

Modified Files:
	mysql_create.sql 
Log Message:
make deletion policies less complex. No individual settings in objects allowed any more.


Index: mysql_create.sql
===================================================================
RCS file: /cvsroot/perfparse/_perfparse/scripts/mysql_create.sql,v
retrieving revision 1.27
retrieving revision 1.28
diff -C2 -d -r1.27 -r1.28
*** mysql_create.sql	28 Sep 2007 21:53:16 -0000	1.27
--- mysql_create.sql	24 Apr 2008 22:29:09 -0000	1.28
***************
*** 63,69 ****
    	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)
--- 63,67 ----
***************
*** 78,82 ****
  	host_name VARCHAR(100) UNIQUE,
  	raw_delete_policy_id INTEGER,
- 	raw_delete_policy_individual INTEGER,
  	INDEX host_ix1 (raw_delete_policy_id),
  	FOREIGN KEY perfdata_host_ibfk_1 (raw_delete_policy_id)
--- 76,79 ----
***************
*** 84,88 ****
  		ON DELETE SET NULL,
  	bin_delete_policy_id INTEGER,
- 	bin_delete_policy_individual INTEGER,
  	INDEX host_ix2 (bin_delete_policy_id),
  	FOREIGN KEY perfdata_host_ibfk_2 (bin_delete_policy_id)
--- 81,84 ----
***************
*** 125,129 ****
  	UNIQUE INDEX service_ix1 (last_perfdata_raw),
  	raw_delete_policy_id INTEGER DEFAULT NULL,
- 	raw_delete_policy_individual INTEGER,
  	INDEX service_ix2 (raw_delete_policy_id),
  	FOREIGN KEY perfdata_service_ibfk_2 (raw_delete_policy_iD)
--- 121,124 ----
***************
*** 176,180 ****
  	UNIQUE INDEX perfdata_metric_ix1 (last_perfdata_bin),
  	bin_delete_policy_id INTEGER ,
- 	bin_delete_policy_individual INTEGER,
  	INDEX metric_ix2 (bin_delete_policy_id),
  	FOREIGN KEY perfdata_service_metric_ifk_1 (bin_delete_policy_id)
--- 171,174 ----