metacat/src/createaccesssubtreetable_postgres.sql @ 1548
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 |
);
|