Changeset 23521

Timestamp:

Mar 25, 2009, 11:20:39 AM (17 years ago)

Author:

Paul Price

Message:

Removing unused table guidePendingExp

Location:

branches/pap/ippTools/share

Files:

• pxadmin_create_tables.sql (modified) (4 diffs)
• pxadmin_drop_tables.sql (modified) (2 diffs)

branches/pap/ippTools/share/pxadmin_create_tables.sql

@@ -250 +250 @@
 ENGINE=innodb DEFAULT CHARSET=latin1;
 
-CREATE TABLE guidePendingExp (guide_id BIGINT AUTO_INCREMENT, exp_id BIGINT, recipe VARCHAR(64), PRIMARY KEY(guide_id), KEY(guide_id), KEY(exp_id)) ENGINE=innodb DEFAULT CHARSET=latin1;
-
 CREATE TABLE chipRun (
     chip_id BIGINT AUTO_INCREMENT,
@@ -1235 +1233 @@
 
 CREATE TABLE distTarget (
-    target_id   BIGINT AUTO_INCREMENT, 
+    target_id   BIGINT AUTO_INCREMENT,
     obs_mode    VARCHAR(64),
     stage       VARCHAR(64),
@@ -1263 +1261 @@
 
 CREATE TABLE distComponent (
-    dist_id     BIGINT, 
+    dist_id     BIGINT,
     component   VARCHAR(64),
     bytes       INT,
@@ -1335 +1333 @@
 
 
--- This comment line is here to avoid empty query error. 
+-- This comment line is here to avoid empty query error.
 -- Another way to avoid that problem is to omit the semicolon above but I think that is untidy.

branches/pap/ippTools/share/pxadmin_drop_tables.sql

@@ -1 +1 @@
 SET FOREIGN_KEY_CHECKS=0;
+
 DROP TABLE IF EXISTS pzDataStore;
 DROP TABLE IF EXISTS summitExp;
@@ -9 +10 @@
 DROP TABLE IF EXISTS rawExp;
 DROP TABLE IF EXISTS rawImfile;
-DROP TABLE IF EXISTS guidePendingExp;
 DROP TABLE IF EXISTS chipRun;
 DROP TABLE IF EXISTS chipProcessedImfile;