Revision 1623
Added by Jing Tao over 21 years ago
| src/reviseformetacat13_postgres.sql | ||
|---|---|---|
| 23 | 23 |
/* |
| 24 | 24 |
* accesssubtree -- table to store access subtree info |
| 25 | 25 |
*/ |
| 26 |
|
|
| 26 | 27 |
CREATE TABLE xml_accesssubtree ( |
| 27 |
docid VARCHAR(250), -- the document id #
|
|
| 28 |
rev INT8 default 1, --the revision number of the docume
|
|
| 28 |
docid VARCHAR(250), -- the document id #
|
|
| 29 |
rev INT8 default 1, --the revision number of the docume
|
|
| 29 | 30 |
controllevel VARCHAR(50), -- the level it control -- document or subtree |
| 30 |
subtreeid VARCHAR(250), -- the subtree id |
|
| 31 |
startnodeid INT8, -- the start node id of access subtree |
|
| 32 |
endnodeid INT8 -- the end node if of access subtree |
|
| 31 |
subtreeid VARCHAR(250), -- the subtree id |
|
| 32 |
startnodeid INT8, -- the start node id of access subtree |
|
| 33 |
endnodeid INT8, -- the end node if of access subtree |
|
| 34 |
CONSTRAINT xml_accesssubtree_docid_fk |
|
| 35 |
FOREIGN KEY (docid) REFERENCES xml_documents |
|
| 33 | 36 |
); |
| 34 | 37 |
|
| 35 | 38 |
/* |
Also available in: Unified diff
Add a foreign key in accesssubtree table.