Revision 6923
Added by ben leinfelder about 11 years ago
upgrade-db-to-2.0.0-oracle.sql | ||
---|---|---|
77 | 77 |
* Allow guid in xml_access table (for system metadata) |
78 | 78 |
*/ |
79 | 79 |
ALTER TABLE xml_access ADD COLUMN guid VARCHAR2(2000); |
80 |
/** |
|
81 |
* Expand accessfileid in xml_access table to hold guids |
|
82 |
*/ |
|
83 |
ALTER TABLE xml_access ALTER COLUMN accessfileid TYPE VARCHAR2(2000); |
|
80 | 84 |
|
85 |
|
|
81 | 86 |
/** |
82 | 87 |
* Upgrade xml_access records to use GUID from identifier table |
83 | 88 |
* NOTE: This duplicates existing access rules for every revision of a document |
Also available in: Unified diff
use larger ("text") db field for guid in the xml_access.accessfileid column