table('fences', ['engine' => 'InnoDB', 'comment' => '' ,'id' => 'id','signed' => true ,'primary_key' => ['id']]); $table->addColumn('name', 'string', ['limit' => 50,'null' => false,'default' => '','signed' => true,'comment' => '围栏名称',]) ->addColumn('fence_shape', 'string', ['limit' => 20,'null' => false,'default' => '','signed' => true,'comment' => '围栏形状',]) ->addColumn('fence_type', 'boolean', ['null' => false,'default' => 0,'signed' => false,'comment' => '围栏类型|0-平台 1-家长',]) ->addColumn('fence_info', 'text', ['limit' => MysqlAdapter::TEXT_REGULAR,'null' => true,'signed' => true,'comment' => '围栏信息',]) ->addColumn('departments', 'text', ['limit' => MysqlAdapter::TEXT_REGULAR,'null' => true,'signed' => true,'comment' => '作用部门',]) ->addColumn('push_users', 'text', ['limit' => MysqlAdapter::TEXT_REGULAR,'null' => true,'signed' => true,'comment' => '推送用户',]) ->addColumn('is_check_in', 'boolean', ['null' => false,'default' => 0,'signed' => false,'comment' => '进围栏检测',]) ->addColumn('in_fence_time_area', 'text', ['limit' => MysqlAdapter::TEXT_REGULAR,'null' => true,'signed' => true,'comment' => '进围栏检测时间',]) ->addColumn('is_check_out', 'boolean', ['null' => false,'default' => 0,'signed' => false,'comment' => '出围栏检测',]) ->addColumn('out_fence_time_area', 'text', ['limit' => MysqlAdapter::TEXT_REGULAR,'null' => true,'signed' => true,'comment' => '出围栏检测时间',]) ->addColumn('remark', 'string', ['limit' => 255,'null' => true,'signed' => true,'comment' => '备注',]) ->addColumn('sent_interval', 'string', ['limit' => 8,'null' => false,'default' => '','signed' => false,'comment' => '围栏推送间隔',]) ->addColumn('creator_id', 'integer', ['limit' => MysqlAdapter::INT_REGULAR,'null' => false,'default' => 0,'signed' => false,'comment' => '创建人ID',]) ->addColumn('created_at', 'integer', ['limit' => MysqlAdapter::INT_REGULAR,'null' => false,'default' => 0,'signed' => false,'comment' => '创建时间',]) ->addColumn('updated_at', 'integer', ['limit' => MysqlAdapter::INT_REGULAR,'null' => false,'default' => 0,'signed' => false,'comment' => '更新时间',]) ->addColumn('deleted_at', 'integer', ['limit' => MysqlAdapter::INT_REGULAR,'null' => false,'default' => 0,'signed' => false,'comment' => '软删除',]) ->create(); } }