· 9 years ago · Jan 17, 2017, 03:18 AM
1-- --------------------------------------------------------
2-- Host: *****************************
3-- Server version: 5.5.54-MariaDB - MariaDB Server
4-- Server OS: Linux
5-- HeidiSQL Version: 9.4.0.5125
6-- --------------------------------------------------------
7
8/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
9/*!40101 SET NAMES utf8 */;
10/*!50503 SET NAMES utf8mb4 */;
11/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
12/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
13
14-- Dumping structure for table aincradc_global.highscores
15CREATE TABLE IF NOT EXISTS `highscores` (
16 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
17 `username` varchar(20) DEFAULT NULL,
18 `overall_xp` bigint(20) NOT NULL DEFAULT '0',
19 `total_level` int(11) NOT NULL DEFAULT '0',
20 `ironManMode` varchar(15) NOT NULL DEFAULT 'NONE',
21 `attack_xp` int(11) NOT NULL DEFAULT '0',
22 `defence_xp` int(11) NOT NULL DEFAULT '0',
23 `strength_xp` int(11) NOT NULL DEFAULT '0',
24 `hitpoints_xp` int(11) NOT NULL DEFAULT '0',
25 `ranged_xp` int(11) NOT NULL DEFAULT '0',
26 `prayer_xp` int(11) NOT NULL DEFAULT '0',
27 `magic_xp` int(11) NOT NULL DEFAULT '0',
28 `cooking_xp` int(11) NOT NULL DEFAULT '0',
29 `woodcutting_xp` int(11) NOT NULL DEFAULT '0',
30 `fletching_xp` int(11) NOT NULL DEFAULT '0',
31 `fishing_xp` int(11) NOT NULL DEFAULT '0',
32 `firemaking_xp` int(11) NOT NULL DEFAULT '0',
33 `crafting_xp` int(11) NOT NULL DEFAULT '0',
34 `smithing_xp` int(11) NOT NULL DEFAULT '0',
35 `mining_xp` int(11) NOT NULL DEFAULT '0',
36 `herblore_xp` int(11) NOT NULL DEFAULT '0',
37 `agility_xp` int(11) NOT NULL DEFAULT '0',
38 `thieving_xp` int(11) NOT NULL DEFAULT '0',
39 `slayer_xp` int(11) NOT NULL DEFAULT '0',
40 `farming_xp` int(11) NOT NULL DEFAULT '0',
41 `runecrafting_xp` int(11) NOT NULL DEFAULT '0',
42 `hunter_xp` int(11) NOT NULL DEFAULT '0',
43 `construction_xp` int(11) NOT NULL DEFAULT '0',
44 `summoning_xp` int(11) NOT NULL DEFAULT '0',
45 PRIMARY KEY (`id`)
46) ENGINE=InnoDB AUTO_INCREMENT=325 DEFAULT CHARSET=latin1;
47
48-- Data exporting was unselected.
49/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
50/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
51/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;