Revision 1421
Added by Jing Tao almost 22 years ago
| xmltables_postgres.sql | ||
|---|---|---|
| 183 | 183 |
begin_time DATE, -- the time that permission begins |
| 184 | 184 |
end_time DATE, -- the time that permission ends |
| 185 | 185 |
ticket_count INT8, -- ticket counter for that permission |
| 186 |
subtreeid VARCHAR(32), |
|
| 187 |
startnodeid INT8, |
|
| 188 |
endnodeid INT8, |
|
| 186 | 189 |
CONSTRAINT xml_access_ck CHECK (begin_time < end_time), |
| 187 | 190 |
CONSTRAINT xml_access_accessfileid_fk |
| 188 | 191 |
FOREIGN KEY (accessfileid) REFERENCES xml_documents |
Also available in: Unified diff
Modify postgres access table.