qimall/addons/StarChain/console/migrations/M240401115843AddStarExpress.php

<?php

namespace addons\StarChain\console\migrations;

use yii\db\Migration;

/**
 * Class M240401115843AddStarExpress
 */
class M240401115843AddStarExpress extends Migration
{
    /**
     * {@inheritdoc}
     */
    public function safeUp()
    {
        try {
            // 插入表数据
            $sql = <<<SQL
            CREATE TABLE `qimall_addons_star_chain_express` (
                `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
                `express_id` int(10) NOT NULL DEFAULT '0',
                `name` varchar(64) NOT NULL DEFAULT '',
                `code` varchar(64) NOT NULL DEFAULT '',
                PRIMARY KEY (`id`) USING BTREE
            ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

            INSERT INTO `qimall_addons_star_chain_express` (`id`, `express_id`, `name`, `code`) VALUES (1, 1, '顺丰速运', 'shunfeng');
            INSERT INTO `qimall_addons_star_chain_express` (`id`, `express_id`, `name`, `code`) VALUES (2, 4, '圆通速递', 'yuantong');
            INSERT INTO `qimall_addons_star_chain_express` (`id`, `express_id`, `name`, `code`) VALUES (3, 5, '中通快递', 'zhongtong');
            INSERT INTO `qimall_addons_star_chain_express` (`id`, `express_id`, `name`, `code`) VALUES (4, 2, '申通快递', 'shentong');
            INSERT INTO `qimall_addons_star_chain_express` (`id`, `express_id`, `name`, `code`) VALUES (5, 3, '韵达快递', 'yunda');
            INSERT INTO `qimall_addons_star_chain_express` (`id`, `express_id`, `name`, `code`) VALUES (6, 6, '百世快递', 'huitongkuaidi');
            INSERT INTO `qimall_addons_star_chain_express` (`id`, `express_id`, `name`, `code`) VALUES (7, 18, '德邦', 'debangwuliu');
            INSERT INTO `qimall_addons_star_chain_express` (`id`, `express_id`, `name`, `code`) VALUES (8, 12, '全峰快递', 'quanfengkuaidi');
            INSERT INTO `qimall_addons_star_chain_express` (`id`, `express_id`, `name`, `code`) VALUES (9, 8, '天天快递', 'tiantian');
            INSERT INTO `qimall_addons_star_chain_express` (`id`, `express_id`, `name`, `code`) VALUES (10, 72, '速尔快递', 'suer');
            INSERT INTO `qimall_addons_star_chain_express` (`id`, `express_id`, `name`, `code`) VALUES (11, 13, '优速', 'youshuwuliu');
            INSERT INTO `qimall_addons_star_chain_express` (`id`, `express_id`, `name`, `code`) VALUES (12, 41, '天地华宇', 'tiandihuayu');
            INSERT INTO `qimall_addons_star_chain_express` (`id`, `express_id`, `name`, `code`) VALUES (13, 9, '邮政快递包裹', 'youzhengguonei');
            INSERT INTO `qimall_addons_star_chain_express` (`id`, `express_id`, `name`, `code`) VALUES (14, 0, '安鲜达', 'exfresh');
            INSERT INTO `qimall_addons_star_chain_express` (`id`, `express_id`, `name`, `code`) VALUES (15, 0, '日日顺物流', 'rrs');
            INSERT INTO `qimall_addons_star_chain_express` (`id`, `express_id`, `name`, `code`) VALUES (16, 0, '国际包裹', 'youzhengguoji');
            INSERT INTO `qimall_addons_star_chain_express` (`id`, `express_id`, `name`, `code`) VALUES (17, 103, '京东物流', 'jd');
            INSERT INTO `qimall_addons_star_chain_express` (`id`, `express_id`, `name`, `code`) VALUES (18, 0, '苏宁物流', 'suning');
            INSERT INTO `qimall_addons_star_chain_express` (`id`, `express_id`, `name`, `code`) VALUES (19, 0, '货拉拉物流', 'huolalawuliu');
            INSERT INTO `qimall_addons_star_chain_express` (`id`, `express_id`, `name`, `code`) VALUES (20, 76, '万象物流', 'wanxiangwuliu');
            INSERT INTO `qimall_addons_star_chain_express` (`id`, `express_id`, `name`, `code`) VALUES (21, 22, '安能快运', 'annengwuliu');
            INSERT INTO `qimall_addons_star_chain_express` (`id`, `express_id`, `name`, `code`) VALUES (22, 78, '信丰物流', 'xinfengwuliu');
            INSERT INTO `qimall_addons_star_chain_express` (`id`, `express_id`, `name`, `code`) VALUES (23, 10, '宅急送', 'zhaijisong');
            INSERT INTO `qimall_addons_star_chain_express` (`id`, `express_id`, `name`, `code`) VALUES (24, 11, '国通快递', 'guotongkuaidi');
            INSERT INTO `qimall_addons_star_chain_express` (`id`, `express_id`, `name`, `code`) VALUES (25, 7, 'EMS', 'ems');
            INSERT INTO `qimall_addons_star_chain_express` (`id`, `express_id`, `name`, `code`) VALUES (26, 74, '全一快递', 'quanyikuaidi');
            INSERT INTO `qimall_addons_star_chain_express` (`id`, `express_id`, `name`, `code`) VALUES (27, 14, '中铁快运', 'ztky');
            INSERT INTO `qimall_addons_star_chain_express` (`id`, `express_id`, `name`, `code`) VALUES (28, 1007, '品骏快递', 'pjbest');
            INSERT INTO `qimall_addons_star_chain_express` (`id`, `express_id`, `name`, `code`) VALUES (29, 0, '黄马甲', 'huangmajia');
            INSERT INTO `qimall_addons_star_chain_express` (`id`, `express_id`, `name`, `code`) VALUES (30, 0, '晟邦物流', 'nanjingshengbang');
            INSERT INTO `qimall_addons_star_chain_express` (`id`, `express_id`, `name`, `code`) VALUES (31, 0, '安得物流', 'annto');
            INSERT INTO `qimall_addons_star_chain_express` (`id`, `express_id`, `name`, `code`) VALUES (32, 52, '加运美', 'jiayunmeiwuliu');
            INSERT INTO `qimall_addons_star_chain_express` (`id`, `express_id`, `name`, `code`) VALUES (33, 0, '转运四方', 'zhuanyunsifang');
            INSERT INTO `qimall_addons_star_chain_express` (`id`, `express_id`, `name`, `code`) VALUES (34, 1023, '壹米滴答', 'yimidida');
            INSERT INTO `qimall_addons_star_chain_express` (`id`, `express_id`, `name`, `code`) VALUES (35, 0, '芝麻开门', 'zhimakaimen');
            INSERT INTO `qimall_addons_star_chain_express` (`id`, `express_id`, `name`, `code`) VALUES (36, 1016, '跨越速运', 'kuayue');
            INSERT INTO `qimall_addons_star_chain_express` (`id`, `express_id`, `name`, `code`) VALUES (37, 1020, '韵达快运', 'yundakuaiyun');
            INSERT INTO `qimall_addons_star_chain_express` (`id`, `express_id`, `name`, `code`) VALUES (38, 1018, '顺心捷达', 'sxjdfreight');
            INSERT INTO `qimall_addons_star_chain_express` (`id`, `express_id`, `name`, `code`) VALUES (39, 0, '特急送', 'lntjs');
            INSERT INTO `qimall_addons_star_chain_express` (`id`, `express_id`, `name`, `code`) VALUES (40, 20, '百世快运', 'baishiwuliu');
            INSERT INTO `qimall_addons_star_chain_express` (`id`, `express_id`, `name`, `code`) VALUES (41, 46, '九曳供应链', 'jiuyescm');
            INSERT INTO `qimall_addons_star_chain_express` (`id`, `express_id`, `name`, `code`) VALUES (42, 0, '丹鸟', 'danniao');
            INSERT INTO `qimall_addons_star_chain_express` (`id`, `express_id`, `name`, `code`) VALUES (43, 93, '速必达', 'subida');
            INSERT INTO `qimall_addons_star_chain_express` (`id`, `express_id`, `name`, `code`) VALUES (44, 45, '京广速递', 'jinguangsudikuaijian');
            INSERT INTO `qimall_addons_star_chain_express` (`id`, `express_id`, `name`, `code`) VALUES (45, 0, '联昊通', 'lianhaowuliu');
            INSERT INTO `qimall_addons_star_chain_express` (`id`, `express_id`, `name`, `code`) VALUES (46, 1024, '极兔速递', 'jtexpress');
            INSERT INTO `qimall_addons_star_chain_express` (`id`, `express_id`, `name`, `code`) VALUES (47, 0, '丰通快运', 'ftky365');
            INSERT INTO `qimall_addons_star_chain_express` (`id`, `express_id`, `name`, `code`) VALUES (48, 0, '三志物流', 'sanzhi56');
            INSERT INTO `qimall_addons_star_chain_express` (`id`, `express_id`, `name`, `code`) VALUES (49, 1005, '中通快运', 'zhongtongkuaiyun');
            INSERT INTO `qimall_addons_star_chain_express` (`id`, `express_id`, `name`, `code`) VALUES (50, 9, '邮政电商标快', 'youzhengdsbk');
            INSERT INTO `qimall_addons_star_chain_express` (`id`, `express_id`, `name`, `code`) VALUES (51, 9, '邮政标准快递', 'youzhengbk');
            INSERT INTO `qimall_addons_star_chain_express` (`id`, `express_id`, `name`, `code`) VALUES (52, 1, '顺丰快运', 'shunfengkuaiyun');
            INSERT INTO `qimall_addons_star_chain_express` (`id`, `express_id`, `name`, `code`) VALUES (53, 0, '海信物流', 'savor');
SQL;
            $this->execute($sql);
        } catch (\Exception $e) {

        }
    }

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