Verzeichnisstruktur phpBB-3.0.0
- Veröffentlicht
- 12.12.2007
So funktioniert es
|
Auf das letzte Element klicken. Dies geht jeweils ein Schritt zurück |
Auf das Icon klicken, dies öffnet das Verzeichnis. Nochmal klicken schließt das Verzeichnis. |
|
(Beispiel Datei-Icons)
|
Auf das Icon klicken um den Quellcode anzuzeigen |
postgres_schema.sql
0001 /*
0002
0003 $Id$
0004
0005 */
0006
0007 BEGIN;
0008
0009 /*
0010 Domain definition
0011 */
0012 CREATE DOMAIN varchar_ci AS varchar(255) NOT NULL DEFAULT ''::character varying;
0013
0014 /*
0015 Operation Functions
0016 */
0017 CREATE FUNCTION _varchar_ci_equal(varchar_ci, varchar_ci) RETURNS boolean AS 'SELECT LOWER($1) = LOWER($2)' LANGUAGE SQL STRICT;
0018 CREATE FUNCTION _varchar_ci_not_equal(varchar_ci, varchar_ci) RETURNS boolean AS 'SELECT LOWER($1) != LOWER($2)' LANGUAGE SQL STRICT;
0019 CREATE FUNCTION _varchar_ci_less_than(varchar_ci, varchar_ci) RETURNS boolean AS 'SELECT LOWER($1) < LOWER($2)' LANGUAGE SQL STRICT;
0020 CREATE FUNCTION _varchar_ci_less_equal(varchar_ci, varchar_ci) RETURNS boolean AS 'SELECT LOWER($1) <= LOWER($2)' LANGUAGE SQL STRICT;
0021 CREATE FUNCTION _varchar_ci_greater_than(varchar_ci, varchar_ci) RETURNS boolean AS 'SELECT LOWER($1) > LOWER($2)' LANGUAGE SQL STRICT;
0022 CREATE FUNCTION _varchar_ci_greater_equals(varchar_ci, varchar_ci) RETURNS boolean AS 'SELECT LOWER($1) >= LOWER($2)' LANGUAGE SQL STRICT;
0023
0024 /*
0025 Operators
0026 */
0027 CREATE OPERATOR <(
0028 PROCEDURE = _varchar_ci_less_than,
0029 LEFTARG = varchar_ci,
0030 RIGHTARG = varchar_ci,
0031 COMMUTATOR = >,
0032 NEGATOR = >=,
0033 RESTRICT = scalarltsel,
0034 JOIN = scalarltjoinsel);
0035
0036 CREATE OPERATOR <=(
0037 PROCEDURE = _varchar_ci_less_equal,
0038 LEFTARG = varchar_ci,
0039 RIGHTARG = varchar_ci,
0040 COMMUTATOR = >=,
0041 NEGATOR = >,
0042 RESTRICT = scalarltsel,
0043 JOIN = scalarltjoinsel);
0044
0045 CREATE OPERATOR >(
0046 PROCEDURE = _varchar_ci_greater_than,
0047 LEFTARG = varchar_ci,
0048 RIGHTARG = varchar_ci,
0049 COMMUTATOR = <,
0050 NEGATOR = <=,
0051 RESTRICT = scalargtsel,
0052 JOIN = scalargtjoinsel);
0053
0054 CREATE OPERATOR >=(
0055 PROCEDURE = _varchar_ci_greater_equals,
0056 LEFTARG = varchar_ci,
0057 RIGHTARG = varchar_ci,
0058 COMMUTATOR = <=,
0059 NEGATOR = <,
0060 RESTRICT = scalargtsel,
0061 JOIN = scalargtjoinsel);
0062
0063 CREATE OPERATOR <>(
0064 PROCEDURE = _varchar_ci_not_equal,
0065 LEFTARG = varchar_ci,
0066 RIGHTARG = varchar_ci,
0067 COMMUTATOR = <>,
0068 NEGATOR = =,
0069 RESTRICT = neqsel,
0070 JOIN = neqjoinsel);
0071
0072 CREATE OPERATOR =(
0073 PROCEDURE = _varchar_ci_equal,
0074 LEFTARG = varchar_ci,
0075 RIGHTARG = varchar_ci,
0076 COMMUTATOR = =,
0077 NEGATOR = <>,
0078 RESTRICT = eqsel,
0079 JOIN = eqjoinsel,
0080 HASHES,
0081 MERGES,
0082 SORT1= <);
0083
0084 /*
0085 Table: 'phpbb_attachments'
0086 */
0087 CREATE SEQUENCE phpbb_attachments_seq;
0088
0089 CREATE TABLE phpbb_attachments (
0090 attach_id INT4 DEFAULT nextval('phpbb_attachments_seq'),
0091 post_msg_id INT4 DEFAULT '0' NOT NULL CHECK (post_msg_id >= 0),
0092 topic_id INT4 DEFAULT '0' NOT NULL CHECK (topic_id >= 0),
0093 in_message INT2 DEFAULT '0' NOT NULL CHECK (in_message >= 0),
0094 poster_id INT4 DEFAULT '0' NOT NULL CHECK (poster_id >= 0),
0095 is_orphan INT2 DEFAULT '1' NOT NULL CHECK (is_orphan >= 0),
0096 physical_filename varchar(255) DEFAULT '' NOT NULL,
0097 real_filename varchar(255) DEFAULT '' NOT NULL,
0098 download_count INT4 DEFAULT '0' NOT NULL CHECK (download_count >= 0),
0099 attach_comment varchar(4000) DEFAULT '' NOT NULL,
0100 extension varchar(100) DEFAULT '' NOT NULL,
0101 mimetype varchar(100) DEFAULT '' NOT NULL,
0102 filesize INT4 DEFAULT '0' NOT NULL CHECK (filesize >= 0),
0103 filetime INT4 DEFAULT '0' NOT NULL CHECK (filetime >= 0),
0104 thumbnail INT2 DEFAULT '0' NOT NULL CHECK (thumbnail >= 0),
0105 PRIMARY KEY (attach_id)
0106 );
0107
0108 CREATE INDEX phpbb_attachments_filetime ON phpbb_attachments (filetime);
0109 CREATE INDEX phpbb_attachments_post_msg_id ON phpbb_attachments (post_msg_id);
0110 CREATE INDEX phpbb_attachments_topic_id ON phpbb_attachments (topic_id);
0111 CREATE INDEX phpbb_attachments_poster_id ON phpbb_attachments (poster_id);
0112 CREATE INDEX phpbb_attachments_is_orphan ON phpbb_attachments (is_orphan);
0113
0114 /*
0115 Table: 'phpbb_acl_groups'
0116 */
0117 CREATE TABLE phpbb_acl_groups (
0118 group_id INT4 DEFAULT '0' NOT NULL CHECK (group_id >= 0),
0119 forum_id INT4 DEFAULT '0' NOT NULL CHECK (forum_id >= 0),
0120 auth_option_id INT4 DEFAULT '0' NOT NULL CHECK (auth_option_id >= 0),
0121 auth_role_id INT4 DEFAULT '0' NOT NULL CHECK (auth_role_id >= 0),
0122 auth_setting INT2 DEFAULT '0' NOT NULL
0123 );
0124
0125 CREATE INDEX phpbb_acl_groups_group_id ON phpbb_acl_groups (group_id);
0126 CREATE INDEX phpbb_acl_groups_auth_opt_id ON phpbb_acl_groups (auth_option_id);
0127 CREATE INDEX phpbb_acl_groups_auth_role_id ON phpbb_acl_groups (auth_role_id);
0128
0129 /*
0130 Table: 'phpbb_acl_options'
0131 */
0132 CREATE SEQUENCE phpbb_acl_options_seq;
0133
0134 CREATE TABLE phpbb_acl_options (
0135 auth_option_id INT4 DEFAULT nextval('phpbb_acl_options_seq'),
0136 auth_option varchar(50) DEFAULT '' NOT NULL,
0137 is_global INT2 DEFAULT '0' NOT NULL CHECK (is_global >= 0),
0138 is_local INT2 DEFAULT '0' NOT NULL CHECK (is_local >= 0),
0139 founder_only INT2 DEFAULT '0' NOT NULL CHECK (founder_only >= 0),
0140 PRIMARY KEY (auth_option_id)
0141 );
0142
0143 CREATE INDEX phpbb_acl_options_auth_option ON phpbb_acl_options (auth_option);
0144
0145 /*
0146 Table: 'phpbb_acl_roles'
0147 */
0148 CREATE SEQUENCE phpbb_acl_roles_seq;
0149
0150 CREATE TABLE phpbb_acl_roles (
0151 role_id INT4 DEFAULT nextval('phpbb_acl_roles_seq'),
0152 role_name varchar(255) DEFAULT '' NOT NULL,
0153 role_description varchar(4000) DEFAULT '' NOT NULL,
0154 role_type varchar(10) DEFAULT '' NOT NULL,
0155 role_order INT2 DEFAULT '0' NOT NULL CHECK (role_order >= 0),
0156 PRIMARY KEY (role_id)
0157 );
0158
0159 CREATE INDEX phpbb_acl_roles_role_type ON phpbb_acl_roles (role_type);
0160 CREATE INDEX phpbb_acl_roles_role_order ON phpbb_acl_roles (role_order);
0161
0162 /*
0163 Table: 'phpbb_acl_roles_data'
0164 */
0165 CREATE TABLE phpbb_acl_roles_data (
0166 role_id INT4 DEFAULT '0' NOT NULL CHECK (role_id >= 0),
0167 auth_option_id INT4 DEFAULT '0' NOT NULL CHECK (auth_option_id >= 0),
0168 auth_setting INT2 DEFAULT '0' NOT NULL,
0169 PRIMARY KEY (role_id, auth_option_id)
0170 );
0171
0172 CREATE INDEX phpbb_acl_roles_data_ath_op_id ON phpbb_acl_roles_data (auth_option_id);
0173
0174 /*
0175 Table: 'phpbb_acl_users'
0176 */
0177 CREATE TABLE phpbb_acl_users (
0178 user_id INT4 DEFAULT '0' NOT NULL CHECK (user_id >= 0),
0179 forum_id INT4 DEFAULT '0' NOT NULL CHECK (forum_id >= 0),
0180 auth_option_id INT4 DEFAULT '0' NOT NULL CHECK (auth_option_id >= 0),
0181 auth_role_id INT4 DEFAULT '0' NOT NULL CHECK (auth_role_id >= 0),
0182 auth_setting INT2 DEFAULT '0' NOT NULL
0183 );
0184
0185 CREATE INDEX phpbb_acl_users_user_id ON phpbb_acl_users (user_id);
0186 CREATE INDEX phpbb_acl_users_auth_option_id ON phpbb_acl_users (auth_option_id);
0187 CREATE INDEX phpbb_acl_users_auth_role_id ON phpbb_acl_users (auth_role_id);
0188
0189 /*
0190 Table: 'phpbb_banlist'
0191 */
0192 CREATE SEQUENCE phpbb_banlist_seq;
0193
0194 CREATE TABLE phpbb_banlist (
0195 ban_id INT4 DEFAULT nextval('phpbb_banlist_seq'),
0196 ban_userid INT4 DEFAULT '0' NOT NULL CHECK (ban_userid >= 0),
0197 ban_ip varchar(40) DEFAULT '' NOT NULL,
0198 ban_email varchar(100) DEFAULT '' NOT NULL,
0199 ban_start INT4 DEFAULT '0' NOT NULL CHECK (ban_start >= 0),
0200 ban_end INT4 DEFAULT '0' NOT NULL CHECK (ban_end >= 0),
0201 ban_exclude INT2 DEFAULT '0' NOT NULL CHECK (ban_exclude >= 0),
0202 ban_reason varchar(255) DEFAULT '' NOT NULL,
0203 ban_give_reason varchar(255) DEFAULT '' NOT NULL,
0204 PRIMARY KEY (ban_id)
0205 );
0206
0207 CREATE INDEX phpbb_banlist_ban_end ON phpbb_banlist (ban_end);
0208 CREATE INDEX phpbb_banlist_ban_user ON phpbb_banlist (ban_userid, ban_exclude);
0209 CREATE INDEX phpbb_banlist_ban_email ON phpbb_banlist (ban_email, ban_exclude);
0210 CREATE INDEX phpbb_banlist_ban_ip ON phpbb_banlist (ban_ip, ban_exclude);
0211
0212 /*
0213 Table: 'phpbb_bbcodes'
0214 */
0215 CREATE TABLE phpbb_bbcodes (
0216 bbcode_id INT2 DEFAULT '0' NOT NULL,
0217 bbcode_tag varchar(16) DEFAULT '' NOT NULL,
0218 bbcode_helpline varchar(255) DEFAULT '' NOT NULL,
0219 display_on_posting INT2 DEFAULT '0' NOT NULL CHECK (display_on_posting >= 0),
0220 bbcode_match varchar(4000) DEFAULT '' NOT NULL,
0221 bbcode_tpl TEXT DEFAULT '' NOT NULL,
0222 first_pass_match TEXT DEFAULT '' NOT NULL,
0223 first_pass_replace TEXT DEFAULT '' NOT NULL,
0224 second_pass_match TEXT DEFAULT '' NOT NULL,
0225 second_pass_replace TEXT DEFAULT '' NOT NULL,
0226 PRIMARY KEY (bbcode_id)
0227 );
0228
0229 CREATE INDEX phpbb_bbcodes_display_on_post ON phpbb_bbcodes (display_on_posting);
0230
0231 /*
0232 Table: 'phpbb_bookmarks'
0233 */
0234 CREATE TABLE phpbb_bookmarks (
0235 topic_id INT4 DEFAULT '0' NOT NULL CHECK (topic_id >= 0),
0236 user_id INT4 DEFAULT '0' NOT NULL CHECK (user_id >= 0),
0237 PRIMARY KEY (topic_id, user_id)
0238 );
0239
0240
0241 /*
0242 Table: 'phpbb_bots'
0243 */
0244 CREATE SEQUENCE phpbb_bots_seq;
0245
0246 CREATE TABLE phpbb_bots (
0247 bot_id INT4 DEFAULT nextval('phpbb_bots_seq'),
0248 bot_active INT2 DEFAULT '1' NOT NULL CHECK (bot_active >= 0),
0249 bot_name varchar(255) DEFAULT '' NOT NULL,
0250 user_id INT4 DEFAULT '0' NOT NULL CHECK (user_id >= 0),
0251 bot_agent varchar(255) DEFAULT '' NOT NULL,
0252 bot_ip varchar(255) DEFAULT '' NOT NULL,
0253 PRIMARY KEY (bot_id)
0254 );
0255
0256 CREATE INDEX phpbb_bots_bot_active ON phpbb_bots (bot_active);
0257
0258 /*
0259 Table: 'phpbb_config'
0260 */
0261 CREATE TABLE phpbb_config (
0262 config_name varchar(255) DEFAULT '' NOT NULL,
0263 config_value varchar(255) DEFAULT '' NOT NULL,
0264 is_dynamic INT2 DEFAULT '0' NOT NULL CHECK (is_dynamic >= 0),
0265 PRIMARY KEY (config_name)
0266 );
0267
0268 CREATE INDEX phpbb_config_is_dynamic ON phpbb_config (is_dynamic);
0269
0270 /*
0271 Table: 'phpbb_confirm'
0272 */
0273 CREATE TABLE phpbb_confirm (
0274 confirm_id char(32) DEFAULT '' NOT NULL,
0275 session_id char(32) DEFAULT '' NOT NULL,
0276 confirm_type INT2 DEFAULT '0' NOT NULL,
0277 code varchar(8) DEFAULT '' NOT NULL,
0278 seed INT4 DEFAULT '0' NOT NULL CHECK (seed >= 0),
0279 PRIMARY KEY (session_id, confirm_id)
0280 );
0281
0282 CREATE INDEX phpbb_confirm_confirm_type ON phpbb_confirm (confirm_type);
0283
0284 /*
0285 Table: 'phpbb_disallow'
0286 */
0287 CREATE SEQUENCE phpbb_disallow_seq;
0288
0289 CREATE TABLE phpbb_disallow (
0290 disallow_id INT4 DEFAULT nextval('phpbb_disallow_seq'),
0291 disallow_username varchar(255) DEFAULT '' NOT NULL,
0292 PRIMARY KEY (disallow_id)
0293 );
0294
0295
0296 /*
0297 Table: 'phpbb_drafts'
0298 */
0299 CREATE SEQUENCE phpbb_drafts_seq;
0300
0301 CREATE TABLE phpbb_drafts (
0302 draft_id INT4 DEFAULT nextval('phpbb_drafts_seq'),
0303 user_id INT4 DEFAULT '0' NOT NULL CHECK (user_id >= 0),
0304 topic_id INT4 DEFAULT '0' NOT NULL CHECK (topic_id >= 0),
0305 forum_id INT4 DEFAULT '0' NOT NULL CHECK (forum_id >= 0),
0306 save_time INT4 DEFAULT '0' NOT NULL CHECK (save_time >= 0),
0307 draft_subject varchar(100) DEFAULT '' NOT NULL,
0308 draft_message TEXT DEFAULT '' NOT NULL,
0309 PRIMARY KEY (draft_id)
0310 );
0311
0312 CREATE INDEX phpbb_drafts_save_time ON phpbb_drafts (save_time);
0313
0314 /*
0315 Table: 'phpbb_extensions'
0316 */
0317 CREATE SEQUENCE phpbb_extensions_seq;
0318
0319 CREATE TABLE phpbb_extensions (
0320 extension_id INT4 DEFAULT nextval('phpbb_extensions_seq'),
0321 group_id INT4 DEFAULT '0' NOT NULL CHECK (group_id >= 0),
0322 extension varchar(100) DEFAULT '' NOT NULL,
0323 PRIMARY KEY (extension_id)
0324 );
0325
0326
0327 /*
0328 Table: 'phpbb_extension_groups'
0329 */
0330 CREATE SEQUENCE phpbb_extension_groups_seq;
0331
0332 CREATE TABLE phpbb_extension_groups (
0333 group_id INT4 DEFAULT nextval('phpbb_extension_groups_seq'),
0334 group_name varchar(255) DEFAULT '' NOT NULL,
0335 cat_id INT2 DEFAULT '0' NOT NULL,
0336 allow_group INT2 DEFAULT '0' NOT NULL CHECK (allow_group >= 0),
0337 download_mode INT2 DEFAULT '1' NOT NULL CHECK (download_mode >= 0),
0338 upload_icon varchar(255) DEFAULT '' NOT NULL,
0339 max_filesize INT4 DEFAULT '0' NOT NULL CHECK (max_filesize >= 0),
0340 allowed_forums varchar(8000) DEFAULT '' NOT NULL,
0341 allow_in_pm INT2 DEFAULT '0' NOT NULL CHECK (allow_in_pm >= 0),
0342 PRIMARY KEY (group_id)
0343 );
0344
0345
0346 /*
0347 Table: 'phpbb_forums'
0348 */
0349 CREATE SEQUENCE phpbb_forums_seq;
0350
0351 CREATE TABLE phpbb_forums (
0352 forum_id INT4 DEFAULT nextval('phpbb_forums_seq'),
0353 parent_id INT4 DEFAULT '0' NOT NULL CHECK (parent_id >= 0),
0354 left_id INT4 DEFAULT '0' NOT NULL CHECK (left_id >= 0),
0355 right_id INT4 DEFAULT '0' NOT NULL CHECK (right_id >= 0),
0356 forum_parents TEXT DEFAULT '' NOT NULL,
0357 forum_name varchar(255) DEFAULT '' NOT NULL,
0358 forum_desc varchar(4000) DEFAULT '' NOT NULL,
0359 forum_desc_bitfield varchar(255) DEFAULT '' NOT NULL,
0360 forum_desc_options INT4 DEFAULT '7' NOT NULL CHECK (forum_desc_options >= 0),
0361 forum_desc_uid varchar(8) DEFAULT '' NOT NULL,
0362 forum_link varchar(255) DEFAULT '' NOT NULL,
0363 forum_password varchar(40) DEFAULT '' NOT NULL,
0364 forum_style INT2 DEFAULT '0' NOT NULL CHECK (forum_style >= 0),
0365 forum_image varchar(255) DEFAULT '' NOT NULL,
0366 forum_rules varchar(4000) DEFAULT '' NOT NULL,
0367 forum_rules_link varchar(255) DEFAULT '' NOT NULL,
0368 forum_rules_bitfield varchar(255) DEFAULT '' NOT NULL,
0369 forum_rules_options INT4 DEFAULT '7' NOT NULL CHECK (forum_rules_options >= 0),
0370 forum_rules_uid varchar(8) DEFAULT '' NOT NULL,
0371 forum_topics_per_page INT2 DEFAULT '0' NOT NULL,
0372 forum_type INT2 DEFAULT '0' NOT NULL,
0373 forum_status INT2 DEFAULT '0' NOT NULL,
0374 forum_posts INT4 DEFAULT '0' NOT NULL CHECK (forum_posts >= 0),
0375 forum_topics INT4 DEFAULT '0' NOT NULL CHECK (forum_topics >= 0),
0376 forum_topics_real INT4 DEFAULT '0' NOT NULL CHECK (forum_topics_real >= 0),
0377 forum_last_post_id INT4 DEFAULT '0' NOT NULL CHECK (forum_last_post_id >= 0),
0378 forum_last_poster_id INT4 DEFAULT '0' NOT NULL CHECK (forum_last_poster_id >= 0),
0379 forum_last_post_subject varchar(100) DEFAULT '' NOT NULL,
0380 forum_last_post_time INT4 DEFAULT '0' NOT NULL CHECK (forum_last_post_time >= 0),
0381 forum_last_poster_name varchar(255) DEFAULT '' NOT NULL,
0382 forum_last_poster_colour varchar(6) DEFAULT '' NOT NULL,
0383 forum_flags INT2 DEFAULT '32' NOT NULL,
0384 display_on_index INT2 DEFAULT '1' NOT NULL CHECK (display_on_index >= 0),
0385 enable_indexing INT2 DEFAULT '1' NOT NULL CHECK (enable_indexing >= 0),
0386 enable_icons INT2 DEFAULT '1' NOT NULL CHECK (enable_icons >= 0),
0387 enable_prune INT2 DEFAULT '0' NOT NULL CHECK (enable_prune >= 0),
0388 prune_next INT4 DEFAULT '0' NOT NULL CHECK (prune_next >= 0),
0389 prune_days INT4 DEFAULT '0' NOT NULL CHECK (prune_days >= 0),
0390 prune_viewed INT4 DEFAULT '0' NOT NULL CHECK (prune_viewed >= 0),
0391 prune_freq INT4 DEFAULT '0' NOT NULL CHECK (prune_freq >= 0),
0392 PRIMARY KEY (forum_id)
0393 );
0394
0395 CREATE INDEX phpbb_forums_left_right_id ON phpbb_forums (left_id, right_id);
0396 CREATE INDEX phpbb_forums_forum_lastpost_id ON phpbb_forums (forum_last_post_id);
0397
0398 /*
0399 Table: 'phpbb_forums_access'
0400 */
0401 CREATE TABLE phpbb_forums_access (
0402 forum_id INT4 DEFAULT '0' NOT NULL CHECK (forum_id >= 0),
0403 user_id INT4 DEFAULT '0' NOT NULL CHECK (user_id >= 0),
0404 session_id char(32) DEFAULT '' NOT NULL,
0405 PRIMARY KEY (forum_id, user_id, session_id)
0406 );
0407
0408
0409 /*
0410 Table: 'phpbb_forums_track'
0411 */
0412 CREATE TABLE phpbb_forums_track (
0413 user_id INT4 DEFAULT '0' NOT NULL CHECK (user_id >= 0),
0414 forum_id INT4 DEFAULT '0' NOT NULL CHECK (forum_id >= 0),
0415 mark_time INT4 DEFAULT '0' NOT NULL CHECK (mark_time >= 0),
0416 PRIMARY KEY (user_id, forum_id)
0417 );
0418
0419
0420 /*
0421 Table: 'phpbb_forums_watch'
0422 */
0423 CREATE TABLE phpbb_forums_watch (
0424 forum_id INT4 DEFAULT '0' NOT NULL CHECK (forum_id >= 0),
0425 user_id INT4 DEFAULT '0' NOT NULL CHECK (user_id >= 0),
0426 notify_status INT2 DEFAULT '0' NOT NULL CHECK (notify_status >= 0)
0427 );
0428
0429 CREATE INDEX phpbb_forums_watch_forum_id ON phpbb_forums_watch (forum_id);
0430 CREATE INDEX phpbb_forums_watch_user_id ON phpbb_forums_watch (user_id);
0431 CREATE INDEX phpbb_forums_watch_notify_stat ON phpbb_forums_watch (notify_status);
0432
0433 /*
0434 Table: 'phpbb_groups'
0435 */
0436 CREATE SEQUENCE phpbb_groups_seq;
0437
0438 CREATE TABLE phpbb_groups (
0439 group_id INT4 DEFAULT nextval('phpbb_groups_seq'),
0440 group_type INT2 DEFAULT '1' NOT NULL,
0441 group_founder_manage INT2 DEFAULT '0' NOT NULL CHECK (group_founder_manage >= 0),
0442 group_name varchar_ci DEFAULT '' NOT NULL,
0443 group_desc varchar(4000) DEFAULT '' NOT NULL,
0444 group_desc_bitfield varchar(255) DEFAULT '' NOT NULL,
0445 group_desc_options INT4 DEFAULT '7' NOT NULL CHECK (group_desc_options >= 0),
0446 group_desc_uid varchar(8) DEFAULT '' NOT NULL,
0447 group_display INT2 DEFAULT '0' NOT NULL CHECK (group_display >= 0),
0448 group_avatar varchar(255) DEFAULT '' NOT NULL,
0449 group_avatar_type INT2 DEFAULT '0' NOT NULL,
0450 group_avatar_width INT2 DEFAULT '0' NOT NULL CHECK (group_avatar_width >= 0),
0451 group_avatar_height INT2 DEFAULT '0' NOT NULL CHECK (group_avatar_height >= 0),
0452 group_rank INT4 DEFAULT '0' NOT NULL CHECK (group_rank >= 0),
0453 group_colour varchar(6) DEFAULT '' NOT NULL,
0454 group_sig_chars INT4 DEFAULT '0' NOT NULL CHECK (group_sig_chars >= 0),
0455 group_receive_pm INT2 DEFAULT '0' NOT NULL CHECK (group_receive_pm >= 0),
0456 group_message_limit INT4 DEFAULT '0' NOT NULL CHECK (group_message_limit >= 0),
0457 group_legend INT2 DEFAULT '1' NOT NULL CHECK (group_legend >= 0),
0458 PRIMARY KEY (group_id)
0459 );
0460
0461 CREATE INDEX phpbb_groups_group_legend ON phpbb_groups (group_legend);
0462
0463 /*
0464 Table: 'phpbb_icons'
0465 */
0466 CREATE SEQUENCE phpbb_icons_seq;
0467
0468 CREATE TABLE phpbb_icons (
0469 icons_id INT4 DEFAULT nextval('phpbb_icons_seq'),
0470 icons_url varchar(255) DEFAULT '' NOT NULL,
0471 icons_width INT2 DEFAULT '0' NOT NULL,
0472 icons_height INT2 DEFAULT '0' NOT NULL,
0473 icons_order INT4 DEFAULT '0' NOT NULL CHECK (icons_order >= 0),
0474 display_on_posting INT2 DEFAULT '1' NOT NULL CHECK (display_on_posting >= 0),
0475 PRIMARY KEY (icons_id)
0476 );
0477
0478 CREATE INDEX phpbb_icons_display_on_posting ON phpbb_icons (display_on_posting);
0479
0480 /*
0481 Table: 'phpbb_lang'
0482 */
0483 CREATE SEQUENCE phpbb_lang_seq;
0484
0485 CREATE TABLE phpbb_lang (
0486 lang_id INT2 DEFAULT nextval('phpbb_lang_seq'),
0487 lang_iso varchar(30) DEFAULT '' NOT NULL,
0488 lang_dir varchar(30) DEFAULT '' NOT NULL,
0489 lang_english_name varchar(100) DEFAULT '' NOT NULL,
0490 lang_local_name varchar(255) DEFAULT '' NOT NULL,
0491 lang_author varchar(255) DEFAULT '' NOT NULL,
0492 PRIMARY KEY (lang_id)
0493 );
0494
0495 CREATE INDEX phpbb_lang_lang_iso ON phpbb_lang (lang_iso);
0496
0497 /*
0498 Table: 'phpbb_log'
0499 */
0500 CREATE SEQUENCE phpbb_log_seq;
0501
0502 CREATE TABLE phpbb_log (
0503 log_id INT4 DEFAULT nextval('phpbb_log_seq'),
0504 log_type INT2 DEFAULT '0' NOT NULL,
0505 user_id INT4 DEFAULT '0' NOT NULL CHECK (user_id >= 0),
0506 forum_id INT4 DEFAULT '0' NOT NULL CHECK (forum_id >= 0),
0507 topic_id INT4 DEFAULT '0' NOT NULL CHECK (topic_id >= 0),
0508 reportee_id INT4 DEFAULT '0' NOT NULL CHECK (reportee_id >= 0),
0509 log_ip varchar(40) DEFAULT '' NOT NULL,
0510 log_time INT4 DEFAULT '0' NOT NULL CHECK (log_time >= 0),
0511 log_operation varchar(4000) DEFAULT '' NOT NULL,
0512 log_data TEXT DEFAULT '' NOT NULL,
0513 PRIMARY KEY (log_id)
0514 );
0515
0516 CREATE INDEX phpbb_log_log_type ON phpbb_log (log_type);
0517 CREATE INDEX phpbb_log_forum_id ON phpbb_log (forum_id);
0518 CREATE INDEX phpbb_log_topic_id ON phpbb_log (topic_id);
0519 CREATE INDEX phpbb_log_reportee_id ON phpbb_log (reportee_id);
0520 CREATE INDEX phpbb_log_user_id ON phpbb_log (user_id);
0521
0522 /*
0523 Table: 'phpbb_moderator_cache'
0524 */
0525 CREATE TABLE phpbb_moderator_cache (
0526 forum_id INT4 DEFAULT '0' NOT NULL CHECK (forum_id >= 0),
0527 user_id INT4 DEFAULT '0' NOT NULL CHECK (user_id >= 0),
0528 username varchar(255) DEFAULT '' NOT NULL,
0529 group_id INT4 DEFAULT '0' NOT NULL CHECK (group_id >= 0),
0530 group_name varchar(255) DEFAULT '' NOT NULL,
0531 display_on_index INT2 DEFAULT '1' NOT NULL CHECK (display_on_index >= 0)
0532 );
0533
0534 CREATE INDEX phpbb_moderator_cache_disp_idx ON phpbb_moderator_cache (display_on_index);
0535 CREATE INDEX phpbb_moderator_cache_forum_id ON phpbb_moderator_cache (forum_id);
0536
0537 /*
0538 Table: 'phpbb_modules'
0539 */
0540 CREATE SEQUENCE phpbb_modules_seq;
0541
0542 CREATE TABLE phpbb_modules (
0543 module_id INT4 DEFAULT nextval('phpbb_modules_seq'),
0544 module_enabled INT2 DEFAULT '1' NOT NULL CHECK (module_enabled >= 0),
0545 module_display INT2 DEFAULT '1' NOT NULL CHECK (module_display >= 0),
0546 module_basename varchar(255) DEFAULT '' NOT NULL,
0547 module_class varchar(10) DEFAULT '' NOT NULL,
0548 parent_id INT4 DEFAULT '0' NOT NULL CHECK (parent_id >= 0),
0549 left_id INT4 DEFAULT '0' NOT NULL CHECK (left_id >= 0),
0550 right_id INT4 DEFAULT '0' NOT NULL CHECK (right_id >= 0),
0551 module_langname varchar(255) DEFAULT '' NOT NULL,
0552 module_mode varchar(255) DEFAULT '' NOT NULL,
0553 module_auth varchar(255) DEFAULT '' NOT NULL,
0554 PRIMARY KEY (module_id)
0555 );
0556
0557 CREATE INDEX phpbb_modules_left_right_id ON phpbb_modules (left_id, right_id);
0558 CREATE INDEX phpbb_modules_module_enabled ON phpbb_modules (module_enabled);
0559 CREATE INDEX phpbb_modules_class_left_id ON phpbb_modules (module_class, left_id);
0560
0561 /*
0562 Table: 'phpbb_poll_options'
0563 */
0564 CREATE TABLE phpbb_poll_options (
0565 poll_option_id INT2 DEFAULT '0' NOT NULL,
0566 topic_id INT4 DEFAULT '0' NOT NULL CHECK (topic_id >= 0),
0567 poll_option_text varchar(4000) DEFAULT '' NOT NULL,
0568 poll_option_total INT4 DEFAULT '0' NOT NULL CHECK (poll_option_total >= 0)
0569 );
0570
0571 CREATE INDEX phpbb_poll_options_poll_opt_id ON phpbb_poll_options (poll_option_id);
0572 CREATE INDEX phpbb_poll_options_topic_id ON phpbb_poll_options (topic_id);
0573
0574 /*
0575 Table: 'phpbb_poll_votes'
0576 */
0577 CREATE TABLE phpbb_poll_votes (
0578 topic_id INT4 DEFAULT '0' NOT NULL CHECK (topic_id >= 0),
0579 poll_option_id INT2 DEFAULT '0' NOT NULL,
0580 vote_user_id INT4 DEFAULT '0' NOT NULL CHECK (vote_user_id >= 0),
0581 vote_user_ip varchar(40) DEFAULT '' NOT NULL
0582 );
0583
0584 CREATE INDEX phpbb_poll_votes_topic_id ON phpbb_poll_votes (topic_id);
0585 CREATE INDEX phpbb_poll_votes_vote_user_id ON phpbb_poll_votes (vote_user_id);
0586 CREATE INDEX phpbb_poll_votes_vote_user_ip ON phpbb_poll_votes (vote_user_ip);
0587
0588 /*
0589 Table: 'phpbb_posts'
0590 */
0591 CREATE SEQUENCE phpbb_posts_seq;
0592
0593 CREATE TABLE phpbb_posts (
0594 post_id INT4 DEFAULT nextval('phpbb_posts_seq'),
0595 topic_id INT4 DEFAULT '0' NOT NULL CHECK (topic_id >= 0),
0596 forum_id INT4 DEFAULT '0' NOT NULL CHECK (forum_id >= 0),
0597 poster_id INT4 DEFAULT '0' NOT NULL CHECK (poster_id >= 0),
0598 icon_id INT4 DEFAULT '0' NOT NULL CHECK (icon_id >= 0),
0599 poster_ip varchar(40) DEFAULT '' NOT NULL,
0600 post_time INT4 DEFAULT '0' NOT NULL CHECK (post_time >= 0),
0601 post_approved INT2 DEFAULT '1' NOT NULL CHECK (post_approved >= 0),
0602 post_reported INT2 DEFAULT '0' NOT NULL CHECK (post_reported >= 0),
0603 enable_bbcode INT2 DEFAULT '1' NOT NULL CHECK (enable_bbcode >= 0),
0604 enable_smilies INT2 DEFAULT '1' NOT NULL CHECK (enable_smilies >= 0),
0605 enable_magic_url INT2 DEFAULT '1' NOT NULL CHECK (enable_magic_url >= 0),
0606 enable_sig INT2 DEFAULT '1' NOT NULL CHECK (enable_sig >= 0),
0607 post_username varchar(255) DEFAULT '' NOT NULL,
0608 post_subject varchar(100) DEFAULT '' NOT NULL,
0609 post_text TEXT DEFAULT '' NOT NULL,
0610 post_checksum varchar(32) DEFAULT '' NOT NULL,
0611 post_attachment INT2 DEFAULT '0' NOT NULL CHECK (post_attachment >= 0),
0612 bbcode_bitfield varchar(255) DEFAULT '' NOT NULL,
0613 bbcode_uid varchar(8) DEFAULT '' NOT NULL,
0614 post_postcount INT2 DEFAULT '1' NOT NULL CHECK (post_postcount >= 0),
0615 post_edit_time INT4 DEFAULT '0' NOT NULL CHECK (post_edit_time >= 0),
0616 post_edit_reason varchar(255) DEFAULT '' NOT NULL,
0617 post_edit_user INT4 DEFAULT '0' NOT NULL CHECK (post_edit_user >= 0),
0618 post_edit_count INT2 DEFAULT '0' NOT NULL CHECK (post_edit_count >= 0),
0619 post_edit_locked INT2 DEFAULT '0' NOT NULL CHECK (post_edit_locked >= 0),
0620 PRIMARY KEY (post_id)
0621 );
0622
0623 CREATE INDEX phpbb_posts_forum_id ON phpbb_posts (forum_id);
0624 CREATE INDEX phpbb_posts_topic_id ON phpbb_posts (topic_id);
0625 CREATE INDEX phpbb_posts_poster_ip ON phpbb_posts (poster_ip);
0626 CREATE INDEX phpbb_posts_poster_id ON phpbb_posts (poster_id);
0627 CREATE INDEX phpbb_posts_post_approved ON phpbb_posts (post_approved);
0628 CREATE INDEX phpbb_posts_tid_post_time ON phpbb_posts (topic_id, post_time);
0629
0630 /*
0631 Table: 'phpbb_privmsgs'
0632 */
0633 CREATE SEQUENCE phpbb_privmsgs_seq;
0634
0635 CREATE TABLE phpbb_privmsgs (
0636 msg_id INT4 DEFAULT nextval('phpbb_privmsgs_seq'),
0637 root_level INT4 DEFAULT '0' NOT NULL CHECK (root_level >= 0),
0638 author_id INT4 DEFAULT '0' NOT NULL CHECK (author_id >= 0),
0639 icon_id INT4 DEFAULT '0' NOT NULL CHECK (icon_id >= 0),
0640 author_ip varchar(40) DEFAULT '' NOT NULL,
0641 message_time INT4 DEFAULT '0' NOT NULL CHECK (message_time >= 0),
0642 enable_bbcode INT2 DEFAULT '1' NOT NULL CHECK (enable_bbcode >= 0),
0643 enable_smilies INT2 DEFAULT '1' NOT NULL CHECK (enable_smilies >= 0),
0644 enable_magic_url INT2 DEFAULT '1' NOT NULL CHECK (enable_magic_url >= 0),
0645 enable_sig INT2 DEFAULT '1' NOT NULL CHECK (enable_sig >= 0),
0646 message_subject varchar(100) DEFAULT '' NOT NULL,
0647 message_text TEXT DEFAULT '' NOT NULL,
0648 message_edit_reason varchar(255) DEFAULT '' NOT NULL,
0649 message_edit_user INT4 DEFAULT '0' NOT NULL CHECK (message_edit_user >= 0),
0650 message_attachment INT2 DEFAULT '0' NOT NULL CHECK (message_attachment >= 0),
0651 bbcode_bitfield varchar(255) DEFAULT '' NOT NULL,
0652 bbcode_uid varchar(8) DEFAULT '' NOT NULL,
0653 message_edit_time INT4 DEFAULT '0' NOT NULL CHECK (message_edit_time >= 0),
0654 message_edit_count INT2 DEFAULT '0' NOT NULL CHECK (message_edit_count >= 0),
0655 to_address varchar(4000) DEFAULT '' NOT NULL,
0656 bcc_address varchar(4000) DEFAULT '' NOT NULL,
0657 PRIMARY KEY (msg_id)
0658 );
0659
0660 CREATE INDEX phpbb_privmsgs_author_ip ON phpbb_privmsgs (author_ip);
0661 CREATE INDEX phpbb_privmsgs_message_time ON phpbb_privmsgs (message_time);
0662 CREATE INDEX phpbb_privmsgs_author_id ON phpbb_privmsgs (author_id);
0663 CREATE INDEX phpbb_privmsgs_root_level ON phpbb_privmsgs (root_level);
0664
0665 /*
0666 Table: 'phpbb_privmsgs_folder'
0667 */
0668 CREATE SEQUENCE phpbb_privmsgs_folder_seq;
0669
0670 CREATE TABLE phpbb_privmsgs_folder (
0671 folder_id INT4 DEFAULT nextval('phpbb_privmsgs_folder_seq'),
0672 user_id INT4 DEFAULT '0' NOT NULL CHECK (user_id >= 0),
0673 folder_name varchar(255) DEFAULT '' NOT NULL,
0674 pm_count INT4 DEFAULT '0' NOT NULL CHECK (pm_count >= 0),
0675 PRIMARY KEY (folder_id)
0676 );
0677
0678 CREATE INDEX phpbb_privmsgs_folder_user_id ON phpbb_privmsgs_folder (user_id);
0679
0680 /*
0681 Table: 'phpbb_privmsgs_rules'
0682 */
0683 CREATE SEQUENCE phpbb_privmsgs_rules_seq;
0684
0685 CREATE TABLE phpbb_privmsgs_rules (
0686 rule_id INT4 DEFAULT nextval('phpbb_privmsgs_rules_seq'),
0687 user_id INT4 DEFAULT '0' NOT NULL CHECK (user_id >= 0),
0688 rule_check INT4 DEFAULT '0' NOT NULL CHECK (rule_check >= 0),
0689 rule_connection INT4 DEFAULT '0' NOT NULL CHECK (rule_connection >= 0),
0690 rule_string varchar(255) DEFAULT '' NOT NULL,
0691 rule_user_id INT4 DEFAULT '0' NOT NULL CHECK (rule_user_id >= 0),
0692 rule_group_id INT4 DEFAULT '0' NOT NULL CHECK (rule_group_id >= 0),
0693 rule_action INT4 DEFAULT '0' NOT NULL CHECK (rule_action >= 0),
0694 rule_folder_id INT4 DEFAULT '0' NOT NULL,
0695 PRIMARY KEY (rule_id)
0696 );
0697
0698 CREATE INDEX phpbb_privmsgs_rules_user_id ON phpbb_privmsgs_rules (user_id);
0699
0700 /*
0701 Table: 'phpbb_privmsgs_to'
0702 */
0703 CREATE TABLE phpbb_privmsgs_to (
0704 msg_id INT4 DEFAULT '0' NOT NULL CHECK (msg_id >= 0),
0705 user_id INT4 DEFAULT '0' NOT NULL CHECK (user_id >= 0),
0706 author_id INT4 DEFAULT '0' NOT NULL CHECK (author_id >= 0),
0707 pm_deleted INT2 DEFAULT '0' NOT NULL CHECK (pm_deleted >= 0),
0708 pm_new INT2 DEFAULT '1' NOT NULL CHECK (pm_new >= 0),
0709 pm_unread INT2 DEFAULT '1' NOT NULL CHECK (pm_unread >= 0),
0710 pm_replied INT2 DEFAULT '0' NOT NULL CHECK (pm_replied >= 0),
0711 pm_marked INT2 DEFAULT '0' NOT NULL CHECK (pm_marked >= 0),
0712 pm_forwarded INT2 DEFAULT '0' NOT NULL CHECK (pm_forwarded >= 0),
0713 folder_id INT4 DEFAULT '0' NOT NULL
0714 );
0715
0716 CREATE INDEX phpbb_privmsgs_to_msg_id ON phpbb_privmsgs_to (msg_id);
0717 CREATE INDEX phpbb_privmsgs_to_author_id ON phpbb_privmsgs_to (author_id);
0718 CREATE INDEX phpbb_privmsgs_to_usr_flder_id ON phpbb_privmsgs_to (user_id, folder_id);
0719
0720 /*
0721 Table: 'phpbb_profile_fields'
0722 */
0723 CREATE SEQUENCE phpbb_profile_fields_seq;
0724
0725 CREATE TABLE phpbb_profile_fields (
0726 field_id INT4 DEFAULT nextval('phpbb_profile_fields_seq'),
0727 field_name varchar(255) DEFAULT '' NOT NULL,
0728 field_type INT2 DEFAULT '0' NOT NULL,
0729 field_ident varchar(20) DEFAULT '' NOT NULL,
0730 field_length varchar(20) DEFAULT '' NOT NULL,
0731 field_minlen varchar(255) DEFAULT '' NOT NULL,
0732 field_maxlen varchar(255) DEFAULT '' NOT NULL,
0733 field_novalue varchar(255) DEFAULT '' NOT NULL,
0734 field_default_value varchar(255) DEFAULT '' NOT NULL,
0735 field_validation varchar(20) DEFAULT '' NOT NULL,
0736 field_required INT2 DEFAULT '0' NOT NULL CHECK (field_required >= 0),
0737 field_show_on_reg INT2 DEFAULT '0' NOT NULL CHECK (field_show_on_reg >= 0),
0738 field_hide INT2 DEFAULT '0' NOT NULL CHECK (field_hide >= 0),
0739 field_no_view INT2 DEFAULT '0' NOT NULL CHECK (field_no_view >= 0),
0740 field_active INT2 DEFAULT '0' NOT NULL CHECK (field_active >= 0),
0741 field_order INT4 DEFAULT '0' NOT NULL CHECK (field_order >= 0),
0742 PRIMARY KEY (field_id)
0743 );
0744
0745 CREATE INDEX phpbb_profile_fields_fld_type ON phpbb_profile_fields (field_type);
0746 CREATE INDEX phpbb_profile_fields_fld_ordr ON phpbb_profile_fields (field_order);
0747
0748 /*
0749 Table: 'phpbb_profile_fields_data'
0750 */
0751 CREATE TABLE phpbb_profile_fields_data (
0752 user_id INT4 DEFAULT '0' NOT NULL CHECK (user_id >= 0),
0753 PRIMARY KEY (user_id)
0754 );
0755
0756
0757 /*
0758 Table: 'phpbb_profile_fields_lang'
0759 */
0760 CREATE TABLE phpbb_profile_fields_lang (
0761 field_id INT4 DEFAULT '0' NOT NULL CHECK (field_id >= 0),
0762 lang_id INT4 DEFAULT '0' NOT NULL CHECK (lang_id >= 0),
0763 option_id INT4 DEFAULT '0' NOT NULL CHECK (option_id >= 0),
0764 field_type INT2 DEFAULT '0' NOT NULL,
0765 lang_value varchar(255) DEFAULT '' NOT NULL,
0766 PRIMARY KEY (field_id, lang_id, option_id)
0767 );
0768
0769
0770 /*
0771 Table: 'phpbb_profile_lang'
0772 */
0773 CREATE TABLE phpbb_profile_lang (
0774 field_id INT4 DEFAULT '0' NOT NULL CHECK (field_id >= 0),
0775 lang_id INT4 DEFAULT '0' NOT NULL CHECK (lang_id >= 0),
0776 lang_name varchar(255) DEFAULT '' NOT NULL,
0777 lang_explain varchar(4000) DEFAULT '' NOT NULL,
0778 lang_default_value varchar(255) DEFAULT '' NOT NULL,
0779 PRIMARY KEY (field_id, lang_id)
0780 );
0781
0782
0783 /*
0784 Table: 'phpbb_ranks'
0785 */
0786 CREATE SEQUENCE phpbb_ranks_seq;
0787
0788 CREATE TABLE phpbb_ranks (
0789 rank_id INT4 DEFAULT nextval('phpbb_ranks_seq'),
0790 rank_title varchar(255) DEFAULT '' NOT NULL,
0791 rank_min INT4 DEFAULT '0' NOT NULL CHECK (rank_min >= 0),
0792 rank_special INT2 DEFAULT '0' NOT NULL CHECK (rank_special >= 0),
0793 rank_image varchar(255) DEFAULT '' NOT NULL,
0794 PRIMARY KEY (rank_id)
0795 );
0796
0797
0798 /*
0799 Table: 'phpbb_reports'
0800 */
0801 CREATE SEQUENCE phpbb_reports_seq;
0802
0803 CREATE TABLE phpbb_reports (
0804 report_id INT4 DEFAULT nextval('phpbb_reports_seq'),
0805 reason_id INT2 DEFAULT '0' NOT NULL CHECK (reason_id >= 0),
0806 post_id INT4 DEFAULT '0' NOT NULL CHECK (post_id >= 0),
0807 user_id INT4 DEFAULT '0' NOT NULL CHECK (user_id >= 0),
0808 user_notify INT2 DEFAULT '0' NOT NULL CHECK (user_notify >= 0),
0809 report_closed INT2 DEFAULT '0' NOT NULL CHECK (report_closed >= 0),
0810 report_time INT4 DEFAULT '0' NOT NULL CHECK (report_time >= 0),
0811 report_text TEXT DEFAULT '' NOT NULL,
0812 PRIMARY KEY (report_id)
0813 );
0814
0815
0816 /*
0817 Table: 'phpbb_reports_reasons'
0818 */
0819 CREATE SEQUENCE phpbb_reports_reasons_seq;
0820
0821 CREATE TABLE phpbb_reports_reasons (
0822 reason_id INT2 DEFAULT nextval('phpbb_reports_reasons_seq'),
0823 reason_title varchar(255) DEFAULT '' NOT NULL,
0824 reason_description TEXT DEFAULT '' NOT NULL,
0825 reason_order INT2 DEFAULT '0' NOT NULL CHECK (reason_order >= 0),
0826 PRIMARY KEY (reason_id)
0827 );
0828
0829
0830 /*
0831 Table: 'phpbb_search_results'
0832 */
0833 CREATE TABLE phpbb_search_results (
0834 search_key varchar(32) DEFAULT '' NOT NULL,
0835 search_time INT4 DEFAULT '0' NOT NULL CHECK (search_time >= 0),
0836 search_keywords TEXT DEFAULT '' NOT NULL,
0837 search_authors TEXT DEFAULT '' NOT NULL,
0838 PRIMARY KEY (search_key)
0839 );
0840
0841
0842 /*
0843 Table: 'phpbb_search_wordlist'
0844 */
0845 CREATE SEQUENCE phpbb_search_wordlist_seq;
0846
0847 CREATE TABLE phpbb_search_wordlist (
0848 word_id INT4 DEFAULT nextval('phpbb_search_wordlist_seq'),
0849 word_text varchar(255) DEFAULT '' NOT NULL,
0850 word_common INT2 DEFAULT '0' NOT NULL CHECK (word_common >= 0),
0851 word_count INT4 DEFAULT '0' NOT NULL CHECK (word_count >= 0),
0852 PRIMARY KEY (word_id)
0853 );
0854
0855 CREATE UNIQUE INDEX phpbb_search_wordlist_wrd_txt ON phpbb_search_wordlist (word_text);
0856 CREATE INDEX phpbb_search_wordlist_wrd_cnt ON phpbb_search_wordlist (word_count);
0857
0858 /*
0859 Table: 'phpbb_search_wordmatch'
0860 */
0861 CREATE TABLE phpbb_search_wordmatch (
0862 post_id INT4 DEFAULT '0' NOT NULL CHECK (post_id >= 0),
0863 word_id INT4 DEFAULT '0' NOT NULL CHECK (word_id >= 0),
0864 title_match INT2 DEFAULT '0' NOT NULL CHECK (title_match >= 0)
0865 );
0866
0867 CREATE UNIQUE INDEX phpbb_search_wordmatch_unq_mtch ON phpbb_search_wordmatch (word_id, post_id, title_match);
0868 CREATE INDEX phpbb_search_wordmatch_word_id ON phpbb_search_wordmatch (word_id);
0869 CREATE INDEX phpbb_search_wordmatch_post_id ON phpbb_search_wordmatch (post_id);
0870
0871 /*
0872 Table: 'phpbb_sessions'
0873 */
0874 CREATE TABLE phpbb_sessions (
0875 session_id char(32) DEFAULT '' NOT NULL,
0876 session_user_id INT4 DEFAULT '0' NOT NULL CHECK (session_user_id >= 0),
0877 session_last_visit INT4 DEFAULT '0' NOT NULL CHECK (session_last_visit >= 0),
0878 session_start INT4 DEFAULT '0' NOT NULL CHECK (session_start >= 0),
0879 session_time INT4 DEFAULT '0' NOT NULL CHECK (session_time >= 0),
0880 session_ip varchar(40) DEFAULT '' NOT NULL,
0881 session_browser varchar(150) DEFAULT '' NOT NULL,
0882 session_forwarded_for varchar(255) DEFAULT '' NOT NULL,
0883 session_page varchar(255) DEFAULT '' NOT NULL,
0884 session_viewonline INT2 DEFAULT '1' NOT NULL CHECK (session_viewonline >= 0),
0885 session_autologin INT2 DEFAULT '0' NOT NULL CHECK (session_autologin >= 0),
0886 session_admin INT2 DEFAULT '0' NOT NULL CHECK (session_admin >= 0),
0887 PRIMARY KEY (session_id)
0888 );
0889
0890 CREATE INDEX phpbb_sessions_session_time ON phpbb_sessions (session_time);
0891 CREATE INDEX phpbb_sessions_session_user_id ON phpbb_sessions (session_user_id);
0892
0893 /*
0894 Table: 'phpbb_sessions_keys'
0895 */
0896 CREATE TABLE phpbb_sessions_keys (
0897 key_id char(32) DEFAULT '' NOT NULL,
0898 user_id INT4 DEFAULT '0' NOT NULL CHECK (user_id >= 0),
0899 last_ip varchar(40) DEFAULT '' NOT NULL,
0900 last_login INT4 DEFAULT '0' NOT NULL CHECK (last_login >= 0),
0901 PRIMARY KEY (key_id, user_id)
0902 );
0903
0904 CREATE INDEX phpbb_sessions_keys_last_login ON phpbb_sessions_keys (last_login);
0905
0906 /*
0907 Table: 'phpbb_sitelist'
0908 */
0909 CREATE SEQUENCE phpbb_sitelist_seq;
0910
0911 CREATE TABLE phpbb_sitelist (
0912 site_id INT4 DEFAULT nextval('phpbb_sitelist_seq'),
0913 site_ip varchar(40) DEFAULT '' NOT NULL,
0914 site_hostname varchar(255) DEFAULT '' NOT NULL,
0915 ip_exclude INT2 DEFAULT '0' NOT NULL CHECK (ip_exclude >= 0),
0916 PRIMARY KEY (site_id)
0917 );
0918
0919
0920 /*
0921 Table: 'phpbb_smilies'
0922 */
0923 CREATE SEQUENCE phpbb_smilies_seq;
0924
0925 CREATE TABLE phpbb_smilies (
0926 smiley_id INT4 DEFAULT nextval('phpbb_smilies_seq'),
0927 code varchar(50) DEFAULT '' NOT NULL,
0928 emotion varchar(50) DEFAULT '' NOT NULL,
0929 smiley_url varchar(50) DEFAULT '' NOT NULL,
0930 smiley_width INT2 DEFAULT '0' NOT NULL CHECK (smiley_width >= 0),
0931 smiley_height INT2 DEFAULT '0' NOT NULL CHECK (smiley_height >= 0),
0932 smiley_order INT4 DEFAULT '0' NOT NULL CHECK (smiley_order >= 0),
0933 display_on_posting INT2 DEFAULT '1' NOT NULL CHECK (display_on_posting >= 0),
0934 PRIMARY KEY (smiley_id)
0935 );
0936
0937 CREATE INDEX phpbb_smilies_display_on_post ON phpbb_smilies (display_on_posting);
0938
0939 /*
0940 Table: 'phpbb_styles'
0941 */
0942 CREATE SEQUENCE phpbb_styles_seq;
0943
0944 CREATE TABLE phpbb_styles (
0945 style_id INT2 DEFAULT nextval('phpbb_styles_seq'),
0946 style_name varchar(255) DEFAULT '' NOT NULL,
0947 style_copyright varchar(255) DEFAULT '' NOT NULL,
0948 style_active INT2 DEFAULT '1' NOT NULL CHECK (style_active >= 0),
0949 template_id INT2 DEFAULT '0' NOT NULL CHECK (template_id >= 0),
0950 theme_id INT2 DEFAULT '0' NOT NULL CHECK (theme_id >= 0),
0951 imageset_id INT2 DEFAULT '0' NOT NULL CHECK (imageset_id >= 0),
0952 PRIMARY KEY (style_id)
0953 );
0954
0955 CREATE UNIQUE INDEX phpbb_styles_style_name ON phpbb_styles (style_name);
0956 CREATE INDEX phpbb_styles_template_id ON phpbb_styles (template_id);
0957 CREATE INDEX phpbb_styles_theme_id ON phpbb_styles (theme_id);
0958 CREATE INDEX phpbb_styles_imageset_id ON phpbb_styles (imageset_id);
0959
0960 /*
0961 Table: 'phpbb_styles_template'
0962 */
0963 CREATE SEQUENCE phpbb_styles_template_seq;
0964
0965 CREATE TABLE phpbb_styles_template (
0966 template_id INT2 DEFAULT nextval('phpbb_styles_template_seq'),
0967 template_name varchar(255) DEFAULT '' NOT NULL,
0968 template_copyright varchar(255) DEFAULT '' NOT NULL,
0969 template_path varchar(100) DEFAULT '' NOT NULL,
0970 bbcode_bitfield varchar(255) DEFAULT 'kNg=' NOT NULL,
0971 template_storedb INT2 DEFAULT '0' NOT NULL CHECK (template_storedb >= 0),
0972 PRIMARY KEY (template_id)
0973 );
0974
0975 CREATE UNIQUE INDEX phpbb_styles_template_tmplte_nm ON phpbb_styles_template (template_name);
0976
0977 /*
0978 Table: 'phpbb_styles_template_data'
0979 */
0980 CREATE TABLE phpbb_styles_template_data (
0981 template_id INT2 DEFAULT '0' NOT NULL CHECK (template_id >= 0),
0982 template_filename varchar(100) DEFAULT '' NOT NULL,
0983 template_included varchar(8000) DEFAULT '' NOT NULL,
0984 template_mtime INT4 DEFAULT '0' NOT NULL CHECK (template_mtime >= 0),
0985 template_data TEXT DEFAULT '' NOT NULL
0986 );
0987
0988 CREATE INDEX phpbb_styles_template_data_tid ON phpbb_styles_template_data (template_id);
0989 CREATE INDEX phpbb_styles_template_data_tfn ON phpbb_styles_template_data (template_filename);
0990
0991 /*
0992 Table: 'phpbb_styles_theme'
0993 */
0994 CREATE SEQUENCE phpbb_styles_theme_seq;
0995
0996 CREATE TABLE phpbb_styles_theme (
0997 theme_id INT2 DEFAULT nextval('phpbb_styles_theme_seq'),
0998 theme_name varchar(255) DEFAULT '' NOT NULL,
0999 theme_copyright varchar(255) DEFAULT '' NOT NULL,
1000 theme_path varchar(100) DEFAULT '' NOT NULL,
1001 theme_storedb INT2 DEFAULT '0' NOT NULL CHECK (theme_storedb >= 0),
1002 theme_mtime INT4 DEFAULT '0' NOT NULL CHECK (theme_mtime >= 0),
1003 theme_data TEXT DEFAULT '' NOT NULL,
1004 PRIMARY KEY (theme_id)
1005 );
1006
1007 CREATE UNIQUE INDEX phpbb_styles_theme_theme_name ON phpbb_styles_theme (theme_name);
1008
1009 /*
1010 Table: 'phpbb_styles_imageset'
1011 */
1012 CREATE SEQUENCE phpbb_styles_imageset_seq;
1013
1014 CREATE TABLE phpbb_styles_imageset (
1015 imageset_id INT2 DEFAULT nextval('phpbb_styles_imageset_seq'),
1016 imageset_name varchar(255) DEFAULT '' NOT NULL,
1017 imageset_copyright varchar(255) DEFAULT '' NOT NULL,
1018 imageset_path varchar(100) DEFAULT '' NOT NULL,
1019 PRIMARY KEY (imageset_id)
1020 );
1021
1022 CREATE UNIQUE INDEX phpbb_styles_imageset_imgset_nm ON phpbb_styles_imageset (imageset_name);
1023
1024 /*
1025 Table: 'phpbb_styles_imageset_data'
1026 */
1027 CREATE SEQUENCE phpbb_styles_imageset_data_seq;
1028
1029 CREATE TABLE phpbb_styles_imageset_data (
1030 image_id INT2 DEFAULT nextval('phpbb_styles_imageset_data_seq'),
1031 image_name varchar(200) DEFAULT '' NOT NULL,
1032 image_filename varchar(200) DEFAULT '' NOT NULL,
1033 image_lang varchar(30) DEFAULT '' NOT NULL,
1034 image_height INT2 DEFAULT '0' NOT NULL CHECK (image_height >= 0),
1035 image_width INT2 DEFAULT '0' NOT NULL CHECK (image_width >= 0),
1036 imageset_id INT2 DEFAULT '0' NOT NULL CHECK (imageset_id >= 0),
1037 PRIMARY KEY (image_id)
1038 );
1039
1040 CREATE INDEX phpbb_styles_imageset_data_i_d ON phpbb_styles_imageset_data (imageset_id);
1041
1042 /*
1043 Table: 'phpbb_topics'
1044 */
1045 CREATE SEQUENCE phpbb_topics_seq;
1046
1047 CREATE TABLE phpbb_topics (
1048 topic_id INT4 DEFAULT nextval('phpbb_topics_seq'),
1049 forum_id INT4 DEFAULT '0' NOT NULL CHECK (forum_id >= 0),
1050 icon_id INT4 DEFAULT '0' NOT NULL CHECK (icon_id >= 0),
1051 topic_attachment INT2 DEFAULT '0' NOT NULL CHECK (topic_attachment >= 0),
1052 topic_approved INT2 DEFAULT '1' NOT NULL CHECK (topic_approved >= 0),
1053 topic_reported INT2 DEFAULT '0' NOT NULL CHECK (topic_reported >= 0),
1054 topic_title varchar(100) DEFAULT '' NOT NULL,
1055 topic_poster INT4 DEFAULT '0' NOT NULL CHECK (topic_poster >= 0),
1056 topic_time INT4 DEFAULT '0' NOT NULL CHECK (topic_time >= 0),
1057 topic_time_limit INT4 DEFAULT '0' NOT NULL CHECK (topic_time_limit >= 0),
1058 topic_views INT4 DEFAULT '0' NOT NULL CHECK (topic_views >= 0),
1059 topic_replies INT4 DEFAULT '0' NOT NULL CHECK (topic_replies >= 0),
1060 topic_replies_real INT4 DEFAULT '0' NOT NULL CHECK (topic_replies_real >= 0),
1061 topic_status INT2 DEFAULT '0' NOT NULL,
1062 topic_type INT2 DEFAULT '0' NOT NULL,
1063 topic_first_post_id INT4 DEFAULT '0' NOT NULL CHECK (topic_first_post_id >= 0),
1064 topic_first_poster_name varchar(255) DEFAULT '' NOT NULL,
1065 topic_first_poster_colour varchar(6) DEFAULT '' NOT NULL,
1066 topic_last_post_id INT4 DEFAULT '0' NOT NULL CHECK (topic_last_post_id >= 0),
1067 topic_last_poster_id INT4 DEFAULT '0' NOT NULL CHECK (topic_last_poster_id >= 0),
1068 topic_last_poster_name varchar(255) DEFAULT '' NOT NULL,
1069 topic_last_poster_colour varchar(6) DEFAULT '' NOT NULL,
1070 topic_last_post_subject varchar(100) DEFAULT '' NOT NULL,
1071 topic_last_post_time INT4 DEFAULT '0' NOT NULL CHECK (topic_last_post_time >= 0),
1072 topic_last_view_time INT4 DEFAULT '0' NOT NULL CHECK (topic_last_view_time >= 0),
1073 topic_moved_id INT4 DEFAULT '0' NOT NULL CHECK (topic_moved_id >= 0),
1074 topic_bumped INT2 DEFAULT '0' NOT NULL CHECK (topic_bumped >= 0),
1075 topic_bumper INT4 DEFAULT '0' NOT NULL CHECK (topic_bumper >= 0),
1076 poll_title varchar(255) DEFAULT '' NOT NULL,
1077 poll_start INT4 DEFAULT '0' NOT NULL CHECK (poll_start >= 0),
1078 poll_length INT4 DEFAULT '0' NOT NULL CHECK (poll_length >= 0),
1079 poll_max_options INT2 DEFAULT '1' NOT NULL,
1080 poll_last_vote INT4 DEFAULT '0' NOT NULL CHECK (poll_last_vote >= 0),
1081 poll_vote_change INT2 DEFAULT '0' NOT NULL CHECK (poll_vote_change >= 0),
1082 PRIMARY KEY (topic_id)
1083 );
1084
1085 CREATE INDEX phpbb_topics_forum_id ON phpbb_topics (forum_id);
1086 CREATE INDEX phpbb_topics_forum_id_type ON phpbb_topics (forum_id, topic_type);
1087 CREATE INDEX phpbb_topics_last_post_time ON phpbb_topics (topic_last_post_time);
1088 CREATE INDEX phpbb_topics_topic_approved ON phpbb_topics (topic_approved);
1089 CREATE INDEX phpbb_topics_forum_appr_last ON phpbb_topics (forum_id, topic_approved, topic_last_post_id);
1090 CREATE INDEX phpbb_topics_fid_time_moved ON phpbb_topics (forum_id, topic_last_post_time, topic_moved_id);
1091
1092 /*
1093 Table: 'phpbb_topics_track'
1094 */
1095 CREATE TABLE phpbb_topics_track (
1096 user_id INT4 DEFAULT '0' NOT NULL CHECK (user_id >= 0),
1097 topic_id INT4 DEFAULT '0' NOT NULL CHECK (topic_id >= 0),
1098 forum_id INT4 DEFAULT '0' NOT NULL CHECK (forum_id >= 0),
1099 mark_time INT4 DEFAULT '0' NOT NULL CHECK (mark_time >= 0),
1100 PRIMARY KEY (user_id, topic_id)
1101 );
1102
1103 CREATE INDEX phpbb_topics_track_forum_id ON phpbb_topics_track (forum_id);
1104
1105 /*
1106 Table: 'phpbb_topics_posted'
1107 */
1108 CREATE TABLE phpbb_topics_posted (
1109 user_id INT4 DEFAULT '0' NOT NULL CHECK (user_id >= 0),
1110 topic_id INT4 DEFAULT '0' NOT NULL CHECK (topic_id >= 0),
1111 topic_posted INT2 DEFAULT '0' NOT NULL CHECK (topic_posted >= 0),
1112 PRIMARY KEY (user_id, topic_id)
1113 );
1114
1115
1116 /*
1117 Table: 'phpbb_topics_watch'
1118 */
1119 CREATE TABLE phpbb_topics_watch (
1120 topic_id INT4 DEFAULT '0' NOT NULL CHECK (topic_id >= 0),
1121 user_id INT4 DEFAULT '0' NOT NULL CHECK (user_id >= 0),
1122 notify_status INT2 DEFAULT '0' NOT NULL CHECK (notify_status >= 0)
1123 );
1124
1125 CREATE INDEX phpbb_topics_watch_topic_id ON phpbb_topics_watch (topic_id);
1126 CREATE INDEX phpbb_topics_watch_user_id ON phpbb_topics_watch (user_id);
1127 CREATE INDEX phpbb_topics_watch_notify_stat ON phpbb_topics_watch (notify_status);
1128
1129 /*
1130 Table: 'phpbb_user_group'
1131 */
1132 CREATE TABLE phpbb_user_group (
1133 group_id INT4 DEFAULT '0' NOT NULL CHECK (group_id >= 0),
1134 user_id INT4 DEFAULT '0' NOT NULL CHECK (user_id >= 0),
1135 group_leader INT2 DEFAULT '0' NOT NULL CHECK (group_leader >= 0),
1136 user_pending INT2 DEFAULT '1' NOT NULL CHECK (user_pending >= 0)
1137 );
1138
1139 CREATE INDEX phpbb_user_group_group_id ON phpbb_user_group (group_id);
1140 CREATE INDEX phpbb_user_group_user_id ON phpbb_user_group (user_id);
1141 CREATE INDEX phpbb_user_group_group_leader ON phpbb_user_group (group_leader);
1142
1143 /*
1144 Table: 'phpbb_users'
1145 */
1146 CREATE SEQUENCE phpbb_users_seq;
1147
1148 CREATE TABLE phpbb_users (
1149 user_id INT4 DEFAULT nextval('phpbb_users_seq'),
1150 user_type INT2 DEFAULT '0' NOT NULL,
1151 group_id INT4 DEFAULT '3' NOT NULL CHECK (group_id >= 0),
1152 user_permissions TEXT DEFAULT '' NOT NULL,
1153 user_perm_from INT4 DEFAULT '0' NOT NULL CHECK (user_perm_from >= 0),
1154 user_ip varchar(40) DEFAULT '' NOT NULL,
1155 user_regdate INT4 DEFAULT '0' NOT NULL CHECK (user_regdate >= 0),
1156 username varchar_ci DEFAULT '' NOT NULL,
1157 username_clean varchar_ci DEFAULT '' NOT NULL,
1158 user_password varchar(40) DEFAULT '' NOT NULL,
1159 user_passchg INT4 DEFAULT '0' NOT NULL CHECK (user_passchg >= 0),
1160 user_pass_convert INT2 DEFAULT '0' NOT NULL CHECK (user_pass_convert >= 0),
1161 user_email varchar(100) DEFAULT '' NOT NULL,
1162 user_email_hash INT8 DEFAULT '0' NOT NULL,
1163 user_birthday varchar(10) DEFAULT '' NOT NULL,
1164 user_lastvisit INT4 DEFAULT '0' NOT NULL CHECK (user_lastvisit >= 0),
1165 user_lastmark INT4 DEFAULT '0' NOT NULL CHECK (user_lastmark >= 0),
1166 user_lastpost_time INT4 DEFAULT '0' NOT NULL CHECK (user_lastpost_time >= 0),
1167 user_lastpage varchar(200) DEFAULT '' NOT NULL,
1168 user_last_confirm_key varchar(10) DEFAULT '' NOT NULL,
1169 user_last_search INT4 DEFAULT '0' NOT NULL CHECK (user_last_search >= 0),
1170 user_warnings INT2 DEFAULT '0' NOT NULL,
1171 user_last_warning INT4 DEFAULT '0' NOT NULL CHECK (user_last_warning >= 0),
1172 user_login_attempts INT2 DEFAULT '0' NOT NULL,
1173 user_inactive_reason INT2 DEFAULT '0' NOT NULL,
1174 user_inactive_time INT4 DEFAULT '0' NOT NULL CHECK (user_inactive_time >= 0),
1175 user_posts INT4 DEFAULT '0' NOT NULL CHECK (user_posts >= 0),
1176 user_lang varchar(30) DEFAULT '' NOT NULL,
1177 user_timezone decimal(5,2) DEFAULT '0' NOT NULL,
1178 user_dst INT2 DEFAULT '0' NOT NULL CHECK (user_dst >= 0),
1179 user_dateformat varchar(30) DEFAULT 'd M Y H:i' NOT NULL,
1180 user_style INT2 DEFAULT '0' NOT NULL CHECK (user_style >= 0),
1181 user_rank INT4 DEFAULT '0' NOT NULL CHECK (user_rank >= 0),
1182 user_colour varchar(6) DEFAULT '' NOT NULL,
1183 user_new_privmsg INT4 DEFAULT '0' NOT NULL,
1184 user_unread_privmsg INT4 DEFAULT '0' NOT NULL,
1185 user_last_privmsg INT4 DEFAULT '0' NOT NULL CHECK (user_last_privmsg >= 0),
1186 user_message_rules INT2 DEFAULT '0' NOT NULL CHECK (user_message_rules >= 0),
1187 user_full_folder INT4 DEFAULT '-3' NOT NULL,
1188 user_emailtime INT4 DEFAULT '0' NOT NULL CHECK (user_emailtime >= 0),
1189 user_topic_show_days INT2 DEFAULT '0' NOT NULL CHECK (user_topic_show_days >= 0),
1190 user_topic_sortby_type varchar(1) DEFAULT 't' NOT NULL,
1191 user_topic_sortby_dir varchar(1) DEFAULT 'd' NOT NULL,
1192 user_post_show_days INT2 DEFAULT '0' NOT NULL CHECK (user_post_show_days >= 0),
1193 user_post_sortby_type varchar(1) DEFAULT 't' NOT NULL,
1194 user_post_sortby_dir varchar(1) DEFAULT 'a' NOT NULL,
1195 user_notify INT2 DEFAULT '0' NOT NULL CHECK (user_notify >= 0),
1196 user_notify_pm INT2 DEFAULT '1' NOT NULL CHECK (user_notify_pm >= 0),
1197 user_notify_type INT2 DEFAULT '0' NOT NULL,
1198 user_allow_pm INT2 DEFAULT '1' NOT NULL CHECK (user_allow_pm >= 0),
1199 user_allow_viewonline INT2 DEFAULT '1' NOT NULL CHECK (user_allow_viewonline >= 0),
1200 user_allow_viewemail INT2 DEFAULT '1' NOT NULL CHECK (user_allow_viewemail >= 0),
1201 user_allow_massemail INT2 DEFAULT '1' NOT NULL CHECK (user_allow_massemail >= 0),
1202 user_options INT4 DEFAULT '895' NOT NULL CHECK (user_options >= 0),
1203 user_avatar varchar(255) DEFAULT '' NOT NULL,
1204 user_avatar_type INT2 DEFAULT '0' NOT NULL,
1205 user_avatar_width INT2 DEFAULT '0' NOT NULL CHECK (user_avatar_width >= 0),
1206 user_avatar_height INT2 DEFAULT '0' NOT NULL CHECK (user_avatar_height >= 0),
1207 user_sig TEXT DEFAULT '' NOT NULL,
1208 user_sig_bbcode_uid varchar(8) DEFAULT '' NOT NULL,
1209 user_sig_bbcode_bitfield varchar(255) DEFAULT '' NOT NULL,
1210 user_from varchar(100) DEFAULT '' NOT NULL,
1211 user_icq varchar(15) DEFAULT '' NOT NULL,
1212 user_aim varchar(255) DEFAULT '' NOT NULL,
1213 user_yim varchar(255) DEFAULT '' NOT NULL,
1214 user_msnm varchar(255) DEFAULT '' NOT NULL,
1215 user_jabber varchar(255) DEFAULT '' NOT NULL,
1216 user_website varchar(200) DEFAULT '' NOT NULL,
1217 user_occ varchar(4000) DEFAULT '' NOT NULL,
1218 user_interests varchar(4000) DEFAULT '' NOT NULL,
1219 user_actkey varchar(32) DEFAULT '' NOT NULL,
1220 user_newpasswd varchar(40) DEFAULT '' NOT NULL,
1221 user_form_salt varchar(32) DEFAULT '' NOT NULL,
1222 PRIMARY KEY (user_id)
1223 );
1224
1225 CREATE INDEX phpbb_users_user_birthday ON phpbb_users (user_birthday);
1226 CREATE INDEX phpbb_users_user_email_hash ON phpbb_users (user_email_hash);
1227 CREATE INDEX phpbb_users_user_type ON phpbb_users (user_type);
1228 CREATE UNIQUE INDEX phpbb_users_username_clean ON phpbb_users (username_clean);
1229
1230 /*
1231 Table: 'phpbb_warnings'
1232 */
1233 CREATE SEQUENCE phpbb_warnings_seq;
1234
1235 CREATE TABLE phpbb_warnings (
1236 warning_id INT4 DEFAULT nextval('phpbb_warnings_seq'),
1237 user_id INT4 DEFAULT '0' NOT NULL CHECK (user_id >= 0),
1238 post_id INT4 DEFAULT '0' NOT NULL CHECK (post_id >= 0),
1239 log_id INT4 DEFAULT '0' NOT NULL CHECK (log_id >= 0),
1240 warning_time INT4 DEFAULT '0' NOT NULL CHECK (warning_time >= 0),
1241 PRIMARY KEY (warning_id)
1242 );
1243
1244
1245 /*
1246 Table: 'phpbb_words'
1247 */
1248 CREATE SEQUENCE phpbb_words_seq;
1249
1250 CREATE TABLE phpbb_words (
1251 word_id INT4 DEFAULT nextval('phpbb_words_seq'),
1252 word varchar(255) DEFAULT '' NOT NULL,
1253 replacement varchar(255) DEFAULT '' NOT NULL,
1254 PRIMARY KEY (word_id)
1255 );
1256
1257
1258 /*
1259 Table: 'phpbb_zebra'
1260 */
1261 CREATE TABLE phpbb_zebra (
1262 user_id INT4 DEFAULT '0' NOT NULL CHECK (user_id >= 0),
1263 zebra_id INT4 DEFAULT '0' NOT NULL CHECK (zebra_id >= 0),
1264 friend INT2 DEFAULT '0' NOT NULL CHECK (friend >= 0),
1265 foe INT2 DEFAULT '0' NOT NULL CHECK (foe >= 0),
1266 PRIMARY KEY (user_id, zebra_id)
1267 );
1268
1269
1270
1271 COMMIT;