· 6 years ago · May 04, 2019, 06:38 AM
1/*
2 Navicat Premium Data Transfer
3
4 Source Server : OXAT-VPS
5 Source Server Type : MySQL
6 Source Server Version : 50560
7 Source Host : 67.211.220.254:3306
8 Source Schema : oxattop_bot
9
10 Target Server Type : MySQL
11 Target Server Version : 50560
12 File Encoding : 65001
13
14 Date: 13/01/2019 00:23:52
15*/
16
17SET NAMES utf8mb4;
18SET FOREIGN_KEY_CHECKS = 0;
19
20-- ----------------------------
21-- Table structure for bots
22-- ----------------------------
23DROP TABLE IF EXISTS `bots`;
24CREATE TABLE `bots` (
25 `id` int(255) NOT NULL,
26 `xat_id` int(255) NOT NULL,
27 `pid` int(255) NOT NULL,
28 `name` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
29 `nick` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
30 `password` longtext CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
31 `crypt_key` longtext CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
32 `lists` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
33 `settings` longtext CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
34 `accesslist` longtext CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
35 `minranks` longtext CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
36 `userinfo` longtext CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL
37) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Compact;
38
39-- ----------------------------
40-- Records of bots
41-- ----------------------------
42INSERT INTO `bots` VALUES (1, 1905, 16605, 'switch', 'BotPanel(glow#010101#flag#br#d#g2)', '123456789', '2CD97DB5C4B65EDE', '[\"430\",\"209\"]', '{\"room\":\"1\",\"name\":\"BolaDeFogo(glow#010101#flag#br#d#g2)(hat#h#gift)##Ultimo Power [XMASBONUS]\",\"avatar\":\"1\",\"home\":\"oxat.top/Tester\",\"automember\":\"1\",\"autowelcome\":\"Bem Vindo ao OXAT [user] digite !powers para ganhar todos powers ! Tem [users] Online\",\"cmdchar\":\"!\",\"automember\":\"2\"}', '{}', '{}', NULL);
43
44-- ----------------------------
45-- Table structure for dpower
46-- ----------------------------
47DROP TABLE IF EXISTS `dpower`;
48CREATE TABLE `dpower` (
49 `id` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
50 `botid` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
51 `pid` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL
52) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Compact;
53
54-- ----------------------------
55-- Records of dpower
56-- ----------------------------
57INSERT INTO `dpower` VALUES ('1', '1', '35');
58INSERT INTO `dpower` VALUES ('2', '1', '67');
59INSERT INTO `dpower` VALUES ('3', '1', '430');
60
61-- ----------------------------
62-- Table structure for userinfo
63-- ----------------------------
64DROP TABLE IF EXISTS `userinfo`;
65CREATE TABLE `userinfo` (
66 `id` int(55) NOT NULL AUTO_INCREMENT,
67 `username` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
68 `nickname` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
69 `avatar` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
70 `home` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
71 `f` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
72 `rank` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
73 `room` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
74 PRIMARY KEY (`id`) USING BTREE
75) ENGINE = InnoDB AUTO_INCREMENT = 223 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Compact;
76
77SET FOREIGN_KEY_CHECKS = 1;