3 MSSQL Schema for phpBB 3.x - (c) phpBB Group, 2005
13 Table: phpbb_attachments
15 CREATE TABLE [phpbb_attachments] (
16 [attach_id] [int] IDENTITY (1, 1) NOT NULL ,
17 [post_msg_id] [int] NOT NULL ,
18 [topic_id] [int] NOT NULL ,
19 [in_message] [int] NOT NULL ,
20 [poster_id] [int] NOT NULL ,
21 [physical_filename] [varchar] (255) NOT NULL ,
22 [real_filename] [varchar] (255) NOT NULL ,
23 [download_count] [int] NOT NULL ,
24 [comment] [varchar] (8000) ,
25 [extension] [varchar] (100) NULL ,
26 [mimetype] [varchar] (100) NULL ,
27 [filesize] [int] NOT NULL ,
28 [filetime] [int] NOT NULL ,
29 [thumbnail] [int] NOT NULL
33 ALTER TABLE [phpbb_attachments] WITH NOCHECK ADD
34 CONSTRAINT [PK_phpbb_attachments] PRIMARY KEY CLUSTERED
40 ALTER TABLE [phpbb_attachments] WITH NOCHECK ADD
41 CONSTRAINT [DF_phpbb_attach_post_msg_id] DEFAULT (0) FOR [post_msg_id],
42 CONSTRAINT [DF_phpbb_attach_topic_id] DEFAULT (0) FOR [topic_id],
43 CONSTRAINT [DF_phpbb_attach_in_message] DEFAULT (0) FOR [in_message],
44 CONSTRAINT [DF_phpbb_attach_poster_id] DEFAULT (0) FOR [poster_id],
45 CONSTRAINT [DF_phpbb_attach_download_count] DEFAULT (0) FOR [download_count],
46 CONSTRAINT [DF_phpbb_attach_filetime] DEFAULT (0) FOR [filetime],
47 CONSTRAINT [DF_phpbb_attach_filesize] DEFAULT (0) FOR [filesize],
48 CONSTRAINT [DF_phpbb_attach_thumbnail] DEFAULT (0) FOR [thumbnail]
51 CREATE INDEX [filetime] ON [phpbb_attachments]([filetime]) ON [PRIMARY]
54 CREATE INDEX [post_msg_id] ON [phpbb_attachments]([post_msg_id]) ON [PRIMARY]
57 CREATE INDEX [topic_id] ON [phpbb_attachments]([topic_id]) ON [PRIMARY]
60 CREATE INDEX [poster_id] ON [phpbb_attachments]([poster_id]) ON [PRIMARY]
63 CREATE INDEX [physical_filename] ON [phpbb_attachments]([physical_filename]) ON [PRIMARY]
66 CREATE INDEX [filesize] ON [phpbb_attachments]([filesize]) ON [PRIMARY]
71 Table: phpbb_acl_groups
73 CREATE TABLE [phpbb_acl_groups] (
74 [group_id] [int] NOT NULL ,
75 [forum_id] [int] NOT NULL ,
76 [auth_option_id] [int] NOT NULL ,
77 [auth_role_id] [int] NOT NULL ,
78 [auth_setting] [int] NOT NULL
82 ALTER TABLE [phpbb_acl_groups] WITH NOCHECK ADD
83 CONSTRAINT [DF_phpbb_acl_g_group_id] DEFAULT (0) FOR [group_id],
84 CONSTRAINT [DF_phpbb_acl_g_forum_id] DEFAULT (0) FOR [forum_id],
85 CONSTRAINT [DF_phpbb_acl_g_auth_option_id] DEFAULT (0) FOR [auth_option_id],
86 CONSTRAINT [DF_phpbb_acl_g_auth_role_id] DEFAULT (0) FOR [auth_role_id],
87 CONSTRAINT [DF_phpbb_acl_g_auth_setting] DEFAULT (0) FOR [auth_setting]
90 CREATE INDEX [group_id] ON [phpbb_acl_groups]([group_id]) ON [PRIMARY]
93 CREATE INDEX [auth_option_id] ON [phpbb_acl_groups]([auth_option_id]) ON [PRIMARY]
98 Table: phpbb_acl_options
100 CREATE TABLE [phpbb_acl_options] (
101 [auth_option_id] [int] IDENTITY (1, 1) NOT NULL ,
102 [auth_option] [varchar] (50) NOT NULL ,
103 [is_global] [int] NOT NULL ,
104 [is_local] [int] NOT NULL ,
105 [founder_only] [int] NOT NULL
109 ALTER TABLE [phpbb_acl_options] WITH NOCHECK ADD
110 CONSTRAINT [PK_phpbb_acl_options] PRIMARY KEY CLUSTERED
116 ALTER TABLE [phpbb_acl_options] WITH NOCHECK ADD
117 CONSTRAINT [DF_phpbb_acl_o_is_global] DEFAULT (0) FOR [is_global],
118 CONSTRAINT [DF_phpbb_acl_o_is_local] DEFAULT (0) FOR [is_local],
119 CONSTRAINT [DF_phpbb_acl_o_founder_only] DEFAULT (0) FOR [founder_only]
122 CREATE INDEX [auth_option] ON [phpbb_acl_options]([auth_option]) ON [PRIMARY]
127 Table: phpbb_acl_roles
129 CREATE TABLE [phpbb_acl_roles] (
130 [role_id] [int] IDENTITY (1, 1) NOT NULL ,
131 [role_name] [varchar] (255) NOT NULL ,
132 [role_description] [varchar] (8000) ,
133 [role_type] [varchar] (10) NOT NULL ,
134 [role_order] [int] NOT NULL
138 ALTER TABLE [phpbb_acl_roles] WITH NOCHECK ADD
139 CONSTRAINT [PK_phpbb_acl_roles] PRIMARY KEY CLUSTERED
145 ALTER TABLE [phpbb_acl_roles] WITH NOCHECK ADD
146 CONSTRAINT [DF_phpbb_acl_p_role_role_order] DEFAULT (0) FOR [role_order],
147 CONSTRAINT [DF_phpbb_acl_p_role_role_type] DEFAULT ('') FOR [role_type],
148 CONSTRAINT [DF_phpbb_acl_p_role_role_name] DEFAULT ('') FOR [role_name]
151 CREATE INDEX [role_type] ON [phpbb_acl_roles]([role_type]) ON [PRIMARY]
154 CREATE INDEX [role_order] ON [phpbb_acl_roles]([role_order]) ON [PRIMARY]
159 Table: phpbb_acl_roles_data
161 CREATE TABLE [phpbb_acl_roles_data] (
162 [role_id] [int] NOT NULL ,
163 [auth_option_id] [int] NOT NULL ,
164 [auth_setting] [int] NOT NULL
168 ALTER TABLE [phpbb_acl_roles_data] WITH NOCHECK ADD
169 CONSTRAINT [PK_phpbb_acl_roles_data] PRIMARY KEY CLUSTERED
176 ALTER TABLE [phpbb_acl_roles_data] WITH NOCHECK ADD
177 CONSTRAINT [DF_phpbb_acl_d_role_id] DEFAULT (0) FOR [role_id],
178 CONSTRAINT [DF_phpbb_acl_d_auth_option_id] DEFAULT (0) FOR [auth_option_id],
179 CONSTRAINT [DF_phpbb_acl_d_auth_setting] DEFAULT (0) FOR [auth_setting]
184 Table: phpbb_acl_users
186 CREATE TABLE [phpbb_acl_users] (
187 [user_id] [int] NOT NULL ,
188 [forum_id] [int] NOT NULL ,
189 [auth_option_id] [int] NOT NULL ,
190 [auth_role_id] [int] NOT NULL ,
191 [auth_setting] [int] NOT NULL
195 ALTER TABLE [phpbb_acl_users] WITH NOCHECK ADD
196 CONSTRAINT [DF_phpbb_acl_u_user_id] DEFAULT (0) FOR [user_id],
197 CONSTRAINT [DF_phpbb_acl_u_forum_id] DEFAULT (0) FOR [forum_id],
198 CONSTRAINT [DF_phpbb_acl_u_auth_option_id] DEFAULT (0) FOR [auth_option_id],
199 CONSTRAINT [DF_phpbb_acl_u_auth_role_id] DEFAULT (0) FOR [auth_role_id],
200 CONSTRAINT [DF_phpbb_acl_u_auth_setting] DEFAULT (0) FOR [auth_setting]
203 CREATE INDEX [user_id] ON [phpbb_acl_users]([user_id]) ON [PRIMARY]
206 CREATE INDEX [auth_option_id] ON [phpbb_acl_users]([auth_option_id]) ON [PRIMARY]
213 CREATE TABLE [phpbb_banlist] (
214 [ban_id] [int] IDENTITY (1, 1) NOT NULL ,
215 [ban_userid] [int] NOT NULL ,
216 [ban_ip] [varchar] (40) NOT NULL ,
217 [ban_email] [varchar] (100) NOT NULL ,
218 [ban_start] [int] NOT NULL ,
219 [ban_end] [int] NOT NULL ,
220 [ban_exclude] [int] NOT NULL ,
221 [ban_reason] [varchar] (3000) ,
222 [ban_give_reason] [varchar] (3000)
226 ALTER TABLE [phpbb_banlist] WITH NOCHECK ADD
227 CONSTRAINT [PK_phpbb_banlist] PRIMARY KEY CLUSTERED
233 ALTER TABLE [phpbb_banlist] WITH NOCHECK ADD
234 CONSTRAINT [DF_phpbb_banlis_ban_userid] DEFAULT (0) FOR [ban_userid],
235 CONSTRAINT [DF_phpbb_banlis_ban_start] DEFAULT (0) FOR [ban_start],
236 CONSTRAINT [DF_phpbb_banlis_ban_end] DEFAULT (0) FOR [ban_end],
237 CONSTRAINT [DF_phpbb_banlis_ban_exclude] DEFAULT (0) FOR [ban_exclude],
238 CONSTRAINT [DF_phpbb_banlis_ban_ip] DEFAULT ('') FOR [ban_ip],
239 CONSTRAINT [DF_phpbb_banlis_ban_email] DEFAULT ('') FOR [ban_email]
246 CREATE TABLE [phpbb_bbcodes] (
247 [bbcode_id] [int] NOT NULL ,
248 [bbcode_tag] [varchar] (16) NOT NULL ,
249 [display_on_posting] [int] NOT NULL ,
250 [bbcode_match] [varchar] (255) NOT NULL ,
251 [bbcode_tpl] [text] ,
252 [first_pass_match] [varchar] (255) NOT NULL ,
253 [first_pass_replace] [varchar] (255) NOT NULL ,
254 [second_pass_match] [varchar] (255) NOT NULL ,
255 [second_pass_replace] [text]
256 ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
259 ALTER TABLE [phpbb_bbcodes] WITH NOCHECK ADD
260 CONSTRAINT [PK_phpbb_bbcodes] PRIMARY KEY CLUSTERED
266 ALTER TABLE [phpbb_bbcodes] WITH NOCHECK ADD
267 CONSTRAINT [DF_phpbb_bbcode_bbcode_id] DEFAULT (0) FOR [bbcode_id],
268 CONSTRAINT [DF_phpbb_bbcode_bbcode_tag] DEFAULT ('') FOR [bbcode_tag],
269 CONSTRAINT [DF_phpbb_bbcode_bbcode_match] DEFAULT ('') FOR [bbcode_match],
270 CONSTRAINT [DF_phpbb_bbcode_display_on_posting] DEFAULT (0) FOR [display_on_posting],
271 CONSTRAINT [DF_phpbb_bbcode_first_pass_match] DEFAULT ('') FOR [first_pass_match],
272 CONSTRAINT [DF_phpbb_bbcode_first_pass_replace] DEFAULT ('') FOR [first_pass_replace],
273 CONSTRAINT [DF_phpbb_bbcode_second_pass_match] DEFAULT ('') FOR [second_pass_match]
276 CREATE INDEX [display_on_posting] ON [phpbb_bbcodes]([display_on_posting]) ON [PRIMARY]
281 Table: phpbb_bookmarks
283 CREATE TABLE [phpbb_bookmarks] (
284 [topic_id] [int] NOT NULL ,
285 [user_id] [int] NOT NULL ,
286 [order_id] [int] NOT NULL
290 ALTER TABLE [phpbb_bookmarks] WITH NOCHECK ADD
291 CONSTRAINT [DF_phpbb_bookma_topic_id] DEFAULT (0) FOR [topic_id],
292 CONSTRAINT [DF_phpbb_bookma_user_id] DEFAULT (0) FOR [user_id],
293 CONSTRAINT [DF_phpbb_bookma_order_id] DEFAULT (0) FOR [order_id]
296 CREATE INDEX [order_id] ON [phpbb_bookmarks]([order_id]) ON [PRIMARY]
299 CREATE INDEX [topic_user_id] ON [phpbb_bookmarks]([topic_id], [user_id]) ON [PRIMARY]
306 CREATE TABLE [phpbb_bots] (
307 [bot_id] [int] IDENTITY (1, 1) NOT NULL ,
308 [bot_active] [int] NOT NULL ,
309 [bot_name] [varchar] (1000) ,
310 [user_id] [int] NOT NULL ,
311 [bot_agent] [varchar] (255) NOT NULL ,
312 [bot_ip] [varchar] (255) NOT NULL
316 ALTER TABLE [phpbb_bots] WITH NOCHECK ADD
317 CONSTRAINT [PK_phpbb_bots] PRIMARY KEY CLUSTERED
323 ALTER TABLE [phpbb_bots] WITH NOCHECK ADD
324 CONSTRAINT [DF_phpbb_bots___bot_active] DEFAULT (1) FOR [bot_active],
325 CONSTRAINT [DF_phpbb_bots___user_id] DEFAULT (0) FOR [user_id],
326 CONSTRAINT [DF_phpbb_bots___bot_ip] DEFAULT ('') FOR [bot_ip]
329 CREATE INDEX [bot_active] ON [phpbb_bots]([bot_active]) ON [PRIMARY]
336 CREATE TABLE [phpbb_config] (
337 [config_name] [varchar] (255) NOT NULL ,
338 [config_value] [varchar] (255) NOT NULL ,
339 [is_dynamic] [int] NOT NULL
343 ALTER TABLE [phpbb_config] WITH NOCHECK ADD
344 CONSTRAINT [PK_phpbb_config] PRIMARY KEY CLUSTERED
350 ALTER TABLE [phpbb_config] WITH NOCHECK ADD
351 CONSTRAINT [DF_phpbb_config_is_dynamic] DEFAULT (0) FOR [is_dynamic]
354 CREATE INDEX [is_dynamic] ON [phpbb_config]([is_dynamic]) ON [PRIMARY]
361 CREATE TABLE [phpbb_confirm] (
362 [confirm_id] [char] (32) NOT NULL ,
363 [session_id] [char] (32) NOT NULL ,
364 [confirm_type] [int] NOT NULL ,
365 [code] [varchar] (8) NOT NULL
369 ALTER TABLE [phpbb_confirm] WITH NOCHECK ADD
370 CONSTRAINT [PK_phpbb_confirm] PRIMARY KEY CLUSTERED
377 ALTER TABLE [phpbb_confirm] WITH NOCHECK ADD
378 CONSTRAINT [DF_phpbb_confirm_confirm_type] DEFAULT (0) FOR [confirm_type],
379 CONSTRAINT [DF_phpbb_confirm_confirm_id] DEFAULT ('') FOR [confirm_id],
380 CONSTRAINT [DF_phpbb_confirm_session_id] DEFAULT ('') FOR [session_id],
381 CONSTRAINT [DF_phpbb_confirm_code] DEFAULT ('') FOR [code]
386 Table: phpbb_disallow
388 CREATE TABLE [phpbb_disallow] (
389 [disallow_id] [int] IDENTITY (1, 1) NOT NULL ,
390 [disallow_username] [varchar] (255) NOT NULL
394 ALTER TABLE [phpbb_disallow] WITH NOCHECK ADD
395 CONSTRAINT [PK_phpbb_disallow] PRIMARY KEY CLUSTERED
401 ALTER TABLE [phpbb_disallow] WITH NOCHECK ADD
402 CONSTRAINT [DF_phpbb_disallow_disallow_username] DEFAULT ('') FOR [disallow_username]
409 CREATE TABLE [phpbb_drafts] (
410 [draft_id] [int] IDENTITY (1, 1) NOT NULL ,
411 [user_id] [int] NOT NULL ,
412 [topic_id] [int] NOT NULL ,
413 [forum_id] [int] NOT NULL ,
414 [save_time] [int] NOT NULL ,
415 [draft_subject] [varchar] (1000) ,
416 [draft_message] [text]
417 ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
420 ALTER TABLE [phpbb_drafts] WITH NOCHECK ADD
421 CONSTRAINT [PK_phpbb_drafts] PRIMARY KEY CLUSTERED
427 ALTER TABLE [phpbb_drafts] WITH NOCHECK ADD
428 CONSTRAINT [DF_phpbb_drafts_user_id] DEFAULT (0) FOR [user_id],
429 CONSTRAINT [DF_phpbb_drafts_topic_id] DEFAULT (0) FOR [topic_id],
430 CONSTRAINT [DF_phpbb_drafts_forum_id] DEFAULT (0) FOR [forum_id],
431 CONSTRAINT [DF_phpbb_drafts_save_time] DEFAULT (0) FOR [save_time]
434 CREATE INDEX [save_time] ON [phpbb_drafts]([save_time]) ON [PRIMARY]
439 Table: phpbb_extensions
441 CREATE TABLE [phpbb_extensions] (
442 [extension_id] [int] IDENTITY (1, 1) NOT NULL ,
443 [group_id] [int] NOT NULL ,
444 [extension] [varchar] (100) NOT NULL
448 ALTER TABLE [phpbb_extensions] WITH NOCHECK ADD
449 CONSTRAINT [PK_phpbb_extensions] PRIMARY KEY CLUSTERED
455 ALTER TABLE [phpbb_extensions] WITH NOCHECK ADD
456 CONSTRAINT [DF_phpbb_extens_group_id] DEFAULT (0) FOR [group_id],
457 CONSTRAINT [DF_phpbb_extens_extension] DEFAULT (0) FOR [extension]
463 Table: phpbb_extension_groups
465 CREATE TABLE [phpbb_extension_groups] (
466 [group_id] [int] IDENTITY (1, 1) NOT NULL ,
467 [group_name] [varchar] (255) NOT NULL ,
468 [cat_id] [int] NOT NULL ,
469 [allow_group] [int] NOT NULL ,
470 [download_mode] [int] NOT NULL ,
471 [upload_icon] [varchar] (255) NOT NULL ,
472 [max_filesize] [int] NOT NULL ,
473 [allowed_forums] [text] ,
474 [allow_in_pm] [int] NOT NULL
475 ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
478 ALTER TABLE [phpbb_extension_groups] WITH NOCHECK ADD
479 CONSTRAINT [PK_phpbb_extension_groups] PRIMARY KEY CLUSTERED
485 ALTER TABLE [phpbb_extension_groups] WITH NOCHECK ADD
486 CONSTRAINT [DF_phpbb_extens_cat_id] DEFAULT (0) FOR [cat_id],
487 CONSTRAINT [DF_phpbb_extens_allow_group] DEFAULT (0) FOR [allow_group],
488 CONSTRAINT [DF_phpbb_extens_download_mode] DEFAULT (1) FOR [download_mode],
489 CONSTRAINT [DF_phpbb_extens_max_filesize] DEFAULT (0) FOR [max_filesize],
490 CONSTRAINT [DF_phpbb_extens_allow_in_pm] DEFAULT (0) FOR [allow_in_pm],
491 CONSTRAINT [DF_phpbb_extens_upload_icon] DEFAULT ('') FOR [upload_icon]
498 CREATE TABLE [phpbb_forums] (
499 [forum_id] [int] IDENTITY (1, 1) NOT NULL ,
500 [parent_id] [int] NOT NULL ,
501 [left_id] [int] NOT NULL ,
502 [right_id] [int] NOT NULL ,
503 [forum_parents] [text] NULL ,
504 [forum_name] [varchar] (3000) ,
505 [forum_desc] [text] ,
506 [forum_desc_bitfield] [int] NOT NULL ,
507 [forum_desc_uid] [varchar] (5) NOT NULL ,
508 [forum_link] [varchar] (255) NOT NULL ,
509 [forum_password] [varchar] (40) NOT NULL ,
510 [forum_style] [int] NULL ,
511 [forum_image] [varchar] (255) NOT NULL ,
512 [forum_rules] [text] ,
513 [forum_rules_link] [varchar] (255) NOT NULL ,
514 [forum_rules_bitfield] [int] NOT NULL ,
515 [forum_rules_uid] [varchar] (5) NOT NULL ,
516 [forum_topics_per_page] [int] NOT NULL ,
517 [forum_type] [int] NOT NULL ,
518 [forum_status] [int] NOT NULL ,
519 [forum_posts] [int] NOT NULL ,
520 [forum_topics] [int] NOT NULL ,
521 [forum_topics_real] [int] NOT NULL ,
522 [forum_last_post_id] [int] NOT NULL ,
523 [forum_last_poster_id] [int] NOT NULL ,
524 [forum_last_post_time] [int] NOT NULL ,
525 [forum_last_poster_name] [varchar] (255) NULL ,
526 [forum_flags] [int] NOT NULL ,
527 [display_on_index] [int] NOT NULL ,
528 [enable_indexing] [int] NOT NULL ,
529 [enable_icons] [int] NOT NULL ,
530 [enable_prune] [int] NOT NULL ,
531 [prune_next] [int] NULL ,
532 [prune_days] [int] NOT NULL ,
533 [prune_viewed] [int] NOT NULL ,
534 [prune_freq] [int] NOT NULL
535 ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
538 ALTER TABLE [phpbb_forums] WITH NOCHECK ADD
539 CONSTRAINT [PK_phpbb_forums] PRIMARY KEY CLUSTERED
545 ALTER TABLE [phpbb_forums] WITH NOCHECK ADD
546 CONSTRAINT [DF_phpbb_forums_parent_id] DEFAULT (0) FOR [parent_id],
547 CONSTRAINT [DF_phpbb_forums_left_id] DEFAULT (0) FOR [left_id],
548 CONSTRAINT [DF_phpbb_forums_right_id] DEFAULT (0) FOR [right_id],
549 CONSTRAINT [DF_phpbb_forums_desc_bitfield] DEFAULT (0) FOR [forum_desc_bitfield],
550 CONSTRAINT [DF_phpbb_forums_rules_bitfield] DEFAULT (0) FOR [forum_rules_bitfield],
551 CONSTRAINT [DF_phpbb_forums_topics_per_page] DEFAULT (0) FOR [forum_topics_per_page],
552 CONSTRAINT [DF_phpbb_forums_forum_type] DEFAULT (0) FOR [forum_type],
553 CONSTRAINT [DF_phpbb_forums_forum_status] DEFAULT (0) FOR [forum_status],
554 CONSTRAINT [DF_phpbb_forums_forum_posts] DEFAULT (0) FOR [forum_posts],
555 CONSTRAINT [DF_phpbb_forums_forum_topics] DEFAULT (0) FOR [forum_topics],
556 CONSTRAINT [DF_phpbb_forums_forum_topics_real] DEFAULT (0) FOR [forum_topics_real],
557 CONSTRAINT [DF_phpbb_forums_forum_last_post_id] DEFAULT (0) FOR [forum_last_post_id],
558 CONSTRAINT [DF_phpbb_forums_forum_last_poster_id] DEFAULT (0) FOR [forum_last_poster_id],
559 CONSTRAINT [DF_phpbb_forums_forum_last_post_time] DEFAULT (0) FOR [forum_last_post_time],
560 CONSTRAINT [DF_phpbb_forums_forum_flags] DEFAULT (32) FOR [forum_flags],
561 CONSTRAINT [DF_phpbb_forums_display_on_index] DEFAULT (1) FOR [display_on_index],
562 CONSTRAINT [DF_phpbb_forums_enable_indexing] DEFAULT (1) FOR [enable_indexing],
563 CONSTRAINT [DF_phpbb_forums_enable_icons] DEFAULT (1) FOR [enable_icons],
564 CONSTRAINT [DF_phpbb_forums_enable_prune] DEFAULT (0) FOR [enable_prune],
565 CONSTRAINT [DF_phpbb_forums_prune_days] DEFAULT (0) FOR [prune_days],
566 CONSTRAINT [DF_phpbb_forums_prune_viewed] DEFAULT (0) FOR [prune_viewed],
567 CONSTRAINT [DF_phpbb_forums_prune_freq] DEFAULT (0) FOR [prune_freq],
568 CONSTRAINT [DF_phpbb_forums_forum_desc_uid] DEFAULT ('') FOR [forum_desc_uid],
569 CONSTRAINT [DF_phpbb_forums_forum_link] DEFAULT ('') FOR [forum_link],
570 CONSTRAINT [DF_phpbb_forums_forum_password] DEFAULT ('') FOR [forum_password],
571 CONSTRAINT [DF_phpbb_forums_forum_image] DEFAULT ('') FOR [forum_image],
572 CONSTRAINT [DF_phpbb_forums_forum_rules_link] DEFAULT ('') FOR [forum_rules_link],
573 CONSTRAINT [DF_phpbb_forums_forum_rules_uid] DEFAULT ('') FOR [forum_rules_uid]
576 CREATE INDEX [left_right_id] ON [phpbb_forums]([left_id], [right_id]) ON [PRIMARY]
579 CREATE INDEX [forum_last_post_id] ON [phpbb_forums]([forum_last_post_id]) ON [PRIMARY]
584 Table: phpbb_forums_access
586 CREATE TABLE [phpbb_forums_access] (
587 [forum_id] [int] NOT NULL ,
588 [user_id] [int] NOT NULL ,
589 [session_id] [varchar] (32) NOT NULL
593 ALTER TABLE [phpbb_forums_access] WITH NOCHECK ADD
594 CONSTRAINT [PK_phpbb_forums_access] PRIMARY KEY CLUSTERED
602 ALTER TABLE [phpbb_forums_access] WITH NOCHECK ADD
603 CONSTRAINT [DF_phpbb_forum__forum_id] DEFAULT (0) FOR [forum_id],
604 CONSTRAINT [DF_phpbb_forum__user_id] DEFAULT (0) FOR [user_id],
605 CONSTRAINT [DF_phpbb_forum__session_id] DEFAULT ('') FOR [session_id]
610 Table: phpbb_forums_track
612 CREATE TABLE [phpbb_forums_track] (
613 [user_id] [int] NOT NULL ,
614 [forum_id] [int] NOT NULL ,
615 [mark_time] [int] NOT NULL
619 ALTER TABLE [phpbb_forums_track] WITH NOCHECK ADD
620 CONSTRAINT [PK_phpbb_forums_track] PRIMARY KEY CLUSTERED
627 ALTER TABLE [phpbb_forums_track] WITH NOCHECK ADD
628 CONSTRAINT [DF_phpbb_forumm_user_id] DEFAULT (0) FOR [user_id],
629 CONSTRAINT [DF_phpbb_forumm_forum_id] DEFAULT (0) FOR [forum_id],
630 CONSTRAINT [DF_phpbb_forumm_mark_time] DEFAULT (0) FOR [mark_time]
635 Table: phpbb_forums_watch
637 CREATE TABLE [phpbb_forums_watch] (
638 [forum_id] [int] NOT NULL ,
639 [user_id] [int] NOT NULL ,
640 [notify_status] [int] NOT NULL
644 ALTER TABLE [phpbb_forums_watch] WITH NOCHECK ADD
645 CONSTRAINT [DF_phpbb_forumw_forum_id] DEFAULT (0) FOR [forum_id],
646 CONSTRAINT [DF_phpbb_forumw_user_id] DEFAULT (0) FOR [user_id],
647 CONSTRAINT [DF_phpbb_forumw_notify_status] DEFAULT (0) FOR [notify_status]
650 CREATE INDEX [forum_id] ON [phpbb_forums_watch]([forum_id]) ON [PRIMARY]
653 CREATE INDEX [user_id] ON [phpbb_forums_watch]([user_id]) ON [PRIMARY]
656 CREATE INDEX [notify_status] ON [phpbb_forums_watch]([notify_status]) ON [PRIMARY]
663 CREATE TABLE [phpbb_groups] (
664 [group_id] [int] IDENTITY (1, 1) NOT NULL ,
665 [group_type] [int] NOT NULL ,
666 [group_name] [varchar] (255) NOT NULL ,
667 [group_desc] [text] ,
668 [group_desc_bitfield] [int] NOT NULL ,
669 [group_desc_uid] [varchar] (5) NOT NULL ,
670 [group_display] [int] NOT NULL ,
671 [group_avatar] [varchar] (255) NOT NULL ,
672 [group_avatar_type] [int] NOT NULL ,
673 [group_avatar_width] [int] NOT NULL ,
674 [group_avatar_height] [int] NOT NULL ,
675 [group_rank] [int] NOT NULL ,
676 [group_colour] [varchar] (6) NOT NULL ,
677 [group_sig_chars] [int] NOT NULL ,
678 [group_receive_pm] [int] NOT NULL ,
679 [group_message_limit] [int] NOT NULL ,
680 [group_chgpass] [int] NOT NULL ,
681 [group_legend] [int] NOT NULL
682 ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
685 ALTER TABLE [phpbb_groups] WITH NOCHECK ADD
686 CONSTRAINT [PK_phpbb_groups] PRIMARY KEY CLUSTERED
692 ALTER TABLE [phpbb_groups] WITH NOCHECK ADD
693 CONSTRAINT [DF_phpbb_groups_group_type] DEFAULT (1) FOR [group_type],
694 CONSTRAINT [DF_phpbb_groups_group_display] DEFAULT (0) FOR [group_display],
695 CONSTRAINT [DF_phpbb_groups_group_desc_bitfield] DEFAULT (0) FOR [group_desc_bitfield],
696 CONSTRAINT [DF_phpbb_groups_group_avatar_type] DEFAULT (0) FOR [group_avatar_type],
697 CONSTRAINT [DF_phpbb_groups_group_avatar_width] DEFAULT (0) FOR [group_avatar_width],
698 CONSTRAINT [DF_phpbb_groups_group_avatar_height] DEFAULT (0) FOR [group_avatar_height],
699 CONSTRAINT [DF_phpbb_groups_group_rank] DEFAULT ((-1)) FOR [group_rank],
700 CONSTRAINT [DF_phpbb_groups_group_sig_chars] DEFAULT (0) FOR [group_sig_chars],
701 CONSTRAINT [DF_phpbb_groups_group_receive_pm] DEFAULT (0) FOR [group_receive_pm],
702 CONSTRAINT [DF_phpbb_groups_group_message_limit] DEFAULT (0) FOR [group_message_limit],
703 CONSTRAINT [DF_phpbb_groups_group_chgpass] DEFAULT (0) FOR [group_chgpass],
704 CONSTRAINT [DF_phpbb_groups_group_legend] DEFAULT (1) FOR [group_legend],
705 CONSTRAINT [DF_phpbb_groups_group_name] DEFAULT ('') FOR [group_name],
706 CONSTRAINT [DF_phpbb_groups_group_desc_uid] DEFAULT ('') FOR [group_desc_uid],
707 CONSTRAINT [DF_phpbb_groups_group_avatar] DEFAULT ('') FOR [group_avatar],
708 CONSTRAINT [DF_phpbb_groups_group_colour] DEFAULT ('') FOR [group_colour]
711 CREATE INDEX [group_legend] ON [phpbb_groups]([group_legend]) ON [PRIMARY]
718 CREATE TABLE [phpbb_icons] (
719 [icons_id] [int] IDENTITY (1, 1) NOT NULL ,
720 [icons_url] [varchar] (255) NULL ,
721 [icons_width] [int] NOT NULL ,
722 [icons_height] [int] NOT NULL ,
723 [icons_order] [int] NOT NULL ,
724 [display_on_posting] [int] NOT NULL
728 ALTER TABLE [phpbb_icons] WITH NOCHECK ADD
729 CONSTRAINT [PK_phpbb_icons] PRIMARY KEY CLUSTERED
735 ALTER TABLE [phpbb_icons] WITH NOCHECK ADD
736 CONSTRAINT [DF_phpbb_icons__display_on_posting] DEFAULT (1) FOR [display_on_posting],
737 CONSTRAINT [DF_phpbb_icons__icons_width] DEFAULT (0) FOR [icons_width],
738 CONSTRAINT [DF_phpbb_icons__icons_height] DEFAULT (0) FOR [icons_height],
739 CONSTRAINT [DF_phpbb_icons__icons_order] DEFAULT (0) FOR [icons_order]
746 CREATE TABLE [phpbb_lang] (
747 [lang_id] [int] IDENTITY (1, 1) NOT NULL ,
748 [lang_iso] [varchar] (5) NOT NULL ,
749 [lang_dir] [varchar] (30) NOT NULL ,
750 [lang_english_name] [varchar] (100) NULL ,
751 [lang_local_name] [varchar] (255) NULL ,
752 [lang_author] [varchar] (255) NULL
756 ALTER TABLE [phpbb_lang] WITH NOCHECK ADD
757 CONSTRAINT [PK_phpbb_lang] PRIMARY KEY CLUSTERED
767 CREATE TABLE [phpbb_log] (
768 [log_id] [int] IDENTITY (1, 1) NOT NULL ,
769 [log_type] [int] NOT NULL ,
770 [user_id] [int] NOT NULL ,
771 [forum_id] [int] NOT NULL ,
772 [topic_id] [int] NOT NULL ,
773 [reportee_id] [int] NOT NULL ,
774 [log_ip] [varchar] (40) NOT NULL ,
775 [log_time] [int] NOT NULL ,
776 [log_operation] [varchar] (8000) ,
778 ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
781 ALTER TABLE [phpbb_log] WITH NOCHECK ADD
782 CONSTRAINT [PK_phpbb_log] PRIMARY KEY CLUSTERED
788 ALTER TABLE [phpbb_log] WITH NOCHECK ADD
789 CONSTRAINT [DF_phpbb_log____log_type] DEFAULT (0) FOR [log_type],
790 CONSTRAINT [DF_phpbb_log____user_id] DEFAULT (0) FOR [user_id],
791 CONSTRAINT [DF_phpbb_log____forum_id] DEFAULT (0) FOR [forum_id],
792 CONSTRAINT [DF_phpbb_log____topic_id] DEFAULT (0) FOR [topic_id],
793 CONSTRAINT [DF_phpbb_log____reportee_id] DEFAULT (0) FOR [reportee_id],
794 CONSTRAINT [DF_phpbb_log____log_time] DEFAULT (0) FOR [log_time]
797 CREATE INDEX [log_type] ON [phpbb_log]([log_type]) ON [PRIMARY]
800 CREATE INDEX [forum_id] ON [phpbb_log]([forum_id]) ON [PRIMARY]
803 CREATE INDEX [topic_id] ON [phpbb_log]([topic_id]) ON [PRIMARY]
806 CREATE INDEX [reportee_id] ON [phpbb_log]([reportee_id]) ON [PRIMARY]
809 CREATE INDEX [user_id] ON [phpbb_log]([user_id]) ON [PRIMARY]
814 Table: phpbb_moderator_cache
816 CREATE TABLE [phpbb_moderator_cache] (
817 [forum_id] [int] NOT NULL ,
818 [user_id] [int] NOT NULL ,
819 [username] [varchar] (255) NOT NULL ,
820 [group_id] [int] NOT NULL ,
821 [group_name] [varchar] (255) NOT NULL ,
822 [display_on_index] [int] NOT NULL
826 ALTER TABLE [phpbb_moderator_cache] WITH NOCHECK ADD
827 CONSTRAINT [DF_phpbb_modera_forum_id] DEFAULT (0) FOR [forum_id],
828 CONSTRAINT [DF_phpbb_modera_user_id] DEFAULT (0) FOR [user_id],
829 CONSTRAINT [DF_phpbb_modera_group_id] DEFAULT (0) FOR [group_id],
830 CONSTRAINT [DF_phpbb_modera_display_on_index] DEFAULT (1) FOR [display_on_index],
831 CONSTRAINT [DF_phpbb_modera_username] DEFAULT ('') FOR [username],
832 CONSTRAINT [DF_phpbb_modera_group_name] DEFAULT ('') FOR [group_name]
835 CREATE INDEX [display_on_index] ON [phpbb_moderator_cache]([display_on_index]) ON [PRIMARY]
838 CREATE INDEX [forum_id] ON [phpbb_moderator_cache]([forum_id]) ON [PRIMARY]
845 CREATE TABLE [phpbb_modules] (
846 [module_id] [int] IDENTITY (1, 1) NOT NULL ,
847 [module_enabled] [int] NOT NULL ,
848 [module_display] [int] NOT NULL ,
849 [module_name] [varchar] (255) NOT NULL ,
850 [module_class] [varchar] (10) NOT NULL ,
851 [parent_id] [int] NOT NULL ,
852 [left_id] [int] NOT NULL ,
853 [right_id] [int] NOT NULL ,
854 [module_langname] [varchar] (255) NOT NULL ,
855 [module_mode] [varchar] (255) NOT NULL ,
856 [module_auth] [varchar] (255) NOT NULL
860 ALTER TABLE [phpbb_modules] WITH NOCHECK ADD
861 CONSTRAINT [PK_phpbb_modules] PRIMARY KEY CLUSTERED
867 ALTER TABLE [phpbb_modules] WITH NOCHECK ADD
868 CONSTRAINT [DF_phpbb_module_forums_parent_id] DEFAULT (0) FOR [parent_id],
869 CONSTRAINT [DF_phpbb_module_left_id] DEFAULT (0) FOR [left_id],
870 CONSTRAINT [DF_phpbb_module_right_id] DEFAULT (0) FOR [right_id],
871 CONSTRAINT [DF_phpbb_module_module_enabled] DEFAULT (1) FOR [module_enabled],
872 CONSTRAINT [DF_phpbb_module_module_display] DEFAULT (1) FOR [module_display],
873 CONSTRAINT [DF_phpbb_module_module_name] DEFAULT ('') FOR [module_name],
874 CONSTRAINT [DF_phpbb_module_module_class] DEFAULT ('') FOR [module_class],
875 CONSTRAINT [DF_phpbb_module_module_langname] DEFAULT ('') FOR [module_langname],
876 CONSTRAINT [DF_phpbb_module_module_mode] DEFAULT ('') FOR [module_mode],
877 CONSTRAINT [DF_phpbb_module_module_auth] DEFAULT ('') FOR [module_auth]
880 CREATE INDEX [module_enabled] ON [phpbb_modules]([module_enabled]) ON [PRIMARY]
883 CREATE INDEX [module_left_right_id] ON [phpbb_modules]([left_id], [right_id]) ON [PRIMARY]
886 CREATE INDEX [module_class_left_id] ON [phpbb_modules]([module_class], [left_id]) ON [PRIMARY]
891 Table: phpbb_poll_options
893 CREATE TABLE [phpbb_poll_options] (
894 [poll_option_id] [int] NOT NULL ,
895 [topic_id] [int] NOT NULL ,
896 [poll_option_text] [varchar] (3000) ,
897 [poll_option_total] [int] NOT NULL
901 ALTER TABLE [phpbb_poll_options] WITH NOCHECK ADD
902 CONSTRAINT [DF_phpbb_poll_o_poll_option_id] DEFAULT (0) FOR [poll_option_id],
903 CONSTRAINT [DF_phpbb_poll_o_poll_option_total] DEFAULT (0) FOR [poll_option_total],
904 CONSTRAINT [DF_phpbb_poll_o_topic_id] DEFAULT (0) FOR [topic_id]
907 CREATE INDEX [poll_option_id] ON [phpbb_poll_options]([poll_option_id]) ON [PRIMARY]
910 CREATE INDEX [topic_id] ON [phpbb_poll_options]([topic_id]) ON [PRIMARY]
915 Table: phpbb_poll_votes
917 CREATE TABLE [phpbb_poll_votes] (
918 [topic_id] [int] NOT NULL ,
919 [poll_option_id] [int] NOT NULL ,
920 [vote_user_id] [int] NOT NULL ,
921 [vote_user_ip] [varchar] (40) NOT NULL
925 ALTER TABLE [phpbb_poll_votes] WITH NOCHECK ADD
926 CONSTRAINT [DF_phpbb_poll_v_topic_id] DEFAULT (0) FOR [topic_id],
927 CONSTRAINT [DF_phpbb_poll_v_poll_option_id] DEFAULT (0) FOR [poll_option_id],
928 CONSTRAINT [DF_phpbb_poll_v_vote_user_id] DEFAULT (0) FOR [vote_user_id]
931 CREATE INDEX [topic_id] ON [phpbb_poll_votes]([topic_id]) ON [PRIMARY]
934 CREATE INDEX [vote_user_id] ON [phpbb_poll_votes]([vote_user_id]) ON [PRIMARY]
937 CREATE INDEX [vote_user_ip] ON [phpbb_poll_votes]([vote_user_ip]) ON [PRIMARY]
944 CREATE TABLE [phpbb_posts] (
945 [post_id] [int] IDENTITY (1, 1) NOT NULL ,
946 [topic_id] [int] NOT NULL ,
947 [forum_id] [int] NOT NULL ,
948 [poster_id] [int] NOT NULL ,
949 [icon_id] [int] NOT NULL ,
950 [poster_ip] [varchar] (40) NOT NULL ,
951 [post_time] [int] NOT NULL ,
952 [post_approved] [int] NOT NULL ,
953 [post_reported] [int] NOT NULL ,
954 [enable_bbcode] [int] NOT NULL ,
955 [enable_smilies] [int] NOT NULL ,
956 [enable_magic_url] [int] NOT NULL ,
957 [enable_sig] [int] NOT NULL ,
958 [post_username] [varchar] (255) NULL ,
959 [post_subject] [varchar] (1000) NOT NULL ,
960 [post_text] [text] NOT NULL ,
961 [post_checksum] [varchar] (32) NOT NULL ,
962 [post_encoding] [varchar] (20) NOT NULL ,
963 [post_attachment] [int] NOT NULL ,
964 [bbcode_bitfield] [int] NOT NULL ,
965 [bbcode_uid] [varchar] (5) NOT NULL ,
966 [post_edit_time] [int] NULL ,
967 [post_edit_reason] [varchar] (3000) NULL,
968 [post_edit_user] [int] NULL ,
969 [post_edit_count] [int] NULL ,
970 [post_edit_locked] [int] NULL
971 ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
974 ALTER TABLE [phpbb_posts] WITH NOCHECK ADD
975 CONSTRAINT [PK_phpbb_posts] PRIMARY KEY CLUSTERED
981 ALTER TABLE [phpbb_posts] WITH NOCHECK ADD
982 CONSTRAINT [DF_phpbb_posts__topic_id] DEFAULT (0) FOR [topic_id],
983 CONSTRAINT [DF_phpbb_posts__forum_id] DEFAULT (0) FOR [forum_id],
984 CONSTRAINT [DF_phpbb_posts__poster_id] DEFAULT (0) FOR [poster_id],
985 CONSTRAINT [DF_phpbb_posts__icon_id] DEFAULT (0) FOR [icon_id],
986 CONSTRAINT [DF_phpbb_posts__post_time] DEFAULT (0) FOR [post_time],
987 CONSTRAINT [DF_phpbb_posts__post_approved] DEFAULT (1) FOR [post_approved],
988 CONSTRAINT [DF_phpbb_posts__post_reported] DEFAULT (0) FOR [post_reported],
989 CONSTRAINT [DF_phpbb_posts__enable_bbcode] DEFAULT (1) FOR [enable_bbcode],
990 CONSTRAINT [DF_phpbb_posts__enable_smilies] DEFAULT (1) FOR [enable_smilies],
991 CONSTRAINT [DF_phpbb_posts__enable_magic_url] DEFAULT (1) FOR [enable_magic_url],
992 CONSTRAINT [DF_phpbb_posts__enable_sig] DEFAULT (1) FOR [enable_sig],
993 CONSTRAINT [DF_phpbb_posts__post_encoding] DEFAULT ('iso-8859-1') FOR [post_encoding],
994 CONSTRAINT [DF_phpbb_posts__post_attachment] DEFAULT (0) FOR [post_attachment],
995 CONSTRAINT [DF_phpbb_posts__bbcode_bitfield] DEFAULT (0) FOR [bbcode_bitfield],
996 CONSTRAINT [DF_phpbb_posts__post_edit_time] DEFAULT (0) FOR [post_edit_time],
997 CONSTRAINT [DF_phpbb_posts__post_edit_user] DEFAULT (0) FOR [post_edit_user],
998 CONSTRAINT [DF_phpbb_posts__post_edit_count] DEFAULT (0) FOR [post_edit_count],
999 CONSTRAINT [DF_phpbb_posts__post_edit_locked] DEFAULT (0) FOR [post_edit_locked],
1000 CONSTRAINT [DF_phpbb_posts__bbcode_uid] DEFAULT ('') FOR [bbcode_uid]
1003 CREATE INDEX [forum_id] ON [phpbb_posts]([forum_id]) ON [PRIMARY]
1006 CREATE INDEX [topic_id] ON [phpbb_posts]([topic_id]) ON [PRIMARY]
1009 CREATE INDEX [poster_ip] ON [phpbb_posts]([poster_ip]) ON [PRIMARY]
1012 CREATE INDEX [poster_id] ON [phpbb_posts]([poster_id]) ON [PRIMARY]
1015 CREATE INDEX [post_approved] ON [phpbb_posts]([post_approved]) ON [PRIMARY]
1018 CREATE INDEX [post_time] ON [phpbb_posts]([post_time]) ON [PRIMARY]
1023 Table: phpbb_privmsgs
1025 CREATE TABLE [phpbb_privmsgs] (
1026 [msg_id] [int] IDENTITY (1, 1) NOT NULL ,
1027 [root_level] [int] NOT NULL ,
1028 [author_id] [int] NOT NULL ,
1029 [icon_id] [int] NOT NULL ,
1030 [author_ip] [varchar] (40) NOT NULL ,
1031 [message_time] [int] NOT NULL ,
1032 [enable_bbcode] [int] NOT NULL ,
1033 [enable_smilies] [int] NOT NULL ,
1034 [enable_magic_url] [int] NOT NULL ,
1035 [enable_sig] [int] NOT NULL ,
1036 [message_subject] [varchar] (1000) NOT NULL ,
1037 [message_text] [text] NOT NULL ,
1038 [message_edit_reason] [varchar] (3000) NULL ,
1039 [message_edit_user] [int] NULL ,
1040 [message_encoding] [varchar] (20) NOT NULL ,
1041 [message_attachment] [int] NOT NULL ,
1042 [bbcode_bitfield] [int] NOT NULL ,
1043 [bbcode_uid] [varchar] (5) NOT NULL ,
1044 [message_edit_time] [int] NULL ,
1045 [message_edit_count] [int] NULL ,
1046 [to_address] [text] NOT NULL ,
1047 [bcc_address] [text] NOT NULL
1048 ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
1051 ALTER TABLE [phpbb_privmsgs] WITH NOCHECK ADD
1052 CONSTRAINT [PK_phpbb_privmsgs] PRIMARY KEY CLUSTERED
1058 ALTER TABLE [phpbb_privmsgs] WITH NOCHECK ADD
1059 CONSTRAINT [DF_phpbb_privms_root_level] DEFAULT (0) FOR [root_level],
1060 CONSTRAINT [DF_phpbb_privms_author_id] DEFAULT (0) FOR [author_id],
1061 CONSTRAINT [DF_phpbb_privms_icon_id] DEFAULT (0) FOR [icon_id],
1062 CONSTRAINT [DF_phpbb_privms_message_time] DEFAULT (0) FOR [message_time],
1063 CONSTRAINT [DF_phpbb_privms_enable_bbcode] DEFAULT (1) FOR [enable_bbcode],
1064 CONSTRAINT [DF_phpbb_privms_enable_smilies] DEFAULT (1) FOR [enable_smilies],
1065 CONSTRAINT [DF_phpbb_privms_enable_magic_url] DEFAULT (1) FOR [enable_magic_url],
1066 CONSTRAINT [DF_phpbb_privms_enable_sig] DEFAULT (1) FOR [enable_sig],
1067 CONSTRAINT [DF_phpbb_privms_message_edit_user] DEFAULT (0) FOR [message_edit_user],
1068 CONSTRAINT [DF_phpbb_privms_message_encoding] DEFAULT ('iso-8859-1') FOR [message_encoding],
1069 CONSTRAINT [DF_phpbb_privms_message_attachment] DEFAULT (0) FOR [message_attachment],
1070 CONSTRAINT [DF_phpbb_privms_bbcode_bitfield] DEFAULT (0) FOR [bbcode_bitfield],
1071 CONSTRAINT [DF_phpbb_privms_message_edit_time] DEFAULT (0) FOR [message_edit_time],
1072 CONSTRAINT [DF_phpbb_privms_message_edit_count] DEFAULT (0) FOR [message_edit_count],
1073 CONSTRAINT [DF_phpbb_privms_author_ip] DEFAULT ('') FOR [author_ip],
1074 CONSTRAINT [DF_phpbb_privms_bbcode_uid] DEFAULT ('') FOR [bbcode_uid]
1077 CREATE INDEX [author_ip] ON [phpbb_privmsgs]([author_ip]) ON [PRIMARY]
1080 CREATE INDEX [message_time] ON [phpbb_privmsgs]([message_time]) ON [PRIMARY]
1083 CREATE INDEX [author_id] ON [phpbb_privmsgs]([author_id]) ON [PRIMARY]
1086 CREATE INDEX [root_level] ON [phpbb_privmsgs]([root_level]) ON [PRIMARY]
1091 Table: phpbb_privmsgs_folder
1093 CREATE TABLE [phpbb_privmsgs_folder] (
1094 [folder_id] [int] IDENTITY (1, 1) NOT NULL ,
1095 [user_id] [int] NOT NULL ,
1096 [folder_name] [varchar] (255) NOT NULL ,
1097 [pm_count] [int] NOT NULL
1101 ALTER TABLE [phpbb_privmsgs_folder] WITH NOCHECK ADD
1102 CONSTRAINT [PK_phpbb_privmsgs_folder] PRIMARY KEY CLUSTERED
1108 ALTER TABLE [phpbb_privmsgs_folder] WITH NOCHECK ADD
1109 CONSTRAINT [DF_phpbb_pmfold_user_id] DEFAULT (0) FOR [user_id],
1110 CONSTRAINT [DF_phpbb_pmfold_pm_count] DEFAULT (0) FOR [pm_count],
1111 CONSTRAINT [DF_phpbb_pmfold_folder_name] DEFAULT ('') FOR [folder_name]
1114 CREATE INDEX [user_id] ON [phpbb_privmsgs_folder]([user_id]) ON [PRIMARY]
1119 Table: phpbb_privmsgs_rules
1121 CREATE TABLE [phpbb_privmsgs_rules] (
1122 [rule_id] [int] IDENTITY (1, 1) NOT NULL ,
1123 [user_id] [int] NOT NULL ,
1124 [rule_check] [int] NOT NULL ,
1125 [rule_connection] [int] NOT NULL ,
1126 [rule_string] [varchar] (255) NOT NULL ,
1127 [rule_user_id] [int] NOT NULL ,
1128 [rule_group_id] [int] NOT NULL ,
1129 [rule_action] [int] NOT NULL ,
1130 [rule_folder_id] [int] NOT NULL
1134 ALTER TABLE [phpbb_privmsgs_rules] WITH NOCHECK ADD
1135 CONSTRAINT [PK_phpbb_privmsgs_rules] PRIMARY KEY CLUSTERED
1141 ALTER TABLE [phpbb_privmsgs_rules] WITH NOCHECK ADD
1142 CONSTRAINT [DF_phpbb_pmrule_user_id] DEFAULT (0) FOR [user_id],
1143 CONSTRAINT [DF_phpbb_pmrule_rule_check] DEFAULT (0) FOR [rule_check],
1144 CONSTRAINT [DF_phpbb_pmrule_rule_connection] DEFAULT (0) FOR [rule_connection],
1145 CONSTRAINT [DF_phpbb_pmrule_rule_user_id] DEFAULT (0) FOR [rule_user_id],
1146 CONSTRAINT [DF_phpbb_pmrule_rule_group_id] DEFAULT (0) FOR [rule_group_id],
1147 CONSTRAINT [DF_phpbb_pmrule_rule_action] DEFAULT (0) FOR [rule_action],
1148 CONSTRAINT [DF_phpbb_pmrule_rule_folder_id] DEFAULT (0) FOR [rule_folder_id],
1149 CONSTRAINT [DF_phpbb_pmrule_rule_string] DEFAULT ('') FOR [rule_string]
1154 Table: phpbb_privmsgs_to
1156 CREATE TABLE [phpbb_privmsgs_to] (
1157 [msg_id] [int] NOT NULL ,
1158 [user_id] [int] NOT NULL ,
1159 [author_id] [int] NOT NULL ,
1160 [deleted] [int] NOT NULL ,
1161 [new] [int] NOT NULL ,
1162 [unread] [int] NOT NULL ,
1163 [replied] [int] NOT NULL ,
1164 [marked] [int] NOT NULL ,
1165 [forwarded] [int] NOT NULL ,
1166 [folder_id] [int] NOT NULL
1170 ALTER TABLE [phpbb_privmsgs_to] WITH NOCHECK ADD
1171 CONSTRAINT [DF_phpbb_pmto___msg_id] DEFAULT (0) FOR [msg_id],
1172 CONSTRAINT [DF_phpbb_pmto___user_id] DEFAULT (0) FOR [user_id],
1173 CONSTRAINT [DF_phpbb_pmto___author_id] DEFAULT (0) FOR [author_id],
1174 CONSTRAINT [DF_phpbb_pmto___deleted] DEFAULT (0) FOR [deleted],
1175 CONSTRAINT [DF_phpbb_pmto___new] DEFAULT (1) FOR [new],
1176 CONSTRAINT [DF_phpbb_pmto___unread] DEFAULT (1) FOR [unread],
1177 CONSTRAINT [DF_phpbb_pmto___replied] DEFAULT (0) FOR [replied],
1178 CONSTRAINT [DF_phpbb_pmto___marked] DEFAULT (0) FOR [marked],
1179 CONSTRAINT [DF_phpbb_pmto___forwarded] DEFAULT (0) FOR [forwarded],
1180 CONSTRAINT [DF_phpbb_pmto___folder_id] DEFAULT (0) FOR [folder_id]
1183 CREATE INDEX [msg_id] ON [phpbb_privmsgs_to]([msg_id]) ON [PRIMARY]
1186 CREATE INDEX [user_id] ON [phpbb_privmsgs_to]([user_id], [folder_id]) ON [PRIMARY]
1191 Table: phpbb_profile_fields
1193 CREATE TABLE [phpbb_profile_fields] (
1194 [field_id] [int] IDENTITY (1, 1) NOT NULL ,
1195 [field_name] [varchar] (255) NOT NULL ,
1196 [field_type] [int] NOT NULL ,
1197 [field_ident] [varchar] (20) NOT NULL ,
1198 [field_length] [varchar] (20) NOT NULL ,
1199 [field_minlen] [varchar] (255) NOT NULL ,
1200 [field_maxlen] [varchar] (255) NOT NULL ,
1201 [field_novalue] [varchar] (255) NOT NULL ,
1202 [field_default_value] [varchar] (255) NOT NULL ,
1203 [field_validation] [varchar] (20) NOT NULL ,
1204 [field_required] [int] NOT NULL ,
1205 [field_show_on_reg] [int] NOT NULL ,
1206 [field_hide] [int] NOT NULL ,
1207 [field_no_view] [int] NOT NULL ,
1208 [field_active] [int] NOT NULL ,
1209 [field_order] [int] NOT NULL
1213 ALTER TABLE [phpbb_profile_fields] WITH NOCHECK ADD
1214 CONSTRAINT [PK_phpbb_profile_fields] PRIMARY KEY CLUSTERED
1220 ALTER TABLE [phpbb_profile_fields] WITH NOCHECK ADD
1221 CONSTRAINT [DF_phpbb_pffiel_field_type] DEFAULT (0) FOR [field_type],
1222 CONSTRAINT [DF_phpbb_pffiel_field_default_value] DEFAULT ('0') FOR [field_default_value],
1223 CONSTRAINT [DF_phpbb_pffiel_field_required] DEFAULT (0) FOR [field_required],
1224 CONSTRAINT [DF_phpbb_pffiel_field_show_on_reg] DEFAULT (0) FOR [field_show_on_reg],
1225 CONSTRAINT [DF_phpbb_pffiel_field_hide] DEFAULT (0) FOR [field_hide],
1226 CONSTRAINT [DF_phpbb_pffiel_field_no_view] DEFAULT (0) FOR [field_no_view],
1227 CONSTRAINT [DF_phpbb_pffiel_field_active] DEFAULT (0) FOR [field_active],
1228 CONSTRAINT [DF_phpbb_pffiel_field_order] DEFAULT (0) FOR [field_order],
1229 CONSTRAINT [DF_phpbb_pffiel_field_name] DEFAULT ('') FOR [field_name],
1230 CONSTRAINT [DF_phpbb_pffiel_field_ident] DEFAULT ('') FOR [field_ident],
1231 CONSTRAINT [DF_phpbb_pffiel_field_length] DEFAULT ('') FOR [field_length],
1232 CONSTRAINT [DF_phpbb_pffiel_field_minlen] DEFAULT ('') FOR [field_minlen],
1233 CONSTRAINT [DF_phpbb_pffiel_field_maxlen] DEFAULT ('') FOR [field_maxlen],
1234 CONSTRAINT [DF_phpbb_pffiel_field_novalue] DEFAULT ('') FOR [field_novalue],
1235 CONSTRAINT [DF_phpbb_pffiel_field_validation] DEFAULT ('') FOR [field_validation]
1238 CREATE INDEX [field_type] ON [phpbb_profile_fields]([field_type]) ON [PRIMARY]
1241 CREATE INDEX [field_order] ON [phpbb_profile_fields]([field_order]) ON [PRIMARY]
1246 Table: phpbb_profile_fields_data
1248 CREATE TABLE [phpbb_profile_fields_data] (
1249 [user_id] [int] NOT NULL
1253 ALTER TABLE [phpbb_profile_fields_data] WITH NOCHECK ADD
1254 CONSTRAINT [PK_phpbb_profile_fields_data] PRIMARY KEY CLUSTERED
1260 ALTER TABLE [phpbb_profile_fields_data] WITH NOCHECK ADD
1261 CONSTRAINT [DF_phpbb_pfdata_user_id] DEFAULT (0) FOR [user_id]
1266 Table: phpbb_profile_fields_lang
1268 CREATE TABLE [phpbb_profile_fields_lang] (
1269 [field_id] [int] NOT NULL ,
1270 [lang_id] [int] NOT NULL ,
1271 [option_id] [int] NOT NULL ,
1272 [field_type] [int] NOT NULL ,
1273 [value] [varchar] (255) NOT NULL
1277 ALTER TABLE [phpbb_profile_fields_lang] WITH NOCHECK ADD
1278 CONSTRAINT [PK_phpbb_profile_fields_lang] PRIMARY KEY CLUSTERED
1286 ALTER TABLE [phpbb_profile_fields_lang] WITH NOCHECK ADD
1287 CONSTRAINT [DF_phpbb_pfflan_field_id] DEFAULT (0) FOR [field_id],
1288 CONSTRAINT [DF_phpbb_pfflan_lang_id] DEFAULT (0) FOR [lang_id],
1289 CONSTRAINT [DF_phpbb_pfflan_option_id] DEFAULT (0) FOR [option_id],
1290 CONSTRAINT [DF_phpbb_pfflan_field_type] DEFAULT (0) FOR [field_type],
1291 CONSTRAINT [DF_phpbb_pfflan_value] DEFAULT ('') FOR [value]
1296 Table: phpbb_profile_lang
1298 CREATE TABLE [phpbb_profile_lang] (
1299 [field_id] [int] NOT NULL ,
1300 [lang_id] [int] NOT NULL ,
1301 [lang_name] [varchar] (255) NOT NULL ,
1302 [lang_explain] [text] ,
1303 [lang_default_value] [varchar] (255) NOT NULL
1304 ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
1307 ALTER TABLE [phpbb_profile_lang] WITH NOCHECK ADD
1308 CONSTRAINT [PK_phpbb_profile_lang] PRIMARY KEY CLUSTERED
1315 ALTER TABLE [phpbb_profile_lang] WITH NOCHECK ADD
1316 CONSTRAINT [DF_phpbb_pflang_field_id] DEFAULT (0) FOR [field_id],
1317 CONSTRAINT [DF_phpbb_pflang_lang_id] DEFAULT (0) FOR [lang_id],
1318 CONSTRAINT [DF_phpbb_pflang_lang_name] DEFAULT ('') FOR [lang_name],
1319 CONSTRAINT [DF_phpbb_pflang_lang_default_value] DEFAULT ('') FOR [lang_default_value]
1326 CREATE TABLE [phpbb_ranks] (
1327 [rank_id] [int] IDENTITY (1, 1) NOT NULL ,
1328 [rank_title] [varchar] (255) NOT NULL ,
1329 [rank_min] [int] NOT NULL ,
1330 [rank_special] [int] NULL ,
1331 [rank_image] [varchar] (255) NULL
1335 ALTER TABLE [phpbb_ranks] WITH NOCHECK ADD
1336 CONSTRAINT [PK_phpbb_ranks] PRIMARY KEY CLUSTERED
1342 ALTER TABLE [phpbb_ranks] WITH NOCHECK ADD
1343 CONSTRAINT [DF_phpbb_ranks__rank_min] DEFAULT (0) FOR [rank_min],
1344 CONSTRAINT [DF_phpbb_ranks__rank_special] DEFAULT (0) FOR [rank_special]
1349 Table: phpbb_reports
1351 CREATE TABLE [phpbb_reports] (
1352 [report_id] [int] IDENTITY (1, 1) NOT NULL ,
1353 [reason_id] [int] NOT NULL ,
1354 [post_id] [int] NOT NULL ,
1355 [user_id] [int] NOT NULL ,
1356 [user_notify] [int] NOT NULL ,
1357 [report_closed] [int] NOT NULL ,
1358 [report_time] [int] NOT NULL ,
1359 [report_text] [text]
1360 ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
1363 ALTER TABLE [phpbb_reports] WITH NOCHECK ADD
1364 CONSTRAINT [PK_phpbb_reports] PRIMARY KEY CLUSTERED
1370 ALTER TABLE [phpbb_reports] WITH NOCHECK ADD
1371 CONSTRAINT [DF_phpbb_report_reason_id] DEFAULT (0) FOR [reason_id],
1372 CONSTRAINT [DF_phpbb_report_post_id] DEFAULT (0) FOR [post_id],
1373 CONSTRAINT [DF_phpbb_report_user_id] DEFAULT (0) FOR [user_id],
1374 CONSTRAINT [DF_phpbb_report_user_notify] DEFAULT (0) FOR [user_notify],
1375 CONSTRAINT [DF_phpbb_report_report_closed] DEFAULT (0) FOR [report_closed],
1376 CONSTRAINT [DF_phpbb_report_report_time] DEFAULT (0) FOR [report_time]
1381 Table: phpbb_reports_reasons
1383 CREATE TABLE [phpbb_reports_reasons] (
1384 [reason_id] [int] IDENTITY (1, 1) NOT NULL ,
1385 [reason_title] [varchar] (255) NOT NULL ,
1386 [reason_description] [varchar] (8000) ,
1387 [reason_order] [int] NOT NULL
1391 ALTER TABLE [phpbb_reports_reasons] WITH NOCHECK ADD
1392 CONSTRAINT [PK_phpbb_reports_reasons] PRIMARY KEY CLUSTERED
1398 ALTER TABLE [phpbb_reports_reasons] WITH NOCHECK ADD
1399 CONSTRAINT [DF_phpbb_reporr_reason_order] DEFAULT (0) FOR [reason_order],
1400 CONSTRAINT [DF_phpbb_reporr_reason_title] DEFAULT ('') FOR [reason_title]
1405 Table: phpbb_search_results
1407 CREATE TABLE [phpbb_search_results] (
1408 [search_key] [varchar] (32) NOT NULL ,
1409 [search_time] [int] NOT NULL ,
1410 [search_keywords] [varchar] (8000) ,
1411 [search_authors] [text]
1412 ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
1415 ALTER TABLE [phpbb_search_results] WITH NOCHECK ADD
1416 CONSTRAINT [PK_phpbb_search_results] PRIMARY KEY CLUSTERED
1422 ALTER TABLE [phpbb_search_results] WITH NOCHECK ADD
1423 CONSTRAINT [DF_phpbb_search_search_time] DEFAULT (0) FOR [search_time],
1424 CONSTRAINT [DF_phpbb_search_search_key] DEFAULT ('') FOR [search_key]
1429 Table: phpbb_search_wordlist
1431 CREATE TABLE [phpbb_search_wordlist] (
1432 [word_text] [nvarchar] (252) NOT NULL ,
1433 [word_id] [int] IDENTITY (1, 1) NOT NULL ,
1434 [word_common] [int] NOT NULL
1438 ALTER TABLE [phpbb_search_wordlist] WITH NOCHECK ADD
1439 CONSTRAINT [PK_phpbb_search_wordlist] PRIMARY KEY CLUSTERED
1445 ALTER TABLE [phpbb_search_wordlist] WITH NOCHECK ADD
1446 CONSTRAINT [DF_phpbb_swlist_word_common] DEFAULT (0) FOR [word_common],
1447 CONSTRAINT [DF_phpbb_swlist_word_text] DEFAULT ('') FOR [word_text]
1450 CREATE INDEX [word_id] ON [phpbb_search_wordlist]([word_id]) ON [PRIMARY]
1455 Table: phpbb_search_wordmatch
1457 CREATE TABLE [phpbb_search_wordmatch] (
1458 [post_id] [int] NOT NULL ,
1459 [word_id] [int] NOT NULL ,
1460 [title_match] [int] NOT NULL
1464 ALTER TABLE [phpbb_search_wordmatch] WITH NOCHECK ADD
1465 CONSTRAINT [DF_phpbb_swmatc_post_id] DEFAULT (0) FOR [post_id],
1466 CONSTRAINT [DF_phpbb_swmatc_word_id] DEFAULT (0) FOR [word_id],
1467 CONSTRAINT [DF_phpbb_swmatc_title_match] DEFAULT (0) FOR [title_match]
1470 CREATE INDEX [word_id] ON [phpbb_search_wordmatch]([word_id]) ON [PRIMARY]
1475 Table: phpbb_sessions
1477 CREATE TABLE [phpbb_sessions] (
1478 [session_id] [varchar] (32) NOT NULL ,
1479 [session_user_id] [int] NOT NULL ,
1480 [session_last_visit] [int] NOT NULL ,
1481 [session_start] [int] NOT NULL ,
1482 [session_time] [int] NOT NULL ,
1483 [session_ip] [varchar] (40) NOT NULL ,
1484 [session_browser] [varchar] (150) NOT NULL ,
1485 [session_page] [varchar] (200) NOT NULL ,
1486 [session_viewonline] [int] NOT NULL ,
1487 [session_autologin] [int] NOT NULL ,
1488 [session_admin] [int] NOT NULL
1492 ALTER TABLE [phpbb_sessions] WITH NOCHECK ADD
1493 CONSTRAINT [PK_phpbb_sessions] PRIMARY KEY CLUSTERED
1499 ALTER TABLE [phpbb_sessions] WITH NOCHECK ADD
1500 CONSTRAINT [DF_phpbb_sessio_session_user_id] DEFAULT (0) FOR [session_user_id],
1501 CONSTRAINT [DF_phpbb_sessio_session_last_visit] DEFAULT (0) FOR [session_last_visit],
1502 CONSTRAINT [DF_phpbb_sessio_session_start] DEFAULT (0) FOR [session_start],
1503 CONSTRAINT [DF_phpbb_sessio_session_time] DEFAULT (0) FOR [session_time],
1504 CONSTRAINT [DF_phpbb_sessio_session_ip] DEFAULT ('0') FOR [session_ip],
1505 CONSTRAINT [DF_phpbb_sessio_session_viewonline] DEFAULT (1) FOR [session_viewonline],
1506 CONSTRAINT [DF_phpbb_sessio_session_autologin] DEFAULT (0) FOR [session_autologin],
1507 CONSTRAINT [DF_phpbb_sessio_session_admin] DEFAULT (0) FOR [session_admin],
1508 CONSTRAINT [DF_phpbb_sessio_session_id] DEFAULT ('') FOR [session_id],
1509 CONSTRAINT [DF_phpbb_sessio_session_browser] DEFAULT ('') FOR [session_browser],
1510 CONSTRAINT [DF_phpbb_sessio_session_page] DEFAULT ('') FOR [session_page]
1513 CREATE INDEX [session_time] ON [phpbb_sessions]([session_time]) ON [PRIMARY]
1516 CREATE INDEX [session_user_id] ON [phpbb_sessions]([session_user_id]) ON [PRIMARY]
1521 Table: phpbb_sessions_keys
1523 CREATE TABLE [phpbb_sessions_keys] (
1524 [key_id] [varchar] (32) NOT NULL ,
1525 [user_id] [int] NOT NULL ,
1526 [last_ip] [varchar] (40) NOT NULL ,
1527 [last_login] [int] NOT NULL
1531 ALTER TABLE [phpbb_sessions_keys] WITH NOCHECK ADD
1532 CONSTRAINT [PK_phpbb_sessions_keys] PRIMARY KEY CLUSTERED
1539 ALTER TABLE [phpbb_sessions_keys] WITH NOCHECK ADD
1540 CONSTRAINT [DF_phpbb_sessik_key_id] DEFAULT ('0') FOR [key_id],
1541 CONSTRAINT [DF_phpbb_sessik_user_id] DEFAULT (0) FOR [user_id],
1542 CONSTRAINT [DF_phpbb_sessik_last_ip] DEFAULT ('0') FOR [last_ip],
1543 CONSTRAINT [DF_phpbb_sessik_last_login] DEFAULT (0) FOR [last_login]
1546 CREATE INDEX [last_login] ON [phpbb_sessions_keys]([last_login]) ON [PRIMARY]
1551 Table: phpbb_sitelist
1553 CREATE TABLE [phpbb_sitelist] (
1554 [site_id] [int] IDENTITY (1, 1) NOT NULL ,
1555 [site_ip] [varchar] (40) NOT NULL ,
1556 [site_hostname] [varchar] (255) NOT NULL ,
1557 [ip_exclude] [int] NOT NULL
1561 ALTER TABLE [phpbb_sitelist] WITH NOCHECK ADD
1562 CONSTRAINT [PK_phpbb_sitelist] PRIMARY KEY CLUSTERED
1568 ALTER TABLE [phpbb_sitelist] WITH NOCHECK ADD
1569 CONSTRAINT [DF_phpbb_siteli_ip_exclude] DEFAULT (0) FOR [ip_exclude],
1570 CONSTRAINT [DF_phpbb_siteli_ip_site_ip] DEFAULT ('') FOR [site_ip],
1571 CONSTRAINT [DF_phpbb_siteli_ip_site_hostname] DEFAULT ('') FOR [site_hostname]
1576 Table: phpbb_smilies
1578 CREATE TABLE [phpbb_smilies] (
1579 [smiley_id] [int] IDENTITY (1, 1) NOT NULL ,
1580 [code] [varchar] (50) NULL ,
1581 [emotion] [varchar] (50) NULL ,
1582 [smiley_url] [varchar] (50) NULL ,
1583 [smiley_width] [int] NOT NULL ,
1584 [smiley_height] [int] NOT NULL ,
1585 [smiley_order] [int] NOT NULL ,
1586 [display_on_posting] [int] NOT NULL
1590 ALTER TABLE [phpbb_smilies] WITH NOCHECK ADD
1591 CONSTRAINT [PK_phpbb_smilies] PRIMARY KEY CLUSTERED
1597 ALTER TABLE [phpbb_smilies] WITH NOCHECK ADD
1598 CONSTRAINT [DF_phpbb_smilie_smiley_width] DEFAULT (0) FOR [smiley_width],
1599 CONSTRAINT [DF_phpbb_smilie_smiley_height] DEFAULT (0) FOR [smiley_height],
1600 CONSTRAINT [DF_phpbb_smilie_smiley_order] DEFAULT (0) FOR [smiley_order],
1601 CONSTRAINT [DF_phpbb_smilie_display_on_posting] DEFAULT (1) FOR [display_on_posting]
1608 CREATE TABLE [phpbb_styles] (
1609 [style_id] [int] IDENTITY (1, 1) NOT NULL ,
1610 [style_name] [varchar] (255) NOT NULL ,
1611 [style_copyright] [varchar] (255) NOT NULL ,
1612 [style_active] [int] NOT NULL ,
1613 [template_id] [int] NOT NULL ,
1614 [theme_id] [int] NOT NULL ,
1615 [imageset_id] [int] NOT NULL
1619 ALTER TABLE [phpbb_styles] WITH NOCHECK ADD
1620 CONSTRAINT [PK_phpbb_styles] PRIMARY KEY CLUSTERED
1626 ALTER TABLE [phpbb_styles] WITH NOCHECK ADD
1627 CONSTRAINT [DF_phpbb_styles_style_active] DEFAULT (1) FOR [style_active],
1628 CONSTRAINT [DF_phpbb_styles_style_name] DEFAULT ('') FOR [style_name],
1629 CONSTRAINT [DF_phpbb_styles_style_copyright] DEFAULT ('') FOR [style_copyright],
1630 CONSTRAINT [DF_phpbb_styles_template_id] DEFAULT (0) FOR [template_id],
1631 CONSTRAINT [DF_phpbb_styles_theme_id] DEFAULT (0) FOR [theme_id],
1632 CONSTRAINT [DF_phpbb_styles_imageset_id] DEFAULT (0) FOR [imageset_id]
1635 CREATE UNIQUE INDEX [style_name] ON [phpbb_styles]([style_name]) ON [PRIMARY]
1638 CREATE INDEX [template_id] ON [phpbb_styles]([template_id]) ON [PRIMARY]
1641 CREATE INDEX [theme_id] ON [phpbb_styles]([theme_id]) ON [PRIMARY]
1644 CREATE INDEX [imageset_id] ON [phpbb_styles]([imageset_id]) ON [PRIMARY]
1649 Table: phpbb_styles_template
1651 CREATE TABLE [phpbb_styles_template] (
1652 [template_id] [int] IDENTITY (1, 1) NOT NULL ,
1653 [template_name] [varchar] (255) NOT NULL ,
1654 [template_copyright] [varchar] (255) NOT NULL ,
1655 [template_path] [varchar] (100) NOT NULL ,
1656 [bbcode_bitfield] [int] NOT NULL ,
1657 [template_storedb] [int] NOT NULL
1661 ALTER TABLE [phpbb_styles_template] WITH NOCHECK ADD
1662 CONSTRAINT [PK_phpbb_styles_template] PRIMARY KEY CLUSTERED
1668 ALTER TABLE [phpbb_styles_template] WITH NOCHECK ADD
1669 CONSTRAINT [DF_phpbb_templa_bbcode_bitfield] DEFAULT (6921) FOR [bbcode_bitfield],
1670 CONSTRAINT [DF_phpbb_templa_template_storedb] DEFAULT (0) FOR [template_storedb]
1673 CREATE UNIQUE INDEX [template_name] ON [phpbb_styles_template]([template_name]) ON [PRIMARY]
1678 Table: phpbb_styles_template_data
1680 CREATE TABLE [phpbb_styles_template_data] (
1681 [template_id] [int] NOT NULL ,
1682 [template_filename] [varchar] (100) NOT NULL ,
1683 [template_included] [text] ,
1684 [template_mtime] [int] NOT NULL ,
1685 [template_data] [text]
1686 ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
1689 ALTER TABLE [phpbb_styles_template_data] WITH NOCHECK ADD
1690 CONSTRAINT [DF_phpbb_tpldat_template_id] DEFAULT (0) FOR [template_id],
1691 CONSTRAINT [DF_phpbb_tpldat_template_mtime] DEFAULT (0) FOR [template_mtime],
1692 CONSTRAINT [DF_phpbb_tpldat_template_filename] DEFAULT ('') FOR [template_filename]
1695 CREATE INDEX [template_id] ON [phpbb_styles_template_data]([template_id]) ON [PRIMARY]
1698 CREATE INDEX [template_filename] ON [phpbb_styles_template_data]([template_filename]) ON [PRIMARY]
1703 Table: phpbb_styles_theme
1705 CREATE TABLE [phpbb_styles_theme] (
1706 [theme_id] [int] IDENTITY (1, 1) NOT NULL ,
1707 [theme_name] [varchar] (255) NOT NULL ,
1708 [theme_copyright] [varchar] (255) NOT NULL ,
1709 [theme_path] [varchar] (100) NOT NULL ,
1710 [theme_storedb] [int] NOT NULL ,
1711 [theme_mtime] [int] NOT NULL ,
1713 ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
1716 ALTER TABLE [phpbb_styles_theme] WITH NOCHECK ADD
1717 CONSTRAINT [PK_phpbb_styles_theme] PRIMARY KEY CLUSTERED
1723 ALTER TABLE [phpbb_styles_theme] WITH NOCHECK ADD
1724 CONSTRAINT [DF_phpbb_theme__theme_storedb] DEFAULT (0) FOR [theme_storedb],
1725 CONSTRAINT [DF_phpbb_theme__theme_mtime] DEFAULT (0) FOR [theme_mtime],
1726 CONSTRAINT [DF_phpbb_theme__theme_name] DEFAULT ('') FOR [theme_name],
1727 CONSTRAINT [DF_phpbb_theme__theme_copyright] DEFAULT ('') FOR [theme_copyright],
1728 CONSTRAINT [DF_phpbb_theme__theme_path] DEFAULT ('') FOR [theme_path]
1731 CREATE UNIQUE INDEX [theme_name] ON [phpbb_styles_theme]([theme_name]) ON [PRIMARY]
1735 Table: phpbb_styles_imageset
1737 CREATE TABLE [phpbb_styles_imageset] (
1738 [imageset_id] [int] IDENTITY (1, 1) NOT NULL ,
1739 [imageset_name] [varchar] (255) NOT NULL ,
1740 [imageset_copyright] [varchar] (255) NOT NULL ,
1741 [imageset_path] [varchar] (100) NOT NULL ,
1742 [site_logo] [varchar] (200) NOT NULL ,
1743 [btn_post] [varchar] (200) NOT NULL ,
1744 [btn_post_pm] [varchar] (200) NOT NULL ,
1745 [btn_reply] [varchar] (200) NOT NULL ,
1746 [btn_reply_pm] [varchar] (200) NOT NULL ,
1747 [btn_locked] [varchar] (200) NOT NULL ,
1748 [btn_profile] [varchar] (200) NOT NULL ,
1749 [btn_pm] [varchar] (200) NOT NULL ,
1750 [btn_delete] [varchar] (200) NOT NULL ,
1751 [btn_info] [varchar] (200) NOT NULL ,
1752 [btn_quote] [varchar] (200) NOT NULL ,
1753 [btn_search] [varchar] (200) NOT NULL ,
1754 [btn_edit] [varchar] (200) NOT NULL ,
1755 [btn_report] [varchar] (200) NOT NULL ,
1756 [btn_email] [varchar] (200) NOT NULL ,
1757 [btn_www] [varchar] (200) NOT NULL ,
1758 [btn_icq] [varchar] (200) NOT NULL ,
1759 [btn_aim] [varchar] (200) NOT NULL ,
1760 [btn_yim] [varchar] (200) NOT NULL ,
1761 [btn_msnm] [varchar] (200) NOT NULL ,
1762 [btn_jabber] [varchar] (200) NOT NULL ,
1763 [btn_online] [varchar] (200) NOT NULL ,
1764 [btn_offline] [varchar] (200) NOT NULL ,
1765 [btn_friend] [varchar] (200) NOT NULL ,
1766 [btn_foe] [varchar] (200) NOT NULL ,
1767 [icon_unapproved] [varchar] (200) NOT NULL ,
1768 [icon_reported] [varchar] (200) NOT NULL ,
1769 [icon_attach] [varchar] (200) NOT NULL ,
1770 [icon_post] [varchar] (200) NOT NULL ,
1771 [icon_post_new] [varchar] (200) NOT NULL ,
1772 [icon_post_latest] [varchar] (200) NOT NULL ,
1773 [icon_post_newest] [varchar] (200) NOT NULL ,
1774 [forum] [varchar] (200) NOT NULL ,
1775 [forum_new] [varchar] (200) NOT NULL ,
1776 [forum_locked] [varchar] (200) NOT NULL ,
1777 [forum_link] [varchar] (200) NOT NULL ,
1778 [sub_forum] [varchar] (200) NOT NULL ,
1779 [sub_forum_new] [varchar] (200) NOT NULL ,
1780 [folder] [varchar] (200) NOT NULL ,
1781 [folder_moved] [varchar] (200) NOT NULL ,
1782 [folder_posted] [varchar] (200) NOT NULL ,
1783 [folder_new] [varchar] (200) NOT NULL ,
1784 [folder_new_posted] [varchar] (200) NOT NULL ,
1785 [folder_hot] [varchar] (200) NOT NULL ,
1786 [folder_hot_posted] [varchar] (200) NOT NULL ,
1787 [folder_hot_new] [varchar] (200) NOT NULL ,
1788 [folder_hot_new_posted] [varchar] (200) NOT NULL ,
1789 [folder_locked] [varchar] (200) NOT NULL ,
1790 [folder_locked_posted] [varchar] (200) NOT NULL ,
1791 [folder_locked_new] [varchar] (200) NOT NULL ,
1792 [folder_locked_new_posted] [varchar] (200) NOT NULL ,
1793 [folder_locked_announce] [varchar] (200) NOT NULL ,
1794 [folder_locked_announce_new] [varchar] (200) NOT NULL ,
1795 [folder_locked_announce_posted] [varchar] (200) NOT NULL ,
1796 [folder_locked_announce_new_posted] [varchar] (200) NOT NULL ,
1797 [folder_locked_global] [varchar] (200) NOT NULL ,
1798 [folder_locked_global_new] [varchar] (200) NOT NULL ,
1799 [folder_locked_global_posted] [varchar] (200) NOT NULL ,
1800 [folder_locked_global_new_posted] [varchar] (200) NOT NULL ,
1801 [folder_locked_sticky] [varchar] (200) NOT NULL ,
1802 [folder_locked_sticky_new] [varchar] (200) NOT NULL ,
1803 [folder_locked_sticky_posted] [varchar] (200) NOT NULL ,
1804 [folder_locked_sticky_new_posted] [varchar] (200) NOT NULL ,
1805 [folder_sticky] [varchar] (200) NOT NULL ,
1806 [folder_sticky_posted] [varchar] (200) NOT NULL ,
1807 [folder_sticky_new] [varchar] (200) NOT NULL ,
1808 [folder_sticky_new_posted] [varchar] (200) NOT NULL ,
1809 [folder_announce] [varchar] (200) NOT NULL ,
1810 [folder_announce_posted] [varchar] (200) NOT NULL ,
1811 [folder_announce_new] [varchar] (200) NOT NULL ,
1812 [folder_announce_new_posted] [varchar] (200) NOT NULL ,
1813 [folder_global] [varchar] (200) NOT NULL ,
1814 [folder_global_posted] [varchar] (200) NOT NULL ,
1815 [folder_global_new] [varchar] (200) NOT NULL ,
1816 [folder_global_new_posted] [varchar] (200) NOT NULL ,
1817 [poll_left] [varchar] (200) NOT NULL ,
1818 [poll_center] [varchar] (200) NOT NULL ,
1819 [poll_right] [varchar] (200) NOT NULL ,
1820 [attach_progress_bar] [varchar] (200) NOT NULL ,
1821 [user_icon1] [varchar] (200) NOT NULL ,
1822 [user_icon2] [varchar] (200) NOT NULL ,
1823 [user_icon3] [varchar] (200) NOT NULL ,
1824 [user_icon4] [varchar] (200) NOT NULL ,
1825 [user_icon5] [varchar] (200) NOT NULL ,
1826 [user_icon6] [varchar] (200) NOT NULL ,
1827 [user_icon7] [varchar] (200) NOT NULL ,
1828 [user_icon8] [varchar] (200) NOT NULL ,
1829 [user_icon9] [varchar] (200) NOT NULL ,
1830 [user_icon10] [varchar] (200) NOT NULL
1834 ALTER TABLE [phpbb_styles_imageset] WITH NOCHECK ADD
1835 CONSTRAINT [PK_phpbb_styles_imageset] PRIMARY KEY CLUSTERED
1841 ALTER TABLE [phpbb_styles_imageset] WITH NOCHECK ADD
1842 CONSTRAINT [DF_phpbb_styles_imageset_imageset_name] DEFAULT ('') FOR [imageset_name],
1843 CONSTRAINT [DF_phpbb_styles_imageset_imageset_copyright] DEFAULT ('') FOR [imageset_copyright],
1844 CONSTRAINT [DF_phpbb_styles_imageset_imageset_path] DEFAULT ('') FOR [imageset_path],
1845 CONSTRAINT [DF_phpbb_styles_imageset_site_logo] DEFAULT ('') FOR [site_logo],
1846 CONSTRAINT [DF_phpbb_styles_imageset_btn_post] DEFAULT ('') FOR [btn_post],
1847 CONSTRAINT [DF_phpbb_styles_imageset_btn_post_pm] DEFAULT ('') FOR [btn_post_pm],
1848 CONSTRAINT [DF_phpbb_styles_imageset_btn_reply] DEFAULT ('') FOR [btn_reply],
1849 CONSTRAINT [DF_phpbb_styles_imageset_btn_reply_pm] DEFAULT ('') FOR [btn_reply_pm],
1850 CONSTRAINT [DF_phpbb_styles_imageset_btn_locked] DEFAULT ('') FOR [btn_locked],
1851 CONSTRAINT [DF_phpbb_styles_imageset_btn_profile] DEFAULT ('') FOR [btn_profile],
1852 CONSTRAINT [DF_phpbb_styles_imageset_btn_pm] DEFAULT ('') FOR [btn_pm],
1853 CONSTRAINT [DF_phpbb_styles_imageset_btn_delete] DEFAULT ('') FOR [btn_delete],
1854 CONSTRAINT [DF_phpbb_styles_imageset_btn_info] DEFAULT ('') FOR [btn_info],
1855 CONSTRAINT [DF_phpbb_styles_imageset_btn_quote] DEFAULT ('') FOR [btn_quote],
1856 CONSTRAINT [DF_phpbb_styles_imageset_btn_search] DEFAULT ('') FOR [btn_search],
1857 CONSTRAINT [DF_phpbb_styles_imageset_btn_edit] DEFAULT ('') FOR [btn_edit],
1858 CONSTRAINT [DF_phpbb_styles_imageset_btn_report] DEFAULT ('') FOR [btn_report],
1859 CONSTRAINT [DF_phpbb_styles_imageset_btn_email] DEFAULT ('') FOR [btn_email],
1860 CONSTRAINT [DF_phpbb_styles_imageset_btn_www] DEFAULT ('') FOR [btn_www],
1861 CONSTRAINT [DF_phpbb_styles_imageset_btn_icq] DEFAULT ('') FOR [btn_icq],
1862 CONSTRAINT [DF_phpbb_styles_imageset_btn_aim] DEFAULT ('') FOR [btn_aim],
1863 CONSTRAINT [DF_phpbb_styles_imageset_btn_yim] DEFAULT ('') FOR [btn_yim],
1864 CONSTRAINT [DF_phpbb_styles_imageset_btn_msnm] DEFAULT ('') FOR [btn_msnm],
1865 CONSTRAINT [DF_phpbb_styles_imageset_btn_jabber] DEFAULT ('') FOR [btn_jabber],
1866 CONSTRAINT [DF_phpbb_styles_imageset_btn_online] DEFAULT ('') FOR [btn_online],
1867 CONSTRAINT [DF_phpbb_styles_imageset_btn_offline] DEFAULT ('') FOR [btn_offline],
1868 CONSTRAINT [DF_phpbb_styles_imageset_btn_friend] DEFAULT ('') FOR [btn_friend],
1869 CONSTRAINT [DF_phpbb_styles_imageset_btn_foe] DEFAULT ('') FOR [btn_foe],
1870 CONSTRAINT [DF_phpbb_styles_imageset_icon_unapproved] DEFAULT ('') FOR [icon_unapproved],
1871 CONSTRAINT [DF_phpbb_styles_imageset_icon_reported] DEFAULT ('') FOR [icon_reported],
1872 CONSTRAINT [DF_phpbb_styles_imageset_icon_attach] DEFAULT ('') FOR [icon_attach],
1873 CONSTRAINT [DF_phpbb_styles_imageset_icon_post] DEFAULT ('') FOR [icon_post],
1874 CONSTRAINT [DF_phpbb_styles_imageset_icon_post_new] DEFAULT ('') FOR [icon_post_new],
1875 CONSTRAINT [DF_phpbb_styles_imageset_icon_post_latest] DEFAULT ('') FOR [icon_post_latest],
1876 CONSTRAINT [DF_phpbb_styles_imageset_icon_post_newest] DEFAULT ('') FOR [icon_post_newest],
1877 CONSTRAINT [DF_phpbb_styles_imageset_forum] DEFAULT ('') FOR [forum],
1878 CONSTRAINT [DF_phpbb_styles_imageset_forum_new] DEFAULT ('') FOR [forum_new],
1879 CONSTRAINT [DF_phpbb_styles_imageset_forum_locked] DEFAULT ('') FOR [forum_locked],
1880 CONSTRAINT [DF_phpbb_styles_imageset_forum_link] DEFAULT ('') FOR [forum_link],
1881 CONSTRAINT [DF_phpbb_styles_imageset_sub_forum] DEFAULT ('') FOR [sub_forum],
1882 CONSTRAINT [DF_phpbb_styles_imageset_sub_forum_new] DEFAULT ('') FOR [sub_forum_new],
1883 CONSTRAINT [DF_phpbb_styles_imageset_folder] DEFAULT ('') FOR [folder],
1884 CONSTRAINT [DF_phpbb_styles_imageset_folder_moved] DEFAULT ('') FOR [folder_moved],
1885 CONSTRAINT [DF_phpbb_styles_imageset_folder_posted] DEFAULT ('') FOR [folder_posted],
1886 CONSTRAINT [DF_phpbb_styles_imageset_folder_new] DEFAULT ('') FOR [folder_new],
1887 CONSTRAINT [DF_phpbb_styles_imageset_folder_new_posted] DEFAULT ('') FOR [folder_new_posted],
1888 CONSTRAINT [DF_phpbb_styles_imageset_folder_hot] DEFAULT ('') FOR [folder_hot],
1889 CONSTRAINT [DF_phpbb_styles_imageset_folder_hot_posted] DEFAULT ('') FOR [folder_hot_posted],
1890 CONSTRAINT [DF_phpbb_styles_imageset_folder_hot_new] DEFAULT ('') FOR [folder_hot_new],
1891 CONSTRAINT [DF_phpbb_styles_imageset_folder_hot_new_posted] DEFAULT ('') FOR [folder_hot_new_posted],
1892 CONSTRAINT [DF_phpbb_styles_imageset_folder_locked] DEFAULT ('') FOR [folder_locked],
1893 CONSTRAINT [DF_phpbb_styles_imageset_folder_locked_posted] DEFAULT ('') FOR [folder_locked_posted],
1894 CONSTRAINT [DF_phpbb_styles_imageset_folder_locked_new] DEFAULT ('') FOR [folder_locked_new],
1895 CONSTRAINT [DF_phpbb_styles_imageset_folder_locked_new_posted] DEFAULT ('') FOR [folder_locked_new_posted],
1896 CONSTRAINT [DF_phpbb_styles_imageset_folder_locked_announce] DEFAULT ('') FOR [folder_locked_announce],
1897 CONSTRAINT [DF_phpbb_styles_imageset_folder_locked_announce_new] DEFAULT ('') FOR [folder_locked_announce_new],
1898 CONSTRAINT [DF_phpbb_styles_imageset_folder_locked_announce_posted] DEFAULT ('') FOR [folder_locked_announce_posted],
1899 CONSTRAINT [DF_phpbb_styles_imageset_folder_locked_announce_new_posted] DEFAULT ('') FOR [folder_locked_announce_new_posted],
1900 CONSTRAINT [DF_phpbb_styles_imageset_folder_locked_global] DEFAULT ('') FOR [folder_locked_global],
1901 CONSTRAINT [DF_phpbb_styles_imageset_folder_locked_global_new] DEFAULT ('') FOR [folder_locked_global_new],
1902 CONSTRAINT [DF_phpbb_styles_imageset_folder_locked_global_posted] DEFAULT ('') FOR [folder_locked_global_posted],
1903 CONSTRAINT [DF_phpbb_styles_imageset_folder_locked_global_new_posted] DEFAULT ('') FOR [folder_locked_global_new_posted],
1904 CONSTRAINT [DF_phpbb_styles_imageset_folder_locked_sticky] DEFAULT ('') FOR [folder_locked_sticky],
1905 CONSTRAINT [DF_phpbb_styles_imageset_folder_locked_sticky_new] DEFAULT ('') FOR [folder_locked_sticky_new],
1906 CONSTRAINT [DF_phpbb_styles_imageset_folder_locked_sticky_posted] DEFAULT ('') FOR [folder_locked_sticky_posted],
1907 CONSTRAINT [DF_phpbb_styles_imageset_folder_locked_sticky_new_posted] DEFAULT ('') FOR [folder_locked_sticky_new_posted],
1908 CONSTRAINT [DF_phpbb_styles_imageset_folder_sticky] DEFAULT ('') FOR [folder_sticky],
1909 CONSTRAINT [DF_phpbb_styles_imageset_folder_sticky_posted] DEFAULT ('') FOR [folder_sticky_posted],
1910 CONSTRAINT [DF_phpbb_styles_imageset_folder_sticky_new] DEFAULT ('') FOR [folder_sticky_new],
1911 CONSTRAINT [DF_phpbb_styles_imageset_folder_sticky_new_posted] DEFAULT ('') FOR [folder_sticky_new_posted],
1912 CONSTRAINT [DF_phpbb_styles_imageset_folder_announce] DEFAULT ('') FOR [folder_announce],
1913 CONSTRAINT [DF_phpbb_styles_imageset_folder_announce_posted] DEFAULT ('') FOR [folder_announce_posted],
1914 CONSTRAINT [DF_phpbb_styles_imageset_folder_announce_new] DEFAULT ('') FOR [folder_announce_new],
1915 CONSTRAINT [DF_phpbb_styles_imageset_folder_announce_new_posted] DEFAULT ('') FOR [folder_announce_new_posted],
1916 CONSTRAINT [DF_phpbb_styles_imageset_folder_global] DEFAULT ('') FOR [folder_global],
1917 CONSTRAINT [DF_phpbb_styles_imageset_folder_global_posted] DEFAULT ('') FOR [folder_global_posted],
1918 CONSTRAINT [DF_phpbb_styles_imageset_folder_global_new] DEFAULT ('') FOR [folder_global_new],
1919 CONSTRAINT [DF_phpbb_styles_imageset_folder_global_new_posted] DEFAULT ('') FOR [folder_global_new_posted],
1920 CONSTRAINT [DF_phpbb_styles_imageset_poll_left] DEFAULT ('') FOR [poll_left],
1921 CONSTRAINT [DF_phpbb_styles_imageset_poll_center] DEFAULT ('') FOR [poll_center],
1922 CONSTRAINT [DF_phpbb_styles_imageset_poll_right] DEFAULT ('') FOR [poll_right],
1923 CONSTRAINT [DF_phpbb_styles_imageset_attach_progress_bar] DEFAULT ('') FOR [attach_progress_bar],
1924 CONSTRAINT [DF_phpbb_styles_imageset_user_icon1] DEFAULT ('') FOR [user_icon1],
1925 CONSTRAINT [DF_phpbb_styles_imageset_user_icon2] DEFAULT ('') FOR [user_icon2],
1926 CONSTRAINT [DF_phpbb_styles_imageset_user_icon3] DEFAULT ('') FOR [user_icon3],
1927 CONSTRAINT [DF_phpbb_styles_imageset_user_icon4] DEFAULT ('') FOR [user_icon4],
1928 CONSTRAINT [DF_phpbb_styles_imageset_user_icon5] DEFAULT ('') FOR [user_icon5],
1929 CONSTRAINT [DF_phpbb_styles_imageset_user_icon6] DEFAULT ('') FOR [user_icon6],
1930 CONSTRAINT [DF_phpbb_styles_imageset_user_icon7] DEFAULT ('') FOR [user_icon7],
1931 CONSTRAINT [DF_phpbb_styles_imageset_user_icon8] DEFAULT ('') FOR [user_icon8],
1932 CONSTRAINT [DF_phpbb_styles_imageset_user_icon9] DEFAULT ('') FOR [user_icon9],
1933 CONSTRAINT [DF_phpbb_styles_imageset_user_icon10] DEFAULT ('') FOR [user_icon10]
1936 CREATE UNIQUE INDEX [imageset_name] ON [phpbb_styles_imageset]([imageset_name]) ON [PRIMARY]
1944 CREATE TABLE [phpbb_topics] (
1945 [topic_id] [int] IDENTITY (1, 1) NOT NULL ,
1946 [forum_id] [int] NOT NULL ,
1947 [icon_id] [int] NOT NULL ,
1948 [topic_attachment] [int] NOT NULL ,
1949 [topic_approved] [int] NOT NULL ,
1950 [topic_reported] [int] NOT NULL ,
1951 [topic_title] [varchar] (1000) ,
1952 [topic_poster] [int] NOT NULL ,
1953 [topic_time] [int] NOT NULL ,
1954 [topic_time_limit] [int] NOT NULL ,
1955 [topic_views] [int] NOT NULL ,
1956 [topic_replies] [int] NOT NULL ,
1957 [topic_replies_real] [int] NOT NULL ,
1958 [topic_status] [int] NOT NULL ,
1959 [topic_type] [int] NOT NULL ,
1960 [topic_first_post_id] [int] NOT NULL ,
1961 [topic_first_poster_name] [varchar] (255) NULL ,
1962 [topic_last_post_id] [int] NOT NULL ,
1963 [topic_last_poster_id] [int] NOT NULL ,
1964 [topic_last_poster_name] [varchar] (255) NULL ,
1965 [topic_last_post_time] [int] NOT NULL ,
1966 [topic_last_view_time] [int] NOT NULL ,
1967 [topic_moved_id] [int] NOT NULL ,
1968 [topic_bumped] [int] NOT NULL ,
1969 [topic_bumper] [int] NOT NULL ,
1970 [poll_title] [varchar] (3000) NULL ,
1971 [poll_start] [int] NULL ,
1972 [poll_length] [int] NULL ,
1973 [poll_max_options] [int] NOT NULL ,
1974 [poll_last_vote] [int] NULL ,
1975 [poll_vote_change] [int] NOT NULL
1979 ALTER TABLE [phpbb_topics] WITH NOCHECK ADD
1980 CONSTRAINT [PK_phpbb_topics] PRIMARY KEY CLUSTERED
1986 ALTER TABLE [phpbb_topics] WITH NOCHECK ADD
1987 CONSTRAINT [DF_phpbb_topics_forum_id] DEFAULT (0) FOR [forum_id],
1988 CONSTRAINT [DF_phpbb_topics_icon_id] DEFAULT (1) FOR [icon_id],
1989 CONSTRAINT [DF_phpbb_topics_topic_attachment] DEFAULT (0) FOR [topic_attachment],
1990 CONSTRAINT [DF_phpbb_topics_topic_approved] DEFAULT (1) FOR [topic_approved],
1991 CONSTRAINT [DF_phpbb_topics_topic_reported] DEFAULT (0) FOR [topic_reported],
1992 CONSTRAINT [DF_phpbb_topics_topic_poster] DEFAULT (0) FOR [topic_poster],
1993 CONSTRAINT [DF_phpbb_topics_topic_time] DEFAULT (0) FOR [topic_time],
1994 CONSTRAINT [DF_phpbb_topics_topic_time_limit] DEFAULT (0) FOR [topic_time_limit],
1995 CONSTRAINT [DF_phpbb_topics_topic_views] DEFAULT (0) FOR [topic_views],
1996 CONSTRAINT [DF_phpbb_topics_topic_replies] DEFAULT (0) FOR [topic_replies],
1997 CONSTRAINT [DF_phpbb_topics_topic_replies_real] DEFAULT (0) FOR [topic_replies_real],
1998 CONSTRAINT [DF_phpbb_topics_topic_status] DEFAULT (0) FOR [topic_status],
1999 CONSTRAINT [DF_phpbb_topics_topic_type] DEFAULT (0) FOR [topic_type],
2000 CONSTRAINT [DF_phpbb_topics_topic_first_post_id] DEFAULT (0) FOR [topic_first_post_id],
2001 CONSTRAINT [DF_phpbb_topics_topic_last_post_id] DEFAULT (0) FOR [topic_last_post_id],
2002 CONSTRAINT [DF_phpbb_topics_topic_last_poster_id] DEFAULT (0) FOR [topic_last_poster_id],
2003 CONSTRAINT [DF_phpbb_topics_topic_last_post_time] DEFAULT (0) FOR [topic_last_post_time],
2004 CONSTRAINT [DF_phpbb_topics_topic_last_view_time] DEFAULT (0) FOR [topic_last_view_time],
2005 CONSTRAINT [DF_phpbb_topics_topic_moved_id] DEFAULT (0) FOR [topic_moved_id],
2006 CONSTRAINT [DF_phpbb_topics_topic_bumped] DEFAULT (0) FOR [topic_bumped],
2007 CONSTRAINT [DF_phpbb_topics_topic_bumper] DEFAULT (0) FOR [topic_bumper],
2008 CONSTRAINT [DF_phpbb_topics_poll_start] DEFAULT (0) FOR [poll_start],
2009 CONSTRAINT [DF_phpbb_topics_poll_length] DEFAULT (0) FOR [poll_length],
2010 CONSTRAINT [DF_phpbb_topics_poll_max_options] DEFAULT (1) FOR [poll_max_options],
2011 CONSTRAINT [DF_phpbb_topics_poll_last_vote] DEFAULT (0) FOR [poll_last_vote],
2012 CONSTRAINT [DF_phpbb_topics_poll_vote_change] DEFAULT (0) FOR [poll_vote_change]
2015 CREATE INDEX [forum_id] ON [phpbb_topics]([forum_id]) ON [PRIMARY]
2018 CREATE INDEX [forum_id_type] ON [phpbb_topics]([forum_id], [topic_type]) ON [PRIMARY]
2021 CREATE INDEX [topic_last_post_time] ON [phpbb_topics]([topic_last_post_time]) ON [PRIMARY]
2026 Table: phpbb_topics_track
2028 CREATE TABLE [phpbb_topics_track] (
2029 [user_id] [int] NOT NULL ,
2030 [topic_id] [int] NOT NULL ,
2031 [forum_id] [int] NOT NULL ,
2032 [mark_time] [int] NOT NULL
2036 ALTER TABLE [phpbb_topics_track] WITH NOCHECK ADD
2037 CONSTRAINT [PK_phpbb_topics_track] PRIMARY KEY CLUSTERED
2044 ALTER TABLE [phpbb_topics_track] WITH NOCHECK ADD
2045 CONSTRAINT [DF_phpbb_tmarki_user_id] DEFAULT (0) FOR [user_id],
2046 CONSTRAINT [DF_phpbb_tmarki_topic_id] DEFAULT (0) FOR [topic_id],
2047 CONSTRAINT [DF_phpbb_tmarki_forum_id] DEFAULT (0) FOR [forum_id],
2048 CONSTRAINT [DF_phpbb_tmarki_mark_time] DEFAULT (0) FOR [mark_time]
2051 CREATE INDEX [forum_id] ON [phpbb_topics_track]([forum_id]) ON [PRIMARY]
2056 Table: phpbb_topics_posted
2058 CREATE TABLE [phpbb_topics_posted] (
2059 [user_id] [int] NOT NULL ,
2060 [topic_id] [int] NOT NULL ,
2061 [topic_posted] [int] NOT NULL
2065 ALTER TABLE [phpbb_topics_posted] WITH NOCHECK ADD
2066 CONSTRAINT [PK_phpbb_topics_posted] PRIMARY KEY CLUSTERED
2073 ALTER TABLE [phpbb_topics_posted] WITH NOCHECK ADD
2074 CONSTRAINT [DF_phpbb_tposte_user_id] DEFAULT (0) FOR [user_id],
2075 CONSTRAINT [DF_phpbb_tposte_topic_id] DEFAULT (0) FOR [topic_id],
2076 CONSTRAINT [DF_phpbb_tposte_topic_posted] DEFAULT (0) FOR [topic_posted]
2081 Table: phpbb_topics_watch
2083 CREATE TABLE [phpbb_topics_watch] (
2084 [topic_id] [int] NOT NULL ,
2085 [user_id] [int] NOT NULL ,
2086 [notify_status] [int] NOT NULL
2090 ALTER TABLE [phpbb_topics_watch] WITH NOCHECK ADD
2091 CONSTRAINT [DF_phpbb_twatch_topic_id] DEFAULT (0) FOR [topic_id],
2092 CONSTRAINT [DF_phpbb_twatch_user_id] DEFAULT (0) FOR [user_id],
2093 CONSTRAINT [DF_phpbb_twatch_notify_status] DEFAULT (0) FOR [notify_status]
2096 CREATE INDEX [topic_id] ON [phpbb_topics_watch]([topic_id]) ON [PRIMARY]
2099 CREATE INDEX [user_id] ON [phpbb_topics_watch]([user_id]) ON [PRIMARY]
2102 CREATE INDEX [notify_status] ON [phpbb_topics_watch]([notify_status]) ON [PRIMARY]
2107 Table: phpbb_user_group
2109 CREATE TABLE [phpbb_user_group] (
2110 [group_id] [int] NOT NULL ,
2111 [user_id] [int] NOT NULL ,
2112 [group_leader] [int] NOT NULL ,
2113 [user_pending] [int] NULL
2117 ALTER TABLE [phpbb_user_group] WITH NOCHECK ADD
2118 CONSTRAINT [DF_phpbb_usersg_group_id] DEFAULT (0) FOR [group_id],
2119 CONSTRAINT [DF_phpbb_usersg_user_id] DEFAULT (0) FOR [user_id],
2120 CONSTRAINT [DF_phpbb_usersg_group_leader] DEFAULT (0) FOR [group_leader]
2123 CREATE INDEX [group_id] ON [phpbb_user_group]([group_id]) ON [PRIMARY]
2126 CREATE INDEX [user_id] ON [phpbb_user_group]([user_id]) ON [PRIMARY]
2129 CREATE INDEX [group_leader] ON [phpbb_user_group]([group_leader]) ON [PRIMARY]
2136 CREATE TABLE [phpbb_users] (
2137 [user_id] [int] IDENTITY (1, 1) NOT NULL ,
2138 [user_type] [int] NOT NULL ,
2139 [group_id] [int] NOT NULL ,
2140 [user_permissions] [text] NULL ,
2141 [user_perm_from] [int] NULL ,
2142 [user_ip] [varchar] (40) NOT NULL ,
2143 [user_regdate] [int] NOT NULL ,
2144 [username] [varchar] (255) NOT NULL ,
2145 [user_password] [varchar] (40) NOT NULL ,
2146 [user_passchg] [int] NULL ,
2147 [user_email] [varchar] (100) NOT NULL ,
2148 [user_email_hash] [float] NOT NULL ,
2149 [user_birthday] [varchar] (10) NULL ,
2150 [user_lastvisit] [int] NOT NULL ,
2151 [user_lastmark] [int] NOT NULL ,
2152 [user_lastpost_time] [int] NOT NULL ,
2153 [user_lastpage] [varchar] (200) NOT NULL ,
2154 [user_last_confirm_key] [varchar] (10) NULL ,
2155 [user_last_search] [int] NULL ,
2156 [user_warnings] [int] NULL ,
2157 [user_last_warning] [int] NULL ,
2158 [user_login_attempts] [int] NULL ,
2159 [user_posts] [int] NOT NULL ,
2160 [user_lang] [varchar] (30) NOT NULL ,
2161 [user_timezone] [float] NOT NULL ,
2162 [user_dst] [int] NOT NULL ,
2163 [user_dateformat] [varchar] (30) NOT NULL ,
2164 [user_style] [int] NOT NULL ,
2165 [user_rank] [int] NULL ,
2166 [user_colour] [varchar] (6) NOT NULL ,
2167 [user_new_privmsg] [int] NOT NULL ,
2168 [user_unread_privmsg] [int] NOT NULL ,
2169 [user_last_privmsg] [int] NOT NULL ,
2170 [user_message_rules] [int] NOT NULL ,
2171 [user_full_folder] [int] NOT NULL ,
2172 [user_emailtime] [int] NOT NULL ,
2173 [user_topic_show_days] [int] NOT NULL ,
2174 [user_topic_sortby_type] [varchar] (1) NOT NULL ,
2175 [user_topic_sortby_dir] [varchar] (1) NOT NULL ,
2176 [user_post_show_days] [int] NOT NULL ,
2177 [user_post_sortby_type] [varchar] (1) NOT NULL ,
2178 [user_post_sortby_dir] [varchar] (1) NOT NULL ,
2179 [user_notify] [int] NOT NULL ,
2180 [user_notify_pm] [int] NOT NULL ,
2181 [user_notify_type] [int] NOT NULL ,
2182 [user_allow_pm] [int] NOT NULL ,
2183 [user_allow_email] [int] NOT NULL ,
2184 [user_allow_viewonline] [int] NOT NULL ,
2185 [user_allow_viewemail] [int] NOT NULL ,
2186 [user_allow_massemail] [int] NOT NULL ,
2187 [user_options] [int] NOT NULL ,
2188 [user_avatar] [varchar] (255) NOT NULL ,
2189 [user_avatar_type] [int] NOT NULL ,
2190 [user_avatar_width] [int] NOT NULL ,
2191 [user_avatar_height] [int] NOT NULL ,
2192 [user_sig] [text] NULL ,
2193 [user_sig_bbcode_uid] [varchar] (5) NULL ,
2194 [user_sig_bbcode_bitfield] [int] NULL ,
2195 [user_from] [varchar] (100) NULL ,
2196 [user_icq] [varchar] (15) NULL ,
2197 [user_aim] [varchar] (255) NULL ,
2198 [user_yim] [varchar] (255) NULL ,
2199 [user_msnm] [varchar] (255) NULL ,
2200 [user_jabber] [varchar] (255) NULL ,
2201 [user_website] [varchar] (200) NULL ,
2202 [user_occ] [varchar] (255) NULL ,
2203 [user_interests] [varchar] (255) NULL ,
2204 [user_actkey] [varchar] (32) NOT NULL ,
2205 [user_newpasswd] [varchar] (32) NULL
2206 ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
2209 ALTER TABLE [phpbb_users] WITH NOCHECK ADD
2210 CONSTRAINT [PK_phpbb_users] PRIMARY KEY CLUSTERED
2216 ALTER TABLE [phpbb_users] WITH NOCHECK ADD
2217 CONSTRAINT [DF_phpbb_users__user_type] DEFAULT (0) FOR [user_type],
2218 CONSTRAINT [DF_phpbb_users__group_id] DEFAULT (3) FOR [group_id],
2219 CONSTRAINT [DF_phpbb_users__user_perm_from] DEFAULT (0) FOR [user_perm_from],
2220 CONSTRAINT [DF_phpbb_users__user_regdate] DEFAULT (0) FOR [user_regdate],
2221 CONSTRAINT [DF_phpbb_users__user_passchg] DEFAULT (0) FOR [user_passchg],
2222 CONSTRAINT [DF_phpbb_users__user_email_hash] DEFAULT (0) FOR [user_email_hash],
2223 CONSTRAINT [DF_phpbb_users__user_lastvisit] DEFAULT (0) FOR [user_lastvisit],
2224 CONSTRAINT [DF_phpbb_users__user_lastmark] DEFAULT (0) FOR [user_lastmark],
2225 CONSTRAINT [DF_phpbb_users__user_lastpost_time] DEFAULT (0) FOR [user_lastpost_time],
2226 CONSTRAINT [DF_phpbb_users__user_warnings] DEFAULT (0) FOR [user_warnings],
2227 CONSTRAINT [DF_phpbb_users__user_last_warning] DEFAULT (0) FOR [user_last_warning],
2228 CONSTRAINT [DF_phpbb_users__user_login_attempts] DEFAULT (0) FOR [user_login_attempts],
2229 CONSTRAINT [DF_phpbb_users__user_posts] DEFAULT (0) FOR [user_posts],
2230 CONSTRAINT [DF_phpbb_users__user_timezone] DEFAULT (0) FOR [user_timezone],
2231 CONSTRAINT [DF_phpbb_users__user_dst] DEFAULT (0) FOR [user_dst],
2232 CONSTRAINT [DF_phpbb_users__user_dateformat] DEFAULT ('d M Y H:i') FOR [user_dateformat],
2233 CONSTRAINT [DF_phpbb_users__user_style] DEFAULT (0) FOR [user_style],
2234 CONSTRAINT [DF_phpbb_users__user_rank] DEFAULT (0) FOR [user_rank],
2235 CONSTRAINT [DF_phpbb_users__user_new_privmsg] DEFAULT (0) FOR [user_new_privmsg],
2236 CONSTRAINT [DF_phpbb_users__user_unread_privmsg] DEFAULT (0) FOR [user_unread_privmsg],
2237 CONSTRAINT [DF_phpbb_users__user_last_privmsg] DEFAULT (0) FOR [user_last_privmsg],
2238 CONSTRAINT [DF_phpbb_users__user_message_rules] DEFAULT (0) FOR [user_message_rules],
2239 CONSTRAINT [DF_phpbb_users__user_full_folder] DEFAULT ((-3)) FOR [user_full_folder],
2240 CONSTRAINT [DF_phpbb_users__user_emailtime] DEFAULT (0) FOR [user_emailtime],
2241 CONSTRAINT [DF_phpbb_users__user_topic_sortby_type] DEFAULT ('t') FOR [user_topic_sortby_type],
2242 CONSTRAINT [DF_phpbb_users__user_topic_sortby_dir] DEFAULT ('d') FOR [user_topic_sortby_dir],
2243 CONSTRAINT [DF_phpbb_users__user_topic_show_days] DEFAULT (0) FOR [user_topic_show_days],
2244 CONSTRAINT [DF_phpbb_users__user_post_show_days] DEFAULT (0) FOR [user_post_show_days],
2245 CONSTRAINT [DF_phpbb_users__user_post_sortby_type] DEFAULT ('t') FOR [user_post_sortby_type],
2246 CONSTRAINT [DF_phpbb_users__user_post_sortby_dir] DEFAULT ('a') FOR [user_post_sortby_dir],
2247 CONSTRAINT [DF_phpbb_users__user_notify] DEFAULT (0) FOR [user_notify],
2248 CONSTRAINT [DF_phpbb_users__user_notify_pm] DEFAULT (1) FOR [user_notify_pm],
2249 CONSTRAINT [DF_phpbb_users__user_notify_type] DEFAULT (0) FOR [user_notify_type],
2250 CONSTRAINT [DF_phpbb_users__user_allow_pm] DEFAULT (1) FOR [user_allow_pm],
2251 CONSTRAINT [DF_phpbb_users__user_allow_email] DEFAULT (1) FOR [user_allow_email],
2252 CONSTRAINT [DF_phpbb_users__user_allow_viewonlin] DEFAULT (1) FOR [user_allow_viewonline],
2253 CONSTRAINT [DF_phpbb_users__user_allow_viewemail] DEFAULT (1) FOR [user_allow_viewemail],
2254 CONSTRAINT [DF_phpbb_users__user_allow_massemail] DEFAULT (1) FOR [user_allow_massemail],
2255 CONSTRAINT [DF_phpbb_users__user_options] DEFAULT (893) FOR [user_options],
2256 CONSTRAINT [DF_phpbb_users__user_avatar_type] DEFAULT (0) FOR [user_avatar_type],
2257 CONSTRAINT [DF_phpbb_users__user_avatar_width] DEFAULT (0) FOR [user_avatar_width],
2258 CONSTRAINT [DF_phpbb_users__user_avatar_height] DEFAULT (0) FOR [user_avatar_height],
2259 CONSTRAINT [DF_phpbb_users__user_sig_bbcode_bitf] DEFAULT (0) FOR [user_sig_bbcode_bitfield],
2260 CONSTRAINT [DF_phpbb_users__user_ip] DEFAULT ('') FOR [user_ip],
2261 CONSTRAINT [DF_phpbb_users__username] DEFAULT ('') FOR [username],
2262 CONSTRAINT [DF_phpbb_users__user_password] DEFAULT ('') FOR [user_password],
2263 CONSTRAINT [DF_phpbb_users__user_email] DEFAULT ('') FOR [user_email],
2264 CONSTRAINT [DF_phpbb_users__user_birthday] DEFAULT ('') FOR [user_birthday],
2265 CONSTRAINT [DF_phpbb_users__user_lastpage] DEFAULT ('') FOR [user_lastpage],
2266 CONSTRAINT [DF_phpbb_users__user_last_confirm_key] DEFAULT ('') FOR [user_last_confirm_key],
2267 CONSTRAINT [DF_phpbb_users__user_lang] DEFAULT ('') FOR [user_lang],
2268 CONSTRAINT [DF_phpbb_users__user_colour] DEFAULT ('') FOR [user_colour],
2269 CONSTRAINT [DF_phpbb_users__user_avatar] DEFAULT ('') FOR [user_avatar],
2270 CONSTRAINT [DF_phpbb_users__user_sig_bbcode_uid] DEFAULT ('') FOR [user_sig_bbcode_uid],
2271 CONSTRAINT [DF_phpbb_users__user_from] DEFAULT ('') FOR [user_from],
2272 CONSTRAINT [DF_phpbb_users__user_icq] DEFAULT ('') FOR [user_icq],
2273 CONSTRAINT [DF_phpbb_users__user_aim] DEFAULT ('') FOR [user_aim],
2274 CONSTRAINT [DF_phpbb_users__user_yim] DEFAULT ('') FOR [user_yim],
2275 CONSTRAINT [DF_phpbb_users__user_msnm] DEFAULT ('') FOR [user_msnm],
2276 CONSTRAINT [DF_phpbb_users__user_jabber] DEFAULT ('') FOR [user_jabber],
2277 CONSTRAINT [DF_phpbb_users__user_website] DEFAULT ('') FOR [user_website],
2278 CONSTRAINT [DF_phpbb_users__user_occ] DEFAULT ('') FOR [user_occ],
2279 CONSTRAINT [DF_phpbb_users__user_interests] DEFAULT ('') FOR [user_interests],
2280 CONSTRAINT [DF_phpbb_users__user_actkey] DEFAULT ('') FOR [user_actkey],
2281 CONSTRAINT [DF_phpbb_users__user_newpasswd] DEFAULT ('') FOR [user_newpasswd]
2284 CREATE INDEX [user_birthday] ON [phpbb_users]([user_birthday]) ON [PRIMARY]
2287 CREATE INDEX [user_email_hash] ON [phpbb_users]([user_email_hash]) ON [PRIMARY]
2290 CREATE INDEX [username] ON [phpbb_users]([username]) ON [PRIMARY]
2295 Table: phpbb_warnings
2297 CREATE TABLE [phpbb_warnings] (
2298 [warning_id] [int] IDENTITY (1, 1) NOT NULL ,
2299 [user_id] [int] NOT NULL ,
2300 [post_id] [int] NOT NULL ,
2301 [log_id] [int] NOT NULL ,
2302 [warning_time] [int] NOT NULL
2306 ALTER TABLE [phpbb_warnings] WITH NOCHECK ADD
2307 CONSTRAINT [PK_phpbb_warnings] PRIMARY KEY CLUSTERED
2313 ALTER TABLE [phpbb_warnings] WITH NOCHECK ADD
2314 CONSTRAINT [DF_phpbb_warnings__user_id] DEFAULT (0) FOR [user_id],
2315 CONSTRAINT [DF_phpbb_warnings__post_id] DEFAULT (0) FOR [post_id],
2316 CONSTRAINT [DF_phpbb_warnings__log_id] DEFAULT (0) FOR [log_id],
2317 CONSTRAINT [DF_phpbb_warnings__warning_time] DEFAULT (0) FOR [warning_time]
2324 CREATE TABLE [phpbb_words] (
2325 [word_id] [int] IDENTITY (1, 1) NOT NULL ,
2326 [word] [varchar] (100) NOT NULL ,
2327 [replacement] [varchar] (100) NOT NULL
2331 ALTER TABLE [phpbb_words] WITH NOCHECK ADD
2332 CONSTRAINT [PK_phpbb_words] PRIMARY KEY CLUSTERED
2342 CREATE TABLE [phpbb_zebra] (
2343 [user_id] [int] NOT NULL ,
2344 [zebra_id] [int] NOT NULL ,
2345 [friend] [int] NOT NULL ,
2346 [foe] [int] NOT NULL
2350 ALTER TABLE [phpbb_zebra] WITH NOCHECK ADD
2351 CONSTRAINT [DF_phpbb_zebra__user_id] DEFAULT (0) FOR [user_id],
2352 CONSTRAINT [DF_phpbb_zebra__zebra_id] DEFAULT (0) FOR [zebra_id],
2353 CONSTRAINT [DF_phpbb_zebra__friend] DEFAULT (0) FOR [friend],
2354 CONSTRAINT [DF_phpbb_zebra__foe] DEFAULT (0) FOR [foe]
2357 CREATE INDEX [user_id] ON [phpbb_zebra]([user_id]) ON [PRIMARY]
2360 CREATE INDEX [zebra_id] ON [phpbb_zebra]([zebra_id]) ON [PRIMARY]