Index: openacs-4/contrib/obsolete-packages/ticket-tracker-lite/ticket-tracker-lite.info
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/ticket-tracker-lite/ticket-tracker-lite.info,v
diff -u -r1.3 -r1.4
--- openacs-4/contrib/obsolete-packages/ticket-tracker-lite/ticket-tracker-lite.info	30 Aug 2001 05:06:04 -0000	1.3
+++ openacs-4/contrib/obsolete-packages/ticket-tracker-lite/ticket-tracker-lite.info	26 Feb 2002 15:51:17 -0000	1.4
@@ -1,5 +1,5 @@
 <?xml version="1.0"?>
-<!-- Generated by the ACS Package Manager -->
+<!-- Generated by the OpenACS Package Manager -->
 
 <package key="ticket-tracker-lite" url="http://www.arsdigita.com/acs-repository/apm/packages/ticket-tracker-lite" type="apm_application">
     <package-name>Ticket Tracker Lite</package-name>
@@ -50,6 +50,8 @@
             <file type="content_page" path="www/admin/deleted.adp"/>
             <file type="content_page" path="www/admin/deleted.tcl"/>
             <file type="query_file" path="www/admin/deleted.xql"/>
+            <file type="query_file" db_type="oracle" path="www/admin/index-oracle.xql"/>
+            <file type="query_file" db_type="postgresql" path="www/admin/index-postgresql.xql"/>
             <file type="content_page" path="www/admin/index.adp"/>
             <file type="content_page" path="www/admin/index.tcl"/>
             <file type="query_file" path="www/admin/index.xql"/>
Index: openacs-4/contrib/obsolete-packages/ticket-tracker-lite/www/index-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/ticket-tracker-lite/www/index-postgresql.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/contrib/obsolete-packages/ticket-tracker-lite/www/index-postgresql.xql	28 May 2001 20:43:16 -0000	1.1
+++ openacs-4/contrib/obsolete-packages/ticket-tracker-lite/www/index-postgresql.xql	26 Feb 2002 15:51:17 -0000	1.2
@@ -54,7 +54,7 @@
 <partialquery name="order_area">
 <querytext>
 
-order by lower(area_name) asc, priority asc, coalesce(c.creation_date, t.last_modified) desc
+order by lower(a.name) asc, priority asc, coalesce(c.creation_date, t.last_modified) desc
 
 </querytext>
 </partialquery>
Index: openacs-4/contrib/obsolete-packages/ticket-tracker-lite/www/index.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/ticket-tracker-lite/www/index.tcl,v
diff -u -r1.2 -r1.3
--- openacs-4/contrib/obsolete-packages/ticket-tracker-lite/www/index.tcl	28 May 2001 20:43:16 -0000	1.2
+++ openacs-4/contrib/obsolete-packages/ticket-tracker-lite/www/index.tcl	26 Feb 2002 15:51:17 -0000	1.3
@@ -75,7 +75,7 @@
         set order_clause "[db_map order_activity]"
     }
     name {
-        set order_clause "order by upper(ticket_name)"
+        set order_clause "order by upper(t.name)"
     }
     area {
         set order_clause "[db_map order_area]"
Index: openacs-4/contrib/obsolete-packages/ticket-tracker-lite/www/ticket-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/ticket-tracker-lite/www/ticket-postgresql.xql,v
diff -u -r1.2 -r1.3
--- openacs-4/contrib/obsolete-packages/ticket-tracker-lite/www/ticket-postgresql.xql	8 Feb 2002 07:27:34 -0000	1.2
+++ openacs-4/contrib/obsolete-packages/ticket-tracker-lite/www/ticket-postgresql.xql	26 Feb 2002 15:51:17 -0000	1.3
@@ -33,7 +33,7 @@
 
 select * from (select p.first_names || ' ' || p.last_name as full_name,
                       t.user_id,
-                      case when a.user_id = null then 0 else 1 end 
+                      case when a.user_id is null then 0 else 1 end 
                         as already_assigned_p
                  from ttl_v_users t left join (select user_id 
                                         from ttl_assignments