#!/bin/bash
$user = '';
$pass = '';
$olddb = '';
$newdb = '';
$charset = '';

mysql -u$user -p$pass -e "create database $newdb;";
for board in adv hr f o pol s4s sp trv tv tg x do
    mysql -u$user -p$pass -e "CREATE TABLE IF NOT EXISTS '%%BOARD%%' ('doc_id' int unsigned NOT NULL auto_increment, 'media_id' int unsigned NOT NULL DEFAULT '0', 'poster_ip' decimal(39,0) unsigned NOT NULL DEFAULT '0', 'num' int unsigned NOT NULL, 'subnum' int unsigned NOT NULL, 'thread_num' int unsigned NOT NULL DEFAULT '0', 'op' bool NOT NULL DEFAULT '0', 'timestamp' int unsigned NOT NULL, 'timestamp_expired' int unsigned NOT NULL, 'preview_orig' varchar(20), 'preview_w' smallint unsigned NOT NULL DEFAULT '0', 'preview_h' smallint unsigned NOT NULL DEFAULT '0', 'media_filename' text, 'media_w' smallint unsigned NOT NULL DEFAULT '0', 'media_h' smallint unsigned NOT NULL DEFAULT '0', 'media_size' int unsigned NOT NULL DEFAULT '0', 'media_hash' varchar(25), 'media_orig' varchar(20), 'spoiler' bool NOT NULL DEFAULT '0', 'deleted' bool NOT NULL DEFAULT '0', 'capcode' varchar(1) NOT NULL DEFAULT 'N', 'email' varchar(100), 'name' varchar(100), 'trip' varchar(25), 'title' varchar(100), 'comment' text, 'delpass' tinytext, 'sticky' bool NOT NULL DEFAULT '0', 'locked' bool NOT NULL DEFAULT '0', 'poster_hash' varchar(8), 'poster_country' varchar(2), 'exif' text, PRIMARY KEY ('doc_id'), UNIQUE num_subnum_index ('num', 'subnum'), INDEX thread_num_subnum_index ('thread_num', 'num', 'subnum'), INDEX subnum_index ('subnum'), INDEX op_index ('op'), INDEX media_id_index ('media_id'), INDEX media_hash_index ('media_hash'), INDEX media_orig_index ('media_orig'), INDEX name_trip_index ('name', 'trip'), INDEX trip_index ('trip'), INDEX email_index ('email'), INDEX poster_ip_index ('poster_ip'), INDEX timestamp_index ('timestamp')
) engine=InnoDB CHARSET=$charset;";
    mysql -u$user -p$pass -e "INSERT IGNORE INTO `$newdb`.`$board` (num, subnum, thread_num, op, timestamp, timestamp_expired, preview_orig, preview_w, preview_h, media_filename, media_w, media_h, media_size, media_hash, media_orig, spoiler, deleted, capcode, email, name, trip, title, comment, sticky, locked, poster_hash, poster_country, exif) SELECT num, subnum, thread_num, op, timestamp, timestamp_expired, preview_orig, preview_w, preview_h, media_filename, media_w, media_h, media_size, media_hash, media_orig, spoiler, deleted, capcode, email, name, trip, title, comment, sticky, locked, poster_hash, poster_country, exif FROM `$olddb`.`$board`;";
    mysqldump -u$user -p$pass $newdb $board > $board.sql;
done;