PwP2vd1J

1DROP TABLE IF EXISTS `moopledev`.`dueyitems`;
2CREATE TABLE  `moopledev`.`dueyitems` (
3  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
4  `PackageId` int(10) unsigned NOT NULL DEFAULT '0',
5  `itemid` int(10) unsigned NOT NULL DEFAULT '0',
6  `quantity` int(10) unsigned NOT NULL DEFAULT '0',
7  `upgradeslots` int(11) DEFAULT '0',
8  `level` int(11) DEFAULT '0',
9  `str` int(11) DEFAULT '0',
10  `dex` int(11) DEFAULT '0',
11  `int` int(11) DEFAULT '0',
12  `luk` int(11) DEFAULT '0',
13  `hp` int(11) DEFAULT '0',
14  `mp` int(11) DEFAULT '0',
15  `watk` int(11) DEFAULT '0',
16  `matk` int(11) DEFAULT '0',
17  `wdef` int(11) DEFAULT '0',
18  `mdef` int(11) DEFAULT '0',
19  `acc` int(11) DEFAULT '0',
20  `avoid` int(11) DEFAULT '0',
21  `hands` int(11) DEFAULT '0',
22  `speed` int(11) DEFAULT '0',
23  `jump` int(11) DEFAULT '0',
24  `owner` varchar(13) DEFAULT NULL,
25  PRIMARY KEY (`id`),
26  KEY `PackageId` (`PackageId`)
27) ENGINE=InnoDB DEFAULT CHARSET=latin1;
28
29DROP TABLE IF EXISTS `moopledev`.`dueypackages`;
30CREATE TABLE  `moopledev`.`dueypackages` (
31  `PackageId` int(10) unsigned NOT NULL AUTO_INCREMENT,
32  `RecieverId` int(10) unsigned NOT NULL,
33  `SenderName` varchar(13) NOT NULL,
34  `Mesos` int(10) unsigned DEFAULT '0',
35  `TimeStamp` varchar(10) NOT NULL,
36  `Checked` tinyint(1) unsigned DEFAULT '1',
37  `Type` tinyint(1) unsigned NOT NULL,
38  PRIMARY KEY (`PackageId`)
39) ENGINE=InnoDB DEFAULT CHARSET=latin1;