Revision 7392
Added by ben leinfelder about 12 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