Changeset 35295 for trunk/dbconfig

Timestamp:

Mar 11, 2013, 2:03:24 PM (13 years ago)

Author:

bills

Message:

add username, proj_id, and registered to table pstampRequest

Location:

trunk/dbconfig

Files:

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

trunk/dbconfig/changes.txt

@@ -2399 +2399 @@
 UPDATE dbversion set schema_version = '1.1.75', updated= CURRENT_TIMESTAMP();
 
+
+-- new Postage Stamp Request columns
+-- Note: These do not aply to the gpc1 database because the pstamp tables were
+-- deleted from that database.
+ALTER TABLE pstampRequest ADD COLUMN username VARCHAR(255) AFTER outdir;
+ALTER TABLE pstampRequest ADD COLUMN proj_id BIGINT AFTER username;
+ALTER TABLE pstampRequest ADD COLUMN registered DATETIME AFTER proj_id;
+
+-- default to the gpc1 project
+UPDATE pstampRequest SET proj_id = 1;

trunk/dbconfig/pstamp.md

@@ -32 +32 @@
     uri         STR         255
     outdir      STR         255
+    username    STR         255
+    proj_id     S64         0
+    registered  UTC         0001-01-01T00:00:00Z
     timestamp   UTC         0001-01-01T00:00:00Z
     fault       S32         0