metacat/src/createaccesssubtreetable_postgres.sql @ 1546
| 1 |
|
|---|---|
| 2 |
/*
|
| 3 |
* accessSubtree -- table to store access subtree info
|
| 4 |
*/
|
| 5 |
CREATE TABLE xml_accesssubtree ( |
| 6 |
docid VARCHAR(250), -- the document id # |
| 7 |
rev INT8 default 1, --the revision number of the docume |
| 8 |
controllevel VARCHAR(50), -- the level it control -- document or subtree |
| 9 |
subtreeid VARCHAR(250), -- the subtree id |
| 10 |
startnodeid INT8, -- the start node id of access subtree |
| 11 |
endnodeid INT8 -- the end node if of access subtree |
| 12 |
);
|