Changeset 24108

Timestamp:

May 7, 2009, 11:25:09 AM (17 years ago)

Author:

bills

Message:

new columns for receiveFile

Location:

trunk/dbconfig

Files:

• changes.txt (modified) (1 diff)
• receive.md (modified) (1 diff)

trunk/dbconfig/changes.txt

@@ -1096 +1096 @@
 ALTER TABLE receiveFileset ADD COLUMN dbinfo_uri VARCHAR(255);
 ALTER TABLE receiveFileset ADD COLUMN fault SMALLINT NOT NULL DEFAULT 0;
+
+ALTER TABLE receiveFile ADD COLUMN bytes BIGINT;
+ALTER TABLE receiveFile ADD COLUMN md5sum VARCHAR(255);
+ALTER TABLE receiveFile ADD COLUMN file_type VARCHAR(64);
+ALTER TABLE receiveFile ADD COLUMN component VARCHAR(64);
+

trunk/dbconfig/receive.md

@@ -26 +26 @@
         fileset_id      S64     0       # Key fkey (fileset_id) ref receiveFileset(fileset_id)
         file            STR     128
+        bytes           S64     0
+        md5sum          STR     255
+        file_type       STR     64
+        component       STR     64
 END