| 16591 |
anikendra |
1 |
# $Id$
|
|
|
2 |
#
|
|
|
3 |
# Copyright (c) Cake Software Foundation, Inc. (http://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 (http://www.opensource.org/licenses/mit-license.php)
|
|
|
9 |
|
|
|
10 |
CREATE 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 |
);
|