| 1 | # $Id: i18n.sql 7118 2008-06-04 20:49:29Z gwoo $ |
|---|
| 2 | # |
|---|
| 3 | # Copyright 2005-2008, Cake Software Foundation, Inc. |
|---|
| 4 | # 1785 E. Sahara Avenue, Suite 490-204 |
|---|
| 5 | # Las Vegas, Nevada 89104 |
|---|
| 6 | # |
|---|
| 7 | # Licensed under The MIT License |
|---|
| 8 | # Redistributions of files must retain the above copyright notice. |
|---|
| 9 | # http://www.opensource.org/licenses/mit-license.php The MIT License |
|---|
| 10 | |
|---|
| 11 | CREATE TABLE i18n ( |
|---|
| 12 | id int(10) NOT NULL auto_increment, |
|---|
| 13 | locale varchar(6) NOT NULL, |
|---|
| 14 | model varchar(255) NOT NULL, |
|---|
| 15 | foreign_key int(10) NOT NULL, |
|---|
| 16 | field varchar(255) NOT NULL, |
|---|
| 17 | content mediumtext, |
|---|
| 18 | PRIMARY KEY (id), |
|---|
| 19 | # UNIQUE INDEX I18N_LOCALE_FIELD(locale, model, foreign_key, field), |
|---|
| 20 | # INDEX I18N_LOCALE_ROW(locale, model, foreign_key), |
|---|
| 21 | # INDEX I18N_LOCALE_MODEL(locale, model), |
|---|
| 22 | # INDEX I18N_FIELD(model, foreign_key, field), |
|---|
| 23 | # INDEX I18N_ROW(model, foreign_key), |
|---|
| 24 | INDEX locale (locale), |
|---|
| 25 | INDEX model (model), |
|---|
| 26 | INDEX row_id (foreign_key), |
|---|
| 27 | INDEX field (field) |
|---|
| 28 | ); |
|---|
