Index: openacs-4/contrib/obsolete-packages/ticket-tracker-lite/sql/postgresql/ticket-tracker-lite-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/ticket-tracker-lite/sql/postgresql/ticket-tracker-lite-create.sql,v
diff -u -r1.1 -r1.2
--- openacs-4/contrib/obsolete-packages/ticket-tracker-lite/sql/postgresql/ticket-tracker-lite-create.sql	28 May 2001 20:41:57 -0000	1.1
+++ openacs-4/contrib/obsolete-packages/ticket-tracker-lite/sql/postgresql/ticket-tracker-lite-create.sql	13 Aug 2001 21:32:05 -0000	1.2
@@ -31,26 +31,6 @@
   null
 );
 
---begin
---
---    acs_object_type.create_type (
---       object_type => 'ticket_tracker_lite_area',
---       pretty_name => 'Ticket Tracker Lite Feature Area',
---       pretty_plural => 'Ticket Tracker Lite Feature Area',
---       table_name => 'ttl_areas',
---       id_column => 'area_id'
---    );
---
---    acs_object_type.create_type (
---       object_type => 'ticket_tracker_lite_ticket',
---       pretty_name => 'Ticket Tracker Lite Ticket',
---       pretty_plural => 'Ticket Tracker Lite Tickets',
---       table_name => 'ttl_tickets',
---       id_column => 'ticket_id'
---    );
---end;
---/
-
 create table ttl_areas (
   area_id           integer 
                     constraint ttl_areas_object_fk
Index: openacs-4/contrib/obsolete-packages/ticket-tracker-lite/sql/postgresql/views-and-plsql.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/ticket-tracker-lite/sql/postgresql/views-and-plsql.sql,v
diff -u -r1.4 -r1.5
--- openacs-4/contrib/obsolete-packages/ticket-tracker-lite/sql/postgresql/views-and-plsql.sql	9 Jul 2001 15:44:25 -0000	1.4
+++ openacs-4/contrib/obsolete-packages/ticket-tracker-lite/sql/postgresql/views-and-plsql.sql	13 Aug 2001 21:32:05 -0000	1.5
@@ -62,9 +62,9 @@
   relative_date     alias for $1;
 begin
   if date_trunc(''day'', relative_date) = date_trunc(''day'', current_timestamp) then
-      return to_char(relative_date, ''fmhh:fmmi am'');
+      return to_char(relative_date, ''fmhh:mi am'');
   else 
-      return to_char(relative_date, ''month fmdd, yyyy'');
+      return to_char(relative_date, ''Month fmdd, yyyy'');
   end if;
 end;' language 'plpgsql';
 
@@ -81,7 +81,6 @@
   v_admin_p          integer;
 begin
     select count(*) into v_admin_p
-    from dual
     where acs_permission__permission_p(p_object_id, p_user_id, ''admin'') = ''t'';
 
     if v_admin_p = 1 then