3VY0DjcX

1/*
2 Navicat Premium Data Transfer
3
4 Source Server         : new
5 Source Server Type    : MySQL
6 Source Server Version : 100136
7 Source Host           : localhost:3306
8 Source Schema         : arcturus
9
10 Target Server Type    : MySQL
11 Target Server Version : 100136
12 File Encoding         : 65001
13
14 Date: 26/08/2019 23:28:52
15*/
16
17SET NAMES utf8mb4;
18SET FOREIGN_KEY_CHECKS = 0;
19
20-- ----------------------------
21-- Table structure for users
22-- ----------------------------
23DROP TABLE IF EXISTS `users`;
24CREATE TABLE `users`  (
25  `id` int(11) NOT NULL AUTO_INCREMENT,
26  `username` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
27  `real_name` varchar(25) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
28  `password` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
29  `mail` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
30  `mail_verified` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
31  `account_created` int(11) NOT NULL,
32  `account_day_of_birth` int(11) NOT NULL DEFAULT 0,
33  `last_login` int(11) NOT NULL DEFAULT 0,
34  `last_online` int(11) NOT NULL DEFAULT 0,
35  `motto` varchar(127) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
36  `look` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'hr-115-42.hd-195-19.ch-3030-82.lg-275-1408.fa-1201.ca-1804-64',
37  `gender` enum('M','F') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'M',
38  `rank` int(2) NOT NULL DEFAULT 1,
39  `credits` int(11) NOT NULL DEFAULT 2500,
40  `pixels` int(11) NOT NULL DEFAULT 500,
41  `points` int(11) NOT NULL DEFAULT 10,
42  `online` enum('0','1','2') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
43  `auth_ticket` varchar(256) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
44  `ip_register` varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
45  `ip_current` varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'Have your CMS update this IP. If you do not do this IP banning won\'t work!',
46  `machine_id` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
47  `home_room` int(32) NOT NULL DEFAULT 0,
48  `theme` int(11) NULL DEFAULT 1,
49  `date_of_birth` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
50  `fbid` int(11) NULL DEFAULT NULL,
51  `rank_2` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
52  `let_it_snow` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
53  `profile_ads` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
54  `chest_points` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
55  `support_tickets_alert` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
56  `logged_in` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
57  PRIMARY KEY (`id`) USING BTREE,
58  UNIQUE INDEX `username`(`username`) USING BTREE,
59  UNIQUE INDEX `id`(`id`) USING BTREE,
60  UNIQUE INDEX `id_2`(`id`) USING BTREE,
61  UNIQUE INDEX `id_3`(`id`) USING BTREE
62) ENGINE = InnoDB AUTO_INCREMENT = 16 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
63
64-- ----------------------------
65-- Records of users
66-- ----------------------------
67INSERT INTO `users` VALUES (1, 'tameuser100tarantula', '', '373d8abd9cf2bc85e66f6d03b8b886eddcb242fcaf9ae0f4c9e7af377e477cde', 'user100@user100.com', '0', 1563731643, 0, 0, 0, 'I\'m an Arcturus Lover!', 'hr-115-42.hd-195-19.ch-3030-82.lg-275-1408.fa-1201.ca-1804-64', 'M', 5, 2500, 500, 10, '0', '', '', '192.168.1.1', '', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);