theforgottenserver.sql, Rzeczy od was
[ Pobierz całość w formacie PDF ]
-- phpMyAdmin SQL Dump-- version 3.2.0.1---- Host: localhost-- Czas wygenerowania: 26 Sty 2011, 16:18-- Wersja serwera: 5.1.37-- Wersja PHP: 5.3.0SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";---- Baza danych: `theforgottenserver`---- ------------------------------------------------------------ Struktura tabeli dla `accounts`--CREATE TABLE IF NOT EXISTS `accounts` (`id` int(11) NOT NULL AUTO_INCREMENT,`name` varchar(32) NOT NULL DEFAULT '',`password` varchar(255) NOT NULL,`premdays` int(11) NOT NULL DEFAULT '0',`lastday` int(10) unsigned NOT NULL DEFAULT '0',`email` varchar(255) NOT NULL DEFAULT '',`key` varchar(20) NOT NULL DEFAULT '0',`blocked` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'internal usage',`warnings` int(11) NOT NULL DEFAULT '0',`group_id` int(11) NOT NULL DEFAULT '1',`page_lastday` int(11) NOT NULL,`email_new` varchar(255) NOT NULL,`email_new_time` int(15) NOT NULL,`created` int(11) NOT NULL DEFAULT '0',`rlname` varchar(255) NOT NULL DEFAULT '',`location` varchar(255) NOT NULL DEFAULT '',`page_access` int(11) NOT NULL DEFAULT '0',`last_post` int(11) NOT NULL DEFAULT '0',`email_code` varchar(255) NOT NULL DEFAULT '0',`next_email` int(11) NOT NULL DEFAULT '0',`premium_points` int(11) NOT NULL DEFAULT '0',`vote` int(11) NOT NULL,PRIMARY KEY (`id`),UNIQUE KEY `name` (`name`)) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=5988465 ;---- Wyzwalacze `accounts`--DROP TRIGGER IF EXISTS `theforgottenserver`.`ondelete_accounts`;DELIMITER //CREATE TRIGGER `theforgottenserver`.`ondelete_accounts` BEFORE DELETE ON `theforgottenserver`.`accounts`FOR EACH ROW BEGINDELETE FROM `bans` WHERE `type` IN (3, 4) AND `value` = OLD.`id`;END//DELIMITER ;---- Zrzut danych tabeli `accounts`--INSERT INTO `accounts` (`id`, `name`, `password`, `premdays`, `lastday`, `email`, `key`, `blocked`, `warnings`, `group_id`, `page_lastday`, `email_new`, `email_new_time`, `created`, `rlname`, `location`, `page_access`, `last_post`, `email_code`, `next_email`, `premium_points`, `vote`) VALUES(1, '1', 'pako9922', 65535, 1292951369, '', '0', 0, 0, 1, 1292862568, '', 0, 0, '', '', 3, 0, '0', 0, 0, 0),(3717651, 'RAFAEL9922', '726207853', 998, 1292950459, 'rafael9900@interia.pl', '0', 0, 0, 3, 1292867936, '', 0, 1292864033, '', '', 0, 0, '0', 0, 0, 0),(3820190, '5761127', '2x3vmd35', 998, 1292949838, 'mundzio123@interia.pl', '0', 0, 0, 3, 1292862927, '', 0, 1292862918, '', '', 0, 0, '0', 0, 0, 0),(5988464, '8005699', '2652583', 999, 1292868100, 'estene11@interia.pl', '0', 0, 0, 1, 1292868122, '', 0, 1292868099, '', '', 0, 0, '0', 0, 0, 0);-- ------------------------------------------------------------ Struktura tabeli dla `account_viplist`--CREATE TABLE IF NOT EXISTS `account_viplist` (`account_id` int(11) NOT NULL,`world_id` tinyint(2) unsigned NOT NULL DEFAULT '0',`player_id` int(11) NOT NULL,UNIQUE KEY `account_id_2` (`account_id`,`player_id`),KEY `account_id` (`account_id`),KEY `player_id` (`player_id`),KEY `world_id` (`world_id`)) ENGINE=InnoDB DEFAULT CHARSET=latin1;---- Zrzut danych tabeli `account_viplist`--INSERT INTO `account_viplist` (`account_id`, `world_id`, `player_id`) VALUES(3717651, 0, 12),(3820190, 0, 12),(5988464, 0, 9);-- ------------------------------------------------------------ Struktura tabeli dla `bans`--CREATE TABLE IF NOT EXISTS `bans` (`id` int(10) unsigned NOT NULL AUTO_INCREMENT,`type` tinyint(1) NOT NULL COMMENT '1 - ip banishment, 2 - namelock, 3 - account banishment, 4 - notation, 5 - deletion',`value` int(10) unsigned NOT NULL COMMENT 'ip address (integer), player guid or account number',`param` int(10) unsigned NOT NULL DEFAULT '4294967295' COMMENT 'used only for ip banishment mask (integer)',`active` tinyint(1) NOT NULL DEFAULT '1',`expires` int(11) NOT NULL,`added` int(10) unsigned NOT NULL,`admin_id` int(10) unsigned NOT NULL DEFAULT '0',`comment` text NOT NULL,`reason` int(10) unsigned NOT NULL DEFAULT '0',`action` int(10) unsigned NOT NULL DEFAULT '0',`statement` varchar(255) NOT NULL DEFAULT '',PRIMARY KEY (`id`),KEY `type` (`type`,`value`),KEY `active` (`active`)) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;---- Zrzut danych tabeli `bans`---- ------------------------------------------------------------ Struktura tabeli dla `environment_killers`--CREATE TABLE IF NOT EXISTS `environment_killers` (`kill_id` int(11) NOT NULL,`name` varchar(255) NOT NULL,KEY `kill_id` (`kill_id`)) ENGINE=InnoDB DEFAULT CHARSET=latin1;---- Zrzut danych tabeli `environment_killers`--INSERT INTO `environment_killers` (`kill_id`, `name`) VALUES(1, 'a dragon'),(2, 'a demon'),(3, 'a demon');-- ------------------------------------------------------------ Struktura tabeli dla `global_storage`--CREATE TABLE IF NOT EXISTS `global_storage` (`key` int(10) unsigned NOT NULL,`world_id` tinyint(2) unsigned NOT NULL DEFAULT '0',`value` varchar(255) NOT NULL DEFAULT '0',UNIQUE KEY `key` (`key`,`world_id`)) ENGINE=InnoDB DEFAULT CHARSET=latin1;---- Zrzut danych tabeli `global_storage`---- ------------------------------------------------------------ Struktura tabeli dla `guilds`--CREATE TABLE IF NOT EXISTS `guilds` (`id` int(11) NOT NULL AUTO_INCREMENT,`world_id` tinyint(2) unsigned NOT NULL DEFAULT '0',`name` varchar(255) NOT NULL,`ownerid` int(11) NOT NULL,`creationdata` int(11) NOT NULL,`motd` varchar(255) NOT NULL,`description` text NOT NULL,`logo_gfx_name` varchar(255) NOT NULL DEFAULT '',PRIMARY KEY (`id`),UNIQUE KEY `name` (`name`,`world_id`)) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;---- Wyzwalacze `guilds`--DROP TRIGGER IF EXISTS `theforgottenserver`.`oncreate_guilds`;DELIMITER //CREATE TRIGGER `theforgottenserver`.`oncreate_guilds` AFTER INSERT ON `theforgottenserver`.`guilds`FOR EACH ROW BEGININSERT INTO `guild_ranks` (`name`, `level`, `guild_id`) VALUES ('Leader', 3, NEW.`id`);INSERT INTO `guild_ranks` (`name`, `level`, `guild_id`) VALUES ('Vice-Leader', 2, NEW.`id`);INSERT INTO `guild_ranks` (`name`, `level`, `guild_id`) VALUES ('Member', 1, NEW.`id`);END//DELIMITER ;DROP TRIGGER IF EXISTS `theforgottenserver`.`ondelete_guilds`;DELIMITER //CREATE TRIGGER `theforgottenserver`.`ondelete_guilds` BEFORE DELETE ON `theforgottenserver`.`guilds`FOR EACH ROW BEGINUPDATE `players` SET `guildnick` = '', `rank_id` = 0 WHERE `rank_id` IN (SELECT `id` FROM `guild_ranks` WHERE `guild_id` = OLD.`id`);END//DELIMITER ;---- Zrzut danych tabeli `guilds`---- ------------------------------------------------------------ Struktura tabeli dla `guild_invites`--CREATE TABLE IF NOT EXISTS `guild_invites` (`player_id` int(11) NOT NULL DEFAULT '0',`guild_id` int(11) NOT NULL DEFAULT '0',UNIQUE KEY `player_id` (`player_id`,`guild_id`),KEY `guild_id` (`guild_id`)) ENGINE=InnoDB DEFAULT CHARSET=latin1;---- Zrzut danych tabeli `guild_invites`---- ------------------------------------------------------------ Struktura tabeli dla `guild_ranks`--CREATE TABLE IF NOT EXISTS `guild_ranks` (`id` int(11) NOT NULL AUTO_INCREMENT,`guild_id` int(11) NOT NULL,`name` varchar(255) NOT NULL,`level` int(11) NOT NULL COMMENT '1 - leader, 2 - vice leader, 3 - member',PRIMARY KEY (`id`),KEY `guild_id` (`guild_id`)) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;---- Zrzut danych tabeli `guild_ranks`---- ------------------------------------------------------------ Struktura tabeli dla `houses`--CREATE TABLE IF NOT EXISTS `houses` (`id` int(10) unsigned NOT NULL,`world_id` tinyint(2) unsigned NOT NULL DEFAULT '0',`owner` int(11) NOT NULL,`paid` int(10) unsigned NOT NULL DEFAULT '0',`warnings` int(11) NOT NULL DEFAULT '0',`lastwarning` int(10) unsigned NOT NULL DEFAULT '0',`name` varchar(255) NOT NULL,`town` int(10) unsigned NOT NULL DEFAULT '0',`size` int(10) unsigned NOT NULL DEFAULT '0',`price` int(10) unsigned NOT NULL DEFAULT '0',`rent` int(10) unsigned NOT NULL DEFAULT '0',`doors` int(10) unsigned NOT NULL DEFAULT '0',`beds` int(10) unsigned NOT NULL DEFAULT '0',`tiles` int(10) unsigned NOT NULL DEFAULT '0',`guild` tinyint(1) unsigned NOT NULL DEFAULT '0',`clear` tinyint(1) unsigned NOT NULL DEFAULT '0',UNIQUE KEY `id` (`id`,`world_id`)) ENGINE=InnoDB DEFAULT CHARSET=latin1;---- Zrzut danych tabeli `houses`--INSERT INTO `houses` (`id`, `world_id`, `owner`, `paid`, `warnings`, `lastwarning`, `name`, `town`, `size`, `price`, `rent`, `doors`, `beds`, `tiles`, `guild`, `clear`) VALUES(1, 0, 0, 0, 0, 0, 'Enigma Square I', 1, 68, 78000, 3500, 2, 0, 78, 0, 0),(4, 0, 0, 0, 0, 0, 'Enigma Square IV', 1, 74, 94000, 3800, 2, 0, 94, 0, 0),(6, 0, 0, 0, 0, 0, 'Enigma Square VI', 1, 55, 74000, 3100, 3, 2, 74, 0, 0),(7, 0, 0, 0, 0, 0, 'Enigma Square VII', 1, 66, 109000, 3500, 2, 2, 109, 0, 0),(8, 0, 0, 0, 0, 0, 'Enigma Square VIII', 1, 46, 73000, 4150, 2, 2, 73, 0, 0),(10, 0, 0, 0, 0, 0, 'Enigma Plaza I', 1, 18, 21000, 1050, 1, 2, 21, 0, 0),(11, 0, 0, 0, 0, 0, 'Enigma Plaza II', 1, 26, 29000, 1450, 1, 2, 29, 0, 0),(12, 0, 0, 0, 0, 0, 'Enigma Plaza III', 1, 19, 22000, 1100, 1, 2, 22, 0, 0),(13, 0, 0, 0, 0, 0, 'Enigma Plaza IV', 1, 32, 35000, 1750, 1, 2, 35, 0, 0),(14, 0, 0, 0, 0, 0, 'Boat Lane I', 1, 119, 126000, 6300, 3, 4, 126,...
[ Pobierz całość w formacie PDF ]