------------------------------------------------------------------------------
--- 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.
------------------------------------------------------------------------------


------------------------------------------------
-- Drop Table, Triggers and Sequences Statements
------------------------------------------------


DROP TABLE ANNOTATIONS;
DROP SEQUENCE ANNOTATIONS_seq;


------------------------------------------------
-- Create Table Statements for ANNOTATIONS
------------------------------------------------  

CREATE TABLE ANNOTATIONS(
	ID NUMBER NOT NULL,
	USERID NUMBER NOT NULL,
	MEDIAID VARCHAR2(50) NOT NULL,
	MGID NUMBER NOT NULL,
	ANNOTATION VARCHAR2(4000)  NULL,
	COLOR VARCHAR2(50)  NULL,
	XPOS NUMBER NOT NULL,
	YPOS NUMBER NOT NULL,
	IMGWIDTH NUMBER NOT NULL,
	IMGHEIGHT NUMBER NOT NULL );

ALTER TABLE ANNOTATIONS
  ADD CONSTRAINT PK_ANNOTATIONS
  PRIMARY KEY (ID);

create sequence ANNOTATIONS_seq 
  start with 1 
  increment by 1 
  nomaxvalue;  
	
-- Create Trigger ANNOTATIONS_trigger
create trigger ANNOTATIONS_trigger before insert on ANNOTATIONS for each row when (new.id is null) begin select ANNOTATIONS_seq.nextval into :new.id from dual; end;;


ALTER TABLE CREDENTIALCOLLECTIONMAP ADD ANNOTATIONENABLED NUMBER NULL;

ALTER TABLE CREDENTIALS ADD UPLOADALLOWED NUMBER NULL;
ALTER TABLE CREDENTIALS ADD SUPPORTEDUPLOADFORMATS VARCHAR2(255) NULL;

ALTER TABLE EXTERNALMEDIA ADD MEDIASOURCE VARCHAR2(25) NULL;

UPDATE USERS SET DISPLAYHELPFULTIPS='00000000000000000000000000';

commit;
