· 6 years ago · Jan 15, 2020, 07:12 PM
1/*
2 Navicat Premium Data Transfer
3
4 Source Server : iveyas2
5 Source Server Type : MySQL
6 Source Server Version : 50726
7 Source Host : 51.75.36.164:3306
8 Source Schema : account
9
10 Target Server Type : MySQL
11 Target Server Version : 50726
12 File Encoding : 65001
13
14 Date: 15/01/2020 20:09:40
15*/
16
17SET NAMES utf8mb4;
18SET FOREIGN_KEY_CHECKS = 0;
19
20-- ----------------------------
21-- Table structure for account
22-- ----------------------------
23DROP TABLE IF EXISTS `account`;
24CREATE TABLE `account` (
25 `id` int(11) NOT NULL AUTO_INCREMENT,
26 `login` varchar(24) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT '',
27 `password` varchar(45) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT '',
28 `real_name` varchar(16) CHARACTER SET ascii COLLATE ascii_general_ci NULL DEFAULT NULL,
29 `social_id` varchar(13) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT '',
30 `email` varchar(64) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT '',
31 `phone1` varchar(16) CHARACTER SET ascii COLLATE ascii_general_ci NULL DEFAULT NULL,
32 `phone2` varchar(16) CHARACTER SET ascii COLLATE ascii_general_ci NULL DEFAULT NULL,
33 `address` varchar(128) CHARACTER SET ascii COLLATE ascii_general_ci NULL DEFAULT NULL,
34 `zipcode` varchar(7) CHARACTER SET ascii COLLATE ascii_general_ci NULL DEFAULT NULL,
35 `create_time` datetime(0) NOT NULL,
36 `question1` char(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
37 `answer1` char(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
38 `question2` varchar(48) CHARACTER SET ascii COLLATE ascii_general_ci NULL DEFAULT NULL,
39 `answer2` varchar(48) CHARACTER SET ascii COLLATE ascii_general_ci NULL DEFAULT NULL,
40 `is_testor` tinyint(1) NOT NULL DEFAULT 0,
41 `status` varchar(8) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT 'OK',
42 `securitycode` varchar(192) CHARACTER SET ascii COLLATE ascii_general_ci NULL DEFAULT NULL,
43 `newsletter` tinyint(1) NULL DEFAULT NULL,
44 `empire` tinyint(1) NOT NULL DEFAULT 0,
45 `name_checked` tinyint(1) NOT NULL DEFAULT 0,
46 `availDt` datetime(0) NOT NULL,
47 `mileage` int(11) NOT NULL DEFAULT 0,
48 `cash` int(11) NOT NULL DEFAULT 0,
49 `gold_expire` datetime(0) NOT NULL,
50 `silver_expire` datetime(0) NOT NULL,
51 `safebox_expire` datetime(0) NOT NULL DEFAULT '2020-01-01 19:00:00',
52 `autoloot_expire` datetime(0) NOT NULL DEFAULT '2020-01-01 19:00:00',
53 `fish_mind_expire` datetime(0) NOT NULL,
54 `marriage_fast_expire` datetime(0) NOT NULL,
55 `money_drop_rate_expire` datetime(0) NOT NULL,
56 `last_play` datetime(0) NULL DEFAULT NULL,
57 `web_admin` int(11) NOT NULL DEFAULT 0,
58 `web_ip` varchar(15) CHARACTER SET ascii COLLATE ascii_general_ci NULL DEFAULT NULL,
59 `web_confirm` varchar(32) CHARACTER SET ascii COLLATE ascii_general_ci NULL DEFAULT NULL,
60 `avatar` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
61 `newpassword` varchar(90) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
62 `date_password_recover` datetime(0) NULL DEFAULT NULL,
63 `newcode` varchar(90) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
64 `newemail` varchar(90) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
65 `newpassword_hash` varchar(90) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
66 `newpassword_mag` varchar(90) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
67 `newpassword_mag_hash` varchar(90) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
68 `newemail_hash` varchar(90) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
69 `newcode_hash` varchar(90) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
70 `password_recover` varchar(90) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
71 `active_hash` varchar(90) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
72 `ban_by` int(11) NULL DEFAULT NULL,
73 `ban_date` datetime(0) NULL DEFAULT NULL,
74 `ban_reason` varchar(255) CHARACTER SET ascii COLLATE ascii_general_ci NULL DEFAULT NULL,
75 `warning_level` int(2) NULL DEFAULT NULL,
76 `coins` int(2) NULL DEFAULT NULL,
77 `return` int(11) NOT NULL DEFAULT 0,
78 `pin` varchar(4) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT '0000',
79 `last_activity` datetime(0) NULL DEFAULT NULL,
80 `p_reference_id` varchar(25) CHARACTER SET ascii COLLATE ascii_general_ci NULL DEFAULT NULL,
81 `email_change_token` varchar(255) CHARACTER SET ascii COLLATE ascii_general_ci NULL DEFAULT NULL,
82 `email_change_token_created_at` datetime(0) NULL DEFAULT NULL,
83 `password_reset_token` varchar(255) CHARACTER SET ascii COLLATE ascii_general_ci NULL DEFAULT NULL,
84 `password_reset_token_created_at` datetime(0) NULL DEFAULT NULL,
85 `last_ip` varchar(255) CHARACTER SET ascii COLLATE ascii_general_ci NULL DEFAULT NULL,
86 `created_at` datetime(0) NULL DEFAULT NULL,
87 `updated_at` datetime(0) NULL DEFAULT NULL,
88 `banned_by` varchar(255) CHARACTER SET ascii COLLATE ascii_general_ci NULL DEFAULT NULL,
89 `reference_id` int(11) NULL DEFAULT NULL,
90 `admin` tinyint(1) NULL DEFAULT 0,
91 `has_reflink` tinyint(1) NULL DEFAULT NULL,
92 `reflink_count` tinyint(11) NULL DEFAULT NULL,
93 `referal_id` int(11) NULL DEFAULT NULL,
94 `token` varchar(255) CHARACTER SET ascii COLLATE ascii_general_ci NULL DEFAULT NULL,
95 PRIMARY KEY (`id`) USING BTREE,
96 UNIQUE INDEX `login`(`login`) USING BTREE,
97 INDEX `social_id`(`social_id`) USING BTREE
98) ENGINE = InnoDB AUTO_INCREMENT = 1165 CHARACTER SET = ascii COLLATE = ascii_general_ci ROW_FORMAT = Dynamic;
99
100SET FOREIGN_KEY_CHECKS = 1;