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 |
mssql_schema.sql
0001 /*
0002
0003 $Id$
0004
0005 */
0006
0007 BEGIN TRANSACTION
0008 GO
0009
0010 /*
0011 Table: 'phpbb_attachments'
0012 */
0013 CREATE TABLE [phpbb_attachments] (
0014 [attach_id] [int] IDENTITY (1, 1) NOT NULL ,
0015 [post_msg_id] [int] DEFAULT (0) NOT NULL ,
0016 [topic_id] [int] DEFAULT (0) NOT NULL ,
0017 [in_message] [int] DEFAULT (0) NOT NULL ,
0018 [poster_id] [int] DEFAULT (0) NOT NULL ,
0019 [is_orphan] [int] DEFAULT (1) NOT NULL ,
0020 [physical_filename] [varchar] (255) DEFAULT ('') NOT NULL ,
0021 [real_filename] [varchar] (255) DEFAULT ('') NOT NULL ,
0022 [download_count] [int] DEFAULT (0) NOT NULL ,
0023 [attach_comment] [varchar] (4000) DEFAULT ('') NOT NULL ,
0024 [extension] [varchar] (100) DEFAULT ('') NOT NULL ,
0025 [mimetype] [varchar] (100) DEFAULT ('') NOT NULL ,
0026 [filesize] [int] DEFAULT (0) NOT NULL ,
0027 [filetime] [int] DEFAULT (0) NOT NULL ,
0028 [thumbnail] [int] DEFAULT (0) NOT NULL
0029 ) ON [PRIMARY]
0030 GO
0031
0032 ALTER TABLE [phpbb_attachments] WITH NOCHECK ADD
0033 CONSTRAINT [PK_phpbb_attachments] PRIMARY KEY CLUSTERED
0034 (
0035 [attach_id]
0036 ) ON [PRIMARY]
0037 GO
0038
0039 CREATE INDEX [filetime] ON [phpbb_attachments]([filetime]) ON [PRIMARY]
0040 GO
0041
0042 CREATE INDEX [post_msg_id] ON [phpbb_attachments]([post_msg_id]) ON [PRIMARY]
0043 GO
0044
0045 CREATE INDEX [topic_id] ON [phpbb_attachments]([topic_id]) ON [PRIMARY]
0046 GO
0047
0048 CREATE INDEX [poster_id] ON [phpbb_attachments]([poster_id]) ON [PRIMARY]
0049 GO
0050
0051 CREATE INDEX [is_orphan] ON [phpbb_attachments]([is_orphan]) ON [PRIMARY]
0052 GO
0053
0054
0055 /*
0056 Table: 'phpbb_acl_groups'
0057 */
0058 CREATE TABLE [phpbb_acl_groups] (
0059 [group_id] [int] DEFAULT (0) NOT NULL ,
0060 [forum_id] [int] DEFAULT (0) NOT NULL ,
0061 [auth_option_id] [int] DEFAULT (0) NOT NULL ,
0062 [auth_role_id] [int] DEFAULT (0) NOT NULL ,
0063 [auth_setting] [int] DEFAULT (0) NOT NULL
0064 ) ON [PRIMARY]
0065 GO
0066
0067 CREATE INDEX [group_id] ON [phpbb_acl_groups]([group_id]) ON [PRIMARY]
0068 GO
0069
0070 CREATE INDEX [auth_opt_id] ON [phpbb_acl_groups]([auth_option_id]) ON [PRIMARY]
0071 GO
0072
0073 CREATE INDEX [auth_role_id] ON [phpbb_acl_groups]([auth_role_id]) ON [PRIMARY]
0074 GO
0075
0076
0077 /*
0078 Table: 'phpbb_acl_options'
0079 */
0080 CREATE TABLE [phpbb_acl_options] (
0081 [auth_option_id] [int] IDENTITY (1, 1) NOT NULL ,
0082 [auth_option] [varchar] (50) DEFAULT ('') NOT NULL ,
0083 [is_global] [int] DEFAULT (0) NOT NULL ,
0084 [is_local] [int] DEFAULT (0) NOT NULL ,
0085 [founder_only] [int] DEFAULT (0) NOT NULL
0086 ) ON [PRIMARY]
0087 GO
0088
0089 ALTER TABLE [phpbb_acl_options] WITH NOCHECK ADD
0090 CONSTRAINT [PK_phpbb_acl_options] PRIMARY KEY CLUSTERED
0091 (
0092 [auth_option_id]
0093 ) ON [PRIMARY]
0094 GO
0095
0096 CREATE INDEX [auth_option] ON [phpbb_acl_options]([auth_option]) ON [PRIMARY]
0097 GO
0098
0099
0100 /*
0101 Table: 'phpbb_acl_roles'
0102 */
0103 CREATE TABLE [phpbb_acl_roles] (
0104 [role_id] [int] IDENTITY (1, 1) NOT NULL ,
0105 [role_name] [varchar] (255) DEFAULT ('') NOT NULL ,
0106 [role_description] [varchar] (4000) DEFAULT ('') NOT NULL ,
0107 [role_type] [varchar] (10) DEFAULT ('') NOT NULL ,
0108 [role_order] [int] DEFAULT (0) NOT NULL
0109 ) ON [PRIMARY]
0110 GO
0111
0112 ALTER TABLE [phpbb_acl_roles] WITH NOCHECK ADD
0113 CONSTRAINT [PK_phpbb_acl_roles] PRIMARY KEY CLUSTERED
0114 (
0115 [role_id]
0116 ) ON [PRIMARY]
0117 GO
0118
0119 CREATE INDEX [role_type] ON [phpbb_acl_roles]([role_type]) ON [PRIMARY]
0120 GO
0121
0122 CREATE INDEX [role_order] ON [phpbb_acl_roles]([role_order]) ON [PRIMARY]
0123 GO
0124
0125
0126 /*
0127 Table: 'phpbb_acl_roles_data'
0128 */
0129 CREATE TABLE [phpbb_acl_roles_data] (
0130 [role_id] [int] DEFAULT (0) NOT NULL ,
0131 [auth_option_id] [int] DEFAULT (0) NOT NULL ,
0132 [auth_setting] [int] DEFAULT (0) NOT NULL
0133 ) ON [PRIMARY]
0134 GO
0135
0136 ALTER TABLE [phpbb_acl_roles_data] WITH NOCHECK ADD
0137 CONSTRAINT [PK_phpbb_acl_roles_data] PRIMARY KEY CLUSTERED
0138 (
0139 [role_id],
0140 [auth_option_id]
0141 ) ON [PRIMARY]
0142 GO
0143
0144 CREATE INDEX [ath_op_id] ON [phpbb_acl_roles_data]([auth_option_id]) ON [PRIMARY]
0145 GO
0146
0147
0148 /*
0149 Table: 'phpbb_acl_users'
0150 */
0151 CREATE TABLE [phpbb_acl_users] (
0152 [user_id] [int] DEFAULT (0) NOT NULL ,
0153 [forum_id] [int] DEFAULT (0) NOT NULL ,
0154 [auth_option_id] [int] DEFAULT (0) NOT NULL ,
0155 [auth_role_id] [int] DEFAULT (0) NOT NULL ,
0156 [auth_setting] [int] DEFAULT (0) NOT NULL
0157 ) ON [PRIMARY]
0158 GO
0159
0160 CREATE INDEX [user_id] ON [phpbb_acl_users]([user_id]) ON [PRIMARY]
0161 GO
0162
0163 CREATE INDEX [auth_option_id] ON [phpbb_acl_users]([auth_option_id]) ON [PRIMARY]
0164 GO
0165
0166 CREATE INDEX [auth_role_id] ON [phpbb_acl_users]([auth_role_id]) ON [PRIMARY]
0167 GO
0168
0169
0170 /*
0171 Table: 'phpbb_banlist'
0172 */
0173 CREATE TABLE [phpbb_banlist] (
0174 [ban_id] [int] IDENTITY (1, 1) NOT NULL ,
0175 [ban_userid] [int] DEFAULT (0) NOT NULL ,
0176 [ban_ip] [varchar] (40) DEFAULT ('') NOT NULL ,
0177 [ban_email] [varchar] (100) DEFAULT ('') NOT NULL ,
0178 [ban_start] [int] DEFAULT (0) NOT NULL ,
0179 [ban_end] [int] DEFAULT (0) NOT NULL ,
0180 [ban_exclude] [int] DEFAULT (0) NOT NULL ,
0181 [ban_reason] [varchar] (255) DEFAULT ('') NOT NULL ,
0182 [ban_give_reason] [varchar] (255) DEFAULT ('') NOT NULL
0183 ) ON [PRIMARY]
0184 GO
0185
0186 ALTER TABLE [phpbb_banlist] WITH NOCHECK ADD
0187 CONSTRAINT [PK_phpbb_banlist] PRIMARY KEY CLUSTERED
0188 (
0189 [ban_id]
0190 ) ON [PRIMARY]
0191 GO
0192
0193 CREATE INDEX [ban_end] ON [phpbb_banlist]([ban_end]) ON [PRIMARY]
0194 GO
0195
0196 CREATE INDEX [ban_user] ON [phpbb_banlist]([ban_userid], [ban_exclude]) ON [PRIMARY]
0197 GO
0198
0199 CREATE INDEX [ban_email] ON [phpbb_banlist]([ban_email], [ban_exclude]) ON [PRIMARY]
0200 GO
0201
0202 CREATE INDEX [ban_ip] ON [phpbb_banlist]([ban_ip], [ban_exclude]) ON [PRIMARY]
0203 GO
0204
0205
0206 /*
0207 Table: 'phpbb_bbcodes'
0208 */
0209 CREATE TABLE [phpbb_bbcodes] (
0210 [bbcode_id] [int] DEFAULT (0) NOT NULL ,
0211 [bbcode_tag] [varchar] (16) DEFAULT ('') NOT NULL ,
0212 [bbcode_helpline] [varchar] (255) DEFAULT ('') NOT NULL ,
0213 [display_on_posting] [int] DEFAULT (0) NOT NULL ,
0214 [bbcode_match] [varchar] (4000) DEFAULT ('') NOT NULL ,
0215 [bbcode_tpl] [text] DEFAULT ('') NOT NULL ,
0216 [first_pass_match] [text] DEFAULT ('') NOT NULL ,
0217 [first_pass_replace] [text] DEFAULT ('') NOT NULL ,
0218 [second_pass_match] [text] DEFAULT ('') NOT NULL ,
0219 [second_pass_replace] [text] DEFAULT ('') NOT NULL
0220 ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
0221 GO
0222
0223 ALTER TABLE [phpbb_bbcodes] WITH NOCHECK ADD
0224 CONSTRAINT [PK_phpbb_bbcodes] PRIMARY KEY CLUSTERED
0225 (
0226 [bbcode_id]
0227 ) ON [PRIMARY]
0228 GO
0229
0230 CREATE INDEX [display_on_post] ON [phpbb_bbcodes]([display_on_posting]) ON [PRIMARY]
0231 GO
0232
0233
0234 /*
0235 Table: 'phpbb_bookmarks'
0236 */
0237 CREATE TABLE [phpbb_bookmarks] (
0238 [topic_id] [int] DEFAULT (0) NOT NULL ,
0239 [user_id] [int] DEFAULT (0) NOT NULL
0240 ) ON [PRIMARY]
0241 GO
0242
0243 ALTER TABLE [phpbb_bookmarks] WITH NOCHECK ADD
0244 CONSTRAINT [PK_phpbb_bookmarks] PRIMARY KEY CLUSTERED
0245 (
0246 [topic_id],
0247 [user_id]
0248 ) ON [PRIMARY]
0249 GO
0250
0251
0252 /*
0253 Table: 'phpbb_bots'
0254 */
0255 CREATE TABLE [phpbb_bots] (
0256 [bot_id] [int] IDENTITY (1, 1) NOT NULL ,
0257 [bot_active] [int] DEFAULT (1) NOT NULL ,
0258 [bot_name] [varchar] (255) DEFAULT ('') NOT NULL ,
0259 [user_id] [int] DEFAULT (0) NOT NULL ,
0260 [bot_agent] [varchar] (255) DEFAULT ('') NOT NULL ,
0261 [bot_ip] [varchar] (255) DEFAULT ('') NOT NULL
0262 ) ON [PRIMARY]
0263 GO
0264
0265 ALTER TABLE [phpbb_bots] WITH NOCHECK ADD
0266 CONSTRAINT [PK_phpbb_bots] PRIMARY KEY CLUSTERED
0267 (
0268 [bot_id]
0269 ) ON [PRIMARY]
0270 GO
0271
0272 CREATE INDEX [bot_active] ON [phpbb_bots]([bot_active]) ON [PRIMARY]
0273 GO
0274
0275
0276 /*
0277 Table: 'phpbb_config'
0278 */
0279 CREATE TABLE [phpbb_config] (
0280 [config_name] [varchar] (255) DEFAULT ('') NOT NULL ,
0281 [config_value] [varchar] (255) DEFAULT ('') NOT NULL ,
0282 [is_dynamic] [int] DEFAULT (0) NOT NULL
0283 ) ON [PRIMARY]
0284 GO
0285
0286 ALTER TABLE [phpbb_config] WITH NOCHECK ADD
0287 CONSTRAINT [PK_phpbb_config] PRIMARY KEY CLUSTERED
0288 (
0289 [config_name]
0290 ) ON [PRIMARY]
0291 GO
0292
0293 CREATE INDEX [is_dynamic] ON [phpbb_config]([is_dynamic]) ON [PRIMARY]
0294 GO
0295
0296
0297 /*
0298 Table: 'phpbb_confirm'
0299 */
0300 CREATE TABLE [phpbb_confirm] (
0301 [confirm_id] [char] (32) DEFAULT ('') NOT NULL ,
0302 [session_id] [char] (32) DEFAULT ('') NOT NULL ,
0303 [confirm_type] [int] DEFAULT (0) NOT NULL ,
0304 [code] [varchar] (8) DEFAULT ('') NOT NULL ,
0305 [seed] [int] DEFAULT (0) NOT NULL
0306 ) ON [PRIMARY]
0307 GO
0308
0309 ALTER TABLE [phpbb_confirm] WITH NOCHECK ADD
0310 CONSTRAINT [PK_phpbb_confirm] PRIMARY KEY CLUSTERED
0311 (
0312 [session_id],
0313 [confirm_id]
0314 ) ON [PRIMARY]
0315 GO
0316
0317 CREATE INDEX [confirm_type] ON [phpbb_confirm]([confirm_type]) ON [PRIMARY]
0318 GO
0319
0320
0321 /*
0322 Table: 'phpbb_disallow'
0323 */
0324 CREATE TABLE [phpbb_disallow] (
0325 [disallow_id] [int] IDENTITY (1, 1) NOT NULL ,
0326 [disallow_username] [varchar] (255) DEFAULT ('') NOT NULL
0327 ) ON [PRIMARY]
0328 GO
0329
0330 ALTER TABLE [phpbb_disallow] WITH NOCHECK ADD
0331 CONSTRAINT [PK_phpbb_disallow] PRIMARY KEY CLUSTERED
0332 (
0333 [disallow_id]
0334 ) ON [PRIMARY]
0335 GO
0336
0337
0338 /*
0339 Table: 'phpbb_drafts'
0340 */
0341 CREATE TABLE [phpbb_drafts] (
0342 [draft_id] [int] IDENTITY (1, 1) NOT NULL ,
0343 [user_id] [int] DEFAULT (0) NOT NULL ,
0344 [topic_id] [int] DEFAULT (0) NOT NULL ,
0345 [forum_id] [int] DEFAULT (0) NOT NULL ,
0346 [save_time] [int] DEFAULT (0) NOT NULL ,
0347 [draft_subject] [varchar] (100) DEFAULT ('') NOT NULL ,
0348 [draft_message] [text] DEFAULT ('') NOT NULL
0349 ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
0350 GO
0351
0352 ALTER TABLE [phpbb_drafts] WITH NOCHECK ADD
0353 CONSTRAINT [PK_phpbb_drafts] PRIMARY KEY CLUSTERED
0354 (
0355 [draft_id]
0356 ) ON [PRIMARY]
0357 GO
0358
0359 CREATE INDEX [save_time] ON [phpbb_drafts]([save_time]) ON [PRIMARY]
0360 GO
0361
0362
0363 /*
0364 Table: 'phpbb_extensions'
0365 */
0366 CREATE TABLE [phpbb_extensions] (
0367 [extension_id] [int] IDENTITY (1, 1) NOT NULL ,
0368 [group_id] [int] DEFAULT (0) NOT NULL ,
0369 [extension] [varchar] (100) DEFAULT ('') NOT NULL
0370 ) ON [PRIMARY]
0371 GO
0372
0373 ALTER TABLE [phpbb_extensions] WITH NOCHECK ADD
0374 CONSTRAINT [PK_phpbb_extensions] PRIMARY KEY CLUSTERED
0375 (
0376 [extension_id]
0377 ) ON [PRIMARY]
0378 GO
0379
0380
0381 /*
0382 Table: 'phpbb_extension_groups'
0383 */
0384 CREATE TABLE [phpbb_extension_groups] (
0385 [group_id] [int] IDENTITY (1, 1) NOT NULL ,
0386 [group_name] [varchar] (255) DEFAULT ('') NOT NULL ,
0387 [cat_id] [int] DEFAULT (0) NOT NULL ,
0388 [allow_group] [int] DEFAULT (0) NOT NULL ,
0389 [download_mode] [int] DEFAULT (1) NOT NULL ,
0390 [upload_icon] [varchar] (255) DEFAULT ('') NOT NULL ,
0391 [max_filesize] [int] DEFAULT (0) NOT NULL ,
0392 [allowed_forums] [varchar] (8000) DEFAULT ('') NOT NULL ,
0393 [allow_in_pm] [int] DEFAULT (0) NOT NULL
0394 ) ON [PRIMARY]
0395 GO
0396
0397 ALTER TABLE [phpbb_extension_groups] WITH NOCHECK ADD
0398 CONSTRAINT [PK_phpbb_extension_groups] PRIMARY KEY CLUSTERED
0399 (
0400 [group_id]
0401 ) ON [PRIMARY]
0402 GO
0403
0404
0405 /*
0406 Table: 'phpbb_forums'
0407 */
0408 CREATE TABLE [phpbb_forums] (
0409 [forum_id] [int] IDENTITY (1, 1) NOT NULL ,
0410 [parent_id] [int] DEFAULT (0) NOT NULL ,
0411 [left_id] [int] DEFAULT (0) NOT NULL ,
0412 [right_id] [int] DEFAULT (0) NOT NULL ,
0413 [forum_parents] [text] DEFAULT ('') NOT NULL ,
0414 [forum_name] [varchar] (255) DEFAULT ('') NOT NULL ,
0415 [forum_desc] [varchar] (4000) DEFAULT ('') NOT NULL ,
0416 [forum_desc_bitfield] [varchar] (255) DEFAULT ('') NOT NULL ,
0417 [forum_desc_options] [int] DEFAULT (7) NOT NULL ,
0418 [forum_desc_uid] [varchar] (8) DEFAULT ('') NOT NULL ,
0419 [forum_link] [varchar] (255) DEFAULT ('') NOT NULL ,
0420 [forum_password] [varchar] (40) DEFAULT ('') NOT NULL ,
0421 [forum_style] [int] DEFAULT (0) NOT NULL ,
0422 [forum_image] [varchar] (255) DEFAULT ('') NOT NULL ,
0423 [forum_rules] [varchar] (4000) DEFAULT ('') NOT NULL ,
0424 [forum_rules_link] [varchar] (255) DEFAULT ('') NOT NULL ,
0425 [forum_rules_bitfield] [varchar] (255) DEFAULT ('') NOT NULL ,
0426 [forum_rules_options] [int] DEFAULT (7) NOT NULL ,
0427 [forum_rules_uid] [varchar] (8) DEFAULT ('') NOT NULL ,
0428 [forum_topics_per_page] [int] DEFAULT (0) NOT NULL ,
0429 [forum_type] [int] DEFAULT (0) NOT NULL ,
0430 [forum_status] [int] DEFAULT (0) NOT NULL ,
0431 [forum_posts] [int] DEFAULT (0) NOT NULL ,
0432 [forum_topics] [int] DEFAULT (0) NOT NULL ,
0433 [forum_topics_real] [int] DEFAULT (0) NOT NULL ,
0434 [forum_last_post_id] [int] DEFAULT (0) NOT NULL ,
0435 [forum_last_poster_id] [int] DEFAULT (0) NOT NULL ,
0436 [forum_last_post_subject] [varchar] (100) DEFAULT ('') NOT NULL ,
0437 [forum_last_post_time] [int] DEFAULT (0) NOT NULL ,
0438 [forum_last_poster_name] [varchar] (255) DEFAULT ('') NOT NULL ,
0439 [forum_last_poster_colour] [varchar] (6) DEFAULT ('') NOT NULL ,
0440 [forum_flags] [int] DEFAULT (32) NOT NULL ,
0441 [display_on_index] [int] DEFAULT (1) NOT NULL ,
0442 [enable_indexing] [int] DEFAULT (1) NOT NULL ,
0443 [enable_icons] [int] DEFAULT (1) NOT NULL ,
0444 [enable_prune] [int] DEFAULT (0) NOT NULL ,
0445 [prune_next] [int] DEFAULT (0) NOT NULL ,
0446 [prune_days] [int] DEFAULT (0) NOT NULL ,
0447 [prune_viewed] [int] DEFAULT (0) NOT NULL ,
0448 [prune_freq] [int] DEFAULT (0) NOT NULL
0449 ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
0450 GO
0451
0452 ALTER TABLE [phpbb_forums] WITH NOCHECK ADD
0453 CONSTRAINT [PK_phpbb_forums] PRIMARY KEY CLUSTERED
0454 (
0455 [forum_id]
0456 ) ON [PRIMARY]
0457 GO
0458
0459 CREATE INDEX [left_right_id] ON [phpbb_forums]([left_id], [right_id]) ON [PRIMARY]
0460 GO
0461
0462 CREATE INDEX [forum_lastpost_id] ON [phpbb_forums]([forum_last_post_id]) ON [PRIMARY]
0463 GO
0464
0465
0466 /*
0467 Table: 'phpbb_forums_access'
0468 */
0469 CREATE TABLE [phpbb_forums_access] (
0470 [forum_id] [int] DEFAULT (0) NOT NULL ,
0471 [user_id] [int] DEFAULT (0) NOT NULL ,
0472 [session_id] [char] (32) DEFAULT ('') NOT NULL
0473 ) ON [PRIMARY]
0474 GO
0475
0476 ALTER TABLE [phpbb_forums_access] WITH NOCHECK ADD
0477 CONSTRAINT [PK_phpbb_forums_access] PRIMARY KEY CLUSTERED
0478 (
0479 [forum_id],
0480 [user_id],
0481 [session_id]
0482 ) ON [PRIMARY]
0483 GO
0484
0485
0486 /*
0487 Table: 'phpbb_forums_track'
0488 */
0489 CREATE TABLE [phpbb_forums_track] (
0490 [user_id] [int] DEFAULT (0) NOT NULL ,
0491 [forum_id] [int] DEFAULT (0) NOT NULL ,
0492 [mark_time] [int] DEFAULT (0) NOT NULL
0493 ) ON [PRIMARY]
0494 GO
0495
0496 ALTER TABLE [phpbb_forums_track] WITH NOCHECK ADD
0497 CONSTRAINT [PK_phpbb_forums_track] PRIMARY KEY CLUSTERED
0498 (
0499 [user_id],
0500 [forum_id]
0501 ) ON [PRIMARY]
0502 GO
0503
0504
0505 /*
0506 Table: 'phpbb_forums_watch'
0507 */
0508 CREATE TABLE [phpbb_forums_watch] (
0509 [forum_id] [int] DEFAULT (0) NOT NULL ,
0510 [user_id] [int] DEFAULT (0) NOT NULL ,
0511 [notify_status] [int] DEFAULT (0) NOT NULL
0512 ) ON [PRIMARY]
0513 GO
0514
0515 CREATE INDEX [forum_id] ON [phpbb_forums_watch]([forum_id]) ON [PRIMARY]
0516 GO
0517
0518 CREATE INDEX [user_id] ON [phpbb_forums_watch]([user_id]) ON [PRIMARY]
0519 GO
0520
0521 CREATE INDEX [notify_stat] ON [phpbb_forums_watch]([notify_status]) ON [PRIMARY]
0522 GO
0523
0524
0525 /*
0526 Table: 'phpbb_groups'
0527 */
0528 CREATE TABLE [phpbb_groups] (
0529 [group_id] [int] IDENTITY (1, 1) NOT NULL ,
0530 [group_type] [int] DEFAULT (1) NOT NULL ,
0531 [group_founder_manage] [int] DEFAULT (0) NOT NULL ,
0532 [group_name] [varchar] (255) DEFAULT ('') NOT NULL ,
0533 [group_desc] [varchar] (4000) DEFAULT ('') NOT NULL ,
0534 [group_desc_bitfield] [varchar] (255) DEFAULT ('') NOT NULL ,
0535 [group_desc_options] [int] DEFAULT (7) NOT NULL ,
0536 [group_desc_uid] [varchar] (8) DEFAULT ('') NOT NULL ,
0537 [group_display] [int] DEFAULT (0) NOT NULL ,
0538 [group_avatar] [varchar] (255) DEFAULT ('') NOT NULL ,
0539 [group_avatar_type] [int] DEFAULT (0) NOT NULL ,
0540 [group_avatar_width] [int] DEFAULT (0) NOT NULL ,
0541 [group_avatar_height] [int] DEFAULT (0) NOT NULL ,
0542 [group_rank] [int] DEFAULT (0) NOT NULL ,
0543 [group_colour] [varchar] (6) DEFAULT ('') NOT NULL ,
0544 [group_sig_chars] [int] DEFAULT (0) NOT NULL ,
0545 [group_receive_pm] [int] DEFAULT (0) NOT NULL ,
0546 [group_message_limit] [int] DEFAULT (0) NOT NULL ,
0547 [group_legend] [int] DEFAULT (1) NOT NULL
0548 ) ON [PRIMARY]
0549 GO
0550
0551 ALTER TABLE [phpbb_groups] WITH NOCHECK ADD
0552 CONSTRAINT [PK_phpbb_groups] PRIMARY KEY CLUSTERED
0553 (
0554 [group_id]
0555 ) ON [PRIMARY]
0556 GO
0557
0558 CREATE INDEX [group_legend] ON [phpbb_groups]([group_legend]) ON [PRIMARY]
0559 GO
0560
0561
0562 /*
0563 Table: 'phpbb_icons'
0564 */
0565 CREATE TABLE [phpbb_icons] (
0566 [icons_id] [int] IDENTITY (1, 1) NOT NULL ,
0567 [icons_url] [varchar] (255) DEFAULT ('') NOT NULL ,
0568 [icons_width] [int] DEFAULT (0) NOT NULL ,
0569 [icons_height] [int] DEFAULT (0) NOT NULL ,
0570 [icons_order] [int] DEFAULT (0) NOT NULL ,
0571 [display_on_posting] [int] DEFAULT (1) NOT NULL
0572 ) ON [PRIMARY]
0573 GO
0574
0575 ALTER TABLE [phpbb_icons] WITH NOCHECK ADD
0576 CONSTRAINT [PK_phpbb_icons] PRIMARY KEY CLUSTERED
0577 (
0578 [icons_id]
0579 ) ON [PRIMARY]
0580 GO
0581
0582 CREATE INDEX [display_on_posting] ON [phpbb_icons]([display_on_posting]) ON [PRIMARY]
0583 GO
0584
0585
0586 /*
0587 Table: 'phpbb_lang'
0588 */
0589 CREATE TABLE [phpbb_lang] (
0590 [lang_id] [int] IDENTITY (1, 1) NOT NULL ,
0591 [lang_iso] [varchar] (30) DEFAULT ('') NOT NULL ,
0592 [lang_dir] [varchar] (30) DEFAULT ('') NOT NULL ,
0593 [lang_english_name] [varchar] (100) DEFAULT ('') NOT NULL ,
0594 [lang_local_name] [varchar] (255) DEFAULT ('') NOT NULL ,
0595 [lang_author] [varchar] (255) DEFAULT ('') NOT NULL
0596 ) ON [PRIMARY]
0597 GO
0598
0599 ALTER TABLE [phpbb_lang] WITH NOCHECK ADD
0600 CONSTRAINT [PK_phpbb_lang] PRIMARY KEY CLUSTERED
0601 (
0602 [lang_id]
0603 ) ON [PRIMARY]
0604 GO
0605
0606 CREATE INDEX [lang_iso] ON [phpbb_lang]([lang_iso]) ON [PRIMARY]
0607 GO
0608
0609
0610 /*
0611 Table: 'phpbb_log'
0612 */
0613 CREATE TABLE [phpbb_log] (
0614 [log_id] [int] IDENTITY (1, 1) NOT NULL ,
0615 [log_type] [int] DEFAULT (0) NOT NULL ,
0616 [user_id] [int] DEFAULT (0) NOT NULL ,
0617 [forum_id] [int] DEFAULT (0) NOT NULL ,
0618 [topic_id] [int] DEFAULT (0) NOT NULL ,
0619 [reportee_id] [int] DEFAULT (0) NOT NULL ,
0620 [log_ip] [varchar] (40) DEFAULT ('') NOT NULL ,
0621 [log_time] [int] DEFAULT (0) NOT NULL ,
0622 [log_operation] [varchar] (4000) DEFAULT ('') NOT NULL ,
0623 [log_data] [text] DEFAULT ('') NOT NULL
0624 ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
0625 GO
0626
0627 ALTER TABLE [phpbb_log] WITH NOCHECK ADD
0628 CONSTRAINT [PK_phpbb_log] PRIMARY KEY CLUSTERED
0629 (
0630 [log_id]
0631 ) ON [PRIMARY]
0632 GO
0633
0634 CREATE INDEX [log_type] ON [phpbb_log]([log_type]) ON [PRIMARY]
0635 GO
0636
0637 CREATE INDEX [forum_id] ON [phpbb_log]([forum_id]) ON [PRIMARY]
0638 GO
0639
0640 CREATE INDEX [topic_id] ON [phpbb_log]([topic_id]) ON [PRIMARY]
0641 GO
0642
0643 CREATE INDEX [reportee_id] ON [phpbb_log]([reportee_id]) ON [PRIMARY]
0644 GO
0645
0646 CREATE INDEX [user_id] ON [phpbb_log]([user_id]) ON [PRIMARY]
0647 GO
0648
0649
0650 /*
0651 Table: 'phpbb_moderator_cache'
0652 */
0653 CREATE TABLE [phpbb_moderator_cache] (
0654 [forum_id] [int] DEFAULT (0) NOT NULL ,
0655 [user_id] [int] DEFAULT (0) NOT NULL ,
0656 [username] [varchar] (255) DEFAULT ('') NOT NULL ,
0657 [group_id] [int] DEFAULT (0) NOT NULL ,
0658 [group_name] [varchar] (255) DEFAULT ('') NOT NULL ,
0659 [display_on_index] [int] DEFAULT (1) NOT NULL
0660 ) ON [PRIMARY]
0661 GO
0662
0663 CREATE INDEX [disp_idx] ON [phpbb_moderator_cache]([display_on_index]) ON [PRIMARY]
0664 GO
0665
0666 CREATE INDEX [forum_id] ON [phpbb_moderator_cache]([forum_id]) ON [PRIMARY]
0667 GO
0668
0669
0670 /*
0671 Table: 'phpbb_modules'
0672 */
0673 CREATE TABLE [phpbb_modules] (
0674 [module_id] [int] IDENTITY (1, 1) NOT NULL ,
0675 [module_enabled] [int] DEFAULT (1) NOT NULL ,
0676 [module_display] [int] DEFAULT (1) NOT NULL ,
0677 [module_basename] [varchar] (255) DEFAULT ('') NOT NULL ,
0678 [module_class] [varchar] (10) DEFAULT ('') NOT NULL ,
0679 [parent_id] [int] DEFAULT (0) NOT NULL ,
0680 [left_id] [int] DEFAULT (0) NOT NULL ,
0681 [right_id] [int] DEFAULT (0) NOT NULL ,
0682 [module_langname] [varchar] (255) DEFAULT ('') NOT NULL ,
0683 [module_mode] [varchar] (255) DEFAULT ('') NOT NULL ,
0684 [module_auth] [varchar] (255) DEFAULT ('') NOT NULL
0685 ) ON [PRIMARY]
0686 GO
0687
0688 ALTER TABLE [phpbb_modules] WITH NOCHECK ADD
0689 CONSTRAINT [PK_phpbb_modules] PRIMARY KEY CLUSTERED
0690 (
0691 [module_id]
0692 ) ON [PRIMARY]
0693 GO
0694
0695 CREATE INDEX [left_right_id] ON [phpbb_modules]([left_id], [right_id]) ON [PRIMARY]
0696 GO
0697
0698 CREATE INDEX [module_enabled] ON [phpbb_modules]([module_enabled]) ON [PRIMARY]
0699 GO
0700
0701 CREATE INDEX [class_left_id] ON [phpbb_modules]([module_class], [left_id]) ON [PRIMARY]
0702 GO
0703
0704
0705 /*
0706 Table: 'phpbb_poll_options'
0707 */
0708 CREATE TABLE [phpbb_poll_options] (
0709 [poll_option_id] [int] DEFAULT (0) NOT NULL ,
0710 [topic_id] [int] DEFAULT (0) NOT NULL ,
0711 [poll_option_text] [varchar] (4000) DEFAULT ('') NOT NULL ,
0712 [poll_option_total] [int] DEFAULT (0) NOT NULL
0713 ) ON [PRIMARY]
0714 GO
0715
0716 CREATE INDEX [poll_opt_id] ON [phpbb_poll_options]([poll_option_id]) ON [PRIMARY]
0717 GO
0718
0719 CREATE INDEX [topic_id] ON [phpbb_poll_options]([topic_id]) ON [PRIMARY]
0720 GO
0721
0722
0723 /*
0724 Table: 'phpbb_poll_votes'
0725 */
0726 CREATE TABLE [phpbb_poll_votes] (
0727 [topic_id] [int] DEFAULT (0) NOT NULL ,
0728 [poll_option_id] [int] DEFAULT (0) NOT NULL ,
0729 [vote_user_id] [int] DEFAULT (0) NOT NULL ,
0730 [vote_user_ip] [varchar] (40) DEFAULT ('') NOT NULL
0731 ) ON [PRIMARY]
0732 GO
0733
0734 CREATE INDEX [topic_id] ON [phpbb_poll_votes]([topic_id]) ON [PRIMARY]
0735 GO
0736
0737 CREATE INDEX [vote_user_id] ON [phpbb_poll_votes]([vote_user_id]) ON [PRIMARY]
0738 GO
0739
0740 CREATE INDEX [vote_user_ip] ON [phpbb_poll_votes]([vote_user_ip]) ON [PRIMARY]
0741 GO
0742
0743
0744 /*
0745 Table: 'phpbb_posts'
0746 */
0747 CREATE TABLE [phpbb_posts] (
0748 [post_id] [int] IDENTITY (1, 1) NOT NULL ,
0749 [topic_id] [int] DEFAULT (0) NOT NULL ,
0750 [forum_id] [int] DEFAULT (0) NOT NULL ,
0751 [poster_id] [int] DEFAULT (0) NOT NULL ,
0752 [icon_id] [int] DEFAULT (0) NOT NULL ,
0753 [poster_ip] [varchar] (40) DEFAULT ('') NOT NULL ,
0754 [post_time] [int] DEFAULT (0) NOT NULL ,
0755 [post_approved] [int] DEFAULT (1) NOT NULL ,
0756 [post_reported] [int] DEFAULT (0) NOT NULL ,
0757 [enable_bbcode] [int] DEFAULT (1) NOT NULL ,
0758 [enable_smilies] [int] DEFAULT (1) NOT NULL ,
0759 [enable_magic_url] [int] DEFAULT (1) NOT NULL ,
0760 [enable_sig] [int] DEFAULT (1) NOT NULL ,
0761 [post_username] [varchar] (255) DEFAULT ('') NOT NULL ,
0762 [post_subject] [varchar] (100) DEFAULT ('') NOT NULL ,
0763 [post_text] [text] DEFAULT ('') NOT NULL ,
0764 [post_checksum] [varchar] (32) DEFAULT ('') NOT NULL ,
0765 [post_attachment] [int] DEFAULT (0) NOT NULL ,
0766 [bbcode_bitfield] [varchar] (255) DEFAULT ('') NOT NULL ,
0767 [bbcode_uid] [varchar] (8) DEFAULT ('') NOT NULL ,
0768 [post_postcount] [int] DEFAULT (1) NOT NULL ,
0769 [post_edit_time] [int] DEFAULT (0) NOT NULL ,
0770 [post_edit_reason] [varchar] (255) DEFAULT ('') NOT NULL ,
0771 [post_edit_user] [int] DEFAULT (0) NOT NULL ,
0772 [post_edit_count] [int] DEFAULT (0) NOT NULL ,
0773 [post_edit_locked] [int] DEFAULT (0) NOT NULL
0774 ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
0775 GO
0776
0777 ALTER TABLE [phpbb_posts] WITH NOCHECK ADD
0778 CONSTRAINT [PK_phpbb_posts] PRIMARY KEY CLUSTERED
0779 (
0780 [post_id]
0781 ) ON [PRIMARY]
0782 GO
0783
0784 CREATE INDEX [forum_id] ON [phpbb_posts]([forum_id]) ON [PRIMARY]
0785 GO
0786
0787 CREATE INDEX [topic_id] ON [phpbb_posts]([topic_id]) ON [PRIMARY]
0788 GO
0789
0790 CREATE INDEX [poster_ip] ON [phpbb_posts]([poster_ip]) ON [PRIMARY]
0791 GO
0792
0793 CREATE INDEX [poster_id] ON [phpbb_posts]([poster_id]) ON [PRIMARY]
0794 GO
0795
0796 CREATE INDEX [post_approved] ON [phpbb_posts]([post_approved]) ON [PRIMARY]
0797 GO
0798
0799 CREATE INDEX [tid_post_time] ON [phpbb_posts]([topic_id], [post_time]) ON [PRIMARY]
0800 GO
0801
0802
0803 /*
0804 Table: 'phpbb_privmsgs'
0805 */
0806 CREATE TABLE [phpbb_privmsgs] (
0807 [msg_id] [int] IDENTITY (1, 1) NOT NULL ,
0808 [root_level] [int] DEFAULT (0) NOT NULL ,
0809 [author_id] [int] DEFAULT (0) NOT NULL ,
0810 [icon_id] [int] DEFAULT (0) NOT NULL ,
0811 [author_ip] [varchar] (40) DEFAULT ('') NOT NULL ,
0812 [message_time] [int] DEFAULT (0) NOT NULL ,
0813 [enable_bbcode] [int] DEFAULT (1) NOT NULL ,
0814 [enable_smilies] [int] DEFAULT (1) NOT NULL ,
0815 [enable_magic_url] [int] DEFAULT (1) NOT NULL ,
0816 [enable_sig] [int] DEFAULT (1) NOT NULL ,
0817 [message_subject] [varchar] (100) DEFAULT ('') NOT NULL ,
0818 [message_text] [text] DEFAULT ('') NOT NULL ,
0819 [message_edit_reason] [varchar] (255) DEFAULT ('') NOT NULL ,
0820 [message_edit_user] [int] DEFAULT (0) NOT NULL ,
0821 [message_attachment] [int] DEFAULT (0) NOT NULL ,
0822 [bbcode_bitfield] [varchar] (255) DEFAULT ('') NOT NULL ,
0823 [bbcode_uid] [varchar] (8) DEFAULT ('') NOT NULL ,
0824 [message_edit_time] [int] DEFAULT (0) NOT NULL ,
0825 [message_edit_count] [int] DEFAULT (0) NOT NULL ,
0826 [to_address] [varchar] (4000) DEFAULT ('') NOT NULL ,
0827 [bcc_address] [varchar] (4000) DEFAULT ('') NOT NULL
0828 ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
0829 GO
0830
0831 ALTER TABLE [phpbb_privmsgs] WITH NOCHECK ADD
0832 CONSTRAINT [PK_phpbb_privmsgs] PRIMARY KEY CLUSTERED
0833 (
0834 [msg_id]
0835 ) ON [PRIMARY]
0836 GO
0837
0838 CREATE INDEX [author_ip] ON [phpbb_privmsgs]([author_ip]) ON [PRIMARY]
0839 GO
0840
0841 CREATE INDEX [message_time] ON [phpbb_privmsgs]([message_time]) ON [PRIMARY]
0842 GO
0843
0844 CREATE INDEX [author_id] ON [phpbb_privmsgs]([author_id]) ON [PRIMARY]
0845 GO
0846
0847 CREATE INDEX [root_level] ON [phpbb_privmsgs]([root_level]) ON [PRIMARY]
0848 GO
0849
0850
0851 /*
0852 Table: 'phpbb_privmsgs_folder'
0853 */
0854 CREATE TABLE [phpbb_privmsgs_folder] (
0855 [folder_id] [int] IDENTITY (1, 1) NOT NULL ,
0856 [user_id] [int] DEFAULT (0) NOT NULL ,
0857 [folder_name] [varchar] (255) DEFAULT ('') NOT NULL ,
0858 [pm_count] [int] DEFAULT (0) NOT NULL
0859 ) ON [PRIMARY]
0860 GO
0861
0862 ALTER TABLE [phpbb_privmsgs_folder] WITH NOCHECK ADD
0863 CONSTRAINT [PK_phpbb_privmsgs_folder] PRIMARY KEY CLUSTERED
0864 (
0865 [folder_id]
0866 ) ON [PRIMARY]
0867 GO
0868
0869 CREATE INDEX [user_id] ON [phpbb_privmsgs_folder]([user_id]) ON [PRIMARY]
0870 GO
0871
0872
0873 /*
0874 Table: 'phpbb_privmsgs_rules'
0875 */
0876 CREATE TABLE [phpbb_privmsgs_rules] (
0877 [rule_id] [int] IDENTITY (1, 1) NOT NULL ,
0878 [user_id] [int] DEFAULT (0) NOT NULL ,
0879 [rule_check] [int] DEFAULT (0) NOT NULL ,
0880 [rule_connection] [int] DEFAULT (0) NOT NULL ,
0881 [rule_string] [varchar] (255) DEFAULT ('') NOT NULL ,
0882 [rule_user_id] [int] DEFAULT (0) NOT NULL ,
0883 [rule_group_id] [int] DEFAULT (0) NOT NULL ,
0884 [rule_action] [int] DEFAULT (0) NOT NULL ,
0885 [rule_folder_id] [int] DEFAULT (0) NOT NULL
0886 ) ON [PRIMARY]
0887 GO
0888
0889 ALTER TABLE [phpbb_privmsgs_rules] WITH NOCHECK ADD
0890 CONSTRAINT [PK_phpbb_privmsgs_rules] PRIMARY KEY CLUSTERED
0891 (
0892 [rule_id]
0893 ) ON [PRIMARY]
0894 GO
0895
0896 CREATE INDEX [user_id] ON [phpbb_privmsgs_rules]([user_id]) ON [PRIMARY]
0897 GO
0898
0899
0900 /*
0901 Table: 'phpbb_privmsgs_to'
0902 */
0903 CREATE TABLE [phpbb_privmsgs_to] (
0904 [msg_id] [int] DEFAULT (0) NOT NULL ,
0905 [user_id] [int] DEFAULT (0) NOT NULL ,
0906 [author_id] [int] DEFAULT (0) NOT NULL ,
0907 [pm_deleted] [int] DEFAULT (0) NOT NULL ,
0908 [pm_new] [int] DEFAULT (1) NOT NULL ,
0909 [pm_unread] [int] DEFAULT (1) NOT NULL ,
0910 [pm_replied] [int] DEFAULT (0) NOT NULL ,
0911 [pm_marked] [int] DEFAULT (0) NOT NULL ,
0912 [pm_forwarded] [int] DEFAULT (0) NOT NULL ,
0913 [folder_id] [int] DEFAULT (0) NOT NULL
0914 ) ON [PRIMARY]
0915 GO
0916
0917 CREATE INDEX [msg_id] ON [phpbb_privmsgs_to]([msg_id]) ON [PRIMARY]
0918 GO
0919
0920 CREATE INDEX [author_id] ON [phpbb_privmsgs_to]([author_id]) ON [PRIMARY]
0921 GO
0922
0923 CREATE INDEX [usr_flder_id] ON [phpbb_privmsgs_to]([user_id], [folder_id]) ON [PRIMARY]
0924 GO
0925
0926
0927 /*
0928 Table: 'phpbb_profile_fields'
0929 */
0930 CREATE TABLE [phpbb_profile_fields] (
0931 [field_id] [int] IDENTITY (1, 1) NOT NULL ,
0932 [field_name] [varchar] (255) DEFAULT ('') NOT NULL ,
0933 [field_type] [int] DEFAULT (0) NOT NULL ,
0934 [field_ident] [varchar] (20) DEFAULT ('') NOT NULL ,
0935 [field_length] [varchar] (20) DEFAULT ('') NOT NULL ,
0936 [field_minlen] [varchar] (255) DEFAULT ('') NOT NULL ,
0937 [field_maxlen] [varchar] (255) DEFAULT ('') NOT NULL ,
0938 [field_novalue] [varchar] (255) DEFAULT ('') NOT NULL ,
0939 [field_default_value] [varchar] (255) DEFAULT ('') NOT NULL ,
0940 [field_validation] [varchar] (20) DEFAULT ('') NOT NULL ,
0941 [field_required] [int] DEFAULT (0) NOT NULL ,
0942 [field_show_on_reg] [int] DEFAULT (0) NOT NULL ,
0943 [field_hide] [int] DEFAULT (0) NOT NULL ,
0944 [field_no_view] [int] DEFAULT (0) NOT NULL ,
0945 [field_active] [int] DEFAULT (0) NOT NULL ,
0946 [field_order] [int] DEFAULT (0) NOT NULL
0947 ) ON [PRIMARY]
0948 GO
0949
0950 ALTER TABLE [phpbb_profile_fields] WITH NOCHECK ADD
0951 CONSTRAINT [PK_phpbb_profile_fields] PRIMARY KEY CLUSTERED
0952 (
0953 [field_id]
0954 ) ON [PRIMARY]
0955 GO
0956
0957 CREATE INDEX [fld_type] ON [phpbb_profile_fields]([field_type]) ON [PRIMARY]
0958 GO
0959
0960 CREATE INDEX [fld_ordr] ON [phpbb_profile_fields]([field_order]) ON [PRIMARY]
0961 GO
0962
0963
0964 /*
0965 Table: 'phpbb_profile_fields_data'
0966 */
0967 CREATE TABLE [phpbb_profile_fields_data] (
0968 [user_id] [int] DEFAULT (0) NOT NULL
0969 ) ON [PRIMARY]
0970 GO
0971
0972 ALTER TABLE [phpbb_profile_fields_data] WITH NOCHECK ADD
0973 CONSTRAINT [PK_phpbb_profile_fields_data] PRIMARY KEY CLUSTERED
0974 (
0975 [user_id]
0976 ) ON [PRIMARY]
0977 GO
0978
0979
0980 /*
0981 Table: 'phpbb_profile_fields_lang'
0982 */
0983 CREATE TABLE [phpbb_profile_fields_lang] (
0984 [field_id] [int] DEFAULT (0) NOT NULL ,
0985 [lang_id] [int] DEFAULT (0) NOT NULL ,
0986 [option_id] [int] DEFAULT (0) NOT NULL ,
0987 [field_type] [int] DEFAULT (0) NOT NULL ,
0988 [lang_value] [varchar] (255) DEFAULT ('') NOT NULL
0989 ) ON [PRIMARY]
0990 GO
0991
0992 ALTER TABLE [phpbb_profile_fields_lang] WITH NOCHECK ADD
0993 CONSTRAINT [PK_phpbb_profile_fields_lang] PRIMARY KEY CLUSTERED
0994 (
0995 [field_id],
0996 [lang_id],
0997 [option_id]
0998 ) ON [PRIMARY]
0999 GO
1000
1001
1002 /*
1003 Table: 'phpbb_profile_lang'
1004 */
1005 CREATE TABLE [phpbb_profile_lang] (
1006 [field_id] [int] DEFAULT (0) NOT NULL ,
1007 [lang_id] [int] DEFAULT (0) NOT NULL ,
1008 [lang_name] [varchar] (255) DEFAULT ('') NOT NULL ,
1009 [lang_explain] [varchar] (4000) DEFAULT ('') NOT NULL ,
1010 [lang_default_value] [varchar] (255) DEFAULT ('') NOT NULL
1011 ) ON [PRIMARY]
1012 GO
1013
1014 ALTER TABLE [phpbb_profile_lang] WITH NOCHECK ADD
1015 CONSTRAINT [PK_phpbb_profile_lang] PRIMARY KEY CLUSTERED
1016 (
1017 [field_id],
1018 [lang_id]
1019 ) ON [PRIMARY]
1020 GO
1021
1022
1023 /*
1024 Table: 'phpbb_ranks'
1025 */
1026 CREATE TABLE [phpbb_ranks] (
1027 [rank_id] [int] IDENTITY (1, 1) NOT NULL ,
1028 [rank_title] [varchar] (255) DEFAULT ('') NOT NULL ,
1029 [rank_min] [int] DEFAULT (0) NOT NULL ,
1030 [rank_special] [int] DEFAULT (0) NOT NULL ,
1031 [rank_image] [varchar] (255) DEFAULT ('') NOT NULL
1032 ) ON [PRIMARY]
1033 GO
1034
1035 ALTER TABLE [phpbb_ranks] WITH NOCHECK ADD
1036 CONSTRAINT [PK_phpbb_ranks] PRIMARY KEY CLUSTERED
1037 (
1038 [rank_id]
1039 ) ON [PRIMARY]
1040 GO
1041
1042
1043 /*
1044 Table: 'phpbb_reports'
1045 */
1046 CREATE TABLE [phpbb_reports] (
1047 [report_id] [int] IDENTITY (1, 1) NOT NULL ,
1048 [reason_id] [int] DEFAULT (0) NOT NULL ,
1049 [post_id] [int] DEFAULT (0) NOT NULL ,
1050 [user_id] [int] DEFAULT (0) NOT NULL ,
1051 [user_notify] [int] DEFAULT (0) NOT NULL ,
1052 [report_closed] [int] DEFAULT (0) NOT NULL ,
1053 [report_time] [int] DEFAULT (0) NOT NULL ,
1054 [report_text] [text] DEFAULT ('') NOT NULL
1055 ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
1056 GO
1057
1058 ALTER TABLE [phpbb_reports] WITH NOCHECK ADD
1059 CONSTRAINT [PK_phpbb_reports] PRIMARY KEY CLUSTERED
1060 (
1061 [report_id]
1062 ) ON [PRIMARY]
1063 GO
1064
1065
1066 /*
1067 Table: 'phpbb_reports_reasons'
1068 */
1069 CREATE TABLE [phpbb_reports_reasons] (
1070 [reason_id] [int] IDENTITY (1, 1) NOT NULL ,
1071 [reason_title] [varchar] (255) DEFAULT ('') NOT NULL ,
1072 [reason_description] [text] DEFAULT ('') NOT NULL ,
1073 [reason_order] [int] DEFAULT (0) NOT NULL
1074 ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
1075 GO
1076
1077 ALTER TABLE [phpbb_reports_reasons] WITH NOCHECK ADD
1078 CONSTRAINT [PK_phpbb_reports_reasons] PRIMARY KEY CLUSTERED
1079 (
1080 [reason_id]
1081 ) ON [PRIMARY]
1082 GO
1083
1084
1085 /*
1086 Table: 'phpbb_search_results'
1087 */
1088 CREATE TABLE [phpbb_search_results] (
1089 [search_key] [varchar] (32) DEFAULT ('') NOT NULL ,
1090 [search_time] [int] DEFAULT (0) NOT NULL ,
1091 [search_keywords] [text] DEFAULT ('') NOT NULL ,
1092 [search_authors] [text] DEFAULT ('') NOT NULL
1093 ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
1094 GO
1095
1096 ALTER TABLE [phpbb_search_results] WITH NOCHECK ADD
1097 CONSTRAINT [PK_phpbb_search_results] PRIMARY KEY CLUSTERED
1098 (
1099 [search_key]
1100 ) ON [PRIMARY]
1101 GO
1102
1103
1104 /*
1105 Table: 'phpbb_search_wordlist'
1106 */
1107 CREATE TABLE [phpbb_search_wordlist] (
1108 [word_id] [int] IDENTITY (1, 1) NOT NULL ,
1109 [word_text] [varchar] (255) DEFAULT ('') NOT NULL ,
1110 [word_common] [int] DEFAULT (0) NOT NULL ,
1111 [word_count] [int] DEFAULT (0) NOT NULL
1112 ) ON [PRIMARY]
1113 GO
1114
1115 ALTER TABLE [phpbb_search_wordlist] WITH NOCHECK ADD
1116 CONSTRAINT [PK_phpbb_search_wordlist] PRIMARY KEY CLUSTERED
1117 (
1118 [word_id]
1119 ) ON [PRIMARY]
1120 GO
1121
1122 CREATE UNIQUE INDEX [wrd_txt] ON [phpbb_search_wordlist]([word_text]) ON [PRIMARY]
1123 GO
1124
1125 CREATE INDEX [wrd_cnt] ON [phpbb_search_wordlist]([word_count]) ON [PRIMARY]
1126 GO
1127
1128
1129 /*
1130 Table: 'phpbb_search_wordmatch'
1131 */
1132 CREATE TABLE [phpbb_search_wordmatch] (
1133 [post_id] [int] DEFAULT (0) NOT NULL ,
1134 [word_id] [int] DEFAULT (0) NOT NULL ,
1135 [title_match] [int] DEFAULT (0) NOT NULL
1136 ) ON [PRIMARY]
1137 GO
1138
1139 CREATE UNIQUE INDEX [unq_mtch] ON [phpbb_search_wordmatch]([word_id], [post_id], [title_match]) ON [PRIMARY]
1140 GO
1141
1142 CREATE INDEX [word_id] ON [phpbb_search_wordmatch]([word_id]) ON [PRIMARY]
1143 GO
1144
1145 CREATE INDEX [post_id] ON [phpbb_search_wordmatch]([post_id]) ON [PRIMARY]
1146 GO
1147
1148
1149 /*
1150 Table: 'phpbb_sessions'
1151 */
1152 CREATE TABLE [phpbb_sessions] (
1153 [session_id] [char] (32) DEFAULT ('') NOT NULL ,
1154 [session_user_id] [int] DEFAULT (0) NOT NULL ,
1155 [session_last_visit] [int] DEFAULT (0) NOT NULL ,
1156 [session_start] [int] DEFAULT (0) NOT NULL ,
1157 [session_time] [int] DEFAULT (0) NOT NULL ,
1158 [session_ip] [varchar] (40) DEFAULT ('') NOT NULL ,
1159 [session_browser] [varchar] (150) DEFAULT ('') NOT NULL ,
1160 [session_forwarded_for] [varchar] (255) DEFAULT ('') NOT NULL ,
1161 [session_page] [varchar] (255) DEFAULT ('') NOT NULL ,
1162 [session_viewonline] [int] DEFAULT (1) NOT NULL ,
1163 [session_autologin] [int] DEFAULT (0) NOT NULL ,
1164 [session_admin] [int] DEFAULT (0) NOT NULL
1165 ) ON [PRIMARY]
1166 GO
1167
1168 ALTER TABLE [phpbb_sessions] WITH NOCHECK ADD
1169 CONSTRAINT [PK_phpbb_sessions] PRIMARY KEY CLUSTERED
1170 (
1171 [session_id]
1172 ) ON [PRIMARY]
1173 GO
1174
1175 CREATE INDEX [session_time] ON [phpbb_sessions]([session_time]) ON [PRIMARY]
1176 GO
1177
1178 CREATE INDEX [session_user_id] ON [phpbb_sessions]([session_user_id]) ON [PRIMARY]
1179 GO
1180
1181
1182 /*
1183 Table: 'phpbb_sessions_keys'
1184 */
1185 CREATE TABLE [phpbb_sessions_keys] (
1186 [key_id] [char] (32) DEFAULT ('') NOT NULL ,
1187 [user_id] [int] DEFAULT (0) NOT NULL ,
1188 [last_ip] [varchar] (40) DEFAULT ('') NOT NULL ,
1189 [last_login] [int] DEFAULT (0) NOT NULL
1190 ) ON [PRIMARY]
1191 GO
1192
1193 ALTER TABLE [phpbb_sessions_keys] WITH NOCHECK ADD
1194 CONSTRAINT [PK_phpbb_sessions_keys] PRIMARY KEY CLUSTERED
1195 (
1196 [key_id],
1197 [user_id]
1198 ) ON [PRIMARY]
1199 GO
1200
1201 CREATE INDEX [last_login] ON [phpbb_sessions_keys]([last_login]) ON [PRIMARY]
1202 GO
1203
1204
1205 /*
1206 Table: 'phpbb_sitelist'
1207 */
1208 CREATE TABLE [phpbb_sitelist] (
1209 [site_id] [int] IDENTITY (1, 1) NOT NULL ,
1210 [site_ip] [varchar] (40) DEFAULT ('') NOT NULL ,
1211 [site_hostname] [varchar] (255) DEFAULT ('') NOT NULL ,
1212 [ip_exclude] [int] DEFAULT (0) NOT NULL
1213 ) ON [PRIMARY]
1214 GO
1215
1216 ALTER TABLE [phpbb_sitelist] WITH NOCHECK ADD
1217 CONSTRAINT [PK_phpbb_sitelist] PRIMARY KEY CLUSTERED
1218 (
1219 [site_id]
1220 ) ON [PRIMARY]
1221 GO
1222
1223
1224 /*
1225 Table: 'phpbb_smilies'
1226 */
1227 CREATE TABLE [phpbb_smilies] (
1228 [smiley_id] [int] IDENTITY (1, 1) NOT NULL ,
1229 [code] [varchar] (50) DEFAULT ('') NOT NULL ,
1230 [emotion] [varchar] (50) DEFAULT ('') NOT NULL ,
1231 [smiley_url] [varchar] (50) DEFAULT ('') NOT NULL ,
1232 [smiley_width] [int] DEFAULT (0) NOT NULL ,
1233 [smiley_height] [int] DEFAULT (0) NOT NULL ,
1234 [smiley_order] [int] DEFAULT (0) NOT NULL ,
1235 [display_on_posting] [int] DEFAULT (1) NOT NULL
1236 ) ON [PRIMARY]
1237 GO
1238
1239 ALTER TABLE [phpbb_smilies] WITH NOCHECK ADD
1240 CONSTRAINT [PK_phpbb_smilies] PRIMARY KEY CLUSTERED
1241 (
1242 [smiley_id]
1243 ) ON [PRIMARY]
1244 GO
1245
1246 CREATE INDEX [display_on_post] ON [phpbb_smilies]([display_on_posting]) ON [PRIMARY]
1247 GO
1248
1249
1250 /*
1251 Table: 'phpbb_styles'
1252 */
1253 CREATE TABLE [phpbb_styles] (
1254 [style_id] [int] IDENTITY (1, 1) NOT NULL ,
1255 [style_name] [varchar] (255) DEFAULT ('') NOT NULL ,
1256 [style_copyright] [varchar] (255) DEFAULT ('') NOT NULL ,
1257 [style_active] [int] DEFAULT (1) NOT NULL ,
1258 [template_id] [int] DEFAULT (0) NOT NULL ,
1259 [theme_id] [int] DEFAULT (0) NOT NULL ,
1260 [imageset_id] [int] DEFAULT (0) NOT NULL
1261 ) ON [PRIMARY]
1262 GO
1263
1264 ALTER TABLE [phpbb_styles] WITH NOCHECK ADD
1265 CONSTRAINT [PK_phpbb_styles] PRIMARY KEY CLUSTERED
1266 (
1267 [style_id]
1268 ) ON [PRIMARY]
1269 GO
1270
1271 CREATE UNIQUE INDEX [style_name] ON [phpbb_styles]([style_name]) ON [PRIMARY]
1272 GO
1273
1274 CREATE INDEX [template_id] ON [phpbb_styles]([template_id]) ON [PRIMARY]
1275 GO
1276
1277 CREATE INDEX [theme_id] ON [phpbb_styles]([theme_id]) ON [PRIMARY]
1278 GO
1279
1280 CREATE INDEX [imageset_id] ON [phpbb_styles]([imageset_id]) ON [PRIMARY]
1281 GO
1282
1283
1284 /*
1285 Table: 'phpbb_styles_template'
1286 */
1287 CREATE TABLE [phpbb_styles_template] (
1288 [template_id] [int] IDENTITY (1, 1) NOT NULL ,
1289 [template_name] [varchar] (255) DEFAULT ('') NOT NULL ,
1290 [template_copyright] [varchar] (255) DEFAULT ('') NOT NULL ,
1291 [template_path] [varchar] (100) DEFAULT ('') NOT NULL ,
1292 [bbcode_bitfield] [varchar] (255) DEFAULT ('kNg=') NOT NULL ,
1293 [template_storedb] [int] DEFAULT (0) NOT NULL
1294 ) ON [PRIMARY]
1295 GO
1296
1297 ALTER TABLE [phpbb_styles_template] WITH NOCHECK ADD
1298 CONSTRAINT [PK_phpbb_styles_template] PRIMARY KEY CLUSTERED
1299 (
1300 [template_id]
1301 ) ON [PRIMARY]
1302 GO
1303
1304 CREATE UNIQUE INDEX [tmplte_nm] ON [phpbb_styles_template]([template_name]) ON [PRIMARY]
1305 GO
1306
1307
1308 /*
1309 Table: 'phpbb_styles_template_data'
1310 */
1311 CREATE TABLE [phpbb_styles_template_data] (
1312 [template_id] [int] DEFAULT (0) NOT NULL ,
1313 [template_filename] [varchar] (100) DEFAULT ('') NOT NULL ,
1314 [template_included] [varchar] (8000) DEFAULT ('') NOT NULL ,
1315 [template_mtime] [int] DEFAULT (0) NOT NULL ,
1316 [template_data] [text] DEFAULT ('') NOT NULL
1317 ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
1318 GO
1319
1320 CREATE INDEX [tid] ON [phpbb_styles_template_data]([template_id]) ON [PRIMARY]
1321 GO
1322
1323 CREATE INDEX [tfn] ON [phpbb_styles_template_data]([template_filename]) ON [PRIMARY]
1324 GO
1325
1326
1327 /*
1328 Table: 'phpbb_styles_theme'
1329 */
1330 CREATE TABLE [phpbb_styles_theme] (
1331 [theme_id] [int] IDENTITY (1, 1) NOT NULL ,
1332 [theme_name] [varchar] (255) DEFAULT ('') NOT NULL ,
1333 [theme_copyright] [varchar] (255) DEFAULT ('') NOT NULL ,
1334 [theme_path] [varchar] (100) DEFAULT ('') NOT NULL ,
1335 [theme_storedb] [int] DEFAULT (0) NOT NULL ,
1336 [theme_mtime] [int] DEFAULT (0) NOT NULL ,
1337 [theme_data] [text] DEFAULT ('') NOT NULL
1338 ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
1339 GO
1340
1341 ALTER TABLE [phpbb_styles_theme] WITH NOCHECK ADD
1342 CONSTRAINT [PK_phpbb_styles_theme] PRIMARY KEY CLUSTERED
1343 (
1344 [theme_id]
1345 ) ON [PRIMARY]
1346 GO
1347
1348 CREATE UNIQUE INDEX [theme_name] ON [phpbb_styles_theme]([theme_name]) ON [PRIMARY]
1349 GO
1350
1351
1352 /*
1353 Table: 'phpbb_styles_imageset'
1354 */
1355 CREATE TABLE [phpbb_styles_imageset] (
1356 [imageset_id] [int] IDENTITY (1, 1) NOT NULL ,
1357 [imageset_name] [varchar] (255) DEFAULT ('') NOT NULL ,
1358 [imageset_copyright] [varchar] (255) DEFAULT ('') NOT NULL ,
1359 [imageset_path] [varchar] (100) DEFAULT ('') NOT NULL
1360 ) ON [PRIMARY]
1361 GO
1362
1363 ALTER TABLE [phpbb_styles_imageset] WITH NOCHECK ADD
1364 CONSTRAINT [PK_phpbb_styles_imageset] PRIMARY KEY CLUSTERED
1365 (
1366 [imageset_id]
1367 ) ON [PRIMARY]
1368 GO
1369
1370 CREATE UNIQUE INDEX [imgset_nm] ON [phpbb_styles_imageset]([imageset_name]) ON [PRIMARY]
1371 GO
1372
1373
1374 /*
1375 Table: 'phpbb_styles_imageset_data'
1376 */
1377 CREATE TABLE [phpbb_styles_imageset_data] (
1378 [image_id] [int] IDENTITY (1, 1) NOT NULL ,
1379 [image_name] [varchar] (200) DEFAULT ('') NOT NULL ,
1380 [image_filename] [varchar] (200) DEFAULT ('') NOT NULL ,
1381 [image_lang] [varchar] (30) DEFAULT ('') NOT NULL ,
1382 [image_height] [int] DEFAULT (0) NOT NULL ,
1383 [image_width] [int] DEFAULT (0) NOT NULL ,
1384 [imageset_id] [int] DEFAULT (0) NOT NULL
1385 ) ON [PRIMARY]
1386 GO
1387
1388 ALTER TABLE [phpbb_styles_imageset_data] WITH NOCHECK ADD
1389 CONSTRAINT [PK_phpbb_styles_imageset_data] PRIMARY KEY CLUSTERED
1390 (
1391 [image_id]
1392 ) ON [PRIMARY]
1393 GO
1394
1395 CREATE INDEX [i_d] ON [phpbb_styles_imageset_data]([imageset_id]) ON [PRIMARY]
1396 GO
1397
1398
1399 /*
1400 Table: 'phpbb_topics'
1401 */
1402 CREATE TABLE [phpbb_topics] (
1403 [topic_id] [int] IDENTITY (1, 1) NOT NULL ,
1404 [forum_id] [int] DEFAULT (0) NOT NULL ,
1405 [icon_id] [int] DEFAULT (0) NOT NULL ,
1406 [topic_attachment] [int] DEFAULT (0) NOT NULL ,
1407 [topic_approved] [int] DEFAULT (1) NOT NULL ,
1408 [topic_reported] [int] DEFAULT (0) NOT NULL ,
1409 [topic_title] [varchar] (100) DEFAULT ('') NOT NULL ,
1410 [topic_poster] [int] DEFAULT (0) NOT NULL ,
1411 [topic_time] [int] DEFAULT (0) NOT NULL ,
1412 [topic_time_limit] [int] DEFAULT (0) NOT NULL ,
1413 [topic_views] [int] DEFAULT (0) NOT NULL ,
1414 [topic_replies] [int] DEFAULT (0) NOT NULL ,
1415 [topic_replies_real] [int] DEFAULT (0) NOT NULL ,
1416 [topic_status] [int] DEFAULT (0) NOT NULL ,
1417 [topic_type] [int] DEFAULT (0) NOT NULL ,
1418 [topic_first_post_id] [int] DEFAULT (0) NOT NULL ,
1419 [topic_first_poster_name] [varchar] (255) DEFAULT ('') NOT NULL ,
1420 [topic_first_poster_colour] [varchar] (6) DEFAULT ('') NOT NULL ,
1421 [topic_last_post_id] [int] DEFAULT (0) NOT NULL ,
1422 [topic_last_poster_id] [int] DEFAULT (0) NOT NULL ,
1423 [topic_last_poster_name] [varchar] (255) DEFAULT ('') NOT NULL ,
1424 [topic_last_poster_colour] [varchar] (6) DEFAULT ('') NOT NULL ,
1425 [topic_last_post_subject] [varchar] (100) DEFAULT ('') NOT NULL ,
1426 [topic_last_post_time] [int] DEFAULT (0) NOT NULL ,
1427 [topic_last_view_time] [int] DEFAULT (0) NOT NULL ,
1428 [topic_moved_id] [int] DEFAULT (0) NOT NULL ,
1429 [topic_bumped] [int] DEFAULT (0) NOT NULL ,
1430 [topic_bumper] [int] DEFAULT (0) NOT NULL ,
1431 [poll_title] [varchar] (255) DEFAULT ('') NOT NULL ,
1432 [poll_start] [int] DEFAULT (0) NOT NULL ,
1433 [poll_length] [int] DEFAULT (0) NOT NULL ,
1434 [poll_max_options] [int] DEFAULT (1) NOT NULL ,
1435 [poll_last_vote] [int] DEFAULT (0) NOT NULL ,
1436 [poll_vote_change] [int] DEFAULT (0) NOT NULL
1437 ) ON [PRIMARY]
1438 GO
1439
1440 ALTER TABLE [phpbb_topics] WITH NOCHECK ADD
1441 CONSTRAINT [PK_phpbb_topics] PRIMARY KEY CLUSTERED
1442 (
1443 [topic_id]
1444 ) ON [PRIMARY]
1445 GO
1446
1447 CREATE INDEX [forum_id] ON [phpbb_topics]([forum_id]) ON [PRIMARY]
1448 GO
1449
1450 CREATE INDEX [forum_id_type] ON [phpbb_topics]([forum_id], [topic_type]) ON [PRIMARY]
1451 GO
1452
1453 CREATE INDEX [last_post_time] ON [phpbb_topics]([topic_last_post_time]) ON [PRIMARY]
1454 GO
1455
1456 CREATE INDEX [topic_approved] ON [phpbb_topics]([topic_approved]) ON [PRIMARY]
1457 GO
1458
1459 CREATE INDEX [forum_appr_last] ON [phpbb_topics]([forum_id], [topic_approved], [topic_last_post_id]) ON [PRIMARY]
1460 GO
1461
1462 CREATE INDEX [fid_time_moved] ON [phpbb_topics]([forum_id], [topic_last_post_time], [topic_moved_id]) ON [PRIMARY]
1463 GO
1464
1465
1466 /*
1467 Table: 'phpbb_topics_track'
1468 */
1469 CREATE TABLE [phpbb_topics_track] (
1470 [user_id] [int] DEFAULT (0) NOT NULL ,
1471 [topic_id] [int] DEFAULT (0) NOT NULL ,
1472 [forum_id] [int] DEFAULT (0) NOT NULL ,
1473 [mark_time] [int] DEFAULT (0) NOT NULL
1474 ) ON [PRIMARY]
1475 GO
1476
1477 ALTER TABLE [phpbb_topics_track] WITH NOCHECK ADD
1478 CONSTRAINT [PK_phpbb_topics_track] PRIMARY KEY CLUSTERED
1479 (
1480 [user_id],
1481 [topic_id]
1482 ) ON [PRIMARY]
1483 GO
1484
1485 CREATE INDEX [forum_id] ON [phpbb_topics_track]([forum_id]) ON [PRIMARY]
1486 GO
1487
1488
1489 /*
1490 Table: 'phpbb_topics_posted'
1491 */
1492 CREATE TABLE [phpbb_topics_posted] (
1493 [user_id] [int] DEFAULT (0) NOT NULL ,
1494 [topic_id] [int] DEFAULT (0) NOT NULL ,
1495 [topic_posted] [int] DEFAULT (0) NOT NULL
1496 ) ON [PRIMARY]
1497 GO
1498
1499 ALTER TABLE [phpbb_topics_posted] WITH NOCHECK ADD
1500 CONSTRAINT [PK_phpbb_topics_posted] PRIMARY KEY CLUSTERED
1501 (
1502 [user_id],
1503 [topic_id]
1504 ) ON [PRIMARY]
1505 GO
1506
1507
1508 /*
1509 Table: 'phpbb_topics_watch'
1510 */
1511 CREATE TABLE [phpbb_topics_watch] (
1512 [topic_id] [int] DEFAULT (0) NOT NULL ,
1513 [user_id] [int] DEFAULT (0) NOT NULL ,
1514 [notify_status] [int] DEFAULT (0) NOT NULL
1515 ) ON [PRIMARY]
1516 GO
1517
1518 CREATE INDEX [topic_id] ON [phpbb_topics_watch]([topic_id]) ON [PRIMARY]
1519 GO
1520
1521 CREATE INDEX [user_id] ON [phpbb_topics_watch]([user_id]) ON [PRIMARY]
1522 GO
1523
1524 CREATE INDEX [notify_stat] ON [phpbb_topics_watch]([notify_status]) ON [PRIMARY]
1525 GO
1526
1527
1528 /*
1529 Table: 'phpbb_user_group'
1530 */
1531 CREATE TABLE [phpbb_user_group] (
1532 [group_id] [int] DEFAULT (0) NOT NULL ,
1533 [user_id] [int] DEFAULT (0) NOT NULL ,
1534 [group_leader] [int] DEFAULT (0) NOT NULL ,
1535 [user_pending] [int] DEFAULT (1) NOT NULL
1536 ) ON [PRIMARY]
1537 GO
1538
1539 CREATE INDEX [group_id] ON [phpbb_user_group]([group_id]) ON [PRIMARY]
1540 GO
1541
1542 CREATE INDEX [user_id] ON [phpbb_user_group]([user_id]) ON [PRIMARY]
1543 GO
1544
1545 CREATE INDEX [group_leader] ON [phpbb_user_group]([group_leader]) ON [PRIMARY]
1546 GO
1547
1548
1549 /*
1550 Table: 'phpbb_users'
1551 */
1552 CREATE TABLE [phpbb_users] (
1553 [user_id] [int] IDENTITY (1, 1) NOT NULL ,
1554 [user_type] [int] DEFAULT (0) NOT NULL ,
1555 [group_id] [int] DEFAULT (3) NOT NULL ,
1556 [user_permissions] [text] DEFAULT ('') NOT NULL ,
1557 [user_perm_from] [int] DEFAULT (0) NOT NULL ,
1558 [user_ip] [varchar] (40) DEFAULT ('') NOT NULL ,
1559 [user_regdate] [int] DEFAULT (0) NOT NULL ,
1560 [username] [varchar] (255) DEFAULT ('') NOT NULL ,
1561 [username_clean] [varchar] (255) DEFAULT ('') NOT NULL ,
1562 [user_password] [varchar] (40) DEFAULT ('') NOT NULL ,
1563 [user_passchg] [int] DEFAULT (0) NOT NULL ,
1564 [user_pass_convert] [int] DEFAULT (0) NOT NULL ,
1565 [user_email] [varchar] (100) DEFAULT ('') NOT NULL ,
1566 [user_email_hash] [float] DEFAULT (0) NOT NULL ,
1567 [user_birthday] [varchar] (10) DEFAULT ('') NOT NULL ,
1568 [user_lastvisit] [int] DEFAULT (0) NOT NULL ,
1569 [user_lastmark] [int] DEFAULT (0) NOT NULL ,
1570 [user_lastpost_time] [int] DEFAULT (0) NOT NULL ,
1571 [user_lastpage] [varchar] (200) DEFAULT ('') NOT NULL ,
1572 [user_last_confirm_key] [varchar] (10) DEFAULT ('') NOT NULL ,
1573 [user_last_search] [int] DEFAULT (0) NOT NULL ,
1574 [user_warnings] [int] DEFAULT (0) NOT NULL ,
1575 [user_last_warning] [int] DEFAULT (0) NOT NULL ,
1576 [user_login_attempts] [int] DEFAULT (0) NOT NULL ,
1577 [user_inactive_reason] [int] DEFAULT (0) NOT NULL ,
1578 [user_inactive_time] [int] DEFAULT (0) NOT NULL ,
1579 [user_posts] [int] DEFAULT (0) NOT NULL ,
1580 [user_lang] [varchar] (30) DEFAULT ('') NOT NULL ,
1581 [user_timezone] [float] DEFAULT (0) NOT NULL ,
1582 [user_dst] [int] DEFAULT (0) NOT NULL ,
1583 [user_dateformat] [varchar] (30) DEFAULT ('d M Y H:i') NOT NULL ,
1584 [user_style] [int] DEFAULT (0) NOT NULL ,
1585 [user_rank] [int] DEFAULT (0) NOT NULL ,
1586 [user_colour] [varchar] (6) DEFAULT ('') NOT NULL ,
1587 [user_new_privmsg] [int] DEFAULT (0) NOT NULL ,
1588 [user_unread_privmsg] [int] DEFAULT (0) NOT NULL ,
1589 [user_last_privmsg] [int] DEFAULT (0) NOT NULL ,
1590 [user_message_rules] [int] DEFAULT (0) NOT NULL ,
1591 [user_full_folder] [int] DEFAULT (-3) NOT NULL ,
1592 [user_emailtime] [int] DEFAULT (0) NOT NULL ,
1593 [user_topic_show_days] [int] DEFAULT (0) NOT NULL ,
1594 [user_topic_sortby_type] [varchar] (1) DEFAULT ('t') NOT NULL ,
1595 [user_topic_sortby_dir] [varchar] (1) DEFAULT ('d') NOT NULL ,
1596 [user_post_show_days] [int] DEFAULT (0) NOT NULL ,
1597 [user_post_sortby_type] [varchar] (1) DEFAULT ('t') NOT NULL ,
1598 [user_post_sortby_dir] [varchar] (1) DEFAULT ('a') NOT NULL ,
1599 [user_notify] [int] DEFAULT (0) NOT NULL ,
1600 [user_notify_pm] [int] DEFAULT (1) NOT NULL ,
1601 [user_notify_type] [int] DEFAULT (0) NOT NULL ,
1602 [user_allow_pm] [int] DEFAULT (1) NOT NULL ,
1603 [user_allow_viewonline] [int] DEFAULT (1) NOT NULL ,
1604 [user_allow_viewemail] [int] DEFAULT (1) NOT NULL ,
1605 [user_allow_massemail] [int] DEFAULT (1) NOT NULL ,
1606 [user_options] [int] DEFAULT (895) NOT NULL ,
1607 [user_avatar] [varchar] (255) DEFAULT ('') NOT NULL ,
1608 [user_avatar_type] [int] DEFAULT (0) NOT NULL ,
1609 [user_avatar_width] [int] DEFAULT (0) NOT NULL ,
1610 [user_avatar_height] [int] DEFAULT (0) NOT NULL ,
1611 [user_sig] [text] DEFAULT ('') NOT NULL ,
1612 [user_sig_bbcode_uid] [varchar] (8) DEFAULT ('') NOT NULL ,
1613 [user_sig_bbcode_bitfield] [varchar] (255) DEFAULT ('') NOT NULL ,
1614 [user_from] [varchar] (100) DEFAULT ('') NOT NULL ,
1615 [user_icq] [varchar] (15) DEFAULT ('') NOT NULL ,
1616 [user_aim] [varchar] (255) DEFAULT ('') NOT NULL ,
1617 [user_yim] [varchar] (255) DEFAULT ('') NOT NULL ,
1618 [user_msnm] [varchar] (255) DEFAULT ('') NOT NULL ,
1619 [user_jabber] [varchar] (255) DEFAULT ('') NOT NULL ,
1620 [user_website] [varchar] (200) DEFAULT ('') NOT NULL ,
1621 [user_occ] [varchar] (4000) DEFAULT ('') NOT NULL ,
1622 [user_interests] [varchar] (4000) DEFAULT ('') NOT NULL ,
1623 [user_actkey] [varchar] (32) DEFAULT ('') NOT NULL ,
1624 [user_newpasswd] [varchar] (40) DEFAULT ('') NOT NULL ,
1625 [user_form_salt] [varchar] (32) DEFAULT ('') NOT NULL
1626 ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
1627 GO
1628
1629 ALTER TABLE [phpbb_users] WITH NOCHECK ADD
1630 CONSTRAINT [PK_phpbb_users] PRIMARY KEY CLUSTERED
1631 (
1632 [user_id]
1633 ) ON [PRIMARY]
1634 GO
1635
1636 CREATE INDEX [user_birthday] ON [phpbb_users]([user_birthday]) ON [PRIMARY]
1637 GO
1638
1639 CREATE INDEX [user_email_hash] ON [phpbb_users]([user_email_hash]) ON [PRIMARY]
1640 GO
1641
1642 CREATE INDEX [user_type] ON [phpbb_users]([user_type]) ON [PRIMARY]
1643 GO
1644
1645 CREATE UNIQUE INDEX [username_clean] ON [phpbb_users]([username_clean]) ON [PRIMARY]
1646 GO
1647
1648
1649 /*
1650 Table: 'phpbb_warnings'
1651 */
1652 CREATE TABLE [phpbb_warnings] (
1653 [warning_id] [int] IDENTITY (1, 1) NOT NULL ,
1654 [user_id] [int] DEFAULT (0) NOT NULL ,
1655 [post_id] [int] DEFAULT (0) NOT NULL ,
1656 [log_id] [int] DEFAULT (0) NOT NULL ,
1657 [warning_time] [int] DEFAULT (0) NOT NULL
1658 ) ON [PRIMARY]
1659 GO
1660
1661 ALTER TABLE [phpbb_warnings] WITH NOCHECK ADD
1662 CONSTRAINT [PK_phpbb_warnings] PRIMARY KEY CLUSTERED
1663 (
1664 [warning_id]
1665 ) ON [PRIMARY]
1666 GO
1667
1668
1669 /*
1670 Table: 'phpbb_words'
1671 */
1672 CREATE TABLE [phpbb_words] (
1673 [word_id] [int] IDENTITY (1, 1) NOT NULL ,
1674 [word] [varchar] (255) DEFAULT ('') NOT NULL ,
1675 [replacement] [varchar] (255) DEFAULT ('') NOT NULL
1676 ) ON [PRIMARY]
1677 GO
1678
1679 ALTER TABLE [phpbb_words] WITH NOCHECK ADD
1680 CONSTRAINT [PK_phpbb_words] PRIMARY KEY CLUSTERED
1681 (
1682 [word_id]
1683 ) ON [PRIMARY]
1684 GO
1685
1686
1687 /*
1688 Table: 'phpbb_zebra'
1689 */
1690 CREATE TABLE [phpbb_zebra] (
1691 [user_id] [int] DEFAULT (0) NOT NULL ,
1692 [zebra_id] [int] DEFAULT (0) NOT NULL ,
1693 [friend] [int] DEFAULT (0) NOT NULL ,
1694 [foe] [int] DEFAULT (0) NOT NULL
1695 ) ON [PRIMARY]
1696 GO
1697
1698 ALTER TABLE [phpbb_zebra] WITH NOCHECK ADD
1699 CONSTRAINT [PK_phpbb_zebra] PRIMARY KEY CLUSTERED
1700 (
1701 [user_id],
1702 [zebra_id]
1703 ) ON [PRIMARY]
1704 GO
1705
1706
1707
1708 COMMIT
1709 GO
1710
1711