------------------------------------------------------------------------------
--- Copyright (c) 1998-2009 Luna Imaging, Inc.  All Rights Reserved.
---
--- This software is confidential and proprietary information of
--- Luna Imaging, Inc.  ("Confidential Information").  You shall not
--- disclose such Confidential Information and shall use it only in
--- accordance with the terms of the license agreement you entered into
--- with Luna Imaging, Inc.
---
--- The software may not be copied, reproduced, translated or reduced to
--- any electronic medium or machine-readable form without
--- the prior written consent of Luna Imaging.
---
--- You are not allowed to distribute the binary and source code
--- (if released) to third parties, without the prior written consent from
--- Luna Imaging.
---
--- You are not allowed to reverse engineer, disassemble or decompile
--- code, or make any modifications of the binary or source code, remove
--- or alter any trademark, logo, copyright or other proprietary notices,
--- legends, symbols, or labels in the Software.
---
--- You are not allowed to sub-license the Software or any derivative
--- work based on or derived from the Software.
---
--- LUNA IMAGING MAKES NO REPRESENTATIONS OR WARRANTIES ABOUT THE SUITABILITY
--- OF THE SOFTWARE, EITHER EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED
--- TO THE IMPLIED WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR
--- PURPOSE, OR NON-INFRINGEMENT, LUNA IMAGING SHALL NOT BE LIABLE FOR ANY
--- DAMAGES SUFFERED BY LICENSEE AS A RESULT OF USING, MODIFYING OR
--- DISTRIBUTING THIS SOFTWARE OR ITS DERIVATIVES.
------------------------------------------------------------------------------
CREATE TABLE LAS_ANCILLARY_INDEX (
	ID NUMBER  NOT NULL ,
	COLLECTIONID NUMBER NULL ,
	ENTITYID NUMBER NULL ,
	INDEXCONTENT VARCHAR2 (4000)  NULL ,
	INSTITUTIONID VARCHAR2 (50)  NULL ,
	LASTINDEXEDDATE DATE NULL ,
	MEDIAID NUMBER NULL ,
	MEDIATYPE NUMBER NOT NULL ,
	RECACHE NUMBER NOT NULL ,
	STATUS NUMBER NOT NULL ,
	UNIQUECOLLECTIONID NUMBER NULL ,
	URL VARCHAR2 (2000)  NULL ,
	VCID VARCHAR2 (50)  NULL 
);


ALTER TABLE LAS_ANCILLARY_INDEX
  ADD CONSTRAINT PK_LAS_ANCILLARY_INDEX
  PRIMARY KEY (ID);

create sequence ANCILLARY_INDEX_seq 
  start with 1 
  increment by 1 
  nomaxvalue;  

create trigger ANCILLARY_INDEX_trigger before insert on LAS_ANCILLARY_INDEX for each row when (new.id is null) begin select ANCILLARY_INDEX_seq.nextval into :new.id from dual; end;;

CREATE INDEX IDX_AS_ANCILLARY_INDEX ON LAS_ANCILLARY_INDEX(ENTITYID, MEDIAID, COLLECTIONID, UNIQUECOLLECTIONID, INSTITUTIONID);


commit;