Changeset 32510

Timestamp:

Oct 6, 2011, 3:21:17 PM (15 years ago)

Author:

bills

Message:

Add new tables and related SQL for video photometry stage

Location:

trunk/ippTools/share

Files:

• Makefile.am (modified) (1 diff)
• pxadmin_create_tables.sql (modified) (1 diff)
• vptool_find_rawexp.sql (added)
• vptool_pendingimfile.sql (added)
• vptool_pendingrun.sql (added)
• vptool_revertrun.sql (added)

trunk/ippTools/share/Makefile.am

@@ -426 +426 @@
         laptool_pendingrun.sql \
         laptool_WSdiff_check.sql \
-        laptool_stacks.sql
+        laptool_stacks.sql \
+        vptool_find_rawexp.sql \
+        vptool_pendingimfile.sql \
+        vptool_pendingrun.sql \
+        vptool_revertrun.sql
 

trunk/ippTools/share/pxadmin_create_tables.sql

@@ -1990 +1990 @@
     FOREIGN KEY(minidvodb_id) REFERENCES minidvodbRun(minidvodb_id)
 ) ENGINE=innodb DEFAULT CHARSET=latin1;
-
-
-
+CREATE TABLE vpRun (
+    vp_id BIGINT AUTO_INCREMENT,
+    exp_id BIGINT,
+    state VARCHAR(64),
+    label VARCHAR(64),
+    data_group VARCHAR(64),
+    workdir VARCHAR(255),
+    note VARCHAR(255),
+    dest_id BIGINT,
+    outroot VARCHAR(255),
+    dtime_script FLOAT,
+    hostname VARCHAR(64),
+    fault SMALLINT NOT NULL DEFAULT 0,
+    PRIMARY KEY(vp_id),
+    KEY(exp_id),
+    KEY(state),
+    KEY(label),
+    KEY(data_group),
+    KEY(fault),
+    INDEX(vp_id, exp_id),
+    FOREIGN KEY(exp_id) REFERENCES rawExp(exp_id)
+) ENGINE=innodb DEFAULT CHARSET=latin1;
+
+CREATE TABLE vpProcessedCell (
+    vp_id BIGINT,
+    class_id VARCHAR(64),
+    cell_id VARCHAR(64),
+    dtime_photom FLOAT,
+    quality SMALLINT NOT NULL DEFAULT 0,
+    path_base VARCHAR(255),
+    fault SMALLINT NOT NULL DEFAULT 0,
+    KEY(quality),
+    KEY(fault),
+    FOREIGN KEY(vp_id) REFERENCES vpRun(vp_id)
+) ENGINE=innodb DEFAULT CHARSET=latin1;
 
 -- This comment line is here to avoid empty query error.