数据库与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;