f075068f
 “wangming”
对考勤这块功能进行开发
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
|
-- 门店信息表新增扩展字段
-- 执行库：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:
-- ["旗舰店","地铁口","停车方便"]
|
