Changeset 29902 for trunk/dbconfig

Timestamp:

Dec 2, 2010, 3:10:33 PM (16 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)
• cam.md (modified) (1 diff)
• changes.txt (modified) (1 diff)
• chip.md (modified) (1 diff)
• config.md (modified) (1 diff)

trunk/dbconfig/cam.md

@@ -113 +113 @@
     maskfrac_max_magic  F32     0.0
     maskfrac_max_advisory F32   0.0
+    deteff         F32      0
+    deteff_err     F32      0
+    deteff_lq      F32      0
+    deteff_uq      F32      0
     quality        S16      0
 END

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

trunk/dbconfig/chip.md

@@ -105 +105 @@
     maskfrac_magic  F32     0.0
     maskfrac_advisory F32   0.0
+    deteff_magref   F32     0.0
 END
 

trunk/dbconfig/config.md

@@ -2 +2 @@
     pkg_name        STR     ippdb
     pkg_namespace   STR     ippdb
-    pkg_version     STR     1.1.65
+    pkg_version     STR     1.1.66
 END