· 6 years ago · Nov 19, 2019, 04:00 PM
1-- MySQL dump 10.16 Distrib 10.1.38-MariaDB, for debian-linux-gnueabihf (armv7l)
2--
3-- Host: localhost Database: cowbot
4-- ------------------------------------------------------
5-- Server version 10.1.38-MariaDB-0+deb9u1
6
7/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
8/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
9/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
10/*!40101 SET NAMES utf8mb4 */;
11/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
12/*!40103 SET TIME_ZONE='+00:00' */;
13/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
14/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
15/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
16/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
17
18--
19-- Table structure for table `members`
20--
21
22DROP TABLE IF EXISTS `members`;
23/*!40101 SET @saved_cs_client = @@character_set_client */;
24/*!40101 SET character_set_client = utf8 */;
25CREATE TABLE `members` (
26 `userID` bigint(20) unsigned NOT NULL,
27 `serverID` bigint(20) unsigned NOT NULL,
28 `messageAmount` int(10) unsigned NOT NULL
29) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
30/*!40101 SET character_set_client = @saved_cs_client */;
31
32--
33-- Dumping data for table `members`
34--
35
36LOCK TABLES `members` WRITE;
37/*!40000 ALTER TABLE `members` DISABLE KEYS */;
38INSERT INTO `members` VALUES (317968962656796674,351093448499134466,16083),(297739448060346368,351093448499134466,2101),(351022328055988225,351093448499134466,15802),(289083630943338509,351093448499134466,1),(477112955532607488,351093448499134466,108),(367068267984191488,351093448499134466,569),(490248803837018112,351093448499134466,23413),(337697353018507269,351093448499134466,29),(477401313479753728,351093448499134466,37),(437320387693510667,351093448499134466,3),(451001096438153216,351093448499134466,1),(247047606910320640,351093448499134466,1146),(597960317603151872,351093448499134466,6),(633322388217528321,351093448499134466,5),(284422638703476747,351093448499134466,2947),(377760827165376522,351093448499134466,1243),(148037341666082816,351093448499134466,50),(345967149396918283,351093448499134466,7),(258707244676284431,351093448499134466,12),(523545167211266068,351093448499134466,4),(281515362267299850,351093448499134466,1334),(475617257305931776,351093448499134466,50),(497579754099179520,351093448499134466,32),(484461468318826511,351093448499134466,3),(364048564944502784,351093448499134466,12),(492426763796873216,351093448499134466,115),(388731578865418252,351093448499134466,68),(585894822188023819,351093448499134466,51),(347687302970998784,351093448499134466,77),(447296977017896972,351093448499134466,85),(445627914617356288,351093448499134466,5),(530769298537578518,351093448499134466,16),(286116265611755520,351093448499134466,2),(394928014183366657,351093448499134466,21),(385481678484799490,351093448499134466,11),(347416067666345984,351093448499134466,44),(497514338517647360,351093448499134466,3),(413782240590430208,351093448499134466,4),(369135157493366784,351093448499134466,5),(485046038940352512,351093448499134466,1),(438970069180219393,351093448499134466,4),(470589581725532172,351093448499134466,26),(453225306413727754,351093448499134466,7),(485868983325687818,351093448499134466,1),(467614873254101002,351093448499134466,16),(481938430251499521,351093448499134466,1),(466942800437444609,351093448499134466,26),(367022839829889025,351093448499134466,4),(408354621061464065,351093448499134466,3),(452900711546617877,351093448499134466,3),(249251452353118208,351093448499134466,9),(473202266296418305,351093448499134466,2),(285126079226839050,351093448499134466,4),(427098830757167106,351093448499134466,2),(428978744640667659,351093448499134466,12),(387210824436940801,351093448499134466,8),(212334894716551169,351093448499134466,49),(480700143759261717,351093448499134466,4),(631466995505954820,617311457025196042,7),(297077339135803392,617311457025196042,0),(597960317603151872,593186331283292181,9),(490248803837018112,593186331283292181,0),(176653635818749952,617311457025196042,8),(176653635818749952,594051998614159360,33),(490248803837018112,594051998614159360,14),(603934554025361439,617311457025196042,0);
39/*!40000 ALTER TABLE `members` ENABLE KEYS */;
40UNLOCK TABLES;
41
42--
43-- Table structure for table `servers`
44--
45
46DROP TABLE IF EXISTS `servers`;
47/*!40101 SET @saved_cs_client = @@character_set_client */;
48/*!40101 SET character_set_client = utf8 */;
49CREATE TABLE `servers` (
50 `ID` bigint(20) unsigned NOT NULL,
51 `memberAmount` int(10) unsigned NOT NULL,
52 `ownerID` bigint(20) unsigned NOT NULL,
53 `config` varchar(10000) NOT NULL
54) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
55/*!40101 SET character_set_client = @saved_cs_client */;
56
57--
58-- Dumping data for table `servers`
59--
60
61LOCK TABLES `servers` WRITE;
62/*!40000 ALTER TABLE `servers` DISABLE KEYS */;
63INSERT INTO `servers` VALUES (617311457025196042,22,631466995505954820,'{}'),(594051998614159360,25,148037341666082816,'{}'),(351093448499134466,88,351022328055988225,'{\"language\": \"fr_FR\", \"prefix\": \"_\", \"welcomeMessage\": \"Bienvenue [member] !!! Tape _captcha dans le salon <#637426723658530859> pour avoir acc\\u00e8s au autres salons !!\", \"welcomeChannel\": 467448215940104192, \"captchaRole\": 429328669522264065, \"logChannel\": 622054415846866945}'),(351093448499134466,88,351022328055988225,'{\"language\": \"fr_FR\", \"prefix\": \"_\", \"welcomeMessage\": \"Bienvenue [member] !!! Tape _captcha dans le salon <#637426723658530859> pour avoir acc\\u00e8s au autres salons !!\", \"welcomeChannel\": 467448215940104192, \"captchaRole\": 429328669522264065, \"logChannel\": 622054415846866945}'),(351093448499134466,88,351022328055988225,'{\"language\": \"fr_FR\", \"prefix\": \"_\", \"welcomeMessage\": \"Bienvenue [member] !!! Tape _captcha dans le salon <#637426723658530859> pour avoir acc\\u00e8s au autres salons !!\", \"welcomeChannel\": 467448215940104192, \"captchaRole\": 429328669522264065, \"logChannel\": 622054415846866945}'),(593186331283292181,30,148037341666082816,'{\"language\": \"en_US\", \"prefix\": \"_\", \"captchaRole\": 631214294935273472, \"reactRanks\": {\"633372351932923905\": {\"\\ud83e\\udd56\": 619734034628608021, \"\\ud83e\\udd43\": 619734885887770624, \"\\ud83c\\udf02\": 619734359133519872, \"\\u2753\": 633372391392673793}}}');
64/*!40000 ALTER TABLE `servers` ENABLE KEYS */;
65UNLOCK TABLES;
66
67--
68-- Table structure for table `users`
69--
70
71DROP TABLE IF EXISTS `users`;
72/*!40101 SET @saved_cs_client = @@character_set_client */;
73/*!40101 SET character_set_client = utf8 */;
74CREATE TABLE `users` (
75 `ID` bigint(20) unsigned NOT NULL,
76 `cowcoin` int(10) unsigned NOT NULL,
77 `email` varchar(128) DEFAULT NULL,
78 `newsLetters` tinyint(1) NOT NULL,
79 UNIQUE KEY `ID` (`ID`)
80) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
81/*!40101 SET character_set_client = @saved_cs_client */;
82
83--
84-- Dumping data for table `users`
85--
86
87LOCK TABLES `users` WRITE;
88/*!40000 ALTER TABLE `users` DISABLE KEYS */;
89/*!40000 ALTER TABLE `users` ENABLE KEYS */;
90UNLOCK TABLES;
91/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
92
93/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
94/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
95/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
96/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
97/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
98/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
99/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
100
101-- Dump completed on 2019-11-12 20:50:08