firebird_schema.sql

通过基于Windows的图形化界面

CREATE TRIGGER t_phpbb_styles_theme FOR phpbb_styles_theme
BEFORE INSERT
AS
BEGIN
	NEW.theme_id = GEN_ID(phpbb_styles_theme_gen, 1);
END;;


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

ALTER TABLE phpbb_styles_imageset ADD PRIMARY KEY (imageset_id);;

CREATE UNIQUE INDEX phpbb_styles_imageset_imgset_nm ON phpbb_styles_imageset(imageset_name);;

CREATE GENERATOR phpbb_styles_imageset_gen;;
SET GENERATOR phpbb_styles_imageset_gen TO 0;;

CREATE TRIGGER t_phpbb_styles_imageset FOR phpbb_styles_imageset
BEFORE INSERT
AS
BEGIN
	NEW.imageset_id = GEN_ID(phpbb_styles_imageset_gen, 1);
END;;


# Table: 'phpbb_topics'
CREATE TABLE phpbb_topics (
	topic_id INTEGER NOT NULL,
	forum_id INTEGER DEFAULT 0 NOT NULL,
	icon_id INTEGER DEFAULT 0 NOT NULL,
	topic_attachment INTEGER DEFAULT 0 NOT NULL,
	topic_approved INTEGER DEFAULT 1 NOT NULL,
	topic_reported INTEGER DEFAULT 0 NOT NULL,
	topic_title VARCHAR(100) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,
	topic_poster INTEGER DEFAULT 0 NOT NULL,
	topic_time INTEGER DEFAULT 0 NOT NULL,
	topic_time_limit INTEGER DEFAULT 0 NOT NULL,
	topic_views INTEGER DEFAULT 0 NOT NULL,
	topic_replies INTEGER DEFAULT 0 NOT NULL,
	topic_replies_real INTEGER DEFAULT 0 NOT NULL,
	topic_status INTEGER DEFAULT 0 NOT NULL,
	topic_type INTEGER DEFAULT 0 NOT NULL,
	topic_first_post_id INTEGER DEFAULT 0 NOT NULL,
	topic_first_poster_name VARCHAR(255) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,
	topic_first_poster_colour VARCHAR(6) CHARACTER SET NONE DEFAULT '' NOT NULL,
	topic_last_post_id INTEGER DEFAULT 0 NOT NULL,
	topic_last_poster_id INTEGER DEFAULT 0 NOT NULL,
	topic_last_poster_name VARCHAR(255) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,
	topic_last_poster_colour VARCHAR(6) CHARACTER SET NONE DEFAULT '' NOT NULL,
	topic_last_post_subject VARCHAR(100) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,
	topic_last_post_time INTEGER DEFAULT 0 NOT NULL,
	topic_last_view_time INTEGER DEFAULT 0 NOT NULL,
	topic_moved_id INTEGER DEFAULT 0 NOT NULL,
	topic_bumped INTEGER DEFAULT 0 NOT NULL,
	topic_bumper INTEGER DEFAULT 0 NOT NULL,
	poll_title VARCHAR(100) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,
	poll_start INTEGER DEFAULT 0 NOT NULL,
	poll_length INTEGER DEFAULT 0 NOT NULL,
	poll_max_options INTEGER DEFAULT 1 NOT NULL,
	poll_last_vote INTEGER DEFAULT 0 NOT NULL,
	poll_vote_change INTEGER DEFAULT 0 NOT NULL
);;

ALTER TABLE phpbb_topics ADD PRIMARY KEY (topic_id);;

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);;

CREATE GENERATOR phpbb_topics_gen;;
SET GENERATOR phpbb_topics_gen TO 0;;

CREATE TRIGGER t_phpbb_topics FOR phpbb_topics
BEFORE INSERT
AS
BEGIN
	NEW.topic_id = GEN_ID(phpbb_topics_gen, 1);
END;;


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

ALTER TABLE phpbb_topics_track ADD 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 DEFAULT 0 NOT NULL,
	topic_id INTEGER DEFAULT 0 NOT NULL,
	topic_posted INTEGER DEFAULT 0 NOT NULL
);;

ALTER TABLE phpbb_topics_posted ADD PRIMARY KEY (user_id, topic_id);;


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

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 DEFAULT 0 NOT NULL,
	user_id INTEGER DEFAULT 0 NOT NULL,
	group_leader INTEGER DEFAULT 0 NOT NULL,
	user_pending INTEGER DEFAULT 1 NOT NULL
);;

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 NOT NULL,
	user_type INTEGER DEFAULT 0 NOT NULL,
	group_id INTEGER DEFAULT 3 NOT NULL,
	user_permissions BLOB SUB_TYPE TEXT CHARACTER SET NONE DEFAULT '' NOT NULL,
	user_perm_from INTEGER DEFAULT 0 NOT NULL,
	user_ip VARCHAR(40) CHARACTER SET NONE DEFAULT '' NOT NULL,
	user_regdate INTEGER DEFAULT 0 NOT NULL,
	username VARCHAR(255) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,
	username_clean VARCHAR(255) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,
	user_password VARCHAR(40) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,
	user_passchg INTEGER DEFAULT 0 NOT NULL,
	user_pass_convert INTEGER DEFAULT 0 NOT NULL,
	user_email VARCHAR(100) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,
	user_email_hash DOUBLE PRECISION DEFAULT 0 NOT NULL,
	user_birthday VARCHAR(10) CHARACTER SET NONE DEFAULT '' NOT NULL,
	user_lastvisit INTEGER DEFAULT 0 NOT NULL,
	user_lastmark INTEGER DEFAULT 0 NOT NULL,
	user_lastpost_time INTEGER DEFAULT 0 NOT NULL,
	user_lastpage VARCHAR(200) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,
	user_last_confirm_key VARCHAR(10) CHARACTER SET NONE DEFAULT '' NOT NULL,
	user_last_search INTEGER DEFAULT 0 NOT NULL,
	user_warnings INTEGER DEFAULT 0 NOT NULL,
	user_last_warning INTEGER DEFAULT 0 NOT NULL,
	user_login_attempts INTEGER DEFAULT 0 NOT NULL,
	user_inactive_reason INTEGER DEFAULT 0 NOT NULL,
	user_inactive_time INTEGER DEFAULT 0 NOT NULL,
	user_posts INTEGER DEFAULT 0 NOT NULL,
	user_lang VARCHAR(30) CHARACTER SET NONE DEFAULT '' NOT NULL,
	user_timezone DOUBLE PRECISION DEFAULT 0 NOT NULL,
	user_dst INTEGER DEFAULT 0 NOT NULL,
	user_dateformat VARCHAR(30) CHARACTER SET UTF8 DEFAULT 'd M Y H:i' NOT NULL COLLATE UNICODE,
	user_style INTEGER DEFAULT 0 NOT NULL,
	user_rank INTEGER DEFAULT 0 NOT NULL,
	user_colour VARCHAR(6) CHARACTER SET NONE DEFAULT '' NOT NULL,
	user_new_privmsg INTEGER DEFAULT 0 NOT NULL,
	user_unread_privmsg INTEGER DEFAULT 0 NOT NULL,
	user_last_privmsg INTEGER DEFAULT 0 NOT NULL,
	user_message_rules INTEGER DEFAULT 0 NOT NULL,
	user_full_folder INTEGER DEFAULT -3 NOT NULL,
	user_emailtime INTEGER DEFAULT 0 NOT NULL,
	user_topic_show_days INTEGER DEFAULT 0 NOT NULL,
	user_topic_sortby_type VARCHAR(1) CHARACTER SET NONE DEFAULT 't' NOT NULL,
	user_topic_sortby_dir VARCHAR(1) CHARACTER SET NONE DEFAULT 'd' NOT NULL,
	user_post_show_days INTEGER DEFAULT 0 NOT NULL,
	user_post_sortby_type VARCHAR(1) CHARACTER SET NONE DEFAULT 't' NOT NULL,
	user_post_sortby_dir VARCHAR(1) CHARACTER SET NONE DEFAULT 'a' NOT NULL,
	user_notify INTEGER DEFAULT 0 NOT NULL,
	user_notify_pm INTEGER DEFAULT 1 NOT NULL,
	user_notify_type INTEGER DEFAULT 0 NOT NULL,
	user_allow_pm INTEGER DEFAULT 1 NOT NULL,
	user_allow_viewonline INTEGER DEFAULT 1 NOT NULL,
	user_allow_viewemail INTEGER DEFAULT 1 NOT NULL,
	user_allow_massemail INTEGER DEFAULT 1 NOT NULL,
	user_options INTEGER DEFAULT 895 NOT NULL,
	user_avatar VARCHAR(255) CHARACTER SET NONE DEFAULT '' NOT NULL,
	user_avatar_type INTEGER DEFAULT 0 NOT NULL,
	user_avatar_width INTEGER DEFAULT 0 NOT NULL,
	user_avatar_height INTEGER DEFAULT 0 NOT NULL,
	user_sig BLOB SUB_TYPE TEXT CHARACTER SET UTF8 DEFAULT '' NOT NULL,
	user_sig_bbcode_uid VARCHAR(5) CHARACTER SET NONE DEFAULT '' NOT NULL,
	user_sig_bbcode_bitfield VARCHAR(255) CHARACTER SET NONE DEFAULT '' NOT NULL,
	user_from VARCHAR(100) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,
	user_icq VARCHAR(15) CHARACTER SET NONE DEFAULT '' NOT NULL,
	user_aim VARCHAR(255) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,
	user_yim VARCHAR(255) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,
	user_msnm VARCHAR(255) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,
	user_jabber VARCHAR(255) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,
	user_website VARCHAR(200) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,
	user_occ BLOB SUB_TYPE TEXT CHARACTER SET UTF8 DEFAULT '' NOT NULL,
	user_interests BLOB SUB_TYPE TEXT CHARACTER SET UTF8 DEFAULT '' NOT NULL,
	user_actkey VARCHAR(32) CHARACTER SET NONE DEFAULT '' NOT NULL,
	user_newpasswd VARCHAR(32) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE
);;

ALTER TABLE phpbb_users ADD PRIMARY KEY (user_id);;

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);;

CREATE GENERATOR phpbb_users_gen;;
SET GENERATOR phpbb_users_gen TO 0;;

CREATE TRIGGER t_phpbb_users FOR phpbb_users
BEFORE INSERT
AS
BEGIN
	NEW.user_id = GEN_ID(phpbb_users_gen, 1);
END;;


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

ALTER TABLE phpbb_warnings ADD PRIMARY KEY (warning_id);;


CREATE GENERATOR phpbb_warnings_gen;;
SET GENERATOR phpbb_warnings_gen TO 0;;

CREATE TRIGGER t_phpbb_warnings FOR phpbb_warnings
BEFORE INSERT
AS
BEGIN
	NEW.warning_id = GEN_ID(phpbb_warnings_gen, 1);
END;;


# Table: 'phpbb_words'
CREATE TABLE phpbb_words (
	word_id INTEGER NOT NULL,
	word VARCHAR(255) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,
	replacement VARCHAR(255) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE
);;

ALTER TABLE phpbb_words ADD PRIMARY KEY (word_id);;


CREATE GENERATOR phpbb_words_gen;;
SET GENERATOR phpbb_words_gen TO 0;;

CREATE TRIGGER t_phpbb_words FOR phpbb_words
BEFORE INSERT
AS
BEGIN
	NEW.word_id = GEN_ID(phpbb_words_gen, 1);
END;;


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

ALTER TABLE phpbb_zebra ADD PRIMARY KEY (user_id, zebra_id);;