Index: openacs-4/packages/download/tcl/download-procs.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/download/tcl/download-procs.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/download/tcl/download-procs.xql	10 May 2001 20:51:30 -0000	1.1
+++ openacs-4/packages/download/tcl/download-procs.xql	22 May 2001 04:18:16 -0000	1.2
@@ -1,115 +1,140 @@
 <?xml version="1.0"?>
 <queryset>
 
-<fullquery name="download_repository_info.repository_info">      
-      <querytext>
-      
-        select repository_id, title, description, help_text from download_repository_obj where parent_id = :package_id
-    
-      </querytext>
+
+<fullquery name="download_repository_info.repository_info">
+<querytext>
+
+select repository_id, title, description, help_text 
+from download_repository_obj 
+where parent_id = :package_id
+
+</querytext>
 </fullquery>
 
  
-<fullquery name="download_repository_info.type_info">      
-      <querytext>
-      
-                select count(*) from download_archive_types where repository_id = :repository_id
+
+<fullquery name="download_repository_info.type_info">
+<querytext>
+
+select count(*) from download_archive_types 
+where repository_id = :repository_id
             
-      </querytext>
+</querytext>
 </fullquery>
 
  
-<fullquery name="download_metadata_widget.download_metadata_choices">      
-      <querytext>
-      select choice_id, label
-            from download_metadata_choices
-            where metadata_id = :metadata_id
-            order by sort_order
-      </querytext>
+
+<fullquery name="download_metadata_widget.download_metadata_choices">
+<querytext>
+
+select choice_id, label
+from download_metadata_choices
+where metadata_id = :metadata_id
+order by sort_order
+
+</querytext>
 </fullquery>
 
  
-<fullquery name="download_file_downloader.download_count">      
-      <querytext>
-      select count(*) from download_downloads where download_id = :download_id
-      </querytext>
+
+<fullquery name="download_file_downloader.download_count">
+<querytext>
+
+select count(*) from download_downloads 
+where download_id = :download_id
+
+</querytext>
 </fullquery>
 
+
  
-<fullquery name="download_file_downloader.file_type">      
-      <querytext>
+<fullquery name="download_file_downloader.file_type">
+<querytext>
       
-    select mime_type 
-    from   cr_revisions 
-    where  revision_id = :revision_id
-      </querytext>
+select mime_type 
+from   cr_revisions 
+where  revision_id = :revision_id
+
+</querytext>
 </fullquery>
 
+
  
-<fullquery name="download_maybe_create_new_mime_type.mime_type_exists">      
-      <querytext>
+<fullquery name="download_maybe_create_new_mime_type.mime_type_exists">
+<querytext>
       
-    select count(*) from cr_mime_types
-    where  mime_type = :mime_type
-      </querytext>
+select count(*) from cr_mime_types
+where  mime_type = :mime_type
+
+</querytext>
 </fullquery>
 
+
  
 <fullquery name="download_maybe_create_new_mime_type.new_mime_type">      
-      <querytext>
+<querytext>
       
-	insert into cr_mime_types
-	(mime_type, file_extension)
-	values
-	(:mime_type, :extension)
-      </querytext>
+insert into cr_mime_types
+(mime_type, file_extension)
+values
+(:mime_type, :extension)
+
+</querytext>
 </fullquery>
 
+
  
 <fullquery name="download_validate_metadata.metadata">      
-      <querytext>
+<querytext>
       
-        select 
-        dam.metadata_id,
-        dam.pretty_name,
-        dam.data_type,
-        dam.required_p
-        from download_archive_metadata dam
-        where dam.repository_id = :repository_id and
-        dam.computed_p = 'f' and
-        (dam.archive_type_id = :archive_type_id or
-         dam.archive_type_id is null)
-        order by sort_key
+select 
+  dam.metadata_id,
+  dam.pretty_name,
+  dam.data_type,
+  dam.required_p
+from download_archive_metadata dam
+where dam.repository_id = :repository_id and
+      dam.computed_p = 'f' and
+      (dam.archive_type_id = :archive_type_id or
+       dam.archive_type_id is null)
+order by sort_key
     
-      </querytext>
+</querytext>
 </fullquery>
 
+
  
 <fullquery name="download_insert_metadata.survsimp_question_info_list">      
-      <querytext>
+<querytext>
       
-            select 
-            dam.metadata_id,
-            dam.data_type
-            from download_archive_metadata dam
-            where dam.repository_id = :repository_id and
-               dam.computed_p = 'f' and
-               (dam.archive_type_id = :archive_type_id or
-                dam.archive_type_id is null)
-            order by sort_key
+select 
+  dam.metadata_id,
+  dam.data_type
+from download_archive_metadata dam
+where dam.repository_id = :repository_id and
+      dam.computed_p = 'f' and
+      (dam.archive_type_id = :archive_type_id or
+       dam.archive_type_id is null)
+order by sort_key
     
-      </querytext>
+</querytext>
 </fullquery>
 
  
+
 <fullquery name="download_insert_metadata.metadata_inserts">      
-      <querytext>
+<querytext>
       
-         insert into download_revision_data(revision_id, metadata_id, $answer_column)
-         values ( :revision_id, :metadata_id, :response )
+insert into download_revision_data
+(revision_id, metadata_id, $answer_column)
+values 
+( :revision_id, :metadata_id, :response )
         
-      </querytext>
+</querytext>
 </fullquery>
 
+
  
 </queryset>
+