Development

HowToUse18NOverMysql

You must first sign up to be able to contribute.

Database Structure :

# Table structure for table `catalogue`
#

CREATE TABLE `catalogue` (
`cat_id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(100) NOT NULL DEFAULT '',
`source_lang` varchar(100) NOT NULL DEFAULT '',
`target_lang` varchar(100) NOT NULL DEFAULT '',
`date_created` int(11) NOT NULL DEFAULT '0',
`date_modified` int(11) NOT NULL DEFAULT '0',
`author` varchar(255) NOT NULL DEFAULT '',
PRIMARY KEY (`cat_id`)
) TYPE=MyISAM AUTO_INCREMENT=4 ;

# --------------------------------------------------------

#
# Table structure for table `trans_unit`
#

CREATE TABLE `trans_unit` (
`msg_id` int(11) NOT NULL AUTO_INCREMENT,
`cat_id` int(11) NOT NULL DEFAULT '1',
`id` varchar(255) NOT NULL DEFAULT '',
`source` text NOT NULL,
`target` text NOT NULL,
`comments` text NOT NULL,
`date_added` int(11) NOT NULL DEFAULT '0',
`date_modified` int(11) NOT NULL DEFAULT '0',
`author` varchar(255) NOT NULL DEFAULT '',
`translated` tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`msg_id`)
) TYPE=MyISAM AUTO_INCREMENT=6 ;

Configuration :

For a project wide configuration, you may put the following code in /config/i18n.yml. For an application configuration, you may put the following code in /apps/your-app/config/i18n.yml (this will override /config/i18n.yml for the application).

all:
  default_culture: en_GB
  source: MySQL
  database: mysql://user:pass@server/database