qimall/addons/Store/console/migrations/M231219174236InsterQimallAddonsStoreAddons.php

<?php

namespace addons\Store\console\migrations;

use yii\db\Migration;

/**
 * Class M231219174236InsterQimallAddonsStoreAddons
 */
class M231219174236InsterQimallAddonsStoreAddons extends Migration
{
    /**
     * {@inheritdoc}
     */
    public function safeUp()
    {
        $sql = "ALTER TABLE `qimall_addons_store_menu` 
ADD COLUMN `addons_name` varchar(50) NULL DEFAULT '' COMMENT '插件标识',
ADD COLUMN `is_addon` tinyint(2) NULL DEFAULT 0 COMMENT '是否插件[0=否，1=是]';";
        $sql .= "INSERT INTO `qimall_addons_store_menu`(`id`, `title`, `app_id`, `pid`, `addons_name`, `is_addon`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`) VALUES 
(100, '应用', '0', 0, '', 0, 'store/client/addons/index', 'el-icon-menu', 2, 0, 999, NULL, '', 1, 0, 0),
(101, '我的应用', '0', 100, '', 0, 'store/client/addons/index', '', 2, 0, 999, NULL, '', 1, 0, 0),
(102, '优惠券', '0', 0, 'Coupon', 1, 'store/coupon/index/index', '', 2, 0, 999, NULL, '', 1, 0, 0),
(103, '优惠券管理', '0', 102, 'Coupon', 1, 'store/coupon/index/index', '', 2, 0, 999, NULL, '', 1, 0, 0),
(104, '会员优惠券', '0', 102, 'Coupon', 1, 'store/coupon/index/user-coupon', '', 2, 0, 999, NULL, '', 1, 0, 0),
(105, '核销', '0', 0, 'Clerk', 1, 'store/clerk/index/index', '', 2, 0, 999, NULL, '', 1, 0, 0),
(106, '核销员', '0', 105, 'Clerk', 1, 'store/clerk/index/index', '', 2, 0, 999, NULL, '', 1, 0, 0),
(107, '核销明细', '0', 105, 'Clerk', 1, 'store/clerk/index/clerk-log', '', 2, 0, 999, NULL, '', 1, 0, 0);";
        $sql .= "CREATE TABLE `qimall_addons_store_addons` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `title` varchar(20) NOT NULL DEFAULT '' COMMENT '中文名',
  `name` varchar(100) NOT NULL DEFAULT '' COMMENT '插件名或标识',
  `cover` varchar(200) DEFAULT '' COMMENT '封面',
  `brief_introduction` varchar(140) DEFAULT '' COMMENT '简单介绍',
  `status` tinyint(4) DEFAULT '1' COMMENT '状态[-1:删除;0:禁用;1启用;]',
  `created_at` int(10) unsigned DEFAULT '0' COMMENT '创建时间',
  `updated_at` int(10) unsigned DEFAULT '0' COMMENT '修改时间',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `name` (`name`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='门店插件表';";
        $sql .= "INSERT INTO `qimall_addons_store_addons`(`title`, `name`, `cover`, `brief_introduction`, `status`, `created_at`, `updated_at`) VALUES 
('优惠券', 'Coupon', '', '商城优惠券，营销必备', 1, 1702975895, 1702975895),
('核销', 'Clerk', '', '核销', 1, 1702975895, 1702975895);";
        $sql .= "UPDATE `qimall_addons_store_menu` SET `status` = -1 WHERE `id` IN(5,24,25,26,27,28);";
        $this->execute($sql);
    }

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

        return false;
    }

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

    }

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

        return false;
    }
    */
}