mssql_schema.sql

通过基于Windows的图形化界面

	[theme_data] [text] DEFAULT ('') NOT NULL 
) 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

CREATE  UNIQUE  INDEX [theme_name] ON [phpbb_styles_theme]([theme_name]) ON [PRIMARY]
GO


/*
	Table: 'phpbb_styles_imageset'
*/
CREATE TABLE [phpbb_styles_imageset] (
	[imageset_id] [int] IDENTITY (1, 1) NOT NULL ,
	[imageset_name] [varchar] (255) DEFAULT ('') NOT NULL ,
	[imageset_copyright] [varchar] (255) DEFAULT ('') NOT NULL ,
	[imageset_path] [varchar] (100) DEFAULT ('') NOT NULL ,
	[site_logo] [varchar] (200) DEFAULT ('') NOT NULL ,
	[upload_bar] [varchar] (200) DEFAULT ('') NOT NULL ,
	[poll_left] [varchar] (200) DEFAULT ('') NOT NULL ,
	[poll_center] [varchar] (200) DEFAULT ('') NOT NULL ,
	[poll_right] [varchar] (200) DEFAULT ('') NOT NULL ,
	[icon_friend] [varchar] (200) DEFAULT ('') NOT NULL ,
	[icon_foe] [varchar] (200) DEFAULT ('') NOT NULL ,
	[forum_link] [varchar] (200) DEFAULT ('') NOT NULL ,
	[forum_read] [varchar] (200) DEFAULT ('') NOT NULL ,
	[forum_read_locked] [varchar] (200) DEFAULT ('') NOT NULL ,
	[forum_read_subforum] [varchar] (200) DEFAULT ('') NOT NULL ,
	[forum_unread] [varchar] (200) DEFAULT ('') NOT NULL ,
	[forum_unread_locked] [varchar] (200) DEFAULT ('') NOT NULL ,
	[forum_unread_subforum] [varchar] (200) DEFAULT ('') NOT NULL ,
	[topic_moved] [varchar] (200) DEFAULT ('') NOT NULL ,
	[topic_read] [varchar] (200) DEFAULT ('') NOT NULL ,
	[topic_read_mine] [varchar] (200) DEFAULT ('') NOT NULL ,
	[topic_read_hot] [varchar] (200) DEFAULT ('') NOT NULL ,
	[topic_read_hot_mine] [varchar] (200) DEFAULT ('') NOT NULL ,
	[topic_read_locked] [varchar] (200) DEFAULT ('') NOT NULL ,
	[topic_read_locked_mine] [varchar] (200) DEFAULT ('') NOT NULL ,
	[topic_unread] [varchar] (200) DEFAULT ('') NOT NULL ,
	[topic_unread_mine] [varchar] (200) DEFAULT ('') NOT NULL ,
	[topic_unread_hot] [varchar] (200) DEFAULT ('') NOT NULL ,
	[topic_unread_hot_mine] [varchar] (200) DEFAULT ('') NOT NULL ,
	[topic_unread_locked] [varchar] (200) DEFAULT ('') NOT NULL ,
	[topic_unread_locked_mine] [varchar] (200) DEFAULT ('') NOT NULL ,
	[sticky_read] [varchar] (200) DEFAULT ('') NOT NULL ,
	[sticky_read_mine] [varchar] (200) DEFAULT ('') NOT NULL ,
	[sticky_read_locked] [varchar] (200) DEFAULT ('') NOT NULL ,
	[sticky_read_locked_mine] [varchar] (200) DEFAULT ('') NOT NULL ,
	[sticky_unread] [varchar] (200) DEFAULT ('') NOT NULL ,
	[sticky_unread_mine] [varchar] (200) DEFAULT ('') NOT NULL ,
	[sticky_unread_locked] [varchar] (200) DEFAULT ('') NOT NULL ,
	[sticky_unread_locked_mine] [varchar] (200) DEFAULT ('') NOT NULL ,
	[announce_read] [varchar] (200) DEFAULT ('') NOT NULL ,
	[announce_read_mine] [varchar] (200) DEFAULT ('') NOT NULL ,
	[announce_read_locked] [varchar] (200) DEFAULT ('') NOT NULL ,
	[announce_read_locked_mine] [varchar] (200) DEFAULT ('') NOT NULL ,
	[announce_unread] [varchar] (200) DEFAULT ('') NOT NULL ,
	[announce_unread_mine] [varchar] (200) DEFAULT ('') NOT NULL ,
	[announce_unread_locked] [varchar] (200) DEFAULT ('') NOT NULL ,
	[announce_unread_locked_mine] [varchar] (200) DEFAULT ('') NOT NULL ,
	[global_read] [varchar] (200) DEFAULT ('') NOT NULL ,
	[global_read_mine] [varchar] (200) DEFAULT ('') NOT NULL ,
	[global_read_locked] [varchar] (200) DEFAULT ('') NOT NULL ,
	[global_read_locked_mine] [varchar] (200) DEFAULT ('') NOT NULL ,
	[global_unread] [varchar] (200) DEFAULT ('') NOT NULL ,
	[global_unread_mine] [varchar] (200) DEFAULT ('') NOT NULL ,
	[global_unread_locked] [varchar] (200) DEFAULT ('') NOT NULL ,
	[global_unread_locked_mine] [varchar] (200) DEFAULT ('') NOT NULL ,
	[pm_read] [varchar] (200) DEFAULT ('') NOT NULL ,
	[pm_unread] [varchar] (200) DEFAULT ('') NOT NULL ,
	[icon_contact_aim] [varchar] (200) DEFAULT ('') NOT NULL ,
	[icon_contact_email] [varchar] (200) DEFAULT ('') NOT NULL ,
	[icon_contact_icq] [varchar] (200) DEFAULT ('') NOT NULL ,
	[icon_contact_jabber] [varchar] (200) DEFAULT ('') NOT NULL ,
	[icon_contact_msnm] [varchar] (200) DEFAULT ('') NOT NULL ,
	[icon_contact_pm] [varchar] (200) DEFAULT ('') NOT NULL ,
	[icon_contact_yahoo] [varchar] (200) DEFAULT ('') NOT NULL ,
	[icon_contact_www] [varchar] (200) DEFAULT ('') NOT NULL ,
	[icon_post_delete] [varchar] (200) DEFAULT ('') NOT NULL ,
	[icon_post_edit] [varchar] (200) DEFAULT ('') NOT NULL ,
	[icon_post_info] [varchar] (200) DEFAULT ('') NOT NULL ,
	[icon_post_quote] [varchar] (200) DEFAULT ('') NOT NULL ,
	[icon_post_report] [varchar] (200) DEFAULT ('') NOT NULL ,
	[icon_post_target] [varchar] (200) DEFAULT ('') NOT NULL ,
	[icon_post_target_unread] [varchar] (200) DEFAULT ('') NOT NULL ,
	[icon_topic_attach] [varchar] (200) DEFAULT ('') NOT NULL ,
	[icon_topic_latest] [varchar] (200) DEFAULT ('') NOT NULL ,
	[icon_topic_newest] [varchar] (200) DEFAULT ('') NOT NULL ,
	[icon_topic_reported] [varchar] (200) DEFAULT ('') NOT NULL ,
	[icon_topic_unapproved] [varchar] (200) DEFAULT ('') NOT NULL ,
	[icon_user_online] [varchar] (200) DEFAULT ('') NOT NULL ,
	[icon_user_offline] [varchar] (200) DEFAULT ('') NOT NULL ,
	[icon_user_profile] [varchar] (200) DEFAULT ('') NOT NULL ,
	[icon_user_search] [varchar] (200) DEFAULT ('') NOT NULL ,
	[icon_user_warn] [varchar] (200) DEFAULT ('') NOT NULL ,
	[button_pm_forward] [varchar] (200) DEFAULT ('') NOT NULL ,
	[button_pm_new] [varchar] (200) DEFAULT ('') NOT NULL ,
	[button_pm_reply] [varchar] (200) DEFAULT ('') NOT NULL ,
	[button_topic_locked] [varchar] (200) DEFAULT ('') NOT NULL ,
	[button_topic_new] [varchar] (200) DEFAULT ('') NOT NULL ,
	[button_topic_reply] [varchar] (200) DEFAULT ('') NOT NULL ,
	[user_icon1] [varchar] (200) DEFAULT ('') NOT NULL ,
	[user_icon2] [varchar] (200) DEFAULT ('') NOT NULL ,
	[user_icon3] [varchar] (200) DEFAULT ('') NOT NULL ,
	[user_icon4] [varchar] (200) DEFAULT ('') NOT NULL ,
	[user_icon5] [varchar] (200) DEFAULT ('') NOT NULL ,
	[user_icon6] [varchar] (200) DEFAULT ('') NOT NULL ,
	[user_icon7] [varchar] (200) DEFAULT ('') NOT NULL ,
	[user_icon8] [varchar] (200) DEFAULT ('') NOT NULL ,
	[user_icon9] [varchar] (200) DEFAULT ('') NOT NULL ,
	[user_icon10] [varchar] (200) DEFAULT ('') NOT NULL 
) 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 [imgset_nm] ON [phpbb_styles_imageset]([imageset_name]) ON [PRIMARY]
GO


/*
	Table: 'phpbb_topics'
*/
CREATE TABLE [phpbb_topics] (
	[topic_id] [int] IDENTITY (1, 1) NOT NULL ,
	[forum_id] [int] DEFAULT (0) NOT NULL ,
	[icon_id] [int] DEFAULT (0) NOT NULL ,
	[topic_attachment] [int] DEFAULT (0) NOT NULL ,
	[topic_approved] [int] DEFAULT (1) NOT NULL ,
	[topic_reported] [int] DEFAULT (0) NOT NULL ,
	[topic_title] [varchar] (100) DEFAULT ('') NOT NULL ,
	[topic_poster] [int] DEFAULT (0) NOT NULL ,
	[topic_time] [int] DEFAULT (0) NOT NULL ,
	[topic_time_limit] [int] DEFAULT (0) NOT NULL ,
	[topic_views] [int] DEFAULT (0) NOT NULL ,
	[topic_replies] [int] DEFAULT (0) NOT NULL ,
	[topic_replies_real] [int] DEFAULT (0) NOT NULL ,
	[topic_status] [int] DEFAULT (0) NOT NULL ,
	[topic_type] [int] DEFAULT (0) NOT NULL ,
	[topic_first_post_id] [int] DEFAULT (0) NOT NULL ,
	[topic_first_poster_name] [varchar] (255) DEFAULT ('') NOT NULL ,
	[topic_first_poster_colour] [varchar] (6) DEFAULT ('') NOT NULL ,
	[topic_last_post_id] [int] DEFAULT (0) NOT NULL ,
	[topic_last_poster_id] [int] DEFAULT (0) NOT NULL ,
	[topic_last_poster_name] [varchar] (255) DEFAULT ('') NOT NULL ,
	[topic_last_poster_colour] [varchar] (6) DEFAULT ('') NOT NULL ,
	[topic_last_post_subject] [varchar] (100) DEFAULT ('') NOT NULL ,
	[topic_last_post_time] [int] DEFAULT (0) NOT NULL ,
	[topic_last_view_time] [int] DEFAULT (0) NOT NULL ,
	[topic_moved_id] [int] DEFAULT (0) NOT NULL ,
	[topic_bumped] [int] DEFAULT (0) NOT NULL ,
	[topic_bumper] [int] DEFAULT (0) NOT NULL ,
	[poll_title] [varchar] (100) DEFAULT ('') NOT NULL ,
	[poll_start] [int] DEFAULT (0) NOT NULL ,
	[poll_length] [int] DEFAULT (0) NOT NULL ,
	[poll_max_options] [int] DEFAULT (1) NOT NULL ,
	[poll_last_vote] [int] DEFAULT (0) NOT NULL ,
	[poll_vote_change] [int] DEFAULT (0) NOT NULL 
) ON [PRIMARY]
GO

ALTER TABLE [phpbb_topics] WITH NOCHECK ADD 
	CONSTRAINT [PK_phpbb_topics] PRIMARY KEY  CLUSTERED 
	(
		[topic_id]
	)  ON [PRIMARY] 
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 [last_post_time] ON [phpbb_topics]([topic_last_post_time]) ON [PRIMARY]
GO

CREATE  INDEX [topic_approved] ON [phpbb_topics]([topic_approved]) ON [PRIMARY]
GO

CREATE  INDEX [fid_time_moved] ON [phpbb_topics]([forum_id], [topic_last_post_time], [topic_moved_id]) ON [PRIMARY]
GO


/*
	Table: 'phpbb_topics_track'
*/
CREATE TABLE [phpbb_topics_track] (
	[user_id] [int] DEFAULT (0) NOT NULL ,
	[topic_id] [int] DEFAULT (0) NOT NULL ,
	[forum_id] [int] DEFAULT (0) NOT NULL ,
	[mark_time] [int] DEFAULT (0) NOT NULL 
) ON [PRIMARY]
GO

ALTER TABLE [phpbb_topics_track] WITH NOCHECK ADD 
	CONSTRAINT [PK_phpbb_topics_track] PRIMARY KEY  CLUSTERED 
	(
		[user_id],
		[topic_id]
	)  ON [PRIMARY] 
GO

CREATE  INDEX [forum_id] ON [phpbb_topics_track]([forum_id]) ON [PRIMARY]
GO


/*
	Table: 'phpbb_topics_posted'
*/
CREATE TABLE [phpbb_topics_posted] (
	[user_id] [int] DEFAULT (0) NOT NULL ,
	[topic_id] [int] DEFAULT (0) NOT NULL ,
	[topic_posted] [int] DEFAULT (0) NOT NULL 
) 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


/*
	Table: 'phpbb_topics_watch'
*/
CREATE TABLE [phpbb_topics_watch] (
	[topic_id] [int] DEFAULT (0) NOT NULL ,
	[user_id] [int] DEFAULT (0) NOT NULL ,
	[notify_status] [int] DEFAULT (0) NOT NULL 
) ON [PRIMARY]
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_stat] ON [phpbb_topics_watch]([notify_status]) ON [PRIMARY]
GO


/*
	Table: 'phpbb_user_group'
*/
CREATE TABLE [phpbb_user_group] (
	[group_id] [int] DEFAULT (0) NOT NULL ,
	[user_id] [int] DEFAULT (0) NOT NULL ,
	[group_leader] [int] DEFAULT (0) NOT NULL ,
	[user_pending] [int] DEFAULT (1) NOT NULL 
) ON [PRIMARY]
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] DEFAULT (0) NOT NULL ,
	[group_id] [int] DEFAULT (3) NOT NULL ,
	[user_permissions] [text] DEFAULT ('') NOT NULL ,
	[user_perm_from] [int] DEFAULT (0) NOT NULL ,
	[user_ip] [varchar] (40) DEFAULT ('') NOT NULL ,
	[user_regdate] [int] DEFAULT (0) NOT NULL ,
	[username] [varchar] (255) DEFAULT ('') NOT NULL ,
	[username_clean] [varchar] (255) DEFAULT ('') NOT NULL ,
	[user_password] [varchar] (40) DEFAULT ('') NOT NULL ,
	[user_passchg] [int] DEFAULT (0) NOT NULL ,
	[user_pass_convert] [int] DEFAULT (0) NOT NULL ,
	[user_email] [varchar] (100) DEFAULT ('') NOT NULL ,
	[user_email_hash] [float] DEFAULT (0) NOT NULL ,
	[user_birthday] [varchar] (10) DEFAULT ('') NOT NULL ,
	[user_lastvisit] [int] DEFAULT (0) NOT NULL ,
	[user_lastmark] [int] DEFAULT (0) NOT NULL ,
	[user_lastpost_time] [int] DEFAULT (0) NOT NULL ,
	[user_lastpage] [varchar] (200) DEFAULT ('') NOT NULL ,
	[user_last_confirm_key] [varchar] (10) DEFAULT ('') NOT NULL ,
	[user_last_search] [int] DEFAULT (0) NOT NULL ,
	[user_warnings] [int] DEFAULT (0) NOT NULL ,
	[user_last_warning] [int] DEFAULT (0) NOT NULL ,
	[user_login_attempts] [int] DEFAULT (0) NOT NULL ,
	[user_inactive_reason] [int] DEFAULT (0) NOT NULL ,
	[user_inactive_time] [int] DEFAULT (0) NOT NULL ,
	[user_posts] [int] DEFAULT (0) NOT NULL ,
	[user_lang] [varchar] (30) DEFAULT ('') NOT NULL ,
	[user_timezone] [float] DEFAULT (0) NOT NULL ,
	[user_dst] [int] DEFAULT (0) NOT NULL ,
	[user_dateformat] [varchar] (30) DEFAULT ('d M Y H:i') NOT NULL ,
	[user_style] [int] DEFAULT (0) NOT NULL ,
	[user_rank] [int] DEFAULT (0) NOT NULL ,
	[user_colour] [varchar] (6) DEFAULT ('') NOT NULL ,
	[user_new_privmsg] [int] DEFAULT (0) NOT NULL ,
	[user_unread_privmsg] [int] DEFAULT (0) NOT NULL ,
	[user_last_privmsg] [int] DEFAULT (0) NOT NULL ,
	[user_message_rules] [int] DEFAULT (0) NOT NULL ,
	[user_full_folder] [int] DEFAULT (-3) NOT NULL ,
	[user_emailtime] [int] DEFAULT (0) NOT NULL ,
	[user_topic_show_days] [int] DEFAULT (0) NOT NULL ,
	[user_topic_sortby_type] [varchar] (1) DEFAULT ('t') NOT NULL ,
	[user_topic_sortby_dir] [varchar] (1) DEFAULT ('d') NOT NULL ,
	[user_post_show_days] [int] DEFAULT (0) NOT NULL ,
	[user_post_sortby_type] [varchar] (1) DEFAULT ('t') NOT NULL ,
	[user_post_sortby_dir] [varchar] (1) DEFAULT ('a') NOT NULL ,
	[user_notify] [int] DEFAULT (0) NOT NULL ,
	[user_notify_pm] [int] DEFAULT (1) NOT NULL ,
	[user_notify_type] [int] DEFAULT (0) NOT NULL ,
	[user_allow_pm] [int] DEFAULT (1) NOT NULL ,
	[user_allow_viewonline] [int] DEFAULT (1) NOT NULL ,
	[user_allow_viewemail] [int] DEFAULT (1) NOT NULL ,
	[user_allow_massemail] [int] DEFAULT (1) NOT NULL ,
	[user_options] [int] DEFAULT (895) NOT NULL ,
	[user_avatar] [varchar] (255) DEFAULT ('') NOT NULL ,
	[user_avatar_type] [int] DEFAULT (0) NOT NULL ,
	[user_avatar_width] [int] DEFAULT (0) NOT NULL ,
	[user_avatar_height] [int] DEFAULT (0) NOT NULL ,
	[user_sig] [text] DEFAULT ('') NOT NULL ,
	[user_sig_bbcode_uid] [varchar] (5) DEFAULT ('') NOT NULL ,
	[user_sig_bbcode_bitfield] [varchar] (255) DEFAULT ('') NOT NULL ,
	[user_from] [varchar] (100) DEFAULT ('') NOT NULL ,
	[user_icq] [varchar] (15) DEFAULT ('') NOT NULL ,
	[user_aim] [varchar] (255) DEFAULT ('') NOT NULL ,
	[user_yim] [varchar] (255) DEFAULT ('') NOT NULL ,
	[user_msnm] [varchar] (255) DEFAULT ('') NOT NULL ,
	[user_jabber] [varchar] (255) DEFAULT ('') NOT NULL ,
	[user_website] [varchar] (200) DEFAULT ('') NOT NULL ,
	[user_occ] [varchar] (4000) DEFAULT ('') NOT NULL ,
	[user_interests] [varchar] (4000) DEFAULT ('') NOT NULL ,
	[user_actkey] [varchar] (32) DEFAULT ('') NOT NULL ,
	[user_newpasswd] [varchar] (32) DEFAULT ('') NOT NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

ALTER TABLE [phpbb_users] WITH NOCHECK ADD 
	CONSTRAINT [PK_phpbb_users] PRIMARY KEY  CLUSTERED 
	(
		[user_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]
GO

CREATE  INDEX [user_type] ON [phpbb_users]([user_type]) ON [PRIMARY]
GO

CREATE  INDEX [username_clean] ON [phpbb_users]([username_clean]) ON [PRIMARY]
GO


/*
	Table: 'phpbb_warnings'
*/
CREATE TABLE [phpbb_warnings] (
	[warning_id] [int] IDENTITY (1, 1) NOT NULL ,
	[user_id] [int] DEFAULT (0) NOT NULL ,
	[post_id] [int] DEFAULT (0) NOT NULL ,
	[log_id] [int] DEFAULT (0) NOT NULL ,
	[warning_time] [int] DEFAULT (0) NOT NULL 
) ON [PRIMARY]
GO

ALTER TABLE [phpbb_warnings] WITH NOCHECK ADD 
	CONSTRAINT [PK_phpbb_warnings] PRIMARY KEY  CLUSTERED 
	(
		[warning_id]
	)  ON [PRIMARY] 
GO


/*
	Table: 'phpbb_words'
*/
CREATE TABLE [phpbb_words] (
	[word_id] [int] IDENTITY (1, 1) NOT NULL ,
	[word] [varchar] (255) DEFAULT ('') NOT NULL ,
	[replacement] [varchar] (255) DEFAULT ('') NOT NULL 
) ON [PRIMARY]
GO

ALTER TABLE [phpbb_words] WITH NOCHECK ADD 
	CONSTRAINT [PK_phpbb_words] PRIMARY KEY  CLUSTERED 
	(
		[word_id]
	)  ON [PRIMARY] 
GO


/*
	Table: 'phpbb_zebra'
*/
CREATE TABLE [phpbb_zebra] (
	[user_id] [int] DEFAULT (0) NOT NULL ,
	[zebra_id] [int] DEFAULT (0) NOT NULL ,
	[friend] [int] DEFAULT (0) NOT NULL ,
	[foe] [int] DEFAULT (0) NOT NULL 
) ON [PRIMARY]
GO

ALTER TABLE [phpbb_zebra] WITH NOCHECK ADD 
	CONSTRAINT [PK_phpbb_zebra] PRIMARY KEY  CLUSTERED 
	(
		[user_id],
		[zebra_id]
	)  ON [PRIMARY] 
GO



COMMIT
GO