i18n.sql 668 B

12345678910111213141516171819
  1. # Copyright (c) Cake Software Foundation, Inc. (http://cakefoundation.org)
  2. #
  3. # Licensed under The MIT License
  4. # For full copyright and license information, please see the LICENSE.txt
  5. # Redistributions of files must retain the above copyright notice.
  6. # MIT License (http://www.opensource.org/licenses/mit-license.php)
  7. CREATE TABLE i18n (
  8. id int NOT NULL auto_increment,
  9. locale varchar(6) NOT NULL,
  10. model varchar(255) NOT NULL,
  11. foreign_key int(10) NOT NULL,
  12. field varchar(255) NOT NULL,
  13. content text,
  14. PRIMARY KEY (id),
  15. UNIQUE INDEX I18N_LOCALE_FIELD(locale, model, foreign_key, field),
  16. INDEX I18N_FIELD(model, foreign_key, field)
  17. );