Changeset 29902 for trunk/dbconfig/changes.txt

Timestamp:

Dec 2, 2010, 3:10:33 PM (15 years ago)

Author:

bills

Message:

Save results of detection efficiency analaysis is the database.
resolve pxadmin_create_tables.sql with dbconfig and changes to the gpc1 database

Location:

trunk/dbconfig

Files:

• . (modified) (1 prop)
• changes.txt (modified) (1 diff)

trunk/dbconfig/changes.txt

@@ -1981 +1981 @@
     FOREIGN KEY(minidvodb_id) REFERENCES minidvodbRun(minidvodb_id)
 ) ENGINE=innodb DEFAULT CHARSET=latin1;
+
+ALTER TABLE chipProcessedImfile ADD column deteff_magref FLOAT;
+ALTER TABLE camProcessedExp ADD column deteff FLOAT AFTER maskfrac_max_advisory;
+ALTER TABLE camProcessedExp ADD column deteff_err FLOAT AFTER deteff;
+ALTER TABLE camProcessedExp ADD column deteff_lq FLOAT AFTER deteff_err;
+ALTER TABLE camProcessedExp ADD column deteff_uq FLOAT AFTER deteff_lq;
+UPDATE dbversion set schema_version = '1.1.66',  updated= CURRENT_TIMESTAMP();
+
+-- Version 1.1.67