-- $Id: oci8-destroy.sql,v 1.2 2005/02/27 09:33:05 rurban Exp $

set verify off
set feedback off

--================================================================
-- Prefix for table names.
--
-- You should set this to the same value you specify for
-- DATABASE_PREFIX in config.ini
--
-- You have to use a prefix, because some phpWiki tablenames are 
-- Oracle reserved words!

define prefix=phpwiki_

--================================================================
--
-- Don't modify below this point unless you know what you are doing.
--
--================================================================

--================================================================
-- Note on Oracle datatypes...
-- 
-- Most of the 'NOT NULL' constraints on the character columns have been 
-- 	dropped since they can contain empty strings which are seen by 
--	Oracle as NULL.
-- Oracle CLOBs are used for TEXTs/MEDUIMTEXTs columns.


prompt Initializing PhpWiki tables with:
prompt        prefix =  &prefix
prompt 
prompt Expect some 'ORA-00942: table or view does not exist' unless you are
prompt overwriting existing tables.
prompt 

define page_tbl=&prefix.page
define version_tbl=&prefix.version
define recent_tbl=&prefix.recent
define nonempty_tbl=&prefix.nonempty
define link_tbl=&prefix.link
define session_tbl=&prefix.session
define pref_tbl=&prefix.pref
define user_tbl=&prefix.user
define member_tbl=&prefix.member
define rating_tbl=&prefix.rating
define accesslog_tbl=&prefix.accesslog

prompt Dropping &page_tbl
DROP TABLE &page_tbl;

prompt Dropping &version_tbl
DROP TABLE &version_tbl;

prompt Dropping &recent_tbl
DROP TABLE &recent_tbl;

prompt Dropping &nonempty_tbl
DROP TABLE &nonempty_tbl;

prompt Dropping &link_tbl
DROP TABLE &link_tbl;

prompt Dropping &session_tbl
DROP TABLE &session_tbl;

-- Optional DB Auth and Prefs
-- For these tables below the default table prefix must be used 
-- in the DBAuthParam SQL statements also.

prompt Dropping &pref_tbl
DROP TABLE &pref_tbl;

-- better use the extra pref table where such users can be created easily 
-- without password.

prompt Dropping &user_tbl
DROP TABLE &user_tbl;

prompt Dropping &member_tbl
DROP TABLE &member_tbl;

-- if you plan to use the wikilens theme
prompt Dropping &rating_tbl
DROP TABLE &rating_tbl;

prompt Dropping &accesslog_tbl
DROP TABLE &accesslog_tbl;
