Revision 6136
Added by ben leinfelder almost 13 years ago
upgrade-db-to-1.10.0-oracle.sql | ||
---|---|---|
1 | 1 |
CREATE TABLE systemMetadata ( |
2 | 2 |
guid VARCHAR2(2000), -- the globally unique string identifier |
3 |
docid VARCHAR(250), -- the local document id # |
|
4 |
rev NUMBER(8), -- the revision part of the local identifier |
|
5 | 3 |
date_uploaded DATE, -- the date/time the document was first submitted |
6 | 4 |
rights_holder VARCHAR2(250), --the user who has rights to the document, usually the first persons to upload it |
7 | 5 |
checksum VARCHAR2(512), --the checksum of the doc using the given algorithm (see below) |
... | ... | |
11 | 9 |
date_modified DATE, -- the last date/time that the file was changed |
12 | 10 |
submitter VARCHAR2(256), -- the user who originally submitted the doc |
13 | 11 |
object_format VARCHAR2(256), --the format of the object |
14 |
size VARCHAR2(256) --the size of the object |
|
12 |
size VARCHAR2(256), --the size of the object |
|
13 |
replication_allowed boolean, -- replication allowed |
|
14 |
number_replicas NUMBER(8), -- the number of replicas allowed |
|
15 |
CONSTRAINT systemMetadata_pk |
|
16 |
PRIMARY KEY (guid) |
|
15 | 17 |
) |
16 | 18 |
|
19 |
/* |
|
20 |
* Table used to store system metadata provenance information |
|
21 |
*/ |
|
22 |
CREATE TABLE systemMetadataProvenance ( |
|
23 |
guid VARCHAR2(2000), -- the globally unique string identifier of the object that the system metadata describes |
|
24 |
relationship VARCHAR(250), -- the provenance relationship defined between objects |
|
25 |
target_guid VARCHAR2(2000), -- the globally unique string identifier of the other object |
|
26 |
CONSTRAINT systemMetadataProvenance_fk |
|
27 |
FOREIGN KEY (guid) REFERENCES systemMetadata |
|
28 |
); |
|
29 |
|
|
30 |
CREATE TABLE systemMetadataReplicationPolicy ( |
|
31 |
guid VARCHAR2(2000), -- the globally unique string identifier of the object that the system metadata describes |
|
32 |
member_node VARCHAR(250), -- replication member node |
|
33 |
policy VARCHAR2(2000), -- the policy (preferred, blocked, etc...TBD) |
|
34 |
CONSTRAINT systemMetadataReplicationPolicy_fk |
|
35 |
FOREIGN KEY (guid) REFERENCES systemMetadata |
|
36 |
); |
|
37 |
|
|
38 |
CREATE TABLE systemMetadataReplicationStatus ( |
|
39 |
guid VARCHAR2(2000), -- the globally unique string identifier of the object that the system metadata describes |
|
40 |
member_node VARCHAR(250), -- replication member node |
|
41 |
status VARCHAR(250), -- replication status |
|
42 |
date_verified DATE, -- the date replication was verified |
|
43 |
CONSTRAINT systemMetadataReplicationStatus_fk |
|
44 |
FOREIGN KEY (guid) REFERENCES systemMetadata |
|
45 |
); |
|
46 |
|
|
17 | 47 |
CREATE TABLE identifier ( |
18 | 48 |
guid VARCHAR2(2000), -- the globally unique string identifier |
19 | 49 |
docid VARCHAR2(250), -- the local document id # |
... | ... | |
21 | 51 |
); |
22 | 52 |
|
23 | 53 |
/* |
54 |
* Replication changes to support DataONE System Metadata replication |
|
55 |
*/ |
|
56 |
ALTER TABLE xml_replication ADD COLUMN systemmetadatareplicate NUMBER(1); |
|
57 |
/* |
|
58 |
* Allow guid in xml_access table (for system metadata) |
|
59 |
*/ |
|
60 |
ALTER TABLE xml_access ADD COLUMN guid VARCHAR2(2000); |
|
61 |
|
|
62 |
/* |
|
24 | 63 |
* add the nodedatadate column to xml_nodes |
25 | 64 |
* TODO: load the data into it (java?) |
26 | 65 |
*/ |
Also available in: Unified diff
add option for replicating system metadata (dataone)
https://redmine.dataone.org/issues/1626
also make sure the latest table changes are included in upgrade scripts