phpffcms / ffcms

Private/Migrations/install_commentpost_table-2016-12-04-15-32-37.php

<?php

use Ffcms\Core\Migrations\MigrationInterface;
use Ffcms\Core\Migrations\Migration;

/**
 * Class install_commentpost_table.
 */
class install_commentpost_table extends Migration implements MigrationInterface

PSR1 recommends that each class must be in a namespace of at least one level to avoid collisions.

{
    /**
     * Execute actions when migration is up
     * @return void
     */
    public function up()
    {
        $this->getSchema()->create('comment_posts', function($table) {
            $table->increments('id');
            $table->string('app_name');
            $table->integer('app_relation_id')->unsigned();
            $table->integer('user_id')->unsigned();
            $table->string('guest_name', 100);
            $table->text('message');
            $table->string('lang', 32)->default('en');
            $table->string('ip', 64)->default('127.0.0.1'); // ipv4 and ipv6 (32 chars + 7 digits is max)
            $table->boolean('moderate')->default(false);
            $table->timestamps();
        });
        parent::up();
    }

    /**
     * Seed created table via up() method with some data
     * @return void
     */
    public function seed() {}

    /**
     * Execute actions when migration is down
     * @return void
     */
    public function down()
    {
        $this->getSchema()->dropIfExists('comment_posts');
        parent::down();
    }
}