Project

General

Profile

Revision 166

Added by Matt Jones over 20 years ago

minor modifications to fix problems introduced with AccessionNumber module

View differences:

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