Changeset 38156 for trunk/dbconfig

Timestamp:

Apr 20, 2015, 12:30:33 PM (11 years ago)

Author:

bills

Message:

Add column ippRelease.accessLevelMin which is an integer that defines the minimum
user accessLevel required to access data from the given release. This will be
used to restrict access to stacks that use post PS1SC data.

Location:

trunk/dbconfig

Files:

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

trunk/dbconfig/changes.txt

@@ -2531 +2531 @@
 ALTER TABLE remoteComponent ADD COLUMN path_base VARCHAR(255) after state;
 
+--
+UPDATE TABLE ippRelease ADD COLUMN accessLevelMin INT DEFAULT 0 AFTER ubercal_file 

trunk/dbconfig/release.md

@@ -14 +14 @@
     dvodb       STR     255
     ubercal_file STR    255
+    accessLevelMin S32  0
 END