case 'mysql':
		case 'mysqli':
			CREATE TABLE {{TABLE_PREFIX}}bans (
					id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
					username VARCHAR(200),
					ip VARCHAR(255),
					email VARCHAR(80),
					message VARCHAR(255),
					expire INT(10) UNSIGNED,
					ban_creator INT(10) UNSIGNED NOT NULL DEFAULT 0,
					PRIMARY KEY (id)
        ) ENGINE = MyISAM CHARACTER SET utf8
      
		case 'pgsql':
			CREATE TABLE {{TABLE_PREFIX}}bans (
					id SERIAL,
					username VARCHAR(200),
					ip VARCHAR(255),
					email VARCHAR(80),
					message VARCHAR(255),
					expire INT,
					ban_creator INT NOT NULL DEFAULT 0,
					PRIMARY KEY (id)
        )

    case 'mysql':
		case 'mysqli':
			CREATE TABLE {{TABLE_PREFIX}}categories (
					id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
					cat_name VARCHAR(80) NOT NULL DEFAULT 'New Category',
					disp_position INT(10) NOT NULL DEFAULT 0,
					PRIMARY KEY (id)
					) ENGINE = MyISAM CHARACTER SET utf8

		case 'pgsql':
			CREATE TABLE {{TABLE_PREFIX}}categories (
					id SERIAL,
					cat_name VARCHAR(80) NOT NULL DEFAULT 'New Category',
					disp_position INT NOT NULL DEFAULT 0,
					PRIMARY KEY (id)
					)

		case 'mysql':
		case 'mysqli':
			CREATE TABLE {{TABLE_PREFIX}}censoring (
					id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
					search_for VARCHAR(60) NOT NULL DEFAULT '',
					replace_with VARCHAR(60) NOT NULL DEFAULT '',
					PRIMARY KEY (id)
					) ENGINE = MyISAM CHARACTER SET utf8

		case 'pgsql':
			CREATE TABLE {{TABLE_PREFIX}}censoring (
					id SERIAL,
					search_for VARCHAR(60) NOT NULL DEFAULT '',
					replace_with VARCHAR(60) NOT NULL DEFAULT '',
					PRIMARY KEY (id)
					)

		case 'mysql':
		case 'mysqli':
			CREATE TABLE {{TABLE_PREFIX}}config (
					conf_name VARCHAR(255) NOT NULL DEFAULT '',
					conf_value TEXT,
					PRIMARY KEY (conf_name)
					) ENGINE = MyISAM CHARACTER SET utf8

		case 'pgsql':
			CREATE TABLE {{TABLE_PREFIX}}config (
					conf_name VARCHAR(255) NOT NULL DEFAULT '',
					conf_value TEXT,
					PRIMARY KEY (conf_name)
					)

		case 'sqlite':
			CREATE TABLE {{TABLE_PREFIX}}config (
					conf_name VARCHAR(255) NOT NULL DEFAULT '',
					conf_value TEXT,
					PRIMARY KEY (conf_name)
					)

		case 'mysql':
		case 'mysqli':
			CREATE TABLE {{TABLE_PREFIX}}extensions (
					id VARCHAR(50) NOT NULL DEFAULT '',
					title VARCHAR(255) NOT NULL DEFAULT '',
					version VARCHAR(25) NOT NULL DEFAULT '',
					description TEXT,
					author VARCHAR(50) NOT NULL DEFAULT '',
					uninstall TEXT,
					uninstall_note TEXT,
					disabled TINYINT(1) NOT NULL DEFAULT 0,
					PRIMARY KEY(id)
					) ENGINE = MyISAM CHARACTER SET utf8

		case 'pgsql':
			CREATE TABLE {{TABLE_PREFIX}}extensions (
					id VARCHAR(50) NOT NULL DEFAULT '',
					title VARCHAR(255) NOT NULL DEFAULT '',
					version VARCHAR(25) NOT NULL DEFAULT '',
					description TEXT,
					author VARCHAR(50) NOT NULL DEFAULT '',
					uninstall TEXT,
					uninstall_note TEXT,
					disabled SMALLINT NOT NULL DEFAULT 0,
					PRIMARY KEY(id)
					)

		case 'mysql':
		case 'mysqli':
			CREATE TABLE {{TABLE_PREFIX}}extension_hooks (
					id VARCHAR(50) NOT NULL DEFAULT '',
					extension_id VARCHAR(50) NOT NULL DEFAULT '',
					code TEXT,
					installed INT(10) UNSIGNED NOT NULL DEFAULT 0,
					PRIMARY KEY(id, extension_id)
					) ENGINE = MyISAM CHARACTER SET utf8

		case 'pgsql':
			CREATE TABLE {{TABLE_PREFIX}}extension_hooks (
					id VARCHAR(50) NOT NULL DEFAULT '',
					extension_id VARCHAR(50) NOT NULL DEFAULT '',
					code TEXT,
					installed INT NOT NULL DEFAULT 0,
					PRIMARY KEY(id, extension_id)
					)

		case 'mysql':
		case 'mysqli':
			CREATE TABLE {{TABLE_PREFIX}}forum_perms (
					group_id INT(10) NOT NULL DEFAULT 0,
					forum_id INT(10) NOT NULL DEFAULT 0,
					read_forum TINYINT(1) NOT NULL DEFAULT 1,
					post_replies TINYINT(1) NOT NULL DEFAULT 1,
					post_topics TINYINT(1) NOT NULL DEFAULT 1,
					PRIMARY KEY (group_id, forum_id)
					) ENGINE = MyISAM CHARACTER SET utf8

		case 'pgsql':
			CREATE TABLE {{TABLE_PREFIX}}forum_perms (
					group_id INT NOT NULL DEFAULT 0,
					forum_id INT NOT NULL DEFAULT 0,
					read_forum SMALLINT NOT NULL DEFAULT 1,
					post_replies SMALLINT NOT NULL DEFAULT 1,
					post_topics SMALLINT NOT NULL DEFAULT 1,
					PRIMARY KEY (group_id, forum_id)
					)

		case 'mysql':
		case 'mysqli':
			CREATE TABLE {{TABLE_PREFIX}}forums (
					id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
					forum_name VARCHAR(80) NOT NULL DEFAULT 'New forum',
					forum_desc TEXT,
					redirect_url VARCHAR(100),
					moderators TEXT,
					num_topics MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT 0,
					num_posts MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT 0,
					last_post INT(10) UNSIGNED,
					last_post_id INT(10) UNSIGNED,
					last_poster VARCHAR(200),
					sort_by TINYINT(1) NOT NULL DEFAULT 0,
					disp_position INT(10) NOT NULL DEFAULT 0,
					cat_id INT(10) UNSIGNED NOT NULL DEFAULT 0,
					PRIMARY KEY (id)
					) ENGINE = MyISAM CHARACTER SET utf8

		case 'pgsql':
			CREATE TABLE {{TABLE_PREFIX}}forums (
					id SERIAL,
					forum_name VARCHAR(80) NOT NULL DEFAULT 'New forum',
					forum_desc TEXT,
					redirect_url VARCHAR(100),
					moderators TEXT,
					num_topics INT NOT NULL DEFAULT 0,
					num_posts INT NOT NULL DEFAULT 0,
					last_post INT,
					last_post_id INT,
					last_poster VARCHAR(200),
					sort_by SMALLINT NOT NULL DEFAULT 0,
					disp_position INT NOT NULL DEFAULT 0,
					cat_id INT NOT NULL DEFAULT 0,
					PRIMARY KEY (id)
					)

		case 'mysql':
		case 'mysqli':
			CREATE TABLE {{TABLE_PREFIX}}groups (
					g_id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
					g_title VARCHAR(50) NOT NULL DEFAULT '',
					g_user_title VARCHAR(50),
					g_moderator TINYINT(1) NOT NULL DEFAULT 0,
					g_mod_edit_users TINYINT(1) NOT NULL DEFAULT 0,
					g_mod_rename_users TINYINT(1) NOT NULL DEFAULT 0,
					g_mod_change_passwords TINYINT(1) NOT NULL DEFAULT 0,
					g_mod_ban_users TINYINT(1) NOT NULL DEFAULT 0,
					g_read_board TINYINT(1) NOT NULL DEFAULT 1,
					g_view_users TINYINT(1) NOT NULL DEFAULT 1,
					g_post_replies TINYINT(1) NOT NULL DEFAULT 1,
					g_post_topics TINYINT(1) NOT NULL DEFAULT 1,
					g_edit_posts TINYINT(1) NOT NULL DEFAULT 1,
					g_delete_posts TINYINT(1) NOT NULL DEFAULT 1,
					g_delete_topics TINYINT(1) NOT NULL DEFAULT 1,
					g_set_title TINYINT(1) NOT NULL DEFAULT 1,
					g_search TINYINT(1) NOT NULL DEFAULT 1,
					g_search_users TINYINT(1) NOT NULL DEFAULT 1,
					g_edit_subjects_interval SMALLINT(6) NOT NULL DEFAULT 300,
					g_post_flood SMALLINT(6) NOT NULL DEFAULT 30,
					g_search_flood SMALLINT(6) NOT NULL DEFAULT 30,
					PRIMARY KEY (g_id)
					) ENGINE = MyISAM CHARACTER SET utf8

		case 'pgsql':
			CREATE TABLE {{TABLE_PREFIX}}groups (
					g_id SERIAL,
					g_title VARCHAR(50) NOT NULL DEFAULT '',
					g_user_title VARCHAR(50),
					g_moderator SMALLINT NOT NULL DEFAULT 0,
					g_mod_edit_users SMALLINT NOT NULL DEFAULT 0,
					g_mod_rename_users SMALLINT NOT NULL DEFAULT 0,
					g_mod_change_passwords SMALLINT NOT NULL DEFAULT 0,
					g_mod_ban_users SMALLINT NOT NULL DEFAULT 0,
					g_read_board SMALLINT NOT NULL DEFAULT 1,
					g_view_users SMALLINT NOT NULL DEFAULT 1,
					g_post_replies SMALLINT NOT NULL DEFAULT 1,
					g_post_topics SMALLINT NOT NULL DEFAULT 1,
					g_edit_posts SMALLINT NOT NULL DEFAULT 1,
					g_delete_posts SMALLINT NOT NULL DEFAULT 1,
					g_delete_topics SMALLINT NOT NULL DEFAULT 1,
					g_set_title SMALLINT NOT NULL DEFAULT 1,
					g_search SMALLINT NOT NULL DEFAULT 1,
					g_search_users SMALLINT NOT NULL DEFAULT 1,
					g_edit_subjects_interval SMALLINT NOT NULL DEFAULT 300,
					g_post_flood SMALLINT NOT NULL DEFAULT 30,
					g_search_flood SMALLINT NOT NULL DEFAULT 30,
					PRIMARY KEY (g_id)
        )

    case 'mysql':
		case 'mysqli':
			CREATE TABLE {{TABLE_PREFIX}}online (
					user_id INT(10) UNSIGNED NOT NULL DEFAULT 1,
					ident VARCHAR(200) NOT NULL DEFAULT '',
					logged INT(10) UNSIGNED NOT NULL DEFAULT 0,
					idle TINYINT(1) NOT NULL DEFAULT 0,
					csrf_token VARCHAR(40) NOT NULL DEFAULT '',
					prev_url VARCHAR(255)
					) TYPE=HEAP;

		case 'pgsql':
			CREATE TABLE {{TABLE_PREFIX}}online (
					user_id INT NOT NULL DEFAULT 1,
					ident VARCHAR(200) NOT NULL DEFAULT '',
					logged INT NOT NULL DEFAULT 0,
					idle SMALLINT NOT NULL DEFAULT 0,
					csrf_token VARCHAR(40) NOT NULL DEFAULT '',
					prev_url VARCHAR(255)
					)

		case 'mysql':
		case 'mysqli':
			CREATE TABLE {{TABLE_PREFIX}}posts (
					id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
					poster VARCHAR(200) NOT NULL DEFAULT '',
					poster_id INT(10) UNSIGNED NOT NULL DEFAULT 1,
					poster_ip VARCHAR(15),
					poster_email VARCHAR(80),
					message TEXT,
					hide_smilies TINYINT(1) NOT NULL DEFAULT 0,
					posted INT(10) UNSIGNED NOT NULL DEFAULT 0,
					edited INT(10) UNSIGNED,
					edited_by VARCHAR(200),
					topic_id INT(10) UNSIGNED NOT NULL DEFAULT 0,
					PRIMARY KEY (id)
        ) ENGINE = MyISAM CHARACTER SET utf8

		case 'pgsql':
			CREATE TABLE {{TABLE_PREFIX}}posts (
					id SERIAL,
					poster VARCHAR(200) NOT NULL DEFAULT '',
					poster_id INT NOT NULL DEFAULT 1,
					poster_ip VARCHAR(15),
					poster_email VARCHAR(80),
					message TEXT,
					hide_smilies SMALLINT NOT NULL DEFAULT 0,
					posted INT NOT NULL DEFAULT 0,
					edited INT,
					edited_by VARCHAR(200),
					topic_id INT NOT NULL DEFAULT 0,
					PRIMARY KEY (id)
        )

    case 'mysql':
		case 'mysqli':
			CREATE TABLE {{TABLE_PREFIX}}ranks (
					id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
					rank VARCHAR(50) NOT NULL DEFAULT '',
					min_posts MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT 0,
					PRIMARY KEY (id)
        ) ENGINE = MyISAM CHARACTER SET utf8

		case 'pgsql':
			CREATE TABLE {{TABLE_PREFIX}}ranks (
					id SERIAL,
					rank VARCHAR(50) NOT NULL DEFAULT '',
					min_posts INT NOT NULL DEFAULT 0,
					PRIMARY KEY (id)
        )

		case 'sqlite':
			CREATE TABLE {{TABLE_PREFIX}}ranks (
					id INTEGER NOT NULL,
					rank VARCHAR(50) NOT NULL DEFAULT '',
					min_posts INTEGER NOT NULL DEFAULT 0,
					PRIMARY KEY (id)
        )

    case 'mysql':
		case 'mysqli':
			CREATE TABLE {{TABLE_PREFIX}}reports (
					id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
					post_id INT(10) UNSIGNED NOT NULL DEFAULT 0,
					topic_id INT(10) UNSIGNED NOT NULL DEFAULT 0,
					forum_id INT(10) UNSIGNED NOT NULL DEFAULT 0,
					reported_by INT(10) UNSIGNED NOT NULL DEFAULT 0,
					created INT(10) UNSIGNED NOT NULL DEFAULT 0,
					message TEXT,
					zapped INT(10) UNSIGNED,
					zapped_by INT(10) UNSIGNED,
					PRIMARY KEY (id)
        ) ENGINE = MyISAM CHARACTER SET utf8

		case 'pgsql':
			CREATE TABLE {{TABLE_PREFIX}}reports (
					id SERIAL,
					post_id INT NOT NULL DEFAULT 0,
					topic_id INT NOT NULL DEFAULT 0,
					forum_id INT NOT NULL DEFAULT 0,
					reported_by INT NOT NULL DEFAULT 0,
					created INT NOT NULL DEFAULT 0,
					message TEXT,
					zapped INT,
					zapped_by INT,
					PRIMARY KEY (id)
        )

		case 'pgsql':
			CREATE TABLE {{TABLE_PREFIX}}search_cache (
					id INT NOT NULL DEFAULT 0,
					ident VARCHAR(200) NOT NULL DEFAULT '',
					search_data TEXT,
					PRIMARY KEY (id)
					)

    case 'pgsql':
			CREATE TABLE {{TABLE_PREFIX}}search_matches (
					post_id INT NOT NULL DEFAULT 0,
					word_id INT NOT NULL DEFAULT 0,
					subject_match SMALLINT NOT NULL DEFAULT 0
					)

		case 'pgsql':
			CREATE TABLE {{TABLE_PREFIX}}search_words (
					id SERIAL,
					word VARCHAR(20) NOT NULL DEFAULT '',
					PRIMARY KEY (word)
					)

		case 'mysql':
		case 'mysqli':
			CREATE TABLE {{TABLE_PREFIX}}subscriptions (
					user_id INT(10) UNSIGNED NOT NULL DEFAULT 0,
					topic_id INT(10) UNSIGNED NOT NULL DEFAULT 0,
					PRIMARY KEY (user_id, topic_id)
					) ENGINE = MyISAM CHARACTER SET utf8

		case 'pgsql':
			CREATE TABLE {{TABLE_PREFIX}}subscriptions (
					user_id INT NOT NULL DEFAULT 0,
					topic_id INT NOT NULL DEFAULT 0,
					PRIMARY KEY (user_id, topic_id)
					)

    case 'mysql':
		case 'mysqli':
			CREATE TABLE {{TABLE_PREFIX}}topics (
					id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
					poster VARCHAR(200) NOT NULL DEFAULT '',
					subject VARCHAR(255) NOT NULL DEFAULT '',
					posted INT(10) UNSIGNED NOT NULL DEFAULT 0,
					first_post_id INT(10) UNSIGNED NOT NULL DEFAULT 0,
					last_post INT(10) UNSIGNED NOT NULL DEFAULT 0,
					last_post_id INT(10) UNSIGNED NOT NULL DEFAULT 0,
					last_poster VARCHAR(200),
					num_views MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT 0,
					num_replies MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT 0,
					closed TINYINT(1) NOT NULL DEFAULT 0,
					sticky TINYINT(1) NOT NULL DEFAULT 0,
					moved_to INT(10) UNSIGNED,
					forum_id INT(10) UNSIGNED NOT NULL DEFAULT 0,
					PRIMARY KEY (id)
        ) ENGINE = MyISAM CHARACTER SET utf8

		case 'pgsql':
			CREATE TABLE {{TABLE_PREFIX}}topics (
					id SERIAL,
					poster VARCHAR(200) NOT NULL DEFAULT '',
					subject VARCHAR(255) NOT NULL DEFAULT '',
					posted INT NOT NULL DEFAULT 0,
					first_post_id INT NOT NULL DEFAULT 0,
					last_post INT NOT NULL DEFAULT 0,
					last_post_id INT NOT NULL DEFAULT 0,
					last_poster VARCHAR(200),
					num_views INT NOT NULL DEFAULT 0,
					num_replies INT NOT NULL DEFAULT 0,
					closed SMALLINT NOT NULL DEFAULT 0,
					sticky SMALLINT NOT NULL DEFAULT 0,
					moved_to INT,
					forum_id INT NOT NULL DEFAULT 0,
					PRIMARY KEY (id)
        )

		case 'mysql':
		case 'mysqli':
			CREATE TABLE {{TABLE_PREFIX}}users (
					id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
					group_id INT(10) UNSIGNED NOT NULL DEFAULT 4,
					username VARCHAR(200) NOT NULL DEFAULT '',
					password VARCHAR(40) NOT NULL DEFAULT '',
					salt VARCHAR(12),
					email VARCHAR(80) NOT NULL DEFAULT '',
					title VARCHAR(50),
					realname VARCHAR(40),
					url VARCHAR(100),
					jabber VARCHAR(80),
					icq VARCHAR(12),
					msn VARCHAR(80),
					aim VARCHAR(30),
					yahoo VARCHAR(30),
					location VARCHAR(30),
					signature TEXT,
					disp_topics TINYINT(3) UNSIGNED,
					disp_posts TINYINT(3) UNSIGNED,
					email_setting TINYINT(1) NOT NULL DEFAULT 1,
					save_pass TINYINT(1) NOT NULL DEFAULT 1,
					notify_with_post TINYINT(1) NOT NULL DEFAULT 0,
					auto_notify TINYINT(1) NOT NULL DEFAULT 0,
					show_smilies TINYINT(1) NOT NULL DEFAULT 1,
					show_img TINYINT(1) NOT NULL DEFAULT 1,
					show_img_sig TINYINT(1) NOT NULL DEFAULT 1,
					show_avatars TINYINT(1) NOT NULL DEFAULT 1,
					show_sig TINYINT(1) NOT NULL DEFAULT 1,
					timezone FLOAT NOT NULL DEFAULT 0,
					dst TINYINT(1) NOT NULL DEFAULT 0,
					time_format INT(10) UNSIGNED NOT NULL DEFAULT 0,
					date_format INT(10) UNSIGNED NOT NULL DEFAULT 0,
					language VARCHAR(25) NOT NULL DEFAULT 'English',
					style VARCHAR(25) NOT NULL DEFAULT 'Oxygen',
					num_posts INT(10) UNSIGNED NOT NULL DEFAULT 0,
					last_post INT(10) UNSIGNED,
					registered INT(10) UNSIGNED NOT NULL DEFAULT 0,
					registration_ip VARCHAR(15) NOT NULL DEFAULT '0.0.0.0',
					last_visit INT(10) UNSIGNED NOT NULL DEFAULT 0,
					admin_note VARCHAR(30),
					activate_string VARCHAR(80),
					activate_key VARCHAR(8),
					PRIMARY KEY (id)
        ) ENGINE = MyISAM CHARACTER SET utf8

		case 'pgsql':
			CREATE TABLE {{TABLE_PREFIX}}users (
					id SERIAL,
					group_id INT NOT NULL DEFAULT 4,
					username VARCHAR(200) NOT NULL DEFAULT '',
					password VARCHAR(40) NOT NULL DEFAULT '',
					salt VARCHAR(12),
					email VARCHAR(80) NOT NULL DEFAULT '',
					title VARCHAR(50),
					realname VARCHAR(40),
					url VARCHAR(100),
					jabber VARCHAR(80),
					icq VARCHAR(12),
					msn VARCHAR(80),
					aim VARCHAR(30),
					yahoo VARCHAR(30),
					location VARCHAR(30),
					signature TEXT,
					disp_topics SMALLINT,
					disp_posts SMALLINT,
					email_setting SMALLINT NOT NULL DEFAULT 1,
					save_pass SMALLINT NOT NULL DEFAULT 1,
					notify_with_post SMALLINT NOT NULL DEFAULT 0,
					auto_notify SMALLINT NOT NULL DEFAULT 0,
					show_smilies SMALLINT NOT NULL DEFAULT 1,
					show_img SMALLINT NOT NULL DEFAULT 1,
					show_img_sig SMALLINT NOT NULL DEFAULT 1,
					show_avatars SMALLINT NOT NULL DEFAULT 1,
					show_sig SMALLINT NOT NULL DEFAULT 1,
					timezone REAL NOT NULL DEFAULT 0,
					dst SMALLINT NOT NULL DEFAULT 0,
					time_format INT NOT NULL DEFAULT 0,
					date_format INT NOT NULL DEFAULT 0,
					language VARCHAR(25) NOT NULL DEFAULT 'English',
					style VARCHAR(25) NOT NULL DEFAULT 'Oxygen',
					num_posts INT NOT NULL DEFAULT 0,
					last_post INT,
					registered INT NOT NULL DEFAULT 0,
					registration_ip VARCHAR(15) NOT NULL DEFAULT '0.0.0.0',
					last_visit INT NOT NULL DEFAULT 0,
					admin_note VARCHAR(30),
					activate_string VARCHAR(80),
					activate_key VARCHAR(8),
					PRIMARY KEY (id)
        )

		case 'mysql':
		case 'mysqli':
			// mysql
			ALTER TABLE {{TABLE_PREFIX}}online ADD UNIQUE INDEX {{TABLE_PREFIX}}online_user_id_ident_idx(user_id,ident(25));
			ALTER TABLE {{TABLE_PREFIX}}online ADD INDEX {{TABLE_PREFIX}}online_user_id_idx(user_id);
			ALTER TABLE {{TABLE_PREFIX}}posts ADD INDEX {{TABLE_PREFIX}}posts_topic_id_idx(topic_id);
			ALTER TABLE {{TABLE_PREFIX}}posts ADD INDEX {{TABLE_PREFIX}}posts_multi_idx(poster_id, topic_id);
			ALTER TABLE {{TABLE_PREFIX}}posts ADD FULLTEXT {{TABLE_PREFIX}}posts_message_idx(message);
			ALTER TABLE {{TABLE_PREFIX}}reports ADD INDEX {{TABLE_PREFIX}}reports_zapped_idx(zapped);
			ALTER TABLE {{TABLE_PREFIX}}topics ADD INDEX {{TABLE_PREFIX}}topics_forum_id_idx(forum_id);
			ALTER TABLE {{TABLE_PREFIX}}topics ADD INDEX {{TABLE_PREFIX}}topics_moved_to_idx(moved_to);
			ALTER TABLE {{TABLE_PREFIX}}topics ADD INDEX {{TABLE_PREFIX}}topics_last_post_idx(last_post);
			ALTER TABLE {{TABLE_PREFIX}}topics ADD INDEX {{TABLE_PREFIX}}topics_first_post_id_idx(first_post_id);
			ALTER TABLE {{TABLE_PREFIX}}topics ADD FULLTEXT {{TABLE_PREFIX}}topics_subject_idx(subject);
			ALTER TABLE {{TABLE_PREFIX}}users ADD INDEX {{TABLE_PREFIX}}users_registered_idx(registered);
			ALTER TABLE {{TABLE_PREFIX}}users ADD INDEX {{TABLE_PREFIX}}users_username_idx(username(8));
      
      // pgsql
			CREATE UNIQUE INDEX {{TABLE_PREFIX}}online_user_id_ident_idx ON {{TABLE_PREFIX}}online(user_id,ident);
			CREATE INDEX {{TABLE_PREFIX}}online_user_id_idx ON {{TABLE_PREFIX}}online(user_id);
			CREATE INDEX {{TABLE_PREFIX}}posts_topic_id_idx ON {{TABLE_PREFIX}}posts(topic_id);
			CREATE INDEX {{TABLE_PREFIX}}posts_multi_idx ON {{TABLE_PREFIX}}posts(poster_id, topic_id);
			CREATE INDEX {{TABLE_PREFIX}}reports_zapped_idx ON {{TABLE_PREFIX}}reports(zapped);
			CREATE INDEX {{TABLE_PREFIX}}search_matches_word_id_idx ON {{TABLE_PREFIX}}search_matches(word_id);
			CREATE INDEX {{TABLE_PREFIX}}search_matches_post_id_idx ON {{TABLE_PREFIX}}search_matches(post_id);
			CREATE INDEX {{TABLE_PREFIX}}topics_forum_id_idx ON {{TABLE_PREFIX}}topics(forum_id);
			CREATE INDEX {{TABLE_PREFIX}}topics_moved_to_idx ON {{TABLE_PREFIX}}topics(moved_to);
			CREATE INDEX {{TABLE_PREFIX}}topics_last_post_idx ON {{TABLE_PREFIX}}topics(last_post);
			CREATE INDEX {{TABLE_PREFIX}}topics_first_post_id_idx ON {{TABLE_PREFIX}}topics(first_post_id);
			CREATE INDEX {{TABLE_PREFIX}}users_registered_idx ON {{TABLE_PREFIX}}users(registered);
			CREATE INDEX {{TABLE_PREFIX}}users_username_idx ON {{TABLE_PREFIX}}users(username);
			CREATE INDEX {{TABLE_PREFIX}}search_cache_ident_idx ON {{TABLE_PREFIX}}search_cache(ident);
			CREATE INDEX {{TABLE_PREFIX}}search_words_id_idx ON {{TABLE_PREFIX}}search_words(id);