Advertisement
Guest User

Untitled

a guest
Mar 27th, 2017
57
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 2.18 KB | None | 0 0
  1. -- Alterações de nome de tabelas --
  2. RENAME TABLE `acc_reg_num_db` TO `acc_reg_num`
  3. RENAME TABLE `acc_reg_str_db` TO `acc_reg_str`
  4. RENAME TABLE `char_reg_num_db` TO `char_reg_num`
  5. RENAME TABLE `char_reg_str_db` TO `acc_reg_str`
  6.  
  7. -- Alterações de adaptação da tabela char --
  8. ALTER TABLE `char` ADD `moves` INT(11) UNSIGNED NOT NULL DEFAULT '0' AFTER `delete_date`;
  9. ALTER TABLE `char` DROP COLUMN `slotchange`;
  10. ALTER TABLE `char` DROP COLUMN `char_opt`;
  11. ALTER TABLE `char` MODIFY `font` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0' AFTER `unban_time`;
  12.  
  13. -- Alterações de adaptação da tabela mail --
  14. ALTER TABLE `mail` ADD `option_id0` smallint(5) unsigned NOT NULL default '0' AFTER `card3`;
  15. ALTER TABLE `mail` ADD `option_val0` smallint(5) unsigned NOT NULL default '0' AFTER `option_id0`;
  16. ALTER TABLE `mail` ADD `option_param0` tinyint(3) unsigned NOT NULL default '0' AFTER `option_val0`;
  17.  
  18. ALTER TABLE `mail` ADD `option_id1` smallint(5) unsigned NOT NULL default '0' AFTER `option_param0`;
  19. ALTER TABLE `mail` ADD `option_val1` smallint(5) unsigned NOT NULL default '0' AFTER `option_id1`;
  20. ALTER TABLE `mail` ADD `option_param1` tinyint(3) unsigned NOT NULL default '0' AFTER `option_val1`;
  21.  
  22. ALTER TABLE `mail` ADD `option_id2` smallint(5) unsigned NOT NULL default '0' AFTER `option_param1`;
  23. ALTER TABLE `mail` ADD `option_val2` smallint(5) unsigned NOT NULL default '0' AFTER `option_id2`;
  24. ALTER TABLE `mail` ADD `option_param2` tinyint(3) unsigned NOT NULL default '0' AFTER `option_val2`;
  25.  
  26. ALTER TABLE `mail` ADD `option_id3` smallint(5) unsigned NOT NULL default '0' AFTER `option_param2`;
  27. ALTER TABLE `mail` ADD `option_val3` smallint(5) unsigned NOT NULL default '0' AFTER `option_id3`;
  28. ALTER TABLE `mail` ADD `option_param3` tinyint(3) unsigned NOT NULL default '0' AFTER `option_val3`;
  29.  
  30. ALTER TABLE `mail` ADD `option_id4` smallint(5) unsigned NOT NULL default '0' AFTER `option_param3`;
  31. ALTER TABLE `mail` ADD `option_val4` smallint(5) unsigned NOT NULL default '0' AFTER `option_id4`;
  32. ALTER TABLE `mail` ADD `option_param4` tinyint(3) unsigned NOT NULL default '0' AFTER `option_val4`;
  33.  
  34. 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