rem --------------------------------------------------------------------------
rem File:        $RCSfile: odwagrph.tab $
rem Author:      $Author: pcsmith $
rem Date:        $Date: 2002/08/07 11:04:12 $
rem Version:     $Revision: 1.1 $
rem Status:      $State: Exp $
rem Locked_by:   $Locker:  $
rem Description: <Enter global description here>
rem Notes:       <Global notes>
rem RealAuth:    <Full real name of code author>
rem IncepDate:   <nnth Xxxember 1999>
rem Copyright:   (c) Oracle Corporation 1999.  All Rights Reserved.
rem --------------------------------------------------------------------------
rem Log of Changes from RCS
rem --------------------------------------------------------------------------
rem $Log: odwagrph.tab $
rem Revision 1.1  2002/08/07 11:04:12  pcsmith
rem Initial revision
rem
rem --------------------------------------------------------------------------
rem  
-- Revision History
-- Label      Date         Who            What
------------------------------------------------------------------------------------------
--            18-jul-2002  ReposDev       added PK contraint and contraint markers for RAU
--            22-sep-2000  Lucas Jellema
-- 1.5        06-mar-2001                 add primary key on ODWA_GRAPHICS; FOREIGN KEY on ODWA_HOTSPOTS
-- 1.1                                    update odwa_hotspots
-- 1.0                                    initial creation for ODWA 6i
-- current label: $LABEL1.5 $

create table odwa_grph_categories
( id                   number(5)
, name                 varchar2(50)
, description          varchar2(4000)
)
/

create table odwa_graphics
( code                 varchar2(50)
, category_id          number(5)
, description          varchar2(4000)
, grph_type            varchar2(1)    -- F, U, R
, irid                 number(38)     -- identification of GIF/JPEG file in the Repository
, ivid                 number(38)
, filename             varchar2(2000) -- full path+file name
, url                  varchar2(2000) -- url to gif/jpeg on Intranet/Internet
)
/

--RAU ODWA_GPH_PK 
alter table odwa_graphics
add constraint odwa_gph_pk primary key (code)
/

create table odwa_hotspots
( grph_code       varchar2(50)
, id              number(10)
, seq             number(4)
, upperleft       varchar2(20)
, lowerright      varchar2(20)
, alt_text        varchar2(500)
, spot_type       varchar2(1)
, link_grph_code  varchar2(50)
, irid            number(38)
, ivid            number(38)
, FILENAME        VARCHAR2(2000)
, url             varchar2(2000)
, LABEL           VARCHAR2(200)
, SPOT_SUB_TYPE   VARCHAR2(3)
)
/

--RAU ODWA_HST_GPH_FK
alter table ODWA_HOTSPOTS
  add constraint ODWA_HST_gph_FK foreign key (GRPH_CODE)
  references ODWA_GRAPHICS (CODE) on delete cascade
/

create sequence odwa_grph_cat_seq
/
create sequence odwa_hotspot_seq
/
rem  
rem  
rem --------------------------------------------------------------------------
rem $$Header_is_done
rem  End of file $RCSfile: odwagrph.tab $
rem --------------------------------------------------------------------------
rem