WthFxrzM

1
2DROP TRIGGER IF EXISTS `oncreate_guilds`;
3DROP TRIGGER IF EXISTS `ondelete_players`;
4DROP TRIGGER IF EXISTS `ondelete_guilds`;
5DROP TRIGGER IF EXISTS `ondelete_accounts`;
6
7DROP TABLE IF EXISTS `player_depotitems`;
8DROP TABLE IF EXISTS `tile_items`;
9DROP TABLE IF EXISTS `tiles`;
10DROP TABLE IF EXISTS `bans`;
11DROP TABLE IF EXISTS `house_lists`;
12DROP TABLE IF EXISTS `houses`;
13DROP TABLE IF EXISTS `player_items`;
14DROP TABLE IF EXISTS `player_namelocks`;
15DROP TABLE IF EXISTS `player_skills`;
16DROP TABLE IF EXISTS `player_storage`;
17DROP TABLE IF EXISTS `player_viplist`;
18DROP TABLE IF EXISTS `player_spells`;
19DROP TABLE IF EXISTS `player_deaths`;
20DROP TABLE IF EXISTS `killers`;
21DROP TABLE IF EXISTS `environment_killers`;
22DROP TABLE IF EXISTS `player_killers`;
23DROP TABLE IF EXISTS `guild_ranks`;
24DROP TABLE IF EXISTS `guilds`;
25DROP TABLE IF EXISTS `guild_invites`;
26DROP TABLE IF EXISTS `global_storage`;
27DROP TABLE IF EXISTS `players`;
28DROP TABLE IF EXISTS `accounts`;
29DROP TABLE IF EXISTS `server_record`;
30DROP TABLE IF EXISTS `server_motd`;
31DROP TABLE IF EXISTS `server_reports`;
32DROP TABLE IF EXISTS `server_config`;
33DROP TABLE IF EXISTS `account_viplist`;
34
35CREATE TABLE `accounts`
36(
37	`id` INT NOT NULL AUTO_INCREMENT,
38	`name` VARCHAR(32) NOT NULL DEFAULT '',
39	`password` VARCHAR(255) NOT NULL/* VARCHAR(32) NOT NULL COMMENT 'MD5'*//* VARCHAR(40) NOT NULL COMMENT 'SHA1'*/,
40	`premdays` INT NOT NULL DEFAULT 0,
41	`lastday` INT UNSIGNED NOT NULL DEFAULT 0,
42	`email` VARCHAR(255) NOT NULL DEFAULT '',
43	`key` VARCHAR(20) NOT NULL DEFAULT '0',
44	`blocked` TINYINT(1) NOT NULL DEFAULT FALSE COMMENT 'internal usage',
45	`warnings` INT NOT NULL DEFAULT 0,
46	`group_id` INT NOT NULL DEFAULT 1,
47	PRIMARY KEY (`id`), UNIQUE (`name`)
48) ENGINE = InnoDB;
49
50INSERT INTO `accounts` VALUES (1, '1', '1', 65535, 0, '', '0', 0, 0, 1);
51
52CREATE TABLE `players`
53(
54	`id` INT NOT NULL AUTO_INCREMENT,
55	`name` VARCHAR(255) NOT NULL,
56	`world_id` TINYINT(2) UNSIGNED NOT NULL DEFAULT 0,
57	`group_id` INT NOT NULL DEFAULT 1,
58	`account_id` INT NOT NULL DEFAULT 0,
59	`level` INT NOT NULL DEFAULT 1,
60	`vocation` INT NOT NULL DEFAULT 0,
61	`health` INT NOT NULL DEFAULT 150,
62	`healthmax` INT NOT NULL DEFAULT 150,
63	`experience` BIGINT NOT NULL DEFAULT 0,
64	`lookbody` INT NOT NULL DEFAULT 0,
65	`lookfeet` INT NOT NULL DEFAULT 0,
66	`lookhead` INT NOT NULL DEFAULT 0,
67	`looklegs` INT NOT NULL DEFAULT 0,
68	`looktype` INT NOT NULL DEFAULT 136,
69	`lookaddons` INT NOT NULL DEFAULT 0,
70	`maglevel` INT NOT NULL DEFAULT 0,
71	`mana` INT NOT NULL DEFAULT 0,
72	`manamax` INT NOT NULL DEFAULT 0,
73	`manaspent` INT NOT NULL DEFAULT 0,
74	`soul` INT UNSIGNED NOT NULL DEFAULT 0,
75	`town_id` INT NOT NULL DEFAULT 0,
76	`posx` INT NOT NULL DEFAULT 0,
77	`posy` INT NOT NULL DEFAULT 0,
78	`posz` INT NOT NULL DEFAULT 0,
79	`conditions` BLOB NOT NULL,
80	`cap` INT NOT NULL DEFAULT 0,
81	`sex` INT NOT NULL DEFAULT 0,
82	`lastlogin` BIGINT UNSIGNED NOT NULL DEFAULT 0,
83	`lastip` INT UNSIGNED NOT NULL DEFAULT 0,
84	`save` TINYINT(1) NOT NULL DEFAULT 1,
85	`skull` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0,
86	`skulltime` INT NOT NULL DEFAULT 0,
87	`rank_id` INT NOT NULL DEFAULT 0,
88	`guildnick` VARCHAR(255) NOT NULL DEFAULT '',
89	`lastlogout` BIGINT UNSIGNED NOT NULL DEFAULT 0,
90	`blessings` TINYINT(2) NOT NULL DEFAULT 0,
91	`balance` BIGINT NOT NULL DEFAULT 0,
92	`stamina` BIGINT NOT NULL DEFAULT 151200000 COMMENT 'stored in miliseconds',
93	`direction` INT NOT NULL DEFAULT 2,
94	`loss_experience` INT NOT NULL DEFAULT 100,
95	`loss_mana` INT NOT NULL DEFAULT 100,
96	`loss_skills` INT NOT NULL DEFAULT 100,
97	`loss_containers` INT NOT NULL DEFAULT 100,
98	`loss_items` INT NOT NULL DEFAULT 100,
99	`premend` INT NOT NULL DEFAULT 0 COMMENT 'NOT IN USE BY THE SERVER',
100	`online` TINYINT(1) NOT NULL DEFAULT 0,
101	`marriage` INT UNSIGNED NOT NULL DEFAULT 0,
102	`promotion` INT NOT NULL DEFAULT 0,
103	`deleted` TINYINT(1) NOT NULL DEFAULT FALSE,
104	`description` VARCHAR(255) NOT NULL DEFAULT '',
105	PRIMARY KEY (`id`), UNIQUE (`name`, `deleted`),
106	KEY (`account_id`), KEY (`group_id`),
107	KEY (`online`), KEY (`deleted`),
108	FOREIGN KEY (`account_id`) REFERENCES `accounts`(`id`) ON DELETE CASCADE
109) ENGINE = InnoDB;
110
111INSERT INTO `players` VALUES (1, 'Account Manager', 0, 1, 1, 1, 0, 150, 150, 0, 0, 0, 0, 0, 110, 0, 0, 0, 0, 0, 0, 0, 50, 50, 7, '', 400, 0, 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 201660000, 0, 100, 100, 100, 100, 100, 0, 0, 0, 0, 0, '');
112
113CREATE TABLE `account_viplist`
114(
115	`account_id` INT NOT NULL,
116	`world_id` TINYINT(2) UNSIGNED NOT NULL DEFAULT 0,
117	`player_id` INT NOT NULL,
118	KEY (`account_id`), KEY (`player_id`), KEY (`world_id`), UNIQUE (`account_id`, `player_id`),
119	FOREIGN KEY (`account_id`) REFERENCES `accounts`(`id`) ON DELETE CASCADE,
120	FOREIGN KEY (`player_id`) REFERENCES `players`(`id`) ON DELETE CASCADE
121) ENGINE = InnoDB;
122
123CREATE TABLE `player_deaths`
124(
125	`id` INT NOT NULL AUTO_INCREMENT,
126	`player_id` INT NOT NULL,
127	`date` BIGINT UNSIGNED NOT NULL,
128	`level` INT UNSIGNED NOT NULL,
129	PRIMARY KEY (`id`), INDEX (`date`),
130	FOREIGN KEY (`player_id`) REFERENCES `players`(`id`) ON DELETE CASCADE
131) ENGINE = InnoDB;
132
133CREATE TABLE `player_depotitems`
134(
135	`player_id` INT NOT NULL,
136	`sid` INT NOT NULL COMMENT 'any given range, eg. 0-100 is reserved for depot lockers and all above 100 will be normal items inside depots',
137	`pid` INT NOT NULL DEFAULT 0,
138	`itemtype` INT NOT NULL,
139	`count` INT NOT NULL DEFAULT 0,
140	`attributes` BLOB NOT NULL,
141	KEY (`player_id`), UNIQUE (`player_id`, `sid`),
142	FOREIGN KEY (`player_id`) REFERENCES `players`(`id`) ON DELETE CASCADE
143) ENGINE = InnoDB;
144
145CREATE TABLE `player_items`
146(
147	`player_id` INT NOT NULL DEFAULT 0,
148	`pid` INT NOT NULL DEFAULT 0,
149	`sid` INT NOT NULL DEFAULT 0,
150	`itemtype` INT NOT NULL DEFAULT 0,
151	`count` INT NOT NULL DEFAULT 0,
152	`attributes` BLOB NOT NULL,
153	KEY (`player_id`), UNIQUE (`player_id`, `sid`),
154	FOREIGN KEY (`player_id`) REFERENCES `players`(`id`) ON DELETE CASCADE
155) ENGINE = InnoDB;
156
157CREATE TABLE `player_namelocks`
158(
159	`player_id` INT NOT NULL DEFAULT 0,
160	`name` VARCHAR(255) NOT NULL,
161	`new_name` VARCHAR(255) NOT NULL,
162	`date` BIGINT NOT NULL DEFAULT 0,
163	KEY (`player_id`),
164	FOREIGN KEY (`player_id`) REFERENCES `players`(`id`) ON DELETE CASCADE
165) ENGINE = InnoDB;
166
167CREATE TABLE `player_skills`
168(
169	`player_id` INT NOT NULL DEFAULT 0,
170	`skillid` TINYINT(2) NOT NULL DEFAULT 0,
171	`value` INT UNSIGNED NOT NULL DEFAULT 0,
172	`count` INT UNSIGNED NOT NULL DEFAULT 0,
173	KEY (`player_id`), UNIQUE (`player_id`, `skillid`),
174	FOREIGN KEY (`player_id`) REFERENCES `players`(`id`) ON DELETE CASCADE
175) ENGINE = InnoDB;
176
177CREATE TABLE `player_spells`
178(
179	`player_id` INT NOT NULL,
180	`name` VARCHAR(255) NOT NULL,
181	KEY (`player_id`), UNIQUE (`player_id`, `name`),
182	FOREIGN KEY (`player_id`) REFERENCES `players`(`id`) ON DELETE CASCADE
183) ENGINE = InnoDB;
184
185CREATE TABLE `player_storage`
186(
187	`player_id` INT NOT NULL DEFAULT 0,
188	`key` INT UNSIGNED NOT NULL DEFAULT 0,
189	`value` VARCHAR(255) NOT NULL DEFAULT '0',
190	KEY (`player_id`), UNIQUE (`player_id`, `key`),
191	FOREIGN KEY (`player_id`) REFERENCES `players`(`id`) ON DELETE CASCADE
192) ENGINE = InnoDB;
193
194CREATE TABLE `player_viplist`
195(
196	`player_id` INT NOT NULL,
197	`vip_id` INT NOT NULL,
198	KEY (`player_id`), KEY (`vip_id`), UNIQUE (`player_id`, `vip_id`),
199	FOREIGN KEY (`player_id`) REFERENCES `players`(`id`) ON DELETE CASCADE,
200	FOREIGN KEY (`vip_id`) REFERENCES `players`(`id`) ON DELETE CASCADE
201) ENGINE = InnoDB;
202
203CREATE TABLE `killers`
204(
205	`id` INT NOT NULL AUTO_INCREMENT,
206	`death_id` INT NOT NULL,
207	`final_hit` TINYINT(1) UNSIGNED NOT NULL DEFAULT FALSE,
208	`unjustified` TINYINT(1) UNSIGNED NOT NULL DEFAULT FALSE,
209	PRIMARY KEY (`id`),
210	FOREIGN KEY (`death_id`) REFERENCES `player_deaths`(`id`) ON DELETE CASCADE
211) ENGINE = InnoDB;
212
213CREATE TABLE `player_killers`
214(
215	`kill_id` INT NOT NULL,
216	`player_id` INT NOT NULL,
217	FOREIGN KEY (`kill_id`) REFERENCES `killers`(`id`) ON DELETE CASCADE,
218	FOREIGN KEY (`player_id`) REFERENCES `players`(`id`) ON DELETE CASCADE
219) ENGINE = InnoDB;
220
221CREATE TABLE `environment_killers`
222(
223	`kill_id` INT NOT NULL,
224	`name` VARCHAR(255) NOT NULL,
225	FOREIGN KEY (`kill_id`) REFERENCES `killers`(`id`) ON DELETE CASCADE
226) ENGINE = InnoDB;
227
228CREATE TABLE `houses`
229(
230	`id` INT UNSIGNED NOT NULL,
231	`world_id` TINYINT(2) UNSIGNED NOT NULL DEFAULT 0,
232	`owner` INT NOT NULL,
233	`paid` INT UNSIGNED NOT NULL DEFAULT 0,
234	`warnings` INT NOT NULL DEFAULT 0,
235	`lastwarning` INT UNSIGNED NOT NULL DEFAULT 0,
236	`name` VARCHAR(255) NOT NULL,
237	`town` INT UNSIGNED NOT NULL DEFAULT 0,
238	`size` INT UNSIGNED NOT NULL DEFAULT 0,
239	`price` INT UNSIGNED NOT NULL DEFAULT 0,
240	`rent` INT UNSIGNED NOT NULL DEFAULT 0,
241	`doors` INT UNSIGNED NOT NULL DEFAULT 0,
242	`beds` INT UNSIGNED NOT NULL DEFAULT 0,
243	`tiles` INT UNSIGNED NOT NULL DEFAULT 0,
244	`guild` TINYINT(1) UNSIGNED NOT NULL DEFAULT FALSE,
245	`clear` TINYINT(1) UNSIGNED NOT NULL DEFAULT FALSE,
246	UNIQUE (`id`, `world_id`)
247) ENGINE = InnoDB;
248
249CREATE TABLE `house_auctions`
250(
251	`house_id` INT UNSIGNED NOT NULL,
252	`world_id` TINYINT(2) UNSIGNED NOT NULL DEFAULT 0,
253	`player_id` INT NOT NULL,
254	`bid` INT UNSIGNED NOT NULL DEFAULT 0,
255	`limit` INT UNSIGNED NOT NULL DEFAULT 0,
256	`endtime` BIGINT UNSIGNED NOT NULL DEFAULT 0,
257	UNIQUE (`house_id`, `world_id`),
258	FOREIGN KEY (`house_id`, `world_id`) REFERENCES `houses`(`id`, `world_id`) ON DELETE CASCADE,
259	FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE
260) ENGINE = InnoDB;
261
262CREATE TABLE `house_lists`
263(
264	`house_id` INT UNSIGNED NOT NULL,
265	`world_id` TINYINT(2) UNSIGNED NOT NULL DEFAULT 0,
266	`listid` INT NOT NULL,
267	`list` TEXT NOT NULL,
268	UNIQUE (`house_id`, `world_id`, `listid`),
269	FOREIGN KEY (`house_id`, `world_id`) REFERENCES `houses`(`id`, `world_id`) ON DELETE CASCADE
270) ENGINE = InnoDB;
271
272CREATE TABLE `house_data`
273(
274	`house_id` INT UNSIGNED NOT NULL,
275	`world_id` TINYINT(2) UNSIGNED NOT NULL DEFAULT 0,
276	`data` LONGBLOB NOT NULL,
277	UNIQUE (`house_id`, `world_id`),
278	FOREIGN KEY (`house_id`, `world_id`) REFERENCES `houses`(`id`, `world_id`) ON DELETE CASCADE
279) ENGINE = InnoDB;
280
281CREATE TABLE `tiles`
282(
283	`id` INT UNSIGNED NOT NULL,
284	`world_id` TINYINT(2) UNSIGNED NOT NULL DEFAULT 0,
285	`house_id` INT UNSIGNED NOT NULL,
286	`x` INT(5) UNSIGNED NOT NULL,
287	`y` INT(5) UNSIGNED NOT NULL,
288	`z` TINYINT(2) UNSIGNED NOT NULL,
289	UNIQUE (`id`, `world_id`),
290	KEY (`x`, `y`, `z`),
291	FOREIGN KEY (`house_id`, `world_id`) REFERENCES `houses`(`id`, `world_id`) ON DELETE CASCADE
292) ENGINE = InnoDB;
293
294CREATE TABLE `tile_items`
295(
296	`tile_id` INT UNSIGNED NOT NULL,
297	`world_id` TINYINT(2) UNSIGNED NOT NULL DEFAULT 0,
298	`sid` INT NOT NULL,
299	`pid` INT NOT NULL DEFAULT 0,
300	`itemtype` INT NOT NULL,
301	`count` INT NOT NULL DEFAULT 0,
302	`attributes` BLOB NOT NULL,
303	UNIQUE (`tile_id`, `world_id`, `sid`), KEY (`sid`),
304	FOREIGN KEY (`tile_id`) REFERENCES `tiles`(`id`) ON DELETE CASCADE
305) ENGINE = InnoDB;
306
307CREATE TABLE `guilds`
308(
309	`id` INT NOT NULL AUTO_INCREMENT,
310	`world_id` TINYINT(2) UNSIGNED NOT NULL DEFAULT 0,
311	`name` VARCHAR(255) NOT NULL,
312	`ownerid` INT NOT NULL,
313	`creationdata` INT NOT NULL,
314	`motd` VARCHAR(255) NOT NULL,
315	PRIMARY KEY (`id`),
316	UNIQUE (`name`, `world_id`)
317) ENGINE = InnoDB;
318
319CREATE TABLE `guild_invites`
320(
321	`player_id` INT NOT NULL DEFAULT 0,
322	`guild_id` INT NOT NULL DEFAULT 0,
323	UNIQUE (`player_id`, `guild_id`),
324	FOREIGN KEY (`player_id`) REFERENCES `players`(`id`) ON DELETE CASCADE,
325	FOREIGN KEY (`guild_id`) REFERENCES `guilds`(`id`) ON DELETE CASCADE
326) ENGINE = InnoDB;
327
328CREATE TABLE `guild_ranks`
329(
330	`id` INT NOT NULL AUTO_INCREMENT,
331	`guild_id` INT NOT NULL,
332	`name` VARCHAR(255) NOT NULL,
333	`level` INT NOT NULL COMMENT '1 - leader, 2 - vice leader, 3 - member',
334	PRIMARY KEY (`id`),
335	FOREIGN KEY (`guild_id`) REFERENCES `guilds`(`id`) ON DELETE CASCADE
336) ENGINE = InnoDB;
337
338CREATE TABLE `bans`
339(
340	`id` INT UNSIGNED NOT NULL auto_increment,
341	`type` TINYINT(1) NOT NULL COMMENT '1 - ip banishment, 2 - namelock, 3 - account banishment, 4 - notation, 5 - deletion',
342	`value` INT UNSIGNED NOT NULL COMMENT 'ip address (integer), player guid or account number',
343	`param` INT UNSIGNED NOT NULL DEFAULT 4294967295 COMMENT 'used only for ip banishment mask (integer)',
344	`active` TINYINT(1) NOT NULL DEFAULT TRUE,
345	`expires` INT NOT NULL,
346	`added` INT UNSIGNED NOT NULL,
347	`admin_id` INT UNSIGNED NOT NULL DEFAULT 0,
348	`comment` TEXT NOT NULL,
349	`reason` INT UNSIGNED NOT NULL DEFAULT 0,
350	`action` INT UNSIGNED NOT NULL DEFAULT 0,
351	`statement` VARCHAR(255) NOT NULL DEFAULT '',
352	PRIMARY KEY (`id`),
353	KEY `type` (`type`, `value`),
354	KEY `active` (`active`)
355) ENGINE = InnoDB;
356
357CREATE TABLE `global_storage`
358(
359	`key` INT UNSIGNED NOT NULL,
360	`world_id` TINYINT(2) UNSIGNED NOT NULL DEFAULT 0,
361	`value` VARCHAR(255) NOT NULL DEFAULT '0',
362	UNIQUE  (`key`, `world_id`)
363) ENGINE = InnoDB;
364
365CREATE TABLE `server_config`
366(
367	`config` VARCHAR(35) NOT NULL DEFAULT '',
368	`value` INT NOT NULL,
369	UNIQUE (`config`)
370) ENGINE = InnoDB;
371
372INSERT INTO `server_config` VALUES ('db_version', 23);
373
374CREATE TABLE `server_motd`
375(
376	`id` INT UNSIGNED NOT NULL,
377	`world_id` TINYINT(2) UNSIGNED NOT NULL DEFAULT 0,
378	`text` TEXT NOT NULL,
379	UNIQUE (`id`, `world_id`)
380) ENGINE = InnoDB;
381
382INSERT INTO `server_motd` VALUES (1, 0, 'Welcome to The Forgotten Server!');
383
384CREATE TABLE `server_record`
385(
386	`record` INT NOT NULL,
387	`world_id` TINYINT(2) UNSIGNED NOT NULL DEFAULT 0,
388	`timestamp` BIGINT NOT NULL,
389	UNIQUE (`record`, `world_id`, `timestamp`)
390) ENGINE = InnoDB;
391
392INSERT INTO `server_record` VALUES (0, 0, 0);
393
394CREATE TABLE `server_reports`
395(
396	`id` INT NOT NULL AUTO_INCREMENT,
397	`world_id` TINYINT(2) UNSIGNED NOT NULL DEFAULT 0,
398	`player_id` INT NOT NULL DEFAULT 1,
399	`posx` INT NOT NULL DEFAULT 0,
400	`posy` INT NOT NULL DEFAULT 0,
401	`posz` INT NOT NULL DEFAULT 0,
402	`timestamp` BIGINT NOT NULL DEFAULT 0,
403	`report` TEXT NOT NULL,
404	`reads` INT NOT NULL DEFAULT 0,
405	PRIMARY KEY (`id`),
406	KEY (`world_id`), KEY (`reads`),
407	FOREIGN KEY (`player_id`) REFERENCES `players`(`id`) ON DELETE CASCADE
408) ENGINE = InnoDB;
409
410DELIMITER |
411
412CREATE TRIGGER `ondelete_accounts`
413BEFORE DELETE
414ON `accounts`
415FOR EACH ROW
416BEGIN
417	DELETE FROM `bans` WHERE `type` IN (3, 4) AND `value` = OLD.`id`;
418END|
419
420CREATE TRIGGER `oncreate_guilds`
421AFTER INSERT
422ON `guilds`
423FOR EACH ROW
424BEGIN
425	INSERT INTO `guild_ranks` (`name`, `level`, `guild_id`) VALUES ('Leader', 3, NEW.`id`);
426	INSERT INTO `guild_ranks` (`name`, `level`, `guild_id`) VALUES ('Vice-Leader', 2, NEW.`id`);
427	INSERT INTO `guild_ranks` (`name`, `level`, `guild_id`) VALUES ('Member', 1, NEW.`id`);
428END|
429
430CREATE TRIGGER `ondelete_guilds`
431BEFORE DELETE
432ON `guilds`
433FOR EACH ROW
434BEGIN
435	UPDATE `players` SET `guildnick` = '', `rank_id` = 0 WHERE `rank_id` IN (SELECT `id` FROM `guild_ranks` WHERE `guild_id` = OLD.`id`);
436END|
437
438CREATE TRIGGER `oncreate_players`
439AFTER INSERT
440ON `players`
441FOR EACH ROW
442BEGIN
443	INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 0, 10);
444	INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 1, 10);
445	INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 2, 10);
446	INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 3, 10);
447	INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 4, 10);
448	INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 5, 10);
449	INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 6, 10);
450END|
451
452CREATE TRIGGER `ondelete_players`
453BEFORE DELETE
454ON `players`
455FOR EACH ROW
456BEGIN
457	DELETE FROM `bans` WHERE `type` IN (2, 5) AND `value` = OLD.`id`;
458	UPDATE `houses` SET `owner` = 0 WHERE `owner` = OLD.`id`;
459END|
460
461DELIMITER ;