Changeset 38157 for trunk/dbconfig/pstamp.md

Timestamp:

Apr 20, 2015, 12:32:54 PM (11 years ago)

Author:

bills

Message:

Add 3 new postage stamp tables to the IPP database config.
Note that we don't keep the postage stamp tables in the gpc1 database
so there are no changes listed in dbconfig/changes.txt to update them.
We do that to avoid mistakenly using pstamptool without setting the dbserver to
the system that actually hosts the ippRequestServer database (currently ippc17).

File:

• trunk/dbconfig/pstamp.md (modified) (1 diff)

trunk/dbconfig/pstamp.md

@@ -69 +69 @@
 END
 
-pstampWebRequest METADATA
+pstampWebRequest        METADATA
     num         S64         0    # Primary Key AUTO_INCREMENT
 END
 
-pstampFile METADATA
+pstampFile              METADATA
     file_id     S64         0   # Primary Key AUTO_INCREMENT
     job_id      S64         0
     path        STR         255
-end
+END
+
+pstampUserDomain        METADATA
+    domainName      STR     64
+    accessLevel     S32     0
+    defaultProduct  STR     255
+    defaultLabel    STR     64
+END
+
+pstampUser              METADATA
+    userName        STR     64  # Primary Key (userName, domainName)
+    domainName      STR     64  
+    accessLevel     S32     0
+    defaultProduct  STR     255
+    defaultLabel    STR     64
+END
+
+pstampAccessLevel       METADATA
+    proj_id         S64     0   # Primary Key (proj_id, accessLevel) fkey(proj_id) 
+    accessLevel     S32     0
+    mjd_min         F32     0
+    mjd_max         F32     0
+END
+