Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- Alterações de nome de tabelas --
- RENAME TABLE `acc_reg_num_db` TO `acc_reg_num`
- RENAME TABLE `acc_reg_str_db` TO `acc_reg_str`
- RENAME TABLE `char_reg_num_db` TO `char_reg_num`
- RENAME TABLE `char_reg_str_db` TO `char_reg_str`
- RENAME TABLE `global_acc_reg_num_db` TO `global_acc_reg_num`
- RENAME TABLE `global_acc_reg_str_db` TO `global_acc_reg_str`
- -- Alterações de adaptação da tabela char --
- ALTER TABLE `char` ADD `moves` INT(11) UNSIGNED NOT NULL DEFAULT '0' AFTER `delete_date`;
- ALTER TABLE `char` DROP COLUMN `slotchange`;
- ALTER TABLE `char` DROP COLUMN `char_opt`;
- ALTER TABLE `char` MODIFY `font` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0' AFTER `unban_time`;
- -- Alterações de adaptação da tabela guild_storage --
- ALTER TABLE `guild_storage` ADD `option_id0` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `card3`;
- ALTER TABLE `guild_storage` ADD `option_val0` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `option_id0`;
- ALTER TABLE `guild_storage` ADD `option_parm0` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0' AFTER `option_val0`;
- ALTER TABLE `guild_storage` ADD `option_id1` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `option_parm0`;
- ALTER TABLE `guild_storage` ADD `option_val1` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `option_id1`;
- ALTER TABLE `guild_storage` ADD `option_parm1` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0' AFTER `option_val1`;
- ALTER TABLE `guild_storage` ADD `option_id2` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `option_parm1`;
- ALTER TABLE `guild_storage` ADD `option_val2` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `option_id2`;
- ALTER TABLE `guild_storage` ADD `option_parm2` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0' AFTER `option_val2`;
- ALTER TABLE `guild_storage` ADD `option_id3` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `option_parm2`;
- ALTER TABLE `guild_storage` ADD `option_val3` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `option_id3`;
- ALTER TABLE `guild_storage` ADD `option_parm3` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0' AFTER `option_val3`;
- ALTER TABLE `guild_storage` ADD `option_id4` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `option_parm3`;
- ALTER TABLE `guild_storage` ADD `option_val4` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `option_id4`;
- ALTER TABLE `guild_storage` ADD `option_parm4` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0' AFTER `option_val4`;
- -- Alterações de adaptação da tabela storage --
- ALTER TABLE `storage` ADD `option_id0` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `card3`;
- ALTER TABLE `storage` ADD `option_val0` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `option_id0`;
- ALTER TABLE `storage` ADD `option_parm0` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0' AFTER `option_val0`;
- ALTER TABLE `storage` ADD `option_id1` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `option_parm0`;
- ALTER TABLE `storage` ADD `option_val1` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `option_id1`;
- ALTER TABLE `storage` ADD `option_parm1` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0' AFTER `option_val1`;
- ALTER TABLE `storage` ADD `option_id2` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `option_parm1`;
- ALTER TABLE `storage` ADD `option_val2` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `option_id2`;
- ALTER TABLE `storage` ADD `option_parm2` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0' AFTER `option_val2`;
- ALTER TABLE `storage` ADD `option_id3` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `option_parm2`;
- ALTER TABLE `storage` ADD `option_val3` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `option_id3`;
- ALTER TABLE `storage` ADD `option_parm3` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0' AFTER `option_val3`;
- ALTER TABLE `storage` ADD `option_id4` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `option_parm3`;
- ALTER TABLE `storage` ADD `option_val4` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `option_id4`;
- ALTER TABLE `storage` ADD `option_parm4` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0' AFTER `option_val4`;
- -- Alterações de adaptação da tabela inventory --
- ALTER TABLE `inventory` ADD `option_id0` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `card3`;
- ALTER TABLE `inventory` ADD `option_val0` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `option_id0`;
- ALTER TABLE `inventory` ADD `option_parm0` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0' AFTER `option_val0`;
- ALTER TABLE `inventory` ADD `option_id1` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `option_parm0`;
- ALTER TABLE `inventory` ADD `option_val1` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `option_id1`;
- ALTER TABLE `inventory` ADD `option_parm1` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0' AFTER `option_val1`;
- ALTER TABLE `inventory` ADD `option_id2` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `option_parm1`;
- ALTER TABLE `inventory` ADD `option_val2` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `option_id2`;
- ALTER TABLE `inventory` ADD `option_parm2` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0' AFTER `option_val2`;
- ALTER TABLE `inventory` ADD `option_id3` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `option_parm2`;
- ALTER TABLE `inventory` ADD `option_val3` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `option_id3`;
- ALTER TABLE `inventory` ADD `option_parm3` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0' AFTER `option_val3`;
- ALTER TABLE `inventory` ADD `option_id4` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `option_parm3`;
- ALTER TABLE `inventory` ADD `option_val4` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `option_id4`;
- ALTER TABLE `inventory` ADD `option_parm4` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0' AFTER `option_val4`;
- -- Alterações de adaptação da tabela cart_inventory --
- ALTER TABLE `cart_inventory` ADD `option_id0` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `card3`;
- ALTER TABLE `cart_inventory` ADD `option_val0` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `option_id0`;
- ALTER TABLE `cart_inventory` ADD `option_parm0` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0' AFTER `option_val0`;
- ALTER TABLE `cart_inventory` ADD `option_id1` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `option_parm0`;
- ALTER TABLE `cart_inventory` ADD `option_val1` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `option_id1`;
- ALTER TABLE `cart_inventory` ADD `option_parm1` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0' AFTER `option_val1`;
- ALTER TABLE `cart_inventory` ADD `option_id2` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `option_parm1`;
- ALTER TABLE `cart_inventory` ADD `option_val2` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `option_id2`;
- ALTER TABLE `cart_inventory` ADD `option_parm2` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0' AFTER `option_val2`;
- ALTER TABLE `cart_inventory` ADD `option_id3` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `option_parm2`;
- ALTER TABLE `cart_inventory` ADD `option_val3` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `option_id3`;
- ALTER TABLE `cart_inventory` ADD `option_parm3` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0' AFTER `option_val3`;
- ALTER TABLE `cart_inventory` ADD `option_id4` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `option_parm3`;
- ALTER TABLE `cart_inventory` ADD `option_val4` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `option_id4`;
- ALTER TABLE `cart_inventory` ADD `option_parm4` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0' AFTER `option_val4`;
- -- Adições extras de tabelas do emulador --
- DROP TABLE IF EXISTS `auction`;
- CREATE TABLE IF NOT EXISTS `auction` (
- `auction_id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
- `seller_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
- `seller_name` VARCHAR(30) NOT NULL DEFAULT '',
- `buyer_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
- `buyer_name` VARCHAR(30) NOT NULL DEFAULT '',
- `price` INT(11) UNSIGNED NOT NULL DEFAULT '0',
- `buynow` INT(11) UNSIGNED NOT NULL DEFAULT '0',
- `hours` SMALLINT(6) NOT NULL DEFAULT '0',
- `timestamp` INT(11) UNSIGNED NOT NULL DEFAULT '0',
- `nameid` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
- `item_name` VARCHAR(50) NOT NULL DEFAULT '',
- `type` SMALLINT(6) NOT NULL DEFAULT '0',
- `refine` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
- `attribute` tinyint(4) UNSIGNED NOT NULL DEFAULT '0',
- `card0` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
- `card1` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
- `card2` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
- `card3` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
- `option_id0` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
- `option_val0` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
- `option_parm0` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
- `option_id1` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
- `option_val1` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
- `option_parm1` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
- `option_id2` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
- `option_val2` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
- `option_parm2` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
- `option_id3` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
- `option_val3` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
- `option_parm3` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
- `option_id4` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
- `option_val4` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
- `option_parm4` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
- `unique_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
- PRIMARY KEY (`auction_id`)
- ) ENGINE=MyISAM;
- DROP TABLE IF EXISTS `mail`;
- CREATE TABLE IF NOT EXISTS `mail` (
- `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
- `send_name` VARCHAR(30) NOT NULL DEFAULT '',
- `send_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
- `dest_name` VARCHAR(30) NOT NULL DEFAULT '',
- `dest_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
- `title` VARCHAR(45) NOT NULL DEFAULT '',
- `message` VARCHAR(255) NOT NULL DEFAULT '',
- `time` INT(11) UNSIGNED NOT NULL DEFAULT '0',
- `status` tinyint(2) NOT NULL DEFAULT '0',
- `zeny` INT(11) UNSIGNED NOT NULL DEFAULT '0',
- `nameid` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
- `amount` INT(11) UNSIGNED NOT NULL DEFAULT '0',
- `refine` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
- `attribute` tinyint(4) UNSIGNED NOT NULL DEFAULT '0',
- `identify` SMALLINT(6) NOT NULL DEFAULT '0',
- `card0` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
- `card1` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
- `card2` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
- `card3` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
- `option_id0` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
- `option_val0` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
- `option_parm0` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
- `option_id1` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
- `option_val1` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
- `option_parm1` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
- `option_id2` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
- `option_val2` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
- `option_parm2` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
- `option_id3` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
- `option_val3` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
- `option_parm3` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
- `option_id4` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
- `option_val4` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
- `option_parm4` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
- `unique_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
- `bound` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
- PRIMARY KEY (`id`)
- ) ENGINE=MyISAM;
- CREATE TABLE IF NOT EXISTS `bonus_script` (
- `char_id` INT(11) UNSIGNED NOT NULL,
- `script` TEXT NOT NULL,
- `tick` INT(11) UNSIGNED NOT NULL DEFAULT '0',
- `flag` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
- `type` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0',
- `icon` SMALLINT(3) NOT NULL DEFAULT '-1'
- ) ENGINE=InnoDB;
- CREATE TABLE IF NOT EXISTS `market` (
- `name` VARCHAR(32) NOT NULL DEFAULT '',
- `nameid` SMALLINT(5) UNSIGNED NOT NULL,
- `price` INT(11) UNSIGNED NOT NULL,
- `amount` SMALLINT(5) UNSIGNED NOT NULL,
- `flag` TINYINT(2) UNSIGNED NOT NULL DEFAULT '0',
- PRIMARY KEY (`name`,`nameid`)
- ) ENGINE = MyISAM;
- CREATE TABLE IF NOT EXISTS `skill` (
- `char_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
- `id` SMALLINT(11) UNSIGNED NOT NULL DEFAULT '0',
- `lv` tinyint(4) UNSIGNED NOT NULL DEFAULT '0',
- `flag` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0,
- PRIMARY KEY (`char_id`,`id`)
- ) ENGINE=MyISAM;
- CREATE TABLE IF NOT EXISTS `skill_homunculus` (
- `homun_id` INT(11) NOT NULL,
- `id` INT(11) NOT NULL,
- `lv` SMALLINT(6) NOT NULL,
- PRIMARY KEY (`homun_id`,`id`)
- ) ENGINE=MyISAM;
- CREATE TABLE IF NOT EXISTS `skillcooldown` (
- `account_id` INT(11) UNSIGNED NOT NULL,
- `char_id` INT(11) UNSIGNED NOT NULL,
- `skill` SMALLINT(11) UNSIGNED NOT NULL DEFAULT '0',
- `tick` INT(11) NOT NULL,
- KEY `account_id` (`account_id`),
- KEY `char_id` (`char_id`)
- ) ENGINE=MyISAM;
- CREATE TABLE IF NOT EXISTS `vending_items` (
- `vending_id` INT(10) UNSIGNED NOT NULL,
- `index` SMALLINT(5) UNSIGNED NOT NULL,
- `cartinventory_id` INT(10) UNSIGNED NOT NULL,
- `amount` SMALLINT(5) UNSIGNED NOT NULL,
- `price` INT(10) UNSIGNED NOT NULL
- ) ENGINE=MyISAM;
- CREATE TABLE IF NOT EXISTS `vendings` (
- `id` INT(10) UNSIGNED NOT NULL,
- `account_id` INT(11) UNSIGNED NOT NULL,
- `char_id` INT(10) UNSIGNED NOT NULL,
- `sex` enum('F','M') NOT NULL DEFAULT 'M',
- `map` VARCHAR(20) NOT NULL,
- `x` SMALLINT(5) UNSIGNED NOT NULL,
- `y` SMALLINT(5) UNSIGNED NOT NULL,
- `title` VARCHAR(80) NOT NULL,
- `body_direction` CHAR( 1 ) NOT NULL DEFAULT '4',
- `head_direction` CHAR( 1 ) NOT NULL DEFAULT '0',
- `sit` CHAR( 1 ) NOT NULL DEFAULT '1',
- `autotrade` tinyint(4) NOT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=MyISAM;
- CREATE TABLE IF NOT EXISTS `buyingstore_items` (
- `buyingstore_id` INT(10) UNSIGNED NOT NULL,
- `index` SMALLINT(5) UNSIGNED NOT NULL,
- `item_id` INT(10) UNSIGNED NOT NULL,
- `amount` SMALLINT(5) UNSIGNED NOT NULL,
- `price` INT(10) UNSIGNED NOT NULL
- ) ENGINE=MyISAM;
- CREATE TABLE IF NOT EXISTS `buyingstores` (
- `id` INT(10) UNSIGNED NOT NULL,
- `account_id` INT(11) UNSIGNED NOT NULL,
- `char_id` INT(10) UNSIGNED NOT NULL,
- `sex` enum('F','M') NOT NULL DEFAULT 'M',
- `map` VARCHAR(20) NOT NULL,
- `x` SMALLINT(5) UNSIGNED NOT NULL,
- `y` SMALLINT(5) UNSIGNED NOT NULL,
- `title` VARCHAR(80) NOT NULL,
- `limit` INT(10) UNSIGNED NOT NULL,
- `body_direction` CHAR( 1 ) NOT NULL DEFAULT '4',
- `head_direction` CHAR( 1 ) NOT NULL DEFAULT '0',
- `sit` CHAR( 1 ) NOT NULL DEFAULT '1',
- `autotrade` tinyint(4) NOT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=MyISAM;
- -- Adições do eAMod --
- ALTER TABLE `char` ADD COLUMN `playtime` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0';
- ALTER TABLE `login` ADD COLUMN `ipallow` VARCHAR(20) NOT NULL DEFAULT '*.*.*.*';
- ALTER TABLE `login` ADD COLUMN `member_id` INT(11) UNSIGNED NOT NULL DEFAULT '0';
- DROP TABLE IF EXISTS `char_pk`;
- CREATE TABLE `char_pk` (
- `char_id` INT(11) NOT NULL,
- `kill_count` INT(11) NOT NULL DEFAULT '0',
- `death_count` INT(11) NOT NULL DEFAULT '0',
- `score` INT(11) NOT NULL DEFAULT '0',
- PRIMARY KEY (`char_id`)
- ) ENGINE=InnoDB;
- DROP TABLE IF EXISTS `char_pvp`;
- CREATE TABLE `char_pvp` (
- `char_id` INT(11) NOT NULL,
- `kill_count` INT(11) NOT NULL DEFAULT '0',
- `death_count` INT(11) NOT NULL DEFAULT '0',
- `score` INT(11) NOT NULL DEFAULT '0',
- PRIMARY KEY (`char_id`)
- ) ENGINE=InnoDB;
- DROP TABLE IF EXISTS `guild_rank`;
- CREATE TABLE `guild_rank` (
- `guild_id` INT(11) NOT NULL,
- `castle_id` INT(11) NOT NULL,
- `capture` INT(11) UNSIGNED NOT NULL DEFAULT '0',
- `emperium` INT(11) UNSIGNED NOT NULL DEFAULT '0',
- `treasure` INT(11) UNSIGNED NOT NULL DEFAULT '0',
- `top_eco` INT(11) UNSIGNED NOT NULL DEFAULT '0',
- `top_def` INT(11) UNSIGNED NOT NULL DEFAULT '0',
- `invest_eco` INT(11) UNSIGNED NOT NULL DEFAULT '0',
- `invest_def` INT(11) UNSIGNED NOT NULL DEFAULT '0',
- `offensive_score` INT(11) UNSIGNED NOT NULL DEFAULT '0',
- `defensive_score` INT(11) UNSIGNED NOT NULL DEFAULT '0',
- `posesion_time` INT(11) UNSIGNED NOT NULL DEFAULT '0',
- `zeny_eco` INT(11) UNSIGNED NOT NULL DEFAULT '0',
- `zeny_def` INT(11) UNSIGNED NOT NULL DEFAULT '0',
- `skill_battleorder` INT(11) UNSIGNED NOT NULL DEFAULT '0',
- `skill_regeneration` INT(11) UNSIGNED NOT NULL DEFAULT '0',
- `skill_restore` INT(11) UNSIGNED NOT NULL DEFAULT '0',
- `skill_emergencycall` INT(11) UNSIGNED NOT NULL DEFAULT '0',
- `off_kill` INT(11) UNSIGNED NOT NULL DEFAULT '0',
- `off_death` INT(11) UNSIGNED NOT NULL DEFAULT '0',
- `def_kill` INT(11) UNSIGNED NOT NULL DEFAULT '0',
- `def_death` INT(11) UNSIGNED NOT NULL DEFAULT '0',
- `ext_kill` INT(11) UNSIGNED NOT NULL DEFAULT '0',
- `ext_death` INT(11) UNSIGNED NOT NULL DEFAULT '0',
- `ali_kill` INT(11) UNSIGNED NOT NULL DEFAULT '0',
- `ali_death` INT(11) UNSIGNED NOT NULL DEFAULT '0',
- PRIMARY KEY (`guild_id`,`castle_id`),
- KEY `castle_id` (`castle_id`)
- ) ENGINE=InnoDB;
- DROP TABLE IF EXISTS `ippremium`;
- CREATE TABLE `ippremium` (
- `ip` VARCHAR(30) NOT NULL,
- `level` tinyint(2) DEFAULT '0',
- PRIMARY KEY (`ip`)
- ) ENGINE=InnoDB;
- DROP TABLE IF EXISTS `members`;
- CREATE TABLE `members` (
- `member_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
- `nombre` VARCHAR(50) NOT NULL DEFAULT '',
- `email` VARCHAR(39) NOT NULL DEFAULT '',
- `sexo` enum('M','F') NOT NULL DEFAULT 'M',
- `pais` VARCHAR(20) NOT NULL DEFAULT '',
- `msn` VARCHAR(39) NOT NULL DEFAULT '',
- `icq` VARCHAR(15) NOT NULL DEFAULT '',
- `mpass` VARCHAR(40) NOT NULL DEFAULT '',
- `last_ip` VARCHAR(20) NOT NULL DEFAULT '0.0.0.0',
- `last_login` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
- `acc_balance` INT(10) UNSIGNED NOT NULL DEFAULT '0',
- `services` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
- `banned` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
- `ref_option` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
- `ref_email` VARCHAR(39) NOT NULL DEFAULT 'none',
- `ref_points` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
- `mlevel` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
- PRIMARY KEY (`member_id`)
- ) ENGINE=InnoDB;
- DROP TABLE IF EXISTS `rentstorage`;
- CREATE TABLE `rentstorage` (
- `id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
- `account_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
- `nameid` INT(11) UNSIGNED NOT NULL DEFAULT '0',
- `amount` SMALLINT(11) UNSIGNED NOT NULL DEFAULT '0',
- `equip` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
- `identify` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
- `refine` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
- `attribute` tinyint(4) UNSIGNED NOT NULL DEFAULT '0',
- `card0` SMALLINT(11) NOT NULL DEFAULT '0',
- `card1` SMALLINT(11) NOT NULL DEFAULT '0',
- `card2` SMALLINT(11) NOT NULL DEFAULT '0',
- `card3` SMALLINT(11) NOT NULL DEFAULT '0',
- `expire_time` INT(11) UNSIGNED NOT NULL DEFAULT '0',
- `serial` INT(11) UNSIGNED NOT NULL DEFAULT '0',
- `bound` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
- PRIMARY KEY (`id`),
- KEY `account_id` (`account_id`)
- ) ENGINE=InnoDB;
- CREATE TABLE IF NOT EXISTS `skillcooldown` (
- `account_id` INT(11) UNSIGNED NOT NULL,
- `char_id` INT(11) UNSIGNED NOT NULL,
- `skill` SMALLINT(11) UNSIGNED NOT NULL DEFAULT '0',
- `tick` INT(11) NOT NULL,
- KEY (`account_id`),
- KEY (`char_id`)
- ) ENGINE=InnoDB;
- ALTER TABLE `inventory` ADD COLUMN `bound` tinyint(1) UNSIGNED NOT NULL DEFAULT '0';
- ALTER TABLE `cart_inventory` ADD COLUMN `bound` tinyint(1) UNSIGNED NOT NULL DEFAULT '0';
- ALTER TABLE `storage` ADD COLUMN `bound` tinyint(1) UNSIGNED NOT NULL DEFAULT '0';
- ALTER TABLE `guild_storage` ADD COLUMN `bound` tinyint(1) UNSIGNED NOT NULL DEFAULT '0';
- DROP TABLE IF EXISTS `item_serials`;
- CREATE TABLE `item_serials` (
- `nameid` SMALLINT(5) UNSIGNED NOT NULL,
- `serial` INT(11) UNSIGNED NOT NULL DEFAULT '0',
- PRIMARY KEY (`nameid`)
- ) ENGINE=InnoDB;
- ALTER TABLE `auction` ADD COLUMN `serial` INT(11) UNSIGNED NOT NULL DEFAULT '0';
- ALTER TABLE `cart_inventory` ADD COLUMN `serial` INT(11) UNSIGNED NOT NULL DEFAULT '0';
- ALTER TABLE `guild_storage` ADD COLUMN `serial` INT(11) UNSIGNED NOT NULL DEFAULT '0';
- ALTER TABLE `inventory` ADD COLUMN `serial` INT(11) UNSIGNED NOT NULL DEFAULT '0';
- ALTER TABLE `mail` ADD COLUMN `serial` INT(11) UNSIGNED NOT NULL DEFAULT '0';
- ALTER TABLE `storage` ADD COLUMN `serial` INT(11) UNSIGNED NOT NULL DEFAULT '0';
- DROP TABLE IF EXISTS `char_bg`;
- CREATE TABLE `char_bg` (
- `char_id` INT(11) NOT NULL,
- `top_damage` INT(11) NOT NULL DEFAULT '0',
- `damage_done` INT(11) NOT NULL DEFAULT '0',
- `damage_received` INT(11) NOT NULL DEFAULT '0',
- `skulls` INT(11) NOT NULL DEFAULT '0',
- `ti_wins` INT(11) NOT NULL DEFAULT '0',
- `ti_lost` INT(11) NOT NULL DEFAULT '0',
- `ti_tie` INT(11) NOT NULL DEFAULT '0',
- `eos_flags` INT(11) NOT NULL DEFAULT '0',
- `eos_bases` INT(11) NOT NULL DEFAULT '0',
- `eos_wins` INT(11) NOT NULL DEFAULT '0',
- `eos_lost` INT(11) NOT NULL DEFAULT '0',
- `eos_tie` INT(11) NOT NULL DEFAULT '0',
- `boss_killed` INT(11) NOT NULL DEFAULT '0',
- `boss_damage` INT(11) NOT NULL DEFAULT '0',
- `boss_flags` INT(11) NOT NULL DEFAULT '0',
- `boss_wins` INT(11) NOT NULL DEFAULT '0',
- `boss_lost` INT(11) NOT NULL DEFAULT '0',
- `boss_tie` INT(11) NOT NULL DEFAULT '0',
- `td_kills` INT(11) NOT NULL DEFAULT '0',
- `td_deaths` INT(11) NOT NULL DEFAULT '0',
- `td_wins` INT(11) NOT NULL DEFAULT '0',
- `td_lost` INT(11) NOT NULL DEFAULT '0',
- `td_tie` INT(11) NOT NULL DEFAULT '0',
- `sc_stole` INT(11) NOT NULL DEFAULT '0',
- `sc_captured` INT(11) NOT NULL DEFAULT '0',
- `sc_droped` INT(11) NOT NULL DEFAULT '0',
- `sc_wins` INT(11) NOT NULL DEFAULT '0',
- `sc_lost` INT(11) NOT NULL DEFAULT '0',
- `sc_tie` INT(11) NOT NULL DEFAULT '0',
- `ctf_taken` INT(11) NOT NULL DEFAULT '0',
- `ctf_captured` INT(11) NOT NULL DEFAULT '0',
- `ctf_droped` INT(11) NOT NULL DEFAULT '0',
- `ctf_wins` INT(11) NOT NULL DEFAULT '0',
- `ctf_lost` INT(11) NOT NULL DEFAULT '0',
- `ctf_tie` INT(11) NOT NULL DEFAULT '0',
- `emperium_kill` INT(11) NOT NULL DEFAULT '0',
- `barricade_kill` INT(11) NOT NULL DEFAULT '0',
- `gstone_kill` INT(11) NOT NULL DEFAULT '0',
- `cq_wins` INT(11) NOT NULL DEFAULT '0',
- `cq_lost` INT(11) NOT NULL DEFAULT '0',
- `kill_count` INT(11) NOT NULL DEFAULT '0',
- `death_count` INT(11) NOT NULL DEFAULT '0',
- `win` INT(11) NOT NULL DEFAULT '0',
- `lost` INT(11) NOT NULL DEFAULT '0',
- `tie` INT(11) NOT NULL DEFAULT '0',
- `leader_win` INT(11) NOT NULL DEFAULT '0',
- `leader_lost` INT(11) NOT NULL DEFAULT '0',
- `leader_tie` INT(11) NOT NULL DEFAULT '0',
- `deserter` INT(11) NOT NULL DEFAULT '0',
- `score` INT(11) NOT NULL DEFAULT '0',
- `points` INT(11) NOT NULL DEFAULT '0',
- `sp_heal_potions` INT(11) NOT NULL DEFAULT '0',
- `hp_heal_potions` INT(11) NOT NULL DEFAULT '0',
- `yellow_gemstones` INT(11) NOT NULL DEFAULT '0',
- `red_gemstones` INT(11) NOT NULL DEFAULT '0',
- `blue_gemstones` INT(11) NOT NULL DEFAULT '0',
- `poison_bottles` INT(11) NOT NULL DEFAULT '0',
- `acid_demostration` INT(11) NOT NULL DEFAULT '0',
- `acid_demostration_fail` INT(11) NOT NULL DEFAULT '0',
- `support_skills_used` INT(11) NOT NULL DEFAULT '0',
- `healing_done` INT(11) NOT NULL DEFAULT '0',
- `wrong_support_skills_used` INT(11) NOT NULL DEFAULT '0',
- `wrong_healing_done` INT(11) NOT NULL DEFAULT '0',
- `sp_used` INT(11) NOT NULL DEFAULT '0',
- `zeny_used` INT(11) NOT NULL DEFAULT '0',
- `spiritb_used` INT(11) NOT NULL DEFAULT '0',
- `ammo_used` INT(11) NOT NULL DEFAULT '0',
- `rank_points` INT(11) NOT NULL DEFAULT '0',
- `rank_games` INT(11) NOT NULL DEFAULT '0',
- `ru_captures` INT(11) NOT NULL DEFAULT '0',
- `ru_wins` INT(11) NOT NULL DEFAULT '0',
- `ru_lost` INT(11) NOT NULL DEFAULT '0',
- PRIMARY KEY (`char_id`)
- ) ENGINE=InnoDB;
- ALTER TABLE `char` ADD COLUMN `bg_gold` INT(11) NOT NULL DEFAULT '0';
- ALTER TABLE `char` ADD COLUMN `bg_silver` INT(11) NOT NULL DEFAULT '0';
- ALTER TABLE `char` ADD COLUMN `bg_bronze` INT(11) NOT NULL DEFAULT '0';
- DROP TABLE IF EXISTS `char_bg_log`;
- CREATE TABLE `char_bg_log` (
- `id` INT(11) NOT NULL AUTO_INCREMENT,
- `time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
- `killer` VARCHAR(25) NOT NULL,
- `killer_id` INT(11) NOT NULL,
- `killed` VARCHAR(25) NOT NULL,
- `killed_id` INT(11) NOT NULL,
- `map` VARCHAR(11) NOT NULL DEFAULT '',
- `skill` INT(11) NOT NULL DEFAULT '0',
- PRIMARY KEY (`id`),
- KEY `killer_id` (`killer_id`),
- KEY `killed_id` (`killed_id`)
- ) ENGINE=MyISAM;
- DROP TABLE IF EXISTS `char_woe_log`;
- CREATE TABLE `char_woe_log` (
- `id` INT(11) NOT NULL AUTO_INCREMENT,
- `time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
- `killer` VARCHAR(25) NOT NULL,
- `killer_id` INT(11) NOT NULL,
- `killed` VARCHAR(25) NOT NULL,
- `killed_id` INT(11) NOT NULL,
- `map` VARCHAR(11) NOT NULL DEFAULT '',
- `skill` INT(11) NOT NULL DEFAULT '0',
- PRIMARY KEY (`id`),
- KEY `killer_id` (`killer_id`),
- KEY `killed_id` (`killed_id`)
- ) ENGINE=MyISAM;
- DROP TABLE IF EXISTS `char_woe`;
- DROP TABLE IF EXISTS `char_wstats`;
- CREATE TABLE `char_wstats` (
- `char_id` INT(11) NOT NULL,
- `kill_count` INT(11) NOT NULL DEFAULT '0',
- `death_count` INT(11) NOT NULL DEFAULT '0',
- `score` INT(11) NOT NULL DEFAULT '0',
- `top_damage` INT(11) NOT NULL DEFAULT '0',
- `damage_done` INT(11) NOT NULL DEFAULT '0',
- `damage_received` INT(11) NOT NULL DEFAULT '0',
- `emperium_damage` INT(11) NOT NULL DEFAULT '0',
- `guardian_damage` INT(11) NOT NULL DEFAULT '0',
- `barricade_damage` INT(11) NOT NULL DEFAULT '0',
- `gstone_damage` INT(11) NOT NULL DEFAULT '0',
- `emperium_kill` INT(11) NOT NULL DEFAULT '0',
- `guardian_kill` INT(11) NOT NULL DEFAULT '0',
- `barricade_kill` INT(11) NOT NULL DEFAULT '0',
- `gstone_kill` INT(11) NOT NULL DEFAULT '0',
- `sp_heal_potions` INT(11) NOT NULL DEFAULT '0',
- `hp_heal_potions` INT(11) NOT NULL DEFAULT '0',
- `yellow_gemstones` INT(11) NOT NULL DEFAULT '0',
- `red_gemstones` INT(11) NOT NULL DEFAULT '0',
- `blue_gemstones` INT(11) NOT NULL DEFAULT '0',
- `poison_bottles` INT(11) NOT NULL DEFAULT '0',
- `acid_demostration` INT(11) NOT NULL DEFAULT '0',
- `acid_demostration_fail` INT(11) NOT NULL DEFAULT '0',
- `support_skills_used` INT(11) NOT NULL DEFAULT '0',
- `healing_done` INT(11) NOT NULL DEFAULT '0',
- `wrong_support_skills_used` INT(11) NOT NULL DEFAULT '0',
- `wrong_healing_done` INT(11) NOT NULL DEFAULT '0',
- `sp_used` INT(11) NOT NULL DEFAULT '0',
- `zeny_used` INT(11) NOT NULL DEFAULT '0',
- `spiritb_used` INT(11) NOT NULL DEFAULT '0',
- `ammo_used` INT(11) NOT NULL DEFAULT '0',
- PRIMARY KEY (`char_id`)
- ) ENGINE=InnoDB;
- DROP TABLE IF EXISTS `skill_count`;
- CREATE TABLE `skill_count` (
- `char_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
- `id` SMALLINT(11) UNSIGNED NOT NULL DEFAULT '0',
- `count` INT(11) UNSIGNED NOT NULL DEFAULT '0',
- PRIMARY KEY (`char_id`,`id`),
- KEY `char_id` (`char_id`)
- ) ENGINE=InnoDB;
- DROP TABLE IF EXISTS `bg_skill_count`;
- CREATE TABLE `bg_skill_count` (
- `char_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
- `id` SMALLINT(11) UNSIGNED NOT NULL DEFAULT '0',
- `count` INT(11) UNSIGNED NOT NULL DEFAULT '0',
- PRIMARY KEY (`char_id`,`id`),
- KEY `char_id` (`char_id`)
- ) ENGINE=InnoDB;
- DROP TABLE IF EXISTS `achievement`;
- CREATE TABLE `achievement` (
- `id` INT(11) NOT NULL,
- `char_id` INT(11) NOT NULL,
- `completed` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
- `count1` INT(11) UNSIGNED NOT NULL DEFAULT '0',
- `count2` INT(11) UNSIGNED NOT NULL DEFAULT '0',
- `count3` INT(11) UNSIGNED NOT NULL DEFAULT '0',
- `count4` INT(11) UNSIGNED NOT NULL DEFAULT '0',
- `count5` INT(11) UNSIGNED NOT NULL DEFAULT '0',
- PRIMARY KEY (`char_id`,`id`)
- ) ENGINE=InnoDB;
- ALTER TABLE `char_bg` ADD COLUMN `dom_bases` INT(11) NOT NULL DEFAULT '0' AFTER `boss_tie`,
- ADD COLUMN `dom_off_kills` INT(11) NOT NULL DEFAULT '0' AFTER `dom_bases`,
- ADD COLUMN `dom_def_kills` INT(11) NOT NULL DEFAULT '0' AFTER `dom_off_kills`,
- ADD COLUMN `dom_wins` INT(11) NOT NULL DEFAULT '0' AFTER `dom_def_kills`,
- ADD COLUMN `dom_lost` INT(11) NOT NULL DEFAULT '0' AFTER `dom_wins`,
- ADD COLUMN `dom_tie` INT(11) NOT NULL DEFAULT '0' AFTER `dom_lost`;
- ALTER TABLE `char` ADD COLUMN `faction_id` INT(11) NOT NULL DEFAULT '0' AFTER `elemental_id`;
- ALTER TABLE `cart_inventory` ADD COLUMN `favorite` tinyint(1) UNSIGNED NOT NULL DEFAULT '0';
- ALTER TABLE `storage` ADD COLUMN `favorite` tinyint(1) UNSIGNED NOT NULL DEFAULT '0';
- ALTER TABLE `rentstorage` ADD COLUMN `favorite` tinyint(1) UNSIGNED NOT NULL DEFAULT '0';
- ALTER TABLE `guild_storage` ADD COLUMN `favorite` tinyint(1) UNSIGNED NOT NULL DEFAULT '0';
- DROP TABLE IF EXISTS `item_serials`;
- ALTER TABLE `auction` DROP COLUMN `serial`;
- ALTER TABLE `cart_inventory` DROP COLUMN `serial`;
- ALTER TABLE `guild_storage` DROP COLUMN `serial`;
- ALTER TABLE `inventory` DROP COLUMN `serial`;
- ALTER TABLE `mail` DROP COLUMN `serial`;
- ALTER TABLE `storage` DROP COLUMN `serial`;
- ALTER TABLE `rentstorage` DROP COLUMN `serial`;
- ALTER TABLE `rentstorage` ADD `unique_id` BIGINT( 20 ) NOT NULL DEFAULT '0';
- -- Update para valores negativos de card0 --
- UPDATE `auction` SET `card0` = 256 WHERE `card0` = -256;
- UPDATE `cart_inventory` SET `card0` = 256 WHERE `card0` = -256;
- UPDATE `guild_storage` SET `card0` = 256 WHERE `card0` = -256;
- UPDATE `inventory` SET `card0` = 256 WHERE `card0` = -256;
- UPDATE `mail` SET `card0` = 256 WHERE `card0` = -256;
- UPDATE `storage` SET `card0` = 256 WHERE `card0` = -256;
- -- Setando valores de último login para valor indefinido --
- UPDATE `login` SET `lastlogin` = NULL WHERE `lastlogin` IS NOT NULL
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement