<?php

use Phinx\Migration\AbstractMigration;
use Phinx\Db\Adapter\MysqlAdapter;
class SocialPostingUsers extends AbstractMigration
{
public function up()
{
    $table = $this->table('users');

    $table->addColumn(
        'useTwitter',
        'boolean',
        [
            'default' => 0,
            'null'    => false
        ]
    );

    $table->addColumn(
        'twitterApiKey',
        'text',
        [
            'null' => false
        ]
    );

    $table->addColumn(
        'twitterApiSecret',
        'text',
        [
            'null' => false
        ]
    );

    $table->addColumn(
        'twitterTokenKey',
        'text',
        [
            'null' => false
        ]
    );

    $table->addColumn(
        'twitterTokenSecret',
        'text',
        [
            'null' => false
        ]
    );

    $table->addColumn(
        'useVkontakte',
        'boolean',
        [
            'null'    => false,
            'default' => '0'
        ]
    );

    $table->addColumn(
        'vkontakteApplicationId',
        'text',
        [
            'null' => false
        ]
    );

    $table->addColumn(
        'vkontakteToken',
        'text',
        [
            'null' => false
        ]
    );

    $table->addColumn(
        'vkontakteUserId',
        'text',
        [
            'null' => false
        ]
    );

    $table->addColumn(
        'vkontakteFromGroup',
        'boolean',
        [
            'null' => false,
            'default' => '0'
        ]
    );

    $table->addColumn(
        'post_for_sale',
        'integer',
        [
            'null' => false,
            'default' => '0',
            'limit' => MysqlAdapter::INT_TINY
        ]
    );

    $table->addColumn(
        'post_for_rent',
        'integer',
        [
            'null' => false,
            'default' => '0',
            'limit' => MysqlAdapter::INT_TINY
        ]
    );

    $table->addColumn(
        'post_buy',
        'integer',
        [
            'null' => false,
            'default' => '0',
            'limit' => MysqlAdapter::INT_TINY
        ]
    );

    $table->addColumn(
        'post_rent',
        'integer',
        [
            'null' => false,
            'default' => '0',
            'limit' => MysqlAdapter::INT_TINY
        ]
    );

    $table->addColumn(
        'post_exchange',
        'integer',
        [
            'null' => false,
            'default' => '0',
            'limit' => MysqlAdapter::INT_TINY
        ]
    );

    $table->addColumn(
        'post_time',
        'integer',
        [
            'null' => false,
            'default' => '12'
        ]
    );

    $table->save();
}

public function down()
	{
		$table = $this->table('users');
		$table->removeColumn('useTwitter');
		$table->removeColumn('twitterApiKey');
		$table->removeColumn('twitterApiSecret');
		$table->removeColumn('twitterTokenKey');
		$table->removeColumn('twitterTokenSecret');
		$table->removeColumn('useVkontakte');
		$table->removeColumn('vkontakteApplicationId');
		$table->removeColumn('vkontakteToken');
		$table->removeColumn('vkontakteUserId');
		$table->removeColumn('vkontakteFromGroup');
		$table->removeColumn('post_for_sale');
		$table->removeColumn('post_for_rent');
		$table->removeColumn('post_buy');
		$table->removeColumn('post_rent');
		$table->removeColumn('post_exchange');
		$table->removeColumn('post_time');
		$table->save();
	}
}