Revision 445
Added by bojilova over 24 years ago
src/xmltables.sql | ||
---|---|---|
77 | 77 |
user_updated VARCHAR2(100), -- the user updated the document |
78 | 78 |
date_created DATE, |
79 | 79 |
date_updated DATE, |
80 |
public_access NUMBER(1), -- flag for public access
|
|
80 |
public_access NUMBER(1) DEFAULT 1, -- flag for public access
|
|
81 | 81 |
CONSTRAINT xml_documents_pk PRIMARY KEY (docid), |
82 | 82 |
CONSTRAINT xml_documents_root_fk |
83 | 83 |
FOREIGN KEY (rootnodeid) REFERENCES xml_nodes |
Also available in: Unified diff
xml_documents.public_access modified to be
NUMBER DEFAULT 1
ie all documents to have public access by default