Development

HowToUse18NOverMysql (diff)

You must first sign up to be able to contribute.

Changes from Version 1 of HowToUse18NOverMysql

Show
Ignore:
Author:
Gregory (IP: 82.239.76.51)
Timestamp:
07/24/06 00:22:38 (11 years ago)
Comment:

initial commit. May change if code is correct.

Legend:

Unmodified
Added
Removed
Modified
  • HowToUse18NOverMysql

    v0 v1  
     1Database Structure : 
     2 
     3{{{ 
     4# Table structure for table `catalogue` 
     5# 
     6 
     7CREATE TABLE `catalogue` ( 
     8`cat_id` int(11) NOT NULL AUTO_INCREMENT, 
     9`name` varchar(100) NOT NULL DEFAULT '', 
     10`source_lang` varchar(100) NOT NULL DEFAULT '', 
     11`target_lang` varchar(100) NOT NULL DEFAULT '', 
     12`date_created` int(11) NOT NULL DEFAULT '0', 
     13`date_modified` int(11) NOT NULL DEFAULT '0', 
     14`author` varchar(255) NOT NULL DEFAULT '', 
     15PRIMARY KEY (`cat_id`) 
     16) TYPE=MyISAM AUTO_INCREMENT=4 ; 
     17 
     18# -------------------------------------------------------- 
     19 
     20# 
     21# Table structure for table `trans_unit` 
     22# 
     23 
     24CREATE TABLE `trans_unit` ( 
     25`msg_id` int(11) NOT NULL AUTO_INCREMENT, 
     26`cat_id` int(11) NOT NULL DEFAULT '1', 
     27`id` varchar(255) NOT NULL DEFAULT '', 
     28`source` text NOT NULL, 
     29`target` text NOT NULL, 
     30`comments` text NOT NULL, 
     31`date_added` int(11) NOT NULL DEFAULT '0', 
     32`date_modified` int(11) NOT NULL DEFAULT '0', 
     33`author` varchar(255) NOT NULL DEFAULT '', 
     34`translated` tinyint(1) NOT NULL DEFAULT '0', 
     35PRIMARY KEY (`msg_id`) 
     36) TYPE=MyISAM AUTO_INCREMENT=6 ; 
     37}}} 
     38 
     39Configuration : 
     40 
     41For a project wide configuration, you may put the following code in /config/i18n.yml. 
     42For 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). 
     43 
     44{{{ 
     45all: 
     46  default_culture: en_GB 
     47  source: MySQL 
     48  database: mysql://user:pass@server/database 
     49}}}