Hq7dC3R2

1CREATE TABLE IF NOT EXISTS `skillsoverall` (
2  `playerName` varchar(15) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
3  `lvl` int(11) DEFAULT NULL,
4  `xp` int(11) DEFAULT NULL,
5  PRIMARY KEY (`playerName`)
6) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
7
8CREATE TABLE IF NOT EXISTS `skills` (
9  `playerName` varchar(15) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
10  `Attacklvl` double DEFAULT NULL,
11  `Attackxp` double DEFAULT NULL,
12  `Defencelvl` double DEFAULT NULL,
13  `Defencexp` double DEFAULT NULL,
14  `Strengthlvl` double DEFAULT NULL,
15  `Strengthxp` double DEFAULT NULL,
16  `Hitpointslvl` double DEFAULT NULL,
17  `Hitpointsxp` double DEFAULT NULL,
18  `Rangelvl` double DEFAULT NULL,
19  `Rangexp` double DEFAULT NULL,
20  `Prayerlvl` double DEFAULT NULL,
21  `Prayerxp` double DEFAULT NULL,
22  `Magiclvl` double DEFAULT NULL,
23  `Magicxp` double DEFAULT NULL,
24  `Cookinglvl` double DEFAULT NULL,
25  `Cookingxp` double DEFAULT NULL,
26  `Woodcuttinglvl` double DEFAULT NULL,
27  `Woodcuttingxp` double DEFAULT NULL,
28  `Fletchinglvl` double DEFAULT NULL,
29  `Fletchingxp` double DEFAULT NULL,
30  `Fishinglvl` double DEFAULT NULL,
31  `Fishingxp` double DEFAULT NULL,
32  `Firemakinglvl` double DEFAULT NULL,
33  `Firemakingxp` double DEFAULT NULL,
34  `Craftinglvl` double DEFAULT NULL,
35  `Craftingxp` double DEFAULT NULL,
36  `Smithinglvl` double DEFAULT NULL,
37  `Smithingxp` double DEFAULT NULL,
38  `Mininglvl` double DEFAULT NULL,
39  `Miningxp` double DEFAULT NULL,
40  `Herblorelvl` double DEFAULT NULL,
41  `Herblorexp` double DEFAULT NULL,
42  `Agilitylvl` double DEFAULT NULL,
43  `Agilityxp` double DEFAULT NULL,
44  `Thievinglvl` double DEFAULT NULL,
45  `Thievingxp` double DEFAULT NULL,
46  `Slayerlvl` double DEFAULT NULL,
47  `Slayerxp` double DEFAULT NULL,
48  `Farminglvl` double DEFAULT NULL,
49  `Farmingxp` double DEFAULT NULL,
50  `Runecraftlvl` double DEFAULT NULL,
51  `Runecraftxp` double DEFAULT NULL,
52  PRIMARY KEY (`playerName`)
53) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;