· 7 years ago · Feb 24, 2019, 02:54 AM
1-- phpMyAdmin SQL Dump
2-- version 4.0.5
3-- http://www.phpmyadmin.net
4--
5-- Host: localhost
6-- Generation Time: Oct 05, 2013 at 06:26 PM
7-- Server version: 5.1.70-cll
8-- PHP Version: 5.3.17
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13
14/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
15/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
16/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
17/*!40101 SET NAMES utf8 */;
18
19--
20-- Database: `avaworld_dbTOCLEAR`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Table structure for table `Ads`
27--
28
29CREATE TABLE IF NOT EXISTS `Ads` (
30 `ID` int(11) NOT NULL AUTO_INCREMENT,
31 `Image` longtext NOT NULL,
32 `Link` longtext NOT NULL,
33 `TimeRun` longtext NOT NULL,
34 `Active` int(11) NOT NULL DEFAULT '0',
35 PRIMARY KEY (`ID`)
36) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
37
38-- --------------------------------------------------------
39
40--
41-- Table structure for table `Badges`
42--
43
44CREATE TABLE IF NOT EXISTS `Badges` (
45 `UserID` int(11) NOT NULL,
46 `ID` int(11) NOT NULL AUTO_INCREMENT,
47 `Position` longtext NOT NULL,
48 PRIMARY KEY (`ID`)
49) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
50
51-- --------------------------------------------------------
52
53--
54-- Table structure for table `Banner`
55--
56
57CREATE TABLE IF NOT EXISTS `Banner` (
58 `Text` longtext NOT NULL
59) ENGINE=MyISAM DEFAULT CHARSET=latin1;
60
61--
62-- Dumping data for table `Banner`
63--
64
65INSERT INTO `Banner` (`Text`) VALUES
66('');
67
68-- --------------------------------------------------------
69
70--
71-- Table structure for table `BlogPosts`
72--
73
74CREATE TABLE IF NOT EXISTS `BlogPosts` (
75 `ID` int(11) NOT NULL AUTO_INCREMENT,
76 `Title` longtext NOT NULL,
77 `Body` longtext NOT NULL,
78 `Poster` longtext NOT NULL,
79 PRIMARY KEY (`ID`)
80) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
81
82-- --------------------------------------------------------
83
84--
85-- Table structure for table `Configuration`
86--
87
88CREATE TABLE IF NOT EXISTS `Configuration` (
89 `Register` longtext NOT NULL
90) ENGINE=MyISAM DEFAULT CHARSET=latin1;
91
92--
93-- Dumping data for table `Configuration`
94--
95
96INSERT INTO `Configuration` (`Register`) VALUES
97('true');
98
99-- --------------------------------------------------------
100
101--
102-- Table structure for table `down`
103--
104
105CREATE TABLE IF NOT EXISTS `down` (
106 `down` int(11) NOT NULL DEFAULT '0'
107) ENGINE=MyISAM DEFAULT CHARSET=latin1;
108
109-- --------------------------------------------------------
110
111--
112-- Table structure for table `forumtags`
113--
114
115CREATE TABLE IF NOT EXISTS `forumtags` (
116 `id` varchar(50) NOT NULL,
117 `text` varchar(50) NOT NULL,
118 `color` varchar(50) NOT NULL,
119 `userid` varchar(50) NOT NULL
120) ENGINE=MyISAM DEFAULT CHARSET=latin1;
121
122-- --------------------------------------------------------
123
124--
125-- Table structure for table `FRs`
126--
127
128CREATE TABLE IF NOT EXISTS `FRs` (
129 `ID` int(11) NOT NULL AUTO_INCREMENT,
130 `SenderID` int(11) NOT NULL,
131 `ReceiveID` int(11) NOT NULL,
132 `Active` int(11) NOT NULL DEFAULT '0',
133 PRIMARY KEY (`ID`)
134) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
135
136-- --------------------------------------------------------
137
138--
139-- Table structure for table `GroupAllies`
140--
141
142CREATE TABLE IF NOT EXISTS `GroupAllies` (
143 `ID` int(11) NOT NULL AUTO_INCREMENT,
144 `GroupID` int(11) NOT NULL,
145 `OtherGroupID` int(11) NOT NULL,
146 `Status` int(11) NOT NULL DEFAULT '0',
147 PRIMARY KEY (`ID`)
148) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=102 ;
149
150-- --------------------------------------------------------
151
152--
153-- Table structure for table `GroupEnemies`
154--
155
156CREATE TABLE IF NOT EXISTS `GroupEnemies` (
157 `ID` int(11) NOT NULL AUTO_INCREMENT,
158 `GroupID` int(11) NOT NULL,
159 `OtherGroupID` int(11) NOT NULL,
160 PRIMARY KEY (`ID`)
161) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=27 ;
162
163-- --------------------------------------------------------
164
165--
166-- Table structure for table `GroupMembers`
167--
168
169CREATE TABLE IF NOT EXISTS `GroupMembers` (
170 `ID` int(11) NOT NULL AUTO_INCREMENT,
171 `GroupID` int(11) NOT NULL,
172 `UserID` int(11) NOT NULL,
173 PRIMARY KEY (`ID`)
174) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
175
176-- --------------------------------------------------------
177
178--
179-- Table structure for table `Groups`
180--
181
182CREATE TABLE IF NOT EXISTS `Groups` (
183 `ID` int(11) NOT NULL AUTO_INCREMENT,
184 `Name` longtext NOT NULL,
185 `Description` longtext NOT NULL,
186 `OwnerID` int(11) NOT NULL,
187 `Logo` longtext NOT NULL,
188 `LogoActive` int(11) NOT NULL DEFAULT '0',
189 `GroupMembers` int(11) NOT NULL,
190 PRIMARY KEY (`ID`)
191) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
192
193-- --------------------------------------------------------
194
195--
196-- Table structure for table `GroupsLogo`
197--
198
199CREATE TABLE IF NOT EXISTS `GroupsLogo` (
200 `ID` int(11) NOT NULL AUTO_INCREMENT,
201 `GroupID` int(11) NOT NULL,
202 `Logo` longtext NOT NULL,
203 PRIMARY KEY (`ID`)
204) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=48 ;
205
206-- --------------------------------------------------------
207
208--
209-- Table structure for table `GroupsPending`
210--
211
212CREATE TABLE IF NOT EXISTS `GroupsPending` (
213 `ID` int(11) NOT NULL AUTO_INCREMENT,
214 `Name` longtext NOT NULL,
215 `Description` longtext NOT NULL,
216 `OwnerID` int(11) NOT NULL,
217 `Logo` longtext NOT NULL,
218 PRIMARY KEY (`ID`)
219) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=149 ;
220
221-- --------------------------------------------------------
222
223--
224-- Table structure for table `GroupWall`
225--
226
227CREATE TABLE IF NOT EXISTS `GroupWall` (
228 `ID` int(11) NOT NULL AUTO_INCREMENT,
229 `GroupID` int(11) NOT NULL,
230 `PosterID` int(11) NOT NULL,
231 `Message` longtext NOT NULL,
232 PRIMARY KEY (`ID`)
233) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
234
235-- --------------------------------------------------------
236
237--
238-- Table structure for table `Inventory`
239--
240
241CREATE TABLE IF NOT EXISTS `Inventory` (
242 `ID` int(11) NOT NULL AUTO_INCREMENT,
243 `UserID` int(11) NOT NULL,
244 `ItemID` int(11) NOT NULL,
245 `File` longtext NOT NULL,
246 `Type` longtext NOT NULL,
247 `code1` longtext NOT NULL,
248 `code2` longtext NOT NULL,
249 `SerialNum` int(11) NOT NULL,
250 PRIMARY KEY (`ID`)
251) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
252
253-- --------------------------------------------------------
254
255--
256-- Table structure for table `IPBans`
257--
258
259CREATE TABLE IF NOT EXISTS `IPBans` (
260 `IP` longtext NOT NULL
261) ENGINE=MyISAM DEFAULT CHARSET=latin1;
262
263--
264-- Dumping data for table `IPBans`
265--
266
267INSERT INTO `IPBans` (`IP`) VALUES
268('');
269
270-- --------------------------------------------------------
271
272--
273-- Table structure for table `ItemComments`
274--
275
276CREATE TABLE IF NOT EXISTS `ItemComments` (
277 `ID` int(11) NOT NULL AUTO_INCREMENT,
278 `UserID` int(11) NOT NULL,
279 `ItemID` int(11) NOT NULL,
280 `Post` longtext NOT NULL,
281 `time` longtext NOT NULL,
282 PRIMARY KEY (`ID`)
283) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
284
285-- --------------------------------------------------------
286
287--
288-- Table structure for table `ItemDrafts`
289--
290
291CREATE TABLE IF NOT EXISTS `ItemDrafts` (
292 `ID` int(11) NOT NULL AUTO_INCREMENT,
293 `Name` longtext NOT NULL,
294 `File` longtext NOT NULL,
295 `Type` longtext NOT NULL,
296 `Price` longtext NOT NULL,
297 `CreatorID` int(11) NOT NULL,
298 `saletype` varchar(1337) NOT NULL,
299 `numbersales` int(11) NOT NULL,
300 `numberstock` int(11) NOT NULL,
301 `sell` varchar(1337) NOT NULL DEFAULT 'yes',
302 `Description` longtext NOT NULL,
303 `CreationTime` longtext NOT NULL,
304 `store` varchar(1337) NOT NULL DEFAULT 'regular',
305 `timemake` longtext NOT NULL,
306 `itemDeleted` int(11) NOT NULL,
307 `SalePrices` int(11) NOT NULL,
308 `NumberSold` int(11) NOT NULL,
309 PRIMARY KEY (`ID`)
310) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1591 ;
311
312-- --------------------------------------------------------
313
314--
315-- Table structure for table `Items`
316--
317
318CREATE TABLE IF NOT EXISTS `Items` (
319 `ID` int(11) NOT NULL AUTO_INCREMENT,
320 `Name` longtext NOT NULL,
321 `File` longtext NOT NULL,
322 `Type` longtext NOT NULL,
323 `Price` longtext NOT NULL,
324 `saletype` varchar(1337) NOT NULL,
325 `numbersales` int(11) NOT NULL,
326 `numberstock` int(11) NOT NULL,
327 `sell` varchar(1337) NOT NULL DEFAULT 'yes',
328 `Description` longtext NOT NULL,
329 `CreationTime` longtext NOT NULL,
330 `store` varchar(1337) NOT NULL DEFAULT 'regular',
331 `timemake` longtext NOT NULL,
332 `itemDeleted` int(11) NOT NULL DEFAULT '0',
333 `SalePrices` int(11) NOT NULL DEFAULT '0',
334 `NumberSold` int(11) NOT NULL,
335 `CreatorID` int(11) NOT NULL DEFAULT '1',
336 PRIMARY KEY (`ID`)
337) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
338
339-- --------------------------------------------------------
340
341--
342-- Table structure for table `Logs`
343--
344
345CREATE TABLE IF NOT EXISTS `Logs` (
346 `ID` int(11) NOT NULL AUTO_INCREMENT,
347 `UserID` int(11) NOT NULL,
348 `Message` longtext NOT NULL,
349 `Page` longtext NOT NULL,
350 PRIMARY KEY (`ID`)
351) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
352
353-- --------------------------------------------------------
354
355--
356-- Table structure for table `Maintenance`
357--
358
359CREATE TABLE IF NOT EXISTS `Maintenance` (
360 `Status` longtext NOT NULL
361) ENGINE=MyISAM DEFAULT CHARSET=latin1;
362
363--
364-- Dumping data for table `Maintenance`
365--
366
367INSERT INTO `Maintenance` (`Status`) VALUES
368('false');
369
370-- --------------------------------------------------------
371
372--
373-- Table structure for table `News`
374--
375
376CREATE TABLE IF NOT EXISTS `News` (
377 `ID` int(11) NOT NULL AUTO_INCREMENT,
378 `Username` longtext NOT NULL,
379 `Title` longtext NOT NULL,
380 `body` longtext NOT NULL,
381 `PosterID` int(11) NOT NULL,
382 `Viewed` int(11) NOT NULL,
383 PRIMARY KEY (`ID`)
384) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
385
386-- --------------------------------------------------------
387
388--
389-- Table structure for table `objectlist`
390--
391
392CREATE TABLE IF NOT EXISTS `objectlist` (
393 `id` int(50) NOT NULL AUTO_INCREMENT,
394 `name` varchar(50) NOT NULL,
395 `image` varchar(50) NOT NULL,
396 `height` varchar(50) NOT NULL,
397 `width` varchar(50) NOT NULL,
398 PRIMARY KEY (`id`)
399) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
400
401--
402-- Dumping data for table `objectlist`
403--
404
405INSERT INTO `objectlist` (`id`, `name`, `image`, `height`, `width`) VALUES
406(1, 'Brick', 'brick.png', '30', '30'),
407(2, 'UA Flag', 'uaflag.png', '149', '108');
408
409-- --------------------------------------------------------
410
411--
412-- Table structure for table `PMs`
413--
414
415CREATE TABLE IF NOT EXISTS `PMs` (
416 `ID` int(11) NOT NULL AUTO_INCREMENT,
417 `SenderID` int(11) NOT NULL,
418 `ReceiveID` int(11) NOT NULL,
419 `Title` longtext NOT NULL,
420 `Body` longtext NOT NULL,
421 `time` int(11) NOT NULL,
422 `LookMessage` int(11) NOT NULL,
423 PRIMARY KEY (`ID`)
424) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
425
426-- --------------------------------------------------------
427
428--
429-- Table structure for table `PurchaseLog`
430--
431
432CREATE TABLE IF NOT EXISTS `PurchaseLog` (
433 `ID` int(11) NOT NULL AUTO_INCREMENT,
434 `UserID` int(11) NOT NULL,
435 `Item` longtext NOT NULL,
436 `TypeStore` longtext NOT NULL,
437 PRIMARY KEY (`ID`)
438) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
439
440-- --------------------------------------------------------
441
442--
443-- Table structure for table `Referrals`
444--
445
446CREATE TABLE IF NOT EXISTS `Referrals` (
447 `ReferredID` int(11) NOT NULL,
448 `UserID` int(11) NOT NULL
449) ENGINE=MyISAM DEFAULT CHARSET=latin1;
450
451-- --------------------------------------------------------
452
453--
454-- Table structure for table `Replies`
455--
456
457CREATE TABLE IF NOT EXISTS `Replies` (
458 `ID` int(11) NOT NULL AUTO_INCREMENT,
459 `Body` longtext NOT NULL,
460 `PosterID` int(11) NOT NULL,
461 `tid` int(11) NOT NULL,
462 PRIMARY KEY (`ID`)
463) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
464
465-- --------------------------------------------------------
466
467--
468-- Table structure for table `Reports`
469--
470
471CREATE TABLE IF NOT EXISTS `Reports` (
472 `ID` int(11) NOT NULL AUTO_INCREMENT,
473 `Message` longtext NOT NULL,
474 `OffenseID` longtext NOT NULL,
475 `Link` longtext NOT NULL,
476 `IP` longtext NOT NULL,
477 `Content` longtext NOT NULL,
478 PRIMARY KEY (`ID`)
479) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=117 ;
480
481-- --------------------------------------------------------
482
483--
484-- Table structure for table `Sales`
485--
486
487CREATE TABLE IF NOT EXISTS `Sales` (
488 `ID` int(11) NOT NULL AUTO_INCREMENT,
489 `UserID` int(11) NOT NULL,
490 `Amount` int(11) NOT NULL,
491 `ItemID` int(11) NOT NULL,
492 `SerialNum` int(11) NOT NULL,
493 PRIMARY KEY (`ID`)
494) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2721 ;
495
496--
497-- Dumping data for table `Sales`
498--
499
500INSERT INTO `Sales` (`ID`, `UserID`, `Amount`, `ItemID`, `SerialNum`) VALUES
501(2684, 3325, 2147483647, 2474, 4),
502(2683, 3325, 2147483647, 2475, 3),
503(2682, 3324, 666666666, 2474, 5),
504(2679, 3325, 2147483647, 2473, 7),
505(2678, 3325, 2147483647, 2456, 4),
506(2677, 3325, 2147483647, 2453, 2),
507(2676, 3325, 2147483647, 2447, 4),
508(2675, 3325, 2147483647, 2472, 5),
509(2674, 3325, 2147483647, 2450, 4),
510(2673, 3320, 350000, 2447, 2),
511(2672, 3320, 30000, 2459, 1),
512(2671, 3320, 100000, 2458, 1),
513(2687, 3360, 25000, 2483, 5),
514(2688, 3373, 90, 2542, 5),
515(2689, 3373, 600, 2536, 5),
516(2703, 4, 13333337, 2605, 0),
517(2720, 3382, 9999999, 2629, 1),
518(2697, 3385, 300000, 2590, 3),
519(2701, 3427, 10000, 2590, 0),
520(2707, 3426, 5000, 2612, 5),
521(2708, 3402, 5000, 2612, 2),
522(2712, 3414, 5000, 2613, 3),
523(2719, 3408, 5000, 2582, 1);
524
525-- --------------------------------------------------------
526
527--
528-- Table structure for table `Staff`
529--
530
531CREATE TABLE IF NOT EXISTS `Staff` (
532 `Username` text NOT NULL,
533 `Rank` int(11) NOT NULL AUTO_INCREMENT,
534 `Job` text NOT NULL,
535 PRIMARY KEY (`Rank`)
536) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
537
538-- --------------------------------------------------------
539
540--
541-- Table structure for table `Threads`
542--
543
544CREATE TABLE IF NOT EXISTS `Threads` (
545 `ID` int(11) NOT NULL AUTO_INCREMENT,
546 `Title` longtext NOT NULL,
547 `Body` longtext NOT NULL,
548 `PosterID` int(11) NOT NULL,
549 `OriginalTitle` longtext NOT NULL,
550 `OriginalBody` int(11) NOT NULL,
551 `Locked` int(11) NOT NULL DEFAULT '0',
552 `Type` varchar(1337) NOT NULL DEFAULT 'regular',
553 `tid` int(11) NOT NULL,
554 `bump` int(11) NOT NULL,
555 PRIMARY KEY (`ID`)
556) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
557
558-- --------------------------------------------------------
559
560--
561-- Table structure for table `tools`
562--
563
564CREATE TABLE IF NOT EXISTS `tools` (
565 `id` int(50) NOT NULL AUTO_INCREMENT,
566 `name` varchar(50) NOT NULL,
567 `image` varchar(50) NOT NULL,
568 PRIMARY KEY (`id`)
569) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
570
571--
572-- Dumping data for table `tools`
573--
574
575INSERT INTO `tools` (`id`, `name`, `image`) VALUES
576(1, 'Build Tool', 'build.png');
577
578-- --------------------------------------------------------
579
580--
581-- Table structure for table `Topics`
582--
583
584CREATE TABLE IF NOT EXISTS `Topics` (
585 `ID` int(11) NOT NULL AUTO_INCREMENT,
586 `TopicName` longtext NOT NULL,
587 `TopicDescription` longtext NOT NULL,
588 PRIMARY KEY (`ID`)
589) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
590
591-- --------------------------------------------------------
592
593--
594-- Table structure for table `TradeDrafts`
595--
596
597CREATE TABLE IF NOT EXISTS `TradeDrafts` (
598 `ID` int(11) NOT NULL AUTO_INCREMENT,
599 `SenderID` int(11) NOT NULL,
600 `ReceiveID` int(11) NOT NULL,
601 `GetID1` int(11) NOT NULL,
602 `GetID2` int(11) NOT NULL,
603 `GetID3` int(11) NOT NULL,
604 `GetID4` int(11) NOT NULL,
605 `GetID5` int(11) NOT NULL,
606 `LoseID1` int(11) NOT NULL,
607 `LoseID2` int(11) NOT NULL,
608 `LoseID3` int(11) NOT NULL,
609 `LoseID4` int(11) NOT NULL,
610 `LoseID5` int(11) NOT NULL,
611 `tradeExpire` int(11) NOT NULL,
612 PRIMARY KEY (`ID`)
613) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
614
615-- --------------------------------------------------------
616
617--
618-- Table structure for table `TradeRequests`
619--
620
621CREATE TABLE IF NOT EXISTS `TradeRequests` (
622 `ID` int(11) NOT NULL AUTO_INCREMENT,
623 `SendorID` int(11) NOT NULL,
624 `RecieverID` int(11) NOT NULL,
625 `Status` int(11) NOT NULL,
626 `Bux` int(11) NOT NULL,
627 `RequestedItem` longtext COLLATE utf8_unicode_ci NOT NULL,
628 `RequestedFile` int(11) NOT NULL,
629 `Gems` int(11) NOT NULL,
630 `Discount` int(11) NOT NULL,
631 `TradeFile` int(11) NOT NULL,
632 `TradeItem` int(11) NOT NULL,
633 `Read` int(11) NOT NULL,
634 PRIMARY KEY (`ID`)
635) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
636
637-- --------------------------------------------------------
638
639--
640-- Table structure for table `UserIPs`
641--
642
643CREATE TABLE IF NOT EXISTS `UserIPs` (
644 `ID` int(11) NOT NULL AUTO_INCREMENT,
645 `UserID` int(11) NOT NULL,
646 `IP` longtext NOT NULL,
647 PRIMARY KEY (`ID`)
648) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
649
650-- --------------------------------------------------------
651
652--
653-- Table structure for table `UserItemComments`
654--
655
656CREATE TABLE IF NOT EXISTS `UserItemComments` (
657 `ID` int(11) NOT NULL AUTO_INCREMENT,
658 `UserID` int(11) NOT NULL,
659 `ItemID` int(11) NOT NULL,
660 `Post` longtext NOT NULL,
661 `time` int(11) NOT NULL,
662 PRIMARY KEY (`ID`)
663) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
664
665-- --------------------------------------------------------
666
667--
668-- Table structure for table `Users`
669--
670
671CREATE TABLE IF NOT EXISTS `Users` (
672 `Username` longtext NOT NULL,
673 `Password` longtext NOT NULL,
674 `ID` int(11) NOT NULL AUTO_INCREMENT,
675 `Rank` int(11) NOT NULL DEFAULT '0',
676 `PowerAdmin` varchar(1337) NOT NULL DEFAULT 'false',
677 `Description` varchar(20000) NOT NULL DEFAULT 'none',
678 `Email` longtext NOT NULL,
679 `IP` longtext NOT NULL,
680 `visitTick` longtext NOT NULL,
681 `expireTime` longtext NOT NULL,
682 `PowerGame` varchar(1337) NOT NULL DEFAULT 'false',
683 `PowerImageModerator` varchar(1337) NOT NULL DEFAULT 'false',
684 `PowerForumModerator` varchar(1337) NOT NULL DEFAULT 'false',
685 `PowerArtist` varchar(1337) NOT NULL DEFAULT 'false',
686 `PowerMegaModerator` varchar(1337) NOT NULL DEFAULT 'false',
687 `OriginalName` longtext NOT NULL,
688 `Eyes` varchar(1337) NOT NULL,
689 `Mouth` varchar(1337) NOT NULL,
690 `Hair` varchar(1337) NOT NULL,
691 `Bottom` varchar(1337) NOT NULL,
692 `Top` varchar(1337) NOT NULL,
693 `Hat` varchar(1337) NOT NULL,
694 `Shoes` varchar(1337) NOT NULL,
695 `Accessory` varchar(1337) NOT NULL,
696 `forumflood` longtext NOT NULL,
697 `Bux` varchar(1337) NOT NULL DEFAULT '15',
698 `Rubies` varchar(1337) NOT NULL DEFAULT '10',
699 `Background` longtext NOT NULL,
700 `Body` varchar(1337) NOT NULL DEFAULT 'Avatar.png',
701 `Ban` int(11) NOT NULL DEFAULT '0',
702 `BanType` longtext NOT NULL,
703 `BanTime` longtext NOT NULL,
704 `BanDescription` longtext NOT NULL,
705 `BanLength` longtext NOT NULL,
706 `Hash` longtext NOT NULL,
707 `SuccessReferrer` int(11) NOT NULL DEFAULT '0',
708 `Premium` int(11) NOT NULL DEFAULT '0',
709 `PremiumExpire` longtext NOT NULL,
710 `isTester` int(11) NOT NULL DEFAULT '0',
711 `pviews` int(11) NOT NULL DEFAULT '0',
712 `BanContent` longtext NOT NULL,
713 `status` varchar(1) NOT NULL DEFAULT '0',
714 `PowerTop` varchar(1337) NOT NULL DEFAULT '0',
715 `vipStart` varchar(1000) NOT NULL DEFAULT '0',
716 `vipEnd` varchar(100) NOT NULL DEFAULT '0',
717 `vipsubscrid` varchar(50) NOT NULL DEFAULT '0',
718 `adminID` varchar(3) NOT NULL DEFAULT '0',
719 `room` varchar(50) NOT NULL,
720 `myroomID` varchar(250) NOT NULL,
721 `myroomIMG` varchar(250) NOT NULL DEFAULT 'templates/default/background.jpg ',
722 `roomaccess` varchar(3) NOT NULL DEFAULT '1',
723 `roomname` varchar(32) NOT NULL,
724 `roommax` varchar(4) NOT NULL DEFAULT '5',
725 `roomMaxStart` varchar(100) NOT NULL DEFAULT '0',
726 `roomMaxEnd` varchar(100) NOT NULL DEFAULT '0',
727 `roommaxsubscrid` varchar(20) NOT NULL DEFAULT '0',
728 `startX` varchar(3) NOT NULL DEFAULT '100',
729 `startY` varchar(3) NOT NULL DEFAULT '180',
730 `music` varchar(255) NOT NULL DEFAULT 'music/index.php',
731 `avatar` varchar(1000) NOT NULL,
732 `avatara` varchar(250) NOT NULL,
733 `avatarb` varchar(250) NOT NULL,
734 `avatarc` varchar(250) NOT NULL,
735 `avatar_x` varchar(10) NOT NULL,
736 `avatar_y` varchar(10) NOT NULL,
737 `online_time` varchar(50) NOT NULL,
738 `photo` varchar(255) NOT NULL DEFAULT 'nopic.jpg',
739 `WallFlood` int(11) NOT NULL,
740 `MainGroupID` int(11) NOT NULL,
741 `userx` int(50) NOT NULL DEFAULT '5',
742 `usery` int(50) NOT NULL DEFAULT '5',
743 `gameid` int(50) NOT NULL,
744 `CommentFlood` int(11) NOT NULL,
745 `getBux` int(11) NOT NULL,
746 `ingamenum` varchar(5) NOT NULL,
747 `chatid` varchar(50) NOT NULL,
748 `chatstatus` varchar(50) NOT NULL,
749 `ingame` varchar(50) NOT NULL,
750 PRIMARY KEY (`ID`)
751) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
752
753-- --------------------------------------------------------
754
755--
756-- Table structure for table `UserStore`
757--
758
759CREATE TABLE IF NOT EXISTS `UserStore` (
760 `ID` int(11) NOT NULL AUTO_INCREMENT,
761 `Name` longtext NOT NULL,
762 `File` longtext NOT NULL,
763 `Type` longtext NOT NULL,
764 `Price` int(11) NOT NULL,
765 `CreatorID` int(11) NOT NULL,
766 `saletype` varchar(1337) NOT NULL DEFAULT 'regular',
767 `numbersales` varchar(50) NOT NULL DEFAULT 'regular',
768 `numberstock` varchar(50) NOT NULL DEFAULT 'regular',
769 `sell` varchar(50) NOT NULL DEFAULT 'yes',
770 `ns` varchar(100) NOT NULL DEFAULT '0',
771 `active` int(11) NOT NULL DEFAULT '0',
772 `code1` longtext NOT NULL,
773 `code2` longtext NOT NULL,
774 `Description` longtext NOT NULL,
775 `CreationTime` longtext NOT NULL,
776 `store` varchar(1337) NOT NULL DEFAULT 'user',
777 `itemDeleted` int(11) NOT NULL DEFAULT '0',
778 PRIMARY KEY (`ID`)
779) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
780
781-- --------------------------------------------------------
782
783--
784-- Table structure for table `Wall`
785--
786
787CREATE TABLE IF NOT EXISTS `Wall` (
788 `ID` int(11) NOT NULL AUTO_INCREMENT,
789 `PosterID` int(11) NOT NULL,
790 `Body` longtext NOT NULL,
791 `time` longtext NOT NULL,
792 PRIMARY KEY (`ID`)
793) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
794
795/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
796/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
797/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
798