13 lines
788 B
SQL
13 lines
788 B
SQL
|
CREATE TABLE `wa_user_extend` (
|
||
|
|
`user_id` int NOT NULL,
|
||
|
|
`team_total` int DEFAULT '0' COMMENT '团队总人数',
|
||
|
|
`direct_total` int DEFAULT '0' COMMENT '直属团队人数',
|
||
|
|
`vip_total` int NOT NULL DEFAULT '0' COMMENT '旗下VIP总数',
|
||
|
|
`consume` int DEFAULT '0',
|
||
|
|
`sales` int DEFAULT '0',
|
||
|
|
`profile_banner` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '个人信息背景',
|
||
|
|
`moments_banner` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '朋友圈背景',
|
||
|
|
`moments_allow_view_days` tinyint NOT NULL DEFAULT '0' COMMENT '允许查看朋友圈的天数,0不限制,-1:不允许查看,>0,具体的天数',
|
||
|
|
PRIMARY KEY (`user_id`)
|
||
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
|