Revision 5333
Added by berkley almost 13 years ago
xmltables-postgres.sql | ||
---|---|---|
283 | 283 |
); |
284 | 284 |
|
285 | 285 |
/* |
286 |
* Table used to store all document identifiers for system metadata objects |
|
287 |
* similar restraints to identifier. Cannot use identifier table for this |
|
288 |
* purpose because then you have to worry about whether you insert the |
|
289 |
* data first or the systemMetadata first. |
|
290 |
*/ |
|
291 |
CREATE TABLE systemMetadata ( |
|
292 |
guid text, -- the globally unique string identifier |
|
293 |
docid VARCHAR(250), -- the local document id # |
|
294 |
rev INT8, -- the revision part of the local identifier |
|
295 |
CONSTRAINT systemMetadata_pk PRIMARY KEY (guid) |
|
296 |
); |
|
297 |
|
|
298 |
/* |
|
286 | 299 |
* accesssubtree -- table to store access subtree info |
287 | 300 |
*/ |
288 | 301 |
CREATE TABLE xml_accesssubtree ( |
Also available in: Unified diff
adding a system to track system metadata documents for dataone