--
-- 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 BIGINT(19) NOT NULL AUTO_INCREMENT ,
	COLLECTIONID INTEGER NULL ,
	ENTITYID BIGINT(19) NULL ,
	INDEXCONTENT VARCHAR (4000)  NULL ,
	INSTITUTIONID VARCHAR (50)  NULL ,
	LASTINDEXEDDATE DATETIME NULL ,
	MEDIAID BIGINT(19) NULL ,
	MEDIATYPE INTEGER NOT NULL ,
	RECACHE INTEGER NOT NULL ,
	STATUS INTEGER NOT NULL ,
	UNIQUECOLLECTIONID INTEGER NULL ,
	URL VARCHAR (2000)  NULL ,
	VCID VARCHAR (50)  NULL,
  PRIMARY KEY (`ID`) 
)DEFAULT CHARACTER SET utf8;


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