Revision 6946
Added by ben leinfelder about 12 years ago
upgrade-db-to-2.0.0-postgres.sql | ||
---|---|---|
74 | 74 |
*/ |
75 | 75 |
INSERT INTO identifier (docid, rev, guid) |
76 | 76 |
SELECT docid, rev, docid || '.' || rev FROM xml_documents; |
77 |
|
|
77 | 78 |
INSERT INTO identifier (docid, rev, guid) |
78 |
SELECT docid, revisionid, docid || '.' || revisionid FROM xml_revisions; |
|
79 |
SELECT docid, revisionid, docid || '.' || revisionid |
|
80 |
FROM xml_revisions |
|
81 |
WHERE docid || '.' || revisionid NOT IN (SELECT guid from identifier); |
|
79 | 82 |
|
80 | 83 |
/** |
81 | 84 |
* Add guid in xml_access table |
Also available in: Unified diff
do not insert duplicate GUID entries when adding rows from the xml_revisions table