<?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 (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";
 
?>