forked from hlxing/fzuTimeMachine
-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathtimemachine.sql
More file actions
128 lines (117 loc) · 5.7 KB
/
Copy pathtimemachine.sql
File metadata and controls
128 lines (117 loc) · 5.7 KB
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
126
127
128
/*
Navicat Premium Data Transfer
Source Server : 本地
Source Server Type : MySQL
Source Server Version : 50149
Source Host : localhost:3306
Source Schema : timemachine
Target Server Type : MySQL
Target Server Version : 50149
File Encoding : 65001
Date: 15/10/2018 19:52:54
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for time
-- ----------------------------
DROP TABLE IF EXISTS `time`;
CREATE TABLE `time` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`userId` int(11) NULL DEFAULT NULL,
`title` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`imgUrl` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`content` varchar(1024) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`longitude` double(255, 0) NULL DEFAULT NULL,
`latitude` double(255, 0) NULL DEFAULT NULL,
`createTime` bigint(20) NULL DEFAULT NULL,
`updateTime` bigint(20) NULL DEFAULT NULL,
`label` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`praiseNum` int(11) NULL DEFAULT NULL,
`checkStatus` TINYINT(1) NULL DEFAULT NULL,
`visible` TINYINT(1) NULL DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
)
ENGINE = InnoDB
AUTO_INCREMENT = 23
CHARACTER SET = utf8
COLLATE = utf8_general_ci
ROW_FORMAT = COMPACT;
-- ----------------------------
-- Records of time
-- ----------------------------
INSERT INTO `time` VALUES
(13, 1, 'a nice day', 'cloud.huanglexing.com/17d906da2a0442d482db49a9646bd368', 'a b c d e', 57, 113, 1538579661161,
1538579661161, 'happy', 0, 1, 1);
INSERT INTO `time` VALUES
(14, 1, 'a bad day', 'cloud.huanglexing.com/17d906da2a0442d482db49a9646bd368', 'a b c d e', 57, 113, 1538579661161,
1538579661161, 'happy', 0, 1, 0);
INSERT INTO `time` VALUES
(15, 3, 'a nice day', 'cloud.huanglexing.com/17d906da2a0442d482db49a9646bd368', 'a b c d e', 57, 113, 1538579661161,
1538579661161, 'happy', 0, 0, 0);
INSERT INTO `time` VALUES
(16, 4, 'a nice day', 'cloud.huanglexing.com/17d906da2a0442d482db49a9646bd368', 'a b c d e', 57, 113, 1538579661161,
1538579661161, 'happy', 0, 0, 0);
INSERT INTO `time` VALUES
(17, 5, 'a nice day', 'cloud.huanglexing.com/17d906da2a0442d482db49a9646bd368', 'a b c d e', 57, 113, 1538579661161,
1538579661161, 'happy', 0, 0, 0);
INSERT INTO `time` VALUES
(21, 1, '那个食堂', 'cloud.huanglexing.com/19c7ce3dcfc64769866c165d7f2c9bb8', '真好吃!', 119, 26, 1539489412210,
1539489412210, '食堂+美食', 0, 0, 1);
INSERT INTO `time` VALUES
(22, 1, '那个食堂', 'cloud.huanglexing.com/5c174090214a4ce7ac19a9d95573c0eb', '真好吃!', NULL, NULL, 1539489719550,
1539489719550, '食堂+美食', 0, 0, 0);
-- ----------------------------
-- Table structure for time_collection
-- ----------------------------
DROP TABLE IF EXISTS `time_collection`;
CREATE TABLE `time_collection` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`userId` int(11) NULL DEFAULT NULL,
`timeId` int(11) NULL DEFAULT NULL,
`createTime` bigint(20) NULL DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
)
ENGINE = InnoDB
AUTO_INCREMENT = 2
CHARACTER SET = utf8
COLLATE = utf8_general_ci
ROW_FORMAT = COMPACT;
-- ----------------------------
-- Table structure for time_praise
-- ----------------------------
DROP TABLE IF EXISTS `time_praise`;
CREATE TABLE `time_praise` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`userId` int(11) NULL DEFAULT NULL,
`timeId` int(11) NULL DEFAULT NULL,
`createTime` bigint(20) NULL DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
)
ENGINE = InnoDB
AUTO_INCREMENT = 3
CHARACTER SET = utf8
COLLATE = utf8_general_ci
ROW_FORMAT = COMPACT;
-- ----------------------------
-- Table structure for wechat_user
-- ----------------------------
DROP TABLE IF EXISTS `wechat_user`;
CREATE TABLE `wechat_user` (
`userId` int(11) NOT NULL AUTO_INCREMENT,
`openId` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`nickName` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`gender` int(11) NULL DEFAULT NULL,
`avatarUrl` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`country` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`province` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`city` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`language` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`createTime` bigint(20) NULL DEFAULT NULL,
PRIMARY KEY (`userId`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
-- ----------------------------
-- Records of wechat_user
-- ----------------------------
INSERT INTO `wechat_user` VALUES (1, 'oi4T64i99AgPnFrPl4SEz9oaOKFo', 'Hlx', 1, 'https://wx.qlogo.cn/mmopen/vi_32/Q0j4TwGTfTKPt3hefZ5CMYbCiag7icR4vUKffpian3Pbtovm54TE5hO2FfY7RTLCDcrSr8EU60hfibnw05LHEXICeA/132', 'China', 'Fujian', 'Xiamen', 'zh_CN', 1538474959);
SET FOREIGN_KEY_CHECKS = 1;