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

<?php

namespace addons\Store\console\migrations;

use yii\db\Migration;

/**
 * Class M230922101945CreateTableQimallAddonsStoreCashierOrderDetail
 */
class M230922101945CreateTableQimallAddonsStoreCashierOrderDetail extends Migration
{
    /**
     * {@inheritdoc}
     */
    public function safeUp()
    {
        $sql = "CREATE TABLE `qimall_addons_store_cashier_order_detail` (
            `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '订单项ID',
            `cashier_order_id` int(11) NOT NULL DEFAULT '0' COMMENT '收银台订单ID',
            `user_id` int(11) NOT NULL DEFAULT '0' COMMENT '用户id',
            `mall_id` int(11) NOT NULL DEFAULT '0' COMMENT '商城ID',
            `goods_id` int(11) NOT NULL DEFAULT '0' COMMENT '商品ID',
            `goods_name` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '商品名称',
            `goods_attr_id` int(11) NOT NULL DEFAULT '0' COMMENT '规格ID',
            `goods_attr_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '规格名称',
            `sign_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '规格ID标识',
            `attr_groups_format` longtext COLLATE utf8mb4_unicode_ci COMMENT '格式化规格组',
            `price` decimal(19,2) NOT NULL DEFAULT '0.00' COMMENT '商品价格',
            `cost_price` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '商品成本价',
            `original_goods_price` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '商品原本总价',
            `goods_price` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '商品优惠后总价',
            `num` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '购买数量',
            `pic_url` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '商品图片',
            `order_status` int(11) NOT NULL DEFAULT '0' COMMENT '订单状态【0待付款 1待发货 2 已发货 3已收货 4已完成 -1申请售后 -2售后中 -3售后完成 -4 已关闭 -5撤销售后】',
            `is_virtual` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否包含 虚拟商品   0 不包含  1  包含',
            `status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '状态[-1:删除;0:禁用;1启用]',
            `extra_info` text CHARACTER SET utf8mb4 COMMENT '额外信息',
            `created_at` int(10) NOT NULL DEFAULT '0',
            `updated_at` int(10) NOT NULL DEFAULT '0',
            `store_id` int(11) NOT NULL DEFAULT '0' COMMENT '门店id',
            PRIMARY KEY (`id`) USING BTREE,
            KEY `order_detail_goods_buyer_id` (`user_id`) USING BTREE,
            KEY `order_detail_goods_goods_id` (`goods_id`) USING BTREE,
            KEY `order_detail_goods_order_id` (`cashier_order_id`) USING BTREE,
            KEY `order_detail_goods_attr_id` (`goods_attr_id`) USING BTREE
          ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='收银台订单商品详情表';";
          $this->execute($sql);
    }

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

        return false;
    }

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

    }

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

        return false;
    }
    */
}