Revision 9483
Added by Jing Tao over 7 years ago
| xmltables-postgres.sql | ||
|---|---|---|
| 341 | 341 |
* ALTER TABLE systemMetadata ADD COLUMN number_replicas INT8; |
| 342 | 342 |
*/ |
| 343 | 343 |
|
| 344 |
|
|
| 344 |
CREATE SEQUENCE policy_id_seq; |
|
| 345 | 345 |
CREATE TABLE smReplicationPolicy ( |
| 346 |
policy_id INT8 default nextval('policy_id_seq'),
|
|
| 346 | 347 |
guid text, -- the globally unique string identifier of the object that the system metadata describes |
| 347 | 348 |
member_node VARCHAR(250), -- replication member node |
| 348 | 349 |
policy text, -- the policy (preferred, blocked, etc...TBD) |
Also available in: Unified diff
Add a policy_id in the smReplicationPolicy table to help preserver the order of the nodes list.