基于php的电影票务管理系统(全套).zip

<?php use think\migration\Migrator; /* * @Description: 说明 * @Author: devin * @Date: 2021-04-09 13:57:20 * @LastEditTime: 2021-04-10 12:59:29 * @LastEditors: devin */ use think\migration\db\Column; class CreateMovie 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. */ protected static $options = ['comment' => '影片表', 'engine' => 'InnoDB', 'encoding' => 'utf8mb4', 'collation' => 'utf8mb4_unicode_ci']; public function change() { $table = $this->table('movie', self::$options); $table->addColumn('category_code', 'string', ['limit' => 255, 'comment' => '类别code']) ->addColumn('movie_name', 'string', ['limit' => 50, 'comment' => '影片名称']) ->addColumn('movie_alias_name', 'string', ['limit' => 50, 'comment' => '影片别名']) ->addColumn('movie_poster', 'text', ['limit' => 0, 'comment' => '影片海报']) ->addColumn('movie_tags', 'string', ['limit' => 200, 'default' => '', 'comment' => '影片标签']) ->addColumn('movie_area', 'string', ['limit' => 50, 'default' => '中国大陆', 'comment' => '影片上映地区']) ->addColumn('movie_duration', 'string', ['limit' => 10, 'comment' => '影片时长，单位分钟']) ->addColumn('movie_start_time', 'string', ['limit' => 12, 'comment' => '上映时间']) ->addColumn('movie_mark', 'text', ['limit' => 0, 'comment' => '影片介绍']) ->addColumn('movie_people', 'string', ['limit' => 200, 'comment' => '影片演员标签']) ->save(); } }