Changeset 28196

Timestamp:

Jun 2, 2010, 3:32:19 PM (16 years ago)

Author:

heather

Message:

the db changes for addtool minidvo dbs

File:

• trunk/dbconfig/changes.txt (modified) (1 diff)

trunk/dbconfig/changes.txt

@@ -1717 +1717 @@
 ) ENGINE=innodb DEFAULT CHARSET=latin1;
 
+-- Version 1.1.68 addition of minidvodb tables and changes to addTables 
+
+-- this modifies addTables
+
+ALTER TABLE addRun ADD COLUMN minidvodb tinyint NOT NULL AFTER image_only;
+ALTER TABLE addRun ADD COLUMN minidvodb_group varchar(64) AFTER minidvodb;
+ALTER TABLE addRun ADD COLUMN minidvodb_name varchar(64) AFTER minidvodb_group;
+
+ALTER TABLE addProcessedExp ADD COLUMN dvodb_path varchar(255) AFTER path_base;
+
+
+-- this adds the new tables 
+
+
+CREATE TABLE minidvodbRun (
+minidvodb_id BIGINT AUTO_INCREMENT,
+                    minidvodb_name VARCHAR(64),
+              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,
+       PRIMARY KEY(minidvodb_id), KEY(minidvodb_name), INDEX(minidvodb_id)
+) ENGINE=innodb DEFAULT CHARSET=latin1;
+
+
+
+CREATE TABLE minidvodbProcessed (
+      minidvodb_id BIGINT,
+      merge_order BIGINT,
+dtime_resort FLOAT,
+dtime_relphot FLOAT,
+dtime_merge FLOAT,
+epoch TIMESTAMP,
+mergedvodb_path VARCHAR(255) NOT NULL,
+fault SMALLINT NOT NULL,
+       KEY(minidvodb_id), CONSTRAINT UNIQUE(minidvodb_id), FOREIGN KEY(minidvodb_id) REFERENCES minidvodbRun (minidvodb_id)
+) ENGINE=innodb DEFAULT CHARSET=latin1;