<?xml version="1.0"?>
<SQLCatalogData>
  <property id="sql_catalog_clear_reserved" type="str">z_clear_reserved</property>
  <property id="sql_catalog_full_text_search_keys" type="tuple">
    <item type="str">full_text.SearchableText</item>
  </property>
  <property id="sql_catalog_keyword_search_keys" type="tuple">
    <item type="str">catalog.description</item>
    <item type="str">catalog.title</item>
    <item type="str">description</item>
    <item type="str">title</item>
  </property>
  <property id="sql_catalog_multivalue_keys" type="tuple">
  </property>
  <property id="sql_catalog_object_list" type="tuple">
    <item type="str">z_catalog_delivery_list</item>
    <item type="str">z_catalog_fulltext_list</item>
    <item type="str">z_catalog_item_list</item>
    <item type="str">z_catalog_movement_category_list</item>
    <item type="str">z_catalog_movement_list</item>
    <item type="str">z_catalog_non_movement_category_list</item>
    <item type="str">z_catalog_object_list</item>
    <item type="str">z_catalog_predicate_category_list</item>
    <item type="str">z_catalog_predicate_list</item>
    <item type="str">z_catalog_roles_and_users_list</item>
    <item type="str">z_catalog_stock_list</item>
  </property>
  <property id="sql_catalog_paths" type="str">z_catalog_paths</property>
  <property id="sql_catalog_produce_reserved" type="str">z_produce_reserved_uid_list</property>
  <property id="sql_catalog_related_keys" type="tuple">
    <item type="str">allowedRolesAndUsers | roles_and_users/allowedRolesAndUsers/z_related_security</item>
    <item type="str">base_category_id | category,catalog/id/z_related_base_category_id</item>
    <item type="str">career_skill_id | category,catalog,catalog/id/z_related_career_skill</item>
    <item type="str">career_skill_title | category,catalog,catalog/title/z_related_career_skill</item>
    <item type="str">default_destination_id | category,catalog/id/z_related_default_destination</item>
    <item type="str">default_destination_section_id | category,catalog/id/z_related_default_destination_section</item>
    <item type="str">default_destination_section_title | category,catalog/title/z_related_default_destination_section</item>
    <item type="str">default_destination_title | category,catalog/title/z_related_default_destination</item>
    <item type="str">default_source_id | category,catalog/id/z_related_default_source</item>
    <item type="str">default_source_section_id | category,catalog/id/z_related_default_source_section</item>
    <item type="str">default_source_section_title | category,catalog/title/z_related_default_source_section</item>
    <item type="str">default_source_title | category,catalog/title/z_related_default_source</item>
    <item type="str">deliveryLineType | movement,catalog/portal_type/z_related_uid_or_parent_uid</item>
    <item type="str">destination_id | category,catalog/id/z_related_default_destination</item>
    <item type="str">destination_section_id | category,catalog/id/z_related_default_destination_section</item>
    <item type="str">destination_section_title | category,catalog/title/z_related_default_destination_section</item>
    <item type="str">destination_title | category,catalog/title/z_related_default_destination</item>
    <item type="str">explanation_portal_type | movement,catalog/portal_type/z_related_explanation</item>
    <item type="str">grand_parent_portal_type | catalog,catalog/portal_type/z_related_grand_parent</item>
    <item type="str">grand_parent_simulation_state | catalog,catalog/simulation_state/z_related_grand_parent</item>
    <item type="str">item_node_category_uid | category/category_uid/z_related_node_uid_from_item</item>
    <item type="str">item_resource_category_uid | category/category_uid/z_related_resource_uid_from_item</item>
    <item type="str">item_section_category_uid | category/category_uid/z_related_section_uid_from_item</item>
    <item type="str">parent_specialise_portal_type | category,catalog/portal_type/z_related_parent_specialise</item>
    <item type="str">predicate_uid | predicate/uid/z_related_predicate</item>
    <item type="str">resourceType | movement,catalog/portal_type/z_related_resource</item>
    <item type="str">source_id | category,catalog/id/z_related_default_source</item>
    <item type="str">source_section_id | category,catalog/id/z_related_default_source_section</item>
    <item type="str">source_section_title | category,catalog/title/z_related_default_source_section</item>
    <item type="str">source_title | category,catalog/title/z_related_default_source</item>
    <item type="str">stock_mirror_section_category_uid | category/category_uid/z_related_mirror_section_uid_from_stock</item>
    <item type="str">stock_node_category_uid | category/category_uid/z_related_node_uid_from_stock</item>
    <item type="str">stock_payment_category_uid | category/category_uid/z_related_payment_uid_from_stock</item>
    <item type="str">stock_resource_category_uid | category/category_uid/z_related_resource_uid_from_stock</item>
    <item type="str">stock_section_category_uid | category/category_uid/z_related_section_uid_from_stock</item>
    <item type="str">subordination_title | category,catalog/title/z_related_subordination</item>
    <item type="str">translated_opportunity_state | translation/translated_message/z_related_translated_opportunity_state</item>
    <item type="str">translated_opportunity_state_title | translation/translated_message/z_related_translated_opportunity_state</item>
    <item type="str">translated_portal_type | translation/translated_message/z_related_translated_portal_type</item>
    <item type="str">translated_simulation_state | translation/translated_message/z_related_translated_simulation_state_title</item>
    <item type="str">translated_simulation_state_title | translation/translated_message/z_related_translated_simulation_state</item>
    <item type="str">translated_validation_state | translation/translated_message/z_related_translated_validation_state</item>
    <item type="str">translated_validation_state_title | translation/translated_message/z_related_translated_validation_state</item>
    <item type="str">variationCategory | category/category_uid/z_related_uid</item>
  </property>
  <property id="sql_catalog_request_keys" type="tuple">
  </property>
  <property id="sql_catalog_reserve_uid" type="str">z_reserve_uid</property>
  <property id="sql_catalog_schema" type="str">z_show_columns</property>
  <property id="sql_catalog_tables" type="str">z_show_tables</property>
  <property id="sql_catalog_topic_search_keys" type="tuple">
  </property>
  <property id="sql_catalog_translation_list" type="str">z_catalog_translation_list</property>
  <property id="sql_clear_catalog" type="tuple">
    <item type="str">z0_drop_catalog</item>
    <item type="str">z0_drop_category</item>
    <item type="str">z0_drop_compatibility</item>
    <item type="str">z0_drop_delivery</item>
    <item type="str">z0_drop_fulltext</item>
    <item type="str">z0_drop_item</item>
    <item type="str">z0_drop_movement</item>
    <item type="str">z0_drop_predicate</item>
    <item type="str">z0_drop_predicate_category</item>
    <item type="str">z0_drop_record</item>
    <item type="str">z0_drop_roles_and_users</item>
    <item type="str">z0_drop_stock</item>
    <item type="str">z0_drop_subject</item>
    <item type="str">z0_drop_translation</item>
    <item type="str">z_create_catalog</item>
    <item type="str">z_create_category</item>
    <item type="str">z_create_compatibility</item>
    <item type="str">z_create_delivery</item>
    <item type="str">z_create_fulltext</item>
    <item type="str">z_create_item</item>
    <item type="str">z_create_movement</item>
    <item type="str">z_create_predicate</item>
    <item type="str">z_create_predicate_category</item>
    <item type="str">z_create_record</item>
    <item type="str">z_create_roles_and_users</item>
    <item type="str">z_create_stock</item>
    <item type="str">z_create_subject</item>
    <item type="str">z_create_translation</item>
  </property>
  <property id="sql_count_results" type="str">z_count_results</property>
  <property id="sql_delete_recorded_object_list" type="str">z_delete_recorded_object_list</property>
  <property id="sql_delete_translation_list" type="str">z_delete_translation_list</property>
  <property id="sql_getitem_by_path" type="str">z_getitem_by_path</property>
  <property id="sql_getitem_by_uid" type="str">z_getitem_by_uid</property>
  <property id="sql_read_recorded_object_list" type="str">z_read_recorded_object_list</property>
  <property id="sql_record_object_list" type="str">z_record_object_list</property>
  <property id="sql_search_result_keys" type="tuple">
    <item type="str">catalog.path</item>
    <item type="str">catalog.uid</item>
  </property>
  <property id="sql_search_results" type="str">z_search_results</property>
  <property id="sql_search_tables" type="tuple">
    <item type="str">catalog</item>
    <item type="str">category</item>
    <item type="str">delivery</item>
    <item type="str">full_text</item>
    <item type="str">item</item>
    <item type="str">movement</item>
    <item type="str">predicate</item>
    <item type="str">predicate_category</item>
    <item type="str">roles_and_users</item>
    <item type="str">stock</item>
  </property>
  <property id="sql_uncatalog_object" type="tuple">
    <item type="str">z0_uncatalog_category</item>
    <item type="str">z0_uncatalog_fulltext</item>
    <item type="str">z0_uncatalog_item</item>
    <item type="str">z0_uncatalog_movement</item>
    <item type="str">z0_uncatalog_predicate</item>
    <item type="str">z0_uncatalog_predicate_category</item>
    <item type="str">z0_uncatalog_stock</item>
    <item type="str">z_uncatalog_delivery</item>
    <item type="str">z_uncatalog_object</item>
  </property>
  <property id="sql_unique_values" type="str">z_unique_values</property>
  <property id="title" type="str">ERP5/MySQL</property>
  <filter id="z_catalog_delivery_list" expression="python: isDelivery" />
  <filter id="z_catalog_item_list" expression="python: isMovement" />
  <filter id="z_catalog_movement_category_list" expression="python: isMovement" />
  <filter id="z_catalog_movement_list" expression="python: isMovement" />
  <filter id="z_catalog_non_movement_category_list" expression="python: not isMovement" />
  <filter id="z_catalog_predicate_category_list" expression="python: isPredicate" />
  <filter id="z_catalog_predicate_list" expression="python: isPredicate" />
  <filter id="z_catalog_stock_list" expression="python: isMovement" />
</SQLCatalogData>
