Revision 7392
Added by ben leinfelder over 11 years ago
| xmltables-postgres.sql | ||
|---|---|---|
| 319 | 319 |
*/ |
| 320 | 320 |
|
| 321 | 321 |
|
| 322 |
CREATE TABLE systemMetadataReplicationPolicy (
|
|
| 322 |
CREATE TABLE smReplicationPolicy (
|
|
| 323 | 323 |
guid text, -- the globally unique string identifier of the object that the system metadata describes |
| 324 | 324 |
member_node VARCHAR(250), -- replication member node |
| 325 | 325 |
policy text, -- the policy (preferred, blocked, etc...TBD) |
| 326 |
CONSTRAINT systemMetadataReplicationPolicy_fk
|
|
| 326 |
CONSTRAINT smReplicationPolicy_fk
|
|
| 327 | 327 |
FOREIGN KEY (guid) REFERENCES systemMetadata DEFERRABLE |
| 328 | 328 |
); |
| 329 | 329 |
|
| 330 |
CREATE TABLE systemMetadataReplicationStatus (
|
|
| 330 |
CREATE TABLE smReplicationStatus (
|
|
| 331 | 331 |
guid text, -- the globally unique string identifier of the object that the system metadata describes |
| 332 | 332 |
member_node VARCHAR(250), -- replication member node |
| 333 | 333 |
status VARCHAR(250), -- replication status |
| 334 | 334 |
date_verified TIMESTAMP, -- the date replication was verified |
| 335 |
CONSTRAINT systemMetadataReplicationStatus_fk
|
|
| 335 |
CONSTRAINT smReplicationStatus_fk
|
|
| 336 | 336 |
FOREIGN KEY (guid) REFERENCES systemMetadata DEFERRABLE |
| 337 | 337 |
); |
| 338 | 338 |
|
Also available in: Unified diff
shorten the systemmetadata* table names for Oracle's 30 character limit. move version to 2.0.5. http://bugzilla.ecoinformatics.org/show_bug.cgi?id=5717