数据库与CRUD生成

xy_shop_order          ✅ 正确

xy_shop_product        ✅ 正确

xy_order               ❌ 错误（缺少扩展名前缀）

shop_order             ❌ 错误（缺少 xy_ 前缀）

-- PostgreSQL

CREATE TABLE IF NOT EXISTS xy_shop_order (

    id         bigserial PRIMARY KEY,

    order_no   varchar(64) NOT NULL DEFAULT '',

    status     smallint    NOT NULL DEFAULT 1,

    amount     decimal(10,2) NOT NULL DEFAULT 0,

    created_at bigint      NOT NULL DEFAULT 0,

    updated_at bigint      NOT NULL DEFAULT 0,

    deleted_at bigint      NOT NULL DEFAULT 0

);



CREATE INDEX IF NOT EXISTS idx_shop_order_status ON xy_shop_order(status);

CREATE INDEX IF NOT EXISTS idx_shop_order_deleted_at ON xy_shop_order(deleted_at);

-- 新增字段

ALTER TABLE xy_shop_order ADD COLUMN IF NOT EXISTS remark varchar(500) DEFAULT '';



-- 新增索引

CREATE INDEX IF NOT EXISTS idx_shop_order_created_at ON xy_shop_order(created_at);



-- 新增表

CREATE TABLE IF NOT EXISTS xy_shop_refund (

    id         bigserial PRIMARY KEY,

    order_id   bigint NOT NULL DEFAULT 0,

    reason     varchar(500) NOT NULL DEFAULT ''

);



-- 新增配置（不覆盖已有值）

INSERT INTO xy_sys_config ("group", "key", "value")

VALUES ('shop', 'payment_timeout', '1800')

ON CONFLICT ("group", "key") DO NOTHING;

DROP TABLE IF EXISTS xy_shop_order;

DROP TABLE IF EXISTS xy_shop_refund;