ApiAdmin/database/migrations/20200318085203_change_admin_menu_field.php
2020-10-13 17:31:18 +08:00

68 lines
2.5 KiB
PHP
Raw Permalink Blame History

This file contains ambiguous Unicode characters

This file contains Unicode characters that might be confused with other characters. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.

<?php
use think\migration\Migrator;
use Phinx\Db\Adapter\MysqlAdapter;
class ChangeAdminMenuField 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() {
$this->table('admin_menu')
->renameColumn('hide', 'show')
->renameColumn('name', 'title')
->changeColumn('level', 'integer', [
'limit' => MysqlAdapter::INT_TINY,
'default' => 1,
'comment' => '菜单层级,1-一级菜单,2-二级菜单,3-按钮'
])->changeColumn('auth', 'integer', [
'limit' => MysqlAdapter::INT_TINY,
'default' => 1,
'comment' => '是否需要登录才可以访问,1-需要,0-不需要'
])->changeColumn('show', 'integer', [
'limit' => MysqlAdapter::INT_TINY,
'default' => 1,
'comment' => '是否显示,1-显示,0-隐藏'
])->addColumn('component', 'string', [
'limit' => 255,
'default' => '',
'comment' => '前端组件'
])->addColumn('router', 'string', [
'limit' => 255,
'default' => '',
'comment' => '前端路由'
])->addColumn('log', 'integer', [
'limit' => MysqlAdapter::INT_TINY,
'default' => 1,
'comment' => '是否记录日志,1-记录,0-不记录'
])->addColumn('permission', 'integer', [
'limit' => MysqlAdapter::INT_TINY,
'default' => 1,
'comment' => '是否验证权限,1-鉴权,0-放行'
])->addColumn('method', 'integer', [
'limit' => MysqlAdapter::INT_TINY,
'default' => 1,
'comment' => '请求方式,1-GET, 2-POST, 3-PUT, 4-DELETE'
])->update();
}
}