db/migrations/1.201_i18n_content.php


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31

<?php

class I18nContent extends Migration
{
    public function description()
    {
        return 'Add database table for multi-language content';
    }

    public function up()
    {
        $db = DBManager::get();

        $db->exec("CREATE TABLE IF NOT EXISTS `i18n` (
                   `object_id` varchar(32) NOT NULL,
                   `table` varchar(255) NOT NULL,
                   `field` varchar(255) NOT NULL,
                   `lang` varchar(32) NOT NULL,
                   `value` text,
                   PRIMARY KEY (`object_id`,`table`,`field`,`lang`)
                   ) ENGINE=InnoDB ROW_FORMAT=DYNAMIC");

    }

    public function down()
    {
        $db = DBManager::get();

        $db->exec('DROP TABLE IF EXISTS i18n');
    }
}