Index: openacs-4/contrib/obsolete-packages/ticket-tracker-lite/sql/oracle/ticket-tracker-lite-drop.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/ticket-tracker-lite/sql/oracle/ticket-tracker-lite-drop.sql,v diff -u -N -r1.1.1.1 -r1.1.1.1.4.1 --- openacs-4/contrib/obsolete-packages/ticket-tracker-lite/sql/oracle/ticket-tracker-lite-drop.sql 20 Apr 2001 20:51:23 -0000 1.1.1.1 +++ openacs-4/contrib/obsolete-packages/ticket-tracker-lite/sql/oracle/ticket-tracker-lite-drop.sql 20 Feb 2003 08:12:18 -0000 1.1.1.1.4.1 @@ -5,6 +5,14 @@ -- --------------------------------------------------- +drop view ttl_v_areas; +drop view ttl_va_areas; +drop view ttl_v_tickets; +drop view ttl_va_tickets; +drop view ttl_va_comments; +drop view ttl_v_comments_latest; +drop view ttl_v_users; + drop table ttl_prefs; drop table ttl_area_assignments; drop table ttl_assignments; @@ -13,6 +21,9 @@ drop table ttl_status; drop table ttl_areas; +drop function ttl_relative_date; +drop function ttl_top_privilege_for_object; + delete from acs_permissions where object_id in (select package_id from apm_packages