[Sommaire] [Imprimer]

   1  #?ini charset="iso-8859-1"?
   2  # eZ publish configuration file.
   3  #
   4  # NOTE: It is not recommended to edit this files directly, instead
   5  #       a file in override should be created for setting the
   6  #       values that is required for your site. Either create
   7  #       a file called settings/override/dbschema.ini.append or
   8  #       settings/override/dbschema.ini.append.php for more security
   9  #       in non-virtualhost modes (the .php file may already be present
  10  #       and can be used for this purpose).
  11  
  12  [SchemaSettings]
  13  SchemaPaths[]
  14  SchemaPaths[mysql]=lib/ezdbschema/classes/ezmysqlschema.php
  15  SchemaPaths[postgresql]=lib/ezdbschema/classes/ezpgsqlschema.php
  16  
  17  SchemaHandlerClasses[]
  18  SchemaHandlerClasses[mysql]=eZMysqlSchema
  19  SchemaHandlerClasses[postgresql]=eZPgsqlSchema
  20  
  21  [LintChecker]
  22  # Limitations on names and identifiers in the database
  23  # In general they should not exceed 30 which is the limit of Oracle
  24  
  25  # Table name limit, is 30 minus 4, this reserves room for suffixes
  26  TableLimit=26
  27  FieldLimit=30
  28  IndexLimit=30
  29  
  30  # A list of tables which do not get their names checked.
  31  # These are tables which are already in eZ publish and
  32  # cannot be changed in the 3.x series.
  33  # They all have workarounds for the various DB handlers.
  34  #
  35  # Each entry is the table name
  36  # e.g ezuser
  37  IgnoredTables[]
  38  IgnoredTables[]=ezcollab_item_participant_link
  39  IgnoredTables[]=ezgeneral_digest_user_settings
  40  IgnoredTables[]=eznotificationcollection_item
  41  IgnoredTables[]=ezproductcollection_item_opt
  42  IgnoredTables[]=ezsubtree_notification_rule
  43  
  44  # A list of table + fields which do not get their names checked.
  45  # These are fields which are already in eZ publish and
  46  # cannot be changed in the 3.x series.
  47  # They all have workarounds for the various DB handlers.
  48  #
  49  # Each entry is the table name, a dot and the field name
  50  # e.g ezuser.login
  51  IgnoredFields[]
  52  IgnoredFields[]=ezenumobjectvalue.contentobject_attribute_version
  53  IgnoredFields[]=ezurl_object_link.contentobject_attribute_version
  54  
  55  # A list of table + fields which do not get their syntax checked.
  56  # These are fields which are already in eZ publish and
  57  # cannot be changed in the 3.x series.
  58  # They all have workarounds for the various DB handlers.
  59  #
  60  # Each entry is the table name, a dot and the field name
  61  # e.g ezuser.login
  62  IgnoredFieldSyntax[]
  63  
  64  # A list of indexes which do not get their names checked.
  65  # These are indexes which are already in eZ publish and
  66  # cannot be changed in the 3.x series.
  67  # They all have workarounds for the various DB handlers.
  68  #
  69  # Each entry is the index name
  70  # e.g ezuser_role
  71  IgnoredIndexes[]
  72  IgnoredIndexes[]=ezcontentobject_attribute_co_id_ver_lang_code
  73  IgnoredIndexes[]=ezcontentobject_attribute_contentobject_id
  74  IgnoredIndexes[]=ezcontentobject_attribute_language_code
  75  IgnoredIndexes[]=ezcontentobject_tree_path_ident
  76  IgnoredIndexes[]=ezcobj_trash_path_ident
  77  IgnoredIndexes[]=ezenumobjectvalue_co_attr_id_co_attr_ver
  78  IgnoredIndexes[]=ezenumvalue_co_cl_attr_id_co_class_att_ver
  79  IgnoredIndexes[]=ezmodule_run_workflow_process_id_s
  80  IgnoredIndexes[]=ezoperation_memento_memento_key_main
  81  IgnoredIndexes[]=ezproductcollection_item_contentobject_id
  82  IgnoredIndexes[]=ezproductcollection_item_productcollection_id
  83  IgnoredIndexes[]=ezproductcollection_item_opt_item_id
  84  IgnoredIndexes[]=ezsearch_object_word_link_frequency
  85  IgnoredIndexes[]=ezsearch_object_word_link_identifier
  86  IgnoredIndexes[]=ezsearch_object_word_link_integer_value
  87  IgnoredIndexes[]=ezsearch_object_word_link_object
  88  IgnoredIndexes[]=ezsubtree_notification_rule_user_id
  89  IgnoredIndexes[]=ezwaituntildateevalue_wf_ev_id_wf_ver
  90  
  91  # Mapping of long words to short words
  92  # This will be used whenever an identifier or name is to long
  93  # each entry will be tried in order until the string is short enough.
  94  # e.g. NameMap[notification]=notif
  95  NameMap[]
  96  # combined words that are really shortened
  97  NameMap[enumobjectvalue]=enov
  98  NameMap[enumvalue]=env
  99  NameMap[waituntildateeval]=wude
 100  NameMap[co_cl_attr_id_co_class_att_ver]=ccai_ccav
 101  
 102  # General word shortening
 103  NameMap[contentobject]=cobj
 104  NameMap[content]=co
 105  NameMap[object]=obj
 106  NameMap[attribute]=attr
 107  NameMap[version]=ver
 108  NameMap[notification]=notif
 109  NameMap[collection]=coll
 110  NameMap[workflow]=wflw
 111  NameMap[product]=prod
 112  NameMap[participant]=part
 113  NameMap[process]=prcs
 114  NameMap[operation]=op
 115  NameMap[memento]=mem
 116  NameMap[search]=src
 117  NameMap[integer]=int
 118  NameMap[frequency]=frq
 119  NameMap[general]=gen
 120  NameMap[module]=mod
 121  NameMap[value]=val
 122  NameMap[link]=lnk
 123  NameMap[user]=usr
 124  NameMap[lang]=lng
 125  
 126  # Transformation rules specific to MySQL
 127  [mysql]
 128  # Since we do not store length information fields in indexes yet we
 129  # need to add/remove them for MySQL.
 130  IndexTranslation[ezimagefile.ezimagefile_file]=filepath.mysql:length/200
 131  IndexTranslation[eztrigger.eztrigger_fetch]=name.mysql:length/25;module_name.mysql:length/50;function_name.mysql:length/50
 132  IndexTranslation[ezurlalias.ezurlalias_desturl]=destination_url.mysql:length/200
 133  IndexTranslation[ezurlalias.ezurlalias_source_url]=source_url.mysql:length/255
 134  IndexTranslation[ezcontentobject_tree.ezcontentobject_tree_path_ident]=path_identification_string.mysql:length/50
 135  IndexTranslation[ezcontentobject_trash.ezcobj_trash_path_ident]=path_identification_string.mysql:length/50
 136  IndexTranslation[ezimagefile.ezimagefile_file]=filepath.mysql:length/200
 137  IndexTranslation[eztrigger.eztrigger_fetch]=name.mysql:length/25;module_name.mysql:length/50;function_name.mysql:length/50
 138  IndexTranslation[eztrigger.eztrigger_def_id]=module_name.mysql:length/50;function_name.mysql:length/50
 139  IndexTranslation[ezurlalias.ezurlalias_desturl]=destination_url.mysql:length/200
 140  IndexTranslation[ezurlalias.ezurlalias_source_url]=source_url.mysql:length/255
 141  
 142  # Make sure this table has delayed key write set when dumping SQL