· 8 years ago · Oct 24, 2017, 01:00 AM
1
2 ____ ____ __ _________ __ __ __________________ ________ __________ __ __________
3 / __ \/ __ ) / / / ____/ | / //_/ / ____/ ____/_ __/ / ____/ / / / ____/ //_// ____/ __ \
4 / / / / __ | / / / __/ / /| | / ,< / / __/ __/ / / / /_ / / / / / / ,< / __/ / / / /
5 / /_/ / /_/ / / /___/ /___/ ___ |/ /| | / /_/ / /___ / / / __/ / /_/ / /___/ /| |/ /___/ /_/ /
6/_____/_____/ /_____/_____/_/ |_/_/ |_| \____/_____/ /_/ /_/ \____/\____/_/ |_/_____/_____/
7
8
9
10-- Adminer 3.3.3 MySQL dump
11
12SET NAMES utf8;
13SET foreign_key_checks = 0;
14SET time_zone = 'SYSTEM';
15SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';
16
17DROP TABLE IF EXISTS `banned_ips`;
18CREATE TABLE `banned_ips` (
19 `ID` int(11) NOT NULL,
20 `ips_banned` varchar(255) NOT NULL,
21 PRIMARY KEY (`ID`)
22) ENGINE=InnoDB DEFAULT CHARSET=latin1;
23
24
25DROP TABLE IF EXISTS `bans`;
26CREATE TABLE `bans` (
27 `ID` int(11) NOT NULL AUTO_INCREMENT,
28 `Moderator` char(12) NOT NULL,
29 `Player` int(11) unsigned NOT NULL,
30 `Comment` text NOT NULL,
31 `Expiration` int(8) NOT NULL,
32 `Time` int(8) NOT NULL,
33 `Type` smallint(3) unsigned NOT NULL,
34 PRIMARY KEY (`ID`),
35 UNIQUE KEY `Time` (`Time`)
36) ENGINE=InnoDB DEFAULT CHARSET=latin1;
37
38
39DROP TABLE IF EXISTS `friends`;
40CREATE TABLE `friends` (
41 `ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
42 `Accepted` text NOT NULL,
43 `Requests` text NOT NULL,
44 `Besties` text NOT NULL,
45 PRIMARY KEY (`ID`)
46) ENGINE=InnoDB DEFAULT CHARSET=latin1;
47
48
49DROP TABLE IF EXISTS `igloos`;
50CREATE TABLE `igloos` (
51 `ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
52 `Owner` int(10) unsigned NOT NULL,
53 `Type` tinyint(3) unsigned NOT NULL DEFAULT '1',
54 `Floor` tinyint(3) unsigned NOT NULL DEFAULT '0',
55 `Music` smallint(6) NOT NULL DEFAULT '0',
56 `Furniture` longtext NOT NULL,
57 `Locked` tinyint(1) NOT NULL DEFAULT '1',
58 PRIMARY KEY (`ID`)
59) ENGINE=InnoDB DEFAULT CHARSET=latin1;
60
61INSERT INTO `igloos` (`ID`, `Owner`, `Type`, `Floor`, `Music`, `Furniture`, `Locked`) VALUES
62(415, 394, 1, 0, 0, '', 1),
63(416, 395, 1, 0, 0, '', 1),
64(417, 396, 1, 0, 0, '', 1),
65(418, 397, 1, 0, 120, '116|403|239|1|1', 1),
66(419, 398, 1, 0, 0, '', 1),
67(420, 399, 1, 0, 0, '', 1),
68(421, 400, 1, 0, 0, '', 1),
69(422, 401, 1, 0, 0, '', 1),
70(423, 402, 1, 0, 0, '', 1),
71(424, 403, 1, 0, 0, '', 1),
72(425, 404, 1, 0, 0, '', 1),
73(426, 405, 1, 0, 0, '', 1),
74(427, 406, 1, 0, 0, '', 1),
75(428, 407, 1, 0, 0, '', 1),
76(429, 408, 1, 0, 0, '', 1),
77(430, 409, 1, 0, 0, '', 1),
78(431, 410, 1, 0, 0, '', 1),
79(432, 411, 1, 0, 0, '', 1),
80(433, 412, 1, 0, 0, '', 1),
81(434, 413, 1, 0, 0, '', 1),
82(435, 414, 38, 0, 235, '810|370|356|1|2,117|381|368|1|2,640|380|175|2|2,452|556|324|1|1,452|204|324|1|1,418|378|214|2|2,14|381|441|1|7,596|655|77|3|4,596|100|79|1|4,596|653|122|3|4,596|101|122|1|4,596|376|175|2|5', 1),
83(436, 415, 1, 0, 0, '', 1),
84(437, 416, 1, 0, 0, '', 1),
85(438, 417, 1, 0, 0, '', 1),
86(439, 418, 1, 0, 0, '', 1),
87(440, 419, 1, 0, 0, '', 1),
88(441, 420, 1, 0, 0, '', 1),
89(442, 421, 1, 0, 0, '', 1),
90(443, 422, 1, 0, 0, '', 1),
91(444, 423, 1, 0, 0, '', 1),
92(445, 424, 1, 0, 0, '', 1);
93
94DROP TABLE IF EXISTS `penguins`;
95CREATE TABLE `penguins` (
96 `ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
97 `Username` char(16) NOT NULL,
98 `Nickname` char(16) NOT NULL,
99 `Password` varchar(255) NOT NULL,
100 `Avatar` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'Don''t think ID will go beyond 255',
101 `AvatarAttributes` char(98) NOT NULL DEFAULT '{"spriteScale":100,"spriteSpeed":100,"ignoresBlockLayer":false,"invisible":false,"floating":false}',
102 `Email` char(254) NOT NULL,
103 `RegistrationDate` int(8) NOT NULL,
104 `Moderator` tinyint(1) NOT NULL DEFAULT '0',
105 `Inventory` longtext NOT NULL,
106 `CareInventory` text NOT NULL,
107 `Coins` mediumint(7) unsigned NOT NULL DEFAULT '5000',
108 `Igloo` int(10) unsigned NOT NULL DEFAULT '1' COMMENT 'Current active igloo',
109 `Igloos` longtext NOT NULL COMMENT 'Owned igloo types',
110 `Floors` longtext NOT NULL COMMENT 'Owned floorings',
111 `Locations` longtext NOT NULL COMMENT 'Owned locations',
112 `Furniture` longtext NOT NULL COMMENT 'Furniture inventory',
113 `Color` tinyint(3) unsigned NOT NULL DEFAULT '1',
114 `Head` mediumint(5) unsigned NOT NULL DEFAULT '0',
115 `Face` smallint(5) unsigned NOT NULL DEFAULT '0',
116 `Neck` smallint(5) unsigned NOT NULL DEFAULT '0',
117 `Body` varchar(255) NOT NULL DEFAULT '0',
118 `Hand` smallint(5) unsigned NOT NULL DEFAULT '0',
119 `Feet` smallint(5) unsigned NOT NULL DEFAULT '0',
120 `Photo` smallint(5) unsigned NOT NULL DEFAULT '0',
121 `Flag` mediumint(5) unsigned NOT NULL DEFAULT '0',
122 `Walking` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Puffle ID',
123 `Banned` varchar(20) NOT NULL DEFAULT '0' COMMENT 'Timestamp of ban',
124 `Stamps` text NOT NULL,
125 `StampBook` varchar(150) NOT NULL DEFAULT '1%1%1%1',
126 `EPF` varchar(9) NOT NULL DEFAULT '0,0,0',
127 `Buddies` text NOT NULL,
128 `Ignores` text NOT NULL,
129 `MinutesPlayed` int(11) NOT NULL DEFAULT '0',
130 `LastPaycheck` int(11) NOT NULL DEFAULT '0',
131 `Active` int(1) NOT NULL DEFAULT '1',
132 `IP` varchar(5) NOT NULL DEFAULT '0',
133 `Redeemed` varchar(255) NOT NULL,
134 `NinjaBelt` int(11) NOT NULL DEFAULT '0',
135 `NinjaPercentage` int(11) NOT NULL DEFAULT '0',
136 `PuffleQuest` varchar(25) NOT NULL DEFAULT '0,1,|0;0;1403959119;',
137 `Rank` int(1) NOT NULL DEFAULT '1',
138 `halloweenmsg` varchar(255) NOT NULL DEFAULT '0,0,0,0,0',
139 `halloweenquest` varchar(255) NOT NULL DEFAULT '0,0,0,0,0,0,0,0',
140 `halloweenvisited` varchar(255) NOT NULL DEFAULT '0',
141 `transformation` text NOT NULL,
142 `Tracks` text NOT NULL,
143 `invalidLogins` text NOT NULL,
144 `LoginKey` char(32) NOT NULL,
145 `ConfirmationHash` char(32) NOT NULL,
146 `hackedItem` text NOT NULL,
147 `nameglow` varchar(8) NOT NULL,
148 `nameglowstrength` varchar(10) NOT NULL,
149 `bubblecolor` varchar(8) NOT NULL,
150 `bubbletext` varchar(8) NOT NULL,
151 `ringcolor` varchar(8) NOT NULL,
152 `speed` tinyint(3) NOT NULL,
153 `walls` tinyint(1) NOT NULL,
154 `snowball` varchar(8) NOT NULL,
155 `sizex` tinyint(2) NOT NULL,
156 `sizey` tinyint(2) NOT NULL,
157 `transparency` varchar(8) NOT NULL,
158 `rotation` varchar(8) NOT NULL,
159 `glitter` varchar(8) NOT NULL,
160 `fog` varchar(8) NOT NULL,
161 `playercard` varchar(8) NOT NULL,
162 `mood` varchar(8) NOT NULL,
163 `moodcolor` varchar(8) NOT NULL,
164 `headhue` varchar(8) NOT NULL,
165 `facehue` varchar(8) NOT NULL,
166 `neckhue` varchar(8) NOT NULL,
167 `handhue` varchar(8) NOT NULL,
168 `bodyhue` varchar(8) NOT NULL,
169 `feethue` varchar(8) NOT NULL,
170 `iconhue` varchar(8) NOT NULL,
171 `eyecolor` varchar(8) NOT NULL,
172 `beak` varchar(8) NOT NULL,
173 `ringtype` varchar(8) NOT NULL,
174 PRIMARY KEY (`ID`),
175 UNIQUE KEY `Username` (`Username`)
176) ENGINE=InnoDB DEFAULT CHARSET=latin1;
177
178INSERT INTO `penguins` (`ID`, `Username`, `Nickname`, `Password`, `Avatar`, `AvatarAttributes`, `Email`, `RegistrationDate`, `Moderator`, `Inventory`, `CareInventory`, `Coins`, `Igloo`, `Igloos`, `Floors`, `Locations`, `Furniture`, `Color`, `Head`, `Face`, `Neck`, `Body`, `Hand`, `Feet`, `Photo`, `Flag`, `Walking`, `Banned`, `Stamps`, `StampBook`, `EPF`, `Buddies`, `Ignores`, `MinutesPlayed`, `LastPaycheck`, `Active`, `IP`, `Redeemed`, `NinjaBelt`, `NinjaPercentage`, `PuffleQuest`, `Rank`, `halloweenmsg`, `halloweenquest`, `halloweenvisited`, `transformation`, `Tracks`, `invalidLogins`, `LoginKey`, `ConfirmationHash`, `hackedItem`, `nameglow`, `nameglowstrength`, `bubblecolor`, `bubbletext`, `ringcolor`, `speed`, `walls`, `snowball`, `sizex`, `sizey`, `transparency`, `rotation`, `glitter`, `fog`, `playercard`, `mood`, `moodcolor`, `headhue`, `facehue`, `neckhue`, `handhue`, `bodyhue`, `feethue`, `iconhue`, `eyecolor`, `beak`, `ringtype`) VALUES
179(394, 'mazzy', 'mazzy', '$2y$12$3Y1V9eSC.mqt.MJ7eTts5.iy2toKdzqqRwfY3C9EFjzxT0CMt4F5W', 0, '{\"spriteScale\":100,\"spriteSpeed\":100,\"ignoresBlockLayer\":false,\"invisible\":false,\"floating\":false}', 'deadlyfire1337@gmail.com', 1507945103, 1, '%14%1%2%3%4%5%6%7%8%9%10%11%12%13%15%405%244%503%214%221', '', 4435, 415, '1', '', '', '', 14, 405, 0, 214, '0', 0, 0, 0, 503, 0, '0', '79,10,', '1%1%1%1', '0,0,0', '399|Derps%401|Emotional', '', 45, 0, 1, '97.84', '', 0, 0, '0,1,|0;0;1403959119;', 1, '0,0,0,0,0', '0,0,0,0,0,0,0,0', '0', '', '', '', '', '', '', '', '', '', '', '', 0, 0, '', 0, 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
180(395, 'Jack', 'Jack', '$2y$12$ggpQX3as/pE63CqROLmzWe1NgG0h0CdVmZOleRnZGjFBF0864Y1KK', 0, '{\"spriteScale\":100,\"spriteSpeed\":100,\"ignoresBlockLayer\":false,\"invisible\":false,\"floating\":false}', 'Jack@gmail.com', 1507980198, 0, '%14%1%2%3%4%5%6%7%8%9%10%11%12%13%15', '', 5000, 416, '1', '', '', '', 4, 0, 0, 0, '0', 0, 0, 0, 0, 0, '0', '7', '1%1%1%1', '0,0,0', '396|Mario10723%399|Derps', '', 51, 0, 1, '82.8.', '', 0, 0, '0,1,|0;0;1403959119;', 1, '0,0,0,0,0', '0,0,0,0,0,0,0,0', '0', '', '', '', '', '', '', '', '', '', '', '', 0, 0, '', 0, 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
181(396, 'Mario10723', 'Mario10723', '$2y$12$0CXG2Q33fYKYfLQIfD5YY.dqhWHgWA5QdD8TyGYrrsxH/jQ0rK51W', 0, '{\"spriteScale\":100,\"spriteSpeed\":100,\"ignoresBlockLayer\":false,\"invisible\":false,\"floating\":false}', 'hakim.ouardi15@gmail.com', 1507980687, 0, '%14%1%2%3%4%5%6%7%8%9%10%11%12%13%15%3144%342%1105%4145%4738%4723%3135%2088%5122%789%9044%1444%2072%609%339%7130%1330%1506%366%5186%2096', '', 388, 417, '1', '', '', '', 14, 1105, 2088, 3135, '4738', 5186, 366, 9044, 7130, 0, '0', '7212,216,206,214,208,', '1%1%1%1', '0,0,0', '397|Angelina%399|Derps%400|test%395|Jack%401|Emotional', '', 116, 0, 1, '105.1', '', 0, 0, '0,1,|0;0;1403959119;', 1, '0,0,0,0,0', '0,0,0,0,0,0,0,0', '0', '', '', '', '', '', '', '', '', '', '', '', 0, 0, '', 0, 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
182(397, 'Angelina', 'Angelina', '$2y$12$i06tBg9tnRi0AWOTRDs4cOlagN8QXmDtJXMcevGhsCBKI/EPKRtDm', 0, '{\"spriteScale\":100,\"spriteSpeed\":100,\"ignoresBlockLayer\":false,\"invisible\":false,\"floating\":false}', 'cppsangelina@gmail.com', 1507981043, 1, '%14%1%2%3%4%5%6%7%8%9%10%11%12%13%15%412%221%244%101918171693823%%609%7130%111%112%113%114%110%107%108%103%101%104%106%102%109%105%401%405%403%201%202%203%204%205%206%174%175%13017%5114%353%322%410%265%217%218%7229%%481%120', '', 2378, 418, '1', '', '', '643|1,116|1,115|1', 4, 410, 106, 13017, '265', 5114, 353, 0, 7229, 0, '0', '710,', '1%1%1%1', '0,0,0', '396|Mario10723%402|Greg%403|ReidTJ%401|Emotional%409|Zore%404|Might%410|Andriy%398|Reece%399|Derps%408|Cody%411|Allie%412|Carson%414|Antagonist%415|Andre%416|Waddle%422|Snipe%413|Toxic', '', 805, 0, 1, '86.13', '', 0, 0, '0,1,|0;0;1403959119;', 6, '0,0,0,0,0', '0,0,0,0,0,0,0,0', '0', '', '', '', '', '', '', '0x010101', '3', '0x010101', '0xEE82EE', '0xDA70D6', -1, 1, '', 0, 0, '', '0', 'r', '', '', 'Reece 14', 'r', '75', '', '50', '165', '45', '325', '175', '0xFF34B3', '', ''),
183(398, 'Reece', 'Reece', '$2y$12$IdTXFR.zERd2ZKTxvocBXOPKJkx8BWP3lUEGOcQASMCGlkzH.Qr6u', 0, '{\"spriteScale\":100,\"spriteSpeed\":100,\"ignoresBlockLayer\":false,\"invisible\":false,\"floating\":false}', 'cppsreece@gmail.com', 1507981057, 1, '%14%1%2%3%4%5%6%7%8%9%10%11%12%13%15%102%403%401%4468%5021%321%4760%1511%7016%1444%1448%609%412%5046%5047%3140%4751%1502%4749%175%174%13017%5114%', '', 938, 419, '1', '', '', '', 14, 1448, 102, 174, '4468', 5114, 0, 0, 0, 0, '0', '710,9,', '1%1%1%1', '0,0,0', '397|Angelina%399|Derps%408|Cody%411|Allie%414|Antagonist%422|Snipe', '', 279, 0, 1, '92.26', '', 0, 0, '0,1,|0;0;1403959119;', 3, '0,0,0,0,0', '0,0,0,0,0,0,0,0', '0', '', '', '', '', '', '', '0xFF69B4', '4', '0xFF69B4', '0x010101', '0x800080', 10, 1, '', 100, 100, '60', '0', '', 'r', '', '', 'r', '335', '', '320', '155', '50', '', '185', '0x800080', '', '4'),
184(399, 'Derps', 'Derps', '$2y$12$RzRrljXC3.ROc/YDmiZmMu1aHEBIod9HU/iJDRQGx2t4BS7QmaRlm', 0, '{\"spriteScale\":100,\"spriteSpeed\":100,\"ignoresBlockLayer\":false,\"invisible\":false,\"floating\":false}', 'catzplaysyt@gmail.com', 1507984368, 0, '%14%1%2%3%4%5%6%7%8%9%10%11%12%13%15%9008%9081%923%9037%1041%256%353%1105%4145%342%5083%1060%6054%789%403', '', 1604, 420, '1', '', '', '', 12, 0, 0, 0, '0', 0, 0, 0, 0, 0, '0', '7216,206,222,208,212,214,218,228,220,224,226,210,', '4%10%2%2', '0,0,0', '396|Mario10723%395|Jack%401|Emotional%394|mazzy%397|Angelina%398|Reece%408|Cody%411|Allie', '', 104, 0, 1, '71.56', '', 0, 0, '0,1,|0;0;1403959119;', 1, '0,0,0,0,0', '0,0,0,0,0,0,0,0', '0', '', '', '', '', '', '', '', '', '', '', '', 0, 0, '', 0, 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
185(401, 'Emotional', 'Emotional', '$2y$12$YU2Wr7Em1Ybf3vMpxY2cTOHC3Nn7QTKE6Zb457DlYHasCE8jQ6dUG', 0, '{\"spriteScale\":100,\"spriteSpeed\":100,\"ignoresBlockLayer\":false,\"invisible\":false,\"floating\":false}', 'itzetchasketch@gmail.com', 1507988038, 1, '%14%1%2%3%4%5%6%7%8%9%10%11%12%13%15%221%102%512%301%106%103%401%404%201%403%405%131%220%408%212%481%244%412%252%219%214%101%503%501%9120', '', 890, 422, '1', '', '', '', 9, 401, 103, 301, '212', 0, 0, 0, 0, 0, '0', '7', '1%1%1%1', '0,0,0', '399|Derps%396|Mario10723%394|mazzy%397|Angelina%409|Zore', '', 51, 0, 1, '107.1', '', 0, 0, '0,1,|0;0;1403959119;', 1, '0,0,0,0,0', '0,0,0,0,0,0,0,0', '0', '', '', '', '', '', '', '', '', '', '', '', 0, 0, '', 0, 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
186(402, 'Greg', 'Greg', '$2y$12$bGHp4LVV65S5lXixbsSRHelEO8weTQcNC7h6j1YRMgTFwXJqZPwdi', 0, '{\"spriteScale\":100,\"spriteSpeed\":100,\"ignoresBlockLayer\":false,\"invisible\":false,\"floating\":false}', 'astonautu@gmail.com', 1507993140, 0, '%14%1%2%3%4%5%6%7%8%9%10%11%12%13%15%408%405%201%219%103%481%212%131%220%4468%2043%4467%4466%489%5031%9120%5131%1106%119%3038%4146', '', 0, 423, '1', '', '', '', 14, 0, 0, 0, '4468', 0, 0, 9120, 0, 0, '0', '7', '1%1%1%1', '0,0,0', '397|Angelina', '', 21, 0, 1, '185.1', '', 0, 0, '0,1,|0;0;1403959119;', 1, '0,0,0,0,0', '0,0,0,0,0,0,0,0', '0', '', '', '', '', '', '', '', '', '', '', '', 0, 0, '', 0, 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
187(403, 'ReidTJ', 'ReidTJ', '$2y$12$42ZWUe2r9z4ruitddYPiQuEuIYFdxN103eIqO/pMJmAVs5tkPrB7u', 0, '{\"spriteScale\":100,\"spriteSpeed\":100,\"ignoresBlockLayer\":false,\"invisible\":false,\"floating\":false}', 'reidtj@zoho.com', 1507993313, 0, '%14%1%2%3%4%5%6%7%8%9%10%11%12%13%15%103%221%401%201%481%301%101%214%403', '', 3650, 424, '1', '', '', '', 14, 403, 101, 214, '221', 0, 0, 0, 0, 0, '0', '7', '1%1%1%1', '0,0,0', '397|Angelina', '', 23, 0, 1, '45.26', '', 0, 0, '0,1,|0;0;1403959119;', 1, '0,0,0,0,0', '0,0,0,0,0,0,0,0', '0', '', '', '', '', '', '', '', '', '', '', '', 0, 0, '', 0, 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
188(404, 'Might', 'Might', '$2y$12$KTqSKGrRFf69GmTGz/CzIuGtap0uTGgZMRU.tA0JfKGTL9ed9DlDy', 0, '{\"spriteScale\":100,\"spriteSpeed\":100,\"ignoresBlockLayer\":false,\"invisible\":false,\"floating\":false}', 'salih_tu@hotmail.com', 1507993461, 0, '%14%1%2%3%4%5%6%7%8%9%10%11%12%13%15%405%103%301%221%101%102%219%214%106%244%220%131%212%481%201%404%401%403%339%609%5046%5021%701%278%3002%5031', '', 215, 425, '1', '', '', '', 4, 405, 103, 3002, '221', 339, 0, 0, 0, 0, '0', '7', '1%1%1%1', '0,0,0', '397|Angelina%409|Zore', '', 43, 0, 1, '213.3', '', 0, 0, '0,1,|0;0;1403959119;', 1, '0,0,0,0,0', '0,0,0,0,0,0,0,0', '0', '', '', '', '', '', '', '', '', '', '', '', 0, 0, '', 0, 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
189(405, 'Camden', 'Camden', '$2y$12$LoWsn.04t77Kx.RdnGWgv.ofJQW.r/onrrtBzHJvquP..aZWQ7i/i', 0, '{\"spriteScale\":100,\"spriteSpeed\":100,\"ignoresBlockLayer\":false,\"invisible\":false,\"floating\":false}', 'nope@nothappening.com', 1507994125, 1, '%14%1%2%3%4%5%6%7%8%9%10%11%12%13%15', '', 5000, 426, '1', '', '', '', 3, 0, 0, 0, '0', 0, 0, 0, 0, 0, '0', '7', '1%1%1%1', '0,0,0', '', '', 0, 0, 1, '108.1', '', 0, 0, '0,1,|0;0;1403959119;', 5, '0,0,0,0,0', '0,0,0,0,0,0,0,0', '0', '', '', '', '', '', '', '', '', '', '', '', 0, 0, '', 0, 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
190(406, 'Jonas', 'Jonas', '$2y$12$RMj9ooMAvE06EL7gDYzbX.cpQXlEEkojnWnzVIu/vMK.rcPcUp/ym', 0, '{\"spriteScale\":100,\"spriteSpeed\":100,\"ignoresBlockLayer\":false,\"invisible\":false,\"floating\":false}', 'cptoivo132@gmail.com', 1507994152, 0, '%14%1%2%3%4%5%6%7%8%9%10%11%12%13%15', '', 5000, 427, '1', '', '', '', 1, 0, 0, 0, '0', 0, 0, 0, 0, 0, '0', '7', '1%1%1%1', '0,0,0', '', '', 2, 0, 1, '45.33', '', 0, 0, '0,1,|0;0;1403959119;', 1, '0,0,0,0,0', '0,0,0,0,0,0,0,0', '0', '', '', '', '', '', '', '', '', '', '', '', 0, 0, '', 0, 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
191(407, 'TheLBall', 'TheLBall', '$2y$12$GoZ4b8y7hP9Dd5gq98xxl.9Ps7ws10G2IjOmH4XGCUJTIkZiS.pBa', 0, '{\"spriteScale\":100,\"spriteSpeed\":100,\"ignoresBlockLayer\":false,\"invisible\":false,\"floating\":false}', 'outofmario1000@gmail.com', 1507994197, 0, '%14%1%2%3%4%5%6%7%8%9%10%11%12%13%15%609', '', 5150, 428, '1', '', '', '', 12, 0, 0, 0, '0', 0, 0, 0, 0, 0, '0', '7214,102,93,', '1%1%1%1', '0,0,0', '', '', 10, 0, 1, '74.13', '', 0, 0, '0,1,|0;0;1403959119;', 1, '0,0,0,0,0', '0,0,0,0,0,0,0,0', '0', '', '', '', '', '', '', '', '', '', '', '', 0, 0, '', 0, 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
192(408, 'Cody', 'Cody', '$2y$12$RZvbcuzie5aZpm2GzlWST.mX9dVDsa0ODErG7Iej7T8R.IAjX6Beq', 0, '{\"spriteScale\":100,\"spriteSpeed\":100,\"ignoresBlockLayer\":false,\"invisible\":false,\"floating\":false}', 'cody.mindfreak.ryan0@gmail.com', 1507997090, 0, '%14%1%2%3%4%5%6%7%8%9%10%11%12%13%15%4760%1511%4759%1510%6013%103%221%404%7130', '', 2400, 429, '1', '', '', '', 4, 404, 103, 0, '221', 0, 6013, 0, 0, 0, '0', '79,10,', '1%1%1%1', '0,0,0', '397|Angelina%398|Reece%399|Derps%411|Allie', '', 72, 0, 1, '115.1', '', 0, 0, '0,1,|0;0;1403959119;', 1, '0,0,0,0,0', '0,0,0,0,0,0,0,0', '0', '', '', '', '', '', '', '', '', '', '', '', 0, 0, '', 0, 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
193(409, 'Zore', 'Zore', '$2y$12$AH5joNW3T69Q9Xfttk49lugJb8UcwqeWTzcPLxRd120hvjyL6Tbey', 0, '{\"spriteScale\":100,\"spriteSpeed\":100,\"ignoresBlockLayer\":false,\"invisible\":false,\"floating\":false}', 'test@me.com', 1508000625, 0, '%14%1%2%3%4%5%6%7%8%9%10%11%12%13%15%103%221%131%244%403', '', 3610, 430, '1', '', '', '', 4, 0, 103, 0, '221', 0, 0, 0, 0, 0, '0', '7', '1%1%1%1', '0,0,0', '397|Angelina%401|Emotional%404|Might', '', 55, 0, 1, '174.1', '', 0, 0, '0,1,|0;0;1403959119;', 1, '0,0,0,0,0', '0,0,0,0,0,0,0,0', '0', '', '', '', '', '', '', '', '', '', '', '', 0, 0, '', 0, 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
194(410, 'Andriy', 'Andriy', '$2y$12$/zhiuOTkclNpvF0klINYCOY8yBGVNqmAfwHDtAQx4cfKlCCeQXRxe', 0, '{\"spriteScale\":100,\"spriteSpeed\":100,\"ignoresBlockLayer\":false,\"invisible\":false,\"floating\":false}', 'andriykobondar@gmail.com', 1508015936, 1, '%14%1%2%3%4%5%6%7%8%9%10%11%12%13%15%403%201%404%452%405%401%103%220%131%408%212%481%244%412%252%301%106%219%221%101%214%5021%1444%609', '', 627, 431, '1', '', '', '', 7, 452, 101, 301, '244', 5021, 0, 0, 0, 0, '0', '7214,206,208,68,', '1%1%1%1', '0,0,0', '397|Angelina', '', 54, 0, 1, '75.87', '', 0, 0, '0,1,|0;0;1403959119;', 4, '0,0,0,0,0', '0,0,0,0,0,0,0,0', '0', '', '', '', '', '', '', '', '', '', '', '', 0, 0, '', 0, 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
195(412, 'Carson', 'Carson', '$2y$12$nqoetUAjXc8iJPmgcmpkROgRvmx/4fikzoPyKJipu521KQa9cUNrK', 0, '{\"spriteScale\":100,\"spriteSpeed\":100,\"ignoresBlockLayer\":false,\"invisible\":false,\"floating\":false}', 'carsonb714@mailinator.com', 1508031730, 0, '%14%1%2%3%4%5%6%7%8%9%10%11%12%13%15%102%221', '', 4690, 433, '1', '', '', '', 14, 0, 102, 0, '221', 0, 0, 0, 0, 0, '0', '7', '1%1%1%1', '0,0,0', '397|Angelina', '', 10, 0, 1, '99.13', '', 0, 0, '0,1,|0;0;1403959119;', 1, '0,0,0,0,0', '0,0,0,0,0,0,0,0', '0', '', '', '', '', '', '', '', '', '', '', '', 0, 0, '', 0, 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
196(413, 'Toxic', 'Toxic', '$2y$12$.Y7rHwbV5XGYCddfViyTieU1Ud1dk2CvC7mlTGrUo0BPrQc2/elUC', 0, '{\"spriteScale\":100,\"spriteSpeed\":100,\"ignoresBlockLayer\":false,\"invisible\":false,\"floating\":false}', 'baidjdjaj@gmail.com', 1508055171, 0, '%14%1%2%3%4%5%6%7%8%9%10%11%12%13%15', '', 5000, 434, '1', '', '', '', 5, 0, 0, 0, '0', 0, 0, 0, 0, 0, '0', '7', '1%1%1%1', '0,0,0', '422|Snipe', '', 42, 0, 1, '71.72', '', 0, 0, '0,1,|0;0;1403959119;', 1, '0,0,0,0,0', '0,0,0,0,0,0,0,0', '0', '', '', '', '', '', '', '', '', '', '', '', 0, 0, '', 0, 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
197(414, 'Antagonist', 'Antagonist', '$2y$12$CTLCtBhNC2QBjRrNqwbozuVzUPsSuu/N.msN8MqEPz3bKRv3BAzLu', 0, '{\"spriteScale\":100,\"spriteSpeed\":100,\"ignoresBlockLayer\":false,\"invisible\":false,\"floating\":false}', 'dylanwyatt003@gmail.com', 1508091516, 0, '%14%1%2%3%4%5%6%7%8%9%10%11%12%13%15%103%301%405%9120%7130%5074%1444%2072%609%5039%403%408%481%220%106%221%219%214%131%404%711%101%1106%3038%5114%%7016%4749%412%244%102%212%119', '', 0, 435, '1,38', '', '', '810|1,907|1,909|1,43|1,117|1,880|1,415|1,418|1,640|1,155|2,150|1,452|2,14|2,596|5', 1, 404, 106, 301, '212', 220, 0, 0, 7130, 0, '0', '79,10,75,77,82,81,88,84,86,63,64,68,66,65,67,51,', '1%1%1%1', '0,0,0', '397|Angelina%398|Reece', '', 366, 0, 1, '73.23', '', 0, 0, '0,1,|0;0;1403959119;', 1, '0,0,0,0,0', '0,0,0,0,0,0,0,0', '0', '', '', '', '', '', '', '', '', '', '', '', 0, 0, '', 0, 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
198(415, 'Andre', 'Andre', '$2y$12$04dzS6shVdsj0RkLNR1BhOQCZSUr.xYdR2QGTtzMTbMy2nSVx7Xve', 0, '{\"spriteScale\":100,\"spriteSpeed\":100,\"ignoresBlockLayer\":false,\"invisible\":false,\"floating\":false}', '132revenge132@gmail.com', 1508100292, 0, '%14%1%2%3%4%5%6%7%8%9%10%11%12%13%15%103%221%106%301', '', 4350, 436, '1', '', '', '', 14, 0, 106, 0, '221', 0, 0, 0, 0, 0, '0', '7', '1%1%1%1', '0,0,0', '397|Angelina', '', 108, 0, 1, '124.1', '', 0, 0, '0,1,|0;0;1403959119;', 1, '0,0,0,0,0', '0,0,0,0,0,0,0,0', '0', '', '', '', '', '', '', '', '', '0xFFFFFF', '0x0000FF', '', 10, 1, '', 0, 0, '', '', '0x010101', '', '', 'Child Su', '0x0000FF', '', '0', '', '', '25', '', '85', '0xFFFFFF', '', ''),
199(416, 'Waddle', 'Waddle', '$2y$12$gu83cJ34Te7YYqxGb50QI.VrjS1KuU/M4icNyugUZmgteuU6K8ove', 0, '{\"spriteScale\":100,\"spriteSpeed\":100,\"ignoresBlockLayer\":false,\"invisible\":false,\"floating\":false}', 'vicklaborie@gmail.com', 1508257806, 0, '%14%1%2%3%4%5%6%7%8%9%10%11%12%13%15%403%201%401%404%405%103%301%106%214%4760%220%6013%244%101%219%221%9120%489%2043%4467%5131%119%7130', '', 50, 437, '1', '', '', '', 5, 0, 0, 0, '201', 220, 0, 9120, 7130, 0, '0', '7', '1%1%1%1', '0,0,0', '397|Angelina', '', 11, 0, 1, '78.11', '', 0, 0, '0,1,|0;0;1403959119;', 1, '0,0,0,0,0', '0,0,0,0,0,0,0,0', '0', '', '', '', '', '', '', '', '', '', '', '', 0, 0, '', 0, 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
200(417, 'Zerm', 'Zerm', '$2y$12$eZ1Z33wqRm77HT.JVWdlPur3X8JmXGLzJ89FGP48UHJ18CPTg6cKW', 0, '{\"spriteScale\":100,\"spriteSpeed\":100,\"ignoresBlockLayer\":false,\"invisible\":false,\"floating\":false}', 'otherbergteam@gmail.com', 1508283044, 0, '%14%1%2%3%4%5%6%7%8%9%10%11%12%13%15%405%404%103%131%221%101%214%102%244%106%401%212', '', 3140, 438, '1', '', '', '', 4, 404, 131, 214, '221', 0, 0, 0, 0, 0, '0', '7', '1%1%1%1', '0,0,0', '', '', 33, 0, 1, '68.10', '', 0, 0, '0,1,|0;0;1403959119;', 1, '0,0,0,0,0', '0,0,0,0,0,0,0,0', '0', '', '', '', '', '', '', '', '', '', '', '', 0, 0, '', 0, 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
201(418, 'Walter', 'Walter', '$2y$12$ApJSvPMZ5JClobiEHnFxe.7LqkwNw2ptgWp8gO/B5utGtdJfjb.oG', 0, '{\"spriteScale\":100,\"spriteSpeed\":100,\"ignoresBlockLayer\":false,\"invisible\":false,\"floating\":false}', 'fakeemailol@fake.com', 1508289322, 5, '%14%1%2%3%4%5%6%7%8%9%10%11%12%13%15%101918171693823\r\n%101%402%292%221', '', 4500, 439, '1', '', '', '', 14, 0, 101, 0, '221', 0, 0, 0, 16777215, 0, '0', '7', '1%1%1%1', '0,0,0', '', '', 126, 0, 1, '173.2', '', 0, 0, '0,1,|0;0;1403959119;', 5, '0,0,0,0,0', '0,0,0,0,0,0,0,0', '0', '', '', '', '', '', '', '', '', '0x010101', '0xFFFFFF', '', 0, 1, '', 0, 0, '', '', '', '0x010101', '', '', '', '', '25', '', '', '25', '', '25', '', '', ''),
202(419, 'Vallorz', 'Vallorz', '$2y$12$LzEAKYHDtuBKsnQ5ddn7juWUHuBYKI/rCK/r/O3Hug5nGyNwmVI66', 0, '{\"spriteScale\":100,\"spriteSpeed\":100,\"ignoresBlockLayer\":false,\"invisible\":false,\"floating\":false}', 'benlewis388@gmail.com', 1508488587, 0, '%14%1%2%3%4%5%6%7%8%9%10%11%12%13%15', '', 5000, 440, '1', '', '', '', 4, 0, 0, 0, '0', 0, 0, 0, 0, 0, '0', '7', '1%1%1%1', '0,0,0', '', '', 11, 0, 1, '5.151', '', 0, 0, '0,1,|0;0;1403959119;', 1, '0,0,0,0,0', '0,0,0,0,0,0,0,0', '0', '', '', '', '', '', '', '', '', '', '', '', 0, 0, '', 0, 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
203(420, 'Nadia2', 'Nadia2', '$2y$12$TM.lkq/ygkTSsRmvJdiUS.GTHcIgG06OLG4FKdEjdjLsKmoae2qhq', 0, '{\"spriteScale\":100,\"spriteSpeed\":100,\"ignoresBlockLayer\":false,\"invisible\":false,\"floating\":false}', 'officialcake@gmail.com', 1508497266, 0, '%14%1%2%3%4%5%6%7%8%9%10%11%12%13%15', '', 5000, 441, '1', '', '', '', 12, 0, 0, 0, '0', 0, 0, 0, 0, 0, '0', '7', '1%1%1%1', '0,0,0', '', '', 0, 0, 1, '108.1', '', 0, 0, '0,1,|0;0;1403959119;', 1, '0,0,0,0,0', '0,0,0,0,0,0,0,0', '0', '', '', '', '', '', '', '', '', '', '', '', 0, 0, '', 0, 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
204(421, 'Vasy', 'Vasy', '$2y$12$34N1g8hYdJT.yL0hFBkEteC4desyvydETXnugHASwW8W6g.SCL90y', 0, '{\"spriteScale\":100,\"spriteSpeed\":100,\"ignoresBlockLayer\":false,\"invisible\":false,\"floating\":false}', 'vasympd12@yahoo.com', 1508534573, 0, '%14%1%2%3%4%5%6%7%8%9%10%11%12%13%15%201%405%403%404%481%103%131%220%212%301%106%244%221%219%101%214', '', 1970, 442, '1', '', '', '', 13, 405, 106, 0, '221', 0, 0, 0, 0, 0, '0', '7', '1%1%1%1', '0,0,0', '', '', 3, 0, 1, '188.2', '', 0, 0, '0,1,|0;0;1403959119;', 1, '0,0,0,0,0', '0,0,0,0,0,0,0,0', '0', '', '', '', '', '', '', '', '', '', '', '', 0, 0, '', 0, 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
205(422, 'Snipe', 'Snipe', '$2y$12$3Vdxr/RYXj2HsG0YaE5RKeY6.UwIg7ImhwH3eV0TPHcY3ajIWBqa.', 0, '{\"spriteScale\":100,\"spriteSpeed\":100,\"ignoresBlockLayer\":false,\"invisible\":false,\"floating\":false}', 'snipe@gmail.com', 1508627828, 0, '%14%1%2%3%4%5%6%7%8%9%10%11%12%13%15%107%221%334%106%1007%4045%3035%435%436', '', 3438, 443, '1', '', '', '224|1', 9, 436, 106, 3035, '221', 0, 0, 0, 0, 0, '0', '710,51,212,216,214,', '1%1%1%1', '0,0,0', '397|Angelina%413|Toxic%398|Reece', '', 178, 0, 1, '82.8.', '', 0, 0, '0,1,|0;0;1403959119;', 1, '0,0,0,0,0', '0,0,0,0,0,0,0,0', '0', '', '', '', '', '', '', '0x0000FF', '', '0xFF0000', '', '', 10, 0, '', 0, 0, '', '', 'r', '', '', 'Hello', '', '0', '0', '0', '', '0', '', '10', '', '', ''),
206(423, 'SnipeTest', 'SnipeTest', '$2y$12$XcwUgYP6j3.T5PrbeE.u7u94T2HSMItV.5wMq3LId2opKpBvgOFA.', 0, '{\"spriteScale\":100,\"spriteSpeed\":100,\"ignoresBlockLayer\":false,\"invisible\":false,\"floating\":false}', 'snipe@test.com', 1508628527, 0, '%14%1%2%3%4%5%6%7%8%9%10%11%12%13%15', '', 5010, 444, '1', '', '', '', 1, 0, 0, 0, '0', 0, 0, 0, 0, 0, '0', '7', '1%1%1%1', '0,0,0', '', '', 2, 0, 1, '82.8.', '', 0, 0, '0,1,|0;0;1403959119;', 1, '0,0,0,0,0', '0,0,0,0,0,0,0,0', '0', '', '', '', '', '', '', '', '', '', '', '', 0, 0, '', 0, 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
207(424, 'Lukey', 'Lukey', '$2y$12$6/RJ2/HbIIeexFziEebC1e6e6Pf0rJzjDgI3rfRXWpcr1Vu8PP/k6', 0, '{\"spriteScale\":100,\"spriteSpeed\":100,\"ignoresBlockLayer\":false,\"invisible\":false,\"floating\":false}', 'evansgloriaj@gmail.com', 1508710444, 0, '%14%1%2%3%4%5%6%7%8%9%10%11%12%13%15', '', 5000, 445, '1', '', '', '', 1, 0, 0, 0, '0', 0, 0, 0, 0, 0, '0', '7', '1%1%1%1', '0,0,0', '', '', 0, 0, 1, '108.1', '', 0, 0, '0,1,|0;0;1403959119;', 1, '0,0,0,0,0', '0,0,0,0,0,0,0,0', '0', '', '', '', '', '', '', '', '', '', '', '', 0, 0, '', 0, 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '');
208
209DROP TABLE IF EXISTS `postcards`;
210CREATE TABLE `postcards` (
211 `ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
212 `Recipient` int(10) unsigned NOT NULL,
213 `SenderName` char(12) NOT NULL,
214 `SenderID` int(10) unsigned NOT NULL,
215 `Details` varchar(12) NOT NULL,
216 `Date` int(8) NOT NULL,
217 `Type` smallint(5) unsigned NOT NULL,
218 `HasRead` tinyint(1) NOT NULL DEFAULT '0',
219 PRIMARY KEY (`ID`)
220) ENGINE=InnoDB DEFAULT CHARSET=latin1;
221
222INSERT INTO `postcards` (`ID`, `Recipient`, `SenderName`, `SenderID`, `Details`, `Date`, `Type`, `HasRead`) VALUES
223(87, 399, 'test', 400, '', 1507985967, 9, 1),
224(88, 399, 'test', 400, '', 1507985998, 18, 1),
225(89, 399, 'test', 400, '', 1507985999, 18, 1),
226(90, 399, 'test', 400, '', 1507986000, 18, 1),
227(91, 399, 'test', 400, '', 1507986001, 18, 1),
228(92, 399, 'test', 400, '', 1507986004, 18, 1),
229(93, 399, 'test', 400, '', 1507986004, 18, 1),
230(94, 399, 'test', 400, '', 1507986005, 18, 1),
231(95, 399, 'test', 400, '', 1507986005, 18, 1),
232(96, 399, 'test', 400, '', 1507986005, 18, 1),
233(97, 399, 'test', 400, '', 1507986005, 18, 1),
234(98, 399, 'test', 400, '', 1507986005, 18, 1),
235(99, 399, 'test', 400, '', 1507986005, 18, 1),
236(100, 399, 'test', 400, '', 1507986005, 18, 1),
237(101, 399, 'test', 400, '', 1507986005, 18, 1),
238(102, 399, 'test', 400, '', 1507986005, 18, 1),
239(103, 399, 'test', 400, '', 1507986006, 18, 1),
240(104, 399, 'test', 400, '', 1507986006, 18, 1),
241(105, 399, 'test', 400, '', 1507986006, 18, 1),
242(106, 399, 'test', 400, '', 1507986006, 18, 1),
243(107, 399, 'test', 400, '', 1507986006, 18, 1),
244(108, 395, 'test', 400, '', 1507986383, 9, 1),
245(109, 395, 'test', 400, '', 1507986400, 18, 1),
246(110, 395, 'test', 400, '', 1507986400, 18, 1),
247(111, 395, 'test', 400, '', 1507986400, 18, 1),
248(112, 395, 'test', 400, '', 1507986400, 18, 1),
249(113, 395, 'test', 400, '', 1507986400, 18, 1),
250(114, 395, 'test', 400, '', 1507986401, 18, 1),
251(115, 395, 'test', 400, '', 1507986401, 18, 1),
252(116, 395, 'test', 400, '', 1507986401, 18, 1),
253(117, 395, 'test', 400, '', 1507986401, 18, 1),
254(118, 395, 'test', 400, '', 1507986401, 18, 1),
255(119, 395, 'test', 400, '', 1507986401, 18, 1),
256(120, 395, 'test', 400, '', 1507986401, 18, 1),
257(121, 395, 'test', 400, '', 1507986401, 18, 1),
258(122, 395, 'test', 400, '', 1507986401, 18, 1),
259(123, 395, 'test', 400, '', 1507986402, 18, 1),
260(124, 395, 'test', 400, '', 1507986402, 18, 1),
261(125, 395, 'test', 400, '', 1507986402, 18, 1),
262(126, 396, 'test', 400, '', 1507986903, 9, 1),
263(127, 396, 'test', 400, '', 1507986918, 18, 1),
264(128, 396, 'test', 400, '', 1507986918, 18, 1),
265(129, 396, 'test', 400, '', 1507986918, 18, 1),
266(130, 396, 'test', 400, '', 1507986918, 18, 1),
267(131, 396, 'test', 400, '', 1507986918, 18, 1),
268(132, 396, 'test', 400, '', 1507986919, 18, 1),
269(133, 396, 'test', 400, '', 1507986919, 18, 1),
270(134, 396, 'test', 400, '', 1507986919, 18, 1),
271(135, 396, 'test', 400, '', 1507986919, 18, 1),
272(136, 396, 'test', 400, '', 1507986919, 18, 1),
273(137, 396, 'test', 400, '', 1507986919, 18, 1),
274(138, 396, 'test', 400, '', 1507986919, 18, 1),
275(139, 396, 'test', 400, '', 1507986919, 18, 1),
276(140, 396, 'test', 400, '', 1507986919, 18, 1),
277(141, 396, 'test', 400, '', 1507986920, 18, 1),
278(142, 396, 'test', 400, '', 1507986920, 18, 1),
279(143, 396, 'test', 400, '', 1507986920, 18, 1),
280(144, 400, 'Mario10723', 396, '', 1507987231, 9, 1),
281(145, 400, 'Mario10723', 396, '', 1507987236, 9, 1),
282(146, 400, 'Mario10723', 396, '', 1507987240, 9, 0),
283(147, 400, 'Mario10723', 396, '', 1507987244, 9, 0),
284(148, 409, 'sys', 0, 'test', 1508001645, 111, 1),
285(149, 398, 'sys', 0, 'Amy', 1508016754, 111, 1),
286(151, 398, 'Angelina', 397, '', 1508032558, 206, 1),
287(154, 422, 'Angelina', 397, '', 1508800851, 5, 1);
288
289DROP TABLE IF EXISTS `puffles`;
290CREATE TABLE `puffles` (
291 `ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
292 `Owner` int(10) unsigned NOT NULL,
293 `Name` char(12) NOT NULL,
294 `AdoptionDate` int(8) NOT NULL,
295 `Type` tinyint(3) unsigned NOT NULL,
296 `Subtype` smallint(5) unsigned NOT NULL DEFAULT '0',
297 `Hat` smallint(5) unsigned NOT NULL DEFAULT '0',
298 `Food` tinyint(3) unsigned NOT NULL DEFAULT '100',
299 `Play` tinyint(3) unsigned NOT NULL DEFAULT '100',
300 `Rest` tinyint(3) unsigned NOT NULL DEFAULT '100',
301 `Clean` tinyint(3) unsigned NOT NULL DEFAULT '100',
302 `Backyard` tinyint(1) NOT NULL DEFAULT '0',
303 `Walking` int(11) NOT NULL,
304 PRIMARY KEY (`ID`)
305) ENGINE=InnoDB DEFAULT CHARSET=latin1;
306
307INSERT INTO `puffles` (`ID`, `Owner`, `Name`, `AdoptionDate`, `Type`, `Subtype`, `Hat`, `Food`, `Play`, `Rest`, `Clean`, `Backyard`, `Walking`) VALUES
308(36, 409, 'test', 1508001645, 6, 0, 0, 100, 100, 100, 100, 0, 0),
309(37, 398, 'Amy', 1508016754, 4, 0, 0, 100, 100, 100, 100, 0, 0);
310
311DROP TABLE IF EXISTS `redemption`;
312CREATE TABLE `redemption` (
313 `ID` int(10) unsigned NOT NULL,
314 `Type` varchar(255) NOT NULL DEFAULT 'BLANKET',
315 `Code` char(16) NOT NULL,
316 `Items` text NOT NULL,
317 `Coins` int(11) NOT NULL DEFAULT '0',
318 `Expires` int(11) NOT NULL DEFAULT '0',
319 `Uses` int(11) NOT NULL DEFAULT '-1',
320 PRIMARY KEY (`ID`)
321) ENGINE=InnoDB DEFAULT CHARSET=latin1;
322
323
324DROP TABLE IF EXISTS `servers`;
325CREATE TABLE `servers` (
326 `ID` int(5) NOT NULL,
327 `Name` varchar(255) NOT NULL,
328 `address` varchar(255) NOT NULL,
329 `port` int(10) NOT NULL,
330 `capacity` int(11) NOT NULL,
331 `Language` varchar(255) NOT NULL
332) ENGINE=InnoDB DEFAULT CHARSET=latin1;
333
334INSERT INTO `servers` (`ID`, `Name`, `address`, `port`, `capacity`, `Language`) VALUES
335(102, 'Avalanche', '', 0, 0, 'pt'),
336(100, 'Blizzard', '', 0, 0, 'en'),
337(101, 'Glaciar', '', 0, 0, 'es'),
338(103, 'Yeti', '', 0, 0, 'fr');
339
340DROP TABLE IF EXISTS `tracks`;
341CREATE TABLE `tracks` (
342 `ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
343 `Name` varchar(12) COLLATE utf8mb4_unicode_ci NOT NULL,
344 `Owner` int(10) unsigned NOT NULL,
345 `Hash` char(32) COLLATE utf8mb4_unicode_ci NOT NULL,
346 `Sharing` tinyint(1) NOT NULL DEFAULT '0',
347 `Pattern` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
348 `Likes` smallint(5) unsigned NOT NULL DEFAULT '0',
349 `LikeStatistics` text COLLATE utf8mb4_unicode_ci NOT NULL,
350 PRIMARY KEY (`ID`)
351) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
352
353
354-- 2017-10-24 00:40:57