-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathactive_users.sql
More file actions
30 lines (24 loc) · 895 Bytes
/
Copy pathactive_users.sql
File metadata and controls
30 lines (24 loc) · 895 Bytes
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
/*
Navicat MySQL Data Transfer
Source Server : dmt
Source Server Type : MySQL
Source Server Version : 50628
Source Host : 5780e03864e11.sh.cdb.myqcloud.com:4201
Source Schema : multimedia
Target Server Type : MySQL
Target Server Version : 50628
File Encoding : 65001
Date: 14/09/2019 01:56:27
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for active_users
-- ----------------------------
DROP TABLE IF EXISTS `active_users`;
CREATE TABLE `active_users` (
`active_id` int(8) NOT NULL COMMENT '8位活动id',
`user_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '32位用户id',
`join_time` datetime(0) NOT NULL COMMENT '加入时间'
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
SET FOREIGN_KEY_CHECKS = 1;