Revision 445
Added by bojilova over 23 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