select ca_attributes__create_attribute ( :content_type::varchar, :attribute_name::varchar, :datatype::varchar, :pretty_name::varchar, :pretty_plural::varchar, :sort_order::int4, :default_value::varchar, 'type_specific'::varchar, 'cr_ca_ads'::varchar, :column_spec::varchar, :package_id::int4 ) as attribute_id select ca_attributes__register_widget ( :attribute_id, :widget, :label, :keyword_id, :html_options, :extra_options, :select_options, :validate, :optional_p, :enabled_p ) SELECT pg_catalog.format_type(a.atttypid, a.atttypmod) FROM pg_catalog.pg_attribute a, ( SELECT c.oid FROM pg_catalog.pg_class c LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace WHERE pg_catalog.pg_table_is_visible(c.oid) AND c.relname ~ '^cr_ca_ads$' ) b WHERE a.attrelid = b.oid AND a.attname = :attribute_name AND NOT a.attisdropped select repeat(:indent_pattern, (tree_level(subtree.tree_sortkey) - 2) * :indent_factor::integer) || subtree.heading AS heading, subtree.keyword_id from cr_keywords parent, cr_keywords subtree where subtree.tree_sortkey between parent.tree_sortkey and tree_right(parent.tree_sortkey) and parent.parent_id = :main_category_id