1# $Id$ 2# 3# Copyright (c) Cake Software Foundation, Inc. (https://cakefoundation.org) 4# 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 (https://opensource.org/licenses/mit-license.php) 9 10CREATE TABLE i18n ( 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, 16 content mediumtext, 17 PRIMARY KEY (id), 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), 24 INDEX model (model), 25 INDEX row_id (foreign_key), 26 INDEX field (field) 27);