Revision 1605
Added by Jing Tao about 21 years ago
| xmltables_postgres.sql | ||
|---|---|---|
| 227 | 227 |
relationship VARCHAR(128) NOT NULL,-- the relationship type |
| 228 | 228 |
object VARCHAR(512) NOT NULL, -- the object of the relation |
| 229 | 229 |
objdoctype VARCHAR(128), -- the doctype of the object |
| 230 |
CONSTRAINT xml_relation_uk UNIQUE (subject, relationship, object), |
|
| 230 |
CONSTRAINT xml_relation_uk UNIQUE (docid, subject, relationship, object),
|
|
| 231 | 231 |
CONSTRAINT xml_relation_docid_fk |
| 232 | 232 |
FOREIGN KEY (docid) REFERENCES xml_documents |
| 233 | 233 |
); |
Also available in: Unified diff
Change a unique constraint in xml_relation table.