1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
| INSERT INTO tz_shop_menu (`menu_id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`, `name_en`, `hidden`) VALUES
|
| (469,0,'客户','','',0,'members',0,'Customer',0),
| (470,469,'客户管理','','',0,'geren',1,'Manage Customer','0'),
| (471,470,'客户列表','customer/customerList','',1,'',0,'Customers',0),
| (472,471,'导入客户','','customer:customerList:importCustomer',2,'',0,'Import',0),
| (473,471,'导出客户','','customer:customerList:exportCustomer',2,'',0,'Export',0);
|
| # 店铺客户
| USE yami_bbc;
| CREATE TABLE `tz_shop_customer` (
| `shop_customer_id` BIGINT NOT NULL AUTO_INCREMENT COMMENT '店铺客户id',
| `user_id` VARCHAR(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '用户id',
| `member_name` VARCHAR(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '会员名称',
| `shop_id` BIGINT NOT NULL COMMENT '店铺id',
| `level_type` TINYINT DEFAULT NULL COMMENT '会员类型（-1：客户，0：免费会员，1：付费会员）',
| `level_id` BIGINT DEFAULT NULL COMMENT '会员等级Id',
| `level` INT DEFAULT NULL COMMENT '会员等级',
| `growth` INT DEFAULT NULL COMMENT '成长值',
| `regist_time` DATETIME DEFAULT NULL COMMENT '会员注册时间',
| `vip_end_time` DATETIME DEFAULT NULL COMMENT '付费会员到期时间',
| `create_time` DATETIME DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
| `update_time` DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
| PRIMARY KEY (`shop_customer_id`)
| ) ENGINE=INNODB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='店铺客户';
|
| # 同城配送配置添加唯一索引
| ALTER TABLE tz_same_city ADD UNIQUE KEY `idx_shop_id` (`shop_id`);
|
|
