Blame view

console/migrations/m160425_130026_create_feedback.php 1.06 KB
14a09168   Alex Savenko   init commit
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
32
33
34
35
36
37
38
  <?php

  

      use yii\db\Migration;

  

      /**

       * Handles the creation for table `feedback`.

       */

      class m160425_130026_create_feedback extends Migration

      {

  

          /**

           * @inheritdoc

           */

          public function up()

          {

              $this->createTable('feedback', [

                  'feedback_id' => $this->primaryKey(),

                  'name'        => $this->string()

                                        ->notNull(),

                  'phone'       => $this->string(),

                  'email'       => $this->string(),

                  'answer'      => $this->string()

                                        ->notNull(),

                  'file'        => $this->string(),

                  'date_add'    => $this->timestamp()

                                        ->notNull()

                                        ->defaultExpression('NOW()'),

              ]);

          }

  

          /**

           * @inheritdoc

           */

          public function down()

          {

              $this->dropTable('feedback');

          }

      }