Revision 9576
Added by Jing Tao over 8 years ago
| src/xmltables-postgres.sql | ||
|---|---|---|
| 130 | 130 |
target_doctype VARCHAR(500), -- the target public_id for transforms |
| 131 | 131 |
public_id VARCHAR(500), -- the unique id for this type |
| 132 | 132 |
system_id VARCHAR(1000), -- the local location of the object |
| 133 |
format_id VARCHAR(1000), -- the format id from dataone |
|
| 133 | 134 |
CONSTRAINT xml_catalog_pk PRIMARY KEY (catalog_id), |
| 134 | 135 |
CONSTRAINT xml_catalog_uk UNIQUE |
| 135 |
(entry_type, source_doctype, target_doctype, public_id) |
|
| 136 |
(entry_type, source_doctype, target_doctype, public_id, format_id)
|
|
| 136 | 137 |
); |
| 137 | 138 |
|
| 138 | 139 |
/* |
Also available in: Unified diff
Add the format_id column on the xml_catalog table.