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
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
| /*
| SQLyog Ultimate v13.1.1 (64 bit)
| MySQL - 5.7.32-log : Database - coreshop
| *********************************************************************
| */
|
| /*!40101 SET NAMES utf8 */;
|
| /*!40101 SET SQL_MODE=''*/;
|
| /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
| /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
| /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
| /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
| CREATE DATABASE /*!32312 IF NOT EXISTS*/`coreshop` /*!40100 DEFAULT CHARACTER SET utf8 */;
|
| USE `coreshop`;
|
| /*Table structure for table `CoreCmsContinuousCheckInRuleDetails` */
|
| DROP TABLE IF EXISTS `CoreCmsContinuousCheckInRuleDetails`;
|
| CREATE TABLE `CoreCmsContinuousCheckInRuleDetails` (
| `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '序列',
| `userGradeId` int(11) DEFAULT NULL COMMENT '用户级别',
| `ruleId` int(11) DEFAULT NULL COMMENT '连续签到规则序列',
| `num` int(11) DEFAULT NULL COMMENT '数量',
| `type` int(11) DEFAULT NULL COMMENT '积分1余额2',
| PRIMARY KEY (`id`)
| ) ENGINE=InnoDB AUTO_INCREMENT=121 DEFAULT CHARSET=utf8;
|
| /*Data for the table `CoreCmsContinuousCheckInRuleDetails` */
|
| insert into `CoreCmsContinuousCheckInRuleDetails`(`id`,`userGradeId`,`ruleId`,`num`,`type`) values
| (109,2,37,1,1),
| (110,6,37,2,1),
| (111,1006,37,3,1),
| (112,2,38,1,1),
| (113,6,38,2,1),
| (114,1006,38,3,1),
| (115,2,39,1,1),
| (116,6,39,2,1),
| (117,1006,39,3,1),
| (118,2,40,1,1),
| (119,6,40,2,1),
| (120,1006,40,3,1);
|
| /*Table structure for table `CoreCmsContinuousCheckInRules` */
|
| DROP TABLE IF EXISTS `CoreCmsContinuousCheckInRules`;
|
| CREATE TABLE `CoreCmsContinuousCheckInRules` (
| `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '序列',
| `days` int(11) DEFAULT NULL COMMENT '天数',
| PRIMARY KEY (`id`)
| ) ENGINE=InnoDB AUTO_INCREMENT=41 DEFAULT CHARSET=utf8;
|
| /*Data for the table `CoreCmsContinuousCheckInRules` */
|
| insert into `CoreCmsContinuousCheckInRules`(`id`,`days`) values
| (37,1),
| (38,2),
| (39,3),
| (40,4);
|
| /*Table structure for table `CoreCmsCumulativeCheckInRules` */
|
| DROP TABLE IF EXISTS `CoreCmsCumulativeCheckInRules`;
|
| CREATE TABLE `CoreCmsCumulativeCheckInRules` (
| `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '序列',
| `days` int(11) DEFAULT NULL COMMENT '累计天数',
| `num` int(11) DEFAULT NULL COMMENT '数量',
| `type` int(11) DEFAULT NULL COMMENT '积分1余额2',
| PRIMARY KEY (`id`)
| ) ENGINE=InnoDB AUTO_INCREMENT=61 DEFAULT CHARSET=utf8;
|
| /*Data for the table `CoreCmsCumulativeCheckInRules` */
|
| insert into `CoreCmsCumulativeCheckInRules`(`id`,`days`,`num`,`type`) values
| (58,4,1,1),
| (59,5,2,1),
| (60,6,3,1);
|
| /*Table structure for table `CoreCmsUserCheckIn` */
|
| DROP TABLE IF EXISTS `CoreCmsUserCheckIn`;
|
| CREATE TABLE `CoreCmsUserCheckIn` (
| `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '序列',
| `userId` int(11) DEFAULT NULL COMMENT '用户序列',
| `continuousCheckInCount` int(11) DEFAULT NULL COMMENT '连续签到次数',
| `cumulativeCheckInCount` int(11) DEFAULT NULL COMMENT '累计签到次数',
| PRIMARY KEY (`id`)
| ) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8;
|
| /*Data for the table `CoreCmsUserCheckIn` */
|
| insert into `CoreCmsUserCheckIn`(`id`,`userId`,`continuousCheckInCount`,`cumulativeCheckInCount`) values
| (17,4467,4,4);
|
| /*Table structure for table `CoreCmsUserCheckInDetails` */
|
| DROP TABLE IF EXISTS `CoreCmsUserCheckInDetails`;
|
| CREATE TABLE `CoreCmsUserCheckInDetails` (
| `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '序列',
| `userId` int(11) DEFAULT NULL COMMENT '用户序列',
| `checkInData` varchar(10) DEFAULT NULL COMMENT '打卡日期',
| `createTime` timestamp NULL DEFAULT NULL COMMENT '打卡时间',
| PRIMARY KEY (`id`)
| ) ENGINE=InnoDB AUTO_INCREMENT=71 DEFAULT CHARSET=utf8;
|
| /*Data for the table `CoreCmsUserCheckInDetails` */
|
| insert into `CoreCmsUserCheckInDetails`(`id`,`userId`,`checkInData`,`createTime`) values
| (67,4467,'2022-03-01','2022-03-14 00:35:06'),
| (68,4467,'2022-03-02','2022-03-14 00:35:11'),
| (69,4467,'2022-03-11','2022-03-14 00:35:12'),
| (70,4467,'2022-03-12','2022-03-14 00:35:15');
|
| /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
| /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
| /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
| /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
|
|
