-- ezcontentobject
create index ezcontentobject_pub on ezcontentobject( published );
create index ezcontentobject_status on ezcontentobject( status );
create index ezcontentobject_classid on ezcontentobject( contentclass_id );
create index ezcontentobject_currentversion on ezcontentobject( current_version );

-- ezcontentobject_name
create index ezcontentobject_name_lang_id on ezcontentobject_name( language_id );
create index ezcontentobject_name_name on ezcontentobject_name( name );
create index ezcontentobject_name_co_id on ezcontentobject_name( contentobject_id );
create index ezcontentobject_name_cov_id on ezcontentobject_name( content_version );

-- ezcontentobject_version
create index ezcontentobject_version_creator_id on ezcontentobject_version( creator_id );
create index ezcontentobject_version_status on ezcontentobject_version( status );

-- ezpolicy_limitation_value
create index ezpolicy_limitation_value_value on ezpolicy_limitation_value( value );

-- ezinfocollection_attribute
create index ezinfocollection_attribute_co_id on ezinfocollection_attribute( contentobject_id );

-- ezurlalias
create index idx_url_forward on ezurlalias( forward_to_id );
create index ezurlalias_is_wildcard on ezurlalias( is_wildcard );

-- ezkeyword
create index idx_keyword_keyword on ezkeyword ( keyword );

-- ezurl
create index ezurl_url on ezurl( url );

-- ezcontentobject_attribute
create index idx_obj_attr_id on ezcontentobject_attribute( id );
create index idx_cca_ccid on ezcontentclass_attribute( contentclass_id );

-- eznode_assignment
create index eznode_assignment_co_id on eznode_assignment( contentobject_id );
create index eznode_assignment_co_version on eznode_assignment( contentobject_version );
create index eznode_assignment_is_main on eznode_assignment( is_main );

-- ezkeyword_attribute_link
create index ezkeyword_attribute_link_keyid on ezkeyword_attribute_link( keyword_id );