File size: 3,902 Bytes
183a3de
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
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
/*

 Navicat Premium Data Transfer



 Source Server         : ndq

 Source Server Type    : MySQL

 Source Server Version : 100432

 Source Host           : localhost:3306

 Source Schema         : base-dql



 Target Server Type    : MySQL

 Target Server Version : 100432

 File Encoding         : 65001



 Date: 25/11/2024 16:16:54

*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for account
-- ----------------------------
DROP TABLE IF EXISTS `account`;
CREATE TABLE `account`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `username` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `password` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `create_time` timestamp NULL DEFAULT current_timestamp,
  `update_time` timestamp NULL DEFAULT current_timestamp,
  `ban` smallint NOT NULL DEFAULT 0,
  `point_post` int NOT NULL DEFAULT 0,
  `last_post` int NOT NULL DEFAULT 0,
  `role` int NOT NULL DEFAULT -1,
  `is_admin` tinyint(1) NOT NULL DEFAULT 0,
  `last_time_login` timestamp NOT NULL DEFAULT '2002-05-07 14:00:00',
  `last_time_logout` timestamp NOT NULL DEFAULT '2002-05-07 14:00:00',
  `ip_address` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `active` int NOT NULL DEFAULT 0,
  `thoi_vang` int NOT NULL DEFAULT 0,
  `server_login` int NOT NULL DEFAULT -1,
  `bd_player` double NULL DEFAULT 1,
  `is_gift_box` tinyint(1) NULL DEFAULT 0,
  `gift_time` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0',
  `reward` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
  `vnd` varchar(360) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0',
  `tongnap` int NOT NULL,
  `account_count` int NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `username`(`username` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of account
-- ----------------------------
INSERT INTO `account` VALUES (1, 'ndq', 'ndq', '2024-10-29 09:44:05', '2024-10-29 09:44:05', 0, 0, 0, -1, 0, '2002-05-07 14:00:00', '2002-05-07 14:00:00', NULL, 0, 0, -1, 1, 0, '0', NULL, '0', 0, NULL);

-- ----------------------------
-- Table structure for players_zalo
-- ----------------------------
DROP TABLE IF EXISTS `players_zalo`;
CREATE TABLE `players_zalo`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `username` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `idUserZalo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '-1',
  `playerName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `balance` varchar(360) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '10000',
  `registrationTime` datetime NULL DEFAULT NULL,
  `totalWinnings` decimal(65, 0) NULL DEFAULT 0,
  `totalLosses` decimal(65, 0) NULL DEFAULT 0,
  `netProfit` bigint NULL DEFAULT 0,
  `totalWinGames` bigint NULL DEFAULT 0,
  `totalGames` bigint NULL DEFAULT 0,
  `winRate` decimal(5, 2) NULL DEFAULT 0.00,
  `lastDailyReward` datetime NULL DEFAULT NULL,
  `isBanned` tinyint(1) NULL DEFAULT 0,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `username`(`username` ASC) USING BTREE,
  INDEX `idUserZalo`(`idUserZalo` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of players_zalo
-- ----------------------------
INSERT INTO `players_zalo` VALUES (1, 'ndq', '4903936046638016387', 'N D Q', '3270000000', '2024-10-29 09:44:05', 2128684243317, -639301612860, 0, 37, 64, 57.81, '2024-11-19 18:59:06', 0);

SET FOREIGN_KEY_CHECKS = 1;