Changeset 32771 for trunk/ippTools/share

Timestamp:

Nov 22, 2011, 2:22:43 PM (15 years ago)

Author:

bills

Message:

add table pstampFile to keep track of nebulous files created as part
of postage stamp jobs

Location:

trunk/ippTools/share

Files:

• Makefile.am (modified) (1 diff)
• pstamptool_listfile.sql (added)
• pxadmin_create_tables.sql (modified) (1 diff)

trunk/ippTools/share/Makefile.am

@@ -308 +308 @@
         pstamptool_getdependent.sql \
         pstamptool_listjob.sql \
+        pstamptool_listfile.sql \
         pstamptool_pendingcleanup.sql \
         pstamptool_pendingdependent.sql \

trunk/ippTools/share/pxadmin_create_tables.sql

@@ -1479 +1479 @@
 ) ENGINE=innodb DEFAULT CHARSET=latin1;
 
+CREATE TABLE pstampFile (
+    file_id BIGINT AUTO_INCREMENT,
+    job_id BIGINT NOT NULL,
+    path VARCHAR(255),
+    PRIMARY KEY(file_id),
+    KEY(job_id)
+) ENGINE=innodb DEFAULT CHARSET=latin1;
+
 CREATE TABLE pstampWebRequest (
         num BIGINT AUTO_INCREMENT,