Revision 6764
Added by ben leinfelder almost 13 years ago
| src/upgrade-db-to-2.0.0-oracle.sql | ||
|---|---|---|
| 118 | 118 |
FROM identifier id, xml_access xa |
| 119 | 119 |
WHERE xa.accessfileid = id.docid |
| 120 | 120 |
AND id.rev = |
| 121 |
(SELECT MAX(id2.rev) FROM identifier id2 WHERE id.docid = id2.docid) |
|
| 121 |
(SELECT MAX(id2.rev) FROM identifier id2 WHERE id.docid = id2.docid);
|
|
| 122 | 122 |
|
| 123 | 123 |
/** |
| 124 | 124 |
* Remove old access rules |
Also available in: Unified diff
add ; to end of update command