Changeset 35295 for trunk/dbconfig/changes.txt

Timestamp:

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

Author:

bills

Message:

add username, proj_id, and registered to table pstampRequest

File:

• trunk/dbconfig/changes.txt (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;