mysql_41_schema.sql

这些都是我以前学习是用到的源码

	theme_id tinyint(4) DEFAULT '0' NOT NULL,
	imageset_id tinyint(4) DEFAULT '0' NOT NULL,
	PRIMARY KEY (style_id),
	UNIQUE style_name (style_name),
	KEY template_id (template_id),
	KEY theme_id (theme_id),
	KEY imageset_id (imageset_id)
) CHARACTER SET `utf8` COLLATE `utf8_bin`;


# Table: 'phpbb_styles_template'
CREATE TABLE phpbb_styles_template (
	template_id tinyint(4) NOT NULL auto_increment,
	template_name varchar(255) DEFAULT '' NOT NULL,
	template_copyright varchar(255) DEFAULT '' NOT NULL,
	template_path varchar(100) DEFAULT '' NOT NULL,
	bbcode_bitfield varchar(255) DEFAULT 'kNg=' NOT NULL,
	template_storedb tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
	PRIMARY KEY (template_id),
	UNIQUE tmplte_nm (template_name)
) CHARACTER SET `utf8` COLLATE `utf8_bin`;


# Table: 'phpbb_styles_template_data'
CREATE TABLE phpbb_styles_template_data (
	template_id tinyint(4) NOT NULL auto_increment,
	template_filename varchar(100) DEFAULT '' NOT NULL,
	template_included text NOT NULL,
	template_mtime int(11) UNSIGNED DEFAULT '0' NOT NULL,
	template_data mediumtext NOT NULL,
	KEY tid (template_id),
	KEY tfn (template_filename)
) CHARACTER SET `utf8` COLLATE `utf8_bin`;


# Table: 'phpbb_styles_theme'
CREATE TABLE phpbb_styles_theme (
	theme_id tinyint(4) NOT NULL auto_increment,
	theme_name varchar(255) DEFAULT '' NOT NULL,
	theme_copyright varchar(255) DEFAULT '' NOT NULL,
	theme_path varchar(100) DEFAULT '' NOT NULL,
	theme_storedb tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
	theme_mtime int(11) UNSIGNED DEFAULT '0' NOT NULL,
	theme_data mediumtext NOT NULL,
	PRIMARY KEY (theme_id),
	UNIQUE theme_name (theme_name)
) CHARACTER SET `utf8` COLLATE `utf8_bin`;


# Table: 'phpbb_styles_imageset'
CREATE TABLE phpbb_styles_imageset (
	imageset_id tinyint(4) NOT NULL auto_increment,
	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,
	PRIMARY KEY (imageset_id),
	UNIQUE imgset_nm (imageset_name)
) CHARACTER SET `utf8` COLLATE `utf8_bin`;


# Table: 'phpbb_topics'
CREATE TABLE phpbb_topics (
	topic_id mediumint(8) UNSIGNED NOT NULL auto_increment,
	forum_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
	icon_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
	topic_attachment tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
	topic_approved tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
	topic_reported tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
	topic_title varchar(100) DEFAULT '' NOT NULL,
	topic_poster mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
	topic_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
	topic_time_limit int(11) UNSIGNED DEFAULT '0' NOT NULL,
	topic_views mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
	topic_replies mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
	topic_replies_real mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
	topic_status tinyint(3) DEFAULT '0' NOT NULL,
	topic_type tinyint(3) DEFAULT '0' NOT NULL,
	topic_first_post_id mediumint(8) UNSIGNED 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 mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
	topic_last_poster_id mediumint(8) UNSIGNED 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(11) UNSIGNED DEFAULT '0' NOT NULL,
	topic_last_view_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
	topic_moved_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
	topic_bumped tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
	topic_bumper mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
	poll_title varchar(100) DEFAULT '' NOT NULL,
	poll_start int(11) UNSIGNED DEFAULT '0' NOT NULL,
	poll_length int(11) UNSIGNED DEFAULT '0' NOT NULL,
	poll_max_options tinyint(4) DEFAULT '1' NOT NULL,
	poll_last_vote int(11) UNSIGNED DEFAULT '0' NOT NULL,
	poll_vote_change tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
	PRIMARY KEY (topic_id),
	KEY forum_id (forum_id),
	KEY forum_id_type (forum_id, topic_type),
	KEY last_post_time (topic_last_post_time),
	KEY topic_approved (topic_approved),
	KEY fid_time_moved (forum_id, topic_last_post_time, topic_moved_id)
) CHARACTER SET `utf8` COLLATE `utf8_bin`;


# Table: 'phpbb_topics_track'
CREATE TABLE phpbb_topics_track (
	user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
	topic_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
	forum_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
	mark_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
	PRIMARY KEY (user_id, topic_id),
	KEY forum_id (forum_id)
) CHARACTER SET `utf8` COLLATE `utf8_bin`;


# Table: 'phpbb_topics_posted'
CREATE TABLE phpbb_topics_posted (
	user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
	topic_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
	topic_posted tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
	PRIMARY KEY (user_id, topic_id)
) CHARACTER SET `utf8` COLLATE `utf8_bin`;


# Table: 'phpbb_topics_watch'
CREATE TABLE phpbb_topics_watch (
	topic_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
	user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
	notify_status tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
	KEY topic_id (topic_id),
	KEY user_id (user_id),
	KEY notify_stat (notify_status)
) CHARACTER SET `utf8` COLLATE `utf8_bin`;


# Table: 'phpbb_user_group'
CREATE TABLE phpbb_user_group (
	group_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
	user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
	group_leader tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
	user_pending tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
	KEY group_id (group_id),
	KEY user_id (user_id),
	KEY group_leader (group_leader)
) CHARACTER SET `utf8` COLLATE `utf8_bin`;


# Table: 'phpbb_users'
CREATE TABLE phpbb_users (
	user_id mediumint(8) UNSIGNED NOT NULL auto_increment,
	user_type tinyint(2) DEFAULT '0' NOT NULL,
	group_id mediumint(8) UNSIGNED DEFAULT '3' NOT NULL,
	user_permissions mediumtext NOT NULL,
	user_perm_from mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
	user_ip varchar(40) DEFAULT '' NOT NULL,
	user_regdate int(11) UNSIGNED 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(11) UNSIGNED DEFAULT '0' NOT NULL,
	user_pass_convert tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
	user_email varchar(100) DEFAULT '' NOT NULL,
	user_email_hash bigint(20) DEFAULT '0' NOT NULL,
	user_birthday varchar(10) DEFAULT '' NOT NULL,
	user_lastvisit int(11) UNSIGNED DEFAULT '0' NOT NULL,
	user_lastmark int(11) UNSIGNED DEFAULT '0' NOT NULL,
	user_lastpost_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
	user_lastpage varchar(200) DEFAULT '' NOT NULL,
	user_last_confirm_key varchar(10) DEFAULT '' NOT NULL,
	user_last_search int(11) UNSIGNED DEFAULT '0' NOT NULL,
	user_warnings tinyint(4) DEFAULT '0' NOT NULL,
	user_last_warning int(11) UNSIGNED DEFAULT '0' NOT NULL,
	user_login_attempts tinyint(4) DEFAULT '0' NOT NULL,
	user_inactive_reason tinyint(2) DEFAULT '0' NOT NULL,
	user_inactive_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
	user_posts mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
	user_lang varchar(30) DEFAULT '' NOT NULL,
	user_timezone decimal(5,2) DEFAULT '0' NOT NULL,
	user_dst tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
	user_dateformat varchar(30) DEFAULT 'd M Y H:i' NOT NULL,
	user_style tinyint(4) DEFAULT '0' NOT NULL,
	user_rank mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
	user_colour varchar(6) DEFAULT '' NOT NULL,
	user_new_privmsg tinyint(4) DEFAULT '0' NOT NULL,
	user_unread_privmsg tinyint(4) DEFAULT '0' NOT NULL,
	user_last_privmsg int(11) UNSIGNED DEFAULT '0' NOT NULL,
	user_message_rules tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
	user_full_folder int(11) DEFAULT '-3' NOT NULL,
	user_emailtime int(11) UNSIGNED DEFAULT '0' NOT NULL,
	user_topic_show_days smallint(4) UNSIGNED 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 smallint(4) UNSIGNED 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 tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
	user_notify_pm tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
	user_notify_type tinyint(4) DEFAULT '0' NOT NULL,
	user_allow_pm tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
	user_allow_viewonline tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
	user_allow_viewemail tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
	user_allow_massemail tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
	user_options int(11) UNSIGNED DEFAULT '893' NOT NULL,
	user_avatar varchar(255) DEFAULT '' NOT NULL,
	user_avatar_type tinyint(2) DEFAULT '0' NOT NULL,
	user_avatar_width smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
	user_avatar_height smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
	user_sig mediumtext 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 text NOT NULL,
	user_interests text NOT NULL,
	user_actkey varchar(32) DEFAULT '' NOT NULL,
	user_newpasswd varchar(32) DEFAULT '' NOT NULL,
	PRIMARY KEY (user_id),
	KEY user_birthday (user_birthday),
	KEY user_email_hash (user_email_hash),
	KEY user_type (user_type),
	KEY username_clean (username_clean)
) CHARACTER SET `utf8` COLLATE `utf8_bin`;


# Table: 'phpbb_warnings'
CREATE TABLE phpbb_warnings (
	warning_id mediumint(8) UNSIGNED NOT NULL auto_increment,
	user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
	post_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
	log_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
	warning_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
	PRIMARY KEY (warning_id)
) CHARACTER SET `utf8` COLLATE `utf8_bin`;


# Table: 'phpbb_words'
CREATE TABLE phpbb_words (
	word_id mediumint(8) UNSIGNED NOT NULL auto_increment,
	word varchar(255) DEFAULT '' NOT NULL,
	replacement varchar(255) DEFAULT '' NOT NULL,
	PRIMARY KEY (word_id)
) CHARACTER SET `utf8` COLLATE `utf8_bin`;


# Table: 'phpbb_zebra'
CREATE TABLE phpbb_zebra (
	user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
	zebra_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
	friend tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
	foe tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
	KEY user_id (user_id),
	KEY zebra_id (zebra_id)
) CHARACTER SET `utf8` COLLATE `utf8_bin`;