Revision 166
Added by Matt Jones over 24 years ago
| src/sqlnodesview.sql | ||
|---|---|---|
| 2 | 2 |
column pnode format 9999 |
| 3 | 3 |
column nind format 999 |
| 4 | 4 |
column nodetype format a10 |
| 5 |
column nodename format a15
|
|
| 5 |
column nodename format a11
|
|
| 6 | 6 |
column nodedata format a23 |
| 7 |
column docid format a5
|
|
| 7 |
column docid format a9
|
|
| 8 | 8 |
column rnode format 9999 |
| 9 | 9 |
select nodeid node, parentnodeid pnode, nodeindex nind, nodetype, |
| 10 | 10 |
nodename, nodedata, docid, rootnodeid rnode |
| src/xmltables.sql | ||
|---|---|---|
| 122 | 122 |
*/ |
| 123 | 123 |
CREATE TABLE xml_acc_numbers ( |
| 124 | 124 |
global_name VARCHAR2(32), -- first part of acc # |
| 125 |
local_id NUMBER(20), -- second part - unique inside global name
|
|
| 125 |
local_id NUMBER(20), -- second part - unique in global name |
|
| 126 | 126 |
CONSTRAINT xml_acc_numbers_pk PRIMARY KEY (global_name, local_id) |
| 127 | 127 |
); |
Also available in: Unified diff
minor modifications to fix problems introduced with AccessionNumber module