门店信息表新增图片介绍标签字段.sql 717 Bytes

Edit Raw Blame History Permalink

-- 门店信息表新增扩展字段
-- 执行库：lqerp_dev / lqerp
-- 用途：支持门店图片、门店介绍、门店标签
ALTER TABLE `lq_mdxx`
    ADD COLUMN `F_StoreImages` LONGTEXT NULL COMMENT '门店图片，JSON数组字符串' AFTER `zzrs`,
    ADD COLUMN `F_StoreDescription` TEXT NULL COMMENT '门店介绍' AFTER `F_StoreImages`,
    ADD COLUMN `F_StoreTags` TEXT NULL COMMENT '门店标签，JSON数组字符串' AFTER `F_StoreDescription`;

-- 示例数据格式
-- F_StoreImages:
-- [
--   {"name":"门头.jpg","fileId":"xxx","url":"/api/File/Image/xxx"},
--   {"name":"前台.jpg","fileId":"yyy","url":"/api/File/Image/yyy"}
-- ]
--
-- F_StoreTags:
-- ["旗舰店","地铁口","停车方便"]