Changeset 24377 for branches/pap_mops/ippTools/share/pxadmin_create_tables.sql

Timestamp:

Jun 10, 2009, 5:49:03 PM (17 years ago)

Author:

Paul Price

Message:

Defining modes for pubtool and dreamed up workflow. Haven't yet defined SQL or the C code for implementing the modes. Made some changes to the database schema for publishing.

File:

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

branches/pap_mops/ippTools/share/pxadmin_create_tables.sql

@@ -1375 +1375 @@
     client_id BIGINT AUTO_INCREMENT, -- unique identifier
     comment VARCHAR(255),            -- for human memory
-    stage VARCHAR(64),               -- stage of interest (chip, camera, diff, etc.)
+    stage VARCHAR(64) NOT NULL, -- stage of interest (chip, camera, diff, etc.)
     format VARCHAR(64),              -- format of data
-    destination VARCHAR(255),        -- where to send data
+    destination VARCHAR(255) NOT NULL, -- where to send data
     PRIMARY KEY(client_id)
 ) ENGINE=innodb DEFAULT CHARSET=latin1;
@@ -1384 +1384 @@
 CREATE TABLE publishRun (
     pub_id BIGINT AUTO_INCREMENT, -- unique identifier
-    client_id BIGINT,             -- link to publishClient
-    stage_id BIGINT,              -- link to various stage tables
+    client_id BIGINT NOT NULL,  -- link to publishClient
+    stage_id BIGINT NOT NULL,   -- link to various stage tables
+    label VARCHAR(64),          -- label for run
+    state VARCHAR(64),          -- state of run (new, full, etc.)
     PRIMARY KEY(pub_id),
     KEY(client_id),
     KEY(stage_id),
+    KEY(label),
+    KEY(state),
     FOREIGN KEY(client_id) REFERENCES publishClient(client_id)
 ) ENGINE=innodb DEFAULT CHARSET=latin1;