diff options
| author | Meik Sievertsen <acydburn@phpbb.com> | 2009-10-04 18:14:59 +0000 |
|---|---|---|
| committer | Meik Sievertsen <acydburn@phpbb.com> | 2009-10-04 18:14:59 +0000 |
| commit | 2e17e448deed073f8614bb555a8ef20c57291c2a (patch) | |
| tree | 533007e53d3584d0887b0f639d0e673b1e15ea7a /phpBB/develop/merge_attachment_tables.php | |
| parent | bf8ac19eaa8d74f9dfd6d597190f5664e7339382 (diff) | |
| download | forums-2e17e448deed073f8614bb555a8ef20c57291c2a.tar forums-2e17e448deed073f8614bb555a8ef20c57291c2a.tar.gz forums-2e17e448deed073f8614bb555a8ef20c57291c2a.tar.bz2 forums-2e17e448deed073f8614bb555a8ef20c57291c2a.tar.xz forums-2e17e448deed073f8614bb555a8ef20c57291c2a.zip | |
Copy 3.0.x branch to trunk
git-svn-id: file:///svn/phpbb/trunk@10211 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/develop/merge_attachment_tables.php')
| -rw-r--r-- | phpBB/develop/merge_attachment_tables.php | 80 |
1 files changed, 80 insertions, 0 deletions
diff --git a/phpBB/develop/merge_attachment_tables.php b/phpBB/develop/merge_attachment_tables.php new file mode 100644 index 0000000000..ae7fe57be4 --- /dev/null +++ b/phpBB/develop/merge_attachment_tables.php @@ -0,0 +1,80 @@ +<?php +// ------------------------------------------------------------- +// +// $Id$ +// +// FILENAME : merge_attachment_tables.php +// STARTED : Tue Nov 04, 2003 +// COPYRIGHT : � 2001, 2003 phpBB Group +// WWW : http://www.phpbb.com/ +// LICENCE : GPL vs2.0 [ see /docs/COPYING ] +// +// ------------------------------------------------------------- + +// +// Security message: +// +// This script is potentially dangerous. +// Remove or comment the next line (die(".... ) to enable this script. +// Do NOT FORGET to either remove this script or disable it after you have used it. +// +die("Please read the first lines of this script for instructions on how to enable it"); + +$db = $dbhost = $dbuser = $dbpasswd = $dbport = $dbname = ''; + +define('IN_PHPBB', 1); +define('ANONYMOUS', 1); +$phpEx = substr(strrchr(__FILE__, '.'), 1); +$phpbb_root_path='./../'; +include($phpbb_root_path . 'config.'.$phpEx); +require($phpbb_root_path . 'includes/acm/acm_' . $acm_type . '.'.$phpEx); +require($phpbb_root_path . 'includes/db/' . $dbms . '.'.$phpEx); +include($phpbb_root_path . 'includes/functions.'.$phpEx); + +$cache = new acm(); +$db = new sql_db(); + +// Connect to DB +$db->sql_connect($dbhost, $dbuser, $dbpasswd, $dbname, $dbport, false); + +// Rename the attachments table... +$sql = "RENAME TABLE {$table_prefix}attachments TO {$table_prefix}attach_temp"; +$db->sql_query($sql); + +$sql = "CREATE TABLE {$table_prefix}attachments + SELECT d.*, a.post_id, a.user_id_from as poster_id, p.topic_id + FROM {$table_prefix}attach_desc d, {$table_prefix}attach_temp a, {$table_prefix}posts p + WHERE a.attach_id = d.attach_id + AND a.post_id = p.post_id"; +$db->sql_query($sql); + +switch ($db->sql_layer) +{ + case 'mysql': + case 'mysql4': + $sql = 'ALTER TABLE ' . $table_prefix . 'attachments + ADD PRIMARY KEY (attach_id), + ADD INDEX filetime (filetime), + ADD INDEX post_id (post_id), + ADD INDEX poster_id (poster_id), + ADD INDEX physical_filename (physical_filename(10)), + ADD INDEX filesize (filesize), + ADD INDEX topic_id (topic_id), + MODIFY COLUMN attach_id mediumint(8) UNSIGNED NOT NULL auto_increment'; + break; + + case 'mssql': + case 'mssql-odbc': + case 'msaccess': + break; + + case 'postgresql': + break; +} +$db->sql_query($sql); + +//$db->sql_query("DROP TABLE {$table_prefix}attach_temp"); + +echo "<p><b>Done</b></p>\n"; + +?>
\ No newline at end of file |