postgresql7.1
select site_node__url(node_id) as package_url from site_nodes where object_id = (select package_id from cr_folders where folder_id= (select parent_id from cr_items where latest_revision = :object_id))
select acs_sc_impl__new(
'FtsContentProvider', -- impl_contract_name
:content_type, -- impl_name
'edit-this-page' -- impl_owner.name
);
select acs_sc_impl_alias__new(
'FtsContentProvider', -- impl_contract_name
:content_type, -- impl_name
'datasource', -- impl_operation_name
'etp_page_revision__datasource', -- impl_alias
'TCL' -- impl_pl
)
select acs_sc_impl_alias__new(
'FtsContentProvider', -- impl_contract_name
:content_type, -- impl_name
'url', -- impl_operation_name
'etp_page_revision__url', -- impl_alias
'TCL' -- impl_pl
);
select acs_sc_binding__new(
'FtsContentProvider', -- contract_name
:content_type -- impl_name
);