/** * 素材表 */ public function initMediaTable() { $tableName = Media::tableName(); $this->createTable($tableName, ['id' => Schema::TYPE_PK, 'mediaId' => Schema::TYPE_STRING . "(100) NOT NULL DEFAULT '' COMMENT '素材ID'", 'filename' => Schema::TYPE_STRING . "(100) NOT NULL COMMENT '文件名'", 'result' => Schema::TYPE_TEXT . " NOT NULL COMMENT '微信返回数据'", 'type' => Schema::TYPE_STRING . "(10) NOT NULL DEFAULT '' COMMENT '素材类型'", 'material' => Schema::TYPE_STRING . "(20) NOT NULL DEFAULT '' COMMENT '素材类别'", 'created_at' => Schema::TYPE_INTEGER . " UNSIGNED NOT NULL DEFAULT '0' COMMENT '创建时间'", 'updated_at' => Schema::TYPE_INTEGER . " UNSIGNED NOT NULL DEFAULT '0' COMMENT '修改时间'"]); }