Changeset 25418 for trunk/ippTools/share/pxadmin_create_tables.sql

Timestamp:

Sep 16, 2009, 9:44:29 AM (17 years ago)

Author:

bills

Message:

Store the size in bytes and md5sum of the Compressed raw image files
in pzDownloadImfile. Propagate the values to rawImfile so that they are
available for checking.
(summitImfile has the parameters of the files before they are compressed)

File:

• trunk/ippTools/share/pxadmin_create_tables.sql (modified) (3 diffs)

trunk/ippTools/share/pxadmin_create_tables.sql

@@ -58 +58 @@
     epoch TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
     hostname VARCHAR(64),
+    bytes INT,
+    md5sum VARCHAR(32),
     PRIMARY KEY(exp_name, camera, telescope, class, class_id),
     KEY(fault),
@@ -94 +96 @@
     uri VARCHAR(255),
     epoch TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
+    bytes INT,
+    md5sum VARCHAR(32),
     PRIMARY KEY(exp_id, tmp_class_id),
     FOREIGN KEY(exp_id) REFERENCES newExp(exp_id)
@@ -237 +241 @@
     raw_image_id BIGINT AUTO_INCREMENT,
     magicked BIGINT,
+    bytes INT,
+    md5sum VARCHAR(32),
     PRIMARY KEY(exp_id, class_id),
     KEY(tmp_class_id),