Changeset 25418 for trunk/dbconfig

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)

Location:

trunk/dbconfig

Files:

• changes.txt (modified) (1 diff)
• new.md (modified) (1 diff)
• raw.md (modified) (1 diff)
• summitcopy.md (modified) (1 diff)

trunk/dbconfig/changes.txt

@@ -1248 +1248 @@
     PRIMARY KEY(label)
 ) ENGINE=innodb DEFAULT CHARSET=latin1;
+
+
+ALTER TABLE pzDownloadImfile ADD COLUMN bytes INT;
+ALTER TABLE pzDownloadImfile ADD COLUMN md5sum VARCHAR(32);
+ALTER TABLE newImfile ADD COLUMN bytes INT;
+ALTER TABLE newImfile ADD COLUMN md5sum VARCHAR(32);
+ALTER TABLE rawImfile ADD COLUMN bytes INT;
+ALTER TABLE rawImfile ADD COLUMN md5sum VARCHAR(32);
+

trunk/dbconfig/new.md

@@ -22 +22 @@
     uri         STR         255
     epoch       UTC         0001-01-01T00:00:00Z
+    bytes       S32         0
+    md5sum      STR         32
 END
 

trunk/dbconfig/raw.md

@@ -136 +136 @@
     epoch       UTC         0001-01-01T00:00:00Z
     magicked    S64         0
+    bytes       S32         0
+    md5sum      STR         32
 END

trunk/dbconfig/summitcopy.md

@@ -57 +57 @@
     epoch       UTC         0001-01-01T00:00:00Z
     hostname    STR         64
+    bytes       S32         0
+    md5sum      STR         32
 END