*/
$_CLASS['core_db']->table_create('start', FORUMS_PRIVMSGS_TO_TABLE);
$_CLASS['core_db']->add_table_field_int('msg_id', array('max' => 16000000));
$_CLASS['core_db']->add_table_field_int('user_id', array('max' => 16000000));
$_CLASS['core_db']->add_table_field_int('author_id', array('max' => 16000000));
$_CLASS['core_db']->add_table_field_int('pm_deleted', array('max' => 1, 'null' => true));
$_CLASS['core_db']->add_table_field_int('pm_new', array('max' => 1));
$_CLASS['core_db']->add_table_field_int('pm_unread', array('max' => 1));
$_CLASS['core_db']->add_table_field_int('pm_replied', array('max' => 1, 'null' => true));
$_CLASS['core_db']->add_table_field_int('pm_marked', array('max' => 1, 'null' => true));
$_CLASS['core_db']->add_table_field_int('pm_forwarded', array('max' => 1, 'null' => true));
$_CLASS['core_db']->add_table_field_int('folder_id', array('min' => -10, 'max' => 16000000));
$_CLASS['core_db']->add_table_index('msg_id');
$_CLASS['core_db']->add_table_index('author_id');
$_CLASS['core_db']->add_table_index(array('user_id', 'folder_id'));
$_CLASS['core_db']->table_create('commit');
$_CLASS['core_db']->table_create('start', FORUMS_SITELIST_TABLE);
$_CLASS['core_db']->add_table_field_int('site_id', array('max' => 16000000, 'auto_increment' => true));
$_CLASS['core_db']->add_table_field_char('site_ip', 40);
$_CLASS['core_db']->add_table_field_char('site_hostname', 255);
$_CLASS['core_db']->add_table_field_int('ip_exclude', array('max' => 1));
$_CLASS['core_db']->add_table_index('site_id', 'primary');
$_CLASS['core_db']->table_create('commit');
$_CLASS['core_db']->table_create('start', FORUMS_SEARCH_TABLE);
$_CLASS['core_db']->add_table_field_int('search_id', array('max' => 16000000));
$_CLASS['core_db']->add_table_field_char('session_id', 40);
field_unix_time('search_time', true);
$_CLASS['core_db']->add_table_field_text('search_array', 16000000);
$_CLASS['core_db']->add_table_index('search_id', 'primary');
$_CLASS['core_db']->add_table_index('session_id');
$_CLASS['core_db']->table_create('commit');
field_unix_time('message_time');
$_CLASS['core_db']->add_table_field_int('message_reported', array('max' => 1, 'null' => true));
$_CLASS['core_db']->add_table_field_int('enable_bbcode', array('max' => 1));
$_CLASS['core_db']->add_table_field_int('enable_html', array('max' => 1));
$_CLASS['core_db']->add_table_field_int('enable_smilies', array('max' => 1));
$_CLASS['core_db']->add_table_field_int('enable_magic_url', array('max' => 1));
$_CLASS['core_db']->add_table_field_int('enable_sig', array('max' => 1));
$_CLASS['core_db']->add_table_field_char('message_subject', 60);
$_CLASS['core_db']->add_table_field_text('message_text', 10000000);
$_CLASS['core_db']->add_table_field_char('message_edit_reason', 100, true);
$_CLASS['core_db']->add_table_field_int('message_edit_user', array('max' => 16000000, 'null' => true));
$_CLASS['core_db']->add_table_field_char('message_checksum', 11);
$_CLASS['core_db']->add_table_field_int('message_attachment', array('max' => 1));
$_CLASS['core_db']->add_table_field_int('bbcode_bitfield', 1000000000);
$_CLASS['core_db']->add_table_field_char('bbcode_uid', 5);
field_unix_time('message_edit_time', true);
$_CLASS['core_db']->add_table_field_int('message_edit_count', array('max' => 200, 'null' => true));
$_CLASS['core_db']->add_table_field_text('to_address', 1000000);
$_CLASS['core_db']->add_table_field_text('bcc_address', 1000000);
$_CLASS['core_db']->add_table_index('msg_id', 'primary');
$_CLASS['core_db']->add_table_index('author_ip');
$_CLASS['core_db']->add_table_index('message_time');
$_CLASS['core_db']->add_table_index('author_id');
$_CLASS['core_db']->add_table_index('root_level');
$_CLASS['core_db']->table_create('commit');
/*
Forums Log Table
*/
$_CLASS['core_db']->table_create('start', $table_prefix . 'forums_privmsgs_folder');
$_CLASS['core_db']->add_table_field_int('folder_id', array('max' => 16000000, 'auto_increment' => true));
$_CLASS['core_db']->add_table_field_int('user_id', array('max' => 16000000));