Página inicial Explorar Ajuda
Entrar
oversu
/
fRO_french_translation_rAthena
1
0
Fork 0
Arquivos Issues 0 Pull Requests 0 Wiki
Branch: Small_cleanup
Branches Tags
fRO_french_tran...
/
sql-files
/
upgrades
/
upgrade_20131231.sql

upgrade_20131231.sql 4.4 KB
Link permanente Histórico Raw

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950 
  1. ALTER TABLE `item_db` CHANGE `type` `type` TINYINT( 2 ) UNSIGNED NOT NULL DEFAULT '0';
    2. 

  2. ALTER TABLE `item_db` CHANGE `price_buy` `price_buy` MEDIUMINT( 8 ) UNSIGNED NULL DEFAULT NULL;
    3. 

  3. ALTER TABLE `item_db` CHANGE `price_sell` `price_sell` MEDIUMINT( 8 ) UNSIGNED NULL DEFAULT NULL;
    4. 

  4. ALTER TABLE `item_db` CHANGE `weight` `weight` SMALLINT( 5 ) UNSIGNED NOT NULL DEFAULT '0';
    5. 

  5. ALTER TABLE `item_db` CHANGE `attack` `attack` SMALLINT( 5 ) UNSIGNED NULL DEFAULT NULL;
    6. 

  6. ALTER TABLE `item_db` CHANGE `defence` `defence` SMALLINT( 5 ) UNSIGNED NULL DEFAULT NULL;
    7. 

  7. ALTER TABLE `item_db` CHANGE `range` `range` TINYINT( 2 ) UNSIGNED NULL DEFAULT NULL;
    8. 

  8. ALTER TABLE `item_db` CHANGE `slots` `slots` TINYINT( 2 ) UNSIGNED NULL DEFAULT NULL;
    9. 

  9. ALTER TABLE `item_db` CHANGE `equip_jobs` `equip_jobs` INT( 10 ) UNSIGNED NULL DEFAULT NULL;
    10. 

  10. ALTER TABLE `item_db` CHANGE `equip_upper` `equip_upper` TINYINT( 2 ) UNSIGNED NULL DEFAULT NULL;
    11. 

  11. ALTER TABLE `item_db` CHANGE `equip_genders` `equip_genders` TINYINT( 1 ) UNSIGNED NULL DEFAULT NULL;
    12. 

  12. ALTER TABLE `item_db` CHANGE `equip_locations` `equip_locations` MEDIUMINT( 7 ) UNSIGNED NULL DEFAULT NULL;
    13. 

  13. ALTER TABLE `item_db` CHANGE `weapon_level` `weapon_level` TINYINT( 1 ) UNSIGNED NULL DEFAULT NULL;
    14. 

  14. ALTER TABLE `item_db` CHANGE `equip_level` `equip_level` TINYINT( 3 ) NULL DEFAULT NULL;
    15. 

  15. ALTER TABLE `item_db` CHANGE `refineable` `refineable` TINYINT( 1 ) UNSIGNED NULL DEFAULT NULL;
    16. 

  16. ALTER TABLE `item_db` CHANGE `view` `view` SMALLINT( 5 ) UNSIGNED NULL DEFAULT NULL;
    17. 

  17. 

  18. ALTER TABLE `item_db2` CHANGE `type` `type` TINYINT( 2 ) UNSIGNED NOT NULL DEFAULT '0';
    19. 

  19. ALTER TABLE `item_db2` CHANGE `price_buy` `price_buy` MEDIUMINT( 8 ) UNSIGNED NULL DEFAULT NULL;
    20. 

  20. ALTER TABLE `item_db2` CHANGE `price_sell` `price_sell` MEDIUMINT( 8 ) UNSIGNED NULL DEFAULT NULL;
    21. 

  21. ALTER TABLE `item_db2` CHANGE `weight` `weight` SMALLINT( 5 ) UNSIGNED NOT NULL DEFAULT '0';
    22. 

  22. ALTER TABLE `item_db2` CHANGE `attack` `attack` SMALLINT( 5 ) UNSIGNED NULL DEFAULT NULL;
    23. 

  23. ALTER TABLE `item_db2` CHANGE `defence` `defence` SMALLINT( 5 ) UNSIGNED NULL DEFAULT NULL;
    24. 

  24. ALTER TABLE `item_db2` CHANGE `range` `range` TINYINT( 2 ) UNSIGNED NULL DEFAULT NULL;
    25. 

  25. ALTER TABLE `item_db2` CHANGE `slots` `slots` TINYINT( 2 ) UNSIGNED NULL DEFAULT NULL;
    26. 

  26. ALTER TABLE `item_db2` CHANGE `equip_jobs` `equip_jobs` INT( 10 ) UNSIGNED NULL DEFAULT NULL;
    27. 

  27. ALTER TABLE `item_db2` CHANGE `equip_upper` `equip_upper` TINYINT( 2 ) UNSIGNED NULL DEFAULT NULL;
    28. 

  28. ALTER TABLE `item_db2` CHANGE `equip_genders` `equip_genders` TINYINT( 1 ) UNSIGNED NULL DEFAULT NULL;
    29. 

  29. ALTER TABLE `item_db2` CHANGE `equip_locations` `equip_locations` MEDIUMINT( 7 ) UNSIGNED NULL DEFAULT NULL;
    30. 

  30. ALTER TABLE `item_db2` CHANGE `weapon_level` `weapon_level` TINYINT( 1 ) UNSIGNED NULL DEFAULT NULL;
    31. 

  31. ALTER TABLE `item_db2` CHANGE `equip_level` `equip_level` TINYINT( 3 ) NULL DEFAULT NULL;
    32. 

  32. ALTER TABLE `item_db2` CHANGE `refineable` `refineable` TINYINT( 1 ) UNSIGNED NULL DEFAULT NULL;
    33. 

  33. ALTER TABLE `item_db2` CHANGE `view` `view` SMALLINT( 5 ) UNSIGNED NULL DEFAULT NULL;
    34. 

  34. 

  35. ALTER TABLE `item_db_re` CHANGE `type` `type` TINYINT( 2 ) UNSIGNED NOT NULL DEFAULT '0';
    36. 

  36. ALTER TABLE `item_db_re` CHANGE `price_buy` `price_buy` MEDIUMINT( 8 ) UNSIGNED NULL DEFAULT NULL;
    37. 

  37. ALTER TABLE `item_db_re` CHANGE `price_sell` `price_sell` MEDIUMINT( 8 ) UNSIGNED NULL DEFAULT NULL;
    38. 

  38. ALTER TABLE `item_db_re` CHANGE `weight` `weight` SMALLINT( 5 ) UNSIGNED NOT NULL DEFAULT '0';
    39. 

  39. ALTER TABLE `item_db_re` CHANGE `atk:matk` `atk:matk` VARCHAR( 10 ) NULL DEFAULT NULL;
    40. 

  40. ALTER TABLE `item_db_re` CHANGE `defence` `defence` SMALLINT( 5 ) UNSIGNED NULL DEFAULT NULL;
    41. 

  41. ALTER TABLE `item_db_re` CHANGE `range` `range` TINYINT( 2 ) UNSIGNED NULL DEFAULT NULL;
    42. 

  42. ALTER TABLE `item_db_re` CHANGE `slots` `slots` TINYINT( 2 ) UNSIGNED NULL DEFAULT NULL;
    43. 

  43. ALTER TABLE `item_db_re` CHANGE `equip_jobs` `equip_jobs` INT( 10 ) UNSIGNED NULL DEFAULT NULL;
    44. 

  44. ALTER TABLE `item_db_re` CHANGE `equip_upper` `equip_upper` TINYINT( 2 ) UNSIGNED NULL DEFAULT NULL;
    45. 

  45. ALTER TABLE `item_db_re` CHANGE `equip_genders` `equip_genders` TINYINT( 1 ) UNSIGNED NULL DEFAULT NULL;
    46. 

  46. ALTER TABLE `item_db_re` CHANGE `equip_locations` `equip_locations` MEDIUMINT( 7 ) UNSIGNED NULL DEFAULT NULL;
    47. 

  47. ALTER TABLE `item_db_re` CHANGE `weapon_level` `weapon_level` TINYINT( 1 ) UNSIGNED NULL DEFAULT NULL;
    48. 

  48. ALTER TABLE `item_db_re` CHANGE `equip_level` `equip_level` VARCHAR( 10 ) NULL DEFAULT NULL;
    49. 

  49. ALTER TABLE `item_db_re` CHANGE `refineable` `refineable` TINYINT( 1 ) UNSIGNED NULL DEFAULT NULL;
    50. 

  50. ALTER TABLE `item_db_re` CHANGE `view` `view` SMALLINT( 5 ) UNSIGNED NULL DEFAULT NULL;
    51.