Changeset 33005 for branches/haf_add201112/ippTools/share/pxadmin_create_tables.sql

Timestamp:

Dec 22, 2011, 4:51:14 PM (14 years ago)

Author:

heather

Message:

fixed up the merge/mini tables

File:

• branches/haf_add201112/ippTools/share/pxadmin_create_tables.sql (modified) (3 diffs)

branches/haf_add201112/ippTools/share/pxadmin_create_tables.sql

@@ -1964 +1964 @@
        minidvodb_group VARCHAR(64) NOT NULL,
        minidvodb_path VARCHAR(255) NOT NULL,
-       mergedvodb_path VARCHAR(255) NOT NULL,
        state VARCHAR(64) NOT NULL,
        creation_date TIMESTAMP,
@@ -1972 +1971 @@
 CREATE TABLE minidvodbProcessed (
       minidvodb_id BIGINT,
-      merge_order BIGINT,
       dtime_resort FLOAT,
       dtime_relphot FLOAT,
-      dtime_verify FLOAT,
-      dtime_merge FLOAT,
       dtime_script FLOAT,
       epoch timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
-      mergedvodb_path VARCHAR(255) NOT NULL,
       fault SMALLINT NOT NULL,
       UNIQUE KEY (minidvodb_id),
@@ -2003 +1998 @@
        merge_id BIGINT AUTO_INCREMENT,
        minidvodb_id BIGINT,
-       minidvodb_group VARCHAR(64) NOT NULL,
-       minidvodb_path VARCHAR(255) NOT NULL,
+       mergedvodb VARCHAR(64) NOT NULL,
        mergedvodb_path VARCHAR(255) NOT NULL,
        state VARCHAR(64) NOT NULL,
        creation_date TIMESTAMP,
-       PRIMARY KEY(merge_id), KEY(minidvodb_id), KEY(minidvodb_group), INDEX(merge_id)
+       PRIMARY KEY(merge_id), KEY(minidvodb_id), KEY(mergedvodb), INDEX(merge_id)
 ) ENGINE=innodb DEFAULT CHARSET=latin1;
 
 CREATE TABLE mergedvodbProcessed (
       merge_id BIGINT,
-      merge_order BIGINT,
       dtime_verify FLOAT,
       dtime_merge FLOAT,