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