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 "

Done

\n";