LJH_Shop/niucloud/app/upgrade/v002/upgrade.sql

ALTER TABLE `member_level` ADD COLUMN `level_benefits` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '等级权益';

ALTER TABLE `member_level` ADD COLUMN `level_gifts` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '等级礼包';

ALTER TABLE `member_level` MODIFY COLUMN `site_id` int NOT NULL DEFAULT 0 COMMENT '站点id';

ALTER TABLE `member_level` MODIFY COLUMN `growth` int NOT NULL DEFAULT 0 COMMENT '所需成长值';

CREATE TABLE `member_sign`  (
                                `sign_id` int UNSIGNED NOT NULL AUTO_INCREMENT,
                                `site_id` int NOT NULL DEFAULT 0 COMMENT '站点id',
                                `member_id` int NOT NULL DEFAULT 0 COMMENT '会员id',
                                `days` int NOT NULL DEFAULT 0 COMMENT '连续签到天数',
                                `day_award` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '日签奖励',
                                `continue_award` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '连签奖励',
                                `continue_tag` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '连签奖励标识',
                                `create_time` int NOT NULL DEFAULT 0 COMMENT '签到时间',
                                `start_time` int NOT NULL DEFAULT 0 COMMENT '签到周期开始时间',
                                `is_sign` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否签到（0未签到 1已签到）',
                                PRIMARY KEY (`sign_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '会员签到表' ROW_FORMAT = Dynamic;

CREATE TABLE `verifier`  (
                             `id` int NOT NULL AUTO_INCREMENT,
                             `site_id` int NOT NULL DEFAULT 0 COMMENT '站点id',
                             `member_id` int NOT NULL DEFAULT 0 COMMENT '会员id',
                             `uid` int NOT NULL DEFAULT 0 COMMENT '用户id',
                             `create_time` int NOT NULL DEFAULT 0 COMMENT '添加时间',
                             `verify_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '核销类型',
                             PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '核销员表' ROW_FORMAT = Dynamic;

CREATE TABLE `verify`  (
                           `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
                           `site_id` int NOT NULL DEFAULT 0 COMMENT '站点id',
                           `code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '核销码',
                           `data` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '核销参数',
                           `type` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '核销类型',
                           `create_time` int NOT NULL DEFAULT 0 COMMENT '核销时间',
                           `verifier_member_id` int NOT NULL DEFAULT 0 COMMENT '核销会员id',
                           `value` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '核销内容',
                           `body` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '描述',
                           `relate_tag` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '业务标识',
                           PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '核销记录' ROW_FORMAT = Dynamic;