diff options
Diffstat (limited to 'phpBB/install/schemas/mssql_schema.sql')
| -rw-r--r-- | phpBB/install/schemas/mssql_schema.sql | 2486 |
1 files changed, 1365 insertions, 1121 deletions
diff --git a/phpBB/install/schemas/mssql_schema.sql b/phpBB/install/schemas/mssql_schema.sql index cc1ae96937..4bad827c8e 100644 --- a/phpBB/install/schemas/mssql_schema.sql +++ b/phpBB/install/schemas/mssql_schema.sql @@ -9,7 +9,9 @@ $Id$ BEGIN TRANSACTION GO - +/* + Table: phpbb_attachments +*/ CREATE TABLE [phpbb_attachments] ( [attach_id] [int] IDENTITY (1, 1) NOT NULL , [post_msg_id] [int] NOT NULL , @@ -19,15 +21,55 @@ CREATE TABLE [phpbb_attachments] ( [physical_filename] [varchar] (255) NOT NULL , [real_filename] [varchar] (255) NOT NULL , [download_count] [int] NOT NULL , - [comment] [varchar] (255) NULL , + [comment] [text] , [extension] [varchar] (100) NULL , [mimetype] [varchar] (100) NULL , [filesize] [int] NOT NULL , [filetime] [int] NOT NULL , [thumbnail] [int] NOT NULL -) ON [PRIMARY] +) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] +GO + +ALTER TABLE [phpbb_attachments] WITH NOCHECK ADD + CONSTRAINT [PK_phpbb_attachments] PRIMARY KEY CLUSTERED + ( + [attach_id] + ) ON [PRIMARY] +GO + +ALTER TABLE [phpbb_attachments] WITH NOCHECK ADD + CONSTRAINT [DF_attach_post_msg_id] DEFAULT (0) FOR [post_msg_id], + CONSTRAINT [DF_attach_topic_id] DEFAULT (0) FOR [topic_id], + CONSTRAINT [DF_attach_in_message] DEFAULT (0) FOR [in_message], + CONSTRAINT [DF_attach_poster_id] DEFAULT (0) FOR [poster_id], + CONSTRAINT [DF_attach_download_count] DEFAULT (0) FOR [download_count], + CONSTRAINT [DF_attach_filesize] DEFAULT (0) FOR [filesize], + CONSTRAINT [DF_attach_filetime] DEFAULT (0) FOR [filetime], + CONSTRAINT [DF_attach_thumbnail] DEFAULT (0) FOR [thumbnail] +GO + +CREATE INDEX [filetime] ON [phpbb_attachments]([filetime]) ON [PRIMARY] +GO + +CREATE INDEX [post_msg_id] ON [phpbb_attachments]([post_msg_id]) ON [PRIMARY] +GO + +CREATE INDEX [topic_id] ON [phpbb_attachments]([topic_id]) ON [PRIMARY] GO +CREATE INDEX [poster_id] ON [phpbb_attachments]([poster_id]) ON [PRIMARY] +GO + +CREATE INDEX [physical_filename] ON [phpbb_attachments]([physical_filename]) ON [PRIMARY] +GO + +CREATE INDEX [filesize] ON [phpbb_attachments]([filesize]) ON [PRIMARY] +GO + + +/* + Table: phpbb_auth_groups +*/ CREATE TABLE [phpbb_auth_groups] ( [group_id] [int] NOT NULL , [forum_id] [int] NOT NULL , @@ -37,6 +79,23 @@ CREATE TABLE [phpbb_auth_groups] ( ) ON [PRIMARY] GO +ALTER TABLE [phpbb_auth_groups] WITH NOCHECK ADD + CONSTRAINT [DF_auth_g_group_id] DEFAULT (0) FOR [group_id], + CONSTRAINT [DF_auth_g_forum_id] DEFAULT (0) FOR [forum_id], + CONSTRAINT [DF_auth_g_auth_option_id] DEFAULT (0) FOR [auth_option_id], + CONSTRAINT [DF_auth_g_auth_setting] DEFAULT (0) FOR [auth_setting] +GO + +CREATE INDEX [group_id] ON [phpbb_auth_groups]([group_id]) ON [PRIMARY] +GO + +CREATE INDEX [auth_option_id] ON [phpbb_auth_groups]([auth_option_id]) ON [PRIMARY] +GO + + +/* + Table: phpbb_auth_options +*/ CREATE TABLE [phpbb_auth_options] ( [auth_option_id] [int] IDENTITY (1, 1) NOT NULL , [auth_option] [varchar] (20) NOT NULL , @@ -46,14 +105,52 @@ CREATE TABLE [phpbb_auth_options] ( ) ON [PRIMARY] GO +ALTER TABLE [phpbb_auth_options] WITH NOCHECK ADD + CONSTRAINT [PK_phpbb_auth_options] PRIMARY KEY CLUSTERED + ( + [auth_option_id] + ) ON [PRIMARY] +GO + +ALTER TABLE [phpbb_auth_options] WITH NOCHECK ADD + CONSTRAINT [DF_auth_o_is_global] DEFAULT (0) FOR [is_global], + CONSTRAINT [DF_auth_o_is_local] DEFAULT (0) FOR [is_local], + CONSTRAINT [DF_auth_o_founder_only] DEFAULT (0) FOR [founder_only] +GO + +CREATE INDEX [auth_option] ON [phpbb_auth_options]([auth_option]) ON [PRIMARY] +GO + + +/* + Table: phpbb_auth_roles +*/ CREATE TABLE [phpbb_auth_roles] ( [role_id] [int] IDENTITY (1, 1) NOT NULL , - [role_name] [varchar] (50) NOT NULL , + [role_name] [varchar] (255) NOT NULL , [role_type] [varchar] (10) NOT NULL , [role_group_ids] [varchar] (255) NOT NULL ) ON [PRIMARY] GO +ALTER TABLE [phpbb_auth_roles] WITH NOCHECK ADD + CONSTRAINT [PK_phpbb_auth_roles] PRIMARY KEY CLUSTERED + ( + [role_id] + ) ON [PRIMARY] +GO + +ALTER TABLE [phpbb_auth_roles] WITH NOCHECK ADD + CONSTRAINT [DF_auth_p_role_group_ids] DEFAULT ('') FOR [role_group_ids] +GO + +CREATE INDEX [role_type] ON [phpbb_auth_roles]([role_type]) ON [PRIMARY] +GO + + +/* + Table: phpbb_auth_roles_data +*/ CREATE TABLE [phpbb_auth_roles_data] ( [role_id] [int] NOT NULL , [auth_option_id] [int] NOT NULL , @@ -61,6 +158,24 @@ CREATE TABLE [phpbb_auth_roles_data] ( ) ON [PRIMARY] GO +ALTER TABLE [phpbb_auth_roles_data] WITH NOCHECK ADD + CONSTRAINT [PK_phpbb_auth_roles_data] PRIMARY KEY CLUSTERED + ( + [role_id], + [auth_option_id] + ) ON [PRIMARY] +GO + +ALTER TABLE [phpbb_auth_roles_data] WITH NOCHECK ADD + CONSTRAINT [DF_auth_d_role_id] DEFAULT (0) FOR [role_id], + CONSTRAINT [DF_auth_d_auth_option_id] DEFAULT (0) FOR [auth_option_id], + CONSTRAINT [DF_auth_d_auth_setting] DEFAULT (0) FOR [auth_setting] +GO + + +/* + Table: phpbb_auth_users +*/ CREATE TABLE [phpbb_auth_users] ( [user_id] [int] NOT NULL , [forum_id] [int] NOT NULL , @@ -70,32 +185,86 @@ CREATE TABLE [phpbb_auth_users] ( ) ON [PRIMARY] GO +ALTER TABLE [phpbb_auth_users] WITH NOCHECK ADD + CONSTRAINT [DF_auth_u_user_id] DEFAULT (0) FOR [user_id], + CONSTRAINT [DF_auth_u_forum_id] DEFAULT (0) FOR [forum_id], + CONSTRAINT [DF_auth_u_auth_option_id] DEFAULT (0) FOR [auth_option_id], + CONSTRAINT [DF_auth_u_auth_setting] DEFAULT (0) FOR [auth_setting] +GO + +CREATE INDEX [user_id] ON [phpbb_auth_users]([user_id]) ON [PRIMARY] +GO + +CREATE INDEX [auth_option_id] ON [phpbb_auth_users]([auth_option_id]) ON [PRIMARY] +GO + + +/* + Table: phpbb_banlist +*/ CREATE TABLE [phpbb_banlist] ( [ban_id] [int] IDENTITY (1, 1) NOT NULL , [ban_userid] [int] NOT NULL , [ban_ip] [varchar] (40) NOT NULL , - [ban_email] [varchar] (50) NOT NULL , + [ban_email] [varchar] (100) NOT NULL , [ban_start] [int] NOT NULL , [ban_end] [int] NOT NULL , [ban_exclude] [int] NOT NULL , - [ban_reason] [varchar] (255) NOT NULL , - [ban_give_reason] [varchar] (255) NOT NULL -) ON [PRIMARY] + [ban_reason] [text] , + [ban_give_reason] [text] +) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO +ALTER TABLE [phpbb_banlist] WITH NOCHECK ADD + CONSTRAINT [PK_phpbb_banlist] PRIMARY KEY CLUSTERED + ( + [ban_id] + ) ON [PRIMARY] +GO + +ALTER TABLE [phpbb_banlist] WITH NOCHECK ADD + CONSTRAINT [DF_banlis_ban_userid] DEFAULT (0) FOR [ban_userid], + CONSTRAINT [DF_banlis_ban_start] DEFAULT (0) FOR [ban_start], + CONSTRAINT [DF_banlis_ban_end] DEFAULT (0) FOR [ban_end], + CONSTRAINT [DF_banlis_ban_exclude] DEFAULT (0) FOR [ban_exclude] +GO + + +/* + Table: phpbb_bbcodes +*/ CREATE TABLE [phpbb_bbcodes] ( [bbcode_id] [int] NOT NULL , [bbcode_tag] [varchar] (16) NOT NULL , [display_on_posting] [int] NOT NULL , [bbcode_match] [varchar] (255) NOT NULL , - [bbcode_tpl] [text] NOT NULL , + [bbcode_tpl] [text] , [first_pass_match] [varchar] (255) NOT NULL , [first_pass_replace] [varchar] (255) NOT NULL , [second_pass_match] [varchar] (255) NOT NULL , - [second_pass_replace] [text] NOT NULL + [second_pass_replace] [text] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO +ALTER TABLE [phpbb_bbcodes] WITH NOCHECK ADD + CONSTRAINT [PK_phpbb_bbcodes] PRIMARY KEY CLUSTERED + ( + [bbcode_id] + ) ON [PRIMARY] +GO + +ALTER TABLE [phpbb_bbcodes] WITH NOCHECK ADD + CONSTRAINT [DF_bbcode_bbcode_id] DEFAULT (0) FOR [bbcode_id], + CONSTRAINT [DF_bbcode_display_on_posting] DEFAULT (0) FOR [display_on_posting] +GO + +CREATE INDEX [display_on_posting] ON [phpbb_bbcodes]([display_on_posting]) ON [PRIMARY] +GO + + +/* + Table: phpbb_bookmarks +*/ CREATE TABLE [phpbb_bookmarks] ( [topic_id] [int] NOT NULL , [user_id] [int] NOT NULL , @@ -103,23 +272,73 @@ CREATE TABLE [phpbb_bookmarks] ( ) ON [PRIMARY] GO +ALTER TABLE [phpbb_bookmarks] WITH NOCHECK ADD + CONSTRAINT [DF_bookma_topic_id] DEFAULT (0) FOR [topic_id], + CONSTRAINT [DF_bookma_user_id] DEFAULT (0) FOR [user_id], + CONSTRAINT [DF_bookma_order_id] DEFAULT (0) FOR [order_id] +GO + +CREATE INDEX [order_id] ON [phpbb_bookmarks]([order_id]) ON [PRIMARY] +GO + +CREATE INDEX [topic_user_id] ON [phpbb_bookmarks]([topic_id], [user_id]) ON [PRIMARY] +GO + + +/* + Table: phpbb_bots +*/ CREATE TABLE [phpbb_bots] ( [bot_id] [int] IDENTITY (1, 1) NOT NULL , [bot_active] [int] NOT NULL , - [bot_name] [varchar] (255) NOT NULL , + [bot_name] [text] , [user_id] [int] NOT NULL , [bot_agent] [varchar] (255) NOT NULL , [bot_ip] [varchar] (255) NOT NULL -) ON [PRIMARY] +) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] +GO + +ALTER TABLE [phpbb_bots] WITH NOCHECK ADD + CONSTRAINT [PK_phpbb_bots] PRIMARY KEY CLUSTERED + ( + [bot_id] + ) ON [PRIMARY] GO +ALTER TABLE [phpbb_bots] WITH NOCHECK ADD + CONSTRAINT [DF_bots___bot_active] DEFAULT (1) FOR [bot_active], + CONSTRAINT [DF_bots___user_id] DEFAULT (0) FOR [user_id] +GO + +CREATE INDEX [bot_active] ON [phpbb_bots]([bot_active]) ON [PRIMARY] +GO + + +/* + Table: phpbb_cache +*/ CREATE TABLE [phpbb_cache] ( [var_name] [varchar] (255) NOT NULL , [var_expires] [int] NOT NULL , - [var_data] [text] NOT NULL + [var_data] [text] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO +ALTER TABLE [phpbb_cache] WITH NOCHECK ADD + CONSTRAINT [PK_phpbb_cache] PRIMARY KEY CLUSTERED + ( + [var_name] + ) ON [PRIMARY] +GO + +ALTER TABLE [phpbb_cache] WITH NOCHECK ADD + CONSTRAINT [DF_cache__var_expires] DEFAULT (0) FOR [var_expires] +GO + + +/* + Table: phpbb_config +*/ CREATE TABLE [phpbb_config] ( [config_name] [varchar] (255) NOT NULL , [config_value] [varchar] (255) NOT NULL , @@ -127,6 +346,24 @@ CREATE TABLE [phpbb_config] ( ) ON [PRIMARY] GO +ALTER TABLE [phpbb_config] WITH NOCHECK ADD + CONSTRAINT [PK_phpbb_config] PRIMARY KEY CLUSTERED + ( + [config_name] + ) ON [PRIMARY] +GO + +ALTER TABLE [phpbb_config] WITH NOCHECK ADD + CONSTRAINT [DF_config_is_dynamic] DEFAULT (0) FOR [is_dynamic] +GO + +CREATE INDEX [is_dynamic] ON [phpbb_config]([is_dynamic]) ON [PRIMARY] +GO + + +/* + Table: phpbb_confirm +*/ CREATE TABLE [phpbb_confirm] ( [confirm_id] [varchar] (32) NOT NULL , [session_id] [varchar] (32) NOT NULL , @@ -135,36 +372,103 @@ CREATE TABLE [phpbb_confirm] ( ) ON [PRIMARY] GO +ALTER TABLE [phpbb_confirm] WITH NOCHECK ADD + CONSTRAINT [PK_phpbb_confirm] PRIMARY KEY CLUSTERED + ( + [session_id], + [confirm_id] + ) ON [PRIMARY] +GO + +ALTER TABLE [phpbb_confirm] WITH NOCHECK ADD + CONSTRAINT [DF_confirm_confirm_type] DEFAULT (0) FOR [confirm_type] +GO + + +/* + Table: phpbb_disallow +*/ CREATE TABLE [phpbb_disallow] ( [disallow_id] [int] IDENTITY (1, 1) NOT NULL , - [disallow_username] [varchar] (30) NOT NULL + [disallow_username] [varchar] (255) NOT NULL ) ON [PRIMARY] GO +ALTER TABLE [phpbb_disallow] WITH NOCHECK ADD + CONSTRAINT [PK_phpbb_disallow] PRIMARY KEY CLUSTERED + ( + [disallow_id] + ) ON [PRIMARY] +GO + + +/* + Table: phpbb_drafts +*/ CREATE TABLE [phpbb_drafts] ( [draft_id] [int] IDENTITY (1, 1) NOT NULL , [user_id] [int] NOT NULL , [topic_id] [int] NOT NULL , [forum_id] [int] NOT NULL , [save_time] [int] NOT NULL , - [draft_subject] [varchar] (60) NULL , - [draft_message] [text] NOT NULL + [draft_subject] [text] , + [draft_message] [text] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO +ALTER TABLE [phpbb_drafts] WITH NOCHECK ADD + CONSTRAINT [PK_phpbb_drafts] PRIMARY KEY CLUSTERED + ( + [draft_id] + ) ON [PRIMARY] +GO + +ALTER TABLE [phpbb_drafts] WITH NOCHECK ADD + CONSTRAINT [DF_drafts_user_id] DEFAULT (0) FOR [user_id], + CONSTRAINT [DF_drafts_topic_id] DEFAULT (0) FOR [topic_id], + CONSTRAINT [DF_drafts_forum_id] DEFAULT (0) FOR [forum_id], + CONSTRAINT [DF_drafts_save_time] DEFAULT (0) FOR [save_time] +GO + +CREATE INDEX [save_time] ON [phpbb_drafts]([save_time]) ON [PRIMARY] +GO + + +/* + Table: phpbb_extension_groups +*/ CREATE TABLE [phpbb_extension_groups] ( [group_id] [int] IDENTITY (1, 1) NOT NULL , - [group_name] [varchar] (20) NOT NULL , + [group_name] [varchar] (255) NOT NULL , [cat_id] [int] NOT NULL , [allow_group] [int] NOT NULL , [download_mode] [int] NOT NULL , - [upload_icon] [varchar] (100) NOT NULL , + [upload_icon] [varchar] (255) NOT NULL , [max_filesize] [int] NOT NULL , - [allowed_forums] [text] NOT NULL , + [allowed_forums] [text] , [allow_in_pm] [int] NOT NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO +ALTER TABLE [phpbb_extension_groups] WITH NOCHECK ADD + CONSTRAINT [PK_phpbb_extension_groups] PRIMARY KEY CLUSTERED + ( + [group_id] + ) ON [PRIMARY] +GO + +ALTER TABLE [phpbb_extension_groups] WITH NOCHECK ADD + CONSTRAINT [DF_extens_cat_id] DEFAULT (0) FOR [cat_id], + CONSTRAINT [DF_extens_allow_group] DEFAULT (0) FOR [allow_group], + CONSTRAINT [DF_extens_download_mode] DEFAULT (1) FOR [download_mode], + CONSTRAINT [DF_extens_max_filesize] DEFAULT (0) FOR [max_filesize], + CONSTRAINT [DF_extens_allow_in_pm] DEFAULT (0) FOR [allow_in_pm] +GO + + +/* + Table: phpbb_extensions +*/ CREATE TABLE [phpbb_extensions] ( [extension_id] [int] IDENTITY (1, 1) NOT NULL , [group_id] [int] NOT NULL , @@ -172,29 +476,37 @@ CREATE TABLE [phpbb_extensions] ( ) ON [PRIMARY] GO -CREATE TABLE [phpbb_forum_access] ( - [forum_id] [int] NOT NULL , - [user_id] [int] NOT NULL , - [session_id] [varchar] (32) NOT NULL -) ON [PRIMARY] +ALTER TABLE [phpbb_extensions] WITH NOCHECK ADD + CONSTRAINT [PK_phpbb_extensions] PRIMARY KEY CLUSTERED + ( + [extension_id] + ) ON [PRIMARY] GO +ALTER TABLE [phpbb_extensions] WITH NOCHECK ADD + CONSTRAINT [DF_extens_group_id] DEFAULT (0) FOR [group_id] +GO + + +/* + Table: phpbb_forums +*/ CREATE TABLE [phpbb_forums] ( [forum_id] [int] IDENTITY (1, 1) NOT NULL , [parent_id] [int] NOT NULL , [left_id] [int] NOT NULL , [right_id] [int] NOT NULL , [forum_parents] [text] NULL , - [forum_name] [varchar] (150) NOT NULL , - [forum_desc] [text] NULL , + [forum_name] [text] , + [forum_desc] [text] , [forum_desc_bitfield] [int] NOT NULL , [forum_desc_uid] [varchar] (5) NOT NULL , - [forum_link] [varchar] (200) NOT NULL , - [forum_password] [varchar] (32) NOT NULL , + [forum_link] [varchar] (255) NOT NULL , + [forum_password] [varchar] (40) NOT NULL , [forum_style] [int] NULL , - [forum_image] [varchar] (50) NOT NULL , - [forum_rules] [text] NOT NULL , - [forum_rules_link] [varchar] (200) NOT NULL , + [forum_image] [varchar] (255) NOT NULL , + [forum_rules] [text] , + [forum_rules_link] [varchar] (255) NOT NULL , [forum_rules_bitfield] [int] NOT NULL , [forum_rules_uid] [varchar] (5) NOT NULL , [forum_topics_per_page] [int] NOT NULL , @@ -206,7 +518,7 @@ CREATE TABLE [phpbb_forums] ( [forum_last_post_id] [int] NOT NULL , [forum_last_poster_id] [int] NOT NULL , [forum_last_post_time] [int] NOT NULL , - [forum_last_poster_name] [varchar] (30) NULL , + [forum_last_poster_name] [varchar] (255) NULL , [forum_flags] [int] NOT NULL , [display_on_index] [int] NOT NULL , [enable_indexing] [int] NOT NULL , @@ -219,6 +531,73 @@ CREATE TABLE [phpbb_forums] ( ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO +ALTER TABLE [phpbb_forums] WITH NOCHECK ADD + CONSTRAINT [PK_phpbb_forums] PRIMARY KEY CLUSTERED + ( + [forum_id] + ) ON [PRIMARY] +GO + +ALTER TABLE [phpbb_forums] WITH NOCHECK ADD + CONSTRAINT [DF_forums_parent_id] DEFAULT (0) FOR [parent_id], + CONSTRAINT [DF_forums_left_id] DEFAULT (0) FOR [left_id], + CONSTRAINT [DF_forums_right_id] DEFAULT (0) FOR [right_id], + CONSTRAINT [DF_forums_desc_bitfield] DEFAULT (0) FOR [forum_desc_bitfield], + CONSTRAINT [DF_forums_rules_bitfield] DEFAULT (0) FOR [forum_rules_bitfield], + CONSTRAINT [DF_forums_topics_per_page] DEFAULT (0) FOR [forum_topics_per_page], + CONSTRAINT [DF_forums_forum_type] DEFAULT (0) FOR [forum_type], + CONSTRAINT [DF_forums_forum_status] DEFAULT (0) FOR [forum_status], + CONSTRAINT [DF_forums_forum_posts] DEFAULT (0) FOR [forum_posts], + CONSTRAINT [DF_forums_forum_topics] DEFAULT (0) FOR [forum_topics], + CONSTRAINT [DF_forums_forum_topics_real] DEFAULT (0) FOR [forum_topics_real], + CONSTRAINT [DF_forums_forum_last_post_id] DEFAULT (0) FOR [forum_last_post_id], + CONSTRAINT [DF_forums_forum_last_poster_id] DEFAULT (0) FOR [forum_last_poster_id], + CONSTRAINT [DF_forums_forum_last_post_time] DEFAULT (0) FOR [forum_last_post_time], + CONSTRAINT [DF_forums_forum_flags] DEFAULT (0) FOR [forum_flags], + CONSTRAINT [DF_forums_display_on_index] DEFAULT (1) FOR [display_on_index], + CONSTRAINT [DF_forums_enable_indexing] DEFAULT (1) FOR [enable_indexing], + CONSTRAINT [DF_forums_enable_icons] DEFAULT (1) FOR [enable_icons], + CONSTRAINT [DF_forums_enable_prune] DEFAULT (0) FOR [enable_prune], + CONSTRAINT [DF_forums_prune_days] DEFAULT (0) FOR [prune_days], + CONSTRAINT [DF_forums_prune_viewed] DEFAULT (0) FOR [prune_viewed], + CONSTRAINT [DF_forums_prune_freq] DEFAULT (0) FOR [prune_freq] +GO + +CREATE INDEX [left_right_id] ON [phpbb_forums]([left_id], [right_id]) ON [PRIMARY] +GO + +CREATE INDEX [forum_last_post_id] ON [phpbb_forums]([forum_last_post_id]) ON [PRIMARY] +GO + + +/* + Table: phpbb_forum_access +*/ +CREATE TABLE [phpbb_forum_access] ( + [forum_id] [int] NOT NULL , + [user_id] [int] NOT NULL , + [session_id] [varchar] (32) NOT NULL +) ON [PRIMARY] +GO + +ALTER TABLE [phpbb_forum_access] WITH NOCHECK ADD + CONSTRAINT [PK_phpbb_forum_access] PRIMARY KEY CLUSTERED + ( + [forum_id], + [user_id], + [session_id] + ) ON [PRIMARY] +GO + +ALTER TABLE [phpbb_forum_access] WITH NOCHECK ADD + CONSTRAINT [DF_forum__forum_id] DEFAULT (0) FOR [forum_id], + CONSTRAINT [DF_forum__user_id] DEFAULT (0) FOR [user_id] +GO + + +/* + Table: phpbb_forums_marking +*/ CREATE TABLE [phpbb_forums_marking] ( [user_id] [int] NOT NULL , [forum_id] [int] NOT NULL , @@ -226,6 +605,24 @@ CREATE TABLE [phpbb_forums_marking] ( ) ON [PRIMARY] GO +ALTER TABLE [phpbb_forums_marking] WITH NOCHECK ADD + CONSTRAINT [PK_phpbb_forums_marking] PRIMARY KEY CLUSTERED + ( + [user_id], + [forum_id] + ) ON [PRIMARY] +GO + +ALTER TABLE [phpbb_forums_marking] WITH NOCHECK ADD + CONSTRAINT [DF_forumm_user_id] DEFAULT (0) FOR [user_id], + CONSTRAINT [DF_forumm_forum_id] DEFAULT (0) FOR [forum_id], + CONSTRAINT [DF_forumm_mark_time] DEFAULT (0) FOR [mark_time] +GO + + +/* + Table: phpbb_forums_watch +*/ CREATE TABLE [phpbb_forums_watch] ( [forum_id] [int] NOT NULL , [user_id] [int] NOT NULL , @@ -233,15 +630,34 @@ CREATE TABLE [phpbb_forums_watch] ( ) ON [PRIMARY] GO +ALTER TABLE [phpbb_forums_watch] WITH NOCHECK ADD + CONSTRAINT [DF_forumw_forum_id] DEFAULT (0) FOR [forum_id], + CONSTRAINT [DF_forumw_user_id] DEFAULT (0) FOR [user_id], + CONSTRAINT [DF_forumw_notify_status] DEFAULT (0) FOR [notify_status] +GO + +CREATE INDEX [forum_id] ON [phpbb_forums_watch]([forum_id]) ON [PRIMARY] +GO + +CREATE INDEX [user_id] ON [phpbb_forums_watch]([user_id]) ON [PRIMARY] +GO + +CREATE INDEX [notify_status] ON [phpbb_forums_watch]([notify_status]) ON [PRIMARY] +GO + + +/* + Table: phpbb_groups +*/ CREATE TABLE [phpbb_groups] ( [group_id] [int] IDENTITY (1, 1) NOT NULL , [group_type] [int] NOT NULL , - [group_name] [varchar] (40) NOT NULL , - [group_desc] [text] NULL , + [group_name] [varchar] (255) NOT NULL , + [group_desc] [text] , [group_desc_bitfield] [int] NOT NULL , [group_desc_uid] [varchar] (5) NOT NULL , [group_display] [int] NOT NULL , - [group_avatar] [varchar] (100) NOT NULL , + [group_avatar] [varchar] (255) NOT NULL , [group_avatar_type] [int] NOT NULL , [group_avatar_width] [int] NOT NULL , [group_avatar_height] [int] NOT NULL , @@ -252,12 +668,41 @@ CREATE TABLE [phpbb_groups] ( [group_message_limit] [int] NOT NULL , [group_chgpass] [int] NOT NULL , [group_legend] [int] NOT NULL -) ON [PRIMARY] +) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] +GO + +ALTER TABLE [phpbb_groups] WITH NOCHECK ADD + CONSTRAINT [PK_phpbb_groups] PRIMARY KEY CLUSTERED + ( + [group_id] + ) ON [PRIMARY] +GO + +ALTER TABLE [phpbb_groups] WITH NOCHECK ADD + CONSTRAINT [DF_groups_group_type] DEFAULT (1) FOR [group_type], + CONSTRAINT [DF_groups_group_display] DEFAULT (0) FOR [group_display], + CONSTRAINT [DF_groups_group_desc_bitfield] DEFAULT (0) FOR [group_desc_bitfield], + CONSTRAINT [DF_groups_group_avatar_type] DEFAULT (0) FOR [group_avatar_type], + CONSTRAINT [DF_groups_group_avatar_width] DEFAULT (0) FOR [group_avatar_width], + CONSTRAINT [DF_groups_group_avatar_height] DEFAULT (0) FOR [group_avatar_height], + CONSTRAINT [DF_groups_group_rank] DEFAULT ((-1)) FOR [group_rank], + CONSTRAINT [DF_groups_group_sig_chars] DEFAULT (0) FOR [group_sig_chars], + CONSTRAINT [DF_groups_group_receive_pm] DEFAULT (0) FOR [group_receive_pm], + CONSTRAINT [DF_groups_group_message_limit] DEFAULT (0) FOR [group_message_limit], + CONSTRAINT [DF_groups_group_chgpass] DEFAULT (0) FOR [group_chgpass], + CONSTRAINT [DF_groups_group_legend] DEFAULT (1) FOR [group_legend] GO +CREATE INDEX [group_legend] ON [phpbb_groups]([group_legend]) ON [PRIMARY] +GO + + +/* + Table: phpbb_icons +*/ CREATE TABLE [phpbb_icons] ( [icons_id] [int] IDENTITY (1, 1) NOT NULL , - [icons_url] [varchar] (50) NULL , + [icons_url] [varchar] (255) NULL , [icons_width] [int] NOT NULL , [icons_height] [int] NOT NULL , [icons_order] [int] NOT NULL , @@ -265,16 +710,45 @@ CREATE TABLE [phpbb_icons] ( ) ON [PRIMARY] GO +ALTER TABLE [phpbb_icons] WITH NOCHECK ADD + CONSTRAINT [PK_phpbb_icons] PRIMARY KEY CLUSTERED + ( + [icons_id] + ) ON [PRIMARY] +GO + +ALTER TABLE [phpbb_icons] WITH NOCHECK ADD + CONSTRAINT [DF_icons__icons_width] DEFAULT (0) FOR [icons_width], + CONSTRAINT [DF_icons__icons_height] DEFAULT (0) FOR [icons_height], + CONSTRAINT [DF_icons__icons_order] DEFAULT (0) FOR [icons_order], + CONSTRAINT [DF_icons__display_on_posting] DEFAULT (1) FOR [display_on_posting] +GO + + +/* + Table: phpbb_lang +*/ CREATE TABLE [phpbb_lang] ( [lang_id] [int] IDENTITY (1, 1) NOT NULL , [lang_iso] [varchar] (5) NOT NULL , [lang_dir] [varchar] (30) NOT NULL , - [lang_english_name] [varchar] (30) NULL , - [lang_local_name] [varchar] (100) NULL , - [lang_author] [varchar] (100) NULL + [lang_english_name] [varchar] (100) NULL , + [lang_local_name] [varchar] (255) NULL , + [lang_author] [varchar] (255) NULL ) ON [PRIMARY] GO +ALTER TABLE [phpbb_lang] WITH NOCHECK ADD + CONSTRAINT [PK_phpbb_lang] PRIMARY KEY CLUSTERED + ( + [lang_id] + ) ON [PRIMARY] +GO + + +/* + Table: phpbb_log +*/ CREATE TABLE [phpbb_log] ( [log_id] [int] IDENTITY (1, 1) NOT NULL , [log_type] [int] NOT NULL , @@ -284,44 +758,134 @@ CREATE TABLE [phpbb_log] ( [reportee_id] [int] NOT NULL , [log_ip] [varchar] (40) NOT NULL , [log_time] [int] NOT NULL , - [log_operation] [text] NULL , - [log_data] [text] NULL + [log_operation] [text] , + [log_data] [text] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO +ALTER TABLE [phpbb_log] WITH NOCHECK ADD + CONSTRAINT [PK_phpbb_log] PRIMARY KEY CLUSTERED + ( + [log_id] + ) ON [PRIMARY] +GO + +ALTER TABLE [phpbb_log] WITH NOCHECK ADD + CONSTRAINT [DF_log____log_type] DEFAULT (0) FOR [log_type], + CONSTRAINT [DF_log____user_id] DEFAULT (0) FOR [user_id], + CONSTRAINT [DF_log____forum_id] DEFAULT (0) FOR [forum_id], + CONSTRAINT [DF_log____topic_id] DEFAULT (0) FOR [topic_id], + CONSTRAINT [DF_log____reportee_id] DEFAULT (0) FOR [reportee_id], + CONSTRAINT [DF_log____log_time] DEFAULT (0) FOR [log_time] +GO + +CREATE INDEX [log_type] ON [phpbb_log]([log_type]) ON [PRIMARY] +GO + +CREATE INDEX [forum_id] ON [phpbb_log]([forum_id]) ON [PRIMARY] +GO + +CREATE INDEX [topic_id] ON [phpbb_log]([topic_id]) ON [PRIMARY] +GO + +CREATE INDEX [reportee_id] ON [phpbb_log]([reportee_id]) ON [PRIMARY] +GO + +CREATE INDEX [user_id] ON [phpbb_log]([user_id]) ON [PRIMARY] +GO + + +/* + Table: phpbb_moderator_cache +*/ CREATE TABLE [phpbb_moderator_cache] ( [forum_id] [int] NOT NULL , [user_id] [int] NOT NULL , - [username] [varchar] (30) NOT NULL , + [username] [varchar] (255) NOT NULL , [group_id] [int] NOT NULL , - [groupname] [varchar] (30) NOT NULL , + [group_name] [varchar] (255) NOT NULL , [display_on_index] [int] NOT NULL ) ON [PRIMARY] GO +ALTER TABLE [phpbb_moderator_cache] WITH NOCHECK ADD + CONSTRAINT [DF_modera_forum_id] DEFAULT (0) FOR [forum_id], + CONSTRAINT [DF_modera_user_id] DEFAULT (0) FOR [user_id], + CONSTRAINT [DF_modera_group_id] DEFAULT (0) FOR [group_id], + CONSTRAINT [DF_modera_display_on_index] DEFAULT (1) FOR [display_on_index] +GO + +CREATE INDEX [display_on_index] ON [phpbb_moderator_cache]([display_on_index]) ON [PRIMARY] +GO + +CREATE INDEX [forum_id] ON [phpbb_moderator_cache]([forum_id]) ON [PRIMARY] +GO + + +/* + Table: phpbb_modules +*/ CREATE TABLE [phpbb_modules] ( [module_id] [int] IDENTITY (1, 1) NOT NULL , [module_enabled] [int] NOT NULL , [module_display] [int] NOT NULL , - [module_name] [varchar] (20) NOT NULL , - [module_class] [varchar] (4) NOT NULL , + [module_name] [varchar] (255) NOT NULL , + [module_class] [varchar] (10) NOT NULL , [parent_id] [int] NOT NULL , [left_id] [int] NOT NULL , [right_id] [int] NOT NULL , - [module_langname] [varchar] (50) NOT NULL , + [module_langname] [varchar] (255) NOT NULL , [module_mode] [varchar] (255) NOT NULL , [module_auth] [varchar] (255) NOT NULL ) ON [PRIMARY] GO +ALTER TABLE [phpbb_modules] WITH NOCHECK ADD + CONSTRAINT [PK_phpbb_modules] PRIMARY KEY CLUSTERED + ( + [module_id] + ) ON [PRIMARY] +GO + +ALTER TABLE [phpbb_modules] WITH NOCHECK ADD + CONSTRAINT [DF_module_module_enabled] DEFAULT (1) FOR [module_enabled], + CONSTRAINT [DF_module_module_display] DEFAULT (1) FOR [module_display] +GO + +CREATE INDEX [module_enabled] ON [phpbb_modules]([module_enabled]) ON [PRIMARY] +GO + +CREATE INDEX [module_left_right_id] ON [phpbb_modules]([left_id], [right_id]) ON [PRIMARY] +GO + + +/* + Table: phpbb_poll_results +*/ CREATE TABLE [phpbb_poll_results] ( [poll_option_id] [int] NOT NULL , [topic_id] [int] NOT NULL , - [poll_option_text] [varchar] (255) NOT NULL , + [poll_option_text] [text] , [poll_option_total] [int] NOT NULL -) ON [PRIMARY] +) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO +ALTER TABLE [phpbb_poll_results] WITH NOCHECK ADD + CONSTRAINT [DF_poll_r_poll_option_id] DEFAULT (0) FOR [poll_option_id], + CONSTRAINT [DF_poll_r_topic_id] DEFAULT (0) FOR [topic_id], + CONSTRAINT [DF_poll_r_poll_option_total] DEFAULT (0) FOR [poll_option_total] +GO + +CREATE INDEX [poll_option_id] ON [phpbb_poll_results]([poll_option_id]) ON [PRIMARY] +GO + +CREATE INDEX [topic_id] ON [phpbb_poll_results]([topic_id]) ON [PRIMARY] +GO + + +/* + Table: phpbb_poll_voters +*/ CREATE TABLE [phpbb_poll_voters] ( [topic_id] [int] NOT NULL , [poll_option_id] [int] NOT NULL , @@ -330,6 +894,25 @@ CREATE TABLE [phpbb_poll_voters] ( ) ON [PRIMARY] GO +ALTER TABLE [phpbb_poll_voters] WITH NOCHECK ADD + CONSTRAINT [DF_poll_v_topic_id] DEFAULT (0) FOR [topic_id], + CONSTRAINT [DF_poll_v_poll_option_id] DEFAULT (0) FOR [poll_option_id], + CONSTRAINT [DF_poll_v_vote_user_id] DEFAULT (0) FOR [vote_user_id] +GO + +CREATE INDEX [topic_id] ON [phpbb_poll_voters]([topic_id]) ON [PRIMARY] +GO + +CREATE INDEX [vote_user_id] ON [phpbb_poll_voters]([vote_user_id]) ON [PRIMARY] +GO + +CREATE INDEX [vote_user_ip] ON [phpbb_poll_voters]([vote_user_ip]) ON [PRIMARY] +GO + + +/* + Table: phpbb_posts +*/ CREATE TABLE [phpbb_posts] ( [post_id] [int] IDENTITY (1, 1) NOT NULL , [topic_id] [int] NOT NULL , @@ -344,22 +927,72 @@ CREATE TABLE [phpbb_posts] ( [enable_smilies] [int] NOT NULL , [enable_magic_url] [int] NOT NULL , [enable_sig] [int] NOT NULL , - [post_username] [varchar] (30) NULL , - [post_subject] [varchar] (60) NULL , - [post_text] [text] NULL , + [post_username] [varchar] (255) NULL , + [post_subject] [text] , + [post_text] [text] , [post_checksum] [varchar] (32) NOT NULL , [post_encoding] [varchar] (20) NOT NULL , [post_attachment] [int] NOT NULL , [bbcode_bitfield] [int] NOT NULL , [bbcode_uid] [varchar] (5) NOT NULL , [post_edit_time] [int] NOT NULL , - [post_edit_reason] [varchar] (100) NULL , + [post_edit_reason] [text] , [post_edit_user] [int] NOT NULL , [post_edit_count] [int] NOT NULL , [post_edit_locked] [int] NOT NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO +ALTER TABLE [phpbb_posts] WITH NOCHECK ADD + CONSTRAINT [PK_phpbb_posts] PRIMARY KEY CLUSTERED + ( + [post_id] + ) ON [PRIMARY] +GO + +ALTER TABLE [phpbb_posts] WITH NOCHECK ADD + CONSTRAINT [DF_posts__topic_id] DEFAULT (0) FOR [topic_id], + CONSTRAINT [DF_posts__forum_id] DEFAULT (0) FOR [forum_id], + CONSTRAINT [DF_posts__poster_id] DEFAULT (0) FOR [poster_id], + CONSTRAINT [DF_posts__icon_id] DEFAULT (1) FOR [icon_id], + CONSTRAINT [DF_posts__post_time] DEFAULT (0) FOR [post_time], + CONSTRAINT [DF_posts__post_approved] DEFAULT (1) FOR [post_approved], + CONSTRAINT [DF_posts__post_reported] DEFAULT (0) FOR [post_reported], + CONSTRAINT [DF_posts__enable_bbcode] DEFAULT (1) FOR [enable_bbcode], + CONSTRAINT [DF_posts__enable_smilies] DEFAULT (1) FOR [enable_smilies], + CONSTRAINT [DF_posts__enable_magic_url] DEFAULT (1) FOR [enable_magic_url], + CONSTRAINT [DF_posts__enable_sig] DEFAULT (1) FOR [enable_sig], + CONSTRAINT [DF_posts__post_encoding] DEFAULT ('iso-8859-1') FOR [post_encoding], + CONSTRAINT [DF_posts__post_attachment] DEFAULT (0) FOR [post_attachment], + CONSTRAINT [DF_posts__bbcode_bitfield] DEFAULT (0) FOR [bbcode_bitfield], + CONSTRAINT [DF_posts__post_edit_time] DEFAULT (0) FOR [post_edit_time], + CONSTRAINT [DF_posts__post_edit_user] DEFAULT (0) FOR [post_edit_user], + CONSTRAINT [DF_posts__post_edit_count] DEFAULT (0) FOR [post_edit_count], + CONSTRAINT [DF_posts__post_edit_locked] DEFAULT (0) FOR [post_edit_locked] +GO + +CREATE INDEX [forum_id] ON [phpbb_posts]([forum_id]) ON [PRIMARY] +GO + +CREATE INDEX [topic_id] ON [phpbb_posts]([topic_id]) ON [PRIMARY] +GO + +CREATE INDEX [poster_ip] ON [phpbb_posts]([poster_ip]) ON [PRIMARY] +GO + +CREATE INDEX [poster_id] ON [phpbb_posts]([poster_id]) ON [PRIMARY] +GO + +CREATE INDEX [post_approved] ON [phpbb_posts]([post_approved]) ON [PRIMARY] +GO + +CREATE INDEX [post_time] ON [phpbb_posts]([post_time]) ON [PRIMARY] +GO + + +/* + Table: phpbb_privmsgs +*/ CREATE TABLE [phpbb_privmsgs] ( [msg_id] [int] IDENTITY (1, 1) NOT NULL , [root_level] [int] NOT NULL , @@ -371,9 +1004,9 @@ CREATE TABLE [phpbb_privmsgs] ( [enable_smilies] [int] NOT NULL , [enable_magic_url] [int] NOT NULL , [enable_sig] [int] NOT NULL , - [message_subject] [varchar] (60) NULL , - [message_text] [text] NULL , - [message_edit_reason] [varchar] (100) NULL , + [message_subject] [text] , + [message_text] [text] , + [message_edit_reason] [text] , [message_edit_user] [int] NOT NULL , [message_encoding] [varchar] (20) NOT NULL , [message_attachment] [int] NOT NULL , @@ -386,14 +1019,73 @@ CREATE TABLE [phpbb_privmsgs] ( ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO +ALTER TABLE [phpbb_privmsgs] WITH NOCHECK ADD + CONSTRAINT [PK_phpbb_privmsgs] PRIMARY KEY CLUSTERED + ( + [msg_id] + ) ON [PRIMARY] +GO + +ALTER TABLE [phpbb_privmsgs] WITH NOCHECK ADD + CONSTRAINT [DF_privms_root_level] DEFAULT (0) FOR [root_level], + CONSTRAINT [DF_privms_author_id] DEFAULT (0) FOR [author_id], + CONSTRAINT [DF_privms_icon_id] DEFAULT (1) FOR [icon_id], + CONSTRAINT [DF_privms_message_time] DEFAULT (0) FOR [message_time], + CONSTRAINT [DF_privms_enable_bbcode] DEFAULT (1) FOR [enable_bbcode], + CONSTRAINT [DF_privms_enable_smilies] DEFAULT (1) FOR [enable_smilies], + CONSTRAINT [DF_privms_enable_magic_url] DEFAULT (1) FOR [enable_magic_url], + CONSTRAINT [DF_privms_enable_sig] DEFAULT (1) FOR [enable_sig], + CONSTRAINT [DF_privms_message_edit_user] DEFAULT (0) FOR [message_edit_user], + CONSTRAINT [DF_privms_message_encoding] DEFAULT ('iso-8859-1') FOR [message_encoding], + CONSTRAINT [DF_privms_message_attachment] DEFAULT (0) FOR [message_attachment], + CONSTRAINT [DF_privms_bbcode_bitfield] DEFAULT (0) FOR [bbcode_bitfield], + CONSTRAINT [DF_privms_message_edit_time] DEFAULT (0) FOR [message_edit_time], + CONSTRAINT [DF_privms_message_edit_count] DEFAULT (0) FOR [message_edit_count] +GO + +CREATE INDEX [author_ip] ON [phpbb_privmsgs]([author_ip]) ON [PRIMARY] +GO + +CREATE INDEX [message_time] ON [phpbb_privmsgs]([message_time]) ON [PRIMARY] +GO + +CREATE INDEX [author_id] ON [phpbb_privmsgs]([author_id]) ON [PRIMARY] +GO + +CREATE INDEX [root_level] ON [phpbb_privmsgs]([root_level]) ON [PRIMARY] +GO + + +/* + Table: phpbb_privmsgs_folder +*/ CREATE TABLE [phpbb_privmsgs_folder] ( [folder_id] [int] IDENTITY (1, 1) NOT NULL , [user_id] [int] NOT NULL , - [folder_name] [varchar] (40) NOT NULL , + [folder_name] [varchar] (255) NOT NULL , [pm_count] [int] NOT NULL ) ON [PRIMARY] GO +ALTER TABLE [phpbb_privmsgs_folder] WITH NOCHECK ADD + CONSTRAINT [PK_phpbb_privmsgs_folder] PRIMARY KEY CLUSTERED + ( + [folder_id] + ) ON [PRIMARY] +GO + +ALTER TABLE [phpbb_privmsgs_folder] WITH NOCHECK ADD + CONSTRAINT [DF_pmfold_user_id] DEFAULT (0) FOR [user_id], + CONSTRAINT [DF_pmfold_pm_count] DEFAULT (0) FOR [pm_count] +GO + +CREATE INDEX [user_id] ON [phpbb_privmsgs_folder]([user_id]) ON [PRIMARY] +GO + + +/* + Table: phpbb_privmsgs_rules +*/ CREATE TABLE [phpbb_privmsgs_rules] ( [rule_id] [int] IDENTITY (1, 1) NOT NULL , [user_id] [int] NOT NULL , @@ -407,6 +1099,27 @@ CREATE TABLE [phpbb_privmsgs_rules] ( ) ON [PRIMARY] GO +ALTER TABLE [phpbb_privmsgs_rules] WITH NOCHECK ADD + CONSTRAINT [PK_phpbb_privmsgs_rules] PRIMARY KEY CLUSTERED + ( + [rule_id] + ) ON [PRIMARY] +GO + +ALTER TABLE [phpbb_privmsgs_rules] WITH NOCHECK ADD + CONSTRAINT [DF_pmrule_user_id] DEFAULT (0) FOR [user_id], + CONSTRAINT [DF_pmrule_rule_check] DEFAULT (0) FOR [rule_check], + CONSTRAINT [DF_pmrule_rule_connection] DEFAULT (0) FOR [rule_connection], + CONSTRAINT [DF_pmrule_rule_user_id] DEFAULT (0) FOR [rule_user_id], + CONSTRAINT [DF_pmrule_rule_group_id] DEFAULT (0) FOR [rule_group_id], + CONSTRAINT [DF_pmrule_rule_action] DEFAULT (0) FOR [rule_action], + CONSTRAINT [DF_pmrule_rule_folder_id] DEFAULT (0) FOR [rule_folder_id] +GO + + +/* + Table: phpbb_privmsgs_to +*/ CREATE TABLE [phpbb_privmsgs_to] ( [msg_id] [int] NOT NULL , [user_id] [int] NOT NULL , @@ -421,10 +1134,33 @@ CREATE TABLE [phpbb_privmsgs_to] ( ) ON [PRIMARY] GO +ALTER TABLE [phpbb_privmsgs_to] WITH NOCHECK ADD + CONSTRAINT [DF_pmto___msg_id] DEFAULT (0) FOR [msg_id], + CONSTRAINT [DF_pmto___user_id] DEFAULT (0) FOR [user_id], + CONSTRAINT [DF_pmto___author_id] DEFAULT (0) FOR [author_id], + CONSTRAINT [DF_pmto___deleted] DEFAULT (0) FOR [deleted], + CONSTRAINT [DF_pmto___new] DEFAULT (1) FOR [new], + CONSTRAINT [DF_pmto___unread] DEFAULT (1) FOR [unread], + CONSTRAINT [DF_pmto___replied] DEFAULT (0) FOR [replied], + CONSTRAINT [DF_pmto___marked] DEFAULT (0) FOR [marked], + CONSTRAINT [DF_pmto___forwarded] DEFAULT (0) FOR [forwarded], + CONSTRAINT [DF_pmto___folder_id] DEFAULT (0) FOR [folder_id] +GO + +CREATE INDEX [msg_id] ON [phpbb_privmsgs_to]([msg_id]) ON [PRIMARY] +GO + +CREATE INDEX [user_id] ON [phpbb_privmsgs_to]([user_id], [folder_id]) ON [PRIMARY] +GO + + +/* + Table: phpbb_profile_fields +*/ CREATE TABLE [phpbb_profile_fields] ( [field_id] [int] IDENTITY (1, 1) NOT NULL , - [field_name] [varchar] (50) NOT NULL , - [field_desc] [varchar] (255) NOT NULL , + [field_name] [varchar] (255) NOT NULL , + [field_desc] [text] , [field_type] [int] NOT NULL , [field_ident] [varchar] (20) NOT NULL , [field_length] [varchar] (20) NOT NULL , @@ -439,14 +1175,57 @@ CREATE TABLE [phpbb_profile_fields] ( [field_no_view] [int] NOT NULL , [field_active] [int] NOT NULL , [field_order] [int] NOT NULL -) ON [PRIMARY] +) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] +GO + +ALTER TABLE [phpbb_profile_fields] WITH NOCHECK ADD + CONSTRAINT [PK_phpbb_profile_fields] PRIMARY KEY CLUSTERED + ( + [field_id] + ) ON [PRIMARY] +GO + +ALTER TABLE [phpbb_profile_fields] WITH NOCHECK ADD + CONSTRAINT [DF_pffiel_field_type] DEFAULT (0) FOR [field_type], + CONSTRAINT [DF_pffiel_field_default_value] DEFAULT ('0') FOR [field_default_value], + CONSTRAINT [DF_pffiel_field_required] DEFAULT (0) FOR [field_required], + CONSTRAINT [DF_pffiel_field_show_on_reg] DEFAULT (0) FOR [field_show_on_reg], + CONSTRAINT [DF_pffiel_field_hide] DEFAULT (0) FOR [field_hide], + CONSTRAINT [DF_pffiel_field_no_view] DEFAULT (0) FOR [field_no_view], + CONSTRAINT [DF_pffiel_field_active] DEFAULT (0) FOR [field_active], + CONSTRAINT [DF_pffiel_field_order] DEFAULT (0) FOR [field_order] GO +CREATE INDEX [field_type] ON [phpbb_profile_fields]([field_type]) ON [PRIMARY] +GO + +CREATE INDEX [field_order] ON [phpbb_profile_fields]([field_order]) ON [PRIMARY] +GO + + +/* + Table: phpbb_profile_fields_data +*/ CREATE TABLE [phpbb_profile_fields_data] ( [user_id] [int] NOT NULL ) ON [PRIMARY] GO +ALTER TABLE [phpbb_profile_fields_data] WITH NOCHECK ADD + CONSTRAINT [PK_phpbb_profile_fields_data] PRIMARY KEY CLUSTERED + ( + [user_id] + ) ON [PRIMARY] +GO + +ALTER TABLE [phpbb_profile_fields_data] WITH NOCHECK ADD + CONSTRAINT [DF_pfdata_user_id] DEFAULT (0) FOR [user_id] +GO + + +/* + Table: phpbb_profile_fields_lang +*/ CREATE TABLE [phpbb_profile_fields_lang] ( [field_id] [int] NOT NULL , [lang_id] [int] NOT NULL , @@ -456,24 +1235,77 @@ CREATE TABLE [phpbb_profile_fields_lang] ( ) ON [PRIMARY] GO +ALTER TABLE [phpbb_profile_fields_lang] WITH NOCHECK ADD + CONSTRAINT [PK_phpbb_profile_fields_lang] PRIMARY KEY CLUSTERED + ( + [field_id], + [lang_id], + [option_id] + ) ON [PRIMARY] +GO + +ALTER TABLE [phpbb_profile_fields_lang] WITH NOCHECK ADD + CONSTRAINT [DF_pfflan_field_id] DEFAULT (0) FOR [field_id], + CONSTRAINT [DF_pfflan_lang_id] DEFAULT (0) FOR [lang_id], + CONSTRAINT [DF_pfflan_option_id] DEFAULT (0) FOR [option_id], + CONSTRAINT [DF_pfflan_field_type] DEFAULT (0) FOR [field_type] +GO + + +/* + Table: phpbb_profile_lang +*/ CREATE TABLE [phpbb_profile_lang] ( [field_id] [int] NOT NULL , [lang_id] [int] NOT NULL , [lang_name] [varchar] (255) NOT NULL , - [lang_explain] [text] NOT NULL , + [lang_explain] [text] , [lang_default_value] [varchar] (255) NOT NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO +ALTER TABLE [phpbb_profile_lang] WITH NOCHECK ADD + CONSTRAINT [PK_phpbb_profile_lang] PRIMARY KEY CLUSTERED + ( + [field_id], + [lang_id] + ) ON [PRIMARY] +GO + +ALTER TABLE [phpbb_profile_lang] WITH NOCHECK ADD + CONSTRAINT [DF_pflang_field_id] DEFAULT (0) FOR [field_id], + CONSTRAINT [DF_pflang_lang_id] DEFAULT (0) FOR [lang_id] +GO + + +/* + Table: phpbb_ranks +*/ CREATE TABLE [phpbb_ranks] ( [rank_id] [int] IDENTITY (1, 1) NOT NULL , - [rank_title] [varchar] (50) NOT NULL , + [rank_title] [varchar] (255) NOT NULL , [rank_min] [int] NOT NULL , [rank_special] [int] NULL , - [rank_image] [varchar] (100) NULL + [rank_image] [varchar] (255) NULL ) ON [PRIMARY] GO +ALTER TABLE [phpbb_ranks] WITH NOCHECK ADD + CONSTRAINT [PK_phpbb_ranks] PRIMARY KEY CLUSTERED + ( + [rank_id] + ) ON [PRIMARY] +GO + +ALTER TABLE [phpbb_ranks] WITH NOCHECK ADD + CONSTRAINT [DF_ranks__rank_min] DEFAULT (0) FOR [rank_min], + CONSTRAINT [DF_ranks__rank_special] DEFAULT (0) FOR [rank_special] +GO + + +/* + Table: phpbb_reports +*/ CREATE TABLE [phpbb_reports] ( [report_id] [int] IDENTITY (1, 1) NOT NULL , [reason_id] [int] NOT NULL , @@ -482,26 +1314,76 @@ CREATE TABLE [phpbb_reports] ( [user_notify] [int] NOT NULL , [report_closed] [int] NOT NULL , [report_time] [int] NOT NULL , - [report_text] [text] NOT NULL + [report_text] [text] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO +ALTER TABLE [phpbb_reports] WITH NOCHECK ADD + CONSTRAINT [PK_phpbb_reports] PRIMARY KEY CLUSTERED + ( + [report_id] + ) ON [PRIMARY] +GO + +ALTER TABLE [phpbb_reports] WITH NOCHECK ADD + CONSTRAINT [DF_report_reason_id] DEFAULT (0) FOR [reason_id], + CONSTRAINT [DF_report_post_id] DEFAULT (0) FOR [post_id], + CONSTRAINT [DF_report_user_id] DEFAULT (0) FOR [user_id], + CONSTRAINT [DF_report_user_notify] DEFAULT (0) FOR [user_notify], + CONSTRAINT [DF_report_report_closed] DEFAULT (0) FOR [report_closed], + CONSTRAINT [DF_report_report_time] DEFAULT (0) FOR [report_time] +GO + + +/* + Table: phpbb_reports_reasons +*/ CREATE TABLE [phpbb_reports_reasons] ( [reason_id] [int] IDENTITY (1, 1) NOT NULL , [reason_title] [varchar] (255) NOT NULL , - [reason_description] [text] NOT NULL , + [reason_description] [text] , [reason_order] [int] NOT NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO +ALTER TABLE [phpbb_reports_reasons] WITH NOCHECK ADD + CONSTRAINT [PK_phpbb_reports_reasons] PRIMARY KEY CLUSTERED + ( + [reason_id] + ) ON [PRIMARY] +GO + +ALTER TABLE [phpbb_reports_reasons] WITH NOCHECK ADD + CONSTRAINT [DF_reporr_reason_order] DEFAULT (0) FOR [reason_order] +GO + + +/* + Table: phpbb_search_results +*/ CREATE TABLE [phpbb_search_results] ( [search_key] [varchar] (32) NOT NULL , [search_time] [int] NOT NULL , - [search_keywords] [text] NOT NULL , - [search_authors] [text] NOT NULL + [search_keywords] [text] , + [search_authors] [text] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO +ALTER TABLE [phpbb_search_results] WITH NOCHECK ADD + CONSTRAINT [PK_phpbb_search_results] PRIMARY KEY CLUSTERED + ( + [search_key] + ) ON [PRIMARY] +GO + +ALTER TABLE [phpbb_search_results] WITH NOCHECK ADD + CONSTRAINT [DF_search_search_time] DEFAULT (0) FOR [search_time] +GO + + +/* + Table: phpbb_search_wordlist +*/ CREATE TABLE [phpbb_search_wordlist] ( [word_text] [nvarchar] (50) NOT NULL , [word_id] [int] IDENTITY (1, 1) NOT NULL , @@ -509,6 +1391,24 @@ CREATE TABLE [phpbb_search_wordlist] ( ) ON [PRIMARY] GO +ALTER TABLE [phpbb_search_wordlist] WITH NOCHECK ADD + CONSTRAINT [PK_phpbb_search_wordlist] PRIMARY KEY CLUSTERED + ( + [word_text] + ) ON [PRIMARY] +GO + +ALTER TABLE [phpbb_search_wordlist] WITH NOCHECK ADD + CONSTRAINT [DF_swlist_word_common] DEFAULT (0) FOR [word_common] +GO + +CREATE INDEX [word_id] ON [phpbb_search_wordlist]([word_id]) ON [PRIMARY] +GO + + +/* + Table: phpbb_search_wordmatch +*/ CREATE TABLE [phpbb_search_wordmatch] ( [post_id] [int] NOT NULL , [word_id] [int] NOT NULL , @@ -516,6 +1416,19 @@ CREATE TABLE [phpbb_search_wordmatch] ( ) ON [PRIMARY] GO +ALTER TABLE [phpbb_search_wordmatch] WITH NOCHECK ADD + CONSTRAINT [DF_swmatc_post_id] DEFAULT (0) FOR [post_id], + CONSTRAINT [DF_swmatc_word_id] DEFAULT (0) FOR [word_id], + CONSTRAINT [DF_swmatc_title_match] DEFAULT (0) FOR [title_match] +GO + +CREATE INDEX [word_id] ON [phpbb_search_wordmatch]([word_id]) ON [PRIMARY] +GO + + +/* + Table: phpbb_sessions +*/ CREATE TABLE [phpbb_sessions] ( [session_id] [varchar] (32) NOT NULL , [session_user_id] [int] NOT NULL , @@ -531,6 +1444,34 @@ CREATE TABLE [phpbb_sessions] ( ) ON [PRIMARY] GO +ALTER TABLE [phpbb_sessions] WITH NOCHECK ADD + CONSTRAINT [PK_phpbb_sessions] PRIMARY KEY CLUSTERED + ( + [session_id] + ) ON [PRIMARY] +GO + +ALTER TABLE [phpbb_sessions] WITH NOCHECK ADD + CONSTRAINT [DF_sessio_session_user_id] DEFAULT (0) FOR [session_user_id], + CONSTRAINT [DF_sessio_session_last_visit] DEFAULT (0) FOR [session_last_visit], + CONSTRAINT [DF_sessio_session_start] DEFAULT (0) FOR [session_start], + CONSTRAINT [DF_sessio_session_time] DEFAULT (0) FOR [session_time], + CONSTRAINT [DF_sessio_session_ip] DEFAULT ('0') FOR [session_ip], + CONSTRAINT [DF_sessio_session_viewonline] DEFAULT (1) FOR [session_viewonline], + CONSTRAINT [DF_sessio_session_autologin] DEFAULT (0) FOR [session_autologin], + CONSTRAINT [DF_sessio_session_admin] DEFAULT (0) FOR [session_admin] +GO + +CREATE INDEX [session_time] ON [phpbb_sessions]([session_time]) ON [PRIMARY] +GO + +CREATE INDEX [session_user_id] ON [phpbb_sessions]([session_user_id]) ON [PRIMARY] +GO + + +/* + Table: phpbb_sessions_keys +*/ CREATE TABLE [phpbb_sessions_keys] ( [key_id] [varchar] (32) NOT NULL , [user_id] [int] NOT NULL , @@ -539,6 +1480,28 @@ CREATE TABLE [phpbb_sessions_keys] ( ) ON [PRIMARY] GO +ALTER TABLE [phpbb_sessions_keys] WITH NOCHECK ADD + CONSTRAINT [PK_phpbb_sessions_keys] PRIMARY KEY CLUSTERED + ( + [key_id], + [user_id] + ) ON [PRIMARY] +GO + +ALTER TABLE [phpbb_sessions_keys] WITH NOCHECK ADD + CONSTRAINT [DF_sessik_key_id] DEFAULT ('0') FOR [key_id], + CONSTRAINT [DF_sessik_user_id] DEFAULT (0) FOR [user_id], + CONSTRAINT [DF_sessik_last_ip] DEFAULT ('0') FOR [last_ip], + CONSTRAINT [DF_sessik_last_login] DEFAULT (0) FOR [last_login] +GO + +CREATE INDEX [last_login] ON [phpbb_sessions_keys]([last_login]) ON [PRIMARY] +GO + + +/* + Table: phpbb_sitelist +*/ CREATE TABLE [phpbb_sitelist] ( [site_id] [int] IDENTITY (1, 1) NOT NULL , [site_ip] [varchar] (40) NOT NULL , @@ -547,6 +1510,21 @@ CREATE TABLE [phpbb_sitelist] ( ) ON [PRIMARY] GO +ALTER TABLE [phpbb_sitelist] WITH NOCHECK ADD + CONSTRAINT [PK_phpbb_sitelist] PRIMARY KEY CLUSTERED + ( + [site_id] + ) ON [PRIMARY] +GO + +ALTER TABLE [phpbb_sitelist] WITH NOCHECK ADD + CONSTRAINT [DF_siteli_ip_exclude] DEFAULT (0) FOR [ip_exclude] +GO + + +/* + Table: phpbb_smilies +*/ CREATE TABLE [phpbb_smilies] ( [smiley_id] [int] IDENTITY (1, 1) NOT NULL , [code] [varchar] (10) NULL , @@ -559,10 +1537,28 @@ CREATE TABLE [phpbb_smilies] ( ) ON [PRIMARY] GO +ALTER TABLE [phpbb_smilies] WITH NOCHECK ADD + CONSTRAINT [PK_phpbb_smilies] PRIMARY KEY CLUSTERED + ( + [smiley_id] + ) ON [PRIMARY] +GO + +ALTER TABLE [phpbb_smilies] WITH NOCHECK ADD + CONSTRAINT [DF_smilie_smiley_width] DEFAULT (0) FOR [smiley_width], + CONSTRAINT [DF_smilie_smiley_height] DEFAULT (0) FOR [smiley_height], + CONSTRAINT [DF_smilie_smiley_order] DEFAULT (0) FOR [smiley_order], + CONSTRAINT [DF_smilie_display_on_posting] DEFAULT (1) FOR [display_on_posting] +GO + + +/* + Table: phpbb_styles +*/ CREATE TABLE [phpbb_styles] ( [style_id] [int] IDENTITY (1, 1) NOT NULL , - [style_name] [varchar] (30) NOT NULL , - [style_copyright] [varchar] (50) NOT NULL , + [style_name] [varchar] (255) NOT NULL , + [style_copyright] [varchar] (255) NOT NULL , [style_active] [int] NOT NULL , [template_id] [int] NOT NULL , [theme_id] [int] NOT NULL , @@ -570,11 +1566,41 @@ CREATE TABLE [phpbb_styles] ( ) ON [PRIMARY] GO +ALTER TABLE [phpbb_styles] WITH NOCHECK ADD + CONSTRAINT [PK_phpbb_styles] PRIMARY KEY CLUSTERED + ( + [style_id] + ) ON [PRIMARY] +GO + +ALTER TABLE [phpbb_styles] WITH NOCHECK ADD + CONSTRAINT [DF_styles_style_active] DEFAULT (1) FOR [style_active], + CONSTRAINT [DF_styles_template_id] DEFAULT (0) FOR [template_id], + CONSTRAINT [DF_styles_theme_id] DEFAULT (0) FOR [theme_id], + CONSTRAINT [DF_styles_imageset_id] DEFAULT (0) FOR [imageset_id] +GO + +CREATE UNIQUE INDEX [style_name] ON [phpbb_styles]([style_name]) ON [PRIMARY] +GO + +CREATE INDEX [template_id] ON [phpbb_styles]([template_id]) ON [PRIMARY] +GO + +CREATE INDEX [theme_id] ON [phpbb_styles]([theme_id]) ON [PRIMARY] +GO + +CREATE INDEX [imageset_id] ON [phpbb_styles]([imageset_id]) ON [PRIMARY] +GO + + +/* + Table: phpbb_styles_imageset +*/ CREATE TABLE [phpbb_styles_imageset] ( [imageset_id] [int] IDENTITY (1, 1) NOT NULL , - [imageset_name] [varchar] (30) NOT NULL , - [imageset_copyright] [varchar] (50) NOT NULL , - [imageset_path] [varchar] (30) NOT NULL , + [imageset_name] [varchar] (255) NOT NULL , + [imageset_copyright] [varchar] (255) NOT NULL , + [imageset_path] [varchar] (100) NOT NULL , [site_logo] [varchar] (200) NOT NULL , [btn_post] [varchar] (200) NOT NULL , [btn_post_pm] [varchar] (200) NOT NULL , @@ -655,36 +1681,103 @@ CREATE TABLE [phpbb_styles_imageset] ( ) ON [PRIMARY] GO +ALTER TABLE [phpbb_styles_imageset] WITH NOCHECK ADD + CONSTRAINT [PK_phpbb_styles_imageset] PRIMARY KEY CLUSTERED + ( + [imageset_id] + ) ON [PRIMARY] +GO + +CREATE UNIQUE INDEX [imageset_name] ON [phpbb_styles_imageset]([imageset_name]) ON [PRIMARY] +GO + + +/* + Table: phpbb_styles_template +*/ CREATE TABLE [phpbb_styles_template] ( [template_id] [int] IDENTITY (1, 1) NOT NULL , - [template_name] [varchar] (30) NOT NULL , - [template_copyright] [varchar] (50) NOT NULL , - [template_path] [varchar] (30) NOT NULL , + [template_name] [varchar] (255) NOT NULL , + [template_copyright] [varchar] (255) NOT NULL , + [template_path] [varchar] (100) NOT NULL , [bbcode_bitfield] [int] NOT NULL , [template_storedb] [int] NOT NULL ) ON [PRIMARY] GO +ALTER TABLE [phpbb_styles_template] WITH NOCHECK ADD + CONSTRAINT [PK_phpbb_styles_template] PRIMARY KEY CLUSTERED + ( + [template_id] + ) ON [PRIMARY] +GO + +ALTER TABLE [phpbb_styles_template] WITH NOCHECK ADD + CONSTRAINT [DF_templa_bbcode_bitfield] DEFAULT (0) FOR [bbcode_bitfield], + CONSTRAINT [DF_templa_template_storedb] DEFAULT (0) FOR [template_storedb] +GO + +CREATE UNIQUE INDEX [template_name] ON [phpbb_styles_template]([template_name]) ON [PRIMARY] +GO + + +/* + Table: phpbb_styles_template_data +*/ CREATE TABLE [phpbb_styles_template_data] ( [template_id] [int] NOT NULL , - [template_filename] [varchar] (50) NOT NULL , - [template_included] [text] NOT NULL , + [template_filename] [varchar] (100) NOT NULL , + [template_included] [text] , [template_mtime] [int] NOT NULL , - [template_data] [text] NULL + [template_data] [text] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO +ALTER TABLE [phpbb_styles_template_data] WITH NOCHECK ADD + CONSTRAINT [DF_tpldat_template_id] DEFAULT (0) FOR [template_id], + CONSTRAINT [DF_tpldat_template_mtime] DEFAULT (0) FOR [template_mtime] +GO + +CREATE INDEX [template_id] ON [phpbb_styles_template_data]([template_id]) ON [PRIMARY] +GO + +CREATE INDEX [template_filename] ON [phpbb_styles_template_data]([template_filename]) ON [PRIMARY] +GO + + +/* + Table: phpbb_styles_theme +*/ CREATE TABLE [phpbb_styles_theme] ( [theme_id] [int] IDENTITY (1, 1) NOT NULL , - [theme_name] [varchar] (30) NOT NULL , - [theme_copyright] [varchar] (50) NOT NULL , - [theme_path] [varchar] (30) NOT NULL , + [theme_name] [varchar] (255) NOT NULL , + [theme_copyright] [varchar] (255) NOT NULL , + [theme_path] [varchar] (100) NOT NULL , [theme_storedb] [int] NOT NULL , [theme_mtime] [int] NOT NULL , - [theme_data] [text] NOT NULL + [theme_data] [text] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO +ALTER TABLE [phpbb_styles_theme] WITH NOCHECK ADD + CONSTRAINT [PK_phpbb_styles_theme] PRIMARY KEY CLUSTERED + ( + [theme_id] + ) ON [PRIMARY] +GO + +ALTER TABLE [phpbb_styles_theme] WITH NOCHECK ADD + CONSTRAINT [DF_theme__theme_storedb] DEFAULT (0) FOR [theme_storedb], + CONSTRAINT [DF_theme__theme_mtime] DEFAULT (0) FOR [theme_mtime] +GO + +CREATE UNIQUE INDEX [theme_name] ON [phpbb_styles_theme]([theme_name]) ON [PRIMARY] +GO + + +/* + Table: phpbb_topics +*/ CREATE TABLE [phpbb_topics] ( [topic_id] [int] IDENTITY (1, 1) NOT NULL , [forum_id] [int] NOT NULL , @@ -692,7 +1785,7 @@ CREATE TABLE [phpbb_topics] ( [topic_attachment] [int] NOT NULL , [topic_approved] [int] NOT NULL , [topic_reported] [int] NOT NULL , - [topic_title] [varchar] (60) NOT NULL , + [topic_title] [text] , [topic_poster] [int] NOT NULL , [topic_time] [int] NOT NULL , [topic_time_limit] [int] NOT NULL , @@ -702,24 +1795,74 @@ CREATE TABLE [phpbb_topics] ( [topic_status] [int] NOT NULL , [topic_type] [int] NOT NULL , [topic_first_post_id] [int] NOT NULL , - [topic_first_poster_name] [varchar] (30) NULL , + [topic_first_poster_name] [varchar] (255) NULL , [topic_last_post_id] [int] NOT NULL , [topic_last_poster_id] [int] NOT NULL , - [topic_last_poster_name] [varchar] (30) NULL , + [topic_last_poster_name] [varchar] (255) NULL , [topic_last_post_time] [int] NOT NULL , [topic_last_view_time] [int] NOT NULL , [topic_moved_id] [int] NOT NULL , [topic_bumped] [int] NOT NULL , [topic_bumper] [int] NOT NULL , - [poll_title] [varchar] (255) NOT NULL , + [poll_title] [text] , [poll_start] [int] NOT NULL , [poll_length] [int] NOT NULL , [poll_max_options] [int] NOT NULL , [poll_last_vote] [int] NULL , [poll_vote_change] [int] NOT NULL -) ON [PRIMARY] +) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] +GO + +ALTER TABLE [phpbb_topics] WITH NOCHECK ADD + CONSTRAINT [PK_phpbb_topics] PRIMARY KEY CLUSTERED + ( + [topic_id] + ) ON [PRIMARY] +GO + +ALTER TABLE [phpbb_topics] WITH NOCHECK ADD + CONSTRAINT [DF_topics_forum_id] DEFAULT (0) FOR [forum_id], + CONSTRAINT [DF_topics_icon_id] DEFAULT (1) FOR [icon_id], + CONSTRAINT [DF_topics_topic_attachment] DEFAULT (0) FOR [topic_attachment], + CONSTRAINT [DF_topics_topic_approved] DEFAULT (1) FOR [topic_approved], + CONSTRAINT [DF_topics_topic_reported] DEFAULT (0) FOR [topic_reported], + CONSTRAINT [DF_topics_topic_poster] DEFAULT (0) FOR [topic_poster], + CONSTRAINT [DF_topics_topic_time] DEFAULT (0) FOR [topic_time], + CONSTRAINT [DF_topics_topic_time_limit] DEFAULT (0) FOR [topic_time_limit], + CONSTRAINT [DF_topics_topic_views] DEFAULT (0) FOR [topic_views], + CONSTRAINT [DF_topics_topic_replies] DEFAULT (0) FOR [topic_replies], + CONSTRAINT [DF_topics_topic_replies_real] DEFAULT (0) FOR [topic_replies_real], + CONSTRAINT [DF_topics_topic_status] DEFAULT (0) FOR [topic_status], + CONSTRAINT [DF_topics_topic_type] DEFAULT (0) FOR [topic_type], + CONSTRAINT [DF_topics_topic_first_post_id] DEFAULT (0) FOR [topic_first_post_id], + CONSTRAINT [DF_topics_topic_last_post_id] DEFAULT (0) FOR [topic_last_post_id], + CONSTRAINT [DF_topics_topic_last_poster_id] DEFAULT (0) FOR [topic_last_poster_id], + CONSTRAINT [DF_topics_topic_last_post_time] DEFAULT (0) FOR [topic_last_post_time], + CONSTRAINT [DF_topics_topic_last_view_time] DEFAULT (0) FOR [topic_last_view_time], + CONSTRAINT [DF_topics_topic_moved_id] DEFAULT (0) FOR [topic_moved_id], + CONSTRAINT [DF_topics_topic_bumped] DEFAULT (0) FOR [topic_bumped], + CONSTRAINT [DF_topics_topic_bumper] DEFAULT (0) FOR [topic_bumper], + CONSTRAINT [DF_topics_poll_title] DEFAULT ('') FOR [poll_title], + CONSTRAINT [DF_topics_poll_start] DEFAULT (0) FOR [poll_start], + CONSTRAINT [DF_topics_poll_length] DEFAULT (0) FOR [poll_length], + CONSTRAINT [DF_topics_poll_max_options] DEFAULT (1) FOR [poll_max_options], + CONSTRAINT [DF_topics_poll_last_vote] DEFAULT (0) FOR [poll_last_vote], + CONSTRAINT [DF_topics_poll_vote_change] DEFAULT (0) FOR [poll_vote_change] +GO + +CREATE INDEX [forum_id] ON [phpbb_topics]([forum_id]) ON [PRIMARY] GO +CREATE INDEX [forum_id_type] ON [phpbb_topics]([forum_id], [topic_type]) ON [PRIMARY] +GO + +CREATE INDEX [topic_last_post_time] ON [phpbb_topics]([topic_last_post_time]) ON [PRIMARY] +GO + + +/* + Table: phpbb_topics_marking +*/ CREATE TABLE [phpbb_topics_marking] ( [user_id] [int] NOT NULL , [topic_id] [int] NOT NULL , @@ -728,6 +1871,28 @@ CREATE TABLE [phpbb_topics_marking] ( ) ON [PRIMARY] GO +ALTER TABLE [phpbb_topics_marking] WITH NOCHECK ADD + CONSTRAINT [PK_phpbb_topics_marking] PRIMARY KEY CLUSTERED + ( + [user_id], + [topic_id] + ) ON [PRIMARY] +GO + +ALTER TABLE [phpbb_topics_marking] WITH NOCHECK ADD + CONSTRAINT [DF_tmarki_user_id] DEFAULT (0) FOR [user_id], + CONSTRAINT [DF_tmarki_topic_id] DEFAULT (0) FOR [topic_id], + CONSTRAINT [DF_tmarki_forum_id] DEFAULT (0) FOR [forum_id], + CONSTRAINT [DF_tmarki_mark_time] DEFAULT (0) FOR [mark_time] +GO + +CREATE INDEX [forum_id] ON [phpbb_topics_marking]([forum_id]) ON [PRIMARY] +GO + + +/* + Table: phpbb_topics_posted +*/ CREATE TABLE [phpbb_topics_posted] ( [user_id] [int] NOT NULL , [topic_id] [int] NOT NULL , @@ -735,6 +1900,24 @@ CREATE TABLE [phpbb_topics_posted] ( ) ON [PRIMARY] GO +ALTER TABLE [phpbb_topics_posted] WITH NOCHECK ADD + CONSTRAINT [PK_phpbb_topics_posted] PRIMARY KEY CLUSTERED + ( + [user_id], + [topic_id] + ) ON [PRIMARY] +GO + +ALTER TABLE [phpbb_topics_posted] WITH NOCHECK ADD + CONSTRAINT [DF_tposte_user_id] DEFAULT (0) FOR [user_id], + CONSTRAINT [DF_tposte_topic_id] DEFAULT (0) FOR [topic_id], + CONSTRAINT [DF_tposte_topic_posted] DEFAULT (0) FOR [topic_posted] +GO + + +/* + Table: phpbb_topics_watch +*/ CREATE TABLE [phpbb_topics_watch] ( [topic_id] [int] NOT NULL , [user_id] [int] NOT NULL , @@ -742,6 +1925,25 @@ CREATE TABLE [phpbb_topics_watch] ( ) ON [PRIMARY] GO +ALTER TABLE [phpbb_topics_watch] WITH NOCHECK ADD + CONSTRAINT [DF_twatch_topic_id] DEFAULT (0) FOR [topic_id], + CONSTRAINT [DF_twatch_user_id] DEFAULT (0) FOR [user_id], + CONSTRAINT [DF_twatch_notify_status] DEFAULT (0) FOR [notify_status] +GO + +CREATE INDEX [topic_id] ON [phpbb_topics_watch]([topic_id]) ON [PRIMARY] +GO + +CREATE INDEX [user_id] ON [phpbb_topics_watch]([user_id]) ON [PRIMARY] +GO + +CREATE INDEX [notify_status] ON [phpbb_topics_watch]([notify_status]) ON [PRIMARY] +GO + + +/* + Table: phpbb_user_group +*/ CREATE TABLE [phpbb_user_group] ( [group_id] [int] NOT NULL , [user_id] [int] NOT NULL , @@ -750,17 +1952,36 @@ CREATE TABLE [phpbb_user_group] ( ) ON [PRIMARY] GO +ALTER TABLE [phpbb_user_group] WITH NOCHECK ADD + CONSTRAINT [DF_usersg_group_id] DEFAULT (0) FOR [group_id], + CONSTRAINT [DF_usersg_user_id] DEFAULT (0) FOR [user_id], + CONSTRAINT [DF_usersg_group_leader] DEFAULT (0) FOR [group_leader] +GO + +CREATE INDEX [group_id] ON [phpbb_user_group]([group_id]) ON [PRIMARY] +GO + +CREATE INDEX [user_id] ON [phpbb_user_group]([user_id]) ON [PRIMARY] +GO + +CREATE INDEX [group_leader] ON [phpbb_user_group]([group_leader]) ON [PRIMARY] +GO + + +/* + Table: phpbb_users +*/ CREATE TABLE [phpbb_users] ( [user_id] [int] IDENTITY (1, 1) NOT NULL , [user_type] [int] NOT NULL , [group_id] [int] NOT NULL , - [user_permissions] [text] NOT NULL , + [user_permissions] [text] , [user_ip] [varchar] (40) NOT NULL , [user_regdate] [int] NOT NULL , - [username] [varchar] (30) NOT NULL , + [username] [varchar] (255) NOT NULL , [user_password] [varchar] (32) NOT NULL , [user_passchg] [int] NOT NULL , - [user_email] [varchar] (60) NOT NULL , + [user_email] [varchar] (100) NOT NULL , [user_email_hash] [float] NOT NULL , [user_birthday] [varchar] (10) NOT NULL , [user_lastvisit] [int] NOT NULL , @@ -800,11 +2021,11 @@ CREATE TABLE [phpbb_users] ( [user_allow_viewemail] [int] NOT NULL , [user_allow_massemail] [int] NOT NULL , [user_options] [int] NOT NULL , - [user_avatar] [varchar] (100) NOT NULL , + [user_avatar] [varchar] (255) NOT NULL , [user_avatar_type] [int] NOT NULL , [user_avatar_width] [int] NOT NULL , [user_avatar_height] [int] NOT NULL , - [user_sig] [text] NOT NULL , + [user_sig] [text] , [user_sig_bbcode_uid] [varchar] (5) NOT NULL , [user_sig_bbcode_bitfield] [int] NOT NULL , [user_from] [varchar] (100) NOT NULL , @@ -813,7 +2034,7 @@ CREATE TABLE [phpbb_users] ( [user_yim] [varchar] (255) NOT NULL , [user_msnm] [varchar] (255) NOT NULL , [user_jabber] [varchar] (255) NOT NULL , - [user_website] [varchar] (100) NOT NULL , + [user_website] [varchar] (200) NOT NULL , [user_occ] [varchar] (255) NOT NULL , [user_interests] [varchar] (255) NOT NULL , [user_actkey] [varchar] (32) NOT NULL , @@ -821,363 +2042,6 @@ CREATE TABLE [phpbb_users] ( ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO -CREATE TABLE [phpbb_warnings] ( - [warning_id] [int] IDENTITY (1, 1) NOT NULL , - [user_id] [int] NOT NULL , - [post_id] [int] NOT NULL , - [log_id] [int] NOT NULL , - [warning_time] [int] NOT NULL -) ON [PRIMARY] -GO - -CREATE TABLE [phpbb_words] ( - [word_id] [int] IDENTITY (1, 1) NOT NULL , - [word] [varchar] (100) NOT NULL , - [replacement] [varchar] (100) NOT NULL -) ON [PRIMARY] -GO - -CREATE TABLE [phpbb_zebra] ( - [user_id] [int] NOT NULL , - [zebra_id] [int] NOT NULL , - [friend] [int] NOT NULL , - [foe] [int] NOT NULL -) ON [PRIMARY] -GO - -ALTER TABLE [phpbb_attachments] WITH NOCHECK ADD - CONSTRAINT [PK_phpbb_attachments] PRIMARY KEY CLUSTERED - ( - [attach_id] - ) ON [PRIMARY] -GO - -ALTER TABLE [phpbb_auth_options] WITH NOCHECK ADD - CONSTRAINT [PK_phpbb_auth_options] PRIMARY KEY CLUSTERED - ( - [auth_option_id] - ) ON [PRIMARY] -GO - -ALTER TABLE [phpbb_auth_roles] WITH NOCHECK ADD - CONSTRAINT [PK_phpbb_auth_roles] PRIMARY KEY CLUSTERED - ( - [role_id] - ) ON [PRIMARY] -GO - -ALTER TABLE [phpbb_auth_roles_data] WITH NOCHECK ADD - CONSTRAINT [PK_phpbb_auth_roles_data] PRIMARY KEY CLUSTERED - ( - [role_id], - [auth_option_id] - ) ON [PRIMARY] -GO - -ALTER TABLE [phpbb_banlist] WITH NOCHECK ADD - CONSTRAINT [PK_phpbb_banlist] PRIMARY KEY CLUSTERED - ( - [ban_id] - ) ON [PRIMARY] -GO - -ALTER TABLE [phpbb_bbcodes] WITH NOCHECK ADD - CONSTRAINT [PK_phpbb_bbcodes] PRIMARY KEY CLUSTERED - ( - [bbcode_id] - ) ON [PRIMARY] -GO - -ALTER TABLE [phpbb_bots] WITH NOCHECK ADD - CONSTRAINT [PK_phpbb_bots] PRIMARY KEY CLUSTERED - ( - [bot_id] - ) ON [PRIMARY] -GO - -ALTER TABLE [phpbb_cache] WITH NOCHECK ADD - CONSTRAINT [PK_phpbb_cache] PRIMARY KEY CLUSTERED - ( - [var_name] - ) ON [PRIMARY] -GO - -ALTER TABLE [phpbb_config] WITH NOCHECK ADD - CONSTRAINT [PK_phpbb_config] PRIMARY KEY CLUSTERED - ( - [config_name] - ) ON [PRIMARY] -GO - -ALTER TABLE [phpbb_confirm] WITH NOCHECK ADD - CONSTRAINT [PK_phpbb_confirm] PRIMARY KEY CLUSTERED - ( - [session_id], - [confirm_id] - ) ON [PRIMARY] -GO - -ALTER TABLE [phpbb_disallow] WITH NOCHECK ADD - CONSTRAINT [PK_phpbb_disallow] PRIMARY KEY CLUSTERED - ( - [disallow_id] - ) ON [PRIMARY] -GO - -ALTER TABLE [phpbb_drafts] WITH NOCHECK ADD - CONSTRAINT [PK_phpbb_drafts] PRIMARY KEY CLUSTERED - ( - [draft_id] - ) ON [PRIMARY] -GO - -ALTER TABLE [phpbb_extension_groups] WITH NOCHECK ADD - CONSTRAINT [PK_phpbb_extension_groups] PRIMARY KEY CLUSTERED - ( - [group_id] - ) ON [PRIMARY] -GO - -ALTER TABLE [phpbb_extensions] WITH NOCHECK ADD - CONSTRAINT [PK_phpbb_extensions] PRIMARY KEY CLUSTERED - ( - [extension_id] - ) ON [PRIMARY] -GO - -ALTER TABLE [phpbb_forum_access] WITH NOCHECK ADD - CONSTRAINT [PK_phpbb_forum_access] PRIMARY KEY CLUSTERED - ( - [forum_id], - [user_id], - [session_id] - ) ON [PRIMARY] -GO - -ALTER TABLE [phpbb_forums] WITH NOCHECK ADD - CONSTRAINT [PK_phpbb_forums] PRIMARY KEY CLUSTERED - ( - [forum_id] - ) ON [PRIMARY] -GO - -ALTER TABLE [phpbb_forums_marking] WITH NOCHECK ADD - CONSTRAINT [PK_phpbb_forums_marking] PRIMARY KEY CLUSTERED - ( - [user_id], - [forum_id] - ) ON [PRIMARY] -GO - -ALTER TABLE [phpbb_groups] WITH NOCHECK ADD - CONSTRAINT [PK_phpbb_groups] PRIMARY KEY CLUSTERED - ( - [group_id] - ) ON [PRIMARY] -GO - -ALTER TABLE [phpbb_icons] WITH NOCHECK ADD - CONSTRAINT [PK_phpbb_icons] PRIMARY KEY CLUSTERED - ( - [icons_id] - ) ON [PRIMARY] -GO - -ALTER TABLE [phpbb_lang] WITH NOCHECK ADD - CONSTRAINT [PK_phpbb_lang] PRIMARY KEY CLUSTERED - ( - [lang_id] - ) ON [PRIMARY] -GO - -ALTER TABLE [phpbb_log] WITH NOCHECK ADD - CONSTRAINT [PK_phpbb_log] PRIMARY KEY CLUSTERED - ( - [log_id] - ) ON [PRIMARY] -GO - -ALTER TABLE [phpbb_modules] WITH NOCHECK ADD - CONSTRAINT [PK_phpbb_modules] PRIMARY KEY CLUSTERED - ( - [module_id] - ) ON [PRIMARY] -GO - -ALTER TABLE [phpbb_posts] WITH NOCHECK ADD - CONSTRAINT [PK_phpbb_posts] PRIMARY KEY CLUSTERED - ( - [post_id] - ) ON [PRIMARY] -GO - -ALTER TABLE [phpbb_privmsgs] WITH NOCHECK ADD - CONSTRAINT [PK_phpbb_privmsgs] PRIMARY KEY CLUSTERED - ( - [msg_id] - ) ON [PRIMARY] -GO - -ALTER TABLE [phpbb_privmsgs_folder] WITH NOCHECK ADD - CONSTRAINT [PK_phpbb_privmsgs_folder] PRIMARY KEY CLUSTERED - ( - [folder_id] - ) ON [PRIMARY] -GO - -ALTER TABLE [phpbb_privmsgs_rules] WITH NOCHECK ADD - CONSTRAINT [PK_phpbb_privmsgs_rules] PRIMARY KEY CLUSTERED - ( - [rule_id] - ) ON [PRIMARY] -GO - -ALTER TABLE [phpbb_profile_fields] WITH NOCHECK ADD - CONSTRAINT [PK_phpbb_profile_fields] PRIMARY KEY CLUSTERED - ( - [field_id] - ) ON [PRIMARY] -GO - -ALTER TABLE [phpbb_profile_fields_data] WITH NOCHECK ADD - CONSTRAINT [PK_phpbb_profile_fields_data] PRIMARY KEY CLUSTERED - ( - [user_id] - ) ON [PRIMARY] -GO - -ALTER TABLE [phpbb_profile_fields_lang] WITH NOCHECK ADD - CONSTRAINT [PK_phpbb_profile_fields_lang] PRIMARY KEY CLUSTERED - ( - [field_id], - [lang_id], - [option_id] - ) ON [PRIMARY] -GO - -ALTER TABLE [phpbb_profile_lang] WITH NOCHECK ADD - CONSTRAINT [PK_phpbb_profile_lang] PRIMARY KEY CLUSTERED - ( - [field_id], - [lang_id] - ) ON [PRIMARY] -GO - -ALTER TABLE [phpbb_ranks] WITH NOCHECK ADD - CONSTRAINT [PK_phpbb_ranks] PRIMARY KEY CLUSTERED - ( - [rank_id] - ) ON [PRIMARY] -GO - -ALTER TABLE [phpbb_reports] WITH NOCHECK ADD - CONSTRAINT [PK_phpbb_reports] PRIMARY KEY CLUSTERED - ( - [report_id] - ) ON [PRIMARY] -GO - -ALTER TABLE [phpbb_reports_reasons] WITH NOCHECK ADD - CONSTRAINT [PK_phpbb_reports_reasons] PRIMARY KEY CLUSTERED - ( - [reason_id] - ) ON [PRIMARY] -GO - -ALTER TABLE [phpbb_search_results] WITH NOCHECK ADD - CONSTRAINT [PK_phpbb_search_results] PRIMARY KEY CLUSTERED - ( - [search_key] - ) ON [PRIMARY] -GO - -ALTER TABLE [phpbb_search_wordlist] WITH NOCHECK ADD - CONSTRAINT [PK_phpbb_search_wordlist] PRIMARY KEY CLUSTERED - ( - [word_text] - ) ON [PRIMARY] -GO - -ALTER TABLE [phpbb_sessions] WITH NOCHECK ADD - CONSTRAINT [PK_phpbb_sessions] PRIMARY KEY CLUSTERED - ( - [session_id] - ) ON [PRIMARY] -GO - -ALTER TABLE [phpbb_sessions_keys] WITH NOCHECK ADD - CONSTRAINT [PK_phpbb_sessions_keys] PRIMARY KEY CLUSTERED - ( - [key_id], - [user_id] - ) ON [PRIMARY] -GO - -ALTER TABLE [phpbb_sitelist] WITH NOCHECK ADD - CONSTRAINT [PK_phpbb_sitelist] PRIMARY KEY CLUSTERED - ( - [site_id] - ) ON [PRIMARY] -GO - -ALTER TABLE [phpbb_smilies] WITH NOCHECK ADD - CONSTRAINT [PK_phpbb_smilies] PRIMARY KEY CLUSTERED - ( - [smiley_id] - ) ON [PRIMARY] -GO - -ALTER TABLE [phpbb_styles] WITH NOCHECK ADD - CONSTRAINT [PK_phpbb_styles] PRIMARY KEY CLUSTERED - ( - [style_id] - ) ON [PRIMARY] -GO - -ALTER TABLE [phpbb_styles_imageset] WITH NOCHECK ADD - CONSTRAINT [PK_phpbb_styles_imageset] PRIMARY KEY CLUSTERED - ( - [imageset_id] - ) ON [PRIMARY] -GO - -ALTER TABLE [phpbb_styles_template] WITH NOCHECK ADD - CONSTRAINT [PK_phpbb_styles_template] PRIMARY KEY CLUSTERED - ( - [template_id] - ) ON [PRIMARY] -GO - -ALTER TABLE [phpbb_styles_theme] WITH NOCHECK ADD - CONSTRAINT [PK_phpbb_styles_theme] PRIMARY KEY CLUSTERED - ( - [theme_id] - ) ON [PRIMARY] -GO - -ALTER TABLE [phpbb_topics] WITH NOCHECK ADD - CONSTRAINT [PK_phpbb_topics] PRIMARY KEY CLUSTERED - ( - [topic_id] - ) ON [PRIMARY] -GO - -ALTER TABLE [phpbb_topics_marking] WITH NOCHECK ADD - CONSTRAINT [PK_phpbb_topics_marking] PRIMARY KEY CLUSTERED - ( - [user_id], - [topic_id] - ) ON [PRIMARY] -GO - -ALTER TABLE [phpbb_topics_posted] WITH NOCHECK ADD - CONSTRAINT [PK_phpbb_topics_posted] PRIMARY KEY CLUSTERED - ( - [user_id], - [topic_id] - ) ON [PRIMARY] -GO - ALTER TABLE [phpbb_users] WITH NOCHECK ADD CONSTRAINT [PK_phpbb_users] PRIMARY KEY CLUSTERED ( @@ -1185,446 +2049,6 @@ ALTER TABLE [phpbb_users] WITH NOCHECK ADD ) ON [PRIMARY] GO -ALTER TABLE [phpbb_warnings] WITH NOCHECK ADD - CONSTRAINT [PK_phpbb_warnings] PRIMARY KEY CLUSTERED - ( - [warning_id] - ) ON [PRIMARY] -GO - -ALTER TABLE [phpbb_words] WITH NOCHECK ADD - CONSTRAINT [PK_phpbb_words] PRIMARY KEY CLUSTERED - ( - [word_id] - ) ON [PRIMARY] -GO - -ALTER TABLE [phpbb_attachments] WITH NOCHECK ADD - CONSTRAINT [DF_attach_post_msg_id] DEFAULT (0) FOR [post_msg_id], - CONSTRAINT [DF_attach_topic_id] DEFAULT (0) FOR [topic_id], - CONSTRAINT [DF_attach_in_message] DEFAULT (0) FOR [in_message], - CONSTRAINT [DF_attach_poster_id] DEFAULT (0) FOR [poster_id], - CONSTRAINT [DF_attach_download_count] DEFAULT (0) FOR [download_count], - CONSTRAINT [DF_attach_filesize] DEFAULT (0) FOR [filesize], - CONSTRAINT [DF_attach_filetime] DEFAULT (0) FOR [filetime], - CONSTRAINT [DF_attach_thumbnail] DEFAULT (0) FOR [thumbnail] -GO - -ALTER TABLE [phpbb_auth_groups] WITH NOCHECK ADD - CONSTRAINT [DF_auth_g_group_id] DEFAULT (0) FOR [group_id], - CONSTRAINT [DF_auth_g_forum_id] DEFAULT (0) FOR [forum_id], - CONSTRAINT [DF_auth_g_auth_option_id] DEFAULT (0) FOR [auth_option_id], - CONSTRAINT [DF_auth_g_auth_setting] DEFAULT (0) FOR [auth_setting] -GO - -ALTER TABLE [phpbb_auth_options] WITH NOCHECK ADD - CONSTRAINT [DF_auth_o_is_global] DEFAULT (0) FOR [is_global], - CONSTRAINT [DF_auth_o_is_local] DEFAULT (0) FOR [is_local], - CONSTRAINT [DF_auth_o_founder_only] DEFAULT (0) FOR [founder_only] -GO - -ALTER TABLE [phpbb_auth_roles] WITH NOCHECK ADD - CONSTRAINT [DF_auth_p_role_group_ids] DEFAULT ('') FOR [role_group_ids] -GO - -ALTER TABLE [phpbb_auth_roles_data] WITH NOCHECK ADD - CONSTRAINT [DF_auth_d_role_id] DEFAULT (0) FOR [role_id], - CONSTRAINT [DF_auth_d_auth_option_id] DEFAULT (0) FOR [auth_option_id], - CONSTRAINT [DF_auth_d_auth_setting] DEFAULT (0) FOR [auth_setting] -GO - -ALTER TABLE [phpbb_auth_users] WITH NOCHECK ADD - CONSTRAINT [DF_auth_u_user_id] DEFAULT (0) FOR [user_id], - CONSTRAINT [DF_auth_u_forum_id] DEFAULT (0) FOR [forum_id], - CONSTRAINT [DF_auth_u_auth_option_id] DEFAULT (0) FOR [auth_option_id], - CONSTRAINT [DF_auth_u_auth_setting] DEFAULT (0) FOR [auth_setting] -GO - -ALTER TABLE [phpbb_banlist] WITH NOCHECK ADD - CONSTRAINT [DF_banlis_ban_userid] DEFAULT (0) FOR [ban_userid], - CONSTRAINT [DF_banlis_ban_start] DEFAULT (0) FOR [ban_start], - CONSTRAINT [DF_banlis_ban_end] DEFAULT (0) FOR [ban_end], - CONSTRAINT [DF_banlis_ban_exclude] DEFAULT (0) FOR [ban_exclude] -GO - -ALTER TABLE [phpbb_bbcodes] WITH NOCHECK ADD - CONSTRAINT [DF_bbcode_bbcode_id] DEFAULT (0) FOR [bbcode_id], - CONSTRAINT [DF_bbcode_display_on_posting] DEFAULT (0) FOR [display_on_posting] -GO - -ALTER TABLE [phpbb_bookmarks] WITH NOCHECK ADD - CONSTRAINT [DF_bookma_topic_id] DEFAULT (0) FOR [topic_id], - CONSTRAINT [DF_bookma_user_id] DEFAULT (0) FOR [user_id], - CONSTRAINT [DF_bookma_order_id] DEFAULT (0) FOR [order_id] -GO - -ALTER TABLE [phpbb_bots] WITH NOCHECK ADD - CONSTRAINT [DF_bots___bot_active] DEFAULT (1) FOR [bot_active], - CONSTRAINT [DF_bots___user_id] DEFAULT (0) FOR [user_id] -GO - -ALTER TABLE [phpbb_cache] WITH NOCHECK ADD - CONSTRAINT [DF_cache__var_expires] DEFAULT (0) FOR [var_expires] -GO - -ALTER TABLE [phpbb_config] WITH NOCHECK ADD - CONSTRAINT [DF_config_is_dynamic] DEFAULT (0) FOR [is_dynamic] -GO - -ALTER TABLE [phpbb_confirm] WITH NOCHECK ADD - CONSTRAINT [DF_confirm_confirm_type] DEFAULT (0) FOR [confirm_type] -GO - -ALTER TABLE [phpbb_drafts] WITH NOCHECK ADD - CONSTRAINT [DF_drafts_user_id] DEFAULT (0) FOR [user_id], - CONSTRAINT [DF_drafts_topic_id] DEFAULT (0) FOR [topic_id], - CONSTRAINT [DF_drafts_forum_id] DEFAULT (0) FOR [forum_id], - CONSTRAINT [DF_drafts_save_time] DEFAULT (0) FOR [save_time] -GO - -ALTER TABLE [phpbb_extension_groups] WITH NOCHECK ADD - CONSTRAINT [DF_extens_cat_id] DEFAULT (0) FOR [cat_id], - CONSTRAINT [DF_extens_allow_group] DEFAULT (0) FOR [allow_group], - CONSTRAINT [DF_extens_download_mode] DEFAULT (1) FOR [download_mode], - CONSTRAINT [DF_extens_max_filesize] DEFAULT (0) FOR [max_filesize], - CONSTRAINT [DF_extens_allow_in_pm] DEFAULT (0) FOR [allow_in_pm] -GO - -ALTER TABLE [phpbb_extensions] WITH NOCHECK ADD - CONSTRAINT [DF_extens_group_id] DEFAULT (0) FOR [group_id] -GO - -ALTER TABLE [phpbb_forum_access] WITH NOCHECK ADD - CONSTRAINT [DF_forum__forum_id] DEFAULT (0) FOR [forum_id], - CONSTRAINT [DF_forum__user_id] DEFAULT (0) FOR [user_id] -GO - -ALTER TABLE [phpbb_forums] WITH NOCHECK ADD - CONSTRAINT [DF_forums_parent_id] DEFAULT (0) FOR [parent_id], - CONSTRAINT [DF_forums_left_id] DEFAULT (0) FOR [left_id], - CONSTRAINT [DF_forums_right_id] DEFAULT (0) FOR [right_id], - CONSTRAINT [DF_forums_desc_bitfield] DEFAULT (0) FOR [forum_desc_bitfield], - CONSTRAINT [DF_forums_rules_bitfield] DEFAULT (0) FOR [forum_rules_bitfield], - CONSTRAINT [DF_forums_topics_per_page] DEFAULT (0) FOR [forum_topics_per_page], - CONSTRAINT [DF_forums_forum_type] DEFAULT (0) FOR [forum_type], - CONSTRAINT [DF_forums_forum_status] DEFAULT (0) FOR [forum_status], - CONSTRAINT [DF_forums_forum_posts] DEFAULT (0) FOR [forum_posts], - CONSTRAINT [DF_forums_forum_topics] DEFAULT (0) FOR [forum_topics], - CONSTRAINT [DF_forums_forum_topics_real] DEFAULT (0) FOR [forum_topics_real], - CONSTRAINT [DF_forums_forum_last_post_id] DEFAULT (0) FOR [forum_last_post_id], - CONSTRAINT [DF_forums_forum_last_poster_id] DEFAULT (0) FOR [forum_last_poster_id], - CONSTRAINT [DF_forums_forum_last_post_time] DEFAULT (0) FOR [forum_last_post_time], - CONSTRAINT [DF_forums_forum_flags] DEFAULT (0) FOR [forum_flags], - CONSTRAINT [DF_forums_display_on_index] DEFAULT (1) FOR [display_on_index], - CONSTRAINT [DF_forums_enable_indexing] DEFAULT (1) FOR [enable_indexing], - CONSTRAINT [DF_forums_enable_icons] DEFAULT (1) FOR [enable_icons], - CONSTRAINT [DF_forums_enable_prune] DEFAULT (0) FOR [enable_prune], - CONSTRAINT [DF_forums_prune_days] DEFAULT (0) FOR [prune_days], - CONSTRAINT [DF_forums_prune_viewed] DEFAULT (0) FOR [prune_viewed], - CONSTRAINT [DF_forums_prune_freq] DEFAULT (0) FOR [prune_freq] -GO - -ALTER TABLE [phpbb_forums_marking] WITH NOCHECK ADD - CONSTRAINT [DF_forumm_user_id] DEFAULT (0) FOR [user_id], - CONSTRAINT [DF_forumm_forum_id] DEFAULT (0) FOR [forum_id], - CONSTRAINT [DF_forumm_mark_time] DEFAULT (0) FOR [mark_time] -GO - -ALTER TABLE [phpbb_forums_watch] WITH NOCHECK ADD - CONSTRAINT [DF_forumw_forum_id] DEFAULT (0) FOR [forum_id], - CONSTRAINT [DF_forumw_user_id] DEFAULT (0) FOR [user_id], - CONSTRAINT [DF_forumw_notify_status] DEFAULT (0) FOR [notify_status] -GO - -ALTER TABLE [phpbb_groups] WITH NOCHECK ADD - CONSTRAINT [DF_groups_group_type] DEFAULT (1) FOR [group_type], - CONSTRAINT [DF_groups_group_display] DEFAULT (0) FOR [group_display], - CONSTRAINT [DF_groups_group_desc_bitfield] DEFAULT (0) FOR [group_desc_bitfield], - CONSTRAINT [DF_groups_group_avatar_type] DEFAULT (0) FOR [group_avatar_type], - CONSTRAINT [DF_groups_group_avatar_width] DEFAULT (0) FOR [group_avatar_width], - CONSTRAINT [DF_groups_group_avatar_height] DEFAULT (0) FOR [group_avatar_height], - CONSTRAINT [DF_groups_group_rank] DEFAULT ((-1)) FOR [group_rank], - CONSTRAINT [DF_groups_group_sig_chars] DEFAULT (0) FOR [group_sig_chars], - CONSTRAINT [DF_groups_group_receive_pm] DEFAULT (0) FOR [group_receive_pm], - CONSTRAINT [DF_groups_group_message_limit] DEFAULT (0) FOR [group_message_limit], - CONSTRAINT [DF_groups_group_chgpass] DEFAULT (0) FOR [group_chgpass], - CONSTRAINT [DF_groups_group_legend] DEFAULT (1) FOR [group_legend] -GO - -ALTER TABLE [phpbb_icons] WITH NOCHECK ADD - CONSTRAINT [DF_icons__icons_width] DEFAULT (0) FOR [icons_width], - CONSTRAINT [DF_icons__icons_height] DEFAULT (0) FOR [icons_height], - CONSTRAINT [DF_icons__icons_order] DEFAULT (0) FOR [icons_order], - CONSTRAINT [DF_icons__display_on_posting] DEFAULT (1) FOR [display_on_posting] -GO - -ALTER TABLE [phpbb_log] WITH NOCHECK ADD - CONSTRAINT [DF_log____log_type] DEFAULT (0) FOR [log_type], - CONSTRAINT [DF_log____user_id] DEFAULT (0) FOR [user_id], - CONSTRAINT [DF_log____forum_id] DEFAULT (0) FOR [forum_id], - CONSTRAINT [DF_log____topic_id] DEFAULT (0) FOR [topic_id], - CONSTRAINT [DF_log____reportee_id] DEFAULT (0) FOR [reportee_id], - CONSTRAINT [DF_log____log_time] DEFAULT (0) FOR [log_time] -GO - -ALTER TABLE [phpbb_moderator_cache] WITH NOCHECK ADD - CONSTRAINT [DF_modera_forum_id] DEFAULT (0) FOR [forum_id], - CONSTRAINT [DF_modera_user_id] DEFAULT (0) FOR [user_id], - CONSTRAINT [DF_modera_group_id] DEFAULT (0) FOR [group_id], - CONSTRAINT [DF_modera_display_on_index] DEFAULT (1) FOR [display_on_index] -GO - -ALTER TABLE [phpbb_modules] WITH NOCHECK ADD - CONSTRAINT [DF_module_module_enabled] DEFAULT (1) FOR [module_enabled] -GO - -ALTER TABLE [phpbb_modules] WITH NOCHECK ADD - CONSTRAINT [DF_module_module_display] DEFAULT (1) FOR [module_display] -GO - -ALTER TABLE [phpbb_poll_results] WITH NOCHECK ADD - CONSTRAINT [DF_poll_r_poll_option_id] DEFAULT (0) FOR [poll_option_id], - CONSTRAINT [DF_poll_r_topic_id] DEFAULT (0) FOR [topic_id], - CONSTRAINT [DF_poll_r_poll_option_total] DEFAULT (0) FOR [poll_option_total] -GO - -ALTER TABLE [phpbb_poll_voters] WITH NOCHECK ADD - CONSTRAINT [DF_poll_v_topic_id] DEFAULT (0) FOR [topic_id], - CONSTRAINT [DF_poll_v_poll_option_id] DEFAULT (0) FOR [poll_option_id], - CONSTRAINT [DF_poll_v_vote_user_id] DEFAULT (0) FOR [vote_user_id] -GO - -ALTER TABLE [phpbb_posts] WITH NOCHECK ADD - CONSTRAINT [DF_posts__topic_id] DEFAULT (0) FOR [topic_id], - CONSTRAINT [DF_posts__forum_id] DEFAULT (0) FOR [forum_id], - CONSTRAINT [DF_posts__poster_id] DEFAULT (0) FOR [poster_id], - CONSTRAINT [DF_posts__icon_id] DEFAULT (1) FOR [icon_id], - CONSTRAINT [DF_posts__post_time] DEFAULT (0) FOR [post_time], - CONSTRAINT [DF_posts__post_approved] DEFAULT (1) FOR [post_approved], - CONSTRAINT [DF_posts__post_reported] DEFAULT (0) FOR [post_reported], - CONSTRAINT [DF_posts__enable_bbcode] DEFAULT (1) FOR [enable_bbcode], - CONSTRAINT [DF_posts__enable_smilies] DEFAULT (1) FOR [enable_smilies], - CONSTRAINT [DF_posts__enable_magic_url] DEFAULT (1) FOR [enable_magic_url], - CONSTRAINT [DF_posts__enable_sig] DEFAULT (1) FOR [enable_sig], - CONSTRAINT [DF_posts__post_encoding] DEFAULT ('iso-8859-1') FOR [post_encoding], - CONSTRAINT [DF_posts__post_attachment] DEFAULT (0) FOR [post_attachment], - CONSTRAINT [DF_posts__bbcode_bitfield] DEFAULT (0) FOR [bbcode_bitfield], - CONSTRAINT [DF_posts__post_edit_time] DEFAULT (0) FOR [post_edit_time], - CONSTRAINT [DF_posts__post_edit_user] DEFAULT (0) FOR [post_edit_user], - CONSTRAINT [DF_posts__post_edit_count] DEFAULT (0) FOR [post_edit_count], - CONSTRAINT [DF_posts__post_edit_locked] DEFAULT (0) FOR [post_edit_locked] -GO - -ALTER TABLE [phpbb_privmsgs] WITH NOCHECK ADD - CONSTRAINT [DF_privms_root_level] DEFAULT (0) FOR [root_level], - CONSTRAINT [DF_privms_author_id] DEFAULT (0) FOR [author_id], - CONSTRAINT [DF_privms_icon_id] DEFAULT (1) FOR [icon_id], - CONSTRAINT [DF_privms_message_time] DEFAULT (0) FOR [message_time], - CONSTRAINT [DF_privms_enable_bbcode] DEFAULT (1) FOR [enable_bbcode], - CONSTRAINT [DF_privms_enable_smilies] DEFAULT (1) FOR [enable_smilies], - CONSTRAINT [DF_privms_enable_magic_url] DEFAULT (1) FOR [enable_magic_url], - CONSTRAINT [DF_privms_enable_sig] DEFAULT (1) FOR [enable_sig], - CONSTRAINT [DF_privms_message_edit_user] DEFAULT (0) FOR [message_edit_user], - CONSTRAINT [DF_privms_message_encoding] DEFAULT ('iso-8859-1') FOR [message_encoding], - CONSTRAINT [DF_privms_message_attachment] DEFAULT (0) FOR [message_attachment], - CONSTRAINT [DF_privms_bbcode_bitfield] DEFAULT (0) FOR [bbcode_bitfield], - CONSTRAINT [DF_privms_message_edit_time] DEFAULT (0) FOR [message_edit_time], - CONSTRAINT [DF_privms_message_edit_count] DEFAULT (0) FOR [message_edit_count] -GO - -ALTER TABLE [phpbb_privmsgs_folder] WITH NOCHECK ADD - CONSTRAINT [DF_pmfold_user_id] DEFAULT (0) FOR [user_id], - CONSTRAINT [DF_pmfold_pm_count] DEFAULT (0) FOR [pm_count] -GO - -ALTER TABLE [phpbb_privmsgs_rules] WITH NOCHECK ADD - CONSTRAINT [DF_pmrule_user_id] DEFAULT (0) FOR [user_id], - CONSTRAINT [DF_pmrule_rule_check] DEFAULT (0) FOR [rule_check], - CONSTRAINT [DF_pmrule_rule_connection] DEFAULT (0) FOR [rule_connection], - CONSTRAINT [DF_pmrule_rule_user_id] DEFAULT (0) FOR [rule_user_id], - CONSTRAINT [DF_pmrule_rule_group_id] DEFAULT (0) FOR [rule_group_id], - CONSTRAINT [DF_pmrule_rule_action] DEFAULT (0) FOR [rule_action], - CONSTRAINT [DF_pmrule_rule_folder_id] DEFAULT (0) FOR [rule_folder_id] -GO - -ALTER TABLE [phpbb_privmsgs_to] WITH NOCHECK ADD - CONSTRAINT [DF_pmto___msg_id] DEFAULT (0) FOR [msg_id], - CONSTRAINT [DF_pmto___user_id] DEFAULT (0) FOR [user_id], - CONSTRAINT [DF_pmto___author_id] DEFAULT (0) FOR [author_id], - CONSTRAINT [DF_pmto___deleted] DEFAULT (0) FOR [deleted], - CONSTRAINT [DF_pmto___new] DEFAULT (1) FOR [new], - CONSTRAINT [DF_pmto___unread] DEFAULT (1) FOR [unread], - CONSTRAINT [DF_pmto___replied] DEFAULT (0) FOR [replied], - CONSTRAINT [DF_pmto___marked] DEFAULT (0) FOR [marked], - CONSTRAINT [DF_pmto___forwarded] DEFAULT (0) FOR [forwarded], - CONSTRAINT [DF_pmto___folder_id] DEFAULT (0) FOR [folder_id] -GO - -ALTER TABLE [phpbb_profile_fields] WITH NOCHECK ADD - CONSTRAINT [DF_pffiel_field_type] DEFAULT (0) FOR [field_type], - CONSTRAINT [DF_pffiel_field_default_value] DEFAULT ('0') FOR [field_default_value], - CONSTRAINT [DF_pffiel_field_required] DEFAULT (0) FOR [field_required], - CONSTRAINT [DF_pffiel_field_show_on_reg] DEFAULT (0) FOR [field_show_on_reg], - CONSTRAINT [DF_pffiel_field_hide] DEFAULT (0) FOR [field_hide], - CONSTRAINT [DF_pffiel_field_no_view] DEFAULT (0) FOR [field_no_view], - CONSTRAINT [DF_pffiel_field_active] DEFAULT (0) FOR [field_active], - CONSTRAINT [DF_pffiel_field_order] DEFAULT (0) FOR [field_order] -GO - -ALTER TABLE [phpbb_profile_fields_data] WITH NOCHECK ADD - CONSTRAINT [DF_pfdata_user_id] DEFAULT (0) FOR [user_id] -GO - -ALTER TABLE [phpbb_profile_fields_lang] WITH NOCHECK ADD - CONSTRAINT [DF_pfflan_field_id] DEFAULT (0) FOR [field_id], - CONSTRAINT [DF_pfflan_lang_id] DEFAULT (0) FOR [lang_id], - CONSTRAINT [DF_pfflan_option_id] DEFAULT (0) FOR [option_id], - CONSTRAINT [DF_pfflan_field_type] DEFAULT (0) FOR [field_type] -GO - -ALTER TABLE [phpbb_profile_lang] WITH NOCHECK ADD - CONSTRAINT [DF_pflang_field_id] DEFAULT (0) FOR [field_id], - CONSTRAINT [DF_pflang_lang_id] DEFAULT (0) FOR [lang_id] -GO - -ALTER TABLE [phpbb_ranks] WITH NOCHECK ADD - CONSTRAINT [DF_ranks__rank_min] DEFAULT (0) FOR [rank_min], - CONSTRAINT [DF_ranks__rank_special] DEFAULT (0) FOR [rank_special] -GO - -ALTER TABLE [phpbb_reports] WITH NOCHECK ADD - CONSTRAINT [DF_report_reason_id] DEFAULT (0) FOR [reason_id], - CONSTRAINT [DF_report_post_id] DEFAULT (0) FOR [post_id], - CONSTRAINT [DF_report_user_id] DEFAULT (0) FOR [user_id], - CONSTRAINT [DF_report_user_notify] DEFAULT (0) FOR [user_notify], - CONSTRAINT [DF_report_report_closed] DEFAULT (0) FOR [report_closed], - CONSTRAINT [DF_report_report_time] DEFAULT (0) FOR [report_time] -GO - -ALTER TABLE [phpbb_reports_reasons] WITH NOCHECK ADD - CONSTRAINT [DF_reporr_reason_order] DEFAULT (0) FOR [reason_order] -GO - -ALTER TABLE [phpbb_search_results] WITH NOCHECK ADD - CONSTRAINT [DF_search_search_time] DEFAULT (0) FOR [search_time] -GO - -ALTER TABLE [phpbb_search_wordlist] WITH NOCHECK ADD - CONSTRAINT [DF_swlist_word_common] DEFAULT (0) FOR [word_common] -GO - -ALTER TABLE [phpbb_search_wordmatch] WITH NOCHECK ADD - CONSTRAINT [DF_swmatc_post_id] DEFAULT (0) FOR [post_id], - CONSTRAINT [DF_swmatc_word_id] DEFAULT (0) FOR [word_id], - CONSTRAINT [DF_swmatc_title_match] DEFAULT (0) FOR [title_match] -GO - -ALTER TABLE [phpbb_sessions] WITH NOCHECK ADD - CONSTRAINT [DF_sessio_session_user_id] DEFAULT (0) FOR [session_user_id], - CONSTRAINT [DF_sessio_session_last_visit] DEFAULT (0) FOR [session_last_visit], - CONSTRAINT [DF_sessio_session_start] DEFAULT (0) FOR [session_start], - CONSTRAINT [DF_sessio_session_time] DEFAULT (0) FOR [session_time], - CONSTRAINT [DF_sessio_session_ip] DEFAULT ('0') FOR [session_ip], - CONSTRAINT [DF_sessio_session_viewonline] DEFAULT (1) FOR [session_viewonline], - CONSTRAINT [DF_sessio_session_autologin] DEFAULT (0) FOR [session_autologin], - CONSTRAINT [DF_sessio_session_admin] DEFAULT (0) FOR [session_admin] -GO - -ALTER TABLE [phpbb_sessions_keys] WITH NOCHECK ADD - CONSTRAINT [DF_sessik_key_id] DEFAULT ('0') FOR [key_id], - CONSTRAINT [DF_sessik_user_id] DEFAULT (0) FOR [user_id], - CONSTRAINT [DF_sessik_last_ip] DEFAULT ('0') FOR [last_ip], - CONSTRAINT [DF_sessik_last_login] DEFAULT (0) FOR [last_login] -GO - -ALTER TABLE [phpbb_sitelist] WITH NOCHECK ADD - CONSTRAINT [DF_siteli_ip_exclude] DEFAULT (0) FOR [ip_exclude] -GO - -ALTER TABLE [phpbb_smilies] WITH NOCHECK ADD - CONSTRAINT [DF_smilie_smiley_width] DEFAULT (0) FOR [smiley_width], - CONSTRAINT [DF_smilie_smiley_height] DEFAULT (0) FOR [smiley_height], - CONSTRAINT [DF_smilie_smiley_order] DEFAULT (0) FOR [smiley_order], - CONSTRAINT [DF_smilie_display_on_posting] DEFAULT (1) FOR [display_on_posting] -GO - -ALTER TABLE [phpbb_styles] WITH NOCHECK ADD - CONSTRAINT [DF_styles_style_active] DEFAULT (1) FOR [style_active], - CONSTRAINT [DF_styles_template_id] DEFAULT (0) FOR [template_id], - CONSTRAINT [DF_styles_theme_id] DEFAULT (0) FOR [theme_id], - CONSTRAINT [DF_styles_imageset_id] DEFAULT (0) FOR [imageset_id] -GO - -ALTER TABLE [phpbb_styles_template] WITH NOCHECK ADD - CONSTRAINT [DF_templa_bbcode_bitfield] DEFAULT (0) FOR [bbcode_bitfield], - CONSTRAINT [DF_templa_template_storedb] DEFAULT (0) FOR [template_storedb] -GO - -ALTER TABLE [phpbb_styles_template_data] WITH NOCHECK ADD - CONSTRAINT [DF_tpldat_template_id] DEFAULT (0) FOR [template_id], - CONSTRAINT [DF_tpldat_template_mtime] DEFAULT (0) FOR [template_mtime] -GO - -ALTER TABLE [phpbb_styles_theme] WITH NOCHECK ADD - CONSTRAINT [DF_theme__theme_storedb] DEFAULT (0) FOR [theme_storedb], - CONSTRAINT [DF_theme__theme_mtime] DEFAULT (0) FOR [theme_mtime] -GO - -ALTER TABLE [phpbb_topics] WITH NOCHECK ADD - CONSTRAINT [DF_topics_forum_id] DEFAULT (0) FOR [forum_id], - CONSTRAINT [DF_topics_icon_id] DEFAULT (1) FOR [icon_id], - CONSTRAINT [DF_topics_topic_attachment] DEFAULT (0) FOR [topic_attachment], - CONSTRAINT [DF_topics_topic_approved] DEFAULT (1) FOR [topic_approved], - CONSTRAINT [DF_topics_topic_reported] DEFAULT (0) FOR [topic_reported], - CONSTRAINT [DF_topics_topic_poster] DEFAULT (0) FOR [topic_poster], - CONSTRAINT [DF_topics_topic_time] DEFAULT (0) FOR [topic_time], - CONSTRAINT [DF_topics_topic_time_limit] DEFAULT (0) FOR [topic_time_limit], - CONSTRAINT [DF_topics_topic_views] DEFAULT (0) FOR [topic_views], - CONSTRAINT [DF_topics_topic_replies] DEFAULT (0) FOR [topic_replies], - CONSTRAINT [DF_topics_topic_replies_real] DEFAULT (0) FOR [topic_replies_real], - CONSTRAINT [DF_topics_topic_status] DEFAULT (0) FOR [topic_status], - CONSTRAINT [DF_topics_topic_type] DEFAULT (0) FOR [topic_type], - CONSTRAINT [DF_topics_topic_first_post_id] DEFAULT (0) FOR [topic_first_post_id], - CONSTRAINT [DF_topics_topic_last_post_id] DEFAULT (0) FOR [topic_last_post_id], - CONSTRAINT [DF_topics_topic_last_poster_id] DEFAULT (0) FOR [topic_last_poster_id], - CONSTRAINT [DF_topics_topic_last_post_time] DEFAULT (0) FOR [topic_last_post_time], - CONSTRAINT [DF_topics_topic_last_view_time] DEFAULT (0) FOR [topic_last_view_time], - CONSTRAINT [DF_topics_topic_moved_id] DEFAULT (0) FOR [topic_moved_id], - CONSTRAINT [DF_topics_topic_bumped] DEFAULT (0) FOR [topic_bumped], - CONSTRAINT [DF_topics_topic_bumper] DEFAULT (0) FOR [topic_bumper], - CONSTRAINT [DF_topics_poll_title] DEFAULT ('') FOR [poll_title], - CONSTRAINT [DF_topics_poll_start] DEFAULT (0) FOR [poll_start], - CONSTRAINT [DF_topics_poll_length] DEFAULT (0) FOR [poll_length], - CONSTRAINT [DF_topics_poll_max_options] DEFAULT (1) FOR [poll_max_options], - CONSTRAINT [DF_topics_poll_last_vote] DEFAULT (0) FOR [poll_last_vote], - CONSTRAINT [DF_topics_poll_vote_change] DEFAULT (0) FOR [poll_vote_change] -GO - -ALTER TABLE [phpbb_topics_marking] WITH NOCHECK ADD - CONSTRAINT [DF_tmarki_user_id] DEFAULT (0) FOR [user_id], - CONSTRAINT [DF_tmarki_topic_id] DEFAULT (0) FOR [topic_id], - CONSTRAINT [DF_tmarki_forum_id] DEFAULT (0) FOR [forum_id], - CONSTRAINT [DF_tmarki_mark_time] DEFAULT (0) FOR [mark_time] -GO - -ALTER TABLE [phpbb_topics_posted] WITH NOCHECK ADD - CONSTRAINT [DF_tposte_user_id] DEFAULT (0) FOR [user_id], - CONSTRAINT [DF_tposte_topic_id] DEFAULT (0) FOR [topic_id], - CONSTRAINT [DF_tposte_topic_posted] DEFAULT (0) FOR [topic_posted] -GO - -ALTER TABLE [phpbb_topics_watch] WITH NOCHECK ADD - CONSTRAINT [DF_twatch_topic_id] DEFAULT (0) FOR [topic_id], - CONSTRAINT [DF_twatch_user_id] DEFAULT (0) FOR [user_id], - CONSTRAINT [DF_twatch_notify_status] DEFAULT (0) FOR [notify_status] -GO - -ALTER TABLE [phpbb_user_group] WITH NOCHECK ADD - CONSTRAINT [DF_usersg_group_id] DEFAULT (0) FOR [group_id], - CONSTRAINT [DF_usersg_user_id] DEFAULT (0) FOR [user_id], - CONSTRAINT [DF_usersg_group_leader] DEFAULT (0) FOR [group_leader] -GO - ALTER TABLE [phpbb_users] WITH NOCHECK ADD CONSTRAINT [DF_users__user_type] DEFAULT (0) FOR [user_type], CONSTRAINT [DF_users__group_id] DEFAULT (3) FOR [group_id], @@ -1670,258 +2094,77 @@ ALTER TABLE [phpbb_users] WITH NOCHECK ADD CONSTRAINT [DF_users__user_sig_bbcode_bitf] DEFAULT (0) FOR [user_sig_bbcode_bitfield] GO -ALTER TABLE [phpbb_warnings] WITH NOCHECK ADD - CONSTRAINT [DF_warnings__user_id] DEFAULT (0) FOR [user_id], - CONSTRAINT [DF_warnings__post_id] DEFAULT (0) FOR [post_id], - CONSTRAINT [DF_warnings__log_id] DEFAULT (0) FOR [log_id], - CONSTRAINT [DF_warnings__warning_time] DEFAULT (0) FOR [warning_time] -GO - -ALTER TABLE [phpbb_zebra] WITH NOCHECK ADD - CONSTRAINT [DF_zebra__user_id] DEFAULT (0) FOR [user_id], - CONSTRAINT [DF_zebra__zebra_id] DEFAULT (0) FOR [zebra_id], - CONSTRAINT [DF_zebra__friend] DEFAULT (0) FOR [friend], - CONSTRAINT [DF_zebra__foe] DEFAULT (0) FOR [foe] -GO - -CREATE INDEX [filetime] ON [phpbb_attachments]([filetime]) ON [PRIMARY] -GO - -CREATE INDEX [post_msg_id] ON [phpbb_attachments]([post_msg_id]) ON [PRIMARY] -GO - -CREATE INDEX [topic_id] ON [phpbb_attachments]([topic_id]) ON [PRIMARY] -GO - -CREATE INDEX [poster_id] ON [phpbb_attachments]([poster_id]) ON [PRIMARY] -GO - -CREATE INDEX [physical_filename] ON [phpbb_attachments]([physical_filename]) ON [PRIMARY] -GO - -CREATE INDEX [filesize] ON [phpbb_attachments]([filesize]) ON [PRIMARY] -GO - -CREATE INDEX [group_id] ON [phpbb_auth_groups]([group_id]) ON [PRIMARY] -GO - -CREATE INDEX [auth_option_id] ON [phpbb_auth_groups]([auth_option_id]) ON [PRIMARY] -GO - -CREATE INDEX [auth_option] ON [phpbb_auth_options]([auth_option]) ON [PRIMARY] -GO - -CREATE INDEX [role_type] ON [phpbb_auth_roles]([role_type]) ON [PRIMARY] -GO - -CREATE INDEX [user_id] ON [phpbb_auth_users]([user_id]) ON [PRIMARY] -GO - -CREATE INDEX [auth_option_id] ON [phpbb_auth_users]([auth_option_id]) ON [PRIMARY] -GO - -CREATE INDEX [order_id] ON [phpbb_bookmarks]([order_id]) ON [PRIMARY] -GO - -CREATE INDEX [topic_user_id] ON [phpbb_bookmarks]([topic_id], [user_id]) ON [PRIMARY] -GO - -CREATE INDEX [bot_active] ON [phpbb_bots]([bot_active]) ON [PRIMARY] -GO - -CREATE INDEX [is_dynamic] ON [phpbb_config]([is_dynamic]) ON [PRIMARY] -GO - -CREATE INDEX [display_on_posting] ON [phpbb_bbcodes]([display_on_posting]) ON [PRIMARY] -GO - -CREATE INDEX [save_time] ON [phpbb_drafts]([save_time]) ON [PRIMARY] -GO - -CREATE INDEX [left_right_id] ON [phpbb_forums]([left_id], [right_id]) ON [PRIMARY] -GO - -CREATE INDEX [forum_last_post_id] ON [phpbb_forums]([forum_last_post_id]) ON [PRIMARY] -GO - -CREATE INDEX [forum_id] ON [phpbb_forums_watch]([forum_id]) ON [PRIMARY] -GO - -CREATE INDEX [user_id] ON [phpbb_forums_watch]([user_id]) ON [PRIMARY] -GO - -CREATE INDEX [notify_status] ON [phpbb_forums_watch]([notify_status]) ON [PRIMARY] -GO - -CREATE INDEX [group_legend] ON [phpbb_groups]([group_legend]) ON [PRIMARY] -GO - -CREATE INDEX [log_type] ON [phpbb_log]([log_type]) ON [PRIMARY] -GO - -CREATE INDEX [forum_id] ON [phpbb_log]([forum_id]) ON [PRIMARY] -GO - -CREATE INDEX [topic_id] ON [phpbb_log]([topic_id]) ON [PRIMARY] -GO - -CREATE INDEX [reportee_id] ON [phpbb_log]([reportee_id]) ON [PRIMARY] -GO - -CREATE INDEX [user_id] ON [phpbb_log]([user_id]) ON [PRIMARY] -GO - -CREATE INDEX [display_on_index] ON [phpbb_moderator_cache]([display_on_index]) ON [PRIMARY] -GO - -CREATE INDEX [forum_id] ON [phpbb_moderator_cache]([forum_id]) ON [PRIMARY] -GO - -CREATE INDEX [module_enabled] ON [phpbb_modules]([module_enabled]) ON [PRIMARY] -GO - -CREATE INDEX [module_left_id] ON [phpbb_modules]([left_id]) ON [PRIMARY] -GO - -CREATE INDEX [poll_option_id] ON [phpbb_poll_results]([poll_option_id]) ON [PRIMARY] -GO - -CREATE INDEX [topic_id] ON [phpbb_poll_results]([topic_id]) ON [PRIMARY] -GO - -CREATE INDEX [topic_id] ON [phpbb_poll_voters]([topic_id]) ON [PRIMARY] -GO - -CREATE INDEX [vote_user_id] ON [phpbb_poll_voters]([vote_user_id]) ON [PRIMARY] -GO - -CREATE INDEX [vote_user_ip] ON [phpbb_poll_voters]([vote_user_ip]) ON [PRIMARY] -GO - -CREATE INDEX [forum_id] ON [phpbb_posts]([forum_id]) ON [PRIMARY] -GO - -CREATE INDEX [topic_id] ON [phpbb_posts]([topic_id]) ON [PRIMARY] -GO - -CREATE INDEX [poster_ip] ON [phpbb_posts]([poster_ip]) ON [PRIMARY] -GO - -CREATE INDEX [poster_id] ON [phpbb_posts]([poster_id]) ON [PRIMARY] -GO - -CREATE INDEX [post_approved] ON [phpbb_posts]([post_approved]) ON [PRIMARY] -GO - -CREATE INDEX [post_time] ON [phpbb_posts]([post_time]) ON [PRIMARY] -GO - -CREATE INDEX [author_ip] ON [phpbb_privmsgs]([author_ip]) ON [PRIMARY] -GO - -CREATE INDEX [message_time] ON [phpbb_privmsgs]([message_time]) ON [PRIMARY] -GO - -CREATE INDEX [author_id] ON [phpbb_privmsgs]([author_id]) ON [PRIMARY] -GO - -CREATE INDEX [root_level] ON [phpbb_privmsgs]([root_level]) ON [PRIMARY] -GO - -CREATE INDEX [user_id] ON [phpbb_privmsgs_folder]([user_id]) ON [PRIMARY] -GO - -CREATE INDEX [msg_id] ON [phpbb_privmsgs_to]([msg_id]) ON [PRIMARY] -GO - -CREATE INDEX [user_id] ON [phpbb_privmsgs_to]([user_id], [folder_id]) ON [PRIMARY] -GO - -CREATE INDEX [field_type] ON [phpbb_profile_fields]([field_type]) ON [PRIMARY] -GO - -CREATE INDEX [field_order] ON [phpbb_profile_fields]([field_order]) ON [PRIMARY] -GO - -CREATE INDEX [word_id] ON [phpbb_search_wordlist]([word_id]) ON [PRIMARY] -GO - -CREATE INDEX [word_id] ON [phpbb_search_wordmatch]([word_id]) ON [PRIMARY] -GO - -CREATE INDEX [session_time] ON [phpbb_sessions]([session_time]) ON [PRIMARY] -GO - -CREATE INDEX [session_user_id] ON [phpbb_sessions]([session_user_id]) ON [PRIMARY] -GO - -CREATE INDEX [last_login] ON [phpbb_sessions_keys]([last_login]) ON [PRIMARY] -GO - -CREATE UNIQUE INDEX [style_name] ON [phpbb_styles]([style_name]) ON [PRIMARY] -GO - -CREATE INDEX [template_id] ON [phpbb_styles]([template_id]) ON [PRIMARY] -GO - -CREATE INDEX [theme_id] ON [phpbb_styles]([theme_id]) ON [PRIMARY] -GO - -CREATE INDEX [imageset_id] ON [phpbb_styles]([imageset_id]) ON [PRIMARY] -GO - -CREATE UNIQUE INDEX [imageset_name] ON [phpbb_styles_imageset]([imageset_name]) ON [PRIMARY] -GO - -CREATE UNIQUE INDEX [template_name] ON [phpbb_styles_template]([template_name]) ON [PRIMARY] -GO - -CREATE INDEX [template_id] ON [phpbb_styles_template_data]([template_id]) ON [PRIMARY] -GO - -CREATE INDEX [template_filename] ON [phpbb_styles_template_data]([template_filename]) ON [PRIMARY] -GO - -CREATE UNIQUE INDEX [theme_name] ON [phpbb_styles_theme]([theme_name]) ON [PRIMARY] -GO - -CREATE INDEX [forum_id] ON [phpbb_topics]([forum_id]) ON [PRIMARY] +CREATE INDEX [user_birthday] ON [phpbb_users]([user_birthday]) ON [PRIMARY] GO -CREATE INDEX [forum_id_type] ON [phpbb_topics]([forum_id], [topic_type]) ON [PRIMARY] +CREATE INDEX [user_email_hash] ON [phpbb_users]([user_email_hash]) ON [PRIMARY] GO -CREATE INDEX [topic_last_post_time] ON [phpbb_topics]([topic_last_post_time]) ON [PRIMARY] +CREATE INDEX [username] ON [phpbb_users]([username]) ON [PRIMARY] GO -CREATE INDEX [forum_id] ON [phpbb_topics_marking]([forum_id]) ON [PRIMARY] -GO -CREATE INDEX [topic_id] ON [phpbb_topics_watch]([topic_id]) ON [PRIMARY] +/* + Table: phpbb_warnings +*/ +CREATE TABLE [phpbb_warnings] ( + [warning_id] [int] IDENTITY (1, 1) NOT NULL , + [user_id] [int] NOT NULL , + [post_id] [int] NOT NULL , + [log_id] [int] NOT NULL , + [warning_time] [int] NOT NULL +) ON [PRIMARY] GO -CREATE INDEX [user_id] ON [phpbb_topics_watch]([user_id]) ON [PRIMARY] +ALTER TABLE [phpbb_warnings] WITH NOCHECK ADD + CONSTRAINT [PK_phpbb_warnings] PRIMARY KEY CLUSTERED + ( + [warning_id] + ) ON [PRIMARY] GO -CREATE INDEX [notify_status] ON [phpbb_topics_watch]([notify_status]) ON [PRIMARY] +ALTER TABLE [phpbb_warnings] WITH NOCHECK ADD + CONSTRAINT [DF_warnings__user_id] DEFAULT (0) FOR [user_id], + CONSTRAINT [DF_warnings__post_id] DEFAULT (0) FOR [post_id], + CONSTRAINT [DF_warnings__log_id] DEFAULT (0) FOR [log_id], + CONSTRAINT [DF_warnings__warning_time] DEFAULT (0) FOR [warning_time] GO -CREATE INDEX [group_id] ON [phpbb_user_group]([group_id]) ON [PRIMARY] -GO -CREATE INDEX [user_id] ON [phpbb_user_group]([user_id]) ON [PRIMARY] +/* + Table: phpbb_words +*/ +CREATE TABLE [phpbb_words] ( + [word_id] [int] IDENTITY (1, 1) NOT NULL , + [word] [varchar] (100) NOT NULL , + [replacement] [varchar] (100) NOT NULL +) ON [PRIMARY] GO -CREATE INDEX [group_leader] ON [phpbb_user_group]([group_leader]) ON [PRIMARY] +ALTER TABLE [phpbb_words] WITH NOCHECK ADD + CONSTRAINT [PK_phpbb_words] PRIMARY KEY CLUSTERED + ( + [word_id] + ) ON [PRIMARY] GO -CREATE INDEX [user_birthday] ON [phpbb_users]([user_birthday]) ON [PRIMARY] -GO -CREATE INDEX [user_email_hash] ON [phpbb_users]([user_email_hash]) ON [PRIMARY] +/* + Table: phpbb_zebra +*/ +CREATE TABLE [phpbb_zebra] ( + [user_id] [int] NOT NULL , + [zebra_id] [int] NOT NULL , + [friend] [int] NOT NULL , + [foe] [int] NOT NULL +) ON [PRIMARY] GO -CREATE INDEX [username] ON [phpbb_users]([username]) ON [PRIMARY] +ALTER TABLE [phpbb_zebra] WITH NOCHECK ADD + CONSTRAINT [DF_zebra__user_id] DEFAULT (0) FOR [user_id], + CONSTRAINT [DF_zebra__zebra_id] DEFAULT (0) FOR [zebra_id], + CONSTRAINT [DF_zebra__friend] DEFAULT (0) FOR [friend], + CONSTRAINT [DF_zebra__foe] DEFAULT (0) FOR [foe] GO CREATE INDEX [user_id] ON [phpbb_zebra]([user_id]) ON [PRIMARY] @@ -1930,5 +2173,6 @@ GO CREATE INDEX [zebra_id] ON [phpbb_zebra]([zebra_id]) ON [PRIMARY] GO + COMMIT GO |