Revision 6136
Added by ben leinfelder over 13 years ago
upgrade-db-to-1.10.0-postgres.sql | ||
---|---|---|
1 | 1 |
CREATE TABLE systemMetadata ( |
2 |
guid text, -- the globally unique string identifier
|
|
3 |
docid VARCHAR(250), -- the local document id #
|
|
4 |
rev INT8, -- the revision part of the local identifier
|
|
5 |
date_uploaded TIMESTAMP, -- the date/time the document was first submitted
|
|
6 |
rights_holder VARCHAR(250), --the user who has rights to the document, usually the first persons to upload it
|
|
7 |
checksum VARCHAR(512), --the checksum of the doc using the given algorithm (see below)
|
|
8 |
checksum_algorithm VARCHAR(250), --the algorithm used to calculate the checksum
|
|
9 |
origin_member_node VARCHAR(250), --the member node where the document was first uploaded
|
|
10 |
authoritive_member_node VARCHAR(250), --the member node that currently controls the document
|
|
11 |
date_modified TIMESTAMP, -- the last date/time that the file was changed
|
|
12 |
submitter VARCHAR(256), -- the user who originally submitted the doc
|
|
13 |
object_format VARCHAR(256), --the format of the object
|
|
14 |
size VARCHAR(256), --the size of the object
|
|
15 |
CONSTRAINT systemMetadata_pk PRIMARY KEY (guid)
|
|
2 |
guid text, -- the globally unique string identifier of the object that the system metadata describes
|
|
3 |
date_uploaded TIMESTAMP, -- the date/time the document was first submitted
|
|
4 |
rights_holder VARCHAR(250), --the user who has rights to the document, usually the first persons to upload it
|
|
5 |
checksum VARCHAR(512), --the checksum of the doc using the given algorithm (see below)
|
|
6 |
checksum_algorithm VARCHAR(250), --the algorithm used to calculate the checksum
|
|
7 |
origin_member_node VARCHAR(250), --the member node where the document was first uploaded
|
|
8 |
authoritive_member_node VARCHAR(250), --the member node that currently controls the document
|
|
9 |
date_modified TIMESTAMP, -- the last date/time that the file was changed
|
|
10 |
submitter VARCHAR(256), -- the user who originally submitted the doc
|
|
11 |
object_format VARCHAR(256), --the format of the object
|
|
12 |
size VARCHAR(256), --the size of the object
|
|
13 |
replication_allowed boolean, -- replication allowed
|
|
14 |
number_replicas INT8, -- the number of replicas allowed
|
|
15 |
CONSTRAINT systemMetadata_pk PRIMARY KEY (guid)
|
|
16 | 16 |
); |
17 |
/* |
|
18 |
* Table used to store system metadata provenance information |
|
19 |
*/ |
|
20 |
CREATE TABLE systemMetadataProvenance ( |
|
21 |
guid text, -- the globally unique string identifier of the object that the system metadata describes |
|
22 |
relationship VARCHAR(250), -- the provenance relationship defined between objects |
|
23 |
target_guid text, -- the globally unique string identifier of the other object |
|
24 |
CONSTRAINT systemMetadataProvenance_fk |
|
25 |
FOREIGN KEY (guid) REFERENCES systemMetadata |
|
26 |
); |
|
17 | 27 |
|
28 |
CREATE TABLE systemMetadataReplicationPolicy ( |
|
29 |
guid text, -- the globally unique string identifier of the object that the system metadata describes |
|
30 |
member_node VARCHAR(250), -- replication member node |
|
31 |
policy text, -- the policy (preferred, blocked, etc...TBD) |
|
32 |
CONSTRAINT systemMetadataReplicationPolicy_fk |
|
33 |
FOREIGN KEY (guid) REFERENCES systemMetadata |
|
34 |
); |
|
35 |
|
|
36 |
CREATE TABLE systemMetadataReplicationStatus ( |
|
37 |
guid text, -- the globally unique string identifier of the object that the system metadata describes |
|
38 |
member_node VARCHAR(250), -- replication member node |
|
39 |
status VARCHAR(250), -- replication status |
|
40 |
date_verified TIMESTAMP, -- the date replication was verified |
|
41 |
CONSTRAINT systemMetadataReplicationStatus_fk |
|
42 |
FOREIGN KEY (guid) REFERENCES systemMetadata |
|
43 |
); |
|
44 |
|
|
18 | 45 |
CREATE TABLE identifier ( |
19 | 46 |
guid text, -- the globally unique string identifier |
20 | 47 |
docid VARCHAR(250), -- the local document id # |
... | ... | |
31 | 58 |
CREATE INDEX xml_path_index_idx5 ON xml_path_index (nodedatadate); |
32 | 59 |
|
33 | 60 |
/* |
61 |
* Replication changes to support DataONE System Metadata replication |
|
62 |
*/ |
|
63 |
ALTER TABLE xml_replication ADD COLUMN systemmetadatareplicate INT8; |
|
64 |
/* |
|
65 |
* Allow guid in xml_access table (for system metadata) |
|
66 |
*/ |
|
67 |
ALTER TABLE xml_access ADD COLUMN guid text; |
|
68 |
|
|
69 |
/* |
|
34 | 70 |
* Register the DataONE schemas |
35 | 71 |
*/ |
36 | 72 |
|
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