[Perfparse-cvs] _perfparse/scripts mysql_create.sql,1.15,1.16

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

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

Modified Files:
	mysql_create.sql 
Log Message:
convert service_bin table. Eleminate DATETIME database columns. Converted to INT for Unix Timestamps.


Index: mysql_create.sql
===================================================================
RCS file: /cvsroot/perfparse/_perfparse/scripts/mysql_create.sql,v
retrieving revision 1.15
retrieving revision 1.16
diff -C2 -d -r1.15 -r1.16
*** mysql_create.sql	14 Apr 2007 00:34:59 -0000	1.15
--- mysql_create.sql	15 Apr 2007 23:39:53 -0000	1.16
***************
*** 105,109 ****
  		REFERENCES perfdata_service (service_id) 
  		ON DELETE RESTRICT,
! 	ctime DATETIME NOT NULL,
  	INDEX perfdata_service_raw_ix1 (ctime),
  	txt_data VARCHAR(255),
--- 105,109 ----
  		REFERENCES perfdata_service (service_id) 
  		ON DELETE RESTRICT,
! 	ctime INT NOT NULL,
  	INDEX perfdata_service_raw_ix1 (ctime),
  	txt_data VARCHAR(255),
***************
*** 155,159 ****
  		REFERENCES perfdata_service_metric (metric_id) 
  		ON DELETE RESTRICT,
! 	ctime DATETIME NOT NULL,
  	INDEX perfdata_service_raw_ix1 (metric_id, ctime),
  	value FLOAT,
--- 155,159 ----
  		REFERENCES perfdata_service_metric (metric_id) 
  		ON DELETE RESTRICT,
! 	ctime INT NOT NULL,
  	INDEX perfdata_service_raw_ix1 (metric_id, ctime),
  	value FLOAT,
***************
*** 209,213 ****
  	metric_id INT NOT NULL,
  	frequency INT NOT NULL,
! 	ctime DATETIME NOT NULL,
  	PRIMARY KEY (metric_id, frequency, ctime),
  	FOREIGN KEY (metric_id, frequency) 
--- 209,213 ----
  	metric_id INT NOT NULL,
  	frequency INT NOT NULL,
! 	ctime INT NOT NULL,
  	PRIMARY KEY (metric_id, frequency, ctime),
  	FOREIGN KEY (metric_id, frequency) 
***************
*** 274,278 ****
  		PRIMARY KEY (host, rkey),
  		rvalue TEXT,
! 		ctime DATETIME NOT NULL
  ) type=InnoDB;
  
--- 274,278 ----
  		PRIMARY KEY (host, rkey),
  		rvalue TEXT,
! 		ctime INT NOT NULL
  ) type=InnoDB;