Changeset 29962 for trunk/ippTools/share

Timestamp:

Dec 6, 2010, 3:00:09 PM (16 years ago)

Author:

Serge CHASTEL

Message:

ppMops -version flag supported

Location:

trunk/ippTools/share

Files:

• pubtool_definerun.sql (modified) (4 diffs)
• pubtool_pending.sql (modified) (3 diffs)
• pxadmin_create_tables.sql (modified) (1 diff)

trunk/ippTools/share/pubtool_definerun.sql

@@ -3 +3 @@
     client_id,
     stage_id,
-    src_label
+    src_label,
+    output_format
 FROM (
     -- Get diffs to publish
@@ -9 +10 @@
         client_id,
         diff_id AS stage_id,
-        diffRun.label AS src_label
+        diffRun.label AS src_label,
+        output_format
     FROM publishClient
     JOIN diffRun
@@ -28 +30 @@
         client_id,
         cam_id AS stage_id,
-        camRun.label AS src_label
+        camRun.label AS src_label,
+        output_format
     FROM publishClient
     JOIN camRun
@@ -43 +46 @@
         client_id,
         diff_phot_id AS stage_id,
-        diffPhotRun.label AS src_label
+        diffPhotRun.label AS src_label,
+        output_format
     FROM publishClient
     JOIN diffPhotRun

trunk/ippTools/share/pubtool_pending.sql

@@ -9 +9 @@
         publishClient.stage,
         publishClient.workdir,
+        publishClient.output_format,
         diffRun.diff_id AS stage_id,
         rawExp.camera,
@@ -35 +36 @@
         publishClient.stage,
         publishClient.workdir,
+        publishClient.output_format,
         camRun.cam_id AS stage_id,
         rawExp.camera,
@@ -56 +58 @@
         publishClient.stage,
         publishClient.workdir,
+        publishClient.output_format,
         diffPhotRun.diff_phot_id AS stage_id,
         rawExp.camera,

trunk/ippTools/share/pxadmin_create_tables.sql

@@ -1643 +1643 @@
     workdir VARCHAR(255) NOT NULL, -- working directory
     comment VARCHAR(255),            -- for human memory
-    PRIMARY KEY(client_id)
+    name varchar(64) default NULL, -- unique client_id verbose identifier
+    output_format SMALLINT NOT NULL default 1, -- format output versioning
+    PRIMARY KEY(client_id),
+    UNIQUE KEY name (name)
 ) ENGINE=innodb DEFAULT CHARSET=latin1;