Revision 6107
Added by ben leinfelder about 13 years ago
| xmltables-oracle.sql | ||
|---|---|---|
| 414 | 414 |
submitter VARCHAR2(256), -- the user who originally submitted the doc |
| 415 | 415 |
object_format VARCHAR2(256), --the format of the object |
| 416 | 416 |
size VARCHAR2(256), --the size of the object |
| 417 |
replication_allowed boolean, -- replication allowed |
|
| 418 |
number_replicas NUMBER(8), -- the number of replicas allowed |
|
| 417 | 419 |
CONSTRAINT systemMetadata_pk |
| 418 | 420 |
PRIMARY KEY (guid) |
| 419 | 421 |
) |
| ... | ... | |
| 429 | 431 |
FOREIGN KEY (guid) REFERENCES systemMetadata |
| 430 | 432 |
); |
| 431 | 433 |
|
| 434 |
CREATE TABLE systemMetadataReplicationPolicy ( |
|
| 435 |
guid VARCHAR2(2000), -- the globally unique string identifier of the object that the system metadata describes |
|
| 436 |
member_node VARCHAR(250), -- replication member node |
|
| 437 |
policy VARCHAR2(2000), -- the policy (preferred, blocked, etc...TBD) |
|
| 438 |
CONSTRAINT systemMetadataReplicationPolicy_fk |
|
| 439 |
FOREIGN KEY (guid) REFERENCES systemMetadata |
|
| 440 |
); |
|
| 441 |
|
|
| 442 |
CREATE TABLE systemMetadataReplicationStatus ( |
|
| 443 |
guid VARCHAR2(2000), -- the globally unique string identifier of the object that the system metadata describes |
|
| 444 |
member_node VARCHAR(250), -- replication member node |
|
| 445 |
status VARCHAR(250), -- replication status |
|
| 446 |
date_verified DATE, -- the date replication was verified |
|
| 447 |
CONSTRAINT systemMetadataReplicationStatus_fk |
|
| 448 |
FOREIGN KEY (guid) REFERENCES systemMetadata |
|
| 449 |
); |
|
| 450 |
|
|
| 432 | 451 |
/* |
| 433 | 452 |
* Table used to store all document identifiers in metacat. Each identifier |
| 434 | 453 |
* has a globally unique, unconstrained string, which we will refer to as a |
Also available in: Unified diff
persist system metadata replication policy and status using db tables