CREATE TABLE IF NOT EXISTS biz_shop_manage (
    id BIGINT PRIMARY KEY AUTO_INCREMENT COMMENT '主键',
    group_name VARCHAR(128) NOT NULL COMMENT '分组',
    shop_name VARCHAR(128) NOT NULL COMMENT '店铺名',
    account VARCHAR(128) NOT NULL COMMENT '账号',
    password VARCHAR(255) NOT NULL COMMENT '密码',
    created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    updated_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
    KEY idx_group_name (group_name),
    KEY idx_shop_name (shop_name),
    KEY idx_created_at (created_at)
) COMMENT='店铺管理表';
