Revision 6923
Added by ben leinfelder about 11 years ago
| upgrade-db-to-2.0.0-postgres.sql | ||
|---|---|---|
| 81 | 81 |
* Add guid in xml_access table |
| 82 | 82 |
*/ |
| 83 | 83 |
ALTER TABLE xml_access ADD COLUMN guid text; |
| 84 |
/** |
|
| 85 |
* Expand accessfileid in xml_access table to hold guids |
|
| 86 |
*/ |
|
| 87 |
ALTER TABLE xml_access ALTER COLUMN accessfileid TYPE text; |
|
| 84 | 88 |
|
| 85 | 89 |
/** |
| 86 | 90 |
* Upgrade xml_access records to use GUID from identifier table |
Also available in: Unified diff
use larger ("text") db field for guid in the xml_access.accessfileid column