<?php

namespace addons\QiJuhe\console\migrations;

use yii\db\Migration;

/**
 * Class M240827034442CreateQiJuHeExpress
 */
class M240827034442CreateQiJuHeExpress extends Migration
{
    /**
     * {@inheritdoc}
     */
    public function safeUp()
    {
        $this->execute("ALTER TABLE `qimall_addons_qijuhe_express`
	ADD COLUMN `type` SMALLINT(6) NOT NULL DEFAULT '0';");

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

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

        return false;
    }

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

    }

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

        return false;
    }
    */
}