group_receive_pm INTEGER DEFAULT 0 NOT NULL,

group_message_limit INTEGER DEFAULT 0 NOT NULL,

group_max_recipients INTEGER DEFAULT 0 NOT NULL,

);;

ALTER TABLE phpbb_groups ADD PRIMARY KEY (group_id);;

ALTER TABLE phpbb_log ADD PRIMARY KEY (log_id);;

CREATE INDEX phpbb_log_log_type ON phpbb_log(log_type);;

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

field_validation VARCHAR(20) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,

field_required INTEGER DEFAULT 0 NOT NULL,

field_show_on_reg INTEGER DEFAULT 0 NOT NULL,

field_show_on_vt INTEGER DEFAULT 0 NOT NULL,

field_show_profile INTEGER DEFAULT 0 NOT NULL,

field_hide INTEGER DEFAULT 0 NOT NULL,

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

style_active INTEGER DEFAULT 1 NOT NULL,

template_id INTEGER DEFAULT 0 NOT NULL,

);;

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

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

template_path VARCHAR(100) CHARACTER SET NONE DEFAULT '' NOT NULL,

bbcode_bitfield VARCHAR(255) CHARACTER SET NONE DEFAULT 'kNg=' NOT NULL,

template_inherits_id INTEGER DEFAULT 0 NOT NULL,

template_inherit_path VARCHAR(255) CHARACTER SET NONE DEFAULT '' NOT NULL

);;

END;;

# Table: 'phpbb_styles_theme'

CREATE TABLE phpbb_styles_theme (

theme_id INTEGER NOT NULL,

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

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

);;

ALTER TABLE phpbb_styles_theme ADD PRIMARY KEY (theme_id);;

END;;

# Table: 'phpbb_topics'

CREATE TABLE phpbb_topics (

topic_id INTEGER NOT NULL,

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

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

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

) ON [PRIMARY]

GO

CREATE INDEX [log_type] ON [phpbb_log]([log_type]) ON [PRIMARY]

GO

CREATE INDEX [forum_id] ON [phpbb_log]([forum_id]) ON [PRIMARY]

GO

[field_validation] [varchar] (20) DEFAULT ('') NOT NULL ,

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

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

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

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

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

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

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

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

) ON [PRIMARY]

GO

CREATE INDEX [theme_id] ON [phpbb_styles]([theme_id]) ON [PRIMARY]

GO

/*

Table: 'phpbb_styles_template'

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

[template_path] [varchar] (100) DEFAULT ('') NOT NULL ,

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

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

[template_inherit_path] [varchar] (255) DEFAULT ('') NOT NULL

) ON [PRIMARY]

/*

Table: 'phpbb_styles_theme'

*/

CREATE TABLE [phpbb_styles_theme] (

[theme_id] [int] IDENTITY (1, 1) NOT NULL ,

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

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

GO

ALTER TABLE [phpbb_styles_theme] WITH NOCHECK ADD

/*

Table: 'phpbb_topics'

*/

CREATE TABLE [phpbb_topics] (

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

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

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

PRIMARY KEY (group_id),

KEY group_legend_name (group_legend, group_name(255))

);

log_data mediumblob NOT NULL,

PRIMARY KEY (log_id),

KEY log_type (log_type),

KEY forum_id (forum_id),

KEY topic_id (topic_id),

KEY reportee_id (reportee_id),

field_validation varbinary(60) DEFAULT '' NOT NULL,

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

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

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

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

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

style_active tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,

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

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

PRIMARY KEY (style_id),

UNIQUE style_name (style_name(255)),

KEY template_id (template_id),

);

template_copyright blob NOT NULL,

template_path varbinary(100) DEFAULT '' NOT NULL,

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

template_inherits_id int(4) UNSIGNED DEFAULT '0' NOT NULL,

template_inherit_path varbinary(255) DEFAULT '' NOT NULL,

PRIMARY KEY (template_id),

);

# Table: 'phpbb_styles_theme'

CREATE TABLE phpbb_styles_theme (

theme_id mediumint(8) UNSIGNED NOT NULL auto_increment,

theme_name blob NOT NULL,

theme_copyright blob NOT NULL,

theme_path varbinary(100) DEFAULT '' NOT NULL,

PRIMARY KEY (theme_id),

UNIQUE theme_name (theme_name(255))

);

# Table: 'phpbb_topics'

CREATE TABLE phpbb_topics (

topic_id mediumint(8) UNSIGNED NOT NULL auto_increment,

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

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

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

PRIMARY KEY (group_id),

KEY group_legend_name (group_legend, group_name)

) CHARACTER SET `utf8` COLLATE `utf8_bin`;

log_data mediumtext NOT NULL,

PRIMARY KEY (log_id),

KEY log_type (log_type),

KEY forum_id (forum_id),

KEY topic_id (topic_id),

KEY reportee_id (reportee_id),

field_validation varchar(20) DEFAULT '' NOT NULL,

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

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

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

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

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

style_active tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,

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

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

PRIMARY KEY (style_id),

UNIQUE style_name (style_name),

KEY template_id (template_id),

) CHARACTER SET `utf8` COLLATE `utf8_bin`;

template_copyright varchar(255) DEFAULT '' NOT NULL,

template_path varchar(100) DEFAULT '' NOT NULL,

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

template_inherits_id int(4) UNSIGNED DEFAULT '0' NOT NULL,

template_inherit_path varchar(255) DEFAULT '' NOT NULL,

PRIMARY KEY (template_id),

) CHARACTER SET `utf8` COLLATE `utf8_bin`;

# Table: 'phpbb_styles_theme'

CREATE TABLE phpbb_styles_theme (

theme_id mediumint(8) UNSIGNED NOT NULL auto_increment,

theme_name varchar(255) DEFAULT '' NOT NULL,

theme_copyright varchar(255) DEFAULT '' NOT NULL,

theme_path varchar(100) DEFAULT '' NOT NULL,

PRIMARY KEY (theme_id),

UNIQUE theme_name (theme_name)

) CHARACTER SET `utf8` COLLATE `utf8_bin`;

# Table: 'phpbb_topics'

CREATE TABLE phpbb_topics (

topic_id mediumint(8) UNSIGNED NOT NULL auto_increment,

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

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

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

CONSTRAINT pk_phpbb_groups PRIMARY KEY (group_id)

)

/

CREATE INDEX phpbb_log_log_type ON phpbb_log (log_type)

/

CREATE INDEX phpbb_log_forum_id ON phpbb_log (forum_id)

/

CREATE INDEX phpbb_log_topic_id ON phpbb_log (topic_id)

field_validation varchar2(60) DEFAULT '' ,

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

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

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

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

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

style_active number(1) DEFAULT '1' NOT NULL,

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

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

CONSTRAINT pk_phpbb_styles PRIMARY KEY (style_id),

CONSTRAINT u_phpbb_style_name UNIQUE (style_name)

)

/

CREATE INDEX phpbb_styles_theme_id ON phpbb_styles (theme_id)

/

CREATE SEQUENCE phpbb_styles_seq

/

template_copyright varchar2(765) DEFAULT '' ,

template_path varchar2(100) DEFAULT '' ,

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

template_inherits_id number(4) DEFAULT '0' NOT NULL,

template_inherit_path varchar2(255) DEFAULT '' ,

CONSTRAINT pk_phpbb_styles_template PRIMARY KEY (template_id),

/*

Table: 'phpbb_styles_theme'

*/

CREATE TABLE phpbb_styles_theme (

theme_name varchar2(765) DEFAULT '' ,

theme_copyright varchar2(765) DEFAULT '' ,

theme_path varchar2(100) DEFAULT '' ,

CONSTRAINT pk_phpbb_styles_theme PRIMARY KEY (theme_id),

CONSTRAINT u_phpbb_theme_name UNIQUE (theme_name)

)

/*

Table: 'phpbb_topics'

*/

CREATE TABLE phpbb_topics (

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

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

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

PRIMARY KEY (group_id)

);

);

CREATE INDEX phpbb_log_log_type ON phpbb_log (log_type);

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

field_validation varchar(20) DEFAULT '' NOT NULL,

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

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

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

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

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

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

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

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

PRIMARY KEY (style_id)

);

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

/*

Table: 'phpbb_styles_template'

template_copyright varchar(255) DEFAULT '' NOT NULL,

template_path varchar(100) DEFAULT '' NOT NULL,

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

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

template_inherit_path varchar(255) DEFAULT '' NOT NULL,

PRIMARY KEY (template_id)

CREATE UNIQUE INDEX phpbb_styles_template_tmplte_nm ON phpbb_styles_template (template_name);

/*

Table: 'phpbb_styles_theme'

*/

CREATE SEQUENCE phpbb_styles_theme_seq;

theme_name varchar(255) DEFAULT '' NOT NULL,

theme_copyright varchar(255) DEFAULT '' NOT NULL,

theme_path varchar(100) DEFAULT '' NOT NULL,

PRIMARY KEY (theme_id)

);

CREATE UNIQUE INDEX phpbb_styles_theme_theme_name ON phpbb_styles_theme (theme_name);

/*

Table: 'phpbb_topics'

*/

CREATE SEQUENCE phpbb_topics_seq;

INSERT INTO phpbb_config (config_name, config_value) VALUES ('ldap_uid', '');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('ldap_user', '');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('ldap_user_filter', '');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('limit_load', '0');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('limit_search_load', '0');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('load_anon_lastread', '0');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('load_birthdays', '1');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('load_cpf_memberlist', '0');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('load_cpf_viewprofile', '1');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('load_cpf_viewtopic', '0');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('load_db_lastread', '1');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('smtp_password', '');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('smtp_port', '25');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('smtp_username', '');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('topics_per_page', '25');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('tpl_allow_php', '0');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('upload_icons_path', 'images/upload_icons');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('upload_path', 'files');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('warnings_expire_days', '90');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('warnings_gc', '14400');

INSERT INTO phpbb_acl_roles (role_name, role_description, role_type, role_order) VALUES ('ROLE_FORUM_NEW_MEMBER', 'ROLE_DESCRIPTION_FORUM_NEW_MEMBER', 'f_', 10);

# -- phpbb_styles

# -- phpbb_styles_template

# -- phpbb_styles_theme

# -- Forums

INSERT INTO phpbb_forums (forum_name, forum_desc, left_id, right_id, parent_id, forum_type, forum_posts, forum_topics, forum_topics_real, forum_last_post_id, forum_last_poster_id, forum_last_poster_name, forum_last_poster_colour, forum_last_post_time, forum_link, forum_password, forum_image, forum_rules, forum_rules_link, forum_rules_uid, forum_desc_uid, prune_days, prune_viewed, forum_parents) VALUES ('{L_FORUMS_FIRST_CATEGORY}', '', 1, 4, 0, 0, 1, 1, 1, 1, 2, 'Admin', 'AA0000', 972086460, '', '', '', '', '', '', '', 0, 0, '');

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

group_receive_pm INTEGER UNSIGNED NOT NULL DEFAULT '0',

group_message_limit INTEGER UNSIGNED NOT NULL DEFAULT '0',

group_max_recipients INTEGER UNSIGNED NOT NULL DEFAULT '0',

);

CREATE INDEX phpbb_groups_group_legend_name ON phpbb_groups (group_legend, group_name);

);

CREATE INDEX phpbb_log_log_type ON phpbb_log (log_type);

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

field_validation varchar(20) NOT NULL DEFAULT '',

field_required INTEGER UNSIGNED NOT NULL DEFAULT '0',

field_show_on_reg INTEGER UNSIGNED NOT NULL DEFAULT '0',

field_show_on_vt INTEGER UNSIGNED NOT NULL DEFAULT '0',

field_show_profile INTEGER UNSIGNED NOT NULL DEFAULT '0',

field_hide INTEGER UNSIGNED NOT NULL DEFAULT '0',

style_copyright varchar(255) NOT NULL DEFAULT '',

style_active INTEGER UNSIGNED NOT NULL DEFAULT '1',

template_id INTEGER UNSIGNED NOT NULL DEFAULT '0',

);

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

# Table: 'phpbb_styles_template'

CREATE TABLE phpbb_styles_template (

template_copyright varchar(255) NOT NULL DEFAULT '',

template_path varchar(100) NOT NULL DEFAULT '',

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

template_inherits_id INTEGER UNSIGNED NOT NULL DEFAULT '0',

template_inherit_path varchar(255) NOT NULL DEFAULT ''

);

CREATE UNIQUE INDEX phpbb_styles_template_tmplte_nm ON phpbb_styles_template (template_name);

# Table: 'phpbb_styles_theme'

CREATE TABLE phpbb_styles_theme (

theme_id INTEGER PRIMARY KEY NOT NULL ,

theme_name varchar(255) NOT NULL DEFAULT '',

theme_copyright varchar(255) NOT NULL DEFAULT '',

);

CREATE UNIQUE INDEX phpbb_styles_theme_theme_name ON phpbb_styles_theme (theme_name);

# Table: 'phpbb_topics'

CREATE TABLE phpbb_topics (

topic_id INTEGER PRIMARY KEY NOT NULL ,