rem --------------------------------------------------------------------------
rem File:        $RCSfile: odwa_htt.tab $
rem Author:      $Author: pcsmith $
rem Date:        $Date: 2002/08/07 11:03:46 $
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: odwa_htt.tab $
rem Revision 1.1  2002/08/07 11:03:46  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
------------------------------------------------------------------------------------------


-- Create table 
create table ODWA_HELP_TEXT
(
  HIM_ID NUMBER(10) not null,
  SEQ NUMBER(3) not null,
  TXT VARCHAR2(4000)
)
;

--RAU ODWA_HTT_PK
alter table ODWA_HELP_TEXT
  add constraint ODWA_HTT_PK primary key (HIM_ID,SEQ)
/
  
--RAU ODWA_HTT_HIM_FK  
alter table ODWA_HELP_TEXT
  add constraint ODWA_HTT_HIM_FK foreign key (HIM_ID)
  references ODWA_HELP_ITEMS (ID) on delete cascade
/
rem  
rem  
rem --------------------------------------------------------------------------
rem $$Header_is_done
rem  End of file $RCSfile: odwa_htt.tab $
rem --------------------------------------------------------------------------
rem