mssql_schema.sql

很好的论坛php+mysql+linux

	[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_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_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_confirm] WITH NOCHECK ADD
	CONSTRAINT [DF_phpbb_confirm_confirm_id] DEFAULT ('') FOR [confirm_id],
	CONSTRAINT [DF_phpbb_confirm_session_id] DEFAULT ('') FOR [session_id],
	CONSTRAINT [DF_phpbb_confirm_code] DEFAULT ('') FOR [code]
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_id
GO

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