Products.ERP5Type.Document.BusinessTemplate
BusinessTemplate
-
_Modify_portal_content_Permission
Manager
-
__ac_local_roles__
-
alex
Owner
-
_action_item
AAAAAAAAAAI=
-
_catalog_method_item
AAAAAAAAAAM=
-
_catalog_related_key_item
AAAAAAAAAAQ=
-
_catalog_result_key_item
AAAAAAAAAAU=
-
_catalog_result_table_item
AAAAAAAAAAY=
-
_category_item
AAAAAAAAAAc=
-
_count
AAAAAAAAAAg=
-
_document_item
AAAAAAAAAAk=
-
_extension_item
AAAAAAAAAAo=
-
_message_translation_item
AAAAAAAAAAs=
-
_module_item
AAAAAAAAAAw=
-
_mt_index
AAAAAAAAAA0=
-
_owner
nexedi
acl_users
alex
-
_path_item
AAAAAAAAAA4=
-
_portal_type_item
AAAAAAAAAA8=
-
_product_item
AAAAAAAAABA=
-
_property_sheet_item
AAAAAAAAABE=
-
_role_item
AAAAAAAAABI=
-
_site_property_item
AAAAAAAAABM=
-
_skin_item
AAAAAAAAABQ=
-
_test_item
AAAAAAAAABU=
-
_tree
AAAAAAAAABY=
-
_workflow_item
AAAAAAAAABc=
-
change_log
2005-04-19 Yoshinor Okuji\n
\n
* Update z_update_delivery.\n
\n
* Add predicate, predicate_category and delivery.
-
description
This Business Template holds every Catalog Methods and Properties used by ERP5
-
id
erp5_catalog
-
portal_type
Business Template
-
template_action_path
-
template_base_category
-
template_catalog_method_id
erp5_mysql/z_related_node_uid_from_stock
erp5_mysql/z_create_catalog
erp5_mysql/z0_drop_catalog
erp5_mysql/AppliedRule_insertMovement
erp5_mysql/AppliedRule_deleteCatalog
erp5_mysql/z_catalog_item
erp5_mysql/z_search_folder
erp5_mysql/AppliedRule_createMessageTable
erp5_mysql/z0_uncatalog_movement
erp5_mysql/z0_drop_movement
erp5_mysql/z_catalog_roles_and_users
erp5_mysql/AppliedRule_deleteCategory
erp5_mysql/z_create_predicate
erp5_mysql/z_search_results
erp5_mysql/z0_drop_delivery
erp5_mysql/z_related_mirror_section_uid_from_stock
erp5_mysql/z_related_security
erp5_mysql/z_create_category
erp5_mysql/z0_drop_item
erp5_mysql/z0_drop_predicate
erp5_mysql/z0_uncatalog_compatibility
erp5_mysql/z_uncatalog_object
erp5_mysql/z_catalog_stock
erp5_mysql/z0_uncatalog_stock
erp5_mysql/z0_drop_roles_and_users
erp5_mysql/z_related_predicate
erp5_mysql/z_create_roles_and_users
erp5_mysql/z_related_section_uid_from_stock
erp5_mysql/z_catalog_item_list
erp5_mysql/AppliedRule_deleteMovement
erp5_mysql/AppliedRule_insertCatalog
erp5_mysql/z0_drop_predicate_category
erp5_mysql/AppliedRule_insertStock
erp5_mysql/z_create_delivery
erp5_mysql/z_catalog_roles_and_users_list
erp5_mysql/z_related_payment_uid_from_stock
erp5_mysql/z_count_results
erp5_mysql/AppliedRule_insertCategory
erp5_mysql/z0_uncatalog_category
erp5_mysql/z_update_delivery
erp5_mysql/AppliedRule_deleteStock
erp5_mysql/z0_drop_subject
erp5_mysql/z_create_compatibility
erp5_mysql/z_catalog_category
erp5_mysql/z_show_category_columns
erp5_mysql/z0_uncatalog_predicate_category
erp5_mysql/z0_uncatalog_roles_and_users
erp5_mysql/z_catalog_compatibility
erp5_mysql/z_catalog_predicate_category
erp5_mysql/z0_drop_stock
erp5_mysql/z0_drop_category
erp5_mysql/z_catalog_movement
erp5_mysql/z_update_object
erp5_mysql/z_create_item
erp5_mysql/z_catalog_category_list
erp5_mysql/z_uncatalog_delivery
erp5_mysql/z_create_stock
erp5_mysql/z_catalog_predicate
erp5_mysql/z_catalog_object_list
erp5_mysql/z_catalog_compatibility_list
erp5_mysql/z_related_resource_uid_from_stock
erp5_mysql/z_catalog_subject_list
erp5_mysql/z_related_resource
erp5_mysql/z_create_movement
erp5_mysql/z0_uncatalog_subject
erp5_mysql/z_related_uid
erp5_mysql/z_catalog_stock_list
erp5_mysql/z_create_subject
erp5_mysql/z0_uncatalog_predicate
erp5_mysql/z0_drop_compatibility
erp5_mysql/z0_uncatalog_item
erp5_mysql/z_catalog_movement_list
erp5_mysql/z_create_predicate_category
erp5_mysql/z_catalog_subject
-
template_catalog_related_key
allowedRolesAndUsers | roles_and_users/allowedRolesAndUsers/z_related_security
predicate_uid | predicate/uid/z_related_predicate
stock_paymentCategory | category/category_uid/z_related_payment_uid_from_stock
stock_mirrorSectionCategory | category/category_uid/z_related_mirror_section_uid_from_stock
stock_sectionCategory | category/category_uid/z_related_section_uid_from_stock
stock_nodeCategory | category/category_uid/z_related_node_uid_from_stock
resourceType | movement,catalog/portal_type/z_related_resource
variationCategory | category/category_uid/z_related_uid
stock_resourceCategory | category/category_uid/z_related_resource_uid_from_stock
-
template_catalog_result_key
catalog.path
catalog.uid
-
template_catalog_result_table
catalog
category
predicate
roles_and_users
delivery
predicate_category
stock
compatibility
movement
-
template_document_id
-
template_message_translation
-
template_module_id
-
template_path
-
template_portal_type_id
-
template_product_id
-
template_property_sheet_id
-
template_role
-
template_site_property_id
-
template_skin_id
-
template_test_id
-
template_workflow_id
-
title
erp5_catalog
-
uid
1991115917
-
version
0.1
-
workflow_history
AAAAAAAAABg=
Products.ERP5Type.Document.BusinessTemplate
ActionTemplateItem
-
_archive
AAAAAAAAABk=
Products.ERP5Type.Document.BusinessTemplate
CatalogMethodTemplateItem
-
_archive
AAAAAAAAABo=
-
_filter_expression_archive
AAAAAAAAABs=
-
_filter_expression_instance_archive
AAAAAAAAABw=
-
_filter_type_archive
AAAAAAAAAB0=
-
_is_catalog_list_method_archive
AAAAAAAAAB4=
-
_is_catalog_method_archive
AAAAAAAAAB8=
-
_is_clear_method_archive
AAAAAAAAACA=
-
_is_filtered_archive
AAAAAAAAACE=
-
_is_uncatalog_method_archive
AAAAAAAAACI=
-
_is_update_method_archive
AAAAAAAAACM=
-
tool_id
portal_catalog
Products.ERP5Type.Document.BusinessTemplate
CatalogRelatedKeyTemplateItem
-
_archive
AAAAAAAAACQ=
Products.ERP5Type.Document.BusinessTemplate
CatalogResultKeyTemplateItem
-
_archive
AAAAAAAAACU=
Products.ERP5Type.Document.BusinessTemplate
CatalogResultTableTemplateItem
-
_archive
AAAAAAAAACY=
Products.ERP5Type.Document.BusinessTemplate
CategoryTemplateItem
-
_archive
AAAAAAAAACc=
-
_light_archive
AAAAAAAAACg=
-
tool_id
BTrees.Length
Length
0
Products.ERP5Type.Document.BusinessTemplate
DocumentTemplateItem
-
_archive
AAAAAAAAACk=
Products.ERP5Type.Document.BusinessTemplate
ExtensionTemplateItem
-
_archive
AAAAAAAAACo=
Products.ERP5Type.Document.BusinessTemplate
MessageTranslationTemplateItem
-
_archive
AAAAAAAAACs=
Products.ERP5Type.Document.BusinessTemplate
ModuleTemplateItem
-
_archive
AAAAAAAAACw=
BTrees.OOBTree
OOBTree
Products.ERP5Type.Document.BusinessTemplate
PathTemplateItem
-
_archive
AAAAAAAAAC0=
-
_path_archive
AAAAAAAAAC4=
-
tool_id
Products.ERP5Type.Document.BusinessTemplate
PortalTypeTemplateItem
-
_archive
AAAAAAAAAC8=
-
_workflow_chain_archive
AAAAAAAAADA=
-
tool_id
portal_types
Products.ERP5Type.Document.BusinessTemplate
ProductTemplateItem
-
_archive
AAAAAAAAADE=
Products.ERP5Type.Document.BusinessTemplate
PropertySheetTemplateItem
-
_archive
AAAAAAAAADI=
Products.ERP5Type.Document.BusinessTemplate
RoleTemplateItem
-
_archive
AAAAAAAAADM=
Products.ERP5Type.Document.BusinessTemplate
SitePropertyTemplateItem
-
_archive
AAAAAAAAADQ=
Products.ERP5Type.Document.BusinessTemplate
SkinTemplateItem
-
_archive
AAAAAAAAADU=
-
tool_id
portal_skins
Products.ERP5Type.Document.BusinessTemplate
TestTemplateItem
-
_archive
AAAAAAAAADY=
BTrees.OOBTree
OOBTree
Products.ERP5Type.Document.BusinessTemplate
WorkflowTemplateItem
-
_archive
AAAAAAAAADc=
-
tool_id
portal_workflow
Persistence
PersistentMapping
-
_container
-
business_template_building_workflow
-
building_action
-
building_actor
alex
-
building_comment
-
building_state
draft
-
building_time
-
building_action
edit
-
building_actor
alex
-
building_comment
-
building_state
modified
-
building_time
-
building_action
edit
-
building_actor
alex
-
building_comment
-
building_state
modified
-
building_time
-
building_action
edit
-
building_actor
alex
-
building_comment
-
building_state
modified
-
building_time
-
building_action
build_action
-
building_actor
alex
-
building_comment
-
building_state
modified
-
building_time
-
building_action
build
-
building_actor
alex
-
building_comment
-
building_state
built
-
building_time
-
building_action
edit
-
building_actor
alex
-
building_comment
-
building_state
modified
-
building_time
-
building_action
edit
-
building_actor
alex
-
building_comment
-
building_state
modified
-
building_time
-
building_action
edit
-
building_actor
alex
-
building_comment
-
building_state
modified
-
building_time
-
building_action
edit
-
building_actor
alex
-
building_comment
-
building_state
modified
-
building_time
-
building_action
build_action
-
building_actor
alex
-
building_comment
-
building_state
modified
-
building_time
-
building_action
build
-
building_actor
alex
-
building_comment
-
building_state
built
-
building_time
-
building_action
rebuild_action
-
building_actor
alex
-
building_comment
-
building_state
built
-
building_time
-
building_action
clean
-
building_actor
alex
-
building_comment
-
building_state
modified
-
building_time
-
building_action
build
-
building_actor
alex
-
building_comment
-
building_state
built
-
building_time
-
building_action
edit
-
building_actor
yo
-
building_comment
-
building_state
modified
-
building_time
-
building_action
build_action
-
building_actor
yo
-
building_comment
-
building_state
modified
-
building_time
-
building_action
build
-
building_actor
yo
-
building_comment
-
building_state
built
-
building_time
-
building_action
build
-
building_actor
yo
-
building_comment
-
building_state
built
-
building_time
-
building_action
edit
-
building_actor
yo
-
building_comment
-
building_state
modified
-
building_time
-
building_action
edit
-
building_actor
yo
-
building_comment
-
building_state
modified
-
building_time
-
building_action
edit
-
building_actor
yo
-
building_comment
-
building_state
modified
-
building_time
-
building_action
build_action
-
building_actor
yo
-
building_comment
-
building_state
modified
-
building_time
-
building_action
build
-
building_actor
yo
-
building_comment
-
building_state
built
-
building_time
-
building_action
build
-
building_actor
yo
-
building_comment
-
building_state
built
-
building_time
-
business_template_installation_workflow
Persistence
PersistentMapping
-
_container
Persistence
PersistentMapping
-
_container
-
portal_catalog/erp5_mysql/AppliedRule_createMessageTable
AAAAAAAAADg=
-
portal_catalog/erp5_mysql/AppliedRule_deleteCatalog
AAAAAAAAADk=
-
portal_catalog/erp5_mysql/AppliedRule_deleteCategory
AAAAAAAAADo=
-
portal_catalog/erp5_mysql/AppliedRule_deleteMovement
AAAAAAAAADs=
-
portal_catalog/erp5_mysql/AppliedRule_deleteStock
AAAAAAAAADw=
-
portal_catalog/erp5_mysql/AppliedRule_insertCatalog
AAAAAAAAAD0=
-
portal_catalog/erp5_mysql/AppliedRule_insertCategory
AAAAAAAAAD4=
-
portal_catalog/erp5_mysql/AppliedRule_insertMovement
AAAAAAAAAD8=
-
portal_catalog/erp5_mysql/AppliedRule_insertStock
AAAAAAAAAEA=
-
portal_catalog/erp5_mysql/z0_drop_catalog
AAAAAAAAAEE=
-
portal_catalog/erp5_mysql/z0_drop_category
AAAAAAAAAEI=
-
portal_catalog/erp5_mysql/z0_drop_compatibility
AAAAAAAAAEM=
-
portal_catalog/erp5_mysql/z0_drop_delivery
AAAAAAAAAEQ=
-
portal_catalog/erp5_mysql/z0_drop_item
AAAAAAAAAEU=
-
portal_catalog/erp5_mysql/z0_drop_movement
AAAAAAAAAEY=
-
portal_catalog/erp5_mysql/z0_drop_predicate
AAAAAAAAAEc=
-
portal_catalog/erp5_mysql/z0_drop_predicate_category
AAAAAAAAAEg=
-
portal_catalog/erp5_mysql/z0_drop_roles_and_users
AAAAAAAAAEk=
-
portal_catalog/erp5_mysql/z0_drop_stock
AAAAAAAAAEo=
-
portal_catalog/erp5_mysql/z0_drop_subject
AAAAAAAAAEs=
-
portal_catalog/erp5_mysql/z0_uncatalog_category
AAAAAAAAAEw=
-
portal_catalog/erp5_mysql/z0_uncatalog_compatibility
AAAAAAAAAE0=
-
portal_catalog/erp5_mysql/z0_uncatalog_item
AAAAAAAAAE4=
-
portal_catalog/erp5_mysql/z0_uncatalog_movement
AAAAAAAAAE8=
-
portal_catalog/erp5_mysql/z0_uncatalog_predicate
AAAAAAAAAFA=
-
portal_catalog/erp5_mysql/z0_uncatalog_predicate_category
AAAAAAAAAFE=
-
portal_catalog/erp5_mysql/z0_uncatalog_roles_and_users
AAAAAAAAAFI=
-
portal_catalog/erp5_mysql/z0_uncatalog_stock
AAAAAAAAAFM=
-
portal_catalog/erp5_mysql/z0_uncatalog_subject
AAAAAAAAAFQ=
-
portal_catalog/erp5_mysql/z_catalog_category
AAAAAAAAAFU=
-
portal_catalog/erp5_mysql/z_catalog_category_list
AAAAAAAAAFY=
-
portal_catalog/erp5_mysql/z_catalog_compatibility
AAAAAAAAAFc=
-
portal_catalog/erp5_mysql/z_catalog_compatibility_list
AAAAAAAAAFg=
-
portal_catalog/erp5_mysql/z_catalog_item
AAAAAAAAAFk=
-
portal_catalog/erp5_mysql/z_catalog_item_list
AAAAAAAAAFo=
-
portal_catalog/erp5_mysql/z_catalog_movement
AAAAAAAAAFs=
-
portal_catalog/erp5_mysql/z_catalog_movement_list
AAAAAAAAAFw=
-
portal_catalog/erp5_mysql/z_catalog_object_list
AAAAAAAAAF0=
-
portal_catalog/erp5_mysql/z_catalog_predicate
AAAAAAAAAF4=
-
portal_catalog/erp5_mysql/z_catalog_predicate_category
AAAAAAAAAF8=
-
portal_catalog/erp5_mysql/z_catalog_roles_and_users
AAAAAAAAAGA=
-
portal_catalog/erp5_mysql/z_catalog_roles_and_users_list
AAAAAAAAAGE=
-
portal_catalog/erp5_mysql/z_catalog_stock
AAAAAAAAAGI=
-
portal_catalog/erp5_mysql/z_catalog_stock_list
AAAAAAAAAGM=
-
portal_catalog/erp5_mysql/z_catalog_subject
AAAAAAAAAGQ=
-
portal_catalog/erp5_mysql/z_catalog_subject_list
AAAAAAAAAGU=
-
portal_catalog/erp5_mysql/z_count_results
AAAAAAAAAGY=
-
portal_catalog/erp5_mysql/z_create_catalog
AAAAAAAAAGc=
-
portal_catalog/erp5_mysql/z_create_category
AAAAAAAAAGg=
-
portal_catalog/erp5_mysql/z_create_compatibility
AAAAAAAAAGk=
-
portal_catalog/erp5_mysql/z_create_delivery
AAAAAAAAAGo=
-
portal_catalog/erp5_mysql/z_create_item
AAAAAAAAAGs=
-
portal_catalog/erp5_mysql/z_create_movement
AAAAAAAAAGw=
-
portal_catalog/erp5_mysql/z_create_predicate
AAAAAAAAAG0=
-
portal_catalog/erp5_mysql/z_create_predicate_category
AAAAAAAAAG4=
-
portal_catalog/erp5_mysql/z_create_roles_and_users
AAAAAAAAAG8=
-
portal_catalog/erp5_mysql/z_create_stock
AAAAAAAAAHA=
-
portal_catalog/erp5_mysql/z_create_subject
AAAAAAAAAHE=
-
portal_catalog/erp5_mysql/z_related_mirror_section_uid_from_stock
AAAAAAAAAHI=
-
portal_catalog/erp5_mysql/z_related_node_uid_from_stock
AAAAAAAAAHM=
-
portal_catalog/erp5_mysql/z_related_payment_uid_from_stock
AAAAAAAAAHQ=
-
portal_catalog/erp5_mysql/z_related_predicate
AAAAAAAAAHU=
-
portal_catalog/erp5_mysql/z_related_resource
AAAAAAAAAHY=
-
portal_catalog/erp5_mysql/z_related_resource_uid_from_stock
AAAAAAAAAHc=
-
portal_catalog/erp5_mysql/z_related_section_uid_from_stock
AAAAAAAAAHg=
-
portal_catalog/erp5_mysql/z_related_security
AAAAAAAAAHk=
-
portal_catalog/erp5_mysql/z_related_uid
AAAAAAAAAHo=
-
portal_catalog/erp5_mysql/z_search_folder
AAAAAAAAAHs=
-
portal_catalog/erp5_mysql/z_search_results
AAAAAAAAAHw=
-
portal_catalog/erp5_mysql/z_show_category_columns
AAAAAAAAAH0=
-
portal_catalog/erp5_mysql/z_uncatalog_delivery
AAAAAAAAAH4=
-
portal_catalog/erp5_mysql/z_uncatalog_object
AAAAAAAAAH8=
-
portal_catalog/erp5_mysql/z_update_delivery
AAAAAAAAAIA=
-
portal_catalog/erp5_mysql/z_update_object
AAAAAAAAAIE=
Persistence
PersistentMapping
-
_container
Persistence
PersistentMapping
-
_container
Persistence
PersistentMapping
-
_container
Persistence
PersistentMapping
-
_container
-
AppliedRule_createMessageTable
0
-
AppliedRule_deleteCatalog
0
-
AppliedRule_deleteCategory
0
-
AppliedRule_deleteMovement
0
-
AppliedRule_deleteStock
0
-
AppliedRule_insertCatalog
0
-
AppliedRule_insertCategory
0
-
AppliedRule_insertMovement
0
-
AppliedRule_insertStock
0
-
z0_drop_catalog
0
-
z0_drop_category
0
-
z0_drop_compatibility
0
-
z0_drop_delivery
0
-
z0_drop_item
0
-
z0_drop_movement
0
-
z0_drop_predicate
0
-
z0_drop_predicate_category
0
-
z0_drop_roles_and_users
0
-
z0_drop_stock
0
-
z0_drop_subject
0
-
z0_uncatalog_category
0
-
z0_uncatalog_compatibility
0
-
z0_uncatalog_item
0
-
z0_uncatalog_movement
0
-
z0_uncatalog_predicate
0
-
z0_uncatalog_predicate_category
0
-
z0_uncatalog_roles_and_users
0
-
z0_uncatalog_stock
0
-
z0_uncatalog_subject
0
-
z_catalog_category
0
-
z_catalog_category_list
1
-
z_catalog_compatibility
0
-
z_catalog_compatibility_list
1
-
z_catalog_item
0
-
z_catalog_item_list
1
-
z_catalog_movement
0
-
z_catalog_movement_list
1
-
z_catalog_object_list
1
-
z_catalog_predicate
0
-
z_catalog_predicate_category
0
-
z_catalog_roles_and_users
0
-
z_catalog_roles_and_users_list
1
-
z_catalog_stock
0
-
z_catalog_stock_list
1
-
z_catalog_subject
0
-
z_catalog_subject_list
1
-
z_count_results
0
-
z_create_catalog
0
-
z_create_category
0
-
z_create_compatibility
0
-
z_create_delivery
0
-
z_create_item
0
-
z_create_movement
0
-
z_create_predicate
0
-
z_create_predicate_category
0
-
z_create_roles_and_users
0
-
z_create_stock
0
-
z_create_subject
0
-
z_related_mirror_section_uid_from_stock
0
-
z_related_node_uid_from_stock
0
-
z_related_payment_uid_from_stock
0
-
z_related_predicate
0
-
z_related_resource
0
-
z_related_resource_uid_from_stock
0
-
z_related_section_uid_from_stock
0
-
z_related_security
0
-
z_related_uid
0
-
z_search_folder
0
-
z_search_results
0
-
z_show_category_columns
0
-
z_uncatalog_delivery
0
-
z_uncatalog_object
0
-
z_update_delivery
0
-
z_update_object
0
Persistence
PersistentMapping
-
_container
-
AppliedRule_createMessageTable
0
-
AppliedRule_deleteCatalog
0
-
AppliedRule_deleteCategory
0
-
AppliedRule_deleteMovement
0
-
AppliedRule_deleteStock
0
-
AppliedRule_insertCatalog
0
-
AppliedRule_insertCategory
0
-
AppliedRule_insertMovement
0
-
AppliedRule_insertStock
0
-
z0_drop_catalog
0
-
z0_drop_category
0
-
z0_drop_compatibility
0
-
z0_drop_delivery
0
-
z0_drop_item
0
-
z0_drop_movement
0
-
z0_drop_predicate
0
-
z0_drop_predicate_category
0
-
z0_drop_roles_and_users
0
-
z0_drop_stock
0
-
z0_drop_subject
0
-
z0_uncatalog_category
0
-
z0_uncatalog_compatibility
0
-
z0_uncatalog_item
0
-
z0_uncatalog_movement
0
-
z0_uncatalog_predicate
0
-
z0_uncatalog_predicate_category
0
-
z0_uncatalog_roles_and_users
0
-
z0_uncatalog_stock
0
-
z0_uncatalog_subject
0
-
z_catalog_category
1
-
z_catalog_category_list
0
-
z_catalog_compatibility
1
-
z_catalog_compatibility_list
0
-
z_catalog_item
1
-
z_catalog_item_list
0
-
z_catalog_movement
1
-
z_catalog_movement_list
0
-
z_catalog_object_list
0
-
z_catalog_predicate
1
-
z_catalog_predicate_category
1
-
z_catalog_roles_and_users
1
-
z_catalog_roles_and_users_list
0
-
z_catalog_stock
1
-
z_catalog_stock_list
0
-
z_catalog_subject
1
-
z_catalog_subject_list
0
-
z_count_results
0
-
z_create_catalog
0
-
z_create_category
0
-
z_create_compatibility
0
-
z_create_delivery
0
-
z_create_item
0
-
z_create_movement
0
-
z_create_predicate
0
-
z_create_predicate_category
0
-
z_create_roles_and_users
0
-
z_create_stock
0
-
z_create_subject
0
-
z_related_mirror_section_uid_from_stock
0
-
z_related_node_uid_from_stock
0
-
z_related_payment_uid_from_stock
0
-
z_related_predicate
0
-
z_related_resource
0
-
z_related_resource_uid_from_stock
0
-
z_related_section_uid_from_stock
0
-
z_related_security
0
-
z_related_uid
0
-
z_search_folder
0
-
z_search_results
0
-
z_show_category_columns
0
-
z_uncatalog_delivery
0
-
z_uncatalog_object
0
-
z_update_delivery
1
-
z_update_object
1
Persistence
PersistentMapping
-
_container
-
AppliedRule_createMessageTable
0
-
AppliedRule_deleteCatalog
0
-
AppliedRule_deleteCategory
0
-
AppliedRule_deleteMovement
0
-
AppliedRule_deleteStock
0
-
AppliedRule_insertCatalog
0
-
AppliedRule_insertCategory
0
-
AppliedRule_insertMovement
0
-
AppliedRule_insertStock
0
-
z0_drop_catalog
1
-
z0_drop_category
1
-
z0_drop_compatibility
1
-
z0_drop_delivery
1
-
z0_drop_item
1
-
z0_drop_movement
1
-
z0_drop_predicate
1
-
z0_drop_predicate_category
1
-
z0_drop_roles_and_users
1
-
z0_drop_stock
1
-
z0_drop_subject
1
-
z0_uncatalog_category
0
-
z0_uncatalog_compatibility
0
-
z0_uncatalog_item
0
-
z0_uncatalog_movement
0
-
z0_uncatalog_predicate
0
-
z0_uncatalog_predicate_category
0
-
z0_uncatalog_roles_and_users
0
-
z0_uncatalog_stock
0
-
z0_uncatalog_subject
0
-
z_catalog_category
0
-
z_catalog_category_list
0
-
z_catalog_compatibility
0
-
z_catalog_compatibility_list
0
-
z_catalog_item
0
-
z_catalog_item_list
0
-
z_catalog_movement
0
-
z_catalog_movement_list
0
-
z_catalog_object_list
0
-
z_catalog_predicate
0
-
z_catalog_predicate_category
0
-
z_catalog_roles_and_users
0
-
z_catalog_roles_and_users_list
0
-
z_catalog_stock
0
-
z_catalog_stock_list
0
-
z_catalog_subject
0
-
z_catalog_subject_list
0
-
z_count_results
0
-
z_create_catalog
1
-
z_create_category
1
-
z_create_compatibility
1
-
z_create_delivery
1
-
z_create_item
1
-
z_create_movement
1
-
z_create_predicate
1
-
z_create_predicate_category
1
-
z_create_roles_and_users
1
-
z_create_stock
1
-
z_create_subject
1
-
z_related_mirror_section_uid_from_stock
0
-
z_related_node_uid_from_stock
0
-
z_related_payment_uid_from_stock
0
-
z_related_predicate
0
-
z_related_resource
0
-
z_related_resource_uid_from_stock
0
-
z_related_section_uid_from_stock
0
-
z_related_security
0
-
z_related_uid
0
-
z_search_folder
0
-
z_search_results
0
-
z_show_category_columns
0
-
z_uncatalog_delivery
0
-
z_uncatalog_object
0
-
z_update_delivery
0
-
z_update_object
0
Persistence
PersistentMapping
-
_container
-
AppliedRule_createMessageTable
0
-
AppliedRule_deleteCatalog
0
-
AppliedRule_deleteCategory
0
-
AppliedRule_deleteMovement
0
-
AppliedRule_deleteStock
0
-
AppliedRule_insertCatalog
0
-
AppliedRule_insertCategory
0
-
AppliedRule_insertMovement
0
-
AppliedRule_insertStock
0
-
z0_drop_catalog
0
-
z0_drop_category
0
-
z0_drop_compatibility
0
-
z0_drop_delivery
0
-
z0_drop_item
0
-
z0_drop_movement
0
-
z0_drop_predicate
0
-
z0_drop_predicate_category
0
-
z0_drop_roles_and_users
0
-
z0_drop_stock
0
-
z0_drop_subject
0
-
z0_uncatalog_category
0
-
z0_uncatalog_compatibility
0
-
z0_uncatalog_item
0
-
z0_uncatalog_movement
0
-
z0_uncatalog_predicate
0
-
z0_uncatalog_predicate_category
0
-
z0_uncatalog_roles_and_users
0
-
z0_uncatalog_stock
0
-
z0_uncatalog_subject
0
-
z_catalog_category
0
-
z_catalog_category_list
0
-
z_catalog_compatibility
0
-
z_catalog_compatibility_list
0
-
z_catalog_item
0
-
z_catalog_item_list
0
-
z_catalog_movement
0
-
z_catalog_movement_list
0
-
z_catalog_object_list
0
-
z_catalog_predicate
0
-
z_catalog_predicate_category
0
-
z_catalog_roles_and_users
0
-
z_catalog_roles_and_users_list
0
-
z_catalog_stock
0
-
z_catalog_stock_list
0
-
z_catalog_subject
0
-
z_catalog_subject_list
0
-
z_count_results
0
-
z_create_catalog
0
-
z_create_category
0
-
z_create_compatibility
0
-
z_create_delivery
0
-
z_create_item
0
-
z_create_movement
0
-
z_create_predicate
0
-
z_create_predicate_category
0
-
z_create_roles_and_users
0
-
z_create_stock
0
-
z_create_subject
0
-
z_related_mirror_section_uid_from_stock
0
-
z_related_node_uid_from_stock
0
-
z_related_payment_uid_from_stock
0
-
z_related_predicate
0
-
z_related_resource
0
-
z_related_resource_uid_from_stock
0
-
z_related_section_uid_from_stock
0
-
z_related_security
0
-
z_related_uid
0
-
z_search_folder
0
-
z_search_results
0
-
z_show_category_columns
0
-
z_uncatalog_delivery
0
-
z_uncatalog_object
0
-
z_update_delivery
0
-
z_update_object
0
Persistence
PersistentMapping
-
_container
-
AppliedRule_createMessageTable
0
-
AppliedRule_deleteCatalog
0
-
AppliedRule_deleteCategory
0
-
AppliedRule_deleteMovement
0
-
AppliedRule_deleteStock
0
-
AppliedRule_insertCatalog
0
-
AppliedRule_insertCategory
0
-
AppliedRule_insertMovement
0
-
AppliedRule_insertStock
0
-
z0_drop_catalog
0
-
z0_drop_category
0
-
z0_drop_compatibility
0
-
z0_drop_delivery
0
-
z0_drop_item
0
-
z0_drop_movement
0
-
z0_drop_predicate
0
-
z0_drop_predicate_category
0
-
z0_drop_roles_and_users
0
-
z0_drop_stock
0
-
z0_drop_subject
0
-
z0_uncatalog_category
1
-
z0_uncatalog_compatibility
1
-
z0_uncatalog_item
1
-
z0_uncatalog_movement
1
-
z0_uncatalog_predicate
1
-
z0_uncatalog_predicate_category
1
-
z0_uncatalog_roles_and_users
1
-
z0_uncatalog_stock
1
-
z0_uncatalog_subject
1
-
z_catalog_category
0
-
z_catalog_category_list
0
-
z_catalog_compatibility
0
-
z_catalog_compatibility_list
0
-
z_catalog_item
0
-
z_catalog_item_list
0
-
z_catalog_movement
0
-
z_catalog_movement_list
0
-
z_catalog_object_list
0
-
z_catalog_predicate
0
-
z_catalog_predicate_category
0
-
z_catalog_roles_and_users
0
-
z_catalog_roles_and_users_list
0
-
z_catalog_stock
0
-
z_catalog_stock_list
0
-
z_catalog_subject
0
-
z_catalog_subject_list
0
-
z_count_results
0
-
z_create_catalog
0
-
z_create_category
0
-
z_create_compatibility
0
-
z_create_delivery
0
-
z_create_item
0
-
z_create_movement
0
-
z_create_predicate
0
-
z_create_predicate_category
0
-
z_create_roles_and_users
0
-
z_create_stock
0
-
z_create_subject
0
-
z_related_mirror_section_uid_from_stock
0
-
z_related_node_uid_from_stock
0
-
z_related_payment_uid_from_stock
0
-
z_related_predicate
0
-
z_related_resource
0
-
z_related_resource_uid_from_stock
0
-
z_related_section_uid_from_stock
0
-
z_related_security
0
-
z_related_uid
0
-
z_search_folder
0
-
z_search_results
0
-
z_show_category_columns
0
-
z_uncatalog_delivery
1
-
z_uncatalog_object
1
-
z_update_delivery
0
-
z_update_object
0
Persistence
PersistentMapping
-
_container
-
AppliedRule_createMessageTable
0
-
AppliedRule_deleteCatalog
0
-
AppliedRule_deleteCategory
0
-
AppliedRule_deleteMovement
0
-
AppliedRule_deleteStock
0
-
AppliedRule_insertCatalog
0
-
AppliedRule_insertCategory
0
-
AppliedRule_insertMovement
0
-
AppliedRule_insertStock
0
-
z0_drop_catalog
0
-
z0_drop_category
0
-
z0_drop_compatibility
0
-
z0_drop_delivery
0
-
z0_drop_item
0
-
z0_drop_movement
0
-
z0_drop_predicate
0
-
z0_drop_predicate_category
0
-
z0_drop_roles_and_users
0
-
z0_drop_stock
0
-
z0_drop_subject
0
-
z0_uncatalog_category
1
-
z0_uncatalog_compatibility
1
-
z0_uncatalog_item
1
-
z0_uncatalog_movement
1
-
z0_uncatalog_predicate
1
-
z0_uncatalog_predicate_category
1
-
z0_uncatalog_roles_and_users
1
-
z0_uncatalog_stock
1
-
z0_uncatalog_subject
1
-
z_catalog_category
1
-
z_catalog_category_list
0
-
z_catalog_compatibility
1
-
z_catalog_compatibility_list
0
-
z_catalog_item
1
-
z_catalog_item_list
0
-
z_catalog_movement
1
-
z_catalog_movement_list
0
-
z_catalog_object_list
0
-
z_catalog_predicate
1
-
z_catalog_predicate_category
1
-
z_catalog_roles_and_users
1
-
z_catalog_roles_and_users_list
0
-
z_catalog_stock
1
-
z_catalog_stock_list
0
-
z_catalog_subject
1
-
z_catalog_subject_list
0
-
z_count_results
0
-
z_create_catalog
0
-
z_create_category
0
-
z_create_compatibility
0
-
z_create_delivery
0
-
z_create_item
0
-
z_create_movement
0
-
z_create_predicate
0
-
z_create_predicate_category
0
-
z_create_roles_and_users
0
-
z_create_stock
0
-
z_create_subject
0
-
z_related_mirror_section_uid_from_stock
0
-
z_related_node_uid_from_stock
0
-
z_related_payment_uid_from_stock
0
-
z_related_predicate
0
-
z_related_resource
0
-
z_related_resource_uid_from_stock
0
-
z_related_section_uid_from_stock
0
-
z_related_security
0
-
z_related_uid
0
-
z_search_folder
0
-
z_search_results
0
-
z_show_category_columns
0
-
z_uncatalog_delivery
0
-
z_uncatalog_object
0
-
z_update_delivery
1
-
z_update_object
1
Persistence
PersistentMapping
-
_container
-
allowedRolesAndUsers | roles_and_users/allowedRolesAndUsers/z_related_security
-
predicate_uid | predicate/uid/z_related_predicate
-
resourceType | movement,catalog/portal_type/z_related_resource
-
stock_mirrorSectionCategory | category/category_uid/z_related_mirror_section_uid_from_stock
-
stock_nodeCategory | category/category_uid/z_related_node_uid_from_stock
-
stock_paymentCategory | category/category_uid/z_related_payment_uid_from_stock
-
stock_resourceCategory | category/category_uid/z_related_resource_uid_from_stock
-
stock_sectionCategory | category/category_uid/z_related_section_uid_from_stock
-
variationCategory | category/category_uid/z_related_uid
Persistence
PersistentMapping
-
_container
-
catalog.path
-
catalog.uid
Persistence
PersistentMapping
-
_container
-
catalog
-
category
-
compatibility
-
delivery
-
movement
-
predicate
-
predicate_category
-
roles_and_users
-
stock
Persistence
PersistentMapping
-
_container
Persistence
PersistentMapping
-
_container
Persistence
PersistentMapping
-
_container
Persistence
PersistentMapping
-
_container
Persistence
PersistentMapping
-
_container
Persistence
PersistentMapping
-
_container
Persistence
PersistentMapping
-
_container
Persistence
PersistentMapping
-
_container
Persistence
PersistentMapping
-
_container
Persistence
PersistentMapping
-
_container
Persistence
PersistentMapping
-
_container
Persistence
PersistentMapping
-
_container
Persistence
PersistentMapping
-
_container
Persistence
PersistentMapping
-
_container
Persistence
PersistentMapping
-
_container
Persistence
PersistentMapping
-
_container
Persistence
PersistentMapping
-
_container
Products.ZSQLMethods.SQL
SQL
-
__ac_local_roles__
-
alex
Owner
-
_arg
-
allow_simple_one_argument_traversal
-
arguments_src
-
cache_time_
0
-
class_file_
-
class_name_
-
connection_hook
-
connection_id
erp5_sql_connection
-
id
AppliedRule_createMessageTable
-
max_cache_
100
-
max_rows_
1000
-
src
# Host: localhost\n
# Database: coramy\n
# Table: \'message\'\n
# \n
CREATE TABLE `message` (\n
`path` varchar(255) default NULL,\n
`method_id` varchar(40) default NULL,\n
`message` blob,\n
KEY `path` (`path`),\n
KEY `method_id` (`method_id`)\n
) TYPE=InnoDB;
-
template
-
title
Products.ZSQLMethods.SQL
SQL
-
__ac_local_roles__
-
alex
Owner
-
_arg
-
allow_simple_one_argument_traversal
-
arguments_src
uid_query
-
cache_time_
0
-
class_file_
-
class_name_
-
connection_hook
-
connection_id
erp5_sql_connection
-
id
AppliedRule_deleteCatalog
-
max_cache_
100
-
max_rows_
1000
-
src
\n
]]>
-
template
-
title
Products.ZSQLMethods.SQL
SQL
-
__ac_local_roles__
-
alex
Owner
-
_arg
-
allow_simple_one_argument_traversal
-
arguments_src
uid_query
-
cache_time_
0
-
class_file_
-
class_name_
-
connection_hook
-
connection_id
erp5_sql_connection
-
id
AppliedRule_deleteCategory
-
max_cache_
100
-
max_rows_
1000
-
src
]]>
-
template
-
title
Products.ZSQLMethods.SQL
SQL
-
__ac_local_roles__
-
alex
Owner
-
_arg
-
allow_simple_one_argument_traversal
-
arguments_src
uid_query
-
cache_time_
0
-
class_file_
-
class_name_
-
connection_hook
-
connection_id
erp5_sql_connection
-
id
AppliedRule_deleteMovement
-
max_cache_
100
-
max_rows_
1000
-
src
]]>
-
template
-
title
Products.ZSQLMethods.SQL
SQL
-
__ac_local_roles__
-
alex
Owner
-
_arg
-
allow_simple_one_argument_traversal
-
arguments_src
uid_query
-
cache_time_
0
-
class_file_
-
class_name_
-
connection_hook
-
connection_id
erp5_sql_connection
-
id
AppliedRule_deleteStock
-
max_cache_
100
-
max_rows_
1000
-
src
]]>
-
template
-
title
Products.ZSQLMethods.SQL
SQL
-
__ac_local_roles__
-
alex
Owner
-
_arg
-
allow_simple_one_argument_traversal
-
arguments_src
values
-
cache_time_
0
-
class_file_
-
class_name_
-
connection_hook
-
connection_id
erp5_sql_connection
-
id
AppliedRule_insertCatalog
-
max_cache_
100
-
max_rows_
1000
-
src
;
]]>
-
template
-
title
Products.ZSQLMethods.SQL
SQL
-
__ac_local_roles__
-
alex
Owner
-
_arg
-
allow_simple_one_argument_traversal
-
arguments_src
values
-
cache_time_
0
-
class_file_
-
class_name_
-
connection_hook
-
connection_id
erp5_sql_connection
-
id
AppliedRule_insertCategory
-
max_cache_
100
-
max_rows_
1000
-
src
;
]]>
-
template
-
title
Products.ZSQLMethods.SQL
SQL
-
__ac_local_roles__
-
alex
Owner
-
_arg
-
allow_simple_one_argument_traversal
-
arguments_src
values
-
cache_time_
0
-
class_file_
-
class_name_
-
connection_hook
-
connection_id
erp5_sql_connection
-
id
AppliedRule_insertMovement
-
max_cache_
100
-
max_rows_
1000
-
src
;
]]>
-
template
-
title
Products.ZSQLMethods.SQL
SQL
-
__ac_local_roles__
-
alex
Owner
-
_arg
-
allow_simple_one_argument_traversal
-
arguments_src
values
-
cache_time_
0
-
class_file_
-
class_name_
-
connection_hook
-
connection_id
erp5_sql_connection
-
id
AppliedRule_insertStock
-
max_cache_
100
-
max_rows_
1000
-
src
;
]]>
-
template
-
title
Products.ZSQLMethods.SQL
SQL
-
__ac_local_roles__
-
alex
Owner
-
_arg
-
allow_simple_one_argument_traversal
-
arguments_src
-
cache_time_
0
-
class_file_
-
class_name_
-
connection_hook
-
connection_id
erp5_sql_connection
-
id
z0_drop_catalog
-
max_cache_
100
-
max_rows_
1000
-
src
DROP TABLE catalog
-
template
-
title
Products.ZSQLMethods.SQL
SQL
-
__ac_local_roles__
-
alex
Owner
-
_arg
-
allow_simple_one_argument_traversal
-
arguments_src
-
cache_time_
0
-
class_file_
-
class_name_
-
connection_hook
-
connection_id
erp5_sql_connection
-
id
z0_drop_category
-
max_cache_
100
-
max_rows_
1000
-
src
DROP TABLE category
-
template
-
title
Products.ZSQLMethods.SQL
SQL
-
__ac_local_roles__
-
alex
Owner
-
_arg
-
allow_simple_one_argument_traversal
-
arguments_src
-
cache_time_
0
-
class_file_
-
class_name_
-
connection_hook
-
connection_id
erp5_sql_connection
-
id
z0_drop_compatibility
-
max_cache_
100
-
max_rows_
1000
-
src
DROP TABLE compatibility
-
template
-
title
Products.ZSQLMethods.SQL
SQL
-
__ac_local_roles__
-
jp
Owner
-
_arg
-
_owner
nexedi
acl_users
jp
-
arguments_src
-
connection_id
erp5_sql_connection
-
id
z0_drop_delivery
-
src
DROP TABLE delivery
-
template
-
title
Products.ZSQLMethods.SQL
SQL
-
__ac_local_roles__
-
alex
Owner
-
_arg
-
_owner
nexedi
acl_users
jp
-
allow_simple_one_argument_traversal
-
arguments_src
-
cache_time_
0
-
class_file_
-
class_name_
-
connection_hook
-
connection_id
erp5_sql_connection
-
id
z0_drop_item
-
max_cache_
100
-
max_rows_
1000
-
src
DROP TABLE item
-
template
-
title
Products.ZSQLMethods.SQL
SQL
-
__ac_local_roles__
-
alex
Owner
-
_arg
-
allow_simple_one_argument_traversal
-
arguments_src
-
cache_time_
0
-
class_file_
-
class_name_
-
connection_hook
-
connection_id
erp5_sql_connection
-
id
z0_drop_movement
-
max_cache_
100
-
max_rows_
1000
-
src
DROP TABLE movement
-
template
-
title
Products.ZSQLMethods.SQL
SQL
-
__ac_local_roles__
-
yo
Owner
-
_arg
-
_owner
nexedi
acl_users
yo
-
arguments_src
-
connection_id
erp5_sql_connection
-
id
z0_drop_predicate
-
src
DROP TABLE predicate
-
template
-
title
Products.ZSQLMethods.SQL
SQL
-
__ac_local_roles__
-
yo
Owner
-
_arg
-
_owner
nexedi
acl_users
yo
-
arguments_src
-
connection_id
erp5_sql_connection
-
id
z0_drop_predicate_category
-
src
DROP TABLE predicate_category
-
template
-
title
Products.ZSQLMethods.SQL
SQL
-
__ac_local_roles__
-
alex
Owner
-
_arg
-
allow_simple_one_argument_traversal
-
arguments_src
-
cache_time_
0
-
class_file_
-
class_name_
-
connection_hook
-
connection_id
erp5_sql_connection
-
id
z0_drop_roles_and_users
-
max_cache_
100
-
max_rows_
1000
-
src
DROP TABLE roles_and_users
-
template
-
title
Products.ZSQLMethods.SQL
SQL
-
__ac_local_roles__
-
alex
Owner
-
_arg
-
allow_simple_one_argument_traversal
-
arguments_src
-
cache_time_
0
-
class_file_
-
class_name_
-
connection_hook
-
connection_id
erp5_sql_connection
-
id
z0_drop_stock
-
max_cache_
100
-
max_rows_
1000
-
src
DROP TABLE stock
-
template
-
title
Products.ZSQLMethods.SQL
SQL
-
__ac_local_roles__
-
alex
Owner
-
_arg
-
allow_simple_one_argument_traversal
-
arguments_src
-
cache_time_
0
-
class_file_
-
class_name_
-
connection_hook
-
connection_id
erp5_sql_connection
-
id
z0_drop_subject
-
max_cache_
100
-
max_rows_
1000
-
src
DROP TABLE subject
-
template
-
title
Products.ZSQLMethods.SQL
SQL
-
__ac_local_roles__
-
alex
Owner
-
_arg
-
allow_simple_one_argument_traversal
-
arguments_src
uid
-
cache_time_
0
-
class_file_
-
class_name_
-
connection_hook
-
connection_id
erp5_sql_connection
-
id
z0_uncatalog_category
-
max_cache_
100
-
max_rows_
1000
-
src
]]>
-
template
-
title
Products.ZSQLMethods.SQL
SQL
-
__ac_local_roles__
-
alex
Owner
-
_arg
-
allow_simple_one_argument_traversal
-
arguments_src
uid
-
cache_time_
0
-
class_file_
-
class_name_
-
connection_hook
-
connection_id
erp5_sql_connection
-
id
z0_uncatalog_compatibility
-
max_cache_
100
-
max_rows_
1000
-
src
]]>
-
template
-
title
Products.ZSQLMethods.SQL
SQL
-
__ac_local_roles__
-
alex
Owner
-
_arg
-
_owner
nexedi
acl_users
jp
-
allow_simple_one_argument_traversal
-
arguments_src
uid
-
cache_time_
0
-
class_file_
-
class_name_
-
connection_hook
-
connection_id
erp5_sql_connection
-
id
z0_uncatalog_item
-
max_cache_
100
-
max_rows_
1000
-
src
]]>
-
template
-
title
Products.ZSQLMethods.SQL
SQL
-
__ac_local_roles__
-
alex
Owner
-
_arg
-
allow_simple_one_argument_traversal
-
arguments_src
uid
-
cache_time_
0
-
class_file_
-
class_name_
-
connection_hook
-
connection_id
erp5_sql_connection
-
id
z0_uncatalog_movement
-
max_cache_
100
-
max_rows_
1000
-
src
]]>
-
template
-
title
Products.ZSQLMethods.SQL
SQL
-
__ac_local_roles__
-
yo
Owner
-
_arg
-
_owner
nexedi
acl_users
yo
-
arguments_src
uid
-
connection_id
erp5_sql_connection
-
id
z0_uncatalog_predicate
-
src
]]>
-
template
-
title
Products.ZSQLMethods.SQL
SQL
-
__ac_local_roles__
-
yo
Owner
-
_arg
-
_owner
nexedi
acl_users
yo
-
arguments_src
uid
-
connection_id
erp5_sql_connection
-
id
z0_uncatalog_predicate_category
-
src
]]>
-
template
-
title
Products.ZSQLMethods.SQL
SQL
-
__ac_local_roles__
-
alex
Owner
-
_arg
-
allow_simple_one_argument_traversal
-
arguments_src
uid
-
cache_time_
0
-
class_file_
-
class_name_
-
connection_hook
-
connection_id
erp5_sql_connection
-
id
z0_uncatalog_roles_and_users
-
max_cache_
100
-
max_rows_
1000
-
src
]]>
-
template
-
title
Products.ZSQLMethods.SQL
SQL
-
__ac_local_roles__
-
alex
Owner
-
_arg
-
allow_simple_one_argument_traversal
-
arguments_src
uid
-
cache_time_
0
-
class_file_
-
class_name_
-
connection_hook
-
connection_id
erp5_sql_connection
-
id
z0_uncatalog_stock
-
max_cache_
100
-
max_rows_
1000
-
src
]]>
-
template
-
title
Products.ZSQLMethods.SQL
SQL
-
__ac_local_roles__
-
alex
Owner
-
_arg
-
allow_simple_one_argument_traversal
-
arguments_src
uid
-
cache_time_
0
-
class_file_
-
class_name_
-
connection_hook
-
connection_id
erp5_sql_connection
-
id
z0_uncatalog_subject
-
max_cache_
100
-
max_rows_
1000
-
src
]]>
-
template
-
title
Products.ZSQLMethods.SQL
SQL
-
__ac_local_roles__
-
alex
Owner
-
_arg
-
allow_simple_one_argument_traversal
-
arguments_src
uid\r\n
getAcquiredCategoryList\r\n
getCategoryList\r\n
isMovement
-
cache_time_
0
-
class_file_
-
class_name_
-
connection_hook
-
connection_id
erp5_sql_connection
-
id
z_catalog_category
-
max_cache_
100
-
max_rows_
1000
-
src
\n
\n
\n
\n
INSERT INTO category VALUES \n
\n
(, , , )\n
,\n
\n
;\n
\n
INSERT INTO category VALUES (, NULL, NULL,1);\n
\n
\n
\n
INSERT INTO category VALUES (, NULL, NULL,1);\n
\n
\n
\n
\n
\n
INSERT INTO category VALUES \n
\n
(, , , )\n
,\n
\n
;\n
\n
INSERT INTO category VALUES (, NULL, NULL,1);\n
\n
\n
\n
INSERT INTO category VALUES (, NULL, NULL,1);\n
\n
]]>
-
template
-
title
Products.ZSQLMethods.SQL
SQL
-
__ac_local_roles__
-
alex
Owner
-
_arg
-
allow_simple_one_argument_traversal
-
arguments_src
uid\r\n
isMovement\r\n
getCategoryList\r\n
getAcquiredCategoryList
-
cache_time_
0
-
class_file_
-
class_name_
-
connection_hook
-
connection_id
erp5_sql_connection
-
id
z_catalog_category_list
-
max_cache_
100
-
max_rows_
1000
-
src
\n
,\n
\n
\n
\n
\n
\n
,\n
(\n
,\n
,\n
,\n
\n
)\n
\n
\n
(\n
,\n
NULL,\n
NULL,\n
1\n
)\n
\n
\n
\n
(\n
,\n
NULL,\n
NULL,\n
1\n
)\n
\n
\n
\n
\n
\n
\n
,\n
(\n
,\n
,\n
,\n
\n
)\n
\n
\n
(\n
,\n
NULL,\n
NULL,\n
1\n
)\n
\n
\n
\n
(\n
,\n
NULL,\n
NULL,\n
1\n
)\n
\n
\n
\n
]]>
-
template
-
title
Products.ZSQLMethods.SQL
SQL
-
__ac_local_roles__
-
alex
Owner
-
_arg
-
allow_simple_one_argument_traversal
-
arguments_src
uid\r\n
Creator\r\n
Date\r\n
PrincipiaSearchSource\r\n
SearchableText\r\n
EffectiveDate\r\n
ExpiresDate\r\n
ModificationDate\r\n
Type\r\n
bobobase_modification_time\r\n
created\r\n
effective\r\n
expires\r\n
getIcon\r\n
in_reply_to\r\n
modified\r\n
review_state\r\n
summary\r\n
-
cache_time_
0
-
class_file_
-
class_name_
-
connection_hook
-
connection_id
erp5_sql_connection
-
id
z_catalog_compatibility
-
max_cache_
100
-
max_rows_
1000
-
src
,\n
,\n
,\n
,\n
,\n
,\n
,\n
,\n
,\n
,\n
,\n
,\n
,\n
,\n
,\n
,\n
,\n
\n
);
]]>
-
template
-
title
Products.ZSQLMethods.SQL
SQL
-
__ac_local_roles__
-
alex
Owner
-
_arg
-
allow_simple_one_argument_traversal
-
arguments_src
uid\r\n
Creator\r\n
Date\r\n
PrincipiaSearchSource\r\n
SearchableText\r\n
EffectiveDate\r\n
ExpiresDate\r\n
ModificationDate\r\n
Type\r\n
bobobase_modification_time\r\n
created\r\n
effective\r\n
expires\r\n
getIcon\r\n
in_reply_to\r\n
modified\r\n
review_state\r\n
summary\r\n
-
cache_time_
0
-
class_file_
-
class_name_
-
connection_hook
-
connection_id
erp5_sql_connection
-
id
z_catalog_compatibility_list
-
max_cache_
100
-
max_rows_
1000
-
src
\n
(\n
, \n
,\n
,\n
,\n
,\n
,\n
,\n
,\n
,\n
,\n
,\n
,\n
,\n
,\n
,\n
,\n
,\n
\n
)\n
\n
\n
,\n
\n
\n
]]>
-
template
-
title
Products.ZSQLMethods.SQL
SQL
-
__ac_local_roles__
-
alex
Owner
-
_arg
-
_owner
nexedi
acl_users
jp
-
allow_simple_one_argument_traversal
-
arguments_src
isMovement\r\n
uid\r\n
getAggregateUidList\r\n
getDestinationUid\r\n
getDestinationSectionUid\r\n
getResourceUid\r\n
getStopDate\r\n
getVariationText
-
cache_time_
0
-
class_file_
-
class_name_
-
connection_hook
-
connection_id
erp5_sql_connection
-
id
z_catalog_item
-
max_cache_
100
-
max_rows_
1000
-
src
\n
\n
\n
INSERT INTO item VALUES ( \n
,\n
,\n
,\n
,\n
,\n
,\n
\n
),;\n
\n
\n
]]>
-
template
-
title
Products.ZSQLMethods.SQL
SQL
-
__ac_local_roles__
-
alex
Owner
-
_arg
-
_owner
nexedi
acl_users
jp
-
allow_simple_one_argument_traversal
-
arguments_src
isMovement\r\n
uid\r\n
getStopDate\r\n
getDestinationUid\r\n
getDestinationSectionUid\r\n
getResourceUid\r\n
getVariationText\r\n
getAggregateUidList
-
cache_time_
0
-
class_file_
-
class_name_
-
connection_hook
-
connection_id
erp5_sql_connection
-
id
z_catalog_item_list
-
max_cache_
100
-
max_rows_
1000
-
src
\n
\n
\n
\n
\n
\n
\n
INSERT INTO\n
item\n
VALUES\n
\n
\n
( \n
,\n
,\n
,\n
,\n
,\n
,\n
,\n
)\n
,\n
,\n
\n
\n
\n
]]>
-
template
-
title
Products.ZSQLMethods.SQL
SQL
-
__ac_local_roles__
-
alex
Owner
-
_arg
-
allow_simple_one_argument_traversal
-
arguments_src
isMovement\r\n
uid\r\n
getDeliveryUid\r\n
getSourceUid\r\n
getDestinationUid\r\n
getResourceUid\r\n
getNetConvertedQuantity\r\n
getStartDate\r\n
getStopDate\r\n
getNetConvertedTargetQuantity\r\n
getTargetStartDate\r\n
getTargetStopDate\r\n
getPrice\r\n
getTotalPrice\r\n
getTargetTotalPrice\r\n
hasCellContent\r\n
isAccountable\r\n
isOrderable\r\n
isDeliverable\r\n
getVariationText
-
cache_time_
0
-
class_file_
-
class_name_
-
connection_hook
-
connection_id
erp5_sql_connection
-
id
z_catalog_movement
-
max_cache_
100
-
max_rows_
1000
-
src
\n
INSERT INTO movement VALUES ( \n
,\n
NULL,\n
NULL,\n
NULL,\n
NULL,\n
NULL,\n
NULL,\n
NULL,\n
NULL,\n
NULL,\n
NULL,\n
NULL,\n
NULL,\n
NULL,\n
NULL,\n
NULL,\n
NULL,\n
NULL,\n
NULL,\n
NULL\n
);\n
]]>
-
template
-
title
Products.ZSQLMethods.SQL
SQL
-
__ac_local_roles__
-
alex
Owner
-
_arg
-
allow_simple_one_argument_traversal
-
arguments_src
isMovement\r\n
uid\r\n
getExplanationUid\r\n
getSourceUid\r\n
getDestinationUid\r\n
getResourceUid\r\n
getNetConvertedQuantity\r\n
getInventoriatedStartDate\r\n
getInventoriatedStopDate\r\n
getNetConvertedTargetQuantity\r\n
getTargetStartDate\r\n
getTargetStopDate\r\n
getPrice\r\n
getTotalPrice\r\n
getTargetTotalPrice\r\n
hasCellContent\r\n
isAccountable\r\n
isOrderable\r\n
isDeliverable\r\n
getVariationText
-
cache_time_
0
-
class_file_
-
class_name_
-
connection_hook
-
connection_id
erp5_sql_connection
-
id
z_catalog_movement_list
-
max_cache_
100
-
max_rows_
1000
-
src
\n
\n
\n
\n
\n
\n
\n
INSERT INTO\n
movement\n
VALUES\n
\n
( \n
,\n
,\n
,\n
,\n
,\n
,\n
NULL,\n
,\n
,\n
,\n
,\n
,\n
,\n
,\n
,\n
,\n
,\n
,\n
,\n
\n
)\n
,\n
\n
\n
\n
]]>
-
template
-
title
Products.ZSQLMethods.SQL
SQL
-
__ac_local_roles__
-
alex
Owner
-
_arg
-
allow_simple_one_argument_traversal
-
arguments_src
uid\r\n
security_uid\r\n
getPath\r\n
getRelativeUrl\r\n
getParentUid\r\n
id\r\n
CreationDate\r\n
getDescription\r\n
getTitle\r\n
meta_type\r\n
getPortalType\r\n
opportunity_state\r\n
getDefaultSourceReference\r\n
getDefaultDestinationReference\r\n
getDefaultSourceTitle\r\n
getDefaultDestinationTitle\r\n
getDefaultSourceSectionTitle\r\n
getDefaultDestinationSectionTitle\r\n
getDefaultCausalityId\r\n
getLocation\r\n
getEan13Code\r\n
simulation_state\r\n
causality_state\r\n
discussion_state\r\n
invoice_state\r\n
getOrderId\r\n
validation_state\r\n
payment_state\r\n
event_state\r\n
getReference\r\n
getSourceReference\r\n
getDestinationReference\n
getStringIndex\n
getIntIndex\n
getFloatIndex
-
cache_time_
0
-
class_file_
-
class_name_
-
connection_hook
-
connection_id
erp5_sql_connection
-
id
z_catalog_object_list
-
max_cache_
100
-
max_rows_
1000
-
src
\n
(\n
, \n
,\n
,\n
,\n
,\n
,\n
,\n
,\n
,\n
,\n
,\n
,\n
,\n
,\n
,\n
,\n
,\n
,\n
,\n
,\n
,\n
,\n
,\n
,\n
,\n
,\n
,\n
,\n
,\n
,\n
,\n
,\n
,\n
,\n
\n
\n
)\n
,\n
\n
]]>
-
template
-
title
Products.ZSQLMethods.SQL
SQL
-
__ac_local_roles__
-
yo
Owner
-
_arg
-
_owner
nexedi
acl_users
yo
-
arguments_src
uid\r\n
isPredicate\r\n
predicate_property_dict
-
connection_id
erp5_sql_connection
-
id
z_catalog_predicate
-
src
\n
INSERT INTO predicate VALUES (\n
,\n
NULL,\n
NULL,\n
NULL\n
);\n
\n
]]>
-
template
-
title
Products.ZSQLMethods.SQL
SQL
-
__ac_local_roles__
-
yo
Owner
-
_arg
-
_owner
nexedi
acl_users
yo
-
arguments_src
uid\r\n
getMembershipCriterionCategoryList\r\n
isPredicate
-
connection_id
erp5_sql_connection
-
id
z_catalog_predicate_category
-
src
\n
\n
\n
\n
INSERT INTO predicate_category VALUES\n
\n
(, , , )\n
,\n
\n
;\n
\n
INSERT INTO predicate_category VALUES (, NULL, NULL, 1);\n
\n
\n
\n
INSERT INTO predicate_category VALUES (, NULL, NULL, 1);\n
\n
\n
]]>
-
template
-
title
Products.ZSQLMethods.SQL
SQL
-
__ac_local_roles__
-
alex
Owner
-
_arg
-
allow_simple_one_argument_traversal
-
arguments_src
security_uid\r\n
optimised_roles_and_users
-
cache_time_
0
-
class_file_
-
class_name_
-
connection_hook
-
connection_id
erp5_sql_connection
-
id
z_catalog_roles_and_users
-
max_cache_
100
-
max_rows_
1000
-
src
\n
INSERT INTO roles_and_users VALUES\n
\n
(, )\n
,\n
\n
;\n
\n
]]>
-
template
-
title
Products.ZSQLMethods.SQL
SQL
-
__ac_local_roles__
-
alex
Owner
-
_arg
-
allow_simple_one_argument_traversal
-
arguments_src
security_uid\r\n
optimised_roles_and_users
-
cache_time_
0
-
class_file_
-
class_name_
-
connection_hook
-
connection_id
erp5_sql_connection
-
id
z_catalog_roles_and_users_list
-
max_cache_
100
-
max_rows_
1000
-
src
\n
\n
\n
\n
\n
\n
\n
\n
\n
INSERT INTO\n
roles_and_users\n
VALUES\n
\n
(, )\n
,\n
\n
\n
\n
]]>
-
template
-
title
Products.ZSQLMethods.SQL
SQL
-
__ac_local_roles__
-
alex
Owner
-
_arg
-
allow_simple_one_argument_traversal
-
arguments_src
uid\r\n
getResourceUid\r\n
getInventoriatedQuantity\r\n
getSourceUid\r\n
getDestinationUid\r\n
getSourceSectionUid\r\n
getDestinationSectionUid\r\n
isMovement\r\n
getSourcePaymentUid\r\n
getDestinationPaymentUid\r\n
getSimulationState\r\n
getPrice\r\n
getStartDate\r\n
getStopDate\r\n
isAccountable\r\n
getPortalType\r\n
getVariationText
-
cache_time_
0
-
class_file_
-
class_name_
-
connection_hook
-
connection_id
erp5_sql_connection
-
id
z_catalog_stock
-
max_cache_
100
-
max_rows_
1000
-
src
\n
\n
\n
INSERT INTO\n
stock\n
VALUES\n
(\n
,\n
,\n
NULL,\n
NULL,\n
NULL, \n
,\n
NULL,\n
NULL,\n
NULL,\n
NULL,\n
NULL,\n
NULL,\n
NULL\n
)\n
\n
,\n
(\n
,\n
, \n
NULL, \n
NULL, \n
NULL,\n
, \n
NULL, \n
NULL,\n
NULL,\n
NULL,\n
NULL,\n
NULL,\n
NULL\n
)\n
\n
\n
\n
INSERT INTO\n
stock\n
VALUES\n
(\n
,\n
, \n
NULL, \n
NULL, \n
NULL,\n
, \n
NULL, \n
NULL,\n
NULL,\n
NULL,\n
NULL,\n
NULL,\n
NULL\n
)\n
\n
\n
\n
\n
]]>
-
template
-
title
Products.ZSQLMethods.SQL
SQL
-
__ac_local_roles__
-
alex
Owner
-
_arg
-
allow_simple_one_argument_traversal
-
arguments_src
uid\r\n
getResourceUid\r\n
getInventoriatedQuantity\r\n
getSourceUid\r\n
getDestinationUid\r\n
getSourceSectionUid\r\n
getDestinationSectionUid\r\n
isMovement\r\n
getSourcePaymentUid\r\n
getDestinationPaymentUid\r\n
getSimulationState\r\n
getPrice\r\n
getStartDate\r\n
getStopDate\r\n
isAccountable\r\n
getPortalType\r\n
getVariationText
-
cache_time_
0
-
class_file_
-
class_name_
-
connection_hook
-
connection_id
erp5_sql_connection
-
id
z_catalog_stock_list
-
max_cache_
100
-
max_rows_
1000
-
src
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
0">\n
INSERT INTO\n
stock\n
VALUES\n
\n
(\n
,\n
, \n
, \n
, \n
,\n
, \n
,\n
\n
\n
\n
\n
\n
\n
)\n
,\n
\n
\n
\n
]]>
-
template
-
title
Products.ZSQLMethods.SQL
SQL
-
__ac_local_roles__
-
alex
Owner
-
_arg
-
allow_simple_one_argument_traversal
-
arguments_src
uid\n
Subject
-
cache_time_
0
-
class_file_
-
class_name_
-
connection_hook
-
connection_id
erp5_sql_connection
-
id
z_catalog_subject
-
max_cache_
100
-
max_rows_
1000
-
src
\n
INSERT INTO subject VALUES \n
\n
\n
(, ),\n
\n
;\n
\n
\n
(, ),\n
\n
;\n
\n
\n
]]>
-
template
-
title
Products.ZSQLMethods.SQL
SQL
-
__ac_local_roles__
-
alex
Owner
-
_arg
-
allow_simple_one_argument_traversal
-
arguments_src
Subject\r\n
uid
-
cache_time_
0
-
class_file_
-
class_name_
-
connection_hook
-
connection_id
erp5_sql_connection
-
id
z_catalog_subject_list
-
max_cache_
100
-
max_rows_
1000
-
src
\n
,\n
\n
\n
\n
,\n
(, )\n
\n
\n
(, NULL)\n
\n
\n
\n
]]>
-
template
-
title
Products.ZSQLMethods.SQL
SQL
-
__ac_local_roles__
-
alex
Owner
-
_arg
-
allow_simple_one_argument_traversal
-
arguments_src
from_table_list\n
where_expression\n
select_expression\n
selection_domain\n
selection_report
-
cache_time_
180
-
class_file_
zsqlbrain.py
-
class_name_
ZSQLBrain
-
connection_hook
-
connection_id
erp5_sql_connection
-
id
z_count_results
-
max_cache_
1000
-
max_rows_
1
-
src
We need subselect for better statistics\n
\n
, \n
\n
FROM\n
AS ,\n
, \n
, \n
WHERE\n
1 = 1\n
\n
AND \n
\n
\n
AND \n
\n
\n
AND \n
\n
\n
ORDER BY\n
\n
\n
]]>
-
template
-
title
Products.ZSQLMethods.SQL
SQL
-
__ac_local_roles__
-
alex
Owner
-
_arg
-
allow_simple_one_argument_traversal
-
arguments_src
-
cache_time_
0
-
class_file_
-
class_name_
-
connection_hook
-
connection_id
erp5_sql_connection
-
id
z_create_catalog
-
max_cache_
100
-
max_rows_
1000
-
src
# Host:\n
# Database: test\n
# Table: \'catalog\'\n
#\n
CREATE TABLE `catalog` (\n
`uid` int(11) NOT NULL AUTO_INCREMENT,\n
`security_uid` INT UNSIGNED,\n
`path` varchar(255) NOT NULL default \'\',\n
`relative_url` varchar(255) NOT NULL default \'\',\n
`parent_uid` int(11) default \'0\',\n
`id` varchar(30) default \'\',\n
`CreationDate` datetime default \'0000-00-00 00:00:00\',\n
`description` text,\n
`title` varchar(255) default \'\',\n
`meta_type` varchar(255) default \'\',\n
`portal_type` varchar(255) default \'\',\n
`opportunity_state` varchar(30) default \'\',\n
`default_source_reference` varchar(30) default \'\',\n
`default_destination_reference` varchar(30) default \'\',\n
`default_source_title` varchar(30) default \'\',\n
`default_destination_title` varchar(30) default \'\',\n
`default_source_section_title` varchar(30) default \'\',\n
`default_destination_section_title` varchar(30) default \'\',\n
`default_causality_id` varchar(30) default \'\',\n
`location` varchar(30),\n
`ean13_code` varchar(30),\n
`validation_state` varchar(30) default \'\',\n
`simulation_state` varchar(30) default \'\',\n
`causality_state` varchar(30) default \'\',\n
`discussion_state` varchar(30) default \'\',\n
`invoice_state` varchar(30) default \'\',\n
`payment_state` varchar(30) default \'\',\n
`event_state` varchar(30) default \'\',\n
`order_id` varchar(30) default \'\',\n
`reference` varchar(30) default \'\',\n
`source_reference` varchar(30) default \'\',\n
`destination_reference` varchar(30) default \'\',\n
`string_index` varchar(30),\n
`int_index` int(11),\n
`float_index` real,\n
PRIMARY KEY (`uid`),\n
KEY `security_uid` (`security_uid`),\n
KEY `Parent` (`parent_uid`),\n
KEY `Path` (`path`),\n
KEY `relative_url` (`relative_url`),\n
KEY `Type` (`meta_type`,`portal_type`),\n
KEY `Type1` (`portal_type`),\n
KEY `Type2` (`meta_type`),\n
KEY `opportunity_state` (`opportunity_state`),\n
KEY `validation_state` (`validation_state`),\n
KEY `simulation_state` (`simulation_state`),\n
KEY `causality_state` (`causality_state`),\n
KEY `discussion_state` (`discussion_state`),\n
KEY `invoice_state` (`invoice_state`),\n
KEY `order_id` (`order_id`),\n
KEY `payment_state` (`payment_state`),\n
KEY `event_state` (`event_state`)\n
) TYPE=InnoDB;\n
-
template
-
title
Products.ZSQLMethods.SQL
SQL
-
__ac_local_roles__
-
alex
Owner
-
_arg
-
allow_simple_one_argument_traversal
-
arguments_src
-
cache_time_
0
-
class_file_
-
class_name_
-
connection_hook
-
connection_id
erp5_sql_connection
-
id
z_create_category
-
max_cache_
100
-
max_rows_
1000
-
src
# Host: \n
# Database: test\n
# Table: \'category\'\n
# \n
CREATE TABLE `category` (\n
`uid` int(11) default \'0\',\n
`category_uid` int(11) default \'0\',\n
`base_category_uid` int(11) default \'0\',\n
`category_strict_membership` tinyint(1) default \'0\',\n
KEY `uid` (`uid`),\n
KEY `category_strict_membership` (`category_strict_membership`),\n
KEY `Membership` (`category_uid`,`base_category_uid`),\n
KEY `FuzzyMembership` (`category_uid`)\n
) TYPE = InnoDB;
-
template
-
title
Products.ZSQLMethods.SQL
SQL
-
__ac_local_roles__
-
alex
Owner
-
_arg
-
allow_simple_one_argument_traversal
-
arguments_src
-
cache_time_
0
-
class_file_
-
class_name_
-
connection_hook
-
connection_id
erp5_sql_connection
-
id
z_create_compatibility
-
max_cache_
100
-
max_rows_
1000
-
src
# Host:\n
# Database: test\n
# Table: \'compatibility\'\n
#\n
CREATE TABLE `compatibility` (\n
`uid` int(11) NOT NULL,\n
`Creator` varchar(30) default \'\',\n
`Date` datetime default \'0000-00-00 00:00:00\',\n
`PrincipiaSearchSource` text,\n
`SearchableText` text,\n
`EffectiveDate` datetime default \'0000-00-00 00:00:00\',\n
`ExpiresDate` datetime default \'0000-00-00 00:00:00\',\n
`ModificationDate` datetime default \'0000-00-00 00:00:00\',\n
`Type` varchar(30) default \'\',\n
`bobobase_modification_time` datetime default \'0000-00-00 00:00:00\',\n
`created` datetime default \'0000-00-00 00:00:00\',\n
`effective` datetime default \'0000-00-00 00:00:00\',\n
`expires` datetime default \'0000-00-00 00:00:00\',\n
`getIcon` varchar(30) default \'\',\n
`in_reply_to` varchar(255) default \'\',\n
`modified` datetime default \'0000-00-00 00:00:00\',\n
`review_state` varchar(30) default \'\',\n
`summary` text,\n
PRIMARY KEY (`uid`),\n
KEY `Type` (`Type`),\n
KEY `review_state` (`review_state`)\n
) TYPE=InnoDB;
-
template
-
title
Products.ZSQLMethods.SQL
SQL
-
__ac_local_roles__
-
jp
Owner
-
_arg
-
_col
-
_owner
nexedi
acl_users
jp
-
arguments_src
-
connection_id
erp5_sql_connection
-
id
z_create_delivery
-
src
CREATE TABLE `delivery` (\n
`uid` int(11) default \'0\',\n
`source_uid` int(11) default \'0\',\n
`destination_uid` int(11) default \'0\',\n
`source_section_uid` int(11) default \'0\',\n
`destination_section_uid` int(11) default \'0\',\n
`resource_uid` int(11) default \'0\',\n
`start_date` datetime default NULL,\n
`stop_date` datetime default NULL,\n
KEY `uid` (`uid`),\n
KEY `source_uid` (`source_uid`),\n
KEY `destination_uid` (`destination_uid`),\n
KEY `source_section_uid` (`source_section_uid`),\n
KEY `destination_section_uid` (`destination_section_uid`),\n
KEY `resource_uid` (`resource_uid`)\n
) TYPE=InnoDB
-
template
-
title
Products.ZSQLMethods.SQL
SQL
-
__ac_local_roles__
-
alex
Owner
-
_arg
-
_col
-
_owner
nexedi
acl_users
jp
-
allow_simple_one_argument_traversal
-
arguments_src
-
cache_time_
0
-
class_file_
-
class_name_
-
connection_hook
-
connection_id
erp5_sql_connection
-
id
z_create_item
-
max_cache_
100
-
max_rows_
1000
-
src
# Host:\n
# Database: test\n
# Table: \'item\'\n
#\n
CREATE TABLE `item` (\n
`uid` int(11) default \'0\',\n
`date` datetime,\n
`node_uid` int(11) default \'0\',\n
`section_uid` int(11) default \'0\',\n
`resource_uid` int(11) default \'0\',\n
`aggregate_uid` int(11) default \'0\',\n
`variation_text` VARCHAR(100),\n
KEY `uid` (`uid`),\n
KEY `node_uid` (`node_uid`),\n
KEY `section_uid` (`section_uid`),\n
KEY `resource_uid` (`resource_uid`),\n
KEY `variation_text` (`variation_text`)\n
) TYPE=InnoDB;\n
-
template
-
title
Products.ZSQLMethods.SQL
SQL
-
__ac_local_roles__
-
alex
Owner
-
_arg
-
allow_simple_one_argument_traversal
-
arguments_src
-
cache_time_
0
-
class_file_
-
class_name_
-
connection_hook
-
connection_id
erp5_sql_connection
-
id
z_create_movement
-
max_cache_
100
-
max_rows_
1000
-
src
# Host:\n
# Database: test\n
# Table: \'movement\'\n
#\n
CREATE TABLE `movement` (\n
`uid` int(11) default \'0\',\n
`delivery_uid` int(11) default \'0\',\n
`source_uid` int(11) default \'0\',\n
`destination_uid` int(11) default \'0\',\n
`resource_uid` int(11) default \'0\',\n
`quantity` real default \'0.0\',\n
`inventory` real default NULL,\n
`start_date` datetime,\n
`stop_date` datetime,\n
`target_quantity` real default \'0.0\',\n
`target_start_date` datetime,\n
`target_stop_date` datetime,\n
`price` real,\n
`total_price` real,\n
`target_total_price` real,\n
`has_cell_content` bool,\n
`is_accountable` bool,\n
`is_orderable` bool,\n
`is_deliverable` bool,\n
`variation_text` VARCHAR(100),\n
KEY `uid` (`uid`),\n
KEY `delivery_uid` (`delivery_uid`),\n
KEY `source_uid` (`source_uid`),\n
KEY `destination_uid` (`destination_uid`),\n
KEY `resource_uid` (`resource_uid`),\n
KEY `has_cell_content` (`has_cell_content`),\n
KEY `is_accountable` (`is_accountable`),\n
KEY `is_orderable` (`is_orderable`),\n
KEY `is_deliverable` (`is_deliverable`),\n
KEY `variation_text` (`variation_text`)\n
) TYPE=InnoDB;\n
-
template
-
title
Products.ZSQLMethods.SQL
SQL
-
__ac_local_roles__
-
yo
Owner
-
_arg
-
_col
-
_owner
nexedi
acl_users
yo
-
arguments_src
-
connection_id
erp5_sql_connection
-
id
z_create_predicate
-
src
CREATE TABLE predicate (\n
uid INT,\n
`quantity` real ,\n
`quantity_min` real ,\n
`quantity_max` real ,\n
KEY `uid` (`uid`)\n
) TYPE=InnoDB;\n
-
template
-
title
Products.ZSQLMethods.SQL
SQL
-
__ac_local_roles__
-
yo
Owner
-
_arg
-
_col
-
_owner
nexedi
acl_users
yo
-
arguments_src
-
connection_id
erp5_sql_connection
-
id
z_create_predicate_category
-
src
CREATE TABLE `predicate_category` (\n
`uid` int(11) default \'0\',\n
`category_uid` int(11) default \'0\',\n
`base_category_uid` int(11) default \'0\',\n
`category_strict_membership` tinyint(1) default \'0\',\n
KEY `uid` (`uid`),\n
KEY `category_strict_membership` (`category_strict_membership`),\n
KEY `Membership` (`category_uid`,`base_category_uid`),\n
KEY `FuzzyMembership` (`category_uid`)\n
) TYPE = InnoDB
-
template
-
title
Products.ZSQLMethods.SQL
SQL
-
__ac_local_roles__
-
alex
Owner
-
_arg
-
allow_simple_one_argument_traversal
-
arguments_src
-
cache_time_
0
-
class_file_
-
class_name_
-
connection_hook
-
connection_id
erp5_sql_connection
-
id
z_create_roles_and_users
-
max_cache_
100
-
max_rows_
1000
-
src
CREATE TABLE roles_and_users (\n
uid INT,\n
allowedRolesAndUsers VARCHAR(40),\n
KEY `uid` (`uid`),\n
KEY `allowedRolesAndUsers` (`allowedRolesAndUsers`)\n
) TYPE=InnoDB;
-
template
-
title
Products.ZSQLMethods.SQL
SQL
-
__ac_local_roles__
-
alex
Owner
-
_arg
-
_col
-
allow_simple_one_argument_traversal
-
arguments_src
-
cache_time_
0
-
class_file_
-
class_name_
-
connection_hook
-
connection_id
erp5_sql_connection
-
id
z_create_stock
-
max_cache_
100
-
max_rows_
1000
-
src
# Host:\n
# Database: test\n
# Table: \'stock\'\n
#\n
CREATE TABLE `stock` (\n
`uid` int(11) NOT NULL default \'0\',\n
`node_uid` int(11),\n
`section_uid` int(11),\n
`payment_uid` int(11),\n
`mirror_section_uid` int(11),\n
`resource_uid` int(11),\n
`quantity` real ,\n
`date` datetime,\n
`price` real ,\n
`is_accountable` bool,\n
`portal_type` VARCHAR(30),\n
`simulation_state` varchar(30) default \'\',\n
`variation_text` VARCHAR(100),\n
KEY `uid` (`uid`),\n
KEY `quantity` (`quantity`),\n
KEY `section_uid` (`section_uid`),\n
KEY `mirror_section_uid` (`mirror_section_uid`),\n
KEY `node_uid` (`node_uid`),\n
KEY `payment_uid` (`payment_uid`),\n
KEY `resource_uid` (`resource_uid`),\n
KEY `simulation_state` (`simulation_state`),\n
KEY `resource_node_uid` (`resource_uid`, `node_uid`),\n
KEY `resource_section_node_uid` (`resource_uid`, `section_uid`, `node_uid`, `simulation_state`)\n
) TYPE = InnoDB;\n
-
template
-
title
Products.ZSQLMethods.SQL
SQL
-
__ac_local_roles__
-
alex
Owner
-
_arg
-
allow_simple_one_argument_traversal
-
arguments_src
-
cache_time_
0
-
class_file_
-
class_name_
-
connection_hook
-
connection_id
erp5_sql_connection
-
id
z_create_subject
-
max_cache_
100
-
max_rows_
1000
-
src
CREATE TABLE subject (\n
uid INT,\n
subject VARCHAR(255),\n
KEY `uid` (`uid`),\n
KEY `allowedRolesAndUsers` (`Subject`)\n
) TYPE=InnoDB;
-
template
-
title
Products.ZSQLMethods.SQL
SQL
-
__ac_local_roles__
-
alex
Owner
-
_arg
-
arguments_src
table_0
-
connection_id
erp5_sql_connection
-
id
z_related_mirror_section_uid_from_stock
-
src
.uid = stock.mirror_section_uid
]]>
-
template
-
title
Products.ZSQLMethods.SQL
SQL
-
__ac_local_roles__
-
alex
Owner
-
_arg
-
arguments_src
table_0
-
connection_id
erp5_sql_connection
-
id
z_related_node_uid_from_stock
-
src
.uid = stock.node_uid
]]>
-
template
-
title
Products.ZSQLMethods.SQL
SQL
-
__ac_local_roles__
-
alex
Owner
-
_arg
-
arguments_src
table_0
-
connection_id
erp5_sql_connection
-
id
z_related_payment_uid_from_stock
-
src
.uid = stock.payment_uid
]]>
-
template
-
title
Products.ZSQLMethods.SQL
SQL
-
__ac_local_roles__
-
yo
Owner
-
_arg
-
_owner
nexedi
acl_users
yo
-
arguments_src
table_0
-
connection_id
erp5_sql_connection
-
id
z_related_predicate
-
src
.uid = catalog.uid
]]>
-
template
-
title
Products.ZSQLMethods.SQL
SQL
-
__ac_local_roles__
-
alex
Owner
-
_arg
-
arguments_src
table_0\r\n
table_1
-
connection_id
cmf_activity_sql_connection
-
id
z_related_resource
-
src
.uid = catalog.uid\n
AND .uid = .resource_uid
]]>
-
template
-
title
Products.ZSQLMethods.SQL
SQL
-
__ac_local_roles__
-
alex
Owner
-
_arg
-
arguments_src
table_0
-
connection_id
erp5_sql_connection
-
id
z_related_resource_uid_from_stock
-
src
.uid = stock.resource_uid
]]>
-
template
-
title
Products.ZSQLMethods.SQL
SQL
-
__ac_local_roles__
-
alex
Owner
-
_arg
-
arguments_src
table_0
-
connection_id
erp5_sql_connection
-
id
z_related_section_uid_from_stock
-
src
.uid = stock.section_uid
]]>
-
template
-
title
Products.ZSQLMethods.SQL
SQL
-
__ac_local_roles__
-
alex
Owner
-
_arg
-
allow_simple_one_argument_traversal
-
arguments_src
table_0
-
cache_time_
0
-
class_file_
-
class_name_
-
connection_hook
-
connection_id
erp5_sql_connection
-
id
z_related_security
-
max_cache_
100
-
max_rows_
1000
-
src
.uid = catalog.security_uid
]]>
-
template
-
title
Products.ZSQLMethods.SQL
SQL
-
__ac_local_roles__
-
alex
Owner
-
_arg
-
arguments_src
table_0
-
connection_id
erp5_sql_connection
-
id
z_related_uid
-
src
.uid = catalog.uid
]]>
-
template
-
title
Products.ZSQLMethods.SQL
SQL
-
__ac_local_roles__
-
alex
Owner
-
_arg
-
allow_simple_one_argument_traversal
-
arguments_src
sort_on\r\n
query\r\n
parent_uid
-
cache_time_
10
-
class_file_
zsqlbrain.py
-
class_name_
ZSQLBrain
-
connection_hook
-
connection_id
erp5_sql_connection
-
id
z_search_folder
-
max_cache_
100
-
max_rows_
1000
-
src
\n
\n
SELECT DISTINCT catalog.* FROM catalog, category, roles_and_users WHERE catalog.uid=category.uid AND catalog.uid=roles_and_users.uid AND AND ORDER BY \n
\n
SELECT * FROM catalog WHERE ORDER BY \n
\n
\n
\n
SELECT DISTINCT catalog.* FROM catalog, category, roles_and_users WHERE AND catalog.uid=category.uid AND catalog.uid=roles_and_users.uid AND \n
\n
SELECT * FROM catalog WHERE \n
\n
]]>
-
template
-
title
Products.ZSQLMethods.SQL
SQL
-
__ac_local_roles__
-
alex
Owner
-
_arg
-
allow_simple_one_argument_traversal
-
arguments_src
selection\r\n
selection_domain\r\n
selection_report\r\n
where_expression\r\n
select_expression\r\n
from_table_list:list\r\n
sort_on\r\n
limit_expression
-
cache_time_
0
-
class_file_
zsqlbrain.py
-
class_name_
ZSQLBrain
-
connection_hook
-
connection_id
erp5_sql_connection
-
id
z_search_results
-
max_cache_
100
-
max_rows_
0
-
src
, \n
\n
FROM\n
AS ,\n
, \n
, \n
\n
WHERE \n
1 = 1 \n
\n
AND \n
\n
\n
AND \n
\n
\n
AND \n
\n
\n
ORDER BY\n
\n
\n
\n
LIMIT \n
\n
LIMIT 1000\n
\n
]]>
-
template
-
title
Products.ZSQLMethods.SQL
SQL
-
__ac_local_roles__
-
alex
Owner
-
_arg
-
allow_simple_one_argument_traversal
-
arguments_src
-
cache_time_
0
-
class_file_
-
class_name_
-
connection_hook
-
connection_id
erp5_sql_connection
-
id
z_show_category_columns
-
max_cache_
100
-
max_rows_
1000
-
src
show columns from category
-
template
-
title
Products.ZSQLMethods.SQL
SQL
-
__ac_local_roles__
-
alex
Owner
-
_arg
-
_owner
nexedi
acl_users
jp
-
allow_simple_one_argument_traversal
-
arguments_src
uid
-
cache_time_
0
-
class_file_
-
class_name_
-
connection_hook
-
connection_id
erp5_sql_connection
-
id
z_uncatalog_delivery
-
max_cache_
100
-
max_rows_
1000
-
src
]]>
-
template
-
title
Products.ZSQLMethods.SQL
SQL
-
__ac_local_roles__
-
alex
Owner
-
_arg
-
allow_simple_one_argument_traversal
-
arguments_src
uid
-
cache_time_
0
-
class_file_
-
class_name_
-
connection_hook
-
connection_id
erp5_sql_connection
-
id
z_uncatalog_object
-
max_cache_
100
-
max_rows_
1000
-
src
]]>
-
template
-
title
Products.ZSQLMethods.SQL
SQL
-
__ac_local_roles__
-
jp
Owner
-
_arg
-
_owner
nexedi
acl_users
jp
-
arguments_src
isDelivery\r\n
uid\r\n
getSourceUid\r\n
getDestinationUid\r\n
getSourceSectionUid\r\n
getDestinationSectionUid\r\n
getResourceUid\r\n
getStartDate\r\n
getStopDate\r\n
insert_catalog_line
-
connection_id
erp5_sql_connection
-
id
z_update_delivery
-
src
\n
INSERT INTO delivery(uid) VALUES ();\n
\n
\n
\n
\n
\n
UPDATE delivery SET\n
uid=,\n
source_uid=,\n
destination_uid=,\n
source_section_uid=,\n
destination_section_uid=,\n
resource_uid=,\n
start_date=,\n
stop_date=\n
WHERE \n
]]>
-
template
-
title
Products.ZSQLMethods.SQL
SQL
-
__ac_local_roles__
-
alex
Owner
-
_arg
-
allow_simple_one_argument_traversal
-
arguments_src
uid\r\n
security_uid\r\n
getPath\r\n
getRelativeUrl\r\n
getParentUid\r\n
id\r\n
CreationDate\r\n
getDescription\r\n
getTitle\r\n
meta_type\r\n
getPortalType\r\n
opportunity_state\r\n
getDefaultSourceReference\r\n
getDefaultDestinationReference\r\n
getDefaultSourceTitle\r\n
getDefaultDestinationTitle\r\n
getDefaultSourceSectionTitle\r\n
getDefaultDestinationSectionTitle\r\n
getDefaultCausalityId\r\n
getLocation\r\n
getEan13Code\r\n
getSimulationState\r\n
causality_state\r\n
discussion_state\r\n
invoice_state\r\n
getOrderId\r\n
validation_state\r\n
payment_state\r\n
event_state\r\n
getReference\r\n
getSourceReference\r\n
getDestinationReference\r\n
getStringIndex\r\n
getIntIndex\r\n
getFloatIndex\r\n
insert_catalog_line
-
cache_time_
0
-
class_file_
-
class_name_
-
connection_hook
-
connection_id
erp5_sql_connection
-
id
z_update_object
-
max_cache_
100
-
max_rows_
1000
-
src
\n
INSERT INTO catalog(uid) VALUES ();\n
\n
\n
\n
\n
UPDATE catalog SET uid=,\n
security_uid=,\n
path=,\n
relative_url=,\n
parent_uid=,\n
id=,\n
CreationDate=,\n
description=,\n
title=,\n
meta_type=,\n
portal_type=,\n
opportunity_state=,\n
default_source_reference=,\n
default_destination_reference=,\n
default_source_title=,\n
default_destination_title=,\n
default_source_section_title=,\n
default_destination_section_title=,\n
default_causality_id=,\n
location=,\n
ean13_code=,\n
validation_state=,\n
simulation_state=,\n
causality_state=,\n
discussion_state=,\n
payment_state=,\n
event_state=,\n
invoice_state=,\n
order_id=,\n
reference=,\n
source_reference=,\n
destination_reference=,\n
string_index=,\n
int_index=,\n
float_index=\n
WHERE \n
]]>
-
template
-
title