aboutsummaryrefslogtreecommitdiffstats
path: root/phpBB/install/schemas/firebird_schema.sql
diff options
context:
space:
mode:
Diffstat (limited to 'phpBB/install/schemas/firebird_schema.sql')
-rw-r--r--phpBB/install/schemas/firebird_schema.sql1522
1 files changed, 767 insertions, 755 deletions
diff --git a/phpBB/install/schemas/firebird_schema.sql b/phpBB/install/schemas/firebird_schema.sql
index f764f9ca38..d421482310 100644
--- a/phpBB/install/schemas/firebird_schema.sql
+++ b/phpBB/install/schemas/firebird_schema.sql
@@ -2,32 +2,33 @@
# Firebird Schema for phpBB 3.x - (c) phpBB Group, 2005
#
# $Id$
+#
-# phpbb_attachments
+# Table: 'phpbb_attachments'
CREATE TABLE phpbb_attachments (
- attach_id INTEGER NOT NULL,
- post_msg_id INTEGER DEFAULT 0 NOT NULL,
- topic_id INTEGER DEFAULT 0 NOT NULL,
- in_message INTEGER DEFAULT 0 NOT NULL,
- poster_id INTEGER DEFAULT 0 NOT NULL,
- physical_filename VARCHAR(255) NOT NULL,
- real_filename VARCHAR(255) NOT NULL,
- download_count INTEGER DEFAULT 0 NOT NULL,
- comment BLOB SUB_TYPE TEXT,
- extension VARCHAR(100),
- mimetype VARCHAR(100),
- filesize INTEGER DEFAULT 0 NOT NULL,
- filetime INTEGER DEFAULT 0 NOT NULL,
- thumbnail INTEGER DEFAULT 0 NOT NULL
+ attach_id INTEGER NOT NULL,
+ post_msg_id INTEGER DEFAULT 0 NOT NULL,
+ topic_id INTEGER DEFAULT 0 NOT NULL,
+ in_message INTEGER DEFAULT 0 NOT NULL,
+ poster_id INTEGER DEFAULT 0 NOT NULL,
+ pysical_filename VARCHAR(255) DEFAULT '' NOT NULL,
+ real_filename VARCHAR(255) DEFAULT '' NOT NULL,
+ download_count INTEGER DEFAULT 0 NOT NULL,
+ attach_comment BLOB SUB_TYPE TEXT DEFAULT '' NOT NULL,
+ extension VARCHAR(100) DEFAULT '' NOT NULL,
+ mimetype VARCHAR(100) DEFAULT '' NOT NULL,
+ filesize INTEGER DEFAULT 0 NOT NULL,
+ filetime INTEGER DEFAULT 0 NOT NULL,
+ thumbnail INTEGER DEFAULT 0 NOT NULL
);;
ALTER TABLE phpbb_attachments ADD PRIMARY KEY (attach_id);;
-CREATE INDEX phpbb_attachments_filesize ON phpbb_attachments(filesize);;
CREATE INDEX phpbb_attachments_filetime ON phpbb_attachments(filetime);;
CREATE INDEX phpbb_attachments_post_msg_id ON phpbb_attachments(post_msg_id);;
-CREATE INDEX phpbb_attachments_poster_id ON phpbb_attachments(poster_id);;
CREATE INDEX phpbb_attachments_topic_id ON phpbb_attachments(topic_id);;
+CREATE INDEX phpbb_attachments_poster_id ON phpbb_attachments(poster_id);;
+CREATE INDEX phpbb_attachments_filesize ON phpbb_attachments(filesize);;
CREATE GENERATOR phpbb_attachments_gen;;
SET GENERATOR phpbb_attachments_gen TO 0;;
@@ -36,30 +37,29 @@ CREATE TRIGGER t_phpbb_attachments_gen FOR phpbb_attachments
BEFORE INSERT
AS
BEGIN
- NEW.attach_id = GEN_ID(phpbb_attachments_gen, 1);
+ NEW.attach_id = GEN_ID(phpbb_attachments_gen, 1);
END;;
-# phpbb_acl_groups
+# Table: 'phpbb_acl_groups'
CREATE TABLE phpbb_acl_groups (
- group_id INTEGER DEFAULT 0 NOT NULL,
- forum_id INTEGER DEFAULT 0 NOT NULL,
- auth_option_id INTEGER DEFAULT 0 NOT NULL,
- auth_role_id INTEGER DEFAULT 0 NOT NULL,
- auth_setting INTEGER DEFAULT 0 NOT NULL
+ group_id INTEGER DEFAULT 0 NOT NULL,
+ forum_id INTEGER DEFAULT 0 NOT NULL,
+ auth_option_id INTEGER DEFAULT 0 NOT NULL,
+ auth_role_id INTEGER DEFAULT 0 NOT NULL,
+ auth_setting INTEGER DEFAULT 0 NOT NULL
);;
-CREATE INDEX phpbb_acl_groups_auth_opt_id ON phpbb_acl_groups(auth_option_id);;
CREATE INDEX phpbb_acl_groups_group_id ON phpbb_acl_groups(group_id);;
+CREATE INDEX phpbb_acl_groups_auth_option_id ON phpbb_acl_groups(auth_option_id);;
-
-# phpbb_acl_options
+# Table: 'phpbb_acl_options'
CREATE TABLE phpbb_acl_options (
- auth_option_id INTEGER NOT NULL,
- auth_option VARCHAR(50) NOT NULL,
- is_global INTEGER DEFAULT 0 NOT NULL,
- is_local INTEGER DEFAULT 0 NOT NULL,
- founder_only INTEGER DEFAULT 0 NOT NULL
+ auth_option_id INTEGER NOT NULL,
+ auth_option VARCHAR(50) DEFAULT '' NOT NULL,
+ is_global INTEGER DEFAULT 0 NOT NULL,
+ is_local INTEGER DEFAULT 0 NOT NULL,
+ founder_only INTEGER DEFAULT 0 NOT NULL
);;
ALTER TABLE phpbb_acl_options ADD PRIMARY KEY (auth_option_id);;
@@ -73,17 +73,17 @@ CREATE TRIGGER t_phpbb_acl_options_gen FOR phpbb_acl_options
BEFORE INSERT
AS
BEGIN
- NEW.auth_option_id = GEN_ID(phpbb_acl_options_gen, 1);
+ NEW.auth_option_id = GEN_ID(phpbb_acl_options_gen, 1);
END;;
-# phpbb_acl_roles
+# Table: 'phpbb_acl_roles'
CREATE TABLE phpbb_acl_roles (
- role_id INTEGER NOT NULL,
- role_name VARCHAR(255) DEFAULT '' NOT NULL,
- role_description BLOB SUB_TYPE TEXT,
- role_type VARCHAR(10) DEFAULT '' NOT NULL,
- role_order INTEGER DEFAULT 0 NOT NULL
+ role_id INTEGER NOT NULL,
+ role_name VARCHAR(255) DEFAULT '' NOT NULL,
+ role_description BLOB SUB_TYPE TEXT DEFAULT '' NOT NULL,
+ role_type VARCHAR(10) DEFAULT '' NOT NULL,
+ role_order INTEGER DEFAULT 0 NOT NULL
);;
ALTER TABLE phpbb_acl_roles ADD PRIMARY KEY (role_id);;
@@ -98,48 +98,48 @@ CREATE TRIGGER t_phpbb_acl_roles_gen FOR phpbb_acl_roles
BEFORE INSERT
AS
BEGIN
- NEW.role_id = GEN_ID(phpbb_acl_roles_gen, 1);
+ NEW.role_id = GEN_ID(phpbb_acl_roles_gen, 1);
END;;
-# phpbb_acl_roles_data
+# Table: 'phpbb_acl_roles_data'
CREATE TABLE phpbb_acl_roles_data (
- role_id INTEGER DEFAULT 0 NOT NULL,
- auth_option_id INTEGER DEFAULT 0 NOT NULL,
- auth_setting INTEGER DEFAULT 0 NOT NULL
+ role_id INTEGER DEFAULT 0 NOT NULL,
+ auth_option_id INTEGER DEFAULT 0 NOT NULL,
+ auth_setting INTEGER DEFAULT 0 NOT NULL
);;
ALTER TABLE phpbb_acl_roles_data ADD PRIMARY KEY (role_id, auth_option_id);;
-# phpbb_acl_users
+# Table: 'phpbb_acl_users'
CREATE TABLE phpbb_acl_users (
- user_id INTEGER DEFAULT 0 NOT NULL,
- forum_id INTEGER DEFAULT 0 NOT NULL,
- auth_option_id INTEGER DEFAULT 0 NOT NULL,
- auth_role_id INTEGER DEFAULT 0 NOT NULL,
- auth_setting INTEGER DEFAULT 0 NOT NULL
+ user_id INTEGER DEFAULT 0 NOT NULL,
+ forum_id INTEGER DEFAULT 0 NOT NULL,
+ auth_option_id INTEGER DEFAULT 0 NOT NULL,
+ auth_role_id INTEGER DEFAULT 0 NOT NULL,
+ auth_setting INTEGER DEFAULT 0 NOT NULL
);;
-CREATE INDEX phpbb_acl_users_auth_opt_id ON phpbb_acl_users(auth_option_id);;
CREATE INDEX phpbb_acl_users_user_id ON phpbb_acl_users(user_id);;
+CREATE INDEX phpbb_acl_users_auth_option_id ON phpbb_acl_users(auth_option_id);;
-
-# phpbb_banlist
+# Table: 'phpbb_banlist'
CREATE TABLE phpbb_banlist (
- ban_id INTEGER NOT NULL,
- ban_userid INTEGER DEFAULT 0 NOT NULL,
- ban_ip VARCHAR(40) DEFAULT '' NOT NULL,
- ban_email VARCHAR(100) DEFAULT '' NOT NULL,
- ban_start INTEGER DEFAULT 0 NOT NULL,
- ban_end INTEGER DEFAULT 0 NOT NULL,
- ban_exclude INTEGER DEFAULT 0 NOT NULL,
- ban_reason BLOB SUB_TYPE TEXT,
- ban_give_reason BLOB SUB_TYPE TEXT
+ ban_id INTEGER NOT NULL,
+ ban_userid INTEGER DEFAULT 0 NOT NULL,
+ ban_ip VARCHAR(40) DEFAULT '' NOT NULL,
+ ban_email VARCHAR(100) DEFAULT '' NOT NULL,
+ ban_start INTEGER DEFAULT 0 NOT NULL,
+ ban_end INTEGER DEFAULT 0 NOT NULL,
+ ban_exclude INTEGER DEFAULT 0 NOT NULL,
+ ban_reason BLOB SUB_TYPE TEXT DEFAULT '' NOT NULL,
+ ban_give_reason BLOB SUB_TYPE TEXT DEFAULT '' NOT NULL
);;
ALTER TABLE phpbb_banlist ADD PRIMARY KEY (ban_id);;
+
CREATE GENERATOR phpbb_banlist_gen;;
SET GENERATOR phpbb_banlist_gen TO 0;;
@@ -147,46 +147,45 @@ CREATE TRIGGER t_phpbb_banlist_gen FOR phpbb_banlist
BEFORE INSERT
AS
BEGIN
- NEW.ban_id = GEN_ID(phpbb_banlist_gen, 1);
+ NEW.ban_id = GEN_ID(phpbb_banlist_gen, 1);
END;;
-# phpbb_bbcodes
+
+# Table: 'phpbb_bbcodes'
CREATE TABLE phpbb_bbcodes (
- bbcode_id INTEGER DEFAULT 0 NOT NULL,
- bbcode_tag VARCHAR(16) DEFAULT '' NOT NULL,
- display_on_posting INTEGER DEFAULT 0 NOT NULL,
- bbcode_match VARCHAR(255) DEFAULT '' NOT NULL,
- bbcode_tpl BLOB SUB_TYPE TEXT,
- first_pass_match VARCHAR(255) DEFAULT '' NOT NULL,
- first_pass_replace VARCHAR(255) DEFAULT '' NOT NULL,
- second_pass_match VARCHAR(255) DEFAULT '' NOT NULL,
- second_pass_replace BLOB SUB_TYPE TEXT
+ bbcode_id INTEGER DEFAULT 0 NOT NULL,
+ bbcode_tag VARCHAR(16) DEFAULT '' NOT NULL,
+ display_on_posting INTEGER DEFAULT 0 NOT NULL,
+ bbcode_match VARCHAR(255) DEFAULT '' NOT NULL,
+ bbcode_tpl BLOB SUB_TYPE TEXT DEFAULT '' NOT NULL,
+ first_pass_match VARCHAR(255) DEFAULT '' NOT NULL,
+ first_pass_replace VARCHAR(255) DEFAULT '' NOT NULL,
+ second_pass_match VARCHAR(255) DEFAULT '' NOT NULL,
+ second_pass_replace BLOB SUB_TYPE TEXT DEFAULT '' NOT NULL
);;
ALTER TABLE phpbb_bbcodes ADD PRIMARY KEY (bbcode_id);;
-CREATE INDEX phpbb_bbcodes_display_on_post ON phpbb_bbcodes(display_on_posting);;
+CREATE INDEX phpbb_bbcodes_display_in_posting ON phpbb_bbcodes(display_on_posting);;
-
-# phpbb_bookmarks
+# Table: 'phpbb_bookmarks'
CREATE TABLE phpbb_bookmarks (
- topic_id INTEGER DEFAULT 0 NOT NULL,
- user_id INTEGER DEFAULT 0 NOT NULL,
- order_id INTEGER DEFAULT 0 NOT NULL
+ topic_id INTEGER DEFAULT 0 NOT NULL,
+ user_id INTEGER DEFAULT 0 NOT NULL,
+ order_id INTEGER DEFAULT 0 NOT NULL
);;
CREATE INDEX phpbb_bookmarks_order_id ON phpbb_bookmarks(order_id);;
CREATE INDEX phpbb_bookmarks_topic_user_id ON phpbb_bookmarks(topic_id, user_id);;
-
-# phpbb_bots
+# Table: 'phpbb_bots'
CREATE TABLE phpbb_bots (
- bot_id INTEGER NOT NULL,
- bot_active INTEGER DEFAULT 1 NOT NULL,
- bot_name BLOB SUB_TYPE TEXT,
- user_id INTEGER DEFAULT 0 NOT NULL,
- bot_agent VARCHAR(255) DEFAULT '' NOT NULL,
- bot_ip VARCHAR(255) DEFAULT '' NOT NULL
+ bot_id INTEGER NOT NULL,
+ bot_active INTEGER DEFAULT 1 NOT NULL,
+ bot_name BLOB SUB_TYPE TEXT DEFAULT '' NOT NULL,
+ user_id INTEGER DEFAULT 0 NOT NULL,
+ bot_agent VARCHAR(255) DEFAULT '' NOT NULL,
+ bot_ip VARCHAR(255) DEFAULT '' NOT NULL
);;
ALTER TABLE phpbb_bots ADD PRIMARY KEY (bot_id);;
@@ -200,41 +199,41 @@ CREATE TRIGGER t_phpbb_bots_gen FOR phpbb_bots
BEFORE INSERT
AS
BEGIN
- NEW.bot_id = GEN_ID(phpbb_bots_gen, 1);
+ NEW.bot_id = GEN_ID(phpbb_bots_gen, 1);
END;;
-# phpbb_config
+# Table: 'phpbb_config'
CREATE TABLE phpbb_config (
- config_name VARCHAR(252) NOT NULL,
- config_value VARCHAR(255) NOT NULL,
- is_dynamic INTEGER DEFAULT 0 NOT NULL
+ config_name VARCHAR(255) DEFAULT '' NOT NULL,
+ config_value VARCHAR(255) DEFAULT '' NOT NULL,
+ is_dynamic INTEGER DEFAULT 0 NOT NULL
);;
ALTER TABLE phpbb_config ADD PRIMARY KEY (config_name);;
CREATE INDEX phpbb_config_is_dynamic ON phpbb_config(is_dynamic);;
-
-# phpbb_confirm
+# Table: 'phpbb_confirm'
CREATE TABLE phpbb_confirm (
- confirm_id CHAR(32) DEFAULT '' NOT NULL,
- session_id CHAR(32) DEFAULT '' NOT NULL,
- confirm_type INTEGER DEFAULT 0 NOT NULL,
- code VARCHAR(8) DEFAULT '' NOT NULL
+ confirm_id CHAR(32) DEFAULT '' NOT NULL,
+ session_id CHAR(32) DEFAULT '' NOT NULL,
+ confirm_type INTEGER DEFAULT 0 NOT NULL,
+ code VARCHAR(8) DEFAULT '' NOT NULL
);;
ALTER TABLE phpbb_confirm ADD PRIMARY KEY (session_id, confirm_id);;
-# phpbb_disallow
+# Table: 'phpbb_disallow'
CREATE TABLE phpbb_disallow (
- disallow_id INTEGER NOT NULL,
- disallow_username VARCHAR(255) DEFAULT '' NOT NULL
+ disallow_id INTEGER NOT NULL,
+ disallow_username VARCHAR(255) DEFAULT '' NOT NULL
);;
ALTER TABLE phpbb_disallow ADD PRIMARY KEY (disallow_id);;
+
CREATE GENERATOR phpbb_disallow_gen;;
SET GENERATOR phpbb_disallow_gen TO 0;;
@@ -242,19 +241,19 @@ CREATE TRIGGER t_phpbb_disallow_gen FOR phpbb_disallow
BEFORE INSERT
AS
BEGIN
- NEW.disallow_id = GEN_ID(phpbb_disallow_gen, 1);
+ NEW.disallow_id = GEN_ID(phpbb_disallow_gen, 1);
END;;
-# phpbb_drafts
+# Table: 'phpbb_drafts'
CREATE TABLE phpbb_drafts (
- draft_id INTEGER NOT NULL,
- user_id INTEGER DEFAULT 0 NOT NULL,
- topic_id INTEGER DEFAULT 0 NOT NULL,
- forum_id INTEGER DEFAULT 0 NOT NULL,
- save_time INTEGER DEFAULT 0 NOT NULL,
- draft_subject BLOB SUB_TYPE TEXT,
- draft_message BLOB SUB_TYPE TEXT
+ draft_id INTEGER NOT NULL,
+ user_id INTEGER DEFAULT 0 NOT NULL,
+ topic_id INTEGER DEFAULT 0 NOT NULL,
+ forum_id INTEGER DEFAULT 0 NOT NULL,
+ save_time INTEGER DEFAULT 0 NOT NULL,
+ draft_subject BLOB SUB_TYPE TEXT DEFAULT '' NOT NULL,
+ draft_message BLOB SUB_TYPE TEXT DEFAULT '' NOT NULL
);;
ALTER TABLE phpbb_drafts ADD PRIMARY KEY (draft_id);;
@@ -268,19 +267,20 @@ CREATE TRIGGER t_phpbb_drafts_gen FOR phpbb_drafts
BEFORE INSERT
AS
BEGIN
- NEW.draft_id = GEN_ID(phpbb_drafts_gen, 1);
+ NEW.draft_id = GEN_ID(phpbb_drafts_gen, 1);
END;;
-# phpbb_extensions
+# Table: 'phpbb_extensions'
CREATE TABLE phpbb_extensions (
- extension_id INTEGER NOT NULL,
- group_id INTEGER DEFAULT 0 NOT NULL,
- extension VARCHAR(100) DEFAULT '' NOT NULL
+ extension_id INTEGER NOT NULL,
+ group_id INTEGER DEFAULT 0 NOT NULL,
+ extension VARCHAR(100) DEFAULT '' NOT NULL
);;
ALTER TABLE phpbb_extensions ADD PRIMARY KEY (extension_id);;
+
CREATE GENERATOR phpbb_extensions_gen;;
SET GENERATOR phpbb_extensions_gen TO 0;;
@@ -288,25 +288,26 @@ CREATE TRIGGER t_phpbb_extensions_gen FOR phpbb_extensions
BEFORE INSERT
AS
BEGIN
- NEW.extension_id = GEN_ID(phpbb_extensions_gen, 1);
+ NEW.extension_id = GEN_ID(phpbb_extensions_gen, 1);
END;;
-# phpbb_extension_groups
+# Table: 'phpbb_extension_groups'
CREATE TABLE phpbb_extension_groups (
- group_id INTEGER NOT NULL,
- group_name VARCHAR(255) NOT NULL,
- cat_id INTEGER DEFAULT 0 NOT NULL,
- allow_group INTEGER DEFAULT 0 NOT NULL,
- download_mode INTEGER DEFAULT 1 NOT NULL,
- upload_icon VARCHAR(255) DEFAULT '' NOT NULL,
- max_filesize INTEGER DEFAULT 0 NOT NULL,
- allowed_forums BLOB SUB_TYPE TEXT,
- allow_in_pm INTEGER DEFAULT 0 NOT NULL
+ group_id INTEGER NOT NULL,
+ group_name VARCHAR(255) DEFAULT '' NOT NULL,
+ cat_id INTEGER DEFAULT 0 NOT NULL,
+ allow_group INTEGER DEFAULT 0 NOT NULL,
+ download_mode INTEGER DEFAULT 1 NOT NULL,
+ upload_icon VARCHAR(255) DEFAULT '' NOT NULL,
+ max_filesize INTEGER DEFAULT 0 NOT NULL,
+ allowed_forums BLOB SUB_TYPE TEXT DEFAULT '' NOT NULL,
+ allow_in_pm INTEGER DEFAULT 0 NOT NULL
);;
ALTER TABLE phpbb_extension_groups ADD PRIMARY KEY (group_id);;
+
CREATE GENERATOR phpbb_extension_groups_gen;;
SET GENERATOR phpbb_extension_groups_gen TO 0;;
@@ -314,54 +315,54 @@ CREATE TRIGGER t_phpbb_extension_groups_gen FOR phpbb_extension_groups
BEFORE INSERT
AS
BEGIN
- NEW.group_id = GEN_ID(phpbb_extension_groups_gen, 1);
+ NEW.group_id = GEN_ID(phpbb_extension_groups_gen, 1);
END;;
-# phpbb_forums
+# Table: 'phpbb_forums'
CREATE TABLE phpbb_forums (
- forum_id INTEGER NOT NULL,
- parent_id INTEGER DEFAULT 0 NOT NULL,
- left_id INTEGER DEFAULT 0 NOT NULL,
- right_id INTEGER DEFAULT 0 NOT NULL,
- forum_parents BLOB SUB_TYPE TEXT,
- forum_name BLOB SUB_TYPE TEXT,
- forum_desc BLOB SUB_TYPE TEXT,
- forum_desc_bitfield INTEGER DEFAULT 0 NOT NULL,
- forum_desc_uid VARCHAR(5) DEFAULT '' NOT NULL,
- forum_link VARCHAR(255) DEFAULT '' NOT NULL,
- forum_password VARCHAR(40) DEFAULT '' NOT NULL,
- forum_style INTEGER,
- forum_image VARCHAR(255) DEFAULT '' NOT NULL,
- forum_rules BLOB SUB_TYPE TEXT,
- forum_rules_link VARCHAR(255) DEFAULT '' NOT NULL,
- forum_rules_bitfield INTEGER DEFAULT 0 NOT NULL,
- forum_rules_uid VARCHAR(5) DEFAULT '' NOT NULL,
- forum_topics_per_page INTEGER DEFAULT 0 NOT NULL,
- forum_type INTEGER DEFAULT 0 NOT NULL,
- forum_status INTEGER DEFAULT 0 NOT NULL,
- forum_posts INTEGER DEFAULT 0 NOT NULL,
- forum_topics INTEGER DEFAULT 0 NOT NULL,
- forum_topics_real INTEGER DEFAULT 0 NOT NULL,
- forum_last_post_id INTEGER DEFAULT 0 NOT NULL,
- forum_last_poster_id INTEGER DEFAULT 0 NOT NULL,
- forum_last_post_time INTEGER DEFAULT 0 NOT NULL,
- forum_last_poster_name VARCHAR(255),
- forum_flags INTEGER DEFAULT 32 NOT NULL,
- display_on_index INTEGER DEFAULT 1 NOT NULL,
- enable_indexing INTEGER DEFAULT 1 NOT NULL,
- enable_icons INTEGER DEFAULT 1 NOT NULL,
- enable_prune INTEGER DEFAULT 0 NOT NULL,
- prune_next INTEGER,
- prune_days INTEGER DEFAULT 0 NOT NULL,
- prune_viewed INTEGER DEFAULT 0 NOT NULL,
- prune_freq INTEGER DEFAULT 0 NOT NULL
+ forum_id INTEGER NOT NULL,
+ parent_id INTEGER DEFAULT 0 NOT NULL,
+ left_id INTEGER DEFAULT 0 NOT NULL,
+ right_id INTEGER DEFAULT 0 NOT NULL,
+ forum_parents BLOB SUB_TYPE TEXT DEFAULT '' NOT NULL,
+ forum_name BLOB SUB_TYPE TEXT DEFAULT '' NOT NULL,
+ forum_desc BLOB SUB_TYPE TEXT DEFAULT '' NOT NULL,
+ forum_desc_bitfield INTEGER DEFAULT 0 NOT NULL,
+ forum_desc_uid VARCHAR(5) DEFAULT '' NOT NULL,
+ forum_link VARCHAR(255) DEFAULT '' NOT NULL,
+ forum_password VARCHAR(40) DEFAULT '' NOT NULL,
+ forum_style INTEGER DEFAULT 0 NOT NULL,
+ forum_image VARCHAR(255) DEFAULT '' NOT NULL,
+ forum_rules BLOB SUB_TYPE TEXT DEFAULT '' NOT NULL,
+ forum_rules_link VARCHAR(255) DEFAULT '' NOT NULL,
+ forum_rules_bitfield INTEGER DEFAULT 0 NOT NULL,
+ forum_rules_uid VARCHAR(5) DEFAULT '' NOT NULL,
+ forum_topics_per_page INTEGER DEFAULT 0 NOT NULL,
+ forum_type INTEGER DEFAULT 0 NOT NULL,
+ forum_status INTEGER DEFAULT 0 NOT NULL,
+ forum_posts INTEGER DEFAULT 0 NOT NULL,
+ forum_topics INTEGER DEFAULT 0 NOT NULL,
+ forum_topics_real INTEGER DEFAULT 0 NOT NULL,
+ forum_last_post_id INTEGER DEFAULT 0 NOT NULL,
+ forum_last_poster_id INTEGER DEFAULT 0 NOT NULL,
+ forum_last_post_time INTEGER DEFAULT 0 NOT NULL,
+ forum_last_poster_name VARCHAR(255) DEFAULT '' NOT NULL,
+ forum_flags INTEGER DEFAULT 32 NOT NULL,
+ display_on_index INTEGER DEFAULT 1 NOT NULL,
+ enable_indexing INTEGER DEFAULT 1 NOT NULL,
+ enable_icons INTEGER DEFAULT 1 NOT NULL,
+ enable_prune INTEGER DEFAULT 0 NOT NULL,
+ prune_next INTEGER DEFAULT 0 NOT NULL,
+ prune_days INTEGER DEFAULT 0 NOT NULL,
+ prune_viewed INTEGER DEFAULT 0 NOT NULL,
+ prune_freq INTEGER DEFAULT 0 NOT NULL
);;
ALTER TABLE phpbb_forums ADD PRIMARY KEY (forum_id);;
-CREATE INDEX phpbb_forums_forum_lst_post_id ON phpbb_forums(forum_last_post_id);;
CREATE INDEX phpbb_forums_left_right_id ON phpbb_forums(left_id, right_id);;
+CREATE INDEX phpbb_forums_forum_last_post_id ON phpbb_forums(forum_last_post_id);;
CREATE GENERATOR phpbb_forums_gen;;
SET GENERATOR phpbb_forums_gen TO 0;;
@@ -370,62 +371,60 @@ CREATE TRIGGER t_phpbb_forums_gen FOR phpbb_forums
BEFORE INSERT
AS
BEGIN
- NEW.forum_id = GEN_ID(phpbb_forums_gen, 1);
+ NEW.forum_id = GEN_ID(phpbb_forums_gen, 1);
END;;
-# phpbb_forums_access
+# Table: 'phpbb_forums_access'
CREATE TABLE phpbb_forums_access (
- forum_id INTEGER DEFAULT 0 NOT NULL,
- user_id INTEGER DEFAULT 0 NOT NULL,
- session_id VARCHAR(32) DEFAULT '' NOT NULL
+ forum_id INTEGER DEFAULT 0 NOT NULL,
+ user_id INTEGER DEFAULT 0 NOT NULL,
+ session_id CHAR(32) DEFAULT '' NOT NULL
);;
ALTER TABLE phpbb_forums_access ADD PRIMARY KEY (forum_id, user_id, session_id);;
-# phpbb_forums_track
+# Table: 'phpbb_forums_track'
CREATE TABLE phpbb_forums_track (
- user_id INTEGER DEFAULT 0 NOT NULL,
- forum_id INTEGER DEFAULT 0 NOT NULL,
- mark_time INTEGER DEFAULT 0 NOT NULL
+ user_id INTEGER DEFAULT 0 NOT NULL,
+ forum_id INTEGER DEFAULT 0 NOT NULL,
+ mark_time INTEGER DEFAULT 0 NOT NULL
);;
ALTER TABLE phpbb_forums_track ADD PRIMARY KEY (user_id, forum_id);;
-# phpbb_forums_watch
+# Table: 'phpbb_forums_watch'
CREATE TABLE phpbb_forums_watch (
- forum_id INTEGER DEFAULT 0 NOT NULL,
- user_id INTEGER DEFAULT 0 NOT NULL,
- notify_status INTEGER DEFAULT 0 NOT NULL
+ forum_id INTEGER DEFAULT 0 NOT NULL,
+ user_id INTEGER DEFAULT 0 NOT NULL,
+ notify_status INTEGER DEFAULT 0 NOT NULL
);;
CREATE INDEX phpbb_forums_watch_forum_id ON phpbb_forums_watch(forum_id);;
-CREATE INDEX phpbb_forums_watch_notify_stat ON phpbb_forums_watch(notify_status);;
CREATE INDEX phpbb_forums_watch_user_id ON phpbb_forums_watch(user_id);;
+CREATE INDEX phpbb_forums_watch_notify_status ON phpbb_forums_watch(notify_status);;
-
-# phpbb_groups
+# Table: 'phpbb_groups'
CREATE TABLE phpbb_groups (
- group_id INTEGER NOT NULL,
- group_type INTEGER DEFAULT 1 NOT NULL,
- group_name VARCHAR(255) DEFAULT '' NOT NULL,
- group_desc BLOB SUB_TYPE TEXT,
- group_desc_bitfield INTEGER DEFAULT 0 NOT NULL,
- group_desc_uid VARCHAR(5) DEFAULT '' NOT NULL,
- group_display INTEGER DEFAULT 0 NOT NULL,
- group_avatar VARCHAR(255) DEFAULT '' NOT NULL,
- group_avatar_type INTEGER DEFAULT 0 NOT NULL,
- group_avatar_width INTEGER DEFAULT 0 NOT NULL,
- group_avatar_height INTEGER DEFAULT 0 NOT NULL,
- group_rank INTEGER DEFAULT -1 NOT NULL,
- group_colour VARCHAR(6) DEFAULT '' NOT NULL,
- group_sig_chars INTEGER DEFAULT 0 NOT NULL,
- group_receive_pm INTEGER DEFAULT 0 NOT NULL,
- group_message_limit INTEGER DEFAULT 0 NOT NULL,
- group_chgpass INTEGER DEFAULT 0 NOT NULL,
- group_legend INTEGER DEFAULT 1 NOT NULL
+ group_id INTEGER NOT NULL,
+ group_type INTEGER DEFAULT 1 NOT NULL,
+ group_name VARCHAR(255) DEFAULT '' NOT NULL,
+ group_desc BLOB SUB_TYPE TEXT DEFAULT '' NOT NULL,
+ group_desc_bitfield INTEGER DEFAULT 0 NOT NULL,
+ group_desc_uid VARCHAR(5) DEFAULT '' NOT NULL,
+ group_display INTEGER DEFAULT 0 NOT NULL,
+ group_avatar VARCHAR(255) DEFAULT '' NOT NULL,
+ group_avatar_type INTEGER DEFAULT 0 NOT NULL,
+ group_avatar_width INTEGER DEFAULT 0 NOT NULL,
+ group_avatar_height INTEGER DEFAULT 0 NOT NULL,
+ group_rank INTEGER DEFAULT 0 NOT NULL,
+ group_colour VARCHAR(6) DEFAULT '' NOT NULL,
+ group_sig_chars INTEGER DEFAULT 0 NOT NULL,
+ group_receive_pm INTEGER DEFAULT 0 NOT NULL,
+ group_message_limit INTEGER DEFAULT 0 NOT NULL,
+ group_legend INTEGER DEFAULT 1 NOT NULL
);;
ALTER TABLE phpbb_groups ADD PRIMARY KEY (group_id);;
@@ -439,22 +438,23 @@ CREATE TRIGGER t_phpbb_groups_gen FOR phpbb_groups
BEFORE INSERT
AS
BEGIN
- NEW.group_id = GEN_ID(phpbb_groups_gen, 1);
+ NEW.group_id = GEN_ID(phpbb_groups_gen, 1);
END;;
-# phpbb_icons
+# Table: 'phpbb_icons'
CREATE TABLE phpbb_icons (
- icons_id INTEGER NOT NULL,
- icons_url VARCHAR(255),
- icons_width INTEGER DEFAULT 0 NOT NULL,
- icons_height INTEGER DEFAULT 0 NOT NULL,
- icons_order INTEGER DEFAULT 0 NOT NULL,
- display_on_posting INTEGER DEFAULT 1 NOT NULL
+ icons_id INTEGER NOT NULL,
+ icons_url VARCHAR(255) DEFAULT '' NOT NULL,
+ icons_width INTEGER DEFAULT 0 NOT NULL,
+ icons_height INTEGER DEFAULT 0 NOT NULL,
+ icons_order INTEGER DEFAULT 0 NOT NULL,
+ display_on_posting INTEGER DEFAULT 1 NOT NULL
);;
ALTER TABLE phpbb_icons ADD PRIMARY KEY (icons_id);;
+
CREATE GENERATOR phpbb_icons_gen;;
SET GENERATOR phpbb_icons_gen TO 0;;
@@ -462,22 +462,24 @@ CREATE TRIGGER t_phpbb_icons_gen FOR phpbb_icons
BEFORE INSERT
AS
BEGIN
- NEW.icons_id = GEN_ID(phpbb_icons_gen, 1);
+ NEW.icons_id = GEN_ID(phpbb_icons_gen, 1);
END;;
-# phpbb_lang
+# Table: 'phpbb_lang'
CREATE TABLE phpbb_lang (
- lang_id INTEGER NOT NULL,
- lang_iso VARCHAR(5) NOT NULL,
- lang_dir VARCHAR(30) NOT NULL,
- lang_english_name VARCHAR(100),
- lang_local_name VARCHAR(255),
- lang_author VARCHAR(255)
+ lang_id INTEGER NOT NULL,
+ lang_iso VARCHAR(5) DEFAULT '' NOT NULL,
+ lang_dir VARCHAR(30) DEFAULT '' NOT NULL,
+ lang_english_name VARCHAR(100) DEFAULT '' NOT NULL,
+ lang_local_name VARCHAR(255) DEFAULT '' NOT NULL,
+ lang_author VARCHAR(255) DEFAULT '' NOT NULL
);;
ALTER TABLE phpbb_lang ADD PRIMARY KEY (lang_id);;
+CREATE INDEX phpbb_lang_lang_iso ON phpbb_lang(lang_iso);;
+
CREATE GENERATOR phpbb_lang_gen;;
SET GENERATOR phpbb_lang_gen TO 0;;
@@ -485,30 +487,30 @@ CREATE TRIGGER t_phpbb_lang_gen FOR phpbb_lang
BEFORE INSERT
AS
BEGIN
- NEW.lang_id = GEN_ID(phpbb_lang_gen, 1);
+ NEW.lang_id = GEN_ID(phpbb_lang_gen, 1);
END;;
-# phpbb_log
+# Table: 'phpbb_log'
CREATE TABLE phpbb_log (
- log_id INTEGER NOT NULL,
- log_type INTEGER DEFAULT 0 NOT NULL,
- user_id INTEGER DEFAULT 0 NOT NULL,
- forum_id INTEGER DEFAULT 0 NOT NULL,
- topic_id INTEGER DEFAULT 0 NOT NULL,
- reportee_id INTEGER DEFAULT 0 NOT NULL,
- log_ip VARCHAR(40) NOT NULL,
- log_time INTEGER DEFAULT 0 NOT NULL,
- log_operation BLOB SUB_TYPE TEXT,
- log_data BLOB SUB_TYPE TEXT
+ log_id INTEGER NOT NULL,
+ log_type INTEGER DEFAULT 0 NOT NULL,
+ user_id INTEGER DEFAULT 0 NOT NULL,
+ forum_id INTEGER DEFAULT 0 NOT NULL,
+ topic_id INTEGER DEFAULT 0 NOT NULL,
+ reportee_id INTEGER DEFAULT 0 NOT NULL,
+ log_ip VARCHAR(40) DEFAULT '' NOT NULL,
+ log_time INTEGER DEFAULT 0 NOT NULL,
+ log_operation BLOB SUB_TYPE TEXT DEFAULT '' NOT NULL,
+ log_data BLOB SUB_TYPE TEXT DEFAULT '' NOT NULL
);;
ALTER TABLE phpbb_log ADD PRIMARY KEY (log_id);;
-CREATE INDEX phpbb_log_forum_id ON phpbb_log(forum_id);;
CREATE INDEX phpbb_log_log_type ON phpbb_log(log_type);;
-CREATE INDEX phpbb_log_reportee_id ON phpbb_log(reportee_id);;
+CREATE INDEX phpbb_log_forum_id ON phpbb_log(forum_id);;
CREATE INDEX phpbb_log_topic_id ON phpbb_log(topic_id);;
+CREATE INDEX phpbb_log_reportee_id ON phpbb_log(reportee_id);;
CREATE INDEX phpbb_log_user_id ON phpbb_log(user_id);;
CREATE GENERATOR phpbb_log_gen;;
@@ -518,43 +520,42 @@ CREATE TRIGGER t_phpbb_log_gen FOR phpbb_log
BEFORE INSERT
AS
BEGIN
- NEW.log_id = GEN_ID(phpbb_log_gen, 1);
+ NEW.log_id = GEN_ID(phpbb_log_gen, 1);
END;;
-# phpbb_moderator_cache
+# Table: 'phpbb_moderator_cache'
CREATE TABLE phpbb_moderator_cache (
- forum_id INTEGER NOT NULL,
- user_id INTEGER DEFAULT 0 NOT NULL,
- username VARCHAR(255) DEFAULT '' NOT NULL,
- group_id INTEGER DEFAULT 0 NOT NULL,
- group_name VARCHAR(255) DEFAULT '' NOT NULL,
- display_on_index INTEGER DEFAULT 1 NOT NULL
+ forum_id INTEGER DEFAULT 0 NOT NULL,
+ user_id INTEGER DEFAULT 0 NOT NULL,
+ username VARCHAR(255) DEFAULT '' NOT NULL,
+ group_id INTEGER DEFAULT 0 NOT NULL,
+ group_name VARCHAR(255) DEFAULT '' NOT NULL,
+ display_on_index INTEGER DEFAULT 1 NOT NULL
);;
-CREATE INDEX phpbb_moderator_cche_dis_on_idx ON phpbb_moderator_cache(display_on_index);;
+CREATE INDEX phpbb_moderator_cache_display_on_index ON phpbb_moderator_cache(display_on_index);;
CREATE INDEX phpbb_moderator_cache_forum_id ON phpbb_moderator_cache(forum_id);;
-
-# phpbb_modules
+# Table: 'phpbb_modules'
CREATE TABLE phpbb_modules (
- module_id INTEGER NOT NULL,
- module_enabled INTEGER DEFAULT 1 NOT NULL,
- module_display INTEGER DEFAULT 1 NOT NULL,
- "module_name" VARCHAR(255) DEFAULT '' NOT NULL,
- module_class VARCHAR(10) DEFAULT '' NOT NULL,
- parent_id INTEGER DEFAULT 0 NOT NULL,
- left_id INTEGER DEFAULT 0 NOT NULL,
- right_id INTEGER DEFAULT 0 NOT NULL,
- module_langname VARCHAR(255) DEFAULT '' NOT NULL,
- module_mode VARCHAR(255) DEFAULT '' NOT NULL,
- module_auth VARCHAR(255) DEFAULT '' NOT NULL
+ module_id INTEGER NOT NULL,
+ module_enabled INTEGER DEFAULT 1 NOT NULL,
+ module_display INTEGER DEFAULT 1 NOT NULL,
+ module_basename VARCHAR(255) DEFAULT '' NOT NULL,
+ module_class VARCHAR(10) DEFAULT '' NOT NULL,
+ parent_id INTEGER DEFAULT 0 NOT NULL,
+ left_id INTEGER DEFAULT 0 NOT NULL,
+ right_id INTEGER DEFAULT 0 NOT NULL,
+ module_langname VARCHAR(255) DEFAULT '' NOT NULL,
+ module_mode VARCHAR(255) DEFAULT '' NOT NULL,
+ module_auth VARCHAR(255) DEFAULT '' NOT NULL
);;
ALTER TABLE phpbb_modules ADD PRIMARY KEY (module_id);;
-CREATE INDEX phpbb_modules_module_enabled ON phpbb_modules(module_enabled);;
CREATE INDEX phpbb_modules_left_right_id ON phpbb_modules(left_id, right_id);;
+CREATE INDEX phpbb_modules_module_enabled ON phpbb_modules(module_enabled);;
CREATE INDEX phpbb_modules_class_left_id ON phpbb_modules(module_class, left_id);;
CREATE GENERATOR phpbb_modules_gen;;
@@ -564,72 +565,71 @@ CREATE TRIGGER t_phpbb_modules_gen FOR phpbb_modules
BEFORE INSERT
AS
BEGIN
- NEW.module_id = GEN_ID(phpbb_modules_gen, 1);
+ NEW.module_id = GEN_ID(phpbb_modules_gen, 1);
END;;
-# phpbb_poll_options
+# Table: 'phpbb_poll_options'
CREATE TABLE phpbb_poll_options (
- poll_option_id INTEGER DEFAULT 0 NOT NULL,
- topic_id INTEGER DEFAULT 0 NOT NULL,
- poll_option_text BLOB SUB_TYPE TEXT,
- poll_option_total INTEGER DEFAULT 0 NOT NULL
+ poll_option_id INTEGER DEFAULT 0 NOT NULL,
+ topic_id INTEGER DEFAULT 0 NOT NULL,
+ poll_option_text BLOB SUB_TYPE TEXT DEFAULT '' NOT NULL,
+ poll_option_total INTEGER DEFAULT 0 NOT NULL
);;
-CREATE INDEX phpbb_poll_options_poll_opt_id ON phpbb_poll_options(poll_option_id);;
+CREATE INDEX phpbb_poll_options_poll_option_id ON phpbb_poll_options(poll_option_id);;
CREATE INDEX phpbb_poll_options_topic_id ON phpbb_poll_options(topic_id);;
-
-# phpbb_poll_votes
+# Table: 'phpbb_poll_votes'
CREATE TABLE phpbb_poll_votes (
- topic_id INTEGER DEFAULT 0 NOT NULL,
- poll_option_id INTEGER DEFAULT 0 NOT NULL,
- vote_user_id INTEGER DEFAULT 0 NOT NULL,
- vote_user_ip VARCHAR(40) NOT NULL
+ topic_id INTEGER DEFAULT 0 NOT NULL,
+ poll_option_id INTEGER DEFAULT 0 NOT NULL,
+ vote_user_id INTEGER DEFAULT 0 NOT NULL,
+ vote_user_ip VARCHAR(40) DEFAULT '' NOT NULL
);;
+CREATE INDEX phpbb_poll_votes_topic_id ON phpbb_poll_votes(topic_id);;
CREATE INDEX phpbb_poll_votes_vote_user_id ON phpbb_poll_votes(vote_user_id);;
CREATE INDEX phpbb_poll_votes_vote_user_ip ON phpbb_poll_votes(vote_user_ip);;
-
-# phpbb_posts
+# Table: 'phpbb_posts'
CREATE TABLE phpbb_posts (
- post_id INTEGER NOT NULL,
- topic_id INTEGER DEFAULT 0 NOT NULL,
- forum_id INTEGER DEFAULT 0 NOT NULL,
- poster_id INTEGER DEFAULT 0 NOT NULL,
- icon_id INTEGER DEFAULT 0 NOT NULL,
- poster_ip VARCHAR(40) NOT NULL,
- post_time INTEGER DEFAULT 0 NOT NULL,
- post_approved INTEGER DEFAULT 1 NOT NULL,
- post_reported INTEGER DEFAULT 0 NOT NULL,
- enable_bbcode INTEGER DEFAULT 1 NOT NULL,
- enable_smilies INTEGER DEFAULT 1 NOT NULL,
- enable_magic_url INTEGER DEFAULT 1 NOT NULL,
- enable_sig INTEGER DEFAULT 1 NOT NULL,
- post_username VARCHAR(255),
- post_subject BLOB SUB_TYPE TEXT NOT NULL,
- post_text BLOB SUB_TYPE TEXT NOT NULL,
- post_checksum VARCHAR(32) NOT NULL,
- post_encoding VARCHAR(20) DEFAULT 'iso-8859-1' NOT NULL,
- post_attachment INTEGER DEFAULT 0 NOT NULL,
- bbcode_bitfield INTEGER DEFAULT 0 NOT NULL,
- bbcode_uid VARCHAR(5) DEFAULT '' NOT NULL,
- post_edit_time INTEGER DEFAULT 0,
- post_edit_reason BLOB SUB_TYPE TEXT,
- post_edit_user INTEGER DEFAULT 0,
- post_edit_count INTEGER DEFAULT 0,
- post_edit_locked INTEGER DEFAULT 0
+ post_id INTEGER NOT NULL,
+ topic_id INTEGER DEFAULT 0 NOT NULL,
+ forum_id INTEGER DEFAULT 0 NOT NULL,
+ poster_id INTEGER DEFAULT 0 NOT NULL,
+ icon_id INTEGER DEFAULT 0 NOT NULL,
+ poster_ip VARCHAR(40) DEFAULT '' NOT NULL,
+ post_time INTEGER DEFAULT 0 NOT NULL,
+ post_approved INTEGER DEFAULT 1 NOT NULL,
+ post_reported INTEGER DEFAULT 0 NOT NULL,
+ enable_bbcode INTEGER DEFAULT 1 NOT NULL,
+ enable_smilies INTEGER DEFAULT 1 NOT NULL,
+ enable_magic_url INTEGER DEFAULT 1 NOT NULL,
+ enable_sig INTEGER DEFAULT 1 NOT NULL,
+ post_username VARCHAR(255) DEFAULT '' NOT NULL,
+ post_subject BLOB SUB_TYPE TEXT DEFAULT '' NOT NULL,
+ post_text BLOB SUB_TYPE TEXT DEFAULT '' NOT NULL,
+ post_checksum VARCHAR(32) DEFAULT '' NOT NULL,
+ post_encoding VARCHAR(20) DEFAULT 'iso-8859-1' NOT NULL,
+ post_attachment INTEGER DEFAULT 0 NOT NULL,
+ bbcode_bitfield INTEGER DEFAULT 0 NOT NULL,
+ bbcode_uid VARCHAR(5) DEFAULT '' NOT NULL,
+ post_edit_time INTEGER DEFAULT 0 NOT NULL,
+ post_edit_reason BLOB SUB_TYPE TEXT DEFAULT '' NOT NULL,
+ post_edit_user INTEGER DEFAULT 0 NOT NULL,
+ post_edit_count INTEGER DEFAULT 0 NOT NULL,
+ post_edit_locked INTEGER DEFAULT 0 NOT NULL
);;
ALTER TABLE phpbb_posts ADD PRIMARY KEY (post_id);;
CREATE INDEX phpbb_posts_forum_id ON phpbb_posts(forum_id);;
+CREATE INDEX phpbb_posts_topic_id ON phpbb_posts(topic_id);;
+CREATE INDEX phpbb_posts_poster_ip ON phpbb_posts(poster_ip);;
+CREATE INDEX phpbb_posts_poster_id ON phpbb_posts(poster_id);;
CREATE INDEX phpbb_posts_post_approved ON phpbb_posts(post_approved);;
CREATE INDEX phpbb_posts_post_time ON phpbb_posts(post_time);;
-CREATE INDEX phpbb_posts_poster_id ON phpbb_posts(poster_id);;
-CREATE INDEX phpbb_posts_poster_ip ON phpbb_posts(poster_ip);;
-CREATE INDEX phpbb_posts_topic_id ON phpbb_posts(topic_id);;
CREATE GENERATOR phpbb_posts_gen;;
SET GENERATOR phpbb_posts_gen TO 0;;
@@ -638,41 +638,41 @@ CREATE TRIGGER t_phpbb_posts_gen FOR phpbb_posts
BEFORE INSERT
AS
BEGIN
- NEW.post_id = GEN_ID(phpbb_posts_gen, 1);
+ NEW.post_id = GEN_ID(phpbb_posts_gen, 1);
END;;
-# phpbb_privmsgs
+# Table: 'phpbb_privmsgs'
CREATE TABLE phpbb_privmsgs (
- msg_id INTEGER NOT NULL,
- root_level INTEGER DEFAULT 0 NOT NULL,
- author_id INTEGER DEFAULT 0 NOT NULL,
- icon_id INTEGER DEFAULT 0 NOT NULL,
- author_ip VARCHAR(40) DEFAULT '' NOT NULL,
- message_time INTEGER DEFAULT 0 NOT NULL,
- enable_bbcode INTEGER DEFAULT 1 NOT NULL,
- enable_smilies INTEGER DEFAULT 1 NOT NULL,
- enable_magic_url INTEGER DEFAULT 1 NOT NULL,
- enable_sig INTEGER DEFAULT 1 NOT NULL,
- message_subject BLOB SUB_TYPE TEXT NOT NULL,
- message_text BLOB SUB_TYPE TEXT NOT NULL,
- message_edit_reason BLOB SUB_TYPE TEXT,
- message_edit_user INTEGER DEFAULT 0,
- message_encoding VARCHAR(20) DEFAULT 'iso-8859-1' NOT NULL,
- message_attachment INTEGER DEFAULT 0 NOT NULL,
- bbcode_bitfield INTEGER DEFAULT 0 NOT NULL,
- bbcode_uid VARCHAR(5) DEFAULT '' NOT NULL,
- message_edit_time INTEGER DEFAULT 0,
- message_edit_count INTEGER DEFAULT 0,
- to_address BLOB SUB_TYPE TEXT NOT NULL,
- bcc_address BLOB SUB_TYPE TEXT NOT NULL
+ msg_id INTEGER NOT NULL,
+ root_level INTEGER DEFAULT 0 NOT NULL,
+ author_id INTEGER DEFAULT 0 NOT NULL,
+ icon_id INTEGER DEFAULT 0 NOT NULL,
+ author_ip VARCHAR(40) DEFAULT '' NOT NULL,
+ message_time INTEGER DEFAULT 0 NOT NULL,
+ enable_bbcode INTEGER DEFAULT 1 NOT NULL,
+ enable_smilies INTEGER DEFAULT 1 NOT NULL,
+ enable_magic_url INTEGER DEFAULT 1 NOT NULL,
+ enable_sig INTEGER DEFAULT 1 NOT NULL,
+ message_subject BLOB SUB_TYPE TEXT DEFAULT '' NOT NULL,
+ message_text BLOB SUB_TYPE TEXT DEFAULT '' NOT NULL,
+ message_edit_reason BLOB SUB_TYPE TEXT DEFAULT '' NOT NULL,
+ message_edit_user INTEGER DEFAULT 0 NOT NULL,
+ message_encoding VARCHAR(20) DEFAULT 'iso-8859-1' NOT NULL,
+ message_attachment INTEGER DEFAULT 0 NOT NULL,
+ bbcode_bitfield INTEGER DEFAULT 0 NOT NULL,
+ bbcode_uid VARCHAR(5) DEFAULT '' NOT NULL,
+ message_edit_time INTEGER DEFAULT 0 NOT NULL,
+ message_edit_count INTEGER DEFAULT 0 NOT NULL,
+ to_address BLOB SUB_TYPE TEXT DEFAULT '' NOT NULL,
+ bcc_address BLOB SUB_TYPE TEXT DEFAULT '' NOT NULL
);;
ALTER TABLE phpbb_privmsgs ADD PRIMARY KEY (msg_id);;
-CREATE INDEX phpbb_privmsgs_author_id ON phpbb_privmsgs(author_id);;
CREATE INDEX phpbb_privmsgs_author_ip ON phpbb_privmsgs(author_ip);;
CREATE INDEX phpbb_privmsgs_message_time ON phpbb_privmsgs(message_time);;
+CREATE INDEX phpbb_privmsgs_author_id ON phpbb_privmsgs(author_id);;
CREATE INDEX phpbb_privmsgs_root_level ON phpbb_privmsgs(root_level);;
CREATE GENERATOR phpbb_privmsgs_gen;;
@@ -682,16 +682,16 @@ CREATE TRIGGER t_phpbb_privmsgs_gen FOR phpbb_privmsgs
BEFORE INSERT
AS
BEGIN
- NEW.msg_id = GEN_ID(phpbb_privmsgs_gen, 1);
+ NEW.msg_id = GEN_ID(phpbb_privmsgs_gen, 1);
END;;
-# phpbb_privmsgs_folder
+# Table: 'phpbb_privmsgs_folder'
CREATE TABLE phpbb_privmsgs_folder (
- folder_id INTEGER NOT NULL,
- user_id INTEGER DEFAULT 0 NOT NULL,
- folder_name VARCHAR(255) DEFAULT '' NOT NULL,
- pm_count INTEGER DEFAULT 0 NOT NULL
+ folder_id INTEGER NOT NULL,
+ user_id INTEGER DEFAULT 0 NOT NULL,
+ folder_name VARCHAR(255) DEFAULT '' NOT NULL,
+ pm_count INTEGER DEFAULT 0 NOT NULL
);;
ALTER TABLE phpbb_privmsgs_folder ADD PRIMARY KEY (folder_id);;
@@ -705,25 +705,26 @@ CREATE TRIGGER t_phpbb_privmsgs_folder_gen FOR phpbb_privmsgs_folder
BEFORE INSERT
AS
BEGIN
- NEW.folder_id = GEN_ID(phpbb_privmsgs_folder_gen, 1);
+ NEW.folder_id = GEN_ID(phpbb_privmsgs_folder_gen, 1);
END;;
-# phpbb_privmsgs_rules
+# Table: 'phpbb_privmsgs_rules'
CREATE TABLE phpbb_privmsgs_rules (
- rule_id INTEGER NOT NULL,
- user_id INTEGER DEFAULT 0 NOT NULL,
- rule_check INTEGER DEFAULT 0 NOT NULL,
- rule_connection INTEGER DEFAULT 0 NOT NULL,
- rule_string VARCHAR(255) DEFAULT '' NOT NULL,
- rule_user_id INTEGER DEFAULT 0 NOT NULL,
- rule_group_id INTEGER DEFAULT 0 NOT NULL,
- rule_action INTEGER DEFAULT 0 NOT NULL,
- rule_folder_id INTEGER DEFAULT 0 NOT NULL
+ rule_id INTEGER NOT NULL,
+ user_id INTEGER DEFAULT 0 NOT NULL,
+ rule_check INTEGER DEFAULT 0 NOT NULL,
+ rule_connection INTEGER DEFAULT 0 NOT NULL,
+ rule_string VARCHAR(255) DEFAULT '' NOT NULL,
+ rule_user_id INTEGER DEFAULT 0 NOT NULL,
+ rule_group_id INTEGER DEFAULT 0 NOT NULL,
+ rule_action INTEGER DEFAULT 0 NOT NULL,
+ rule_folder_id INTEGER DEFAULT 0 NOT NULL
);;
ALTER TABLE phpbb_privmsgs_rules ADD PRIMARY KEY (rule_id);;
+
CREATE GENERATOR phpbb_privmsgs_rules_gen;;
SET GENERATOR phpbb_privmsgs_rules_gen TO 0;;
@@ -731,52 +732,51 @@ CREATE TRIGGER t_phpbb_privmsgs_rules_gen FOR phpbb_privmsgs_rules
BEFORE INSERT
AS
BEGIN
- NEW.rule_id = GEN_ID(phpbb_privmsgs_rules_gen, 1);
+ NEW.rule_id = GEN_ID(phpbb_privmsgs_rules_gen, 1);
END;;
-# phpbb_privmsgs_to
+# Table: 'phpbb_privmsgs_to'
CREATE TABLE phpbb_privmsgs_to (
- msg_id INTEGER DEFAULT 0 NOT NULL,
- user_id INTEGER DEFAULT 0 NOT NULL,
- author_id INTEGER DEFAULT 0 NOT NULL,
- deleted INTEGER DEFAULT 0 NOT NULL,
- new INTEGER DEFAULT 1 NOT NULL,
- unread INTEGER DEFAULT 1 NOT NULL,
- replied INTEGER DEFAULT 0 NOT NULL,
- marked INTEGER DEFAULT 0 NOT NULL,
- forwarded INTEGER DEFAULT 0 NOT NULL,
- folder_id INTEGER DEFAULT 0 NOT NULL
+ msg_id INTEGER DEFAULT 0 NOT NULL,
+ user_id INTEGER DEFAULT 0 NOT NULL,
+ author_id INTEGER DEFAULT 0 NOT NULL,
+ pm_deleted INTEGER DEFAULT 0 NOT NULL,
+ pm_new INTEGER DEFAULT 1 NOT NULL,
+ pm_unread INTEGER DEFAULT 1 NOT NULL,
+ pm_replied INTEGER DEFAULT 0 NOT NULL,
+ pm_marked INTEGER DEFAULT 0 NOT NULL,
+ pm_forwarded INTEGER DEFAULT 0 NOT NULL,
+ folder_id INTEGER DEFAULT 0 NOT NULL
);;
CREATE INDEX phpbb_privmsgs_to_msg_id ON phpbb_privmsgs_to(msg_id);;
-CREATE INDEX phpbb_privmsgs_to_user_id ON phpbb_privmsgs_to(user_id, folder_id);;
+CREATE INDEX phpbb_privmsgs_to_user_folder_id ON phpbb_privmsgs_to(user_id, folder_id);;
-
-# phpbb_profile_fields
+# Table: 'phpbb_profile_fields'
CREATE TABLE phpbb_profile_fields (
- field_id INTEGER NOT NULL,
- field_name VARCHAR(255) NOT NULL,
- field_type INTEGER DEFAULT 0 NOT NULL,
- field_ident VARCHAR(20) DEFAULT '' NOT NULL,
- field_length VARCHAR(20) DEFAULT '' NOT NULL,
- field_minlen VARCHAR(255) DEFAULT '' NOT NULL,
- field_maxlen VARCHAR(255) DEFAULT '' NOT NULL,
- field_novalue VARCHAR(255) DEFAULT '' NOT NULL,
- field_default_value VARCHAR(255) DEFAULT '0' NOT NULL,
- field_validation VARCHAR(20) DEFAULT '' NOT NULL,
- field_required INTEGER DEFAULT 0 NOT NULL,
- field_show_on_reg INTEGER DEFAULT 0 NOT NULL,
- field_hide INTEGER DEFAULT 0 NOT NULL,
- field_no_view INTEGER DEFAULT 0 NOT NULL,
- field_active INTEGER DEFAULT 0 NOT NULL,
- field_order INTEGER DEFAULT 0 NOT NULL
+ field_id INTEGER NOT NULL,
+ field_name VARCHAR(255) DEFAULT '' NOT NULL,
+ field_type INTEGER DEFAULT 0 NOT NULL,
+ field_ident VARCHAR(20) DEFAULT '' NOT NULL,
+ field_length VARCHAR(20) DEFAULT '' NOT NULL,
+ field_minlen VARCHAR(255) DEFAULT '' NOT NULL,
+ field_maxlen VARCHAR(255) DEFAULT '' NOT NULL,
+ field_novalue VARCHAR(255) DEFAULT '' NOT NULL,
+ field_default_value VARCHAR(255) DEFAULT '' NOT NULL,
+ field_validation VARCHAR(20) DEFAULT '' NOT NULL,
+ field_required INTEGER DEFAULT 0 NOT NULL,
+ field_show_on_reg INTEGER DEFAULT 0 NOT NULL,
+ field_hide INTEGER DEFAULT 0 NOT NULL,
+ field_no_view INTEGER DEFAULT 0 NOT NULL,
+ field_active INTEGER DEFAULT 0 NOT NULL,
+ field_order INTEGER DEFAULT 0 NOT NULL
);;
ALTER TABLE phpbb_profile_fields ADD PRIMARY KEY (field_id);;
-CREATE INDEX phpbb_profile_fields_field_ord ON phpbb_profile_fields(field_order);;
CREATE INDEX phpbb_profile_fields_field_type ON phpbb_profile_fields(field_type);;
+CREATE INDEX phpbb_profile_fields_field_order ON phpbb_profile_fields(field_order);;
CREATE GENERATOR phpbb_profile_fields_gen;;
SET GENERATOR phpbb_profile_fields_gen TO 0;;
@@ -785,53 +785,54 @@ CREATE TRIGGER t_phpbb_profile_fields_gen FOR phpbb_profile_fields
BEFORE INSERT
AS
BEGIN
- NEW.field_id = GEN_ID(phpbb_profile_fields_gen, 1);
+ NEW.field_id = GEN_ID(phpbb_profile_fields_gen, 1);
END;;
-# phpbb_profile_fields_data
+# Table: 'phpbb_profile_fields_data'
CREATE TABLE phpbb_profile_fields_data (
- user_id INTEGER DEFAULT 0 NOT NULL
+ user_id INTEGER DEFAULT 0 NOT NULL
);;
ALTER TABLE phpbb_profile_fields_data ADD PRIMARY KEY (user_id);;
-# phpbb_profile_fields_lang
+# Table: 'phpbb_profile_fields_lang'
CREATE TABLE phpbb_profile_fields_lang (
- field_id INTEGER DEFAULT 0 NOT NULL,
- lang_id INTEGER DEFAULT 0 NOT NULL,
- option_id INTEGER DEFAULT 0 NOT NULL,
- field_type INTEGER DEFAULT 0 NOT NULL,
- "value" VARCHAR(255) DEFAULT '' NOT NULL
+ field_id INTEGER DEFAULT 0 NOT NULL,
+ lang_id INTEGER DEFAULT 0 NOT NULL,
+ option_id INTEGER DEFAULT 0 NOT NULL,
+ field_type INTEGER DEFAULT 0 NOT NULL,
+ lang_value VARCHAR(255) DEFAULT '' NOT NULL
);;
ALTER TABLE phpbb_profile_fields_lang ADD PRIMARY KEY (field_id, lang_id, option_id);;
-# phpbb_profile_lang
+# Table: 'phpbb_profile_lang'
CREATE TABLE phpbb_profile_lang (
- field_id INTEGER DEFAULT 0 NOT NULL,
- lang_id INTEGER DEFAULT 0 NOT NULL,
- lang_name VARCHAR(255) DEFAULT '' NOT NULL,
- lang_explain BLOB SUB_TYPE TEXT,
- lang_default_value VARCHAR(255) DEFAULT '' NOT NULL
+ field_id INTEGER DEFAULT 0 NOT NULL,
+ lang_id INTEGER DEFAULT 0 NOT NULL,
+ lang_name VARCHAR(255) DEFAULT '' NOT NULL,
+ lang_explain BLOB SUB_TYPE TEXT DEFAULT '' NOT NULL,
+ lang_default_value VARCHAR(255) DEFAULT '' NOT NULL
);;
ALTER TABLE phpbb_profile_lang ADD PRIMARY KEY (field_id, lang_id);;
-# phpbb_ranks
+# Table: 'phpbb_ranks'
CREATE TABLE phpbb_ranks (
- rank_id INTEGER NOT NULL,
- rank_title VARCHAR(255) NOT NULL,
- rank_min INTEGER DEFAULT 0 NOT NULL,
- rank_special INTEGER DEFAULT 0 ,
- rank_image VARCHAR(255)
+ rank_id INTEGER NOT NULL,
+ rank_title VARCHAR(255) DEFAULT '' NOT NULL,
+ rank_min INTEGER DEFAULT 0 NOT NULL,
+ rank_special INTEGER DEFAULT 0 NOT NULL,
+ rank_image VARCHAR(255) DEFAULT '' NOT NULL
);;
ALTER TABLE phpbb_ranks ADD PRIMARY KEY (rank_id);;
+
CREATE GENERATOR phpbb_ranks_gen;;
SET GENERATOR phpbb_ranks_gen TO 0;;
@@ -839,24 +840,25 @@ CREATE TRIGGER t_phpbb_ranks_gen FOR phpbb_ranks
BEFORE INSERT
AS
BEGIN
- NEW.rank_id = GEN_ID(phpbb_ranks_gen, 1);
+ NEW.rank_id = GEN_ID(phpbb_ranks_gen, 1);
END;;
-# phpbb_reports
+# Table: 'phpbb_reports'
CREATE TABLE phpbb_reports (
- report_id INTEGER NOT NULL,
- reason_id INTEGER DEFAULT 0 NOT NULL,
- post_id INTEGER DEFAULT 0 NOT NULL,
- user_id INTEGER DEFAULT 0 NOT NULL,
- user_notify INTEGER DEFAULT 0 NOT NULL,
- report_closed INTEGER DEFAULT 0 NOT NULL,
- report_time INTEGER DEFAULT 0 NOT NULL,
- report_text BLOB SUB_TYPE TEXT
+ report_id INTEGER NOT NULL,
+ reason_id INTEGER DEFAULT 0 NOT NULL,
+ post_id INTEGER DEFAULT 0 NOT NULL,
+ user_id INTEGER DEFAULT 0 NOT NULL,
+ user_notify INTEGER DEFAULT 0 NOT NULL,
+ report_closed INTEGER DEFAULT 0 NOT NULL,
+ report_time INTEGER DEFAULT 0 NOT NULL,
+ report_text BLOB SUB_TYPE TEXT DEFAULT '' NOT NULL
);;
ALTER TABLE phpbb_reports ADD PRIMARY KEY (report_id);;
+
CREATE GENERATOR phpbb_reports_gen;;
SET GENERATOR phpbb_reports_gen TO 0;;
@@ -864,20 +866,21 @@ CREATE TRIGGER t_phpbb_reports_gen FOR phpbb_reports
BEFORE INSERT
AS
BEGIN
- NEW.report_id = GEN_ID(phpbb_reports_gen, 1);
+ NEW.report_id = GEN_ID(phpbb_reports_gen, 1);
END;;
-# phpbb_reports_reasons
+# Table: 'phpbb_reports_reasons'
CREATE TABLE phpbb_reports_reasons (
- reason_id INTEGER NOT NULL,
- reason_title VARCHAR(255) DEFAULT '' NOT NULL,
- reason_description BLOB SUB_TYPE TEXT,
- reason_order INTEGER DEFAULT 0 NOT NULL
+ reason_id INTEGER NOT NULL,
+ reason_title VARCHAR(255) DEFAULT '' NOT NULL,
+ reason_description BLOB SUB_TYPE TEXT DEFAULT '' NOT NULL,
+ reason_order INTEGER DEFAULT 0 NOT NULL
);;
ALTER TABLE phpbb_reports_reasons ADD PRIMARY KEY (reason_id);;
+
CREATE GENERATOR phpbb_reports_reasons_gen;;
SET GENERATOR phpbb_reports_reasons_gen TO 0;;
@@ -885,26 +888,26 @@ CREATE TRIGGER t_phpbb_reports_reasons_gen FOR phpbb_reports_reasons
BEFORE INSERT
AS
BEGIN
- NEW.reason_id = GEN_ID(phpbb_reports_reasons_gen, 1);
+ NEW.reason_id = GEN_ID(phpbb_reports_reasons_gen, 1);
END;;
-# phpbb_search_results
+# Table: 'phpbb_search_results'
CREATE TABLE phpbb_search_results (
- search_key VARCHAR(32) DEFAULT '' NOT NULL,
- search_time INTEGER DEFAULT 0 NOT NULL,
- search_keywords BLOB SUB_TYPE TEXT,
- search_authors BLOB SUB_TYPE TEXT
+ search_key VARCHAR(32) DEFAULT '' NOT NULL,
+ search_time INTEGER DEFAULT 0 NOT NULL,
+ search_keywords BLOB SUB_TYPE TEXT DEFAULT '' NOT NULL,
+ search_authors BLOB SUB_TYPE TEXT DEFAULT '' NOT NULL
);;
ALTER TABLE phpbb_search_results ADD PRIMARY KEY (search_key);;
-# phpbb_search_wordlist
+# Table: 'phpbb_search_wordlist'
CREATE TABLE phpbb_search_wordlist (
- word_text VARCHAR(252) DEFAULT '' NOT NULL,
- word_id INTEGER NOT NULL,
- word_common INTEGER DEFAULT 0 NOT NULL
+ word_text VARCHAR(252) DEFAULT '' NOT NULL,
+ word_id INTEGER NOT NULL,
+ word_common INTEGER DEFAULT 0 NOT NULL
);;
ALTER TABLE phpbb_search_wordlist ADD PRIMARY KEY (word_text);;
@@ -918,32 +921,32 @@ CREATE TRIGGER t_phpbb_search_wordlist_gen FOR phpbb_search_wordlist
BEFORE INSERT
AS
BEGIN
- NEW.word_id = GEN_ID(phpbb_search_wordlist_gen, 1);
+ NEW.word_id = GEN_ID(phpbb_search_wordlist_gen, 1);
END;;
-# phpbb_search_wordmatch
+# Table: 'phpbb_search_wordmatch'
CREATE TABLE phpbb_search_wordmatch (
- post_id INTEGER DEFAULT 0 NOT NULL,
- word_id INTEGER DEFAULT 0 NOT NULL,
- title_match INTEGER DEFAULT 0 NOT NULL
+ post_id INTEGER DEFAULT 0 NOT NULL,
+ word_id INTEGER DEFAULT 0 NOT NULL,
+ title_match INTEGER DEFAULT 0 NOT NULL
);;
CREATE INDEX phpbb_search_wordmatch_word_id ON phpbb_search_wordmatch(word_id);;
-# phpbb_sessions
+# Table: 'phpbb_sessions'
CREATE TABLE phpbb_sessions (
- session_id VARCHAR(32) DEFAULT '' NOT NULL,
- session_user_id INTEGER DEFAULT 0 NOT NULL,
- session_last_visit INTEGER DEFAULT 0 NOT NULL,
- session_start INTEGER DEFAULT 0 NOT NULL,
- session_time INTEGER DEFAULT 0 NOT NULL,
- session_ip VARCHAR(40) DEFAULT '0' NOT NULL,
- session_browser VARCHAR(150) DEFAULT '' NOT NULL,
- session_page VARCHAR(200) DEFAULT '' NOT NULL,
- session_viewonline INTEGER DEFAULT 1 NOT NULL,
- session_autologin INTEGER DEFAULT 0 NOT NULL,
- session_admin INTEGER DEFAULT 0 NOT NULL
+ session_id CHAR(32) DEFAULT '' NOT NULL,
+ session_user_id INTEGER DEFAULT 0 NOT NULL,
+ session_last_visit INTEGER DEFAULT 0 NOT NULL,
+ session_start INTEGER DEFAULT 0 NOT NULL,
+ session_time INTEGER DEFAULT 0 NOT NULL,
+ session_ip VARCHAR(40) DEFAULT '' NOT NULL,
+ session_browser VARCHAR(150) DEFAULT '' NOT NULL,
+ session_page VARCHAR(255) DEFAULT '' NOT NULL,
+ session_viewonline INTEGER DEFAULT 1 NOT NULL,
+ session_autologin INTEGER DEFAULT 0 NOT NULL,
+ session_admin INTEGER DEFAULT 0 NOT NULL
);;
ALTER TABLE phpbb_sessions ADD PRIMARY KEY (session_id);;
@@ -951,30 +954,29 @@ ALTER TABLE phpbb_sessions ADD PRIMARY KEY (session_id);;
CREATE INDEX phpbb_sessions_session_time ON phpbb_sessions(session_time);;
CREATE INDEX phpbb_sessions_session_user_id ON phpbb_sessions(session_user_id);;
-
-# phpbb_sessions_keys
+# Table: 'phpbb_sessions_keys'
CREATE TABLE phpbb_sessions_keys (
- key_id VARCHAR(32) DEFAULT '' NOT NULL,
- user_id INTEGER DEFAULT 0 NOT NULL,
- last_ip VARCHAR(40) DEFAULT '0' NOT NULL,
- last_login INTEGER DEFAULT 0 NOT NULL
+ key_id CHAR(32) DEFAULT '' NOT NULL,
+ user_id INTEGER DEFAULT 0 NOT NULL,
+ last_ip VARCHAR(40) DEFAULT '' NOT NULL,
+ last_login INTEGER DEFAULT 0 NOT NULL
);;
ALTER TABLE phpbb_sessions_keys ADD PRIMARY KEY (key_id, user_id);;
CREATE INDEX phpbb_sessions_keys_last_login ON phpbb_sessions_keys(last_login);;
-
-# phpbb_sitelist
+# Table: 'phpbb_sitelist'
CREATE TABLE phpbb_sitelist (
- site_id INTEGER NOT NULL,
- site_ip VARCHAR(40) DEFAULT '' NOT NULL,
- site_hostname VARCHAR(255) DEFAULT '' NOT NULL,
- ip_exclude INTEGER DEFAULT 0 NOT NULL
+ site_id INTEGER NOT NULL,
+ site_ip VARCHAR(40) DEFAULT '' NOT NULL,
+ site_hostname VARCHAR(255) DEFAULT '' NOT NULL,
+ ip_exclude INTEGER DEFAULT 0 NOT NULL
);;
ALTER TABLE phpbb_sitelist ADD PRIMARY KEY (site_id);;
+
CREATE GENERATOR phpbb_sitelist_gen;;
SET GENERATOR phpbb_sitelist_gen TO 0;;
@@ -982,24 +984,26 @@ CREATE TRIGGER t_phpbb_sitelist_gen FOR phpbb_sitelist
BEFORE INSERT
AS
BEGIN
- NEW.site_id = GEN_ID(phpbb_sitelist_gen, 1);
+ NEW.site_id = GEN_ID(phpbb_sitelist_gen, 1);
END;;
-# phpbb_smilies
+# Table: 'phpbb_smilies'
CREATE TABLE phpbb_smilies (
- smiley_id INTEGER NOT NULL,
- code VARCHAR(50),
- emotion VARCHAR(50),
- smiley_url VARCHAR(50),
- smiley_width INTEGER DEFAULT 0 NOT NULL,
- smiley_height INTEGER DEFAULT 0 NOT NULL,
- smiley_order INTEGER DEFAULT 0 NOT NULL,
- display_on_posting INTEGER DEFAULT 1 NOT NULL
+ smiley_id INTEGER NOT NULL,
+ code VARCHAR(50) DEFAULT '' NOT NULL,
+ emotion VARCHAR(50) DEFAULT '' NOT NULL,
+ smiley_url VARCHAR(50) DEFAULT '' NOT NULL,
+ smiley_width INTEGER DEFAULT 0 NOT NULL,
+ smiley_height INTEGER DEFAULT 0 NOT NULL,
+ smiley_order INTEGER DEFAULT 0 NOT NULL,
+ display_on_posting INTEGER DEFAULT 1 NOT NULL
);;
ALTER TABLE phpbb_smilies ADD PRIMARY KEY (smiley_id);;
+CREATE INDEX phpbb_smilies_display_on_posting ON phpbb_smilies(display_on_posting);;
+
CREATE GENERATOR phpbb_smilies_gen;;
SET GENERATOR phpbb_smilies_gen TO 0;;
@@ -1007,75 +1011,96 @@ CREATE TRIGGER t_phpbb_smilies_gen FOR phpbb_smilies
BEFORE INSERT
AS
BEGIN
- NEW.smiley_id = GEN_ID(phpbb_smilies_gen, 1);
+ NEW.smiley_id = GEN_ID(phpbb_smilies_gen, 1);
END;;
-# phpbb_styles
+# Table: 'phpbb_styles'
CREATE TABLE phpbb_styles (
- style_id INTEGER NOT NULL,
- style_name VARCHAR(252) DEFAULT '' NOT NULL,
- style_copyright VARCHAR(255) DEFAULT '' NOT NULL,
- style_active INTEGER DEFAULT 1 NOT NULL,
- template_id INTEGER DEFAULT 0 NOT NULL,
- theme_id INTEGER DEFAULT 0 NOT NULL,
- imageset_id INTEGER DEFAULT 0 NOT NULL
+ style_id INTEGER NOT NULL,
+ style_name VARCHAR(255) DEFAULT '' NOT NULL,
+ style_copyright VARCHAR(255) DEFAULT '' NOT NULL,
+ style_active INTEGER DEFAULT 1 NOT NULL,
+ template_id INTEGER DEFAULT 0 NOT NULL,
+ theme_id INTEGER DEFAULT 0 NOT NULL,
+ imageset_id INTEGER DEFAULT 0 NOT NULL
);;
ALTER TABLE phpbb_styles ADD PRIMARY KEY (style_id);;
-CREATE UNIQUE INDEX phpbb_styles_tmplte_nm ON phpbb_styles(template_name);;
+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);;
-# phpbb_styles_template
+CREATE GENERATOR phpbb_styles_gen;;
+SET GENERATOR phpbb_styles_gen TO 0;;
+
+CREATE TRIGGER t_phpbb_styles_gen FOR phpbb_styles
+BEFORE INSERT
+AS
+BEGIN
+ NEW.style_id = GEN_ID(phpbb_styles_gen, 1);
+END;;
+
+
+# Table: 'phpbb_styles_template'
CREATE TABLE phpbb_styles_template (
- template_id INTEGER NOT NULL,
- template_name VARCHAR(252) NOT NULL,
- template_copyright VARCHAR(255) NOT NULL,
- template_path VARCHAR(100) NOT NULL,
- bbcode_bitfield INTEGER DEFAULT 6921 NOT NULL,
- template_storedb INTEGER DEFAULT 0 NOT NULL
+ template_id INTEGER NOT NULL,
+ template_name VARCHAR(255) DEFAULT '' NOT NULL,
+ template_copyright VARCHAR(255) DEFAULT '' NOT NULL,
+ template_path VARCHAR(100) DEFAULT '' NOT NULL,
+ bbcode_bitfield INTEGER DEFAULT 6921 NOT NULL,
+ template_storedb INTEGER DEFAULT 0 NOT NULL
);;
ALTER TABLE phpbb_styles_template ADD PRIMARY KEY (template_id);;
-CREATE UNIQUE INDEX phpbb_styles_template_tmplte_nm ON phpbb_styles_template(template_name);;
+CREATE UNIQUE INDEX phpbb_styles_template_template_name ON phpbb_styles_template(template_name);;
+CREATE GENERATOR phpbb_styles_template_gen;;
+SET GENERATOR phpbb_styles_template_gen TO 0;;
-# phpbb_styles_template_data
+CREATE TRIGGER t_phpbb_styles_template_gen FOR phpbb_styles_template
+BEFORE INSERT
+AS
+BEGIN
+ NEW.template_id = GEN_ID(phpbb_styles_template_gen, 1);
+END;;
+
+
+# Table: 'phpbb_styles_template_data'
CREATE TABLE phpbb_styles_template_data (
- template_id INTEGER DEFAULT 0 NOT NULL,
- template_filename VARCHAR(100) DEFAULT '' NOT NULL,
- template_included BLOB SUB_TYPE TEXT,
- template_mtime INTEGER DEFAULT 0 NOT NULL,
- template_data BLOB SUB_TYPE TEXT
+ template_id INTEGER NOT NULL,
+ template_filename VARCHAR(100) DEFAULT '' NOT NULL,
+ template_included BLOB SUB_TYPE TEXT DEFAULT '' NOT NULL,
+ template_mtime INTEGER DEFAULT 0 NOT NULL,
+ template_data BLOB SUB_TYPE TEXT DEFAULT '' NOT NULL
);;
-CREATE INDEX phpbb_styles_tmplte_d_tmpl_flnm ON phpbb_styles_template_data(template_filename);;
-CREATE INDEX phpbb_styles_tmplte_dt_tmplt_id ON phpbb_styles_template_data(template_id);;
+CREATE INDEX phpbb_styles_template_data_template_id ON phpbb_styles_template_data(template_id);;
+CREATE INDEX phpbb_styles_template_data_template_filename ON phpbb_styles_template_data(template_filename);;
-CREATE GENERATOR phpbb_styles_templte_data_gen;;
-SET GENERATOR phpbb_styles_templte_data_gen TO 0;;
+CREATE GENERATOR phpbb_styles_template_data_gen;;
+SET GENERATOR phpbb_styles_template_data_gen TO 0;;
-CREATE TRIGGER t_phpbb_styles_templte_data_gen FOR phpbb_styles_template
+CREATE TRIGGER t_phpbb_styles_template_data_gen FOR phpbb_styles_template_data
BEFORE INSERT
AS
BEGIN
- NEW.template_id = GEN_ID(phpbb_styles_templte_data_gen, 1);
+ NEW.template_id = GEN_ID(phpbb_styles_template_data_gen, 1);
END;;
-# phpbb_styles_theme
+# Table: 'phpbb_styles_theme'
CREATE TABLE phpbb_styles_theme (
- theme_id INTEGER NOT NULL,
- theme_name VARCHAR(252) DEFAULT '' NOT NULL,
- theme_copyright VARCHAR(255) DEFAULT '' NOT NULL,
- theme_path VARCHAR(100) DEFAULT '' NOT NULL,
- theme_storedb INTEGER DEFAULT 0 NOT NULL,
- theme_mtime INTEGER DEFAULT 0 NOT NULL,
- theme_data BLOB SUB_TYPE TEXT
+ theme_id INTEGER NOT NULL,
+ theme_name VARCHAR(255) DEFAULT '' NOT NULL,
+ theme_copyright VARCHAR(255) DEFAULT '' NOT NULL,
+ theme_path VARCHAR(100) DEFAULT '' NOT NULL,
+ theme_storedb INTEGER DEFAULT 0 NOT NULL,
+ theme_mtime INTEGER DEFAULT 0 NOT NULL,
+ theme_data BLOB SUB_TYPE TEXT DEFAULT '' NOT NULL
);;
ALTER TABLE phpbb_styles_theme ADD PRIMARY KEY (theme_id);;
@@ -1089,127 +1114,110 @@ CREATE TRIGGER t_phpbb_styles_theme_gen FOR phpbb_styles_theme
BEFORE INSERT
AS
BEGIN
- NEW.theme_id = GEN_ID(phpbb_styles_theme_gen, 1);
-END;;
-
-ALTER TABLE phpbb_styles ADD PRIMARY KEY (style_id);;
-
-CREATE UNIQUE INDEX phpbb_styles_style_name ON phpbb_styles(style_name);;
-CREATE INDEX phpbb_styles_imageset_id ON phpbb_styles(imageset_id);;
-CREATE INDEX phpbb_styles_template_id ON phpbb_styles(template_id);;
-CREATE INDEX phpbb_styles_theme_id ON phpbb_styles(theme_id);;
-
-CREATE GENERATOR phpbb_styles_gen;;
-SET GENERATOR phpbb_styles_gen TO 0;;
-
-CREATE TRIGGER t_phpbb_styles_gen FOR phpbb_styles
-BEFORE INSERT
-AS
-BEGIN
- NEW.style_id = GEN_ID(phpbb_styles_gen, 1);
+ NEW.theme_id = GEN_ID(phpbb_styles_theme_gen, 1);
END;;
-# phpbb_styles_imageset
+# Table: 'phpbb_styles_imageset'
CREATE TABLE phpbb_styles_imageset (
- imageset_id INTEGER NOT NULL,
- imageset_name VARCHAR(252) DEFAULT '' NOT NULL,
- imageset_copyright VARCHAR(255) DEFAULT '' NOT NULL,
- imageset_path VARCHAR(100) DEFAULT '' NOT NULL,
- site_logo VARCHAR(200) DEFAULT '' NOT NULL,
- btn_post VARCHAR(200) DEFAULT '' NOT NULL,
- btn_post_pm VARCHAR(200) DEFAULT '' NOT NULL,
- btn_reply VARCHAR(200) DEFAULT '' NOT NULL,
- btn_reply_pm VARCHAR(200) DEFAULT '' NOT NULL,
- btn_locked VARCHAR(200) DEFAULT '' NOT NULL,
- btn_profile VARCHAR(200) DEFAULT '' NOT NULL,
- btn_pm VARCHAR(200) DEFAULT '' NOT NULL,
- btn_delete VARCHAR(200) DEFAULT '' NOT NULL,
- btn_info VARCHAR(200) DEFAULT '' NOT NULL,
- btn_quote VARCHAR(200) DEFAULT '' NOT NULL,
- btn_search VARCHAR(200) DEFAULT '' NOT NULL,
- btn_edit VARCHAR(200) DEFAULT '' NOT NULL,
- btn_report VARCHAR(200) DEFAULT '' NOT NULL,
- btn_email VARCHAR(200) DEFAULT '' NOT NULL,
- btn_www VARCHAR(200) DEFAULT '' NOT NULL,
- btn_icq VARCHAR(200) DEFAULT '' NOT NULL,
- btn_aim VARCHAR(200) DEFAULT '' NOT NULL,
- btn_yim VARCHAR(200) DEFAULT '' NOT NULL,
- btn_msnm VARCHAR(200) DEFAULT '' NOT NULL,
- btn_jabber VARCHAR(200) DEFAULT '' NOT NULL,
- btn_online VARCHAR(200) DEFAULT '' NOT NULL,
- btn_offline VARCHAR(200) DEFAULT '' NOT NULL,
- btn_friend VARCHAR(200) DEFAULT '' NOT NULL,
- btn_foe VARCHAR(200) DEFAULT '' NOT NULL,
- icon_unapproved VARCHAR(200) DEFAULT '' NOT NULL,
- icon_reported VARCHAR(200) DEFAULT '' NOT NULL,
- icon_attach VARCHAR(200) DEFAULT '' NOT NULL,
- icon_post VARCHAR(200) DEFAULT '' NOT NULL,
- icon_post_new VARCHAR(200) DEFAULT '' NOT NULL,
- icon_post_latest VARCHAR(200) DEFAULT '' NOT NULL,
- icon_post_newest VARCHAR(200) DEFAULT '' NOT NULL,
- forum VARCHAR(200) DEFAULT '' NOT NULL,
- forum_new VARCHAR(200) DEFAULT '' NOT NULL,
- forum_locked VARCHAR(200) DEFAULT '' NOT NULL,
- forum_link VARCHAR(200) DEFAULT '' NOT NULL,
- sub_forum VARCHAR(200) DEFAULT '' NOT NULL,
- sub_forum_new VARCHAR(200) DEFAULT '' NOT NULL,
- folder VARCHAR(200) DEFAULT '' NOT NULL,
- folder_moved VARCHAR(200) DEFAULT '' NOT NULL,
- folder_posted VARCHAR(200) DEFAULT '' NOT NULL,
- folder_new VARCHAR(200) DEFAULT '' NOT NULL,
- folder_new_posted VARCHAR(200) DEFAULT '' NOT NULL,
- folder_hot VARCHAR(200) DEFAULT '' NOT NULL,
- folder_hot_posted VARCHAR(200) DEFAULT '' NOT NULL,
- folder_hot_new VARCHAR(200) DEFAULT '' NOT NULL,
- folder_hot_new_posted VARCHAR(200) DEFAULT '' NOT NULL,
- folder_locked VARCHAR(200) DEFAULT '' NOT NULL,
- folder_locked_posted VARCHAR(200) DEFAULT '' NOT NULL,
- folder_locked_new VARCHAR(200) DEFAULT '' NOT NULL,
- folder_locked_new_posted VARCHAR(200) DEFAULT '' NOT NULL,
- folder_locked_announce VARCHAR(200) DEFAULT '' NOT NULL,
- folder_locked_announce_new VARCHAR(200) DEFAULT '' NOT NULL,
- folder_locked_announce_posted VARCHAR(200) DEFAULT '' NOT NULL,
- folder_locked_announce_new_posted VARCHAR(200) DEFAULT '' NOT NULL,
- folder_locked_global VARCHAR(200) DEFAULT '' NOT NULL,
- folder_locked_global_new VARCHAR(200) DEFAULT '' NOT NULL,
- folder_locked_global_posted VARCHAR(200) DEFAULT '' NOT NULL,
- folder_locked_global_new_posted VARCHAR(200) DEFAULT '' NOT NULL,
- folder_locked_sticky VARCHAR(200) DEFAULT '' NOT NULL,
- folder_locked_sticky_new VARCHAR(200) DEFAULT '' NOT NULL,
- folder_locked_sticky_posted VARCHAR(200) DEFAULT '' NOT NULL,
- folder_locked_sticky_new_posted VARCHAR(200) DEFAULT '' NOT NULL,
- folder_sticky VARCHAR(200) DEFAULT '' NOT NULL,
- folder_sticky_posted VARCHAR(200) DEFAULT '' NOT NULL,
- folder_sticky_new VARCHAR(200) DEFAULT '' NOT NULL,
- folder_sticky_new_posted VARCHAR(200) DEFAULT '' NOT NULL,
- folder_announce VARCHAR(200) DEFAULT '' NOT NULL,
- folder_announce_posted VARCHAR(200) DEFAULT '' NOT NULL,
- folder_announce_new VARCHAR(200) DEFAULT '' NOT NULL,
- folder_announce_new_posted VARCHAR(200) DEFAULT '' NOT NULL,
- folder_global VARCHAR(200) DEFAULT '' NOT NULL,
- folder_global_posted VARCHAR(200) DEFAULT '' NOT NULL,
- folder_global_new VARCHAR(200) DEFAULT '' NOT NULL,
- folder_global_new_posted 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,
- attach_progress_bar 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
+ imageset_id INTEGER 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,
+ btn_post VARCHAR(200) DEFAULT '' NOT NULL,
+ btn_post_pm VARCHAR(200) DEFAULT '' NOT NULL,
+ btn_reply VARCHAR(200) DEFAULT '' NOT NULL,
+ btn_reply_pm VARCHAR(200) DEFAULT '' NOT NULL,
+ btn_locked VARCHAR(200) DEFAULT '' NOT NULL,
+ btn_profile VARCHAR(200) DEFAULT '' NOT NULL,
+ btn_pm VARCHAR(200) DEFAULT '' NOT NULL,
+ btn_delete VARCHAR(200) DEFAULT '' NOT NULL,
+ btn_info VARCHAR(200) DEFAULT '' NOT NULL,
+ btn_quote VARCHAR(200) DEFAULT '' NOT NULL,
+ btn_search VARCHAR(200) DEFAULT '' NOT NULL,
+ btn_edit VARCHAR(200) DEFAULT '' NOT NULL,
+ btn_report VARCHAR(200) DEFAULT '' NOT NULL,
+ btn_email VARCHAR(200) DEFAULT '' NOT NULL,
+ btn_www VARCHAR(200) DEFAULT '' NOT NULL,
+ btn_icq VARCHAR(200) DEFAULT '' NOT NULL,
+ btn_aim VARCHAR(200) DEFAULT '' NOT NULL,
+ btn_yim VARCHAR(200) DEFAULT '' NOT NULL,
+ btn_msnm VARCHAR(200) DEFAULT '' NOT NULL,
+ btn_jabber VARCHAR(200) DEFAULT '' NOT NULL,
+ btn_online VARCHAR(200) DEFAULT '' NOT NULL,
+ btn_offline VARCHAR(200) DEFAULT '' NOT NULL,
+ btn_friend VARCHAR(200) DEFAULT '' NOT NULL,
+ btn_foe VARCHAR(200) DEFAULT '' NOT NULL,
+ icon_unapproved VARCHAR(200) DEFAULT '' NOT NULL,
+ icon_reported VARCHAR(200) DEFAULT '' NOT NULL,
+ icon_attach VARCHAR(200) DEFAULT '' NOT NULL,
+ icon_post VARCHAR(200) DEFAULT '' NOT NULL,
+ icon_post_new VARCHAR(200) DEFAULT '' NOT NULL,
+ icon_post_latest VARCHAR(200) DEFAULT '' NOT NULL,
+ icon_post_newest VARCHAR(200) DEFAULT '' NOT NULL,
+ forum VARCHAR(200) DEFAULT '' NOT NULL,
+ forum_new VARCHAR(200) DEFAULT '' NOT NULL,
+ forum_locked VARCHAR(200) DEFAULT '' NOT NULL,
+ forum_link VARCHAR(200) DEFAULT '' NOT NULL,
+ sub_forum VARCHAR(200) DEFAULT '' NOT NULL,
+ sub_forum_new VARCHAR(200) DEFAULT '' NOT NULL,
+ folder VARCHAR(200) DEFAULT '' NOT NULL,
+ folder_moved VARCHAR(200) DEFAULT '' NOT NULL,
+ folder_posted VARCHAR(200) DEFAULT '' NOT NULL,
+ folder_new VARCHAR(200) DEFAULT '' NOT NULL,
+ folder_new_posted VARCHAR(200) DEFAULT '' NOT NULL,
+ folder_hot VARCHAR(200) DEFAULT '' NOT NULL,
+ folder_hot_posted VARCHAR(200) DEFAULT '' NOT NULL,
+ folder_hot_new VARCHAR(200) DEFAULT '' NOT NULL,
+ folder_hot_new_posted VARCHAR(200) DEFAULT '' NOT NULL,
+ folder_locked VARCHAR(200) DEFAULT '' NOT NULL,
+ folder_locked_posted VARCHAR(200) DEFAULT '' NOT NULL,
+ folder_locked_new VARCHAR(200) DEFAULT '' NOT NULL,
+ folder_locked_new_posted VARCHAR(200) DEFAULT '' NOT NULL,
+ folder_locked_announce VARCHAR(200) DEFAULT '' NOT NULL,
+ folder_locked_announce_new VARCHAR(200) DEFAULT '' NOT NULL,
+ folder_locked_announce_posted VARCHAR(200) DEFAULT '' NOT NULL,
+ folder_locked_announce_new_posted VARCHAR(200) DEFAULT '' NOT NULL,
+ folder_locked_global VARCHAR(200) DEFAULT '' NOT NULL,
+ folder_locked_global_new VARCHAR(200) DEFAULT '' NOT NULL,
+ folder_locked_global_posted VARCHAR(200) DEFAULT '' NOT NULL,
+ folder_locked_global_new_posted VARCHAR(200) DEFAULT '' NOT NULL,
+ folder_locked_sticky VARCHAR(200) DEFAULT '' NOT NULL,
+ folder_locked_sticky_new VARCHAR(200) DEFAULT '' NOT NULL,
+ folder_locked_sticky_posted VARCHAR(200) DEFAULT '' NOT NULL,
+ folder_locked_sticky_new_posted VARCHAR(200) DEFAULT '' NOT NULL,
+ folder_sticky VARCHAR(200) DEFAULT '' NOT NULL,
+ folder_sticky_posted VARCHAR(200) DEFAULT '' NOT NULL,
+ folder_sticky_new VARCHAR(200) DEFAULT '' NOT NULL,
+ folder_sticky_new_posted VARCHAR(200) DEFAULT '' NOT NULL,
+ folder_announce VARCHAR(200) DEFAULT '' NOT NULL,
+ folder_announce_posted VARCHAR(200) DEFAULT '' NOT NULL,
+ folder_announce_new VARCHAR(200) DEFAULT '' NOT NULL,
+ folder_announce_new_posted VARCHAR(200) DEFAULT '' NOT NULL,
+ folder_global VARCHAR(200) DEFAULT '' NOT NULL,
+ folder_global_posted VARCHAR(200) DEFAULT '' NOT NULL,
+ folder_global_new VARCHAR(200) DEFAULT '' NOT NULL,
+ folder_global_new_posted 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,
+ attach_progress_bar 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
);;
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 UNIQUE INDEX phpbb_styles_imageset_imageset_name ON phpbb_styles_imageset(imageset_name);;
CREATE GENERATOR phpbb_styles_imageset_gen;;
SET GENERATOR phpbb_styles_imageset_gen TO 0;;
@@ -1218,49 +1226,50 @@ CREATE TRIGGER t_phpbb_styles_imageset_gen FOR phpbb_styles_imageset
BEFORE INSERT
AS
BEGIN
- NEW.imageset_id = GEN_ID(phpbb_styles_imageset_gen, 1);
+ NEW.imageset_id = GEN_ID(phpbb_styles_imageset_gen, 1);
END;;
-# phpbb_topics
+
+# Table: 'phpbb_topics'
CREATE TABLE phpbb_topics (
- topic_id INTEGER NOT NULL,
- forum_id INTEGER DEFAULT 0 NOT NULL,
- icon_id INTEGER DEFAULT 1 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 BLOB SUB_TYPE TEXT,
- 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),
- topic_last_post_id INTEGER DEFAULT 0 NOT NULL,
- topic_last_poster_id INTEGER DEFAULT 0 NOT NULL,
- topic_last_poster_name VARCHAR(255),
- 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 BLOB SUB_TYPE TEXT NULL,
- poll_start INTEGER DEFAULT 0 NULL,
- poll_length INTEGER DEFAULT 0 NULL,
- poll_max_options INTEGER DEFAULT 1 NOT NULL,
- poll_last_vote INTEGER DEFAULT 0 ,
- poll_vote_change INTEGER DEFAULT 0 NOT NULL
+ 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 BLOB SUB_TYPE TEXT DEFAULT '' NOT NULL,
+ 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) 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) DEFAULT '' NOT NULL,
+ 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 BLOB SUB_TYPE TEXT DEFAULT '' NOT NULL,
+ 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_topic_last_pst_tme ON phpbb_topics(topic_last_post_time);;
+CREATE INDEX phpbb_topics_topic_last_post_time ON phpbb_topics(topic_last_post_time);;
CREATE GENERATOR phpbb_topics_gen;;
SET GENERATOR phpbb_topics_gen TO 0;;
@@ -1269,135 +1278,133 @@ CREATE TRIGGER t_phpbb_topics_gen FOR phpbb_topics
BEFORE INSERT
AS
BEGIN
- NEW.topic_id = GEN_ID(phpbb_topics_gen, 1);
+ NEW.topic_id = GEN_ID(phpbb_topics_gen, 1);
END;;
-# phpbb_topics_track
+# 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
+ 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);;
-
-# phpbb_topics_posted
+# 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
+ 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);;
-# phpbb_topics_watch
+# 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
+ 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_notify_stat ON phpbb_topics_watch(notify_status);;
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_status ON phpbb_topics_watch(notify_status);;
-
-# phpbb_user_group
+# 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
+ 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_group_leader ON phpbb_user_group(group_leader);;
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);;
-
-# phpbb_users
+# 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,
- user_perm_from INTEGER DEFAULT 0 NULL,
- user_ip VARCHAR(40) DEFAULT '' NOT NULL,
- user_regdate INTEGER DEFAULT 0 NOT NULL,
- username VARCHAR(252) DEFAULT '' NOT NULL,
- user_password VARCHAR(40) DEFAULT '' NOT NULL,
- user_passchg INTEGER DEFAULT 0,
- user_email VARCHAR(100) DEFAULT '' NOT NULL,
- user_email_hash DOUBLE PRECISION DEFAULT 0 NOT NULL,
- user_birthday VARCHAR(10) DEFAULT '',
- 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) DEFAULT '' NOT NULL,
- user_last_confirm_key VARCHAR(10) DEFAULT '',
- user_last_search INTEGER DEFAULT 0,
- user_warnings INTEGER DEFAULT 0,
- user_last_warning INTEGER DEFAULT 0,
- user_login_attempts INTEGER DEFAULT 0,
- user_posts INTEGER DEFAULT 0 NOT NULL,
- user_lang VARCHAR(30) DEFAULT '' NOT NULL,
- user_timezone DOUBLE PRECISION DEFAULT 0 NOT NULL,
- user_dst INTEGER DEFAULT 0 NOT NULL,
- user_dateformat VARCHAR(30) DEFAULT 'd M Y H:i' NOT NULL,
- user_style INTEGER DEFAULT 0 NOT NULL,
- user_rank INTEGER DEFAULT 0 ,
- user_colour VARCHAR(6) 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) DEFAULT 't' NOT NULL,
- user_topic_sortby_dir VARCHAR(1) DEFAULT 'd' NOT NULL,
- user_post_show_days INTEGER 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 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_email 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 893 NOT NULL,
- user_avatar VARCHAR(255) 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,
- user_sig_bbcode_uid VARCHAR(5) DEFAULT '',
- user_sig_bbcode_bitfield INTEGER DEFAULT 0,
- user_from VARCHAR(100) DEFAULT '',
- user_icq VARCHAR(15) DEFAULT '',
- user_aim VARCHAR(255) DEFAULT '',
- user_yim VARCHAR(255) DEFAULT '',
- user_msnm VARCHAR(255) DEFAULT '',
- user_jabber VARCHAR(255) DEFAULT '',
- user_website VARCHAR(200) DEFAULT '',
- user_occ VARCHAR(255) DEFAULT '',
- user_interests VARCHAR(255) DEFAULT '',
- user_actkey VARCHAR(32) DEFAULT '' NOT NULL,
- user_newpasswd VARCHAR(32) DEFAULT ''
+ 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 DEFAULT '' NOT NULL,
+ user_perm_from INTEGER DEFAULT 0 NOT NULL,
+ user_ip VARCHAR(40) DEFAULT '' NOT NULL,
+ user_regdate INTEGER DEFAULT 0 NOT NULL,
+ username VARCHAR(255) DEFAULT '' NOT NULL,
+ user_password VARCHAR(40) DEFAULT '' NOT NULL,
+ user_passchg INTEGER DEFAULT 0 NOT NULL,
+ user_email VARCHAR(100) DEFAULT '' NOT NULL,
+ user_email_hash DOUBLE PRECISION DEFAULT 0 NOT NULL,
+ user_birthday VARCHAR(10) 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) DEFAULT '' NOT NULL,
+ user_last_confirm_key VARCHAR(10) 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_posts INTEGER DEFAULT 0 NOT NULL,
+ user_lang VARCHAR(30) DEFAULT '' NOT NULL,
+ user_timezone DOUBLE PRECISION DEFAULT 0 NOT NULL,
+ user_dst INTEGER DEFAULT 0 NOT NULL,
+ user_dateformat VARCHAR(30) DEFAULT 'd M Y H:i' NOT NULL,
+ user_style INTEGER DEFAULT 0 NOT NULL,
+ user_rank INTEGER DEFAULT 0 NOT NULL,
+ user_colour VARCHAR(6) 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) DEFAULT 't' NOT NULL,
+ user_topic_sortby_dir VARCHAR(1) DEFAULT 'd' NOT NULL,
+ user_post_show_days INTEGER 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 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_email 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 893 NOT NULL,
+ user_avatar VARCHAR(255) 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 DEFAULT '' NOT NULL,
+ user_sig_bbcode_uid VARCHAR(5) DEFAULT '' NOT NULL,
+ user_sig_bbcode_bitfield INTEGER DEFAULT 0 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(255) DEFAULT '' NOT NULL,
+ user_interests BLOB SUB_TYPE TEXT DEFAULT '' NOT NULL,
+ user_actkey VARCHAR(32) DEFAULT '' NOT NULL,
+ user_newpasswd VARCHAR(32) DEFAULT '' NOT NULL
);;
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 ON phpbb_users(username);;
CREATE GENERATOR phpbb_users_gen;;
@@ -1407,21 +1414,22 @@ CREATE TRIGGER t_phpbb_users_gen FOR phpbb_users
BEFORE INSERT
AS
BEGIN
- NEW.user_id = GEN_ID(phpbb_users_gen, 1);
+ NEW.user_id = GEN_ID(phpbb_users_gen, 1);
END;;
-# phpbb_warnings
+# 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
+ 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;;
@@ -1429,19 +1437,20 @@ CREATE TRIGGER t_phpbb_warnings_gen FOR phpbb_warnings
BEFORE INSERT
AS
BEGIN
- NEW.warning_id = GEN_ID(phpbb_warnings_gen, 1);
+ NEW.warning_id = GEN_ID(phpbb_warnings_gen, 1);
END;;
-# phpbb_words
+# Table: 'phpbb_words'
CREATE TABLE phpbb_words (
- word_id INTEGER NOT NULL,
- word VARCHAR(255) NOT NULL,
- replacement VARCHAR(255) NOT NULL
+ word_id INTEGER NOT NULL,
+ word VARCHAR(255) DEFAULT '' NOT NULL,
+ replacement VARCHAR(255) DEFAULT '' NOT NULL
);;
ALTER TABLE phpbb_words ADD PRIMARY KEY (word_id);;
+
CREATE GENERATOR phpbb_words_gen;;
SET GENERATOR phpbb_words_gen TO 0;;
@@ -1449,26 +1458,29 @@ CREATE TRIGGER t_phpbb_words_gen FOR phpbb_words
BEFORE INSERT
AS
BEGIN
- NEW.word_id = GEN_ID(phpbb_words_gen, 1);
+ NEW.word_id = GEN_ID(phpbb_words_gen, 1);
END;;
-# phpbb_zebra
+# 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
+ 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
);;
CREATE INDEX phpbb_zebra_user_id ON phpbb_zebra(user_id);;
CREATE INDEX phpbb_zebra_zebra_id ON phpbb_zebra(zebra_id);;
+
+
DECLARE EXTERNAL FUNCTION STRLEN
- CSTRING(32767)
+ CSTRING(32767)
RETURNS INTEGER BY VALUE
ENTRY_POINT 'IB_UDF_strlen' MODULE_NAME 'ib_udf';;
DECLARE EXTERNAL FUNCTION LOWER CSTRING(80)
RETURNS CSTRING(80) FREE_IT
-ENTRY_POINT 'IB_UDF_lower' MODULE_NAME 'ib_udf';; \ No newline at end of file
+ENTRY_POINT 'IB_UDF_lower' MODULE_NAME 'ib_udf';;
+