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