Yarik / artbox1

Blame view

console/migrations/m160930_133757_create_service_lang_table.php 1.74 KB
Edit Raw Normal View History
d55d2fe0   Yarik   Multilanguage 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
 
  <?php
      
      use yii\db\Migration;
      
      /**
       * Handles the creation for table `service_lang`.
       */
      class m160930_133757_create_service_lang_table extends Migration
      {
          
          /**
           * @inheritdoc
           */
          public function up()
          {
4428da8c   Yarik   Almost all databa... 
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
 
              $this->createTable(
                  'service_lang',
                  [
                      'service_id'       => $this->integer()
                                                 ->notNull(),
                      'language_id'      => $this->integer()
                                                 ->notNull(),
                      'title'            => $this->string()
                                                 ->notNull(),
                      'body'             => $this->text()
                                                 ->notNull(),
                      'seo_text'         => $this->text(),
                      'meta_title'       => $this->string(),
                      'meta_description' => $this->string(),
                      'h1'               => $this->string(),
                  ]
              );
              $this->createIndex(
                  'service_lang_service_language_key',
                  'service_lang',
                  [
                      'service_id',
                      'language_id',
                  ],
                  true
              );
d55d2fe0   Yarik   Multilanguage 
42
4428da8c   Yarik   Almost all databa... 
43
 
              $this->addForeignKey('service_fk', 'service_lang', 'service_id', 'service', 'id', 'CASCADE', 'CASCADE');
8af13427   Yarik   For leha commit. 
44
 
              $this->addForeignKey('language_fk', 'service_lang', 'language_id', 'language', 'id', 'RESTRICT', 'CASCADE');
d55d2fe0   Yarik   Multilanguage 
45
46
47
48
49
50
51
52
53
54
 
          }
          
          /**
           * @inheritdoc
           */
          public function down()
          {
              $this->dropTable('service_lang');
          }
      }