●架設主機作業系統：Windows2000 Server
●您的上網方式：ADSL
●您的 phpBB2 版本：phpBB 2.0.4
●錯誤狀態：我把整個phpbb2.04完全上傳好了,但phpbb2/install/schemas/***.sql檔全部都無法上傳,我該怎麼辦?
[問題]sql檔無法上傳該怎麼辦?
版主: 版主管理群
版面規則
本區是討論關於 phpBB 2.0.X 架設安裝上的問題，只要有安裝任何外掛，請到外掛討論相關版面按照公告格式發表。
(發表文章請按照公告格式發表，違者砍文)
本區是討論關於 phpBB 2.0.X 架設安裝上的問題，只要有安裝任何外掛，請到外掛討論相關版面按照公告格式發表。
(發表文章請按照公告格式發表，違者砍文)
[問題]sql檔無法上傳該怎麼辦?
最後由 超級訪客 於 2003-08-26 10:12 編輯，總共編輯了 1 次。
我執行了mssql_schema.sql,
但出現\r
執行其他的sql檔也出現錯誤,
我該怎麼辦?
但出現\r
代碼: 選擇全部
錯誤
SQL 語法 :
/* mssql_schema.sql for phpBB2 (c) 2001, phpBB Group $Id: mssql_schema.sql,v 1.1.2.3 2002/12/21 18:31:54 psotfx Exp $ */ BEGIN TRANSACTIONGO CREATE TABLE [phpbb_auth_access](
[group_id][int] NULL ,
[forum_id][int] NULL ,
[auth_view][smallint] NOT NULL ,
[auth_read][smallint] NOT NULL ,
[auth_post][smallint] NOT NULL ,
[auth_reply][smallint] NOT NULL ,
[auth_edit][smallint] NOT NULL ,
[auth_delete][smallint] NOT NULL ,
[auth_sticky][smallint] NOT NULL ,
[auth_announce][smallint] NOT NULL ,
[auth_vote][smallint] NOT NULL ,
[auth_pollcreate][smallint] NOT NULL ,
[auth_attachments][smallint] NOT NULL ,
[auth_mod][smallint] NOT NULL
) ON [ PRIMARY ]GO CREATE TABLE [phpbb_banlist](
[ban_id][int]IDENTITY( 1, 1 ) NOT NULL ,
[ban_userid][int] NULL ,
[ban_ip][char]( 8 ) NULL ,
[ban_email][varchar]( 50 ) NULL
) ON [ PRIMARY ]GO CREATE TABLE [phpbb_categories](
[cat_id][int]IDENTITY( 1, 1 ) NOT NULL ,
[cat_title][varchar]( 50 ) NOT NULL ,
[cat_order][int] NOT NULL
) ON [ PRIMARY ]GO CREATE TABLE [phpbb_config](
[config_name][varchar]( 255 ) NULL ,
[config_value][varchar]( 255 ) NULL
) ON [ PRIMARY ]GO CREATE TABLE [phpbb_disallow](
[disallow_id][int]IDENTITY( 1, 1 ) NOT NULL ,
[disallow_username][varchar]( 100 ) NULL
) ON [ PRIMARY ]GO CREATE TABLE [phpbb_forum_prune](
[prune_id][int]IDENTITY( 1, 1 ) NOT NULL ,
[forum_id][int] NOT NULL ,
[prune_days][int] NOT NULL ,
[prune_freq][int] NOT NULL
) ON [ PRIMARY ]GO CREATE TABLE [phpbb_forums](
[forum_id][int] NOT NULL ,
[cat_id][int] NOT NULL ,
[forum_name][varchar]( 100 ) NOT NULL ,
[forum_desc][varchar]( 255 ) NULL ,
[forum_status][smallint] NOT NULL ,
[forum_order][int] NOT NULL ,
[forum_posts][int] NOT NULL ,
[forum_topics][smallint] NOT NULL ,
[forum_last_post_id][int] NOT NULL ,
[prune_next][int] NULL ,
[prune_enable][smallint] NOT NULL ,
[auth_view][smallint] NOT NULL ,
[auth_read][smallint] NOT NULL ,
[auth_post][smallint] NOT NULL ,
[auth_reply][smallint] NOT NULL ,
[auth_edit][smallint] NOT NULL ,
[auth_delete][smallint] NOT NULL ,
[auth_sticky][smallint] NOT NULL ,
[auth_announce][smallint] NOT NULL ,
[auth_vote][smallint] NOT NULL ,
[auth_pollcreate][smallint] NOT NULL ,
[auth_attachments][smallint] NOT NULL
) ON [ PRIMARY ]GO CREATE TABLE [phpbb_groups](
[group_id][int]IDENTITY( 1, 1 ) NOT NULL ,
[group_type][smallint] NULL ,
[group_name][varchar]( 50 ) NOT NULL ,
[group_description][varchar]( 255 ) NOT NULL ,
[group_moderator][int] NULL ,
[group_single_user][smallint] NOT NULL
) ON [ PRIMARY ]GO CREATE TABLE [phpbb_posts](
[post_id][int]IDENTITY( 1, 1 ) NOT NULL ,
[topic_id][int] NOT NULL ,
[forum_id][int] NOT NULL ,
[poster_id][int] NOT NULL ,
[post_time][int] NOT NULL ,
[poster_ip][char]( 8 ) NULL ,
[post_username][char]( 25 ) NULL ,
[enable_bbcode][smallint] NULL ,
[enable_html][smallint] NULL ,
[enable_smilies][smallint] NULL ,
[enable_sig][smallint] NULL ,
[post_edit_time][int] NULL ,
[post_edit_count][smallint] NULL
) ON [ PRIMARY ]GO CREATE TABLE [phpbb_posts_text](
[post_id][int] NOT NULL ,
[bbcode_uid][char]( 10 ) NULL ,
[post_subject][char]( 60 ) NULL ,
[post_text][text] NULL
) ON [ PRIMARY ]TEXTIMAGE_ON[ PRIMARY ]GO CREATE TABLE [phpbb_privmsgs](
[privmsgs_id][int]IDENTITY( 1, 1 ) NOT NULL ,
[privmsgs_type][smallint] NOT NULL ,
[privmsgs_subject][varchar]( 100 ) NOT NULL ,
[privmsgs_from_userid][int] NOT NULL ,
[privmsgs_to_userid][int] NOT NULL ,
[privmsgs_date][int] NOT NULL ,
[privmsgs_ip][char]( 8 ) NOT NULL ,
[privmsgs_enable_bbcode][smallint] NULL ,
[privmsgs_enable_html][smallint] NULL ,
[privmsgs_enable_smilies][smallint] NULL ,
[privmsgs_attach_sig][smallint] NULL
) ON [ PRIMARY ]GO CREATE TABLE [phpbb_privmsgs_text](
[privmsgs_text_id][int] NOT NULL ,
[privmsgs_bbcode_uid][char]( 10 ) NULL ,
[privmsgs_text][text] NULL
) ON [ PRIMARY ]TEXTIMAGE_ON[ PRIMARY ]GO CREATE TABLE [phpbb_ranks](
[rank_id][int]IDENTITY( 1, 1 ) NOT NULL ,
[rank_title][varchar]( 50 ) NOT NULL ,
[rank_min][int] NULL ,
[rank_special][smallint] NULL ,
[rank_image][varchar]( 50 ) NULL
) ON [ PRIMARY ]GO CREATE TABLE [phpbb_search_results](
[search_id][int] NOT NULL ,
[session_id][char]( 32 ) NOT NULL ,
[search_array][text] NOT NULL
) ON [ PRIMARY ]TEXTIMAGE_ON[ PRIMARY ]GO CREATE TABLE [phpbb_search_wordlist](
[word_id][int]IDENTITY( 1, 1 ) NOT NULL ,
[word_text][varchar]( 50 ) NOT NULL ,
[word_common][tinyint] NOT NULL
) ON [ PRIMARY ]GO CREATE TABLE [phpbb_search_wordmatch](
[post_id][int] NOT NULL ,
[word_id][int] NOT NULL ,
[title_match][smallint] NOT NULL
) ON [ PRIMARY ]GO CREATE TABLE [phpbb_sessions](
[session_id][char]( 32 ) NOT NULL ,
[session_user_id][int] NOT NULL ,
[session_start][int] NULL ,
[session_time][int] NULL ,
[session_ip][char]( 8 ) NOT NULL ,
[session_page][int] NULL ,
[session_logged_in][smallint] NULL
) ON [ PRIMARY ]GO CREATE TABLE [phpbb_smilies](
[smilies_id][int]IDENTITY( 1, 1 ) NOT NULL ,
code[varchar]( 10 ) NOT NULL ,
[smile_url][varchar]( 50 ) NOT NULL ,
[emoticon][varchar]( 50 ) NULL
) ON [ PRIMARY ]GO CREATE TABLE [phpbb_themes](
[themes_id][int]IDENTITY( 1, 1 ) NOT NULL ,
[template_name][varchar]( 30 ) NOT NULL ,
[style_name][varchar]( 50 ) NOT NULL ,
[head_stylesheet][varchar]( 50 ) NULL ,
[body_background][varchar]( 50 ) NULL ,
[body_bgcolor][char]( 6 ) NULL ,
[body_text][char]( 6 ) NULL ,
[body_link][char]( 6 ) NULL ,
[body_vlink][char]( 6 ) NULL ,
[body_alink][char]( 6 ) NULL ,
[body_hlink][char]( 6 ) NULL ,
[tr_color1][char]( 6 ) NULL ,
[tr_color2][char]( 6 ) NULL ,
[tr_color3][char]( 6 ) NULL ,
[tr_class1][varchar]( 25 ) NULL ,
[tr_class2][varchar]( 25 ) NULL ,
[tr_class3][varchar]( 25 ) NULL ,
[th_color1][char]( 6 ) NULL ,
[th_color2][char]( 6 ) NULL ,
[th_color3][char]( 6 ) NULL ,
[th_class1][varchar]( 25 ) NULL ,
[th_class2][varchar]( 25 ) NULL ,
[th_class3][varchar]( 25 ) NULL ,
[td_color1][char]( 6 ) NULL ,
[td_color2][char]( 6 ) NULL ,
[td_color3][char]( 6 ) NULL ,
[td_class1][varchar]( 25 ) NULL ,
[td_class2][varchar]( 25 ) NULL ,
[td_class3][varchar]( 25 ) NULL ,
[fontface1][varchar]( 50 ) NULL ,
[fontface2][varchar]( 50 ) NULL ,
[fontface3][varchar]( 50 ) NULL ,
[fontsize1][smallint] NULL ,
[fontsize2][smallint] NULL ,
[fontsize3][smallint] NULL ,
[fontcolor1][char]( 6 ) NULL ,
[fontcolor2][char]( 6 ) NULL ,
[fontcolor3][char]( 6 ) NULL ,
[span_class1][varchar]( 25 ) NULL ,
[span_class2][varchar]( 25 ) NULL ,
[span_class3][varchar]( 25 ) NULL ,
[img_size_poll][smallint] NULL ,
[img_size_privmsg][smallint] NULL
) ON [ PRIMARY ]GO CREATE TABLE [phpbb_themes_name](
[themes_id][int] NOT NULL ,
[tr_color1_name][varchar]( 50 ) NULL ,
[tr_color2_name][varchar]( 50 ) NULL ,
[tr_color3_name][varchar]( 50 ) NULL ,
[tr_class1_name][varchar]( 50 ) NULL ,
[tr_class2_name][varchar]( 50 ) NULL ,
[tr_class3_name][varchar]( 50 ) NULL ,
[th_color1_name][varchar]( 50 ) NULL ,
[th_color2_name][varchar]( 50 ) NULL ,
[th_color3_name][varchar]( 50 ) NULL ,
[th_class1_name][varchar]( 50 ) NULL ,
[th_class2_name][varchar]( 50 ) NULL ,
[th_class3_name][varchar]( 50 ) NULL ,
[td_color1_name][varchar]( 50 ) NULL ,
[td_color2_name][varchar]( 50 ) NULL ,
[td_color3_name][varchar]( 50 ) NULL ,
[td_class1_name][varchar]( 50 ) NULL ,
[td_class2_name][varchar]( 50 ) NULL ,
[td_class3_name][varchar]( 50 ) NULL ,
[fontface1_name][varchar]( 50 ) NULL ,
[fontface2_name][varchar]( 50 ) NULL ,
[fontface3_name][varchar]( 50 ) NULL ,
[fontsize1_name][varchar]( 50 ) NULL ,
[fontsize2_name][varchar]( 50 ) NULL ,
[fontsize3_name][varchar]( 50 ) NULL ,
[fontcolor1_name][varchar]( 50 ) NULL ,
[fontcolor2_name][varchar]( 50 ) NULL ,
[fontcolor3_name][varchar]( 50 ) NULL ,
[span_class1_name][varchar]( 50 ) NULL ,
[span_class2_name][varchar]( 50 ) NULL ,
[span_class3_name][varchar]( 50 ) NULL
) ON [ PRIMARY ]GO CREATE TABLE [phpbb_topics](
[topic_id][int]IDENTITY( 1, 1 ) NOT NULL ,
[forum_id][int] NOT NULL ,
[topic_title][varchar]( 60 ) NOT NULL ,
[topic_poster][int] NOT NULL ,
[topic_time][int] NOT NULL ,
[topic_views][int] NOT NULL ,
[topic_replies][int] NOT NULL ,
[topic_status][smallint] NOT NULL ,
[topic_type][smallint] NOT NULL ,
[topic_vote][smallint] NOT NULL ,
[topic_first_post_id][int] NULL ,
[topic_last_post_id][int] NULL ,
[topic_moved_id][int] NULL
) ON [ PRIMARY ]GO CREATE TABLE [phpbb_topics_watch](
[topic_id][int] NOT NULL ,
[user_id][int] NOT NULL ,
[notify_status][smallint] NOT NULL
) ON [ PRIMARY ]GO CREATE TABLE [phpbb_user_group](
[group_id][int] NOT NULL ,
[user_id][int] NOT NULL ,
[user_pending][smallint] NULL
) ON [ PRIMARY ]GO CREATE TABLE [phpbb_users](
[user_id][int] NOT NULL ,
[user_active][smallint] NULL ,
[username][varchar]( 25 ) NOT NULL ,
[user_password][varchar]( 32 ) NOT NULL ,
[user_session_time][int] NOT NULL ,
[user_session_page][smallint] NOT NULL ,
[user_lastvisit][int] NOT NULL ,
[user_regdate][int] NOT NULL ,
[user_level][smallint] NOT NULL ,
[user_posts][int] NOT NULL ,
[user_timezone][decimal]( 5, 2 ) NOT NULL ,
[user_style][int] NULL ,
[user_lang][varchar]( 255 ) NULL ,
[user_dateformat][varchar]( 14 ) NOT NULL ,
[user_new_privmsg][smallint] NOT NULL ,
[user_unread_privmsg][smallint] NOT NULL ,
[user_last_privmsg][int] NOT NULL ,
[user_emailtime][int] NOT NULL ,
[user_viewemail][smallint] NULL ,
[user_attachsig][smallint] NULL ,
[user_allowhtml][smallint] NULL ,
[user_allowbbcode][smallint] NULL ,
[user_allowsmile][smallint] NULL ,
[user_allowavatar][smallint] NULL ,
[user_allow_pm][smallint] NOT NULL ,
[user_allow_viewonline][smallint] NOT NULL ,
[user_notify_pm][smallint] NOT NULL ,
[user_popup_pm][smallint] NULL ,
[user_rank][int] NULL ,
[user_avatar_type][smallint] NULL ,
[user_avatar][varchar]( 100 ) NULL ,
[user_email][varchar]( 255 ) NULL ,
[user_icq][varchar]( 15 ) NULL ,
[user_website][varchar]( 100 ) NULL ,
[user_occ][varchar]( 100 ) NULL ,
[user_from][varchar]( 100 ) NULL ,
[user_sig][text] NULL ,
[user_sig_bbcode_uid][char]( 10 ) NULL ,
[user_aim][varchar]( 255 ) NULL ,
[user_yim][varchar]( 255 ) NULL ,
[user_msnm][varchar]( 255 ) NULL ,
[user_interests][varchar]( 255 ) NULL ,
[user_actkey][varchar]( 32 ) NULL ,
[user_newpasswd][varchar]( 32 ) NULL ,
[user_notify][smallint] NOT NULL
) ON [ PRIMARY ]TEXTIMAGE_ON[ PRIMARY ]GO CREATE TABLE [phpbb_vote_desc](
[vote_id][int]IDENTITY( 1, 1 ) NOT NULL ,
[topic_id][int] NOT NULL ,
[vote_text][varchar]( 255 ) NOT NULL ,
[vote_start][int] NOT NULL ,
[vote_length][int] NOT NULL
) ON [ PRIMARY ]GO CREATE TABLE [phpbb_vote_results](
[vote_id][int] NOT NULL ,
[vote_option_id][int] NOT NULL ,
[vote_option_text][varchar]( 255 ) NOT NULL ,
[vote_result][int] NOT NULL
) ON [ PRIMARY ]GO CREATE TABLE [phpbb_vote_voters](
[vote_id][int] NOT NULL ,
[vote_user_id][int] NOT NULL ,
[vote_user_ip][char]( 8 ) NOT NULL
) ON [ PRIMARY ]GO CREATE TABLE [phpbb_words](
[word_id][int]IDENTITY( 1, 1 ) NOT NULL ,
[word][varchar]( 255 ) NOT NULL ,
[replacement][varchar]( 255 ) NOT NULL
) 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_categories] WITH NOCHECK ADD CONSTRAINT [PK_phpbb_categories] PRIMARY KEY CLUSTERED( [cat_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_forum_prune] WITH NOCHECK ADD CONSTRAINT [PK_phpbb_forum_prune] PRIMARY KEY CLUSTERED( [prune_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_groups] WITH NOCHECK ADD CONSTRAINT [PK_phpbb_groups] PRIMARY KEY CLUSTERED( [group_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( [privmsgs_id] ) ON [ PRIMARY ]GO ALTER TABLE [phpbb_privmsgs_text] WITH NOCHECK ADD CONSTRAINT [PK_phpbb_privmsgs_text] PRIMARY KEY CLUSTERED( [privmsgs_text_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_search_results] WITH NOCHECK ADD CONSTRAINT [PK_phpbb_search_results] PRIMARY KEY CLUSTERED( [search_id] ) ON [ PRIMARY ]GO ALTER TABLE [phpbb_search_wordlist] WITH NOCHECK ADD CONSTRAINT [PK_phpbb_search_wordlist] PRIMARY KEY CLUSTERED( [word_id] ) ON [ PRIMARY ]GO ALTER TABLE [phpbb_smilies] WITH NOCHECK ADD CONSTRAINT [PK_phpbb_smilies] PRIMARY KEY CLUSTERED( [smilies_id] ) ON [ PRIMARY ]GO ALTER TABLE [phpbb_themes] WITH NOCHECK ADD CONSTRAINT [PK_phpbb_themes] PRIMARY KEY CLUSTERED( [themes_id] ) ON [ PRIMARY ]GO ALTER TABLE [phpbb_themes_name] WITH NOCHECK ADD CONSTRAINT [PK_phpbb_themes_name] PRIMARY KEY CLUSTERED( [themes_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_users] WITH NOCHECK ADD CONSTRAINT [PK_phpbb_users] PRIMARY KEY CLUSTERED( [user_id] ) ON [ PRIMARY ]GO ALTER TABLE [phpbb_vote_desc] WITH NOCHECK ADD CONSTRAINT [PK_phpbb_vote_desc] PRIMARY KEY CLUSTERED( [vote_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_auth_access] WITH NOCHECK ADD CONSTRAINT [DF_phpbb_auth_access_auth_view]DEFAULT( 0 ) FOR [auth_view],
CONSTRAINT [DF_phpbb_auth_access_auth_read]DEFAULT( 0 ) FOR [auth_read],
CONSTRAINT [DF_phpbb_auth_access_auth_post]DEFAULT( 0 ) FOR [auth_post],
CONSTRAINT [DF_phpbb_auth_access_auth_reply]DEFAULT( 0 ) FOR [auth_reply],
CONSTRAINT [DF_phpbb_auth_access_auth_edit]DEFAULT( 0 ) FOR [auth_edit],
CONSTRAINT [DF_phpbb_auth_access_auth_delete]DEFAULT( 0 ) FOR [auth_delete],
CONSTRAINT [DF_phpbb_auth_access_auth_sticky]DEFAULT( 0 ) FOR [auth_sticky],
CONSTRAINT [DF_phpbb_auth_access_auth_announce]DEFAULT( 0 ) FOR [auth_announce],
CONSTRAINT [DF_phpbb_auth_access_auth_vote]DEFAULT( 0 ) FOR [auth_vote],
CONSTRAINT [DF_phpbb_auth_access_auth_pollcreate]DEFAULT( 0 ) FOR [auth_pollcreate],
CONSTRAINT [DF_phpbb_auth_access_auth_attachments]DEFAULT( 0 ) FOR [auth_attachments],
CONSTRAINT [DF_phpbb_auth_access_auth_mod]DEFAULT( 0 ) FOR [auth_mod]GO ALTER TABLE [phpbb_forums] WITH NOCHECK ADD CONSTRAINT [DF_phpbb_forums_forum_posts]DEFAULT( 0 ) FOR [forum_posts],
CONSTRAINT [DF_phpbb_forums_forum_topics]DEFAULT( 0 ) FOR [forum_topics],
CONSTRAINT [DF_phpbb_forums_forum_last_post_id]DEFAULT( 0 ) FOR [forum_last_post_id],
CONSTRAINT [DF_phpbb_forums_prune_enable]DEFAULT( 0 ) FOR [prune_enable],
CONSTRAINT [DF_phpbb_forums_auth_view]DEFAULT( 0 ) FOR [auth_view],
CONSTRAINT [DF_phpbb_forums_auth_read]DEFAULT( 0 ) FOR [auth_read],
CONSTRAINT [DF_phpbb_forums_auth_post]DEFAULT( 0 ) FOR [auth_post],
CONSTRAINT [DF_phpbb_forums_auth_reply]DEFAULT( 0 ) FOR [auth_reply],
CONSTRAINT [DF_phpbb_forums_auth_edit]DEFAULT( 0 ) FOR [auth_edit],
CONSTRAINT [DF_phpbb_forums_auth_delete]DEFAULT( 0 ) FOR [auth_delete],
CONSTRAINT [DF_phpbb_forums_auth_sticky]DEFAULT( 0 ) FOR [auth_sticky],
CONSTRAINT [DF_phpbb_forums_auth_announce]DEFAULT( 0 ) FOR [auth_announce],
CONSTRAINT [DF_phpbb_forums_auth_vote]DEFAULT( 0 ) FOR [auth_vote],
CONSTRAINT [DF_phpbb_forums_auth_pollcreate]DEFAULT( 0 ) FOR [auth_pollcreate],
CONSTRAINT [DF_phpbb_forums_auth_attachments]DEFAULT( 0 ) FOR [auth_attachments]GO ALTER TABLE [phpbb_posts] WITH NOCHECK ADD CONSTRAINT [DF_phpbb_posts_enable_bbcode]DEFAULT( 1 ) FOR [enable_bbcode],
CONSTRAINT [DF_phpbb_posts_enable_html]DEFAULT( 0 ) FOR [enable_html],
CONSTRAINT [DF_phpbb_posts_enable_smilies]DEFAULT( 1 ) FOR [enable_smilies],
CONSTRAINT [DF_phpbb_posts_enable_sig]DEFAULT( 1 ) FOR [enable_sig],
CONSTRAINT [DF_phpbb_posts_post_edit_count]DEFAULT( 0 ) FOR [post_edit_count]GO ALTER TABLE [phpbb_search_wordlist] WITH NOCHECK ADD CONSTRAINT [DF_phpbb_search_wordlist_word_common]DEFAULT( 0 ) FOR [word_common]GO ALTER TABLE [phpbb_topics] WITH NOCHECK ADD CONSTRAINT [DF_phpbb_topics_topic_views]DEFAULT( 0 ) FOR [topic_views],
CONSTRAINT [DF_phpbb_topics_topic_replies]DEFAULT( 0 ) FOR [topic_replies],
CONSTRAINT [DF_phpbb_topics_topic_status]DEFAULT( 0 ) FOR [topic_status],
CONSTRAINT [DF_phpbb_topics_topic_type]DEFAULT( 0 ) FOR [topic_type],
CONSTRAINT [DF_phpbb_topics_topic_vote]DEFAULT( 0 ) FOR [topic_vote],
CONSTRAINT [DF_phpbb_topics_topic_moved_id]DEFAULT( 0 ) FOR topic_moved_idGO ALTER TABLE [phpbb_users] WITH NOCHECK ADD CONSTRAINT [DF_phpbb_users_user_level]DEFAULT( 0 ) FOR [user_level],
CONSTRAINT [DF_phpbb_users_user_posts]DEFAULT( 0 ) FOR [user_posts],
CONSTRAINT [DF_phpbb_users_user_session_time]DEFAULT( 0 ) FOR [user_session_time],
CONSTRAINT [DF_phpbb_users_user_session_page]DEFAULT( 0 ) FOR [user_session_page],
CONSTRAINT [DF_phpbb_users_user_lastvisit]DEFAULT( 0 ) FOR [user_lastvisit],
CONSTRAINT [DF_phpbb_users_user_new_privmsg]DEFAULT( 0 ) FOR [user_new_privmsg],
CONSTRAINT [DF_phpbb_users_user_unread_privmsg]DEFAULT( 0 ) FOR [user_unread_privmsg],
CONSTRAINT [DF_phpbb_users_user_last_privmsg]DEFAULT( 0 ) FOR [user_last_privmsg],
CONSTRAINT [DF_phpbb_users_user_emailtime]DEFAULT( 0 ) FOR [user_emailtime],
CONSTRAINT [DF_phpbb_users_user_viewemail]DEFAULT( 1 ) FOR [user_viewemail],
CONSTRAINT [DF_phpbb_users_user_attachsig]DEFAULT( 1 ) FOR [user_attachsig],
CONSTRAINT [DF_phpbb_users_user_allowhtml]DEFAULT( 0 ) FOR [user_allowhtml],
CONSTRAINT [DF_phpbb_users_user_allowbbcode]DEFAULT( 1 ) FOR [user_allowbbcode],
CONSTRAINT [DF_phpbb_users_user_allowsmile]DEFAULT( 1 ) FOR [user_allowsmile],
CONSTRAINT [DF_phpbb_users_user_allowavatar]DEFAULT( 1 ) FOR [user_allowavatar],
CONSTRAINT [DF_phpbb_users_user_allow_pm]DEFAULT( 1 ) FOR [user_allow_pm],
CONSTRAINT [DF_phpbb_users_user_allow_viewonline]DEFAULT( 1 ) FOR [user_allow_viewonline],
CONSTRAINT [DF_phpbb_users_user_notify_pm]DEFAULT( 0 ) FOR [user_notify_pm],
CONSTRAINT [DF_phpbb_users_user_popup_pm]DEFAULT( 1 ) FOR [user_popup_pm],
CONSTRAINT [DF_phpbb_users_user_avatar_type]DEFAULT( 0 ) FOR [user_avatar_type]GO CREATE INDEX [IX_phpbb_auth_access] ON [phpbb_auth_access](
[group_id],
[forum_id]
) ON [ PRIMARY ]GO CREATE INDEX [IX_phpbb_banlist] ON [phpbb_banlist](
[ban_userid],
[ban_ip]
) ON [ PRIMARY ]GO CREATE INDEX [IX_phpbb_categories] ON [phpbb_categories](
[cat_order]
) ON [ PRIMARY ]GO CREATE INDEX [IX_phpbb_forum_prune] ON [phpbb_forum_prune](
[forum_id]
) ON [ PRIMARY ]GO CREATE INDEX [IX_phpbb_forums] ON [phpbb_forums](
[cat_id],
[forum_order],
[forum_last_post_id]
) ON [ PRIMARY ]GO CREATE INDEX [IX_phpbb_groups] ON [phpbb_groups](
[group_single_user]
) ON [ PRIMARY ]GO CREATE INDEX [IX_phpbb_posts] ON [phpbb_posts](
[topic_id],
[forum_id],
[poster_id]
) ON [ PRIMARY ]GO CREATE INDEX [IX_phpbb_posts_text] ON [phpbb_posts_text](
[post_id]
) ON [ PRIMARY ]GO CREATE INDEX [IX_phpbb_privmsgs] ON [phpbb_privmsgs](
[privmsgs_from_userid],
[privmsgs_to_userid]
) ON [ PRIMARY ]GO CREATE INDEX [IX_phpbb_ranks] ON [phpbb_ranks](
[rank_min],
[rank_special]
) ON [ PRIMARY ]GO CREATE INDEX [IX_phpbb_search_results] ON [phpbb_search_results](
[session_id]
) ON [ PRIMARY ]GO CREATE UNIQUE INDEX [IX_phpbb_search_wordlist] ON [phpbb_search_wordlist](
[word_text]
) WITH IGNORE_DUP_KEY ON [ PRIMARY ]GO CREATE INDEX [IX_phpbb_search_wordlist_1] ON [phpbb_search_wordlist](
[word_common]
) ON [ PRIMARY ]GO CREATE INDEX [IX_phpbb_search_wordmatch] ON [phpbb_search_wordmatch](
[post_id]
) ON [ PRIMARY ]GO CREATE INDEX [IX_phpbb_search_wordmatch_1] ON [phpbb_search_wordmatch](
[word_id]
) ON [ PRIMARY ]GO CREATE INDEX [IX_phpbb_sessions] ON [phpbb_sessions](
[session_id],
[session_user_id],
[session_ip],
[session_logged_in]
) ON [ PRIMARY ]GO CREATE INDEX [IX_phpbb_topics] ON [phpbb_topics](
[forum_id],
[topic_type],
[topic_first_post_id],
[topic_last_post_id]
) ON [ PRIMARY ]GO CREATE INDEX [IX_phpbb_topics_watch] ON [phpbb_topics_watch](
[topic_id],
[user_id]
) ON [ PRIMARY ]GO CREATE INDEX [IX_phpbb_users] ON [phpbb_users](
[user_session_time]
) ON [ PRIMARY ]GO CREATE INDEX [IX_phpbb_user_group] ON [phpbb_user_group](
[group_id],
[user_id]
) ON [ PRIMARY ]GO CREATE INDEX [IX_phpbb_vote_desc] ON [phpbb_vote_desc](
[topic_id]
) ON [ PRIMARY ]GO CREATE INDEX [IX_phpbb_vote_results] ON [phpbb_vote_results](
[vote_id]
) ON [ PRIMARY ]GO CREATE INDEX [IX_phpbb_vote_results_1] ON [phpbb_vote_results](
[vote_option_id]
) ON [ PRIMARY ]GO CREATE INDEX [IX_phpbb_vote_voters] ON [phpbb_vote_voters](
[vote_id]
) ON [ PRIMARY ]GO CREATE INDEX [IX_phpbb_vote_voters_1] ON [phpbb_vote_voters](
[vote_user_id]
) ON [ PRIMARY ]GO COMMIT GO
MySQL 傳回：
#1064 - You have an error in your SQL syntax near 'TRANSACTIONGO CREATE TABLE [phpbb_auth_access]( [group_id][int] NULL ,
[forum_i' at line 7
我該怎麼辦?