<?php
use think\migration\Migrator;
use think\migration\db\Column;
use app\model\CustomerPortraitField;

class CreateRenovatePriceTable extends Migrator
{

    public function change()
    {
        $this->table('renovate_price')
        ->addColumn('root_id', 'integer', ['comment'=>'企业id', 'limit'=>11, 'default'=>0])
        ->addColumn('package_name', 'string', ['comment'=>'套餐名称', 'limit'=>255, 'null'=>true])
        ->addColumn(Column::decimal('service_price',10)->setComment('服务费')->setDefault(0))
        ->addColumn(Column::decimal('devise_price',10)->setComment('设计费')->setDefault(0))
        ->addColumn('remark', 'string', ['comment'=>'备注', 'limit'=>2000, 'null'=>true])
        //->addColumn('itemcount', 'text', ['comment'=>'包含的项目', 'null'=>true])
        ->addColumn(Column::tinyInteger('status')->setComment('状态')->setDefault(0))
        ->addColumn(Column::tinyInteger('sort')->setComment('排序')->setDefault(0))
        ->addColumn('addtime', 'timestamp', ['default'=> 'CURRENT_TIMESTAMP', 'comment'=> '添加时间'])
        ->create();
    }
}