upgrade_2-1_mysql.sql 4.8 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139
  1. /* ATTENTION: You don't need to run or use this file! The upgrade.php script does everything for you! */
  2. /******************************************************************************/
  3. --- Adding new settings...
  4. /******************************************************************************/
  5. ---# Adding login history...
  6. CREATE TABLE IF NOT EXISTS {$db_prefix}member_logins (
  7. id_login int(10) NOT NULL auto_increment,
  8. id_member mediumint(8) NOT NULL,
  9. time int(10) NOT NULL,
  10. ip varchar(255) NOT NULL default '',
  11. ip2 varchar(255) NOT NULL default '',
  12. PRIMARY KEY id_login(id_login),
  13. KEY id_member (id_member),
  14. KEY time (time)
  15. ) ENGINE=MyISAM{$db_collation};
  16. ---#
  17. ---# Moving the cookie name to the database...
  18. ---{
  19. if (!isset($modSettings['cookie_name']))
  20. {
  21. if (empty($cookiename))
  22. $cookiename = 'SMFCookie11';
  23. upgrade_query("
  24. INSERT INTO {$db_prefix}settings
  25. (variable, value)
  26. VALUES
  27. ('cookie_name', '$cookiename')");
  28. }
  29. ---}
  30. ---#
  31. ---# Copying the current package backup setting...
  32. ---{
  33. if (!isset($modSettings['package_make_full_backups']) && isset($modSettings['package_make_backups']))
  34. upgrade_query("
  35. INSERT INTO {$db_prefix}settings
  36. (variable, value)
  37. VALUES
  38. ('package_make_full_backups', '" . $modSettings['package_make_backups'] . "')");
  39. ---}
  40. ---#
  41. /******************************************************************************/
  42. --- Updating legacy attachments...
  43. /******************************************************************************/
  44. ---# Converting legacy attachments.
  45. ---{
  46. $request = upgrade_query("
  47. SELECT MAX(id_attach)
  48. FROM {$db_prefix}attachments");
  49. list ($step_progress['total']) = $smcFunc['db_fetch_row']($request);
  50. $smcFunc['db_free_result']($request);
  51. $_GET['a'] = isset($_GET['a']) ? (int) $_GET['a'] : 0;
  52. $step_progress['name'] = 'Converting legacy attachments';
  53. $step_progress['current'] = $_GET['a'];
  54. // We may be using multiple attachment directories.
  55. if (!empty($modSettings['currentAttachmentUploadDir']) && !is_array($modSettings['attachmentUploadDir']))
  56. $modSettings['attachmentUploadDir'] = unserialize($modSettings['attachmentUploadDir']);
  57. $is_done = false;
  58. while (!$is_done)
  59. {
  60. nextSubStep($substep);
  61. $request = upgrade_query("
  62. SELECT id_attach, id_folder, filename, file_hash
  63. FROM {$db_prefix}attachments
  64. WHERE file_hash = ''
  65. LIMIT $_GET[a], 100");
  66. // Finished?
  67. if ($smcFunc['db_num_rows']($request) == 0)
  68. $is_done = true;
  69. while ($row = $smcFunc['db_fetch_assoc']($request))
  70. {
  71. // The current folder.
  72. $current_folder = !empty($modSettings['currentAttachmentUploadDir']) ? $modSettings['attachmentUploadDir'][$row['id_folder']] : $modSettings['attachmentUploadDir'];
  73. // The old location of the file.
  74. $old_location = getLegacyAttachmentFilename($row['filename'], $row['id_attach'], $row['id_folder']);
  75. // The new file name.
  76. $file_hash = getAttachmentFilename($row['filename'], $row['id_attach'], $row['id_folder'], true);
  77. // And we try to move it.
  78. rename($old_location, $current_folder . '/' . $row['id_attach'] . '_' . $file_hash);
  79. // Only update thif if it was successful.
  80. if (file_exists($current_folder . '/' . $row['id_attach'] . '_' . $file_hash) && !file_exists($old_location))
  81. upgrade_query("
  82. UPDATE {$db_prefix}attachments
  83. SET file_hash = '$file_hash'
  84. WHERE id_attach = $row[id_attach]");
  85. }
  86. $smcFunc['db_free_result']($request);
  87. $_GET['a'] += 100;
  88. $step_progress['current'] = $_GET['a'];
  89. }
  90. unset($_GET['a']);
  91. ---}
  92. ---#
  93. /******************************************************************************/
  94. --- Adding support for IPv6...
  95. /******************************************************************************/
  96. ---# Adding new columns to ban items...
  97. ALTER TABLE {$db_prefix}ban_items
  98. ADD COLUMN ip_low5 smallint(255) unsigned NOT NULL DEFAULT '0',
  99. ADD COLUMN ip_high5 smallint(255) unsigned NOT NULL DEFAULT '0',
  100. ADD COLUMN ip_low6 smallint(255) unsigned NOT NULL DEFAULT '0',
  101. ADD COLUMN ip_high6 smallint(255) unsigned NOT NULL DEFAULT '0',
  102. ADD COLUMN ip_low7 smallint(255) unsigned NOT NULL DEFAULT '0',
  103. ADD COLUMN ip_high7 smallint(255) unsigned NOT NULL DEFAULT '0',
  104. ADD COLUMN ip_low8 smallint(255) unsigned NOT NULL DEFAULT '0',
  105. ADD COLUMN ip_high8 smallint(255) unsigned NOT NULL DEFAULT '0';
  106. ---#
  107. ---# Changing existing columns to ban items...
  108. ALTER TABLE {$db_prefix}ban_items
  109. CHANGE ip_low1 ip_low1 tinyint(3) unsigned NOT NULL DEFAULT '0',
  110. CHANGE ip_high1 ip_high1 tinyint(3) unsigned NOT NULL DEFAULT '0',
  111. CHANGE ip_low2 ip_low2 tinyint(3) unsigned NOT NULL DEFAULT '0',
  112. CHANGE ip_high2 ip_high2 tinyint(3) unsigned NOT NULL DEFAULT '0',
  113. CHANGE ip_low3 ip_low3 tinyint(3) unsigned NOT NULL DEFAULT '0',
  114. CHANGE ip_high3 ip_high3 tinyint(3) unsigned NOT NULL DEFAULT '0',
  115. CHANGE ip_low4 ip_low4 tinyint(3) unsigned NOT NULL DEFAULT '0',
  116. CHANGE ip_high4 ip_high4 tinyint(3) unsigned NOT NULL DEFAULT '0';
  117. ---#