$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 JsRongyuInfo 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('js_rongyu_info');
// 添加当前表字段
$table
->addColumn('title','string',['limit'=>100,'default'=>'a','null'=>false,'comment'=>'获奖内容标题'])
->addColumn('rongyuce_id','integer',['limit'=>11,'default'=>0,'null'=>false,'comment'=>'荣誉册'])
->addColumn('bianhao','string',['limit'=>15,'null'=>true,'comment'=>'证书编号'])
->addColumn('hjschool_id','integer',['limit'=>11,'null'=>true,'comment'=>'证书所属单位'])
->addColumn('subject_id','integer',['limit'=>11,'null'=>true,'comment'=>'所属学科'])
->addColumn('jiangxiang_id','integer',['limit'=>11,'null'=>true,'comment'=>'荣誉奖项'])
->addColumn('pic','string',['limit'=>100,'null'=>true,'comment'=>'证书图片'])
->addColumn('hjshijian','integer',['limit'=>11,'null'=>true,'comment'=>'获奖时间'])
->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('status','boolean',['limit'=>1,'default'=>'1','null'=>false,'comment'=>'0=禁用,1=正常'])
->create();
}
}