· 6 years ago · May 10, 2019, 03:36 PM
1-- Adminer 4.2.5 MySQL dump
2
3SET NAMES utf8;
4SET time_zone = '+00:00';
5SET foreign_key_checks = 0;
6SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';
7
8DROP TABLE IF EXISTS `mordan_clans`;
9CREATE TABLE `mordan_clans` (
10 `clan_name` varchar(23) NOT NULL,
11 `color` varchar(23) DEFAULT NULL,
12 `members` text,
13 `gold` int(10) unsigned DEFAULT '0',
14 `kills` int(10) unsigned DEFAULT '0',
15 `deaths` int(10) unsigned DEFAULT '0',
16 `default_rank` varchar(23) DEFAULT NULL,
17 `default_perm` varchar(23) DEFAULT NULL,
18 `ally` text,
19 `enemy` text,
20 PRIMARY KEY (`clan_name`)
21) ENGINE=InnoDB DEFAULT CHARSET=latin1;
22
23
24DROP TABLE IF EXISTS `mordan_head`;
25CREATE TABLE `mordan_head` (
26 `username` varchar(23) NOT NULL,
27 `gold` int(10) unsigned DEFAULT '0',
28 PRIMARY KEY (`username`)
29) ENGINE=InnoDB DEFAULT CHARSET=latin1;
30
31
32DROP TABLE IF EXISTS `mordan_players_atribute`;
33CREATE TABLE `mordan_players_atribute` (
34 `username` varchar(23) NOT NULL,
35 `gold` int(10) unsigned DEFAULT '0',
36 `rank` float DEFAULT '0',
37 `pvp_win` smallint(5) unsigned DEFAULT '0',
38 `pvp_lose` smallint(5) unsigned DEFAULT '0',
39 `pk` smallint(5) unsigned DEFAULT '0',
40 `mission_complete` smallint(5) unsigned DEFAULT '0',
41 `monster_killed` int(10) unsigned DEFAULT '0',
42 PRIMARY KEY (`username`)
43) ENGINE=InnoDB DEFAULT CHARSET=latin1;
44
45INSERT INTO `mordan_players_atribute` (`username`, `gold`, `rank`, `pvp_win`, `pvp_lose`, `pk`, `mission_complete`, `monster_killed`) VALUES
46
47
48DROP TABLE IF EXISTS `mordan_players_character`;
49CREATE TABLE `mordan_players_character` (
50 `username` varchar(23) NOT NULL,
51 `character_1` varchar(23) DEFAULT 'NONE',
52 `character_2` varchar(23) DEFAULT 'NONE',
53 `character_3` varchar(23) DEFAULT 'PREMIUM',
54 `character_4` varchar(23) DEFAULT 'PREMIUM',
55 `mordan_points` int(10) unsigned DEFAULT '0',
56 `loggedin` int(10) unsigned DEFAULT '0',
57 PRIMARY KEY (`username`)
58) ENGINE=InnoDB DEFAULT CHARSET=latin1;
59
60INSERT INTO `mordan_players_character` (`username`, `character_1`, `character_2`, `character_3`, `character_4`, `mordan_points`, `loggedin`) VALUES
61
62
63DROP TABLE IF EXISTS `mordan_players_items`;
64CREATE TABLE `mordan_players_items` (
65 `username` varchar(23) NOT NULL,
66 `items` text,
67 PRIMARY KEY (`username`)
68) ENGINE=InnoDB DEFAULT CHARSET=latin1;
69
70INSERT INTO `mordan_players_items` (`username`, `items`) VALUES
71
72
73DROP TABLE IF EXISTS `mordan_players_mission`;
74CREATE TABLE `mordan_players_mission` (
75 `username` varchar(23) NOT NULL,
76 `mission` text,
77 `mission_data` text,
78 PRIMARY KEY (`username`)
79) ENGINE=InnoDB DEFAULT CHARSET=latin1;
80
81INSERT INTO `mordan_players_mission` (`username`, `mission`, `mission_data`) VALUES
82
83
84DROP TABLE IF EXISTS `mordan_players_npc_menu`;
85CREATE TABLE `mordan_players_npc_menu` (
86 `username` varchar(23) NOT NULL,
87 `menu` text,
88 PRIMARY KEY (`username`)
89) ENGINE=InnoDB DEFAULT CHARSET=latin1;
90
91INSERT INTO `mordan_players_npc_menu` (`username`, `menu`) VALUES
92
93
94DROP TABLE IF EXISTS `mordan_players_skills`;
95CREATE TABLE `mordan_players_skills` (
96 `username` varchar(23) NOT NULL,
97 `hunter` text,
98 `armorer` text,
99 `alchemist` text,
100 `smith` text,
101 `mage` text,
102 `other` text,
103 PRIMARY KEY (`username`)
104) ENGINE=InnoDB DEFAULT CHARSET=latin1;
105
106INSERT INTO `mordan_players_skills` (`username`, `hunter`, `armorer`, `alchemist`, `smith`, `mage`, `other`) VALUES
107
108
109DROP TABLE IF EXISTS `mordan_players_stats`;
110CREATE TABLE `mordan_players_stats` (
111 `username` varchar(23) NOT NULL,
112 `position` varchar(150) DEFAULT NULL,
113 `angle` smallint(5) unsigned DEFAULT NULL,
114 `world` varchar(40) DEFAULT NULL,
115 `acrobatic` tinyint(1) unsigned DEFAULT '0',
116 `visual` varchar(100) DEFAULT NULL,
117 `fatness` float DEFAULT NULL,
118 `dexterity` smallint(5) unsigned DEFAULT '10',
119 `strength` smallint(5) unsigned DEFAULT '10',
120 `experience` int(10) unsigned DEFAULT '0',
121 `next_experience` int(10) unsigned DEFAULT '200',
122 `level` tinyint(4) DEFAULT '0',
123 `learn_points` smallint(5) unsigned DEFAULT '0',
124 `health` smallint(5) unsigned DEFAULT '40',
125 `max_health` smallint(5) unsigned DEFAULT '40',
126 `mana` smallint(5) unsigned DEFAULT '0',
127 `max_mana` smallint(5) unsigned DEFAULT '0',
128 `magic_level` tinyint(4) DEFAULT '0',
129 `1h` tinyint(4) DEFAULT '0',
130 `2h` tinyint(4) DEFAULT '0',
131 `bow` tinyint(4) DEFAULT '0',
132 `crossbow` tinyint(4) DEFAULT '0',
133 `science` varchar(17) DEFAULT '0 0 0 0 0 0 0',
134 PRIMARY KEY (`username`)
135) ENGINE=InnoDB DEFAULT CHARSET=latin1;
136
137INSERT INTO `mordan_players_stats` (`username`, `position`, `angle`, `world`, `acrobatic`, `visual`, `fatness`, `dexterity`, `strength`, `experience`, `next_experience`, `level`, `learn_points`, `health`, `max_health`, `mana`, `max_mana`, `magic_level`, `1h`, `2h`, `bow`, `crossbow`, `science`) VALUES
138
139
140DROP TABLE IF EXISTS `mordan_players_update`;
141CREATE TABLE `mordan_players_update` (
142 `username` varchar(23) NOT NULL,
143 `finish` text,
144 PRIMARY KEY (`username`)
145) ENGINE=InnoDB DEFAULT CHARSET=latin1;
146
147INSERT INTO `mordan_players_update` (`username`, `finish`) VALUES
148
149DROP TABLE IF EXISTS `mordan_player_clans`;
150CREATE TABLE `mordan_player_clans` (
151 `username` varchar(23) NOT NULL,
152 `clan` varchar(23) DEFAULT NULL,
153 `rank` varchar(23) DEFAULT NULL,
154 `permission` varchar(23) DEFAULT NULL,
155 PRIMARY KEY (`username`)
156) ENGINE=InnoDB DEFAULT CHARSET=latin1;
157
158INSERT INTO `mordan_player_clans` (`username`, `clan`, `rank`, `permission`) VALUES
159
160DROP TABLE IF EXISTS `mordan_premium`;
161CREATE TABLE `mordan_premium` (
162 `username` varchar(23) NOT NULL,
163 `data` varchar(23) DEFAULT NULL,
164 PRIMARY KEY (`username`)
165) ENGINE=InnoDB DEFAULT CHARSET=latin1;
166
167
168DROP TABLE IF EXISTS `pb3_groups`;
169CREATE TABLE `pb3_groups` (
170 `group_name` varchar(30) NOT NULL,
171 `group_colour` char(30) NOT NULL,
172 `group_id` int(11) NOT NULL
173) ENGINE=InnoDB DEFAULT CHARSET=latin1;
174
175
176DROP TABLE IF EXISTS `pb3_users`;
177CREATE TABLE `pb3_users` (
178 `username` varchar(32) NOT NULL,
179 `user_password` varchar(32) NOT NULL,
180 `group_id` int(11) NOT NULL
181) ENGINE=InnoDB DEFAULT CHARSET=latin1;
182
183INSERT INTO `pb3_users` (`username`, `user_password`, `group_id`) VALUES
184('Avaldsnes', '202cb962ac59075b964b07152d234b70', 0);