Revision 8606
Added by ben leinfelder over 10 years ago
| upgrade-db-to-2.4.0-postgres.sql | ||
|---|---|---|
| 4 | 4 |
|
| 5 | 5 |
/* |
| 6 | 6 |
* Gather most recent docids that: |
| 7 |
* - have access_log event='delete' by the CN
|
|
| 8 |
* - are obsoleted by a newer version
|
|
| 7 |
* have access_log event='delete' by the CN |
|
| 8 |
* are obsoleted by a newer version |
|
| 9 | 9 |
* Then we know the current version should be restored |
| 10 | 10 |
*/ |
| 11 | 11 |
|
| ... | ... | |
| 63 | 63 |
AND x.rev = id.rev |
| 64 | 64 |
AND id.guid = cd.guid; |
| 65 | 65 |
|
| 66 |
-- look at them
|
|
| 66 |
/* look at them */
|
|
| 67 | 67 |
/* |
| 68 | 68 |
SELECT * |
| 69 | 69 |
FROM restore_documents; |
| 70 | 70 |
*/ |
| 71 | 71 |
|
| 72 |
--STOP HERE WHEN TESTING
|
|
| 72 |
/* STOP HERE WHEN TESTING */
|
|
| 73 | 73 |
|
| 74 | 74 |
/* Move xml_nodes_revisions back into xml_nodes for the affected docids |
| 75 | 75 |
*/ |
| ... | ... | |
| 131 | 131 |
/*Do the update on xml_revisions |
| 132 | 132 |
*/ |
| 133 | 133 |
UPDATE systemMetadata sm |
| 134 |
SET sm.archived = false
|
|
| 134 |
SET archived = false |
|
| 135 | 135 |
FROM xml_revisions x, |
| 136 | 136 |
identifier id |
| 137 | 137 |
WHERE x.docid = id.docid |
| ... | ... | |
| 158 | 158 |
/*Do the update on xml_documents |
| 159 | 159 |
*/ |
| 160 | 160 |
UPDATE systemMetadata sm |
| 161 |
SET sm.archived = false
|
|
| 161 |
SET archived = false |
|
| 162 | 162 |
FROM xml_documents x, |
| 163 | 163 |
identifier id |
| 164 | 164 |
WHERE x.docid = id.docid |
Also available in: Unified diff
do not include "sm" alias in the SET clause.