1     case 'mysql':

     2 		case 'mysqli':

     3 			CREATE TABLE {{TABLE_PREFIX}}bans (

     4 					id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,

     5 					username VARCHAR(200),

     6 					ip VARCHAR(255),

     7 					email VARCHAR(80),

     8 					message VARCHAR(255),

     9 					expire INT(10) UNSIGNED,

    10 					ban_creator INT(10) UNSIGNED NOT NULL DEFAULT 0,

    11 					PRIMARY KEY (id)

    12         ) ENGINE = MyISAM CHARACTER SET utf8

    13       

    14 		case 'pgsql':

    15 			CREATE TABLE {{TABLE_PREFIX}}bans (

    16 					id SERIAL,

    17 					username VARCHAR(200),

    18 					ip VARCHAR(255),

    19 					email VARCHAR(80),

    20 					message VARCHAR(255),

    21 					expire INT,

    22 					ban_creator INT NOT NULL DEFAULT 0,

    23 					PRIMARY KEY (id)

    24         )

    25 

    26     case 'mysql':

    27 		case 'mysqli':

    28 			CREATE TABLE {{TABLE_PREFIX}}categories (

    29 					id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,

    30 					cat_name VARCHAR(80) NOT NULL DEFAULT 'New Category',

    31 					disp_position INT(10) NOT NULL DEFAULT 0,

    32 					PRIMARY KEY (id)

    33 					) ENGINE = MyISAM CHARACTER SET utf8

    34 

    35 		case 'pgsql':

    36 			CREATE TABLE {{TABLE_PREFIX}}categories (

    37 					id SERIAL,

    38 					cat_name VARCHAR(80) NOT NULL DEFAULT 'New Category',

    39 					disp_position INT NOT NULL DEFAULT 0,

    40 					PRIMARY KEY (id)

    41 					)

    42 

    43 		case 'mysql':

    44 		case 'mysqli':

    45 			CREATE TABLE {{TABLE_PREFIX}}censoring (

    46 					id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,

    47 					search_for VARCHAR(60) NOT NULL DEFAULT '',

    48 					replace_with VARCHAR(60) NOT NULL DEFAULT '',

    49 					PRIMARY KEY (id)

    50 					) ENGINE = MyISAM CHARACTER SET utf8

    51 

    52 		case 'pgsql':

    53 			CREATE TABLE {{TABLE_PREFIX}}censoring (

    54 					id SERIAL,

    55 					search_for VARCHAR(60) NOT NULL DEFAULT '',

    56 					replace_with VARCHAR(60) NOT NULL DEFAULT '',

    57 					PRIMARY KEY (id)

    58 					)

    59 

    60 		case 'mysql':

    61 		case 'mysqli':

    62 			CREATE TABLE {{TABLE_PREFIX}}config (

    63 					conf_name VARCHAR(255) NOT NULL DEFAULT '',

    64 					conf_value TEXT,

    65 					PRIMARY KEY (conf_name)

    66 					) ENGINE = MyISAM CHARACTER SET utf8

    67 

    68 		case 'pgsql':

    69 			CREATE TABLE {{TABLE_PREFIX}}config (

    70 					conf_name VARCHAR(255) NOT NULL DEFAULT '',

    71 					conf_value TEXT,

    72 					PRIMARY KEY (conf_name)

    73 					)

    74 

    75 		case 'sqlite':

    76 			CREATE TABLE {{TABLE_PREFIX}}config (

    77 					conf_name VARCHAR(255) NOT NULL DEFAULT '',

    78 					conf_value TEXT,

    79 					PRIMARY KEY (conf_name)

    80 					)

    81 

    82 		case 'mysql':

    83 		case 'mysqli':

    84 			CREATE TABLE {{TABLE_PREFIX}}extensions (

    85 					id VARCHAR(50) NOT NULL DEFAULT '',

    86 					title VARCHAR(255) NOT NULL DEFAULT '',

    87 					version VARCHAR(25) NOT NULL DEFAULT '',

    88 					description TEXT,

    89 					author VARCHAR(50) NOT NULL DEFAULT '',

    90 					uninstall TEXT,

    91 					uninstall_note TEXT,

    92 					disabled TINYINT(1) NOT NULL DEFAULT 0,

    93 					PRIMARY KEY(id)

    94 					) ENGINE = MyISAM CHARACTER SET utf8

    95 

    96 		case 'pgsql':

    97 			CREATE TABLE {{TABLE_PREFIX}}extensions (

    98 					id VARCHAR(50) NOT NULL DEFAULT '',

    99 					title VARCHAR(255) NOT NULL DEFAULT '',

   100 					version VARCHAR(25) NOT NULL DEFAULT '',

   101 					description TEXT,

   102 					author VARCHAR(50) NOT NULL DEFAULT '',

   103 					uninstall TEXT,

   104 					uninstall_note TEXT,

   105 					disabled SMALLINT NOT NULL DEFAULT 0,

   106 					PRIMARY KEY(id)

   107 					)

   108 

   109 		case 'mysql':

   110 		case 'mysqli':

   111 			CREATE TABLE {{TABLE_PREFIX}}extension_hooks (

   112 					id VARCHAR(50) NOT NULL DEFAULT '',

   113 					extension_id VARCHAR(50) NOT NULL DEFAULT '',

   114 					code TEXT,

   115 					installed INT(10) UNSIGNED NOT NULL DEFAULT 0,

   116 					PRIMARY KEY(id, extension_id)

   117 					) ENGINE = MyISAM CHARACTER SET utf8

   118 

   119 		case 'pgsql':

   120 			CREATE TABLE {{TABLE_PREFIX}}extension_hooks (

   121 					id VARCHAR(50) NOT NULL DEFAULT '',

   122 					extension_id VARCHAR(50) NOT NULL DEFAULT '',

   123 					code TEXT,

   124 					installed INT NOT NULL DEFAULT 0,

   125 					PRIMARY KEY(id, extension_id)

   126 					)

   127 

   128 		case 'mysql':

   129 		case 'mysqli':

   130 			CREATE TABLE {{TABLE_PREFIX}}forum_perms (

   131 					group_id INT(10) NOT NULL DEFAULT 0,

   132 					forum_id INT(10) NOT NULL DEFAULT 0,

   133 					read_forum TINYINT(1) NOT NULL DEFAULT 1,

   134 					post_replies TINYINT(1) NOT NULL DEFAULT 1,

   135 					post_topics TINYINT(1) NOT NULL DEFAULT 1,

   136 					PRIMARY KEY (group_id, forum_id)

   137 					) ENGINE = MyISAM CHARACTER SET utf8

   138 

   139 		case 'pgsql':

   140 			CREATE TABLE {{TABLE_PREFIX}}forum_perms (

   141 					group_id INT NOT NULL DEFAULT 0,

   142 					forum_id INT NOT NULL DEFAULT 0,

   143 					read_forum SMALLINT NOT NULL DEFAULT 1,

   144 					post_replies SMALLINT NOT NULL DEFAULT 1,

   145 					post_topics SMALLINT NOT NULL DEFAULT 1,

   146 					PRIMARY KEY (group_id, forum_id)

   147 					)

   148 

   149 		case 'mysql':

   150 		case 'mysqli':

   151 			CREATE TABLE {{TABLE_PREFIX}}forums (

   152 					id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,

   153 					forum_name VARCHAR(80) NOT NULL DEFAULT 'New forum',

   154 					forum_desc TEXT,

   155 					redirect_url VARCHAR(100),

   156 					moderators TEXT,

   157 					num_topics MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT 0,

   158 					num_posts MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT 0,

   159 					last_post INT(10) UNSIGNED,

   160 					last_post_id INT(10) UNSIGNED,

   161 					last_poster VARCHAR(200),

   162 					sort_by TINYINT(1) NOT NULL DEFAULT 0,

   163 					disp_position INT(10) NOT NULL DEFAULT 0,

   164 					cat_id INT(10) UNSIGNED NOT NULL DEFAULT 0,

   165 					PRIMARY KEY (id)

   166 					) ENGINE = MyISAM CHARACTER SET utf8

   167 

   168 		case 'pgsql':

   169 			CREATE TABLE {{TABLE_PREFIX}}forums (

   170 					id SERIAL,

   171 					forum_name VARCHAR(80) NOT NULL DEFAULT 'New forum',

   172 					forum_desc TEXT,

   173 					redirect_url VARCHAR(100),

   174 					moderators TEXT,

   175 					num_topics INT NOT NULL DEFAULT 0,

   176 					num_posts INT NOT NULL DEFAULT 0,

   177 					last_post INT,

   178 					last_post_id INT,

   179 					last_poster VARCHAR(200),

   180 					sort_by SMALLINT NOT NULL DEFAULT 0,

   181 					disp_position INT NOT NULL DEFAULT 0,

   182 					cat_id INT NOT NULL DEFAULT 0,

   183 					PRIMARY KEY (id)

   184 					)

   185 

   186 		case 'mysql':

   187 		case 'mysqli':

   188 			CREATE TABLE {{TABLE_PREFIX}}groups (

   189 					g_id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,

   190 					g_title VARCHAR(50) NOT NULL DEFAULT '',

   191 					g_user_title VARCHAR(50),

   192 					g_moderator TINYINT(1) NOT NULL DEFAULT 0,

   193 					g_mod_edit_users TINYINT(1) NOT NULL DEFAULT 0,

   194 					g_mod_rename_users TINYINT(1) NOT NULL DEFAULT 0,

   195 					g_mod_change_passwords TINYINT(1) NOT NULL DEFAULT 0,

   196 					g_mod_ban_users TINYINT(1) NOT NULL DEFAULT 0,

   197 					g_read_board TINYINT(1) NOT NULL DEFAULT 1,

   198 					g_view_users TINYINT(1) NOT NULL DEFAULT 1,

   199 					g_post_replies TINYINT(1) NOT NULL DEFAULT 1,

   200 					g_post_topics TINYINT(1) NOT NULL DEFAULT 1,

   201 					g_edit_posts TINYINT(1) NOT NULL DEFAULT 1,

   202 					g_delete_posts TINYINT(1) NOT NULL DEFAULT 1,

   203 					g_delete_topics TINYINT(1) NOT NULL DEFAULT 1,

   204 					g_set_title TINYINT(1) NOT NULL DEFAULT 1,

   205 					g_search TINYINT(1) NOT NULL DEFAULT 1,

   206 					g_search_users TINYINT(1) NOT NULL DEFAULT 1,

   207 					g_edit_subjects_interval SMALLINT(6) NOT NULL DEFAULT 300,

   208 					g_post_flood SMALLINT(6) NOT NULL DEFAULT 30,

   209 					g_search_flood SMALLINT(6) NOT NULL DEFAULT 30,

   210 					PRIMARY KEY (g_id)

   211 					) ENGINE = MyISAM CHARACTER SET utf8

   212 

   213 		case 'pgsql':

   214 			CREATE TABLE {{TABLE_PREFIX}}groups (

   215 					g_id SERIAL,

   216 					g_title VARCHAR(50) NOT NULL DEFAULT '',

   217 					g_user_title VARCHAR(50),

   218 					g_moderator SMALLINT NOT NULL DEFAULT 0,

   219 					g_mod_edit_users SMALLINT NOT NULL DEFAULT 0,

   220 					g_mod_rename_users SMALLINT NOT NULL DEFAULT 0,

   221 					g_mod_change_passwords SMALLINT NOT NULL DEFAULT 0,

   222 					g_mod_ban_users SMALLINT NOT NULL DEFAULT 0,

   223 					g_read_board SMALLINT NOT NULL DEFAULT 1,

   224 					g_view_users SMALLINT NOT NULL DEFAULT 1,

   225 					g_post_replies SMALLINT NOT NULL DEFAULT 1,

   226 					g_post_topics SMALLINT NOT NULL DEFAULT 1,

   227 					g_edit_posts SMALLINT NOT NULL DEFAULT 1,

   228 					g_delete_posts SMALLINT NOT NULL DEFAULT 1,

   229 					g_delete_topics SMALLINT NOT NULL DEFAULT 1,

   230 					g_set_title SMALLINT NOT NULL DEFAULT 1,

   231 					g_search SMALLINT NOT NULL DEFAULT 1,

   232 					g_search_users SMALLINT NOT NULL DEFAULT 1,

   233 					g_edit_subjects_interval SMALLINT NOT NULL DEFAULT 300,

   234 					g_post_flood SMALLINT NOT NULL DEFAULT 30,

   235 					g_search_flood SMALLINT NOT NULL DEFAULT 30,

   236 					PRIMARY KEY (g_id)

   237         )

   238 

   239     case 'mysql':

   240 		case 'mysqli':

   241 			CREATE TABLE {{TABLE_PREFIX}}online (

   242 					user_id INT(10) UNSIGNED NOT NULL DEFAULT 1,

   243 					ident VARCHAR(200) NOT NULL DEFAULT '',

   244 					logged INT(10) UNSIGNED NOT NULL DEFAULT 0,

   245 					idle TINYINT(1) NOT NULL DEFAULT 0,

   246 					csrf_token VARCHAR(40) NOT NULL DEFAULT '',

   247 					prev_url VARCHAR(255)

   248 					) TYPE=HEAP;

   249 

   250 		case 'pgsql':

   251 			CREATE TABLE {{TABLE_PREFIX}}online (

   252 					user_id INT NOT NULL DEFAULT 1,

   253 					ident VARCHAR(200) NOT NULL DEFAULT '',

   254 					logged INT NOT NULL DEFAULT 0,

   255 					idle SMALLINT NOT NULL DEFAULT 0,

   256 					csrf_token VARCHAR(40) NOT NULL DEFAULT '',

   257 					prev_url VARCHAR(255)

   258 					)

   259 

   260 		case 'mysql':

   261 		case 'mysqli':

   262 			CREATE TABLE {{TABLE_PREFIX}}posts (

   263 					id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,

   264 					poster VARCHAR(200) NOT NULL DEFAULT '',

   265 					poster_id INT(10) UNSIGNED NOT NULL DEFAULT 1,

   266 					poster_ip VARCHAR(15),

   267 					poster_email VARCHAR(80),

   268 					message TEXT,

   269 					hide_smilies TINYINT(1) NOT NULL DEFAULT 0,

   270 					posted INT(10) UNSIGNED NOT NULL DEFAULT 0,

   271 					edited INT(10) UNSIGNED,

   272 					edited_by VARCHAR(200),

   273 					topic_id INT(10) UNSIGNED NOT NULL DEFAULT 0,

   274 					PRIMARY KEY (id)

   275         ) ENGINE = MyISAM CHARACTER SET utf8

   276 

   277 		case 'pgsql':

   278 			CREATE TABLE {{TABLE_PREFIX}}posts (

   279 					id SERIAL,

   280 					poster VARCHAR(200) NOT NULL DEFAULT '',

   281 					poster_id INT NOT NULL DEFAULT 1,

   282 					poster_ip VARCHAR(15),

   283 					poster_email VARCHAR(80),

   284 					message TEXT,

   285 					hide_smilies SMALLINT NOT NULL DEFAULT 0,

   286 					posted INT NOT NULL DEFAULT 0,

   287 					edited INT,

   288 					edited_by VARCHAR(200),

   289 					topic_id INT NOT NULL DEFAULT 0,

   290 					PRIMARY KEY (id)

   291         )

   292 

   293     case 'mysql':

   294 		case 'mysqli':

   295 			CREATE TABLE {{TABLE_PREFIX}}ranks (

   296 					id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,

   297 					rank VARCHAR(50) NOT NULL DEFAULT '',

   298 					min_posts MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT 0,

   299 					PRIMARY KEY (id)

   300         ) ENGINE = MyISAM CHARACTER SET utf8

   301 

   302 		case 'pgsql':

   303 			CREATE TABLE {{TABLE_PREFIX}}ranks (

   304 					id SERIAL,

   305 					rank VARCHAR(50) NOT NULL DEFAULT '',

   306 					min_posts INT NOT NULL DEFAULT 0,

   307 					PRIMARY KEY (id)

   308         )

   309 

   310 		case 'sqlite':

   311 			CREATE TABLE {{TABLE_PREFIX}}ranks (

   312 					id INTEGER NOT NULL,

   313 					rank VARCHAR(50) NOT NULL DEFAULT '',

   314 					min_posts INTEGER NOT NULL DEFAULT 0,

   315 					PRIMARY KEY (id)

   316         )

   317 

   318     case 'mysql':

   319 		case 'mysqli':

   320 			CREATE TABLE {{TABLE_PREFIX}}reports (

   321 					id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,

   322 					post_id INT(10) UNSIGNED NOT NULL DEFAULT 0,

   323 					topic_id INT(10) UNSIGNED NOT NULL DEFAULT 0,

   324 					forum_id INT(10) UNSIGNED NOT NULL DEFAULT 0,

   325 					reported_by INT(10) UNSIGNED NOT NULL DEFAULT 0,

   326 					created INT(10) UNSIGNED NOT NULL DEFAULT 0,

   327 					message TEXT,

   328 					zapped INT(10) UNSIGNED,

   329 					zapped_by INT(10) UNSIGNED,

   330 					PRIMARY KEY (id)

   331         ) ENGINE = MyISAM CHARACTER SET utf8

   332 

   333 		case 'pgsql':

   334 			CREATE TABLE {{TABLE_PREFIX}}reports (

   335 					id SERIAL,

   336 					post_id INT NOT NULL DEFAULT 0,

   337 					topic_id INT NOT NULL DEFAULT 0,

   338 					forum_id INT NOT NULL DEFAULT 0,

   339 					reported_by INT NOT NULL DEFAULT 0,

   340 					created INT NOT NULL DEFAULT 0,

   341 					message TEXT,

   342 					zapped INT,

   343 					zapped_by INT,

   344 					PRIMARY KEY (id)

   345         )

   346 

   347 		case 'pgsql':

   348 			CREATE TABLE {{TABLE_PREFIX}}search_cache (

   349 					id INT NOT NULL DEFAULT 0,

   350 					ident VARCHAR(200) NOT NULL DEFAULT '',

   351 					search_data TEXT,

   352 					PRIMARY KEY (id)

   353 					)

   354 

   355     case 'pgsql':

   356 			CREATE TABLE {{TABLE_PREFIX}}search_matches (

   357 					post_id INT NOT NULL DEFAULT 0,

   358 					word_id INT NOT NULL DEFAULT 0,

   359 					subject_match SMALLINT NOT NULL DEFAULT 0

   360 					)

   361 

   362 		case 'pgsql':

   363 			CREATE TABLE {{TABLE_PREFIX}}search_words (

   364 					id SERIAL,

   365 					word VARCHAR(20) NOT NULL DEFAULT '',

   366 					PRIMARY KEY (word)

   367 					)

   368 

   369 		case 'mysql':

   370 		case 'mysqli':

   371 			CREATE TABLE {{TABLE_PREFIX}}subscriptions (

   372 					user_id INT(10) UNSIGNED NOT NULL DEFAULT 0,

   373 					topic_id INT(10) UNSIGNED NOT NULL DEFAULT 0,

   374 					PRIMARY KEY (user_id, topic_id)

   375 					) ENGINE = MyISAM CHARACTER SET utf8

   376 

   377 		case 'pgsql':

   378 			CREATE TABLE {{TABLE_PREFIX}}subscriptions (

   379 					user_id INT NOT NULL DEFAULT 0,

   380 					topic_id INT NOT NULL DEFAULT 0,

   381 					PRIMARY KEY (user_id, topic_id)

   382 					)

   383 

   384     case 'mysql':

   385 		case 'mysqli':

   386 			CREATE TABLE {{TABLE_PREFIX}}topics (

   387 					id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,

   388 					poster VARCHAR(200) NOT NULL DEFAULT '',

   389 					subject VARCHAR(255) NOT NULL DEFAULT '',

   390 					posted INT(10) UNSIGNED NOT NULL DEFAULT 0,

   391 					first_post_id INT(10) UNSIGNED NOT NULL DEFAULT 0,

   392 					last_post INT(10) UNSIGNED NOT NULL DEFAULT 0,

   393 					last_post_id INT(10) UNSIGNED NOT NULL DEFAULT 0,

   394 					last_poster VARCHAR(200),

   395 					num_views MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT 0,

   396 					num_replies MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT 0,

   397 					closed TINYINT(1) NOT NULL DEFAULT 0,

   398 					sticky TINYINT(1) NOT NULL DEFAULT 0,

   399 					moved_to INT(10) UNSIGNED,

   400 					forum_id INT(10) UNSIGNED NOT NULL DEFAULT 0,

   401 					PRIMARY KEY (id)

   402         ) ENGINE = MyISAM CHARACTER SET utf8

   403 

   404 		case 'pgsql':

   405 			CREATE TABLE {{TABLE_PREFIX}}topics (

   406 					id SERIAL,

   407 					poster VARCHAR(200) NOT NULL DEFAULT '',

   408 					subject VARCHAR(255) NOT NULL DEFAULT '',

   409 					posted INT NOT NULL DEFAULT 0,

   410 					first_post_id INT NOT NULL DEFAULT 0,

   411 					last_post INT NOT NULL DEFAULT 0,

   412 					last_post_id INT NOT NULL DEFAULT 0,

   413 					last_poster VARCHAR(200),

   414 					num_views INT NOT NULL DEFAULT 0,

   415 					num_replies INT NOT NULL DEFAULT 0,

   416 					closed SMALLINT NOT NULL DEFAULT 0,

   417 					sticky SMALLINT NOT NULL DEFAULT 0,

   418 					moved_to INT,

   419 					forum_id INT NOT NULL DEFAULT 0,

   420 					PRIMARY KEY (id)

   421         )

   422 

   423 		case 'mysql':

   424 		case 'mysqli':

   425 			CREATE TABLE {{TABLE_PREFIX}}users (

   426 					id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,

   427 					group_id INT(10) UNSIGNED NOT NULL DEFAULT 4,

   428 					username VARCHAR(200) NOT NULL DEFAULT '',

   429 					password VARCHAR(40) NOT NULL DEFAULT '',

   430 					salt VARCHAR(12),

   431 					email VARCHAR(80) NOT NULL DEFAULT '',

   432 					title VARCHAR(50),

   433 					realname VARCHAR(40),

   434 					url VARCHAR(100),

   435 					jabber VARCHAR(80),

   436 					icq VARCHAR(12),

   437 					msn VARCHAR(80),

   438 					aim VARCHAR(30),

   439 					yahoo VARCHAR(30),

   440 					location VARCHAR(30),

   441 					signature TEXT,

   442 					disp_topics TINYINT(3) UNSIGNED,

   443 					disp_posts TINYINT(3) UNSIGNED,

   444 					email_setting TINYINT(1) NOT NULL DEFAULT 1,

   445 					save_pass TINYINT(1) NOT NULL DEFAULT 1,

   446 					notify_with_post TINYINT(1) NOT NULL DEFAULT 0,

   447 					auto_notify TINYINT(1) NOT NULL DEFAULT 0,

   448 					show_smilies TINYINT(1) NOT NULL DEFAULT 1,

   449 					show_img TINYINT(1) NOT NULL DEFAULT 1,

   450 					show_img_sig TINYINT(1) NOT NULL DEFAULT 1,

   451 					show_avatars TINYINT(1) NOT NULL DEFAULT 1,

   452 					show_sig TINYINT(1) NOT NULL DEFAULT 1,

   453 					timezone FLOAT NOT NULL DEFAULT 0,

   454 					dst TINYINT(1) NOT NULL DEFAULT 0,

   455 					time_format INT(10) UNSIGNED NOT NULL DEFAULT 0,

   456 					date_format INT(10) UNSIGNED NOT NULL DEFAULT 0,

   457 					language VARCHAR(25) NOT NULL DEFAULT 'English',

   458 					style VARCHAR(25) NOT NULL DEFAULT 'Oxygen',

   459 					num_posts INT(10) UNSIGNED NOT NULL DEFAULT 0,

   460 					last_post INT(10) UNSIGNED,

   461 					registered INT(10) UNSIGNED NOT NULL DEFAULT 0,

   462 					registration_ip VARCHAR(15) NOT NULL DEFAULT '0.0.0.0',

   463 					last_visit INT(10) UNSIGNED NOT NULL DEFAULT 0,

   464 					admin_note VARCHAR(30),

   465 					activate_string VARCHAR(80),

   466 					activate_key VARCHAR(8),

   467 					PRIMARY KEY (id)

   468         ) ENGINE = MyISAM CHARACTER SET utf8

   469 

   470 		case 'pgsql':

   471 			CREATE TABLE {{TABLE_PREFIX}}users (

   472 					id SERIAL,

   473 					group_id INT NOT NULL DEFAULT 4,

   474 					username VARCHAR(200) NOT NULL DEFAULT '',

   475 					password VARCHAR(40) NOT NULL DEFAULT '',

   476 					salt VARCHAR(12),

   477 					email VARCHAR(80) NOT NULL DEFAULT '',

   478 					title VARCHAR(50),

   479 					realname VARCHAR(40),

   480 					url VARCHAR(100),

   481 					jabber VARCHAR(80),

   482 					icq VARCHAR(12),

   483 					msn VARCHAR(80),

   484 					aim VARCHAR(30),

   485 					yahoo VARCHAR(30),

   486 					location VARCHAR(30),

   487 					signature TEXT,

   488 					disp_topics SMALLINT,

   489 					disp_posts SMALLINT,

   490 					email_setting SMALLINT NOT NULL DEFAULT 1,

   491 					save_pass SMALLINT NOT NULL DEFAULT 1,

   492 					notify_with_post SMALLINT NOT NULL DEFAULT 0,

   493 					auto_notify SMALLINT NOT NULL DEFAULT 0,

   494 					show_smilies SMALLINT NOT NULL DEFAULT 1,

   495 					show_img SMALLINT NOT NULL DEFAULT 1,

   496 					show_img_sig SMALLINT NOT NULL DEFAULT 1,

   497 					show_avatars SMALLINT NOT NULL DEFAULT 1,

   498 					show_sig SMALLINT NOT NULL DEFAULT 1,

   499 					timezone REAL NOT NULL DEFAULT 0,

   500 					dst SMALLINT NOT NULL DEFAULT 0,

   501 					time_format INT NOT NULL DEFAULT 0,

   502 					date_format INT NOT NULL DEFAULT 0,

   503 					language VARCHAR(25) NOT NULL DEFAULT 'English',

   504 					style VARCHAR(25) NOT NULL DEFAULT 'Oxygen',

   505 					num_posts INT NOT NULL DEFAULT 0,

   506 					last_post INT,

   507 					registered INT NOT NULL DEFAULT 0,

   508 					registration_ip VARCHAR(15) NOT NULL DEFAULT '0.0.0.0',

   509 					last_visit INT NOT NULL DEFAULT 0,

   510 					admin_note VARCHAR(30),

   511 					activate_string VARCHAR(80),

   512 					activate_key VARCHAR(8),

   513 					PRIMARY KEY (id)

   514         )

   515 

   516 		case 'mysql':

   517 		case 'mysqli':

   518 			// mysql

   519 			ALTER TABLE {{TABLE_PREFIX}}online ADD UNIQUE INDEX {{TABLE_PREFIX}}online_user_id_ident_idx(user_id,ident(25));

   520 			ALTER TABLE {{TABLE_PREFIX}}online ADD INDEX {{TABLE_PREFIX}}online_user_id_idx(user_id);

   521 			ALTER TABLE {{TABLE_PREFIX}}posts ADD INDEX {{TABLE_PREFIX}}posts_topic_id_idx(topic_id);

   522 			ALTER TABLE {{TABLE_PREFIX}}posts ADD INDEX {{TABLE_PREFIX}}posts_multi_idx(poster_id, topic_id);

   523 			ALTER TABLE {{TABLE_PREFIX}}posts ADD FULLTEXT {{TABLE_PREFIX}}posts_message_idx(message);

   524 			ALTER TABLE {{TABLE_PREFIX}}reports ADD INDEX {{TABLE_PREFIX}}reports_zapped_idx(zapped);

   525 			ALTER TABLE {{TABLE_PREFIX}}topics ADD INDEX {{TABLE_PREFIX}}topics_forum_id_idx(forum_id);

   526 			ALTER TABLE {{TABLE_PREFIX}}topics ADD INDEX {{TABLE_PREFIX}}topics_moved_to_idx(moved_to);

   527 			ALTER TABLE {{TABLE_PREFIX}}topics ADD INDEX {{TABLE_PREFIX}}topics_last_post_idx(last_post);

   528 			ALTER TABLE {{TABLE_PREFIX}}topics ADD INDEX {{TABLE_PREFIX}}topics_first_post_id_idx(first_post_id);

   529 			ALTER TABLE {{TABLE_PREFIX}}topics ADD FULLTEXT {{TABLE_PREFIX}}topics_subject_idx(subject);

   530 			ALTER TABLE {{TABLE_PREFIX}}users ADD INDEX {{TABLE_PREFIX}}users_registered_idx(registered);

   531 			ALTER TABLE {{TABLE_PREFIX}}users ADD INDEX {{TABLE_PREFIX}}users_username_idx(username(8));

   532       

   533       // pgsql

   534 			CREATE UNIQUE INDEX {{TABLE_PREFIX}}online_user_id_ident_idx ON {{TABLE_PREFIX}}online(user_id,ident);

   535 			CREATE INDEX {{TABLE_PREFIX}}online_user_id_idx ON {{TABLE_PREFIX}}online(user_id);

   536 			CREATE INDEX {{TABLE_PREFIX}}posts_topic_id_idx ON {{TABLE_PREFIX}}posts(topic_id);

   537 			CREATE INDEX {{TABLE_PREFIX}}posts_multi_idx ON {{TABLE_PREFIX}}posts(poster_id, topic_id);

   538 			CREATE INDEX {{TABLE_PREFIX}}reports_zapped_idx ON {{TABLE_PREFIX}}reports(zapped);

   539 			CREATE INDEX {{TABLE_PREFIX}}search_matches_word_id_idx ON {{TABLE_PREFIX}}search_matches(word_id);

   540 			CREATE INDEX {{TABLE_PREFIX}}search_matches_post_id_idx ON {{TABLE_PREFIX}}search_matches(post_id);

   541 			CREATE INDEX {{TABLE_PREFIX}}topics_forum_id_idx ON {{TABLE_PREFIX}}topics(forum_id);

   542 			CREATE INDEX {{TABLE_PREFIX}}topics_moved_to_idx ON {{TABLE_PREFIX}}topics(moved_to);

   543 			CREATE INDEX {{TABLE_PREFIX}}topics_last_post_idx ON {{TABLE_PREFIX}}topics(last_post);

   544 			CREATE INDEX {{TABLE_PREFIX}}topics_first_post_id_idx ON {{TABLE_PREFIX}}topics(first_post_id);

   545 			CREATE INDEX {{TABLE_PREFIX}}users_registered_idx ON {{TABLE_PREFIX}}users(registered);

   546 			CREATE INDEX {{TABLE_PREFIX}}users_username_idx ON {{TABLE_PREFIX}}users(username);

   547 			CREATE INDEX {{TABLE_PREFIX}}search_cache_ident_idx ON {{TABLE_PREFIX}}search_cache(ident);

   548 			CREATE INDEX {{TABLE_PREFIX}}search_words_id_idx ON {{TABLE_PREFIX}}search_words(id);

   549