rem --------------------------------------------------------------------------
rem File:        $RCSfile: odwasess.tab $
rem Author:      $Author: pcsmith $
rem Date:        $Date: 2002/08/07 11:04:32 $
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: odwasess.tab $
rem Revision 1.1  2002/08/07 11:04:32  pcsmith
rem Initial revision
rem
rem --------------------------------------------------------------------------
rem  
-- Revision History
-- $LABEL1.1 $   $KW_DATE$
-- 24-jul-2000 Lucas Jellema
-- 1.0         initial creation for ODWA 6i
-- current label: $LABEL1.1 $

create table odwa_sessions
(
 id                    number(10)
,username              varchar2(30)  default user
,number_of_requests    number(10)    default 1
,workarea_irid         number(38)
,timestamp_creation    date          default sysdate
,timestamp_last_call   date
,pac_irid              number(38)
,pac_ivid              number(38)
,pac_type_id           number(38)
,folder_irid           number(38)
,folder_ivid           number(38)
,cfg_id                number(38)
)
/

create sequence odwa_session_seq
/
rem  
rem  
rem --------------------------------------------------------------------------
rem $$Header_is_done
rem  End of file $RCSfile: odwasess.tab $
rem --------------------------------------------------------------------------
rem