/*
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 */;
