sqlite_schema.sql

通过基于Windows的图形化界面

);

CREATE UNIQUE INDEX phpbb_styles_style_name ON phpbb_styles (style_name);
CREATE INDEX phpbb_styles_template_id ON phpbb_styles (template_id);
CREATE INDEX phpbb_styles_theme_id ON phpbb_styles (theme_id);
CREATE INDEX phpbb_styles_imageset_id ON phpbb_styles (imageset_id);

# Table: 'phpbb_styles_template'
CREATE TABLE phpbb_styles_template (
	template_id INTEGER PRIMARY KEY NOT NULL ,
	template_name varchar(255) NOT NULL DEFAULT '',
	template_copyright varchar(255) NOT NULL DEFAULT '',
	template_path varchar(100) NOT NULL DEFAULT '',
	bbcode_bitfield varchar(255) NOT NULL DEFAULT 'kNg=',
	template_storedb INTEGER UNSIGNED NOT NULL DEFAULT '0'
);

CREATE UNIQUE INDEX phpbb_styles_template_tmplte_nm ON phpbb_styles_template (template_name);

# Table: 'phpbb_styles_template_data'
CREATE TABLE phpbb_styles_template_data (
	template_id INTEGER PRIMARY KEY NOT NULL ,
	template_filename varchar(100) NOT NULL DEFAULT '',
	template_included text(65535) NOT NULL DEFAULT '',
	template_mtime INTEGER UNSIGNED NOT NULL DEFAULT '0',
	template_data mediumtext(16777215) NOT NULL DEFAULT ''
);

CREATE INDEX phpbb_styles_template_data_tid ON phpbb_styles_template_data (template_id);
CREATE INDEX phpbb_styles_template_data_tfn ON phpbb_styles_template_data (template_filename);

# Table: 'phpbb_styles_theme'
CREATE TABLE phpbb_styles_theme (
	theme_id INTEGER PRIMARY KEY NOT NULL ,
	theme_name varchar(255) NOT NULL DEFAULT '',
	theme_copyright varchar(255) NOT NULL DEFAULT '',
	theme_path varchar(100) NOT NULL DEFAULT '',
	theme_storedb INTEGER UNSIGNED NOT NULL DEFAULT '0',
	theme_mtime INTEGER UNSIGNED NOT NULL DEFAULT '0',
	theme_data mediumtext(16777215) NOT NULL DEFAULT ''
);

CREATE UNIQUE INDEX phpbb_styles_theme_theme_name ON phpbb_styles_theme (theme_name);

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

CREATE UNIQUE INDEX phpbb_styles_imageset_imgset_nm ON phpbb_styles_imageset (imageset_name);

# Table: 'phpbb_topics'
CREATE TABLE phpbb_topics (
	topic_id INTEGER PRIMARY KEY NOT NULL ,
	forum_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
	icon_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
	topic_attachment INTEGER UNSIGNED NOT NULL DEFAULT '0',
	topic_approved INTEGER UNSIGNED NOT NULL DEFAULT '1',
	topic_reported INTEGER UNSIGNED NOT NULL DEFAULT '0',
	topic_title text(65535) NOT NULL DEFAULT '',
	topic_poster INTEGER UNSIGNED NOT NULL DEFAULT '0',
	topic_time INTEGER UNSIGNED NOT NULL DEFAULT '0',
	topic_time_limit INTEGER UNSIGNED NOT NULL DEFAULT '0',
	topic_views INTEGER UNSIGNED NOT NULL DEFAULT '0',
	topic_replies INTEGER UNSIGNED NOT NULL DEFAULT '0',
	topic_replies_real INTEGER UNSIGNED NOT NULL DEFAULT '0',
	topic_status tinyint(3) NOT NULL DEFAULT '0',
	topic_type tinyint(3) NOT NULL DEFAULT '0',
	topic_first_post_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
	topic_first_poster_name varchar(255) NOT NULL DEFAULT '',
	topic_first_poster_colour varchar(6) NOT NULL DEFAULT '',
	topic_last_post_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
	topic_last_poster_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
	topic_last_poster_name varchar(255) NOT NULL DEFAULT '',
	topic_last_poster_colour varchar(6) NOT NULL DEFAULT '',
	topic_last_post_subject text(65535) NOT NULL DEFAULT '',
	topic_last_post_time INTEGER UNSIGNED NOT NULL DEFAULT '0',
	topic_last_view_time INTEGER UNSIGNED NOT NULL DEFAULT '0',
	topic_moved_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
	topic_bumped INTEGER UNSIGNED NOT NULL DEFAULT '0',
	topic_bumper INTEGER UNSIGNED NOT NULL DEFAULT '0',
	poll_title text(65535) NOT NULL DEFAULT '',
	poll_start INTEGER UNSIGNED NOT NULL DEFAULT '0',
	poll_length INTEGER UNSIGNED NOT NULL DEFAULT '0',
	poll_max_options tinyint(4) NOT NULL DEFAULT '1',
	poll_last_vote INTEGER UNSIGNED NOT NULL DEFAULT '0',
	poll_vote_change INTEGER UNSIGNED NOT NULL DEFAULT '0'
);

CREATE INDEX phpbb_topics_forum_id ON phpbb_topics (forum_id);
CREATE INDEX phpbb_topics_forum_id_type ON phpbb_topics (forum_id, topic_type);
CREATE INDEX phpbb_topics_last_post_time ON phpbb_topics (topic_last_post_time);
CREATE INDEX phpbb_topics_topic_approved ON phpbb_topics (topic_approved);
CREATE INDEX phpbb_topics_fid_time_moved ON phpbb_topics (forum_id, topic_last_post_time, topic_moved_id);

# Table: 'phpbb_topics_track'
CREATE TABLE phpbb_topics_track (
	user_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
	topic_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
	forum_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
	mark_time INTEGER UNSIGNED NOT NULL DEFAULT '0',
	PRIMARY KEY (user_id, topic_id)
);

CREATE INDEX phpbb_topics_track_forum_id ON phpbb_topics_track (forum_id);

# Table: 'phpbb_topics_posted'
CREATE TABLE phpbb_topics_posted (
	user_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
	topic_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
	topic_posted INTEGER UNSIGNED NOT NULL DEFAULT '0',
	PRIMARY KEY (user_id, topic_id)
);


# Table: 'phpbb_topics_watch'
CREATE TABLE phpbb_topics_watch (
	topic_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
	user_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
	notify_status INTEGER UNSIGNED NOT NULL DEFAULT '0'
);

CREATE INDEX phpbb_topics_watch_topic_id ON phpbb_topics_watch (topic_id);
CREATE INDEX phpbb_topics_watch_user_id ON phpbb_topics_watch (user_id);
CREATE INDEX phpbb_topics_watch_notify_stat ON phpbb_topics_watch (notify_status);

# Table: 'phpbb_user_group'
CREATE TABLE phpbb_user_group (
	group_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
	user_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
	group_leader INTEGER UNSIGNED NOT NULL DEFAULT '0',
	user_pending INTEGER UNSIGNED NOT NULL DEFAULT '1'
);

CREATE INDEX phpbb_user_group_group_id ON phpbb_user_group (group_id);
CREATE INDEX phpbb_user_group_user_id ON phpbb_user_group (user_id);
CREATE INDEX phpbb_user_group_group_leader ON phpbb_user_group (group_leader);

# Table: 'phpbb_users'
CREATE TABLE phpbb_users (
	user_id INTEGER PRIMARY KEY NOT NULL ,
	user_type tinyint(2) NOT NULL DEFAULT '0',
	group_id INTEGER UNSIGNED NOT NULL DEFAULT '3',
	user_permissions mediumtext(16777215) NOT NULL DEFAULT '',
	user_perm_from INTEGER UNSIGNED NOT NULL DEFAULT '0',
	user_ip varchar(40) NOT NULL DEFAULT '',
	user_regdate INTEGER UNSIGNED NOT NULL DEFAULT '0',
	username varchar(255) NOT NULL DEFAULT '',
	username_clean varchar(255) NOT NULL DEFAULT '',
	user_password varchar(40) NOT NULL DEFAULT '',
	user_passchg INTEGER UNSIGNED NOT NULL DEFAULT '0',
	user_pass_convert INTEGER UNSIGNED NOT NULL DEFAULT '0',
	user_email varchar(100) NOT NULL DEFAULT '',
	user_email_hash bigint(20) NOT NULL DEFAULT '0',
	user_birthday varchar(10) NOT NULL DEFAULT '',
	user_lastvisit INTEGER UNSIGNED NOT NULL DEFAULT '0',
	user_lastmark INTEGER UNSIGNED NOT NULL DEFAULT '0',
	user_lastpost_time INTEGER UNSIGNED NOT NULL DEFAULT '0',
	user_lastpage varchar(200) NOT NULL DEFAULT '',
	user_last_confirm_key varchar(10) NOT NULL DEFAULT '',
	user_last_search INTEGER UNSIGNED NOT NULL DEFAULT '0',
	user_warnings tinyint(4) NOT NULL DEFAULT '0',
	user_last_warning INTEGER UNSIGNED NOT NULL DEFAULT '0',
	user_login_attempts tinyint(4) NOT NULL DEFAULT '0',
	user_inactive_reason tinyint(2) NOT NULL DEFAULT '0',
	user_inactive_time INTEGER UNSIGNED NOT NULL DEFAULT '0',
	user_posts INTEGER UNSIGNED NOT NULL DEFAULT '0',
	user_lang varchar(30) NOT NULL DEFAULT '',
	user_timezone decimal(5,2) NOT NULL DEFAULT '0',
	user_dst INTEGER UNSIGNED NOT NULL DEFAULT '0',
	user_dateformat varchar(30) NOT NULL DEFAULT 'd M Y H:i',
	user_style tinyint(4) NOT NULL DEFAULT '0',
	user_rank INTEGER UNSIGNED NOT NULL DEFAULT '0',
	user_colour varchar(6) NOT NULL DEFAULT '',
	user_new_privmsg tinyint(4) NOT NULL DEFAULT '0',
	user_unread_privmsg tinyint(4) NOT NULL DEFAULT '0',
	user_last_privmsg INTEGER UNSIGNED NOT NULL DEFAULT '0',
	user_message_rules INTEGER UNSIGNED NOT NULL DEFAULT '0',
	user_full_folder int(11) NOT NULL DEFAULT '-3',
	user_emailtime INTEGER UNSIGNED NOT NULL DEFAULT '0',
	user_topic_show_days INTEGER UNSIGNED NOT NULL DEFAULT '0',
	user_topic_sortby_type varchar(1) NOT NULL DEFAULT 't',
	user_topic_sortby_dir varchar(1) NOT NULL DEFAULT 'd',
	user_post_show_days INTEGER UNSIGNED NOT NULL DEFAULT '0',
	user_post_sortby_type varchar(1) NOT NULL DEFAULT 't',
	user_post_sortby_dir varchar(1) NOT NULL DEFAULT 'a',
	user_notify INTEGER UNSIGNED NOT NULL DEFAULT '0',
	user_notify_pm INTEGER UNSIGNED NOT NULL DEFAULT '1',
	user_notify_type tinyint(4) NOT NULL DEFAULT '0',
	user_allow_pm INTEGER UNSIGNED NOT NULL DEFAULT '1',
	user_allow_viewonline INTEGER UNSIGNED NOT NULL DEFAULT '1',
	user_allow_viewemail INTEGER UNSIGNED NOT NULL DEFAULT '1',
	user_allow_massemail INTEGER UNSIGNED NOT NULL DEFAULT '1',
	user_options INTEGER UNSIGNED NOT NULL DEFAULT '895',
	user_avatar varchar(255) NOT NULL DEFAULT '',
	user_avatar_type tinyint(2) NOT NULL DEFAULT '0',
	user_avatar_width INTEGER UNSIGNED NOT NULL DEFAULT '0',
	user_avatar_height INTEGER UNSIGNED NOT NULL DEFAULT '0',
	user_sig mediumtext(16777215) NOT NULL DEFAULT '',
	user_sig_bbcode_uid varchar(5) NOT NULL DEFAULT '',
	user_sig_bbcode_bitfield varchar(255) NOT NULL DEFAULT '',
	user_from varchar(100) NOT NULL DEFAULT '',
	user_icq varchar(15) NOT NULL DEFAULT '',
	user_aim varchar(255) NOT NULL DEFAULT '',
	user_yim varchar(255) NOT NULL DEFAULT '',
	user_msnm varchar(255) NOT NULL DEFAULT '',
	user_jabber varchar(255) NOT NULL DEFAULT '',
	user_website varchar(200) NOT NULL DEFAULT '',
	user_occ text(65535) NOT NULL DEFAULT '',
	user_interests text(65535) NOT NULL DEFAULT '',
	user_actkey varchar(32) NOT NULL DEFAULT '',
	user_newpasswd varchar(32) NOT NULL DEFAULT ''
);

CREATE INDEX phpbb_users_user_birthday ON phpbb_users (user_birthday);
CREATE INDEX phpbb_users_user_email_hash ON phpbb_users (user_email_hash);
CREATE INDEX phpbb_users_user_type ON phpbb_users (user_type);
CREATE INDEX phpbb_users_username_clean ON phpbb_users (username_clean);

# Table: 'phpbb_warnings'
CREATE TABLE phpbb_warnings (
	warning_id INTEGER PRIMARY KEY NOT NULL ,
	user_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
	post_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
	log_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
	warning_time INTEGER UNSIGNED NOT NULL DEFAULT '0'
);


# Table: 'phpbb_words'
CREATE TABLE phpbb_words (
	word_id INTEGER PRIMARY KEY NOT NULL ,
	word varchar(255) NOT NULL DEFAULT '',
	replacement varchar(255) NOT NULL DEFAULT ''
);


# Table: 'phpbb_zebra'
CREATE TABLE phpbb_zebra (
	user_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
	zebra_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
	friend INTEGER UNSIGNED NOT NULL DEFAULT '0',
	foe INTEGER UNSIGNED NOT NULL DEFAULT '0',
	PRIMARY KEY (user_id, zebra_id)
);



COMMIT;