476 lines
24 KiB
SQL
476 lines
24 KiB
SQL
/*
|
||
Navicat Premium Data Transfer
|
||
|
||
Source Server : 内网测试数据库
|
||
Source Server Type : MySQL
|
||
Source Server Version : 50731
|
||
Source Host : 172.16.2.122:3306
|
||
Source Schema : NewMiniGame
|
||
|
||
Target Server Type : MySQL
|
||
Target Server Version : 50731
|
||
File Encoding : 65001
|
||
|
||
Date: 20/12/2021 21:35:55
|
||
*/
|
||
|
||
SET NAMES utf8mb4;
|
||
SET FOREIGN_KEY_CHECKS = 0;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for ad_convert_record
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `ad_convert_record`;
|
||
CREATE TABLE `ad_convert_record` (
|
||
`recordTime` int(10) NULL DEFAULT NULL COMMENT '记录时间',
|
||
`requestIP` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '请求的IP地址',
|
||
`adMd5` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'MD5',
|
||
`adStatus` int(10) NULL DEFAULT NULL COMMENT '0-展示 1-点击 2-已使用',
|
||
`adDeviceParam` json NULL COMMENT '广告平台记录参数',
|
||
`endTime` int(10) NULL DEFAULT NULL COMMENT '结束时间'
|
||
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of ad_convert_record
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for adinfo
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `adinfo`;
|
||
CREATE TABLE `adinfo` (
|
||
`firmId` int(10) NOT NULL COMMENT '平台id',
|
||
`ratio` int(10) NOT NULL COMMENT '分成比例 范围 1- 100',
|
||
`todayEcpm` int(10) NULL DEFAULT NULL COMMENT '当前平台的 ecpm （指广告端当日的千次视频展示获得的收入）',
|
||
`yesterdayEcpm` int(10) NULL DEFAULT NULL COMMENT '昨天的ecpm',
|
||
`recordTime` int(10) NULL DEFAULT NULL COMMENT '最后一次记录时间',
|
||
PRIMARY KEY (`firmId`) USING BTREE
|
||
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of adinfo
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for admin
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `admin`;
|
||
CREATE TABLE `admin` (
|
||
`id` int(10) NOT NULL AUTO_INCREMENT,
|
||
`name` char(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
|
||
`pwd` char(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
|
||
`lastLoginTime` int(11) NULL DEFAULT NULL,
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of admin
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for alluserrecord
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `alluserrecord`;
|
||
CREATE TABLE `alluserrecord` (
|
||
`ID` int(10) NULL DEFAULT NULL COMMENT '玩家ID',
|
||
`CreationValue` float(255, 2) NULL DEFAULT NULL COMMENT '创造价值',
|
||
`GameTime` int(10) NULL DEFAULT NULL COMMENT '游戏时长',
|
||
`WatchCount` int(10) NULL DEFAULT NULL COMMENT '广告数量',
|
||
`RecordTime` int(11) NULL DEFAULT NULL COMMENT '记录时间'
|
||
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of alluserrecord
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for day_data_record
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `day_data_record`;
|
||
CREATE TABLE `day_data_record` (
|
||
`ID` int(10) NOT NULL COMMENT '玩家ID',
|
||
`AdCount` int(10) NULL DEFAULT NULL COMMENT '广告数量',
|
||
`RecordTime` int(10) NULL DEFAULT NULL COMMENT '记录时间',
|
||
PRIMARY KEY (`ID`) USING BTREE
|
||
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of day_data_record
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for everyday
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `everyday`;
|
||
CREATE TABLE `everyday` (
|
||
`id` bigint(20) NOT NULL,
|
||
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
|
||
`stime` int(11) NULL DEFAULT NULL,
|
||
`headurl` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of everyday
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for gaincash
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `gaincash`;
|
||
CREATE TABLE `gaincash` (
|
||
`id` int(10) NOT NULL,
|
||
`gameId` int(10) NULL DEFAULT NULL,
|
||
`source` int(10) NULL DEFAULT NULL COMMENT '来源',
|
||
`type` int(10) NULL DEFAULT NULL COMMENT '1-红包提现 2-直接提现',
|
||
`money` int(10) NULL DEFAULT NULL COMMENT '提现金额',
|
||
`redPacket` int(10) NULL DEFAULT NULL COMMENT '此次消耗的红包券',
|
||
`WatchCount` int(10) NULL DEFAULT NULL COMMENT '累计观看次数',
|
||
`GameTime` int(10) NULL DEFAULT NULL COMMENT '累计游戏时间',
|
||
`GainCashCount` int(10) NULL DEFAULT NULL COMMENT '累计提现数量',
|
||
`GainRedCount` int(10) NULL DEFAULT NULL COMMENT '累计获得红包',
|
||
`CostRedCount` int(10) NULL DEFAULT NULL COMMENT '累计消耗红包',
|
||
`recordTime` int(12) NULL DEFAULT NULL
|
||
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of gaincash
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for gamedatarecord
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `gamedatarecord`;
|
||
CREATE TABLE `gamedatarecord` (
|
||
`CreationValue` float(255, 2) NULL DEFAULT NULL COMMENT '创造价值',
|
||
`GainCash` float(255, 2) NULL DEFAULT NULL COMMENT '提现金额',
|
||
`OnlineCount` int(10) NULL DEFAULT NULL COMMENT '在线人数',
|
||
`RecordTime` int(11) NULL DEFAULT NULL COMMENT '记录时间'
|
||
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of gamedatarecord
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for loginrecord
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `loginrecord`;
|
||
CREATE TABLE `loginrecord` (
|
||
`ID` int(10) NULL DEFAULT NULL COMMENT '玩家ID',
|
||
`Status` int(10) NULL DEFAULT NULL COMMENT '1-登陆 2-离开',
|
||
`IP` char(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'IP地址',
|
||
`RecordTime` int(11) NULL DEFAULT NULL COMMENT '记录时间'
|
||
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of loginrecord
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for moneyrecord
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `moneyrecord`;
|
||
CREATE TABLE `moneyrecord` (
|
||
`id` int(10) NOT NULL COMMENT '玩家ID',
|
||
`opType` int(10) NULL DEFAULT NULL COMMENT '操作类型1-获得 2-支付',
|
||
`itemType` int(10) NULL DEFAULT NULL COMMENT '1-钻石 2-红包券 3-经验',
|
||
`isUseRed` int(10) NULL DEFAULT NULL COMMENT '是否使用红包，opType为2进生效',
|
||
`changeCount` int(10) NULL DEFAULT NULL COMMENT '变化的数量',
|
||
`lastCount` int(10) NULL DEFAULT NULL COMMENT '最新的数量',
|
||
`source` int(10) NULL DEFAULT NULL COMMENT '来源类型',
|
||
`recordTime` int(11) NULL DEFAULT NULL COMMENT '记录时间',
|
||
INDEX `TimeIndex`(`recordTime`) USING BTREE
|
||
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of moneyrecord
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for player
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `player`;
|
||
CREATE TABLE `player` (
|
||
`id` int(11) NOT NULL,
|
||
`data` json NULL,
|
||
`lastRecordTime` int(11) NULL DEFAULT NULL COMMENT '最后一次刷新记录时间',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of player
|
||
-- ----------------------------
|
||
INSERT INTO `player` VALUES (100025, '{\"id\": 100025, \"bag\": [], \"exp\": 0, \"gain\": {\"farmCount\": 0, \"platCount\": 0, \"shopCount\": 0}, \"item\": [], \"name\": \"\", \"plat\": [], \"shop\": {\"times1\": [], \"times2\": [], \"times3\": [], \"times4\": [], \"times5\": [], \"times6\": [], \"isvideo\": 0, \"unlock1\": 2, \"unlock2\": 2, \"unlock3\": 2, \"unlock4\": 2, \"unlock5\": 2, \"unlock6\": 2, \"factory1\": [], \"factory2\": [], \"factory3\": [], \"factory4\": [], \"factory5\": [], \"factory6\": []}, \"guide\": {\"step\": 0, \"isGainGift\": false}, \"level\": 1, \"title\": [], \"adEcpm\": 0, \"adInfo\": {\"adId\": 0, \"firmId\": 0, \"status\": 1, \"startTime\": 0}, \"signIn\": {\"curDay\": 1, \"isActive\": true, \"curPeriod\": 1, \"isTodayGain\": false, \"isTodayWatch\": false}, \"tixian\": {\"tx\": [], \"yuan\": 0, \"records\": []}, \"account\": \"r1\", \"bigcrad\": {\"nums\": 0, \"bubred\": 0, \"isopen\": 0, \"time_s\": 0, \"catchexp\": 0, \"bubfreeexp\": 0, \"bubfreered\": 0, \"catchtimes\": 0, \"watchvido1\": 0, \"watchvido2\": 0, \"bubfreediamo\": 0, \"catchdiamond\": 0}, \"dayTask\": {\"box\": [], \"task\": [], \"stime\": 0, \"tatalscore\": 0, \"todaylogin\": 0}, \"dialROI\": 0, \"diamond\": 100, \"dropRed\": {\"gainCount\": 0, \"isCanGain\": false, \"isWatchAd\": false, \"lastRandCount\": 0}, \"headUrl\": \"\", \"isFloor\": false, \"mainRed\": [], \"regTime\": 1635390630, \"upLvExp\": 0, \"farmgame\": {\"gift\": [], \"hasgot\": 0, \"lvlist\": [], \"kanvido\": 0}, \"gainCash\": 0, \"loginDay\": 0, \"allAdInfo\": [], \"godwealth\": {\"alone\": 0, \"stime\": 0, \"ttime\": 0, \"txtime\": 0, \"currpkg\": \"111\", \"txmoney\": 0, \"evrdyone\": 0, \"evrdytwo\": 0, \"startpkg\": \"222\", \"currvideo\": 0, \"sevrdyone\": 0, \"sevrdytwo\": 0, \"staralone\": 0, \"teverdtwo\": 0, \"tixiantims\": 0, \"packagename\": [], \"oldstarttime\": 0, \"othervediotimes\": 0}, \"platCount\": 0, \"redPacket\": 0, \"todayGain\": {\"exp\": 0, \"cash\": 0, \"adRed\": 0, \"diamond\": 0, \"farmBuy\": 0, \"freeRed\": 0, \"watchAd\": [], \"gameTime\": 0, \"redCount\": [], \"buyDiamond\": 0, \"floorCount\": 0, \"plantCount\": 0, \"dropRedCount\": 0, \"creationValue\": 0, \"plantAccCount\": 0, \"shopMakeCount\": 0, \"plantRandReward\": [], \"shopUnlockCount\": 0, \"farmFeedAccCount\": 0, \"shopMakeAccCount\": 0}, \"buyDiamond\": {\"isWatchAd\": false}, \"dialReward\": {\"money\": 0, \"stime\": 0, \"times\": 0, \"bigred\": 0, \"isvido\": 0, \"diamond\": 0, \"hugered\": 0, \"todaylogin\": 0}, \"gainDouble\": {\"farmDouble\": false, \"shopDouble\": false, \"plantDouble\": false}, \"landUnlock\": {\"farm\": false, \"plat\": false, \"shop\": false, \"plant\": true}, \"loginCount\": 0, \"npcredpckt\": {\"pool\": 1, \"stime\": 0, \"awards\": [], \"kitten\": 1, \"todaydt\": [], \"littecrad\": 1, \"poolvideo\": 0, \"kittenvideo\": 0, \"litcradvideo\": 0, \"litcradvideo2\": 0, \"litcradvideo3\": 0}, \"saving_pot\": {\"money\": 0, \"time_s\": 0, \"isbaodi\": 0, \"txtimes\": 0, \"totalmoney\": 0, \"isoldplayer\": 0}, \"allDataStat\": {\"cash\": 0, \"adRed\": 0, \"diamond\": 0, \"fallRed\": 0, \"freeRed\": 0, \"creationValue\": 0}, \"annimalhome\": {\"cow\": [], \"pig\": [], \"stime\": 0, \"isopen\": 0, \"chicken\": [], \"isvideo\": 0, \"cowfodder\": 50, \"pigfodder\": 50, \"unlockhome1\": 1, \"unlockhome2\": 1, \"unlockhome3\": 1, \"chickenfodder\": 50}, \"lastAdValue\": 0, \"levelReward\": [], \"adDialProfit\": 0, \"adMainProfit\": 0, \"clickAdCount\": 0, \"everydaygift\": {\"stime\": 1, \"times\": 0, \"showmy\": 0, \"dangwei\": [], \"todaylogin\": 0, \"tixiantimes\": []}, \"isTodayFloor\": true, \"npcRedPacket\": 0, \"watchAdCount\": 0, \"watchAdAction\": {\"isAdJudge\": true, \"isGainCash\": true, \"unlockTime\": 0, \"seriesCount\": 0, \"nextLimitLevel\": 0}, \"lastLogintTime\": 0, \"loginSeriesDay\": 1, \"adDayGiftProfit\": 0, \"adSavingPotEcpm\": 0, \"lastDayGainCash\": 0, \"todayLoginCount\": 0, \"gameWatchAdCount\": 0, \"lastDayCreationValue\": 0}', 1635390630);
|
||
|
||
-- ----------------------------
|
||
-- Table structure for real_identity
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `real_identity`;
|
||
CREATE TABLE `real_identity` (
|
||
`ID` int(11) NOT NULL,
|
||
`Name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
|
||
`IdentityCard` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
|
||
PRIMARY KEY (`ID`) USING BTREE
|
||
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of real_identity
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for rewardcenter
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `rewardcenter`;
|
||
CREATE TABLE `rewardcenter` (
|
||
`itemId` int(10) NOT NULL COMMENT '道具id',
|
||
`type` int(10) NULL DEFAULT NULL COMMENT '1-种植园 2-养殖场 3-商店',
|
||
`curCount` int(10) NULL DEFAULT NULL COMMENT '今日当前数量',
|
||
`allCount` int(10) NULL DEFAULT NULL COMMENT '每日总的数量'
|
||
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of rewardcenter
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for serverinfo
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `serverinfo`;
|
||
CREATE TABLE `serverinfo` (
|
||
`userVersion` int(10) NULL DEFAULT NULL
|
||
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '当前的用户数据版本' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of serverinfo
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for statalluserdata
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `statalluserdata`;
|
||
CREATE TABLE `statalluserdata` (
|
||
`UserType` int(11) NULL DEFAULT NULL COMMENT '1-新玩家 2-老玩家',
|
||
`DataType` int(11) NULL DEFAULT NULL COMMENT '类型 1-创造价值 2-提现数量',
|
||
`AllCount` float(11, 2) NULL DEFAULT NULL COMMENT '数量',
|
||
`RecordTime` int(11) NULL DEFAULT NULL COMMENT '记录时间（时间戳）'
|
||
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of statalluserdata
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for statbaseinfo
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `statbaseinfo`;
|
||
CREATE TABLE `statbaseinfo` (
|
||
`ActiveUser` int(11) NULL DEFAULT NULL COMMENT '活跃人数',
|
||
`ActiveNewUser` int(11) NULL DEFAULT NULL COMMENT '新活跃人数',
|
||
`ActiveOldUser` int(11) NULL DEFAULT NULL COMMENT '老活跃人数',
|
||
`ActiveARPU` int(11) NULL DEFAULT NULL COMMENT '活跃ARPU',
|
||
`CashARPU` int(11) NULL DEFAULT NULL COMMENT '提现ARPU',
|
||
`ActiveNewARPU` int(11) NULL DEFAULT NULL COMMENT '新活跃ARPU',
|
||
`ActiveOldARPU` int(11) NULL DEFAULT NULL COMMENT '老活跃ARPU',
|
||
`CashNewARPU` int(11) NULL DEFAULT NULL COMMENT '新提现ARPU',
|
||
`CashOldARPU` int(11) NULL DEFAULT NULL COMMENT '老提现ARPU',
|
||
`RecordTime` int(11) NULL DEFAULT NULL COMMENT '记录时间（时间戳）'
|
||
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of statbaseinfo
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for statcash
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `statcash`;
|
||
CREATE TABLE `statcash` (
|
||
`UserType` int(11) NULL DEFAULT NULL COMMENT '1新增人数 2老玩家 3活跃玩家',
|
||
`CashCountType` int(11) NULL DEFAULT NULL COMMENT '提现次数类型\r\n1为1次\r\n2为2次\r\n3为3次\r\n4为4次\r\n5为5次\r\n6为6次\r\n7为7次\r\n8为8次\r\n9为9次\r\n10为10次',
|
||
`CashUser` int(11) NULL DEFAULT NULL COMMENT '提现人数',
|
||
`CashMoney` int(11) NULL DEFAULT NULL COMMENT '提现金额',
|
||
`CreationValue` float(11, 2) NULL DEFAULT NULL COMMENT '创造价值',
|
||
`AveCashMoney` float(11, 2) NULL DEFAULT NULL COMMENT '人均提现金额',
|
||
`AveCreationValue` float(11, 2) NULL DEFAULT NULL COMMENT '人均创造价值',
|
||
`AveGameTime` float(11, 2) NULL DEFAULT NULL COMMENT '人均在线时长',
|
||
`AveWatchCount` float(11, 2) NULL DEFAULT NULL COMMENT '人均视频次数',
|
||
`RecordTime` int(11) NULL DEFAULT NULL COMMENT '记录时间（时间戳秒）'
|
||
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of statcash
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for statdetailsinfo
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `statdetailsinfo`;
|
||
CREATE TABLE `statdetailsinfo` (
|
||
`UserType` int(11) NULL DEFAULT NULL COMMENT '1新增人数 2老玩家',
|
||
`UserCount` int(11) NULL DEFAULT NULL COMMENT '人数',
|
||
`AdRedCoin` bigint(16) NULL DEFAULT NULL COMMENT '付费红包币',
|
||
`FreeRedCoin` bigint(16) NULL DEFAULT NULL COMMENT '免费红包币',
|
||
`SaveCoin` bigint(16) NULL DEFAULT NULL COMMENT '存钱币',
|
||
`CreationValue` bigint(16) NULL DEFAULT NULL COMMENT '创造价值',
|
||
`GoldValue` bigint(16) NULL DEFAULT NULL COMMENT '财神价值',
|
||
`AllGainCash` bigint(16) NULL DEFAULT NULL COMMENT '所有提现金额',
|
||
`GoldGainCash` bigint(16) NULL DEFAULT NULL COMMENT '财神提现金额',
|
||
`SaveGainCash` bigint(16) NULL DEFAULT NULL COMMENT '存钱罐提现金额',
|
||
`DialGainCash` bigint(16) NULL DEFAULT NULL COMMENT '转盘提现金额',
|
||
`RecordTime` int(11) NULL DEFAULT NULL COMMENT '记录时间（时间戳秒）'
|
||
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of statdetailsinfo
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for statretention
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `statretention`;
|
||
CREATE TABLE `statretention` (
|
||
`ID` int(11) NOT NULL AUTO_INCREMENT,
|
||
`NewUser` int(11) NULL DEFAULT NULL COMMENT '新增人数',
|
||
`2DayCount` int(11) NULL DEFAULT NULL COMMENT '次留',
|
||
`3DayCount` int(11) NULL DEFAULT NULL,
|
||
`4DayCount` int(11) NULL DEFAULT NULL,
|
||
`5DayCount` int(11) NULL DEFAULT NULL COMMENT '5留',
|
||
`6DayCount` int(11) NULL DEFAULT NULL,
|
||
`7DayCount` int(11) NULL DEFAULT NULL,
|
||
`8DayCount` int(11) NULL DEFAULT NULL,
|
||
`9DayCount` int(11) NULL DEFAULT NULL COMMENT '9留',
|
||
`RecordTime` int(11) NULL DEFAULT NULL COMMENT '记录时间（时间戳）',
|
||
PRIMARY KEY (`ID`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of statretention
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for statwatchmovie
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `statwatchmovie`;
|
||
CREATE TABLE `statwatchmovie` (
|
||
`UserType` int(11) NOT NULL COMMENT '1新增人数 2老玩家 3活跃玩家',
|
||
`WatchCountType` int(11) NULL DEFAULT NULL COMMENT '观看视频次数类型\r\n0 为 0次\r\n1 为 1-4\r\n2 为 5-9\r\n3 为 10-19\r\n4 为 20-29\r\n5 为 30-39\r\n6 为 40-49\r\n7 为 50-59\r\n8 为 60-69\r\n9 为 70-79\r\n10 为 80-89\r\n11 为 90-99\r\n12 为 100-119\r\n13 为 120-149\r\n14 为 150-179\r\n15 为 180-199\r\n16 为 200以上',
|
||
`UserCount` int(11) NULL DEFAULT NULL COMMENT '当前用户类型观看视频人数',
|
||
`WatchUserRatio` int(11) NULL DEFAULT NULL COMMENT '当前用户类型观看视频人数占比',
|
||
`WatchMovieCount` int(11) NULL DEFAULT NULL COMMENT '当前用户类型观看视频次数',
|
||
`WatchMovieRatio` int(11) NULL DEFAULT NULL COMMENT '当前用户类型观看视频次数占比',
|
||
`AveWatchMovieCount` int(11) NULL DEFAULT NULL COMMENT '当前用户类型观看视频人均观看次数',
|
||
`RecordTime` int(11) NULL DEFAULT NULL COMMENT '记录时间（时间戳秒）'
|
||
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of statwatchmovie
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for uppoint
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `uppoint`;
|
||
CREATE TABLE `uppoint` (
|
||
`UDID` char(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
|
||
`PointType` int(10) NULL DEFAULT NULL,
|
||
`RecordTime` int(11) NULL DEFAULT NULL
|
||
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of uppoint
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for user
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `user`;
|
||
CREATE TABLE `user` (
|
||
`id` int(10) NOT NULL AUTO_INCREMENT,
|
||
`account` char(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
|
||
`pwd` char(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
|
||
`name` char(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
|
||
`loginType` int(10) NULL DEFAULT NULL COMMENT '1-本地登陆 2-微信登陆',
|
||
`accountStatus` int(10) NULL DEFAULT NULL COMMENT '1-正常状态 2-白名单 3-灰名单 4-黑名单',
|
||
`token` char(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
|
||
`regTime` int(11) NULL DEFAULT NULL COMMENT '注册时间',
|
||
`regIP` char(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '注册IP',
|
||
`lastLoginTime` int(11) NULL DEFAULT NULL COMMENT '最后一次登陆时间',
|
||
`lastLoginIP` char(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '最后一次登陆IP',
|
||
`lastServerId` int(11) NULL DEFAULT NULL COMMENT '最后一次登陆服务器的ID',
|
||
`RealName` char(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '真实姓名',
|
||
`IdentityCard` char(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '身份证\r\n',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 100026 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of user
|
||
-- ----------------------------
|
||
INSERT INTO `user` VALUES (100025, 'r1', NULL, '我是人', 1, 1, '', 1635390630, '172.16.1.245', 1635390630, '172.16.1.245', NULL, NULL, NULL);
|
||
|
||
-- ----------------------------
|
||
-- Table structure for user_device_info
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `user_device_info`;
|
||
CREATE TABLE `user_device_info` (
|
||
`id` int(11) NOT NULL COMMENT '玩家ID',
|
||
`adDeviceParam` json NULL COMMENT '广告平台的设备信息',
|
||
`aDeviceParam` json NULL COMMENT 'APP的设备信息',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of user_device_info
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for user_device_infor
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `user_device_infor`;
|
||
CREATE TABLE `user_device_infor` (
|
||
`id` int(11) NOT NULL,
|
||
`adDeviceInfor` json NULL COMMENT '广告过来的设备信息',
|
||
`appDeviceInfor` json NULL COMMENT 'APP过来的设备信息',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of user_device_infor
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for warning
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `warning`;
|
||
CREATE TABLE `warning` (
|
||
`id` int(10) NOT NULL,
|
||
`type` int(10) NULL DEFAULT NULL,
|
||
`recordTime` int(12) NULL DEFAULT NULL
|
||
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of warning
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Procedure structure for ADCount
|
||
-- ----------------------------
|
||
DROP PROCEDURE IF EXISTS `ADCount`;
|
||
delimiter ;;
|
||
CREATE PROCEDURE `ADCount`()
|
||
BEGIN
|
||
DECLARE adCount int default 0;
|
||
DECLARE i INT DEFAULT 0;
|
||
select json_length(JSON_EXTRACT(player.data,'$.allAdInfo')) from player where player.id = 100000 into adCount;
|
||
|
||
WHILE i < adCount DO
|
||
select JSON_EXTRACT(JSON_EXTRACT(player.data,'$.allAdInfo'), '$[1].count') as a1 from player where player.id = 100000;
|
||
set i = i + 1;
|
||
END WHILE;
|
||
|
||
END
|
||
;;
|
||
delimiter ;
|
||
|
||
SET FOREIGN_KEY_CHECKS = 1;
|