------------------------------------------------------------------------------
--- Copyright (c) 1998-2008 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 SLIDEVIDEOS;
DROP SEQUENCE SLIDEVIDEOS_seq;


------------------------------------------------
-- Create Table Statements for SLIDEVIDEOS
------------------------------------------------  

CREATE TABLE SLIDEVIDEOS(
	ID NUMBER NOT NULL,
	SLIDEID NUMBER NOT NULL,
	MEDIAID VARCHAR2(100) NOT NULL,
	WORKSPACEWIDTH NUMBER NOT NULL,
	WORKSPACEHEIGHT NUMBER NOT NULL,
	POSITIONX NUMBER NOT NULL,
	POSITIONY NUMBER NOT NULL,
	PANELWIDTH NUMBER NOT NULL,
	PANELHEIGHT NUMBER NOT NULL,
	STARTTIME NUMBER NOT NULL,
	STACKORDER NUMBER NOT NULL );

ALTER TABLE SLIDEVIDEOS
  ADD CONSTRAINT PK_SLIDEVIDEO
  PRIMARY KEY (ID);	
  
create sequence SLIDEVIDEOS_seq 
  start with 1 
  increment by 1 
  nomaxvalue;
	
-- Create Trigger SLIDEVIDEOS_trigger
create trigger SLIDEVIDEOS_trigger before insert on SLIDEVIDEOS for each row when (new.id is null) begin select SLIDEVIDEOS_seq.nextval into :new.id from dual; end;;


ALTER TABLE SLIDEIMAGES RENAME COLUMN CENTERPONUMBERX TO CENTERPOINTX;
ALTER TABLE SLIDEIMAGES RENAME COLUMN CENTERPONUMBERY TO CENTERPOINTY;


commit;
