rem --------------------------------------------------------------------------
rem File:        $RCSfile: odwa_prf.tab $
rem Author:      $Author: kparthas $
rem Date:        $Date: 2002/11/22 03:10:58 $
rem Version:     $Revision: 1.3 $
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_prf.tab $
rem Revision 1.3  2002/11/22 03:10:58  kparthas
rem Fixed OAC P1 violations
rem
rem Revision 1.2  2002/09/26 19:18:11  kparthas
rem Added new preference use_cdm and obsoleted doc_path preference.
rem
rem Revision 1.1  2002/08/07 11:03:48  pcsmith
rem Initial revision
rem
rem --------------------------------------------------------------------------
rem  
-- Purpose: Create table odwa_preferences  and insert the rows
--
-- Usage:   Run while connected as ODWA owner
--
-- Remarks: values for preferences may be customzied
--
--
-- Revision History
-- Date         Label      Who               What
------------------------------------------------------------------------------------------
-- 18-jul-2002             ReposDev          added contraint markers for RAU
-- 29-jan-2001  1.2        Lucas Jellema     Add global_search_users; provide better default values
-- 29-jan-2001  1.1        Lucas Jellema     Add servlet_urlbase and servlets_enabled
-- 25-jan-2001  1.0        Lucas Jellema     Initial Creation
--
-------------------------------------------------------------------------------


-- Create table 
create table odwa_preferences
(
  preference_name        varchar2(50)          not null
, preference_value       varchar2(2000) 
, preference_description varchar2(2000) 
);

-- Create/Recreate primary, unique and foreign key constraints 

--RAU ODWA_PRF_PK
alter table odwa_preferences
  add constraint odwa_prf_pk primary key (preference_name)
/

insert into odwa_preferences (preference_name, preference_value, preference_description)
values ( 'image_path', '/rob_images/' ,'Name of virtual directory mapped by the WebServer to the physical directory holding the ODWA images.')
/
insert into odwa_preferences (preference_name, preference_value, preference_description)
values ('edit_help_allowed', 'N', 'Is creation and editing of help items allowed? When Y the Edit Help option gets enabled.')
/
insert into odwa_preferences (preference_name, preference_value, preference_description)
values ('servlet_urlbase', '', 'The Base part of the URL (host, port and ServletZone) to access the ODWA6i servlets (e.g. http://nlsu108.nl.oracle.com:7777/odwa6i/, http://localhost.nl.oracle.com/odwa6i/')
/
insert into odwa_preferences (preference_name, preference_value, preference_description)
values ('servlets_enabled', 'N', 'Is a Java WebServer configured with the ODWA6i Servlets for file uploading?')
/
insert into odwa_preferences (preference_name, preference_value, preference_description)
values ('global_search_users', '', 'A comma delimited list of database/repository user names that are allowed to perform a global search, regardless of access privileges.')
/
insert into odwa_preferences (preference_name, preference_value, preference_description)
values ('use_cdm', 'N', 'Preference to indicate that the repository contains CDM objects')
/
insert into odwa_preferences (preference_name, preference_value, preference_description)
values ('charset', 'ISO-8859-1', 'Preference to indicate what charset the application data is')
/

rem  
rem  
rem --------------------------------------------------------------------------
rem $$Header_is_done
rem  End of file $RCSfile: odwa_prf.tab $
rem --------------------------------------------------------------------------
rem