qimall/addons/Happiness/console/migrations/M250909033445AddHappinessTablePv.php

<?php

namespace addons\Happiness\console\migrations;

use yii\db\Migration;

/**
 * Class M250909033445AddHappinessTablePv
 */
class M250909033445AddHappinessTablePv extends Migration
{
    /**
     * {@inheritdoc}
     */
    public function safeUp()
    {
        $this->execute("CREATE TABLE `qimall_addons_happiness_pv_order`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `mall_id` int(11) NOT NULL DEFAULT 0 COMMENT '商城ID',
  `user_id` int(11) NOT NULL DEFAULT 0 COMMENT '用户ID',
  `order_id` int(11) NOT NULL DEFAULT 0 COMMENT '订单ID',
  `order_no` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '订单号',
  `goods_price` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '订单商品金额',
  `score` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '获得积分',
  `status` tinyint(3) NOT NULL DEFAULT 1 COMMENT '状态：0 禁用 1启用',
  `is_settled` tinyint(3) NOT NULL DEFAULT 0 COMMENT '是否已结算,可进行释放',
  `settled_time` int(11) NULL DEFAULT NULL COMMENT '可结算时间',
  `updated_at` int(11) NOT NULL DEFAULT 0,
  `created_at` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = 'PV订单明细' ROW_FORMAT = Dynamic;");
        
        $this->execute("CREATE TABLE `qimall_addons_happiness_pv_wallet`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `mall_id` int(11) NOT NULL DEFAULT 0 COMMENT '商城id',
  `user_id` int(11) NOT NULL DEFAULT 0 COMMENT '用户id',
  `score_value` decimal(32, 2) NOT NULL DEFAULT 0.00 COMMENT '当前拥有积分',
  `freeze_score_value` decimal(22, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '冻结积分,待释放的',
  `total_score_value` decimal(22, 2) NOT NULL DEFAULT 0.00 COMMENT '累加获得积分',
  `active_score_value` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '累计释放积分',
  `status` tinyint(1) 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
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '幸福宝积分表' ROW_FORMAT = Dynamic;");
        
        $this->execute("CREATE TABLE `qimall_addons_happiness_pv_wallet_log`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `mall_id` int(11) UNSIGNED NOT NULL DEFAULT 0,
  `user_id` int(11) UNSIGNED NOT NULL DEFAULT 0,
  `wallet_type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
  `change_type` char(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '操作类型：add-增加，sub-减少',
  `change_num` decimal(12, 2) UNSIGNED NOT NULL COMMENT '操作数量',
  `after_num` decimal(12, 2) NOT NULL DEFAULT 0.00 COMMENT '变动后数量',
  `desc` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '变动说明',
  `source_table` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '来源表',
  `source_table_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '操作来源业务id',
  `from_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '来源类型',
  `status` tinyint(4) NOT NULL DEFAULT 1 COMMENT '状态，-1：失效，1：正常，2：冻结',
  `order_no` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '订单号',
  `addon_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'Happiness' COMMENT '来源插件名称',
  `created_at` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '添加时间戳',
  `updated_at` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '更新时间戳',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `idx_mall_user`(`mall_id`, `user_id`) USING BTREE,
  INDEX `idx_source`(`source_table`, `source_table_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '幸福宝积分明细' ROW_FORMAT = Dynamic;");
        $this->execute("INSERT INTO `qimall_crontab_task` (`name`, `command`, `type`, `rule`, `is_warning`, `status`, `created_at`, `updated_at`) VALUES ('幸福小店定时发送养老金', 'happiness/index/send-pension', '1', '0 */1 * * * *', '0', '1', '1679104279', '1679104279');");
        $this->execute("INSERT INTO `qimall_crontab_task` (`name`, `command`, `type`, `rule`, `is_warning`, `status`, `created_at`, `updated_at`) VALUES ('幸福小店定时结算佣金', 'happiness/index/send-commission', '1', '0 */1 * * * *', '0', '1', '1679104279', '1679104279');");
        $this->execute("DELETE FROM `qimall_crontab_task` WHERE `name` = '幸福小店佣金结算';");
    }

    /**
     * {@inheritdoc}
     */
    public function safeDown()
    {

        return false;
    }

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

    }

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

        return false;
    }
    */
}