Changeset 31407 for branches/czw_branch/20110406/ippTools/share/pxadmin_create_tables.sql

Timestamp:

Apr 28, 2011, 6:41:17 PM (15 years ago)

Author:

watersc1

Message:

Majority of ippTools/SQL work should be complete now. Need to start queueing exposures, and testing the script

File:

• branches/czw_branch/20110406/ippTools/share/pxadmin_create_tables.sql (modified) (2 diffs)

branches/czw_branch/20110406/ippTools/share/pxadmin_create_tables.sql

@@ -1912 +1912 @@
     registered TIMESTAMP DEFAULT CURRENT_TIMESTAMP, -- time run was registered
     fault SMALLINT NOT NULL,      -- fault code
-    quick_sass_id,                -- stackAssociation id for quick stack
-    final_sass_id,                -- stackAssociation id for final stack
+    quick_sass_id BIGINT,         -- stackAssociation id for quick stack
+    final_sass_id BIGINT,         -- stackAssociation id for final stack
     PRIMARY KEY(lap_id),
     KEY(seq_id),
@@ -1943 +1943 @@
     FOREIGN KEY (exp_id) REFERENCES rawExp(exp_id),
     FOREIGN KEY (chip_id,exp_id) REFERENCES chipRun(chip_id,exp_id),
-    FOREIGN KEY (pair_id) REFERENCES chipRun(chip_id),
+    FOREIGN KEY (pair_id) REFERENCES chipRun(chip_id)
 ) ENGINE=innodb DEFAULT CHARSET=latin1;