oracle8.1.6
begin
acs_object_type.create_type (
:content_type,
:pretty_name,
:pretty_plural,
'content_revision',
:content_type,
:content_type,
null,
'f',
null,
null
);
end;
begin
:1 := acs_attribute.create_attribute (
:content_type,
:a_name,
:a_datatype,
:a_pretty_name,
:a_pretty_plural,
null,
null,
:a_default,
1,
1,
null,
'generic',
'f'
);
end;
begin
etp_create_page(
:package_id,
:name,
:title,
:content_type
);
end;
select object_id as package_id
from site_nodes
where node_id = site_node.node_id(:url_stub, null)
select 1 from cr_items
where parent_id = etp.get_folder_id(:package_id)
and name = :name
select i.item_id, i.name, r.revision_id, r.title,
r.description, r.publish_date, r.content $extended_attributes
from cr_items i, cr_revisions r
where i.parent_id = etp.get_folder_id(:package_id)
and i.name = :name
and i.item_id = r.item_id
and r.revision_id = i.live_revision
select i.item_id, i.name, r.revision_id, r.title,
r.description, r.publish_date, r.content $extended_attributes
from cr_items i, cr_revisions r
where i.parent_id = etp.get_folder_id(:package_id)
and i.name = :name
and i.item_id = r.item_id
and r.revision_id = :revision_id
select max(revision_id) as revision_id
from cr_revisions r, cr_items i
where i.parent_id = etp.get_folder_id(:package_id)
and i.name = :name
and i.item_id = r.item_id
select live_revision as revision_id
from cr_items i
where i.parent_id = etp.get_folder_id(:package_id)
and i.name = :name
select * from (
select $columns
from cr_items i
left join
cr_revisions r
on (i.live_revision = r.revision_id)
where i.parent_id = etp.get_folder_id(:package_id)
and i.name != 'index'
) as attributes
where $extra_where_clauses
order by $orderby
$limit_clause
select child.name, child.node_id, child.object_id as package_id,
etp.package_title(child.object_id) as title,
etp.package_description(child.object_id) as description
from site_nodes parent, site_nodes child, apm_packages p
where parent.object_id = :package_id
and child.parent_id = parent.node_id
and child.object_id = p.package_id
and p.package_key = 'edit-this-page'