Revision 6136
Added by ben leinfelder over 13 years ago
xmltables-postgres.sql | ||
---|---|---|
39 | 39 |
last_checked DATE, |
40 | 40 |
replicate INT8, |
41 | 41 |
datareplicate INT8, |
42 |
systemmetadatareplicate INT8, |
|
42 | 43 |
hub INT8, |
43 | 44 |
CONSTRAINT xml_replication_pk PRIMARY KEY (serverid) |
44 | 45 |
); |
45 | 46 |
|
46 |
INSERT INTO xml_replication (server, replicate, datareplicate, hub) VALUES ('localhost', '0', '0', '0'); |
|
47 |
INSERT INTO xml_replication (server, replicate, datareplicate, systemmetadatareplicate, hub) VALUES ('localhost', '0', '0', '0' '0'); |
|
48 |
/* |
|
49 |
* ALTER TABLE xml_replication ADD COLUMN systemmetadatareplicate INT8; |
|
50 |
*/ |
|
47 | 51 |
|
48 | 52 |
/* |
49 | 53 |
* Nodes -- table to store XML Nodes (both elements and attributes) |
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