Revision 552
Added by berkley almost 24 years ago
src/xmltables.sql | ||
---|---|---|
146 | 146 |
doctitle VARCHAR2(1000), -- title of document if exists |
147 | 147 |
user_owner VARCHAR2(100), |
148 | 148 |
user_updated VARCHAR2(100), |
149 |
server_location NUMBER(20), |
|
149 | 150 |
date_created DATE, |
150 | 151 |
date_updated DATE, |
151 | 152 |
CONSTRAINT xml_revisions_pk PRIMARY KEY (revisionid), |
153 |
CONSTRAINT xml_revisions_rep_fk |
|
154 |
FOREIGN KEY (server_location) REFERENCES xml_replication, |
|
152 | 155 |
CONSTRAINT xml_revisions_root_fk |
153 | 156 |
FOREIGN KEY (rootnodeid) REFERENCES xml_nodes |
154 | 157 |
); |
src/edu/ucsb/nceas/metacat/DocumentImpl.java | ||
---|---|---|
899 | 899 |
|
900 | 900 |
/** Save a document entry in the xml_revisions table */ |
901 | 901 |
private static void archiveDocRevision(Connection conn, String docid, |
902 |
String user) throws SQLException { |
|
902 |
String user) |
|
903 |
throws SQLException { |
|
903 | 904 |
// create a record in xml_revisions table |
904 | 905 |
// for that document as selected from xml_documents |
905 | 906 |
PreparedStatement pstmt = conn.prepareStatement( |
906 | 907 |
"INSERT INTO xml_revisions " + |
907 | 908 |
"(revisionid, docid, rootnodeid, docname, doctype, doctitle, " + |
908 |
"user_owner, user_updated, date_created, date_updated) " + |
|
909 |
"user_owner, user_updated, date_created, date_updated, server_location) " +
|
|
909 | 910 |
"SELECT null, ?, rootnodeid, docname, doctype, doctitle," + |
910 |
"user_owner, ?, sysdate, sysdate "+ |
|
911 |
"user_owner, ?, sysdate, sysdate, server_location "+
|
|
911 | 912 |
"FROM xml_documents " + |
912 | 913 |
"WHERE docid = ?"); |
913 | 914 |
// Bind the values to the query and execute it |
Also available in: Unified diff
added support for server_location in the xml_revisions table.