3 # Copyright (c) Cake Software Foundation, Inc. (http://cakefoundation.org)
5 # Licensed under The MIT License
6 # For full copyright and license information, please see the LICENSE.txt
7 # Redistributions of files must retain the above copyright notice.
8 # MIT License (http://www.opensource.org/licenses/mit-license.php)
11 id int(10) NOT NULL auto_increment,
12 locale varchar(6) NOT NULL,
13 model varchar(255) NOT NULL,
14 foreign_key int(10) NOT NULL,
15 field varchar(255) NOT NULL,
18 # UNIQUE INDEX I18N_LOCALE_FIELD(locale, model, foreign_key, field),
19 # INDEX I18N_LOCALE_ROW(locale, model, foreign_key),
20 # INDEX I18N_LOCALE_MODEL(locale, model),
21 # INDEX I18N_FIELD(model, foreign_key, field),
22 # INDEX I18N_ROW(model, foreign_key),
23 INDEX locale (locale),
25 INDEX row_id (foreign_key),