dbschema.ini [mysql] #

The block [mysql] of settings/dbschema.ini, with 1 setting(s).

RDBMS specific schema transformation rules

Syntax:
[RDBMSName]

Column name transformation: #

maps the schema field name to a different column name, to avoid identifier length or reserved keywords issues #

ColumnNameTranslation[table.column]=transformedColumnName

Column type transformation: #

overrides the default field type mapping, so that a different type mapping can be used when required, #

for instance longtext;varchar2(4000) for oracle if GROUP BY is required on a field #

ColumnTypeTranslation[table.column]=sourceType;targetType

Column options #

Only NULL is supported now, for ezoracle. Removes the NOT NULL option Oracle does not support if set. #

ColumnOptionTranslations[table.column]=options

Index name translation #

Maps a different index name, to avoid index identifiers length limitation issues on some RDBMS. #

IndexNameTranslation[table.indexName]=newIndexName
Transformation rules specific to MySQL

Never edit settings/dbschema.ini itself: an update replaces it. Put the settings you change in an override, which wins over the shipped file:

• settings/override/dbschema.ini.append.php for every siteaccess,
• settings/siteaccess/<siteaccess>/dbschema.ini.append.php for one siteaccess,
• extension/<extension>/settings/dbschema.ini.append.php in an extension (read when the extension is active).

IndexTranslation #

Since we do not store length information fields in indexes yet we
need to add/remove them for MySQL.

Default: a hash of 17: ezimagefile.ezimagefile_file=filepath.mysql:length/200, eztrigger.eztrigger_fetch=name.mysql:length/25;module_name.mysql:length/50;function_name.mysql:length/50, ezurlalias.ezurlalias_desturl=destination_url.mysql:length/200, ezurlalias.ezurlalias_source_url=source_url.mysql:length/255, ezcontentobject_tree.ezcontentobject_tree_path_ident=path_identification_string.mysql:length/50, ezcontentobject_trash.ezcobj_trash_path_ident=path_identification_string.mysql:length/50, ezimagefile.ezimagefile_file=filepath.mysql:length/200, eztrigger.eztrigger_fetch=name.mysql:length/25;module_name.mysql:length/50;function_name.mysql:length/50, eztrigger.eztrigger_def_id=module_name.mysql:length/50;function_name.mysql:length/50, ezurlalias.ezurlalias_desturl=destination_url.mysql:length/200, ezurlalias.ezurlalias_source_url=source_url.mysql:length/255, ezurlalias_ml.ezurlalias_ml_text=text.mysql:length/32 ....

<?php /* #?ini charset="utf-8"?
# settings/override/dbschema.ini.append.php
[mysql]
# an empty "IndexTranslation[]" first replaces the shipped list; without it the items are added
IndexTranslation[]
IndexTranslation[ezimagefile.ezimagefile_file]=filepath.mysql:length/200
IndexTranslation[eztrigger.eztrigger_fetch]=name.mysql:length/25;module_name.mysql:length/50;function_name.mysql:length/50
IndexTranslation[ezurlalias.ezurlalias_desturl]=destination_url.mysql:length/200
IndexTranslation[ezurlalias.ezurlalias_source_url]=source_url.mysql:length/255
IndexTranslation[ezcontentobject_tree.ezcontentobject_tree_path_ident]=path_identification_string.mysql:length/50
IndexTranslation[ezcontentobject_trash.ezcobj_trash_path_ident]=path_identification_string.mysql:length/50
IndexTranslation[ezimagefile.ezimagefile_file]=filepath.mysql:length/200
IndexTranslation[eztrigger.eztrigger_fetch]=name.mysql:length/25;module_name.mysql:length/50;function_name.mysql:length/50
IndexTranslation[eztrigger.eztrigger_def_id]=module_name.mysql:length/50;function_name.mysql:length/50
IndexTranslation[ezurlalias.ezurlalias_desturl]=destination_url.mysql:length/200
IndexTranslation[ezurlalias.ezurlalias_source_url]=source_url.mysql:length/255
IndexTranslation[ezurlalias_ml.ezurlalias_ml_text]=text.mysql:length/32
IndexTranslation[ezurlalias_ml.ezurlalias_ml_text_lang]=text.mysql:length/32
IndexTranslation[ezurlalias_ml.ezurlalias_ml_par_lnk_txt]=text.mysql:length/32
IndexTranslation[ezurlalias_ml.ezurlalias_ml_par_act_id_lnk]=action.mysql:length/32
IndexTranslation[ezurlalias_ml.ezurlalias_ml_act_org]=action.mysql:length/32
IndexTranslation[ezurl.ezurl_url]=url.mysql:length/255
*/ ?>

Related #

• All blocks of dbschema.ini
• All INI files
• The settings page

Generated by ./console exp:help:examples from settings/dbschema.ini. Do not edit this page: change the source and generate again (how). Free documentation: GFDL 1.3 or later.