$version
$version : float
Abstract Migration Class.
It is expected that the migrations you write extend from this class.
This abstract class proxies the various database methods to your specified adapter.
$adapter : \Phinx\Db\Adapter\AdapterInterface
$output : \think\console\Output
$input : \think\console\Input
table(string $tableName, array $options = array()) : \Phinx\Db\Table
Returns an instance of the <code>\Table</code> class.
You can use this class to create and manipulate tables.
string | $tableName | Table Name |
array | $options | Options |
__construct(integer $version, \think\console\Input|null $input = null, \think\console\Output|null $output = null)
Class Constructor.
integer | $version | Migration Version |
\think\console\Input|null | $input | |
\think\console\Output|null | $output |
up()
Change Method.
Write your reversible migrations using this method.
More information on writing migrations is available here: http://docs.phinx.org/en/latest/migrations.html#the-abstractmigration-class
The following commands can be used in this method and Phinx will automatically reverse them when rolling back:
createTable renameTable addColumn renameColumn addIndex addForeignKey
Remember to call "create()" or "update()" and NOT "save()" when working with the Table class.
setAdapter(\Phinx\Db\Adapter\AdapterInterface $adapter) : \Phinx\Migration\MigrationInterface
Sets the database adapter.
\Phinx\Db\Adapter\AdapterInterface | $adapter | Database Adapter |
getAdapter() : \Phinx\Db\Adapter\AdapterInterface
Gets the database adapter.
setInput(\think\console\Input $input) : \Phinx\Migration\MigrationInterface
Sets the input object to be used in migration object
\think\console\Input | $input |
getInput() : \think\console\Input
Gets the input object to be used in migration object
setOutput(\think\console\Output $output) : \Phinx\Migration\MigrationInterface
Sets the output object to be used in migration object
\think\console\Output | $output |
getOutput() : \think\console\Output
Gets the output object to be used in migration object
setVersion(float $version) : \Phinx\Migration\MigrationInterface
Sets the migration version number.
float | $version | Version |
<?php
use think\migration\Migrator;
use think\migration\db\Column;
class Member extends Migrator
{
/**
* Change Method.
*
* Write your reversible migrations using this method.
*
* More information on writing migrations is available here:
* http://docs.phinx.org/en/latest/migrations.html#the-abstractmigration-class
*
* The following commands can be used in this method and Phinx will
* automatically reverse them when rolling back:
*
* createTable
* renameTable
* addColumn
* renameColumn
* addIndex
* addForeignKey
*
* Remember to call "create()" or "update()" and NOT "save()" when working
* with the Table class.
*/
public function up()
{
// 定义数据表名称
$table = $this->table('admin');
// 添加当前表字段
$table
->addColumn('xingming','string',['limit'=>15,'null'=>false,'default'=>'a','comment'=>'用户姓名'])
->addColumn('sex','boolean',['limit'=>1,'default'=>'2','null'=>false,'default'=>2,'comment'=>'0=女,1=男,2=未知'])
->addColumn('shengri','integer',['limit'=>11,'null'=>true,'comment'=>'出生日期'])
->addColumn('username','string',['limit'=>20,'null'=>false,'default'=>'a','comment'=>'用户帐号'])
->addColumn('password','string',['limit'=>137,'null'=>false,'default'=>'$apr1$RSUodBwI$zOhVq9RQWfQDOW2sbeCDS1','comment'=>'登录密码'])
->addColumn('teacher_id','string',['limit'=>11,'null'=>true,'comment'=>'教师编号'])
->addColumn('school_id','integer',['limit'=>11,'null'=>false,'default'=>0,'comment'=>'所在单位'])
->addColumn('phone','string',['limit'=>11,'null'=>true,'comment'=>'联系方式'])
->addColumn('denglucishu','integer',['limit'=>5,'default'=>0,'null'=>false,'comment'=>'登录次数'])
->addColumn('lastip','string',['limit'=>55,'default'=>'127.0.0.1','null'=>false,'comment'=>'最后一次登录IP'])
->addColumn('ip','string',['limit'=>55,'default'=>'127.0.0.1','null'=>false,'comment'=>'登录IP'])
->addColumn('lasttime','integer',['limit'=>11,'default'=>'0','null'=>false,'comment'=>'最后登录时间'])
->addColumn('thistime','integer',['limit'=>11,'default'=>'0','null'=>false,'comment'=>'本次登录时间'])
->addColumn('status','boolean',['limit'=>1,'default'=>'1','null'=>false,'comment'=>'0=禁用,1=正常'])
->addColumn('create_time','integer',['limit'=>11,'default'=>'1539158918','null'=>false,'comment'=>'创建时间'])
->addColumn('update_time','integer',['limit'=>11,'default'=>'1539158918','null'=>false,'comment'=>'更新时间'])
->addColumn('delete_time','integer',['limit'=>11,'null'=>true,'comment'=>'删除时间'])
->addColumn('beizhu','string',['limit'=>80,'null'=>true,'comment'=>'备注'])
->addIndex(array('username'), array('unique' => true))
->create();
}
}