array('group_display', 0, ''),

array('group_legend', 0, ''),

array('group_name', 'groups.group_name', 'phpbb_convert_group_name'), // phpbb_set_encoding called in phpbb_convert_group_name

array('group_desc', 'groups.group_description', 'phpbb_set_encoding'),

'where' => 'groups.group_single_user = 0',

$sql = 'SELECT group_id

FROM ' . GROUPS_TABLE . "

$result = $db->sql_query($sql);

$bot_group_id = (int) $db->sql_fetchfield('group_id');

$db->sql_freeresult($result);

}

/**

* Convert the group type constants

*/

function phpbb_convert_group_type($group_type)

'UINT' => 'INT4', // unsigned

'UINT:' => 'INT4', // unsigned

'USINT' => 'INT2', // unsigned

'TINT:' => 'INT2',

'VCHAR' => 'varchar(255)',

'VCHAR:' => 'varchar(%d)',

'DECIMAL' => 'decimal(5,2)',

'VCHAR_UNI' => 'varchar(255)',

'VCHAR_UNI:'=> 'varchar(%d)',

'VARBINARY' => 'bytea',

),

);

$sql = 'SELECT group_id

FROM ' . GROUPS_TABLE . "

$result = $db->sql_query($sql);

$group_id = (int) $db->sql_fetchfield('group_id');

$db->sql_freeresult($result);

);

CREATE INDEX phpbb_config_is_dynamic ON phpbb_config (is_dynamic) PCTFREE 10 MINPCTUSED 10 ALLOW REVERSE SCANS PAGE SPLIT SYMMETRIC COLLECT SAMPLED DETAILED STATISTICS;

/*

Table: 'phpbb_confirm'

group_type smallint NOT NULL DEFAULT 1,

group_founder_manage smallint NOT NULL DEFAULT 0,

group_name varchar(255) NOT NULL DEFAULT '',

group_desc clob(65K) NOT NULL DEFAULT '',

group_desc_bitfield varchar(255) NOT NULL DEFAULT '',

group_desc_options integer NOT NULL DEFAULT 7,

PRIMARY KEY (user_id, zebra_id)

);

ALTER TABLE phpbb_config ADD PRIMARY KEY (config_name);;

CREATE INDEX phpbb_config_is_dynamic ON phpbb_config(is_dynamic);;

# Table: 'phpbb_confirm'

CREATE TABLE phpbb_confirm (

group_type INTEGER DEFAULT 1 NOT NULL,

group_founder_manage INTEGER DEFAULT 0 NOT NULL,

group_name VARCHAR(255) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,

group_desc BLOB SUB_TYPE TEXT CHARACTER SET UTF8 DEFAULT '' NOT NULL,

group_desc_bitfield VARCHAR(255) CHARACTER SET NONE DEFAULT '' NOT NULL,

group_desc_options INTEGER DEFAULT 7 NOT NULL,

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

CREATE INDEX [is_dynamic] ON [phpbb_config]([is_dynamic]) ON [PRIMARY]

GO

/*

Table: 'phpbb_confirm'

[group_type] [int] DEFAULT (1) NOT NULL ,

[group_founder_manage] [int] DEFAULT (0) NOT NULL ,

[group_name] [varchar] (255) DEFAULT ('') NOT NULL ,

[group_desc] [varchar] (4000) DEFAULT ('') NOT NULL ,

[group_desc_bitfield] [varchar] (255) DEFAULT ('') NOT NULL ,

[group_desc_options] [int] DEFAULT (7) NOT NULL ,

) ON [PRIMARY]

GO

COMMIT

config_value varchar(255) DEFAULT '' NOT NULL,

is_dynamic tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,

PRIMARY KEY (config_name),

) CHARACTER SET `utf8` COLLATE `utf8_bin`;

group_type tinyint(4) DEFAULT '1' NOT NULL,

group_founder_manage tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,

group_name varchar(255) DEFAULT '' NOT NULL,

group_desc text NOT NULL,

group_desc_bitfield varchar(255) DEFAULT '' NOT NULL,

group_desc_options int(11) UNSIGNED DEFAULT '7' NOT NULL,

zebra_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

friend tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,

foe tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,

) CHARACTER SET `utf8` COLLATE `utf8_bin`;

CREATE INDEX phpbb_config_is_dynamic ON phpbb_config (is_dynamic)

/

/*

Table: 'phpbb_confirm'

group_id number(8) NOT NULL,

group_type number(4) DEFAULT '1' NOT NULL,

group_founder_manage number(1) DEFAULT '0' NOT NULL,

group_desc clob DEFAULT '' ,

group_desc_bitfield varchar2(255) DEFAULT '' ,

group_desc_options number(11) DEFAULT '7' NOT NULL,

user_perm_from number(8) DEFAULT '0' NOT NULL,

user_ip varchar2(40) DEFAULT '' ,

user_regdate number(11) DEFAULT '0' NOT NULL,

user_password varchar2(120) DEFAULT '' ,

user_passchg number(11) DEFAULT '0' NOT NULL,

user_pass_convert number(1) DEFAULT '0' NOT NULL,

)

/

BEGIN;

/*

Table: 'phpbb_attachments'

attach_id INT4 DEFAULT nextval('phpbb_attachments_seq'),

post_msg_id INT4 DEFAULT '0' NOT NULL CHECK (post_msg_id >= 0),

topic_id INT4 DEFAULT '0' NOT NULL CHECK (topic_id >= 0),

poster_id INT4 DEFAULT '0' NOT NULL CHECK (poster_id >= 0),

physical_filename varchar(255) DEFAULT '' NOT NULL,

real_filename varchar(255) DEFAULT '' NOT NULL,

download_count INT4 DEFAULT '0' NOT NULL CHECK (download_count >= 0),

mimetype varchar(100) DEFAULT '' NOT NULL,

filesize INT4 DEFAULT '0' NOT NULL CHECK (filesize >= 0),

filetime INT4 DEFAULT '0' NOT NULL CHECK (filetime >= 0),

PRIMARY KEY (attach_id)

);

CREATE TABLE phpbb_acl_options (

auth_option_id INT4 DEFAULT nextval('phpbb_acl_options_seq'),

auth_option varchar(50) DEFAULT '' NOT NULL,

PRIMARY KEY (auth_option_id)

);

ban_email varchar(100) DEFAULT '' NOT NULL,

ban_start INT4 DEFAULT '0' NOT NULL CHECK (ban_start >= 0),

ban_end INT4 DEFAULT '0' NOT NULL CHECK (ban_end >= 0),

ban_reason varchar(255) DEFAULT '' NOT NULL,

ban_give_reason varchar(255) DEFAULT '' NOT NULL,

PRIMARY KEY (ban_id)

bbcode_id INT2 DEFAULT '0' NOT NULL,

bbcode_tag varchar(16) DEFAULT '' NOT NULL,

bbcode_helpline varchar(255) DEFAULT '' NOT NULL,

bbcode_match varchar(4000) DEFAULT '' NOT NULL,

bbcode_tpl TEXT DEFAULT '' NOT NULL,

first_pass_match TEXT DEFAULT '' NOT NULL,

CREATE TABLE phpbb_bots (

bot_id INT4 DEFAULT nextval('phpbb_bots_seq'),

bot_name varchar(255) DEFAULT '' NOT NULL,

user_id INT4 DEFAULT '0' NOT NULL CHECK (user_id >= 0),

bot_agent varchar(255) DEFAULT '' NOT NULL,

CREATE TABLE phpbb_config (

config_name varchar(255) DEFAULT '' NOT NULL,

config_value varchar(255) DEFAULT '' NOT NULL,

PRIMARY KEY (config_name)

);

CREATE INDEX phpbb_config_is_dynamic ON phpbb_config (is_dynamic);

/*

Table: 'phpbb_confirm'

group_id INT4 DEFAULT nextval('phpbb_extension_groups_seq'),

group_name varchar(255) DEFAULT '' NOT NULL,

cat_id INT2 DEFAULT '0' NOT NULL,

upload_icon varchar(255) DEFAULT '' NOT NULL,

max_filesize INT4 DEFAULT '0' NOT NULL CHECK (max_filesize >= 0),

allowed_forums varchar(8000) DEFAULT '' NOT NULL,

PRIMARY KEY (group_id)

);

forum_last_poster_name varchar(255) DEFAULT '' NOT NULL,

forum_last_poster_colour varchar(6) DEFAULT '' NOT NULL,

forum_flags INT2 DEFAULT '32' NOT NULL,

prune_next INT4 DEFAULT '0' NOT NULL CHECK (prune_next >= 0),

prune_days INT4 DEFAULT '0' NOT NULL CHECK (prune_days >= 0),

prune_viewed INT4 DEFAULT '0' NOT NULL CHECK (prune_viewed >= 0),

CREATE TABLE phpbb_forums_watch (

forum_id INT4 DEFAULT '0' NOT NULL CHECK (forum_id >= 0),

user_id INT4 DEFAULT '0' NOT NULL CHECK (user_id >= 0),

);

CREATE INDEX phpbb_forums_watch_forum_id ON phpbb_forums_watch (forum_id);

CREATE TABLE phpbb_groups (

group_id INT4 DEFAULT nextval('phpbb_groups_seq'),

group_type INT2 DEFAULT '1' NOT NULL,

group_desc varchar(4000) DEFAULT '' NOT NULL,

group_desc_bitfield varchar(255) DEFAULT '' NOT NULL,

group_desc_options INT4 DEFAULT '7' NOT NULL CHECK (group_desc_options >= 0),

group_desc_uid varchar(8) DEFAULT '' NOT NULL,

group_avatar varchar(255) DEFAULT '' NOT NULL,

group_avatar_type INT2 DEFAULT '0' NOT NULL,

group_avatar_width INT2 DEFAULT '0' NOT NULL CHECK (group_avatar_width >= 0),

group_rank INT4 DEFAULT '0' NOT NULL CHECK (group_rank >= 0),

group_colour varchar(6) DEFAULT '' NOT NULL,

group_sig_chars INT4 DEFAULT '0' NOT NULL CHECK (group_sig_chars >= 0),

group_message_limit INT4 DEFAULT '0' NOT NULL CHECK (group_message_limit >= 0),

PRIMARY KEY (group_id)

);

icons_width INT2 DEFAULT '0' NOT NULL,

icons_height INT2 DEFAULT '0' NOT NULL,

icons_order INT4 DEFAULT '0' NOT NULL CHECK (icons_order >= 0),

PRIMARY KEY (icons_id)

);

username varchar(255) DEFAULT '' NOT NULL,

group_id INT4 DEFAULT '0' NOT NULL CHECK (group_id >= 0),

group_name varchar(255) DEFAULT '' NOT NULL,

);

CREATE INDEX phpbb_moderator_cache_disp_idx ON phpbb_moderator_cache (display_on_index);

CREATE TABLE phpbb_modules (

module_id INT4 DEFAULT nextval('phpbb_modules_seq'),

module_basename varchar(255) DEFAULT '' NOT NULL,

module_class varchar(10) DEFAULT '' NOT NULL,

parent_id INT4 DEFAULT '0' NOT NULL CHECK (parent_id >= 0),

icon_id INT4 DEFAULT '0' NOT NULL CHECK (icon_id >= 0),

poster_ip varchar(40) DEFAULT '' NOT NULL,

post_time INT4 DEFAULT '0' NOT NULL CHECK (post_time >= 0),

post_username varchar(255) DEFAULT '' NOT NULL,

post_subject varchar(100) DEFAULT '' NOT NULL,

post_text TEXT DEFAULT '' NOT NULL,

post_checksum varchar(32) DEFAULT '' NOT NULL,

bbcode_bitfield varchar(255) DEFAULT '' NOT NULL,

bbcode_uid varchar(8) DEFAULT '' NOT NULL,

post_edit_time INT4 DEFAULT '0' NOT NULL CHECK (post_edit_time >= 0),

post_edit_reason varchar(255) DEFAULT '' NOT NULL,

post_edit_user INT4 DEFAULT '0' NOT NULL CHECK (post_edit_user >= 0),

post_edit_count INT2 DEFAULT '0' NOT NULL CHECK (post_edit_count >= 0),

PRIMARY KEY (post_id)

);

icon_id INT4 DEFAULT '0' NOT NULL CHECK (icon_id >= 0),

author_ip varchar(40) DEFAULT '' NOT NULL,

message_time INT4 DEFAULT '0' NOT NULL CHECK (message_time >= 0),

message_subject varchar(100) DEFAULT '' NOT NULL,

message_text TEXT DEFAULT '' NOT NULL,

message_edit_reason varchar(255) DEFAULT '' NOT NULL,

message_edit_user INT4 DEFAULT '0' NOT NULL CHECK (message_edit_user >= 0),

bbcode_bitfield varchar(255) DEFAULT '' NOT NULL,

bbcode_uid varchar(8) DEFAULT '' NOT NULL,

message_edit_time INT4 DEFAULT '0' NOT NULL CHECK (message_edit_time >= 0),

msg_id INT4 DEFAULT '0' NOT NULL CHECK (msg_id >= 0),

user_id INT4 DEFAULT '0' NOT NULL CHECK (user_id >= 0),

author_id INT4 DEFAULT '0' NOT NULL CHECK (author_id >= 0),

folder_id INT4 DEFAULT '0' 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_order INT4 DEFAULT '0' NOT NULL CHECK (field_order >= 0),

PRIMARY KEY (field_id)

);

rank_id INT4 DEFAULT nextval('phpbb_ranks_seq'),

rank_title varchar(255) DEFAULT '' NOT NULL,

rank_min INT4 DEFAULT '0' NOT NULL CHECK (rank_min >= 0),

rank_image varchar(255) DEFAULT '' NOT NULL,

PRIMARY KEY (rank_id)

);

reason_id INT2 DEFAULT '0' NOT NULL CHECK (reason_id >= 0),

post_id INT4 DEFAULT '0' NOT NULL CHECK (post_id >= 0),

user_id INT4 DEFAULT '0' NOT NULL CHECK (user_id >= 0),

report_time INT4 DEFAULT '0' NOT NULL CHECK (report_time >= 0),

report_text TEXT DEFAULT '' NOT NULL,

PRIMARY KEY (report_id)

CREATE TABLE phpbb_search_wordlist (

word_id INT4 DEFAULT nextval('phpbb_search_wordlist_seq'),

word_text varchar(255) DEFAULT '' NOT NULL,

word_count INT4 DEFAULT '0' NOT NULL CHECK (word_count >= 0),

PRIMARY KEY (word_id)

);

CREATE TABLE phpbb_search_wordmatch (

post_id INT4 DEFAULT '0' NOT NULL CHECK (post_id >= 0),

word_id INT4 DEFAULT '0' NOT NULL CHECK (word_id >= 0),

);

CREATE UNIQUE INDEX phpbb_search_wordmatch_unq_mtch ON phpbb_search_wordmatch (word_id, post_id, title_match);

session_browser varchar(150) DEFAULT '' NOT NULL,

session_forwarded_for varchar(255) DEFAULT '' NOT NULL,

session_page varchar(255) DEFAULT '' NOT NULL,

PRIMARY KEY (session_id)

);

site_id INT4 DEFAULT nextval('phpbb_sitelist_seq'),

site_ip varchar(40) DEFAULT '' NOT NULL,

site_hostname varchar(255) DEFAULT '' NOT NULL,

PRIMARY KEY (site_id)

);

smiley_width INT2 DEFAULT '0' NOT NULL CHECK (smiley_width >= 0),

smiley_height INT2 DEFAULT '0' NOT NULL CHECK (smiley_height >= 0),

smiley_order INT4 DEFAULT '0' NOT NULL CHECK (smiley_order >= 0),

PRIMARY KEY (smiley_id)

);

style_id INT2 DEFAULT nextval('phpbb_styles_seq'),

style_name varchar(255) DEFAULT '' NOT NULL,

style_copyright varchar(255) DEFAULT '' NOT NULL,

template_id INT2 DEFAULT '0' NOT NULL CHECK (template_id >= 0),

theme_id INT2 DEFAULT '0' NOT NULL CHECK (theme_id >= 0),

imageset_id INT2 DEFAULT '0' NOT NULL CHECK (imageset_id >= 0),

template_copyright varchar(255) DEFAULT '' NOT NULL,

template_path varchar(100) DEFAULT '' NOT NULL,

bbcode_bitfield varchar(255) DEFAULT 'kNg=' NOT NULL,

PRIMARY KEY (template_id)

);

theme_name varchar(255) DEFAULT '' NOT NULL,

theme_copyright varchar(255) DEFAULT '' NOT NULL,

theme_path varchar(100) DEFAULT '' NOT NULL,

theme_mtime INT4 DEFAULT '0' NOT NULL CHECK (theme_mtime >= 0),

theme_data TEXT DEFAULT '' NOT NULL,

PRIMARY KEY (theme_id)

topic_id INT4 DEFAULT nextval('phpbb_topics_seq'),

forum_id INT4 DEFAULT '0' NOT NULL CHECK (forum_id >= 0),

icon_id INT4 DEFAULT '0' NOT NULL CHECK (icon_id >= 0),

topic_title varchar(100) DEFAULT '' NOT NULL,

topic_poster INT4 DEFAULT '0' NOT NULL CHECK (topic_poster >= 0),

topic_time INT4 DEFAULT '0' NOT NULL CHECK (topic_time >= 0),

topic_last_post_time INT4 DEFAULT '0' NOT NULL CHECK (topic_last_post_time >= 0),

topic_last_view_time INT4 DEFAULT '0' NOT NULL CHECK (topic_last_view_time >= 0),

topic_moved_id INT4 DEFAULT '0' NOT NULL CHECK (topic_moved_id >= 0),

topic_bumper INT4 DEFAULT '0' NOT NULL CHECK (topic_bumper >= 0),

poll_title varchar(255) DEFAULT '' NOT NULL,

poll_start INT4 DEFAULT '0' NOT NULL CHECK (poll_start >= 0),

poll_length INT4 DEFAULT '0' NOT NULL CHECK (poll_length >= 0),

poll_max_options INT2 DEFAULT '1' NOT NULL,

poll_last_vote INT4 DEFAULT '0' NOT NULL CHECK (poll_last_vote >= 0),

PRIMARY KEY (topic_id)

);

CREATE TABLE phpbb_topics_posted (

user_id INT4 DEFAULT '0' NOT NULL CHECK (user_id >= 0),

topic_id INT4 DEFAULT '0' NOT NULL CHECK (topic_id >= 0),

PRIMARY KEY (user_id, topic_id)

);

CREATE TABLE phpbb_topics_watch (

topic_id INT4 DEFAULT '0' NOT NULL CHECK (topic_id >= 0),

user_id INT4 DEFAULT '0' NOT NULL CHECK (user_id >= 0),

);

CREATE INDEX phpbb_topics_watch_topic_id ON phpbb_topics_watch (topic_id);

CREATE TABLE phpbb_user_group (

group_id INT4 DEFAULT '0' NOT NULL CHECK (group_id >= 0),

user_id INT4 DEFAULT '0' NOT NULL CHECK (user_id >= 0),

);

CREATE INDEX phpbb_user_group_group_id ON phpbb_user_group (group_id);

user_perm_from INT4 DEFAULT '0' NOT NULL CHECK (user_perm_from >= 0),

user_ip varchar(40) DEFAULT '' NOT NULL,

user_regdate INT4 DEFAULT '0' NOT NULL CHECK (user_regdate >= 0),

user_password varchar(40) DEFAULT '' NOT NULL,

user_passchg INT4 DEFAULT '0' NOT NULL CHECK (user_passchg >= 0),

user_email varchar(100) DEFAULT '' NOT NULL,

user_email_hash INT8 DEFAULT '0' NOT NULL,

user_birthday varchar(10) DEFAULT '' NOT NULL,

user_posts INT4 DEFAULT '0' NOT NULL CHECK (user_posts >= 0),

user_lang varchar(30) DEFAULT '' NOT NULL,

user_timezone decimal(5,2) DEFAULT '0' NOT NULL,

user_dateformat varchar(30) DEFAULT 'd M Y H:i' NOT NULL,

user_style INT2 DEFAULT '0' NOT NULL CHECK (user_style >= 0),

user_rank INT4 DEFAULT '0' NOT NULL CHECK (user_rank >= 0),

user_new_privmsg INT4 DEFAULT '0' NOT NULL,

user_unread_privmsg INT4 DEFAULT '0' NOT NULL,

user_last_privmsg INT4 DEFAULT '0' NOT NULL CHECK (user_last_privmsg >= 0),

user_full_folder INT4 DEFAULT '-3' NOT NULL,

user_emailtime INT4 DEFAULT '0' NOT NULL CHECK (user_emailtime >= 0),

user_topic_show_days INT2 DEFAULT '0' NOT NULL CHECK (user_topic_show_days >= 0),

user_post_show_days INT2 DEFAULT '0' NOT NULL CHECK (user_post_show_days >= 0),

user_post_sortby_type varchar(1) DEFAULT 't' NOT NULL,

user_post_sortby_dir varchar(1) DEFAULT 'a' NOT NULL,

user_notify_type INT2 DEFAULT '0' NOT NULL,

user_options INT4 DEFAULT '895' NOT NULL CHECK (user_options >= 0),

user_avatar varchar(255) DEFAULT '' NOT NULL,

user_avatar_type INT2 DEFAULT '0' NOT NULL,

CREATE TABLE phpbb_zebra (

user_id INT4 DEFAULT '0' NOT NULL CHECK (user_id >= 0),

zebra_id INT4 DEFAULT '0' NOT NULL CHECK (zebra_id >= 0),

PRIMARY KEY (user_id, zebra_id)

);

COMMIT; \ No newline at end of file

INSERT INTO phpbb_users (user_type, group_id, username, username_clean, user_regdate, user_password, user_email, user_lang, user_style, user_rank, user_colour, user_posts, user_permissions, user_ip, user_birthday, user_lastpage, user_last_confirm_key, user_post_sortby_type, user_post_sortby_dir, user_topic_sortby_type, user_topic_sortby_dir, user_avatar, user_sig, user_sig_bbcode_uid, user_from, user_icq, user_aim, user_yim, user_msnm, user_jabber, user_website, user_occ, user_interests, user_actkey, user_newpasswd) VALUES (3, 5, 'Admin', 'admin', 0, '21232f297a57a5a743894a0e4a801fc3', 'admin@yourdomain.com', 'en', 1, 1, 'AA0000', 1, '', '', '', '', '', 't', 'a', 't', 'd', '', '', '', '', '', '', '', '', '', '', '', '', '', '');

# -- Groups

# -- User -> Group

INSERT INTO phpbb_user_group (group_id, user_id, user_pending, group_leader) VALUES (1, 1, 0, 0);

);

CREATE INDEX phpbb_config_is_dynamic ON phpbb_config (is_dynamic);

# Table: 'phpbb_confirm'

CREATE TABLE phpbb_confirm (

group_type tinyint(4) NOT NULL DEFAULT '1',

group_founder_manage INTEGER UNSIGNED NOT NULL DEFAULT '0',

group_name varchar(255) NOT NULL DEFAULT '',

group_desc text(65535) NOT NULL DEFAULT '',

group_desc_bitfield varchar(255) NOT NULL DEFAULT '',

group_desc_options INTEGER UNSIGNED NOT NULL DEFAULT '7',

PRIMARY KEY (user_id, zebra_id)

);

COMMIT; \ No newline at end of file