Index: openacs-4/packages/evaluation/sql/oracle/evaluation-drop.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/evaluation/sql/oracle/evaluation-drop.sql,v diff -u -r1.3 -r1.4 --- openacs-4/packages/evaluation/sql/oracle/evaluation-drop.sql 7 Apr 2005 18:57:01 -0000 1.3 +++ openacs-4/packages/evaluation/sql/oracle/evaluation-drop.sql 8 Aug 2006 21:26:41 -0000 1.4 @@ -15,31 +15,18 @@ delete from acs_object_type_tables where object_type = 'evaluation_task_groups'; delete from group_types where group_type = 'evaluation_task_groups'; -begin -acs_object_type.drop_type('evaluation_task_group'); -acs_rel_type.drop_type('evaluation_task_group_rel'); -acs_object_type.drop_type('evaluation_grades'); -acs_object_type.drop_type('evaluation_tasks'); -acs_object_type.drop_type('evaluation_tasks_sols'); -acs_object_type.drop_type('evaluation_answers'); -acs_object_type.drop_type('evaluation_grades_sheets'); -acs_object_type.drop_type('evaluation_student_evals'); -acs_object_type.drop_type('evaluation_task_groups'); -end; -/ -show errors; -drop index ev_tasks_sols_tid_index; +drop index eva_tasks_sols_tid_index; drop view evaluation_tasks_solsi; drop view evaluation_tasks_solsx; drop table evaluation_tasks_sols; -drop index ev_grades_sheets_tid_index; +drop index eva_grades_sheets_tid_index; drop view evaluation_grades_sheetsi; drop view evaluation_grades_sheetsx; drop table evaluation_grades_sheets; -drop index ev_student_evals_tid_index; -drop index ev_student_evals_pid_index; +drop index eva_student_evals_tid_index; +drop index eva_student_evals_pid_index; drop view evaluation_student_evalsi; drop view evaluation_student_evalsx; drop table evaluation_student_evals; @@ -73,5 +60,17 @@ / show errors; +begin +acs_object_type.drop_type('evaluation_grades'); +acs_object_type.drop_type('evaluation_tasks'); +acs_object_type.drop_type('evaluation_tasks_sols'); +acs_object_type.drop_type('evaluation_answers'); +acs_object_type.drop_type('evaluation_grades_sheets'); +acs_object_type.drop_type('evaluation_student_evals'); +acs_object_type.drop_type('evaluation_task_groups'); +end; +/ +show errors; + @ evaluation-package-drop.sql