[Perfparse-cvs] _perfparse/scripts mysql_create.sql,1.12,1.13

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

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

Modified Files:
	mysql_create.sql 
Log Message:
schema fine tuning and more conversion


Index: mysql_create.sql
===================================================================
RCS file: /cvsroot/perfparse/_perfparse/scripts/mysql_create.sql,v
retrieving revision 1.12
retrieving revision 1.13
diff -C2 -d -r1.12 -r1.13
*** mysql_create.sql	1 Apr 2007 22:45:14 -0000	1.12
--- mysql_create.sql	3 Apr 2007 22:21:07 -0000	1.13
***************
*** 42,46 ****
  	host_name VARCHAR(75) UNIQUE,
  	raw_delete_policy_id INTEGER,
! 	raw_delete_individual INTEGER,
  	INDEX host_ix1 (raw_delete_policy_id),
  	FOREIGN KEY perfdata_host_ibfk_1 (raw_delete_policy_id)
--- 42,46 ----
  	host_name VARCHAR(75) 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)
***************
*** 65,69 ****
    host_id INT,
    FOREIGN KEY perfdata_host_groups_ibfk_2 (host_id) 
!     REFERENCES perfdata_host(host_id) ON DELETE CASCADE
    ) type=InnoDB;
  
--- 65,70 ----
    host_id INT,
    FOREIGN KEY perfdata_host_groups_ibfk_2 (host_id) 
!     REFERENCES perfdata_host(host_id) ON DELETE CASCADE,
!   UNIQUE (group_id,host_id)
    ) type=InnoDB;
  
***************
*** 74,78 ****
  
  CREATE TABLE IF NOT EXISTS perfdata_service (
! 	service_id INT PRIMARY KEY,
  	host_id INT NOT NULL,
  	service_description VARCHAR(75) NOT NULL,
--- 75,79 ----
  
  CREATE TABLE IF NOT EXISTS perfdata_service (
! 	service_id INT AUTO_IMCREMENT PRIMARY KEY,
  	host_id INT NOT NULL,
  	service_description VARCHAR(75) NOT NULL,