Revision 8606
Added by ben leinfelder almost 11 years ago
src/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.