jader
committed
on 09 Jan 04
Fixed bug where resources were reformatted after being approved.
/www/etp-setup-2-oracle.xql (+15 -1)
1 1 <?xml version="1.0"?>
2 2 <queryset>
3 3    <rdbms><type>oracle</type><version>8.1.6</version></rdbms>
4 4
5 5 <fullquery name="create_folder">
6 6 <querytext>
7 7    begin
8 8      :1 := content_folder.new(
9 9               name        => :name,
10 10               label       => :title,
11 11               description => '',
12 12               parent_id   => etp.get_folder_id(:parent_package_id)
13 13            );
14 14    end;
15 15 </querytext>
16 16 </fullquery>
17 17
  18 <fullquery name="register_types">
  19     <querytext>
  20       select
  21       content_folder.register_content_type(:folder_id,'content_revision','t')
  22     </querytext>
  23 </fullquery>
  24
  25 <fullquery name="register_folders">
  26     <querytext>
  27       select
  28       content_folder.register_content_type(:folder_id,'content_folder','f')
  29     </querytext>
  30 </fullquery>
  31
18 32 <fullquery name="get_section_name">
19 33 <querytext>
20 34    select acs_object.name(:package_id) as title from dual
21 35 </querytext>
22 36 </fullquery>
23 37
24 38 </queryset>