rem --------------------------------------------------------------------------
rem File:        $RCSfile: wsgp.sql $
rem Author:      $Author: rclewley $
rem Date:        $Date: 2001/04/19 11:29:01 $
rem Version:     $Revision: 1.5 $
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: wsgp.sql $
rem Revision 1.5  2001/04/19  11:29:01  rclewley
rem B1727074: Modifications to account for the provider package bodies being moved to seperate pkb files.
rem
rem Revision 1.4  2001/01/31  18:37:50  ngilmore
rem Re-ordered packages calls
rem
rem Revision 1.3  2001/01/15  14:57:02  ngilmore
rem Added calls to WSGAPT.PKS and WSGCSS.pks
rem
rem Revision 1.2  2000/12/28  13:35:36  ngilmore
rem Added column CSS_STYLE to WSG_AVAILABLE_PORTLETS
rem
rem Revision 1.1  2000/12/08  17:56:38  ngilmore
rem Initial revision
rem
rem --------------------------------------------------------------------------
rem  


-- Create the portlets table to store all the available
-- Portlets to the WSG_GENERIC_PROVIDER
PROMPT Creating Table 'WSG_AVAILABLE_PORTLETS'
create table WSG_AVAILABLE_PORTLETS
(
  PORTLET_ID NUMBER(5) not null,
  PORTLET_PACKAGE VARCHAR2(30),
  FORM_LINK_URL VARCHAR2(4000) DEFAULT null
);

-- Atler WSG_AVAILABLE_PORTLETS to add a Primary Key
PROMPT Altering Table 'WSG_AVAILABLE_PORTLETS' adding Primary key
alter table WSG_AVAILABLE_PORTLETS
  add constraint WSG_AP_PK primary key (PORTLET_ID);
  

-- Create the sequence used when adding to the list of available
-- portlets (WSG_AVAILABLE_PORTLETS table) for the WSG_GENERIC_PROVIDER
PROMPT Creating Sequence 'WSG_SEQUENCE'
create sequence WSG_SEQUENCE
minvalue 1
maxvalue 999999999999999999999999999
start with 1
increment by 1;


-- Create WSGAPT Package
@@wsgapt.pks
@@wsgapt.pkb

-- Create WSGCSS Package
@@wsgcss.pks
@@wsgcss.pkb

-- Create WSG_GENERIC_PROVIDER Package
@@wsgp.pks
@@wsgp.pkb

rem  
rem  
rem --------------------------------------------------------------------------
rem $$Header_is_done
rem  End of file $RCSfile: wsgp.sql $
rem --------------------------------------------------------------------------
rem 




