removeEvalTablesOracle.sql

--
-- Copyright 2005 Sakai Foundation Licensed under the
-- Educational Community License, Version 2.0 (the "License"); you may
-- not use this file except in compliance with the License. You may
-- obtain a copy of the License at
--
-- http://www.osedu.org/licenses/ECL-2.0
--
-- Unless required by applicable law or agreed to in writing,
-- software distributed under the License is distributed on an "AS IS"
-- BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express
-- or implied. See the License for the specific language governing
-- permissions and limitations under the License.
--

-- This is the SQL for use on Oracle DBs to clear the Sakai Evaluation tables from
-- the database.
--
-- WARNING: This will delete all your evaluation data permanently! It should only
--          be used for development purposes.
--
drop table EVAL_ADHOC_EVALUATEES;
drop table EVAL_ADHOC_PARTICIPANTS;
drop table EVAL_ADHOC_GROUP cascade constraints;
drop table EVAL_ADHOC_USER;
drop table EVAL_CONFIG;
drop table EVAL_LOCK;
drop table EVAL_TAGS;
drop table EVAL_TAGS_META;
drop table EVAL_TRANSLATION;
drop table EVAL_ASSIGN_GROUP;
drop table EVAL_ASSIGN_USER;
drop table EVAL_ANSWER;
drop table EVAL_RESPONSE;
drop table EVAL_TEMPLATEITEM;
drop table EVAL_EVALUATION;
drop table EVAL_EMAIL_TEMPLATE;
drop table EVAL_TEMPLATE;
drop table EVAL_ITEMGROUP cascade constraints;
drop table EVAL_ITEM cascade constraints;
drop table EVAL_SCALE cascade constraints;
drop table EVAL_SCALE_OPTIONS;
drop table EVAL_GROUPNODES;
drop table EVAL_GROUPNODES_GROUPS;
drop table EVAL_ASSIGN_HIERARCHY;
drop table EVAL_HIERARCHY_RULE;
drop table EVAL_EMAIL_PROCESSING_QUEUE;
drop table EVAL_ADMIN;