rem ----------------------------------------------------------------------------
rem File:        $RCSfile: WSGSR.SQL $
rem Author:      $Author: ipenning $
rem Date:        $Date: 1998/11/10 15:39: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 1998>
rem Copyright:   (c) Oracle Corporation 1998.  All Rights Reserved.
rem ----------------------------------------------------------------------------
rem Log of Changes from RCS
rem ----------------------------------------------------------------------------
rem $Log: WSGSR.SQL $
rem Revision 1.1  1998/11/10  15:39:32  ipenning
rem Initial revision
rem
rem ----------------------------------------------------------------------------
rem  


PROMPT Creating Table 'WSGSR_SESSIONS' 
CREATE TABLE WSGSR_SESSIONS
 (CLIENT_ID  VARCHAR2(240) NOT NULL
 ,USER_NAME  VARCHAR2(30) NOT NULL
 ,IP_ADDRESS  VARCHAR2(30) NOT NULL
 ,EXPIRES  DATE
 )
/

PROMPT Creating Table 'WSGSR_USERDATA' 
CREATE TABLE WSGSR_USERDATA
 (USER_NAME  VARCHAR2(30) NOT NULL
 ,PASSWORD  VARCHAR2(30) NOT NULL
 ,TITLE  VARCHAR2(10)
 ,NAME1  VARCHAR2(30) NOT NULL
 ,NAME2  VARCHAR2(30)
 ,SEX  VARCHAR2(4)
 ,EMAIL  VARCHAR2(30) NOT NULL
 ,ADDRESS1  VARCHAR2(30) NOT NULL
 ,ADDRESS2  VARCHAR2(30)
 ,ADDRESS3  VARCHAR2(30)
 ,ADDRESS4  VARCHAR2(30)
 ,POSTCODE  VARCHAR2(10)
 ,TELEPHONE  VARCHAR2(30)
 )
/

PROMPT Creating Primary Key on 'WSGSR_SESSIONS'
ALTER TABLE WSGSR_SESSIONS ADD CONSTRAINT
 WSGSR_SESS_PK PRIMARY KEY 
  (CLIENT_ID)
/

PROMPT Creating Primary Key on 'WSGSR_USERDATA'
ALTER TABLE WSGSR_USERDATA ADD CONSTRAINT
 WSGSR_USERDATA_PK PRIMARY KEY 
  (USER_NAME)
/

PROMPT Installing Self Registration security package
@@wsgsr.pks
@@wsgsr.pkb

rem  
rem ----------------------------------------------------------------------------
rem $$Header_is_done
rem  End of file $RCSfile: WSGSR.SQL $
rem ----------------------------------------------------------------------------
