qimall/console/migrations/M230922155130CreateQimallOptimize.php

<?php

namespace app\migrations;

use yii\db\Migration;

/**
 * Class M230922155130CreateQimallOptimize
 */
class M230922155130CreateQimallOptimize extends Migration
{
    /**
     * {@inheritdoc}
     */
    public function safeUp()
    {
        try {
            $sql="CREATE TABLE `qimall_optimize` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `mall_id` int(11) NOT NULL DEFAULT '0',
  `category` varchar(50) NOT NULL DEFAULT '' COMMENT '工单类型',
  `mobile` varchar(50) NOT NULL DEFAULT '' COMMENT '联系方式',
  `backend_path` varchar(50) NOT NULL DEFAULT '' COMMENT '后台地址路径json字符串',
  `backend_path_str` varchar(50) NOT NULL DEFAULT '' COMMENT '后台地址中文',
  `title` varchar(50) NOT NULL DEFAULT '' COMMENT '标题',
  `examine_status` tinyint(2) NOT NULL DEFAULT '1' COMMENT '工单状态[1=客户已回复,2=中台已回复,3=工单结束]',
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态[-1:删除;0:禁用;1启用]',
  `created_at` int(11) NOT NULL DEFAULT '0',
  `updated_at` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `mall_id` (`mall_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='优化建议表';

CREATE TABLE `qimall_optimize_detail` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `mall_id` int(11) NOT NULL DEFAULT '0',
  `optimize_id` int(11) NOT NULL DEFAULT '0' COMMENT 'qimall_optimize.id',
  `ip` varchar(50) NOT NULL DEFAULT '' COMMENT 'IP',
  `member_id` int(11) NOT NULL DEFAULT '0' COMMENT '操作人id',
  `member_name` varchar(50) DEFAULT '' COMMENT '操作人',
  `optimize` longtext COMMENT '优化建议',
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态[-1:删除;0:禁用;1启用]',
  `created_at` int(11) NOT NULL DEFAULT '0',
  `updated_at` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `mall_id+optimize_id` (`mall_id`,`optimize_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='优化建议沟通记录表';";
            $this->execute($sql);
        }catch (\Exception $e){

        }

    }

    /**
     * {@inheritdoc}
     */
    public function safeDown()
    {
        echo "M230922155130CreateQimallOptimize cannot be reverted.\n";

        return false;
    }

    /*
    // Use up()/down() to run migration code without a transaction.
    public function up()
    {

    }

    public function down()
    {
        echo "M230922155130CreateQimallOptimize cannot be reverted.\n";

        return false;
    }
    */
}