Revision 6100
Added by ben leinfelder almost 12 years ago
| xmltables-oracle.sql | ||
|---|---|---|
| 404 | 404 |
*/ |
| 405 | 405 |
CREATE TABLE systemMetadata ( |
| 406 | 406 |
guid VARCHAR2(2000), -- the globally unique string identifier |
| 407 |
docid VARCHAR(250), -- the local document id # |
|
| 408 |
rev NUMBER(8), -- the revision part of the local identifier |
|
| 409 | 407 |
date_uploaded DATE, -- the date/time the document was first submitted |
| 410 | 408 |
rights_holder VARCHAR2(250), --the user who has rights to the document, usually the first persons to upload it |
| 411 | 409 |
checksum VARCHAR2(512), --the checksum of the doc using the given algorithm (see below) |
Also available in: Unified diff
remove docid and rev from systemMetadata table