Blame view

console/migrations/m160425_130026_create_feedback.php 1.02 KB
eb780746   Yarik   test
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
  <?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(),
70d00c60   Yarik   test
25
26
27
                  'date_add'    => $this->timestamp()
                                        ->notNull()
                                        ->defaultExpression('NOW()'),
eb780746   Yarik   test
28
29
30
31
32
33
34
35
36
37
38
              ]);
          }
  
          /**
           * @inheritdoc
           */
          public function down()
          {
              $this->dropTable('feedback');
          }
      }