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 `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 mail --
- ALTER TABLE `mail` ADD `option_id0` smallint(5) unsigned NOT NULL default '0' AFTER `card3`;
- ALTER TABLE `mail` ADD `option_val0` smallint(5) unsigned NOT NULL default '0' AFTER `option_id0`;
- ALTER TABLE `mail` ADD `option_param0` tinyint(3) unsigned NOT NULL default '0' AFTER `option_val0`;
- ALTER TABLE `mail` ADD `option_id1` smallint(5) unsigned NOT NULL default '0' AFTER `option_param0`;
- ALTER TABLE `mail` ADD `option_val1` smallint(5) unsigned NOT NULL default '0' AFTER `option_id1`;
- ALTER TABLE `mail` ADD `option_param1` tinyint(3) unsigned NOT NULL default '0' AFTER `option_val1`;
- ALTER TABLE `mail` ADD `option_id2` smallint(5) unsigned NOT NULL default '0' AFTER `option_param1`;
- ALTER TABLE `mail` ADD `option_val2` smallint(5) unsigned NOT NULL default '0' AFTER `option_id2`;
- ALTER TABLE `mail` ADD `option_param2` tinyint(3) unsigned NOT NULL default '0' AFTER `option_val2`;
- ALTER TABLE `mail` ADD `option_id3` smallint(5) unsigned NOT NULL default '0' AFTER `option_param2`;
- ALTER TABLE `mail` ADD `option_val3` smallint(5) unsigned NOT NULL default '0' AFTER `option_id3`;
- ALTER TABLE `mail` ADD `option_param3` tinyint(3) unsigned NOT NULL default '0' AFTER `option_val3`;
- ALTER TABLE `mail` ADD `option_id4` smallint(5) unsigned NOT NULL default '0' AFTER `option_param3`;
- ALTER TABLE `mail` ADD `option_val4` smallint(5) unsigned NOT NULL default '0' AFTER `option_id4`;
- ALTER TABLE `mail` ADD `option_param4` tinyint(3) unsigned NOT NULL default '0' AFTER `option_val4`;
- ALTER TABLE `mail` ADD `bound` tinyint(1) unsigned NOT NULL default '0' AFTER `unique_id`;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement