Index: openacs-4/packages/download/www/admin/repository-metadata.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/download/www/admin/repository-metadata.xql,v
diff -u -N -r1.2 -r1.3
--- openacs-4/packages/download/www/admin/repository-metadata.xql	22 May 2001 04:17:45 -0000	1.2
+++ openacs-4/packages/download/www/admin/repository-metadata.xql	23 May 2001 01:00:43 -0000	1.3
@@ -2,75 +2,84 @@
 <queryset>
 
 <fullquery name="archiv_types">      
-      <querytext>
+<querytext>
       
-    select pretty_name, archive_type_id from download_archive_types where repository_id = $repository_id
-      </querytext>
+select pretty_name, archive_type_id 
+from download_archive_types 
+where repository_id = $repository_id
+
+</querytext>
 </fullquery>
 
+
  
 <fullquery name="metadata_insert">      
-      <querytext>
+<querytext>
       
-            insert into download_archive_metadata (
-              metadata_id,
-              repository_id, 
-              archive_type_id,
-              sort_key,
-              pretty_name,
-              data_type,
-              required_p,
-              linked_p,
-              mainpage_p,
-              computed_p)
-            values (
-              :metadata_id,
-              :repository_id, 
-              :archive_type_id,
-              :sort_key,
-              :pretty_name,
-              :data_type,
-              :required_p,
-              :linked_p,
-              :mainpage_p,
-              :computed_p)
+insert into download_archive_metadata (
+    metadata_id,
+    repository_id, 
+    archive_type_id,
+    sort_key,
+    pretty_name,
+    data_type,
+    required_p,
+    linked_p,
+    mainpage_p,
+    computed_p)
+values (
+    :metadata_id,
+    :repository_id, 
+    :archive_type_id,
+    :sort_key,
+    :pretty_name,
+    :data_type,
+    :required_p,
+    :linked_p,
+    :mainpage_p,
+    :computed_p)
         
-      </querytext>
+</querytext>
 </fullquery>
 
+
  
 <fullquery name="choice_insert">      
-      <querytext>
+<querytext>
       
-                    insert into download_metadata_choices (choice_id, metadata_id, label, sort_order)
-                    values (download_md_choice_id_sequence.nextval, :metadata_id, :choice, :count)
+insert into download_metadata_choices 
+(choice_id, metadata_id, label, sort_order)
+values 
+(download_md_choice_id_sequence.nextval, :metadata_id, :choice, :count)
                 
-      </querytext>
+</querytext>
 </fullquery>
 
+
  
 <fullquery name="metadata_select">      
-      <querytext>
+<querytext>
 
-    select 
-      dam.metadata_id,
-      dam.repository_id,
-      dam.archive_type_id,
-      coalesce(dat.pretty_name, 'All') as archive_name,
-      dam.sort_key,
-      dam.pretty_name,
-      dam.data_type,
-      dam.required_p,      
-      dam.linked_p,        
-      dam.mainpage_p,
-      dam.computed_p      
-    from download_archive_metadata dam left join download_archive_types dat
-			using archive_type_id
-         where dam.repository_id = :repository_id 
-    order by archive_type_id, sort_key
+select 
+  dam.metadata_id,
+  dam.repository_id,
+  dam.archive_type_id,
+  coalesce(dat.pretty_name, 'All') as archive_name,
+  dam.sort_key,
+  dam.pretty_name,
+  dam.data_type,
+  dam.required_p,      
+  dam.linked_p,        
+  dam.mainpage_p,
+  dam.computed_p      
+from download_archive_metadata dam left join download_archive_types dat
+  using (archive_type_id)
+where dam.repository_id = :repository_id 
+order by archive_type_id, sort_key
 
-      </querytext>
+</querytext>
 </fullquery>
 
+
  
 </queryset>