| 1234567891011121314151617181920212223242526 |
- # $Id$
- #
- # Copyright 2005-2012, Cake Software Foundation, Inc.
- #
- # Licensed under The MIT License
- # Redistributions of files must retain the above copyright notice.
- # MIT License (http://www.opensource.org/licenses/mit-license.php)
- CREATE TABLE i18n (
- id int(10) NOT NULL auto_increment,
- locale varchar(6) NOT NULL,
- model varchar(255) NOT NULL,
- foreign_key int(10) NOT NULL,
- field varchar(255) NOT NULL,
- content mediumtext,
- PRIMARY KEY (id),
- # UNIQUE INDEX I18N_LOCALE_FIELD(locale, model, foreign_key, field),
- # INDEX I18N_LOCALE_ROW(locale, model, foreign_key),
- # INDEX I18N_LOCALE_MODEL(locale, model),
- # INDEX I18N_FIELD(model, foreign_key, field),
- # INDEX I18N_ROW(model, foreign_key),
- INDEX locale (locale),
- INDEX model (model),
- INDEX row_id (foreign_key),
- INDEX field (field)
- );
|
