'template_inherits_id' => array('UINT:4', 0),

'template_inherit_path' => array('VCHAR', ''),

),

),

),

);

*/

function change_database_data(&$no_updates, $version)

{

switch ($version)

{

set_config('enable_queue_trigger', '0');

set_config('queue_trigger_posts', '3');

// Not prefilling yet

set_config('dbms_version', '');

{

}

$no_updates = false;

break;

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

);;

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

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

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

[group_legend] [int] DEFAULT (1) NOT NULL

) ON [PRIMARY]

GO

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

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

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

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

PRIMARY KEY (group_id),

KEY group_legend_name (group_legend, group_name(255))

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

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

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

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

PRIMARY KEY (group_id),

KEY group_legend_name (group_legend, group_name)

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

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

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

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

CONSTRAINT pk_phpbb_groups PRIMARY KEY (group_id)

)

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

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_legend INT2 DEFAULT '1' NOT NULL CHECK (group_legend >= 0),

PRIMARY KEY (group_id)

);

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

INSERT INTO phpbb_config (config_name, config_value) VALUES ('pm_max_boxes', '4');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('pm_max_msgs', '50');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('posts_per_page', '10');

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

INSERT INTO phpbb_config (config_name, config_value) VALUES ('queue_interval', '600');

INSERT INTO phpbb_acl_options (auth_option, is_global) VALUES ('u_hideonline', 1);

INSERT INTO phpbb_acl_options (auth_option, is_global) VALUES ('u_ignoreflood', 1);

INSERT INTO phpbb_acl_options (auth_option, is_global) VALUES ('u_masspm', 1);

INSERT INTO phpbb_acl_options (auth_option, is_global) VALUES ('u_pm_attach', 1);

INSERT INTO phpbb_acl_options (auth_option, is_global) VALUES ('u_pm_bbcode', 1);

INSERT INTO phpbb_acl_options (auth_option, is_global) VALUES ('u_pm_delete', 1);

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

INSERT INTO phpbb_acl_roles_data (role_id, auth_option_id, auth_setting) SELECT 6, auth_option_id, 1 FROM phpbb_acl_options WHERE auth_option LIKE 'u_%' AND auth_option NOT IN ('u_viewonline', 'u_chggrp', 'u_chgname', 'u_ignoreflood', 'u_pm_flash', 'u_pm_forward');

# Limited Features (u_)

# No Private Messages (u_)

INSERT INTO phpbb_acl_roles_data (role_id, auth_option_id, auth_setting) SELECT 8, auth_option_id, 1 FROM phpbb_acl_options WHERE auth_option LIKE 'u_%' AND auth_option IN ('u_', 'u_chgavatar', 'u_chgcensors', 'u_chgemail', 'u_chgpasswd', 'u_download', 'u_hideonline', 'u_sig', 'u_viewprofile');

# No Avatar (u_)

INSERT INTO phpbb_acl_roles_data (role_id, auth_option_id, auth_setting) SELECT 9, auth_option_id, 1 FROM phpbb_acl_options WHERE auth_option LIKE 'u_%' AND auth_option NOT IN ('u_attach', 'u_chgavatar', 'u_viewonline', 'u_chggrp', 'u_chgname', 'u_ignoreflood', 'u_pm_attach', 'u_pm_emailpm', 'u_pm_flash', 'u_savedrafts', 'u_search', 'u_sendemail', 'u_sendim');

# Full Moderator (m_)

INSERT INTO phpbb_acl_roles_data (role_id, auth_option_id, auth_setting) SELECT 10, auth_option_id, 1 FROM phpbb_acl_options WHERE auth_option LIKE 'm_%';

group_sig_chars INTEGER UNSIGNED NOT NULL DEFAULT '0',

group_receive_pm INTEGER UNSIGNED NOT NULL DEFAULT '0',

group_message_limit INTEGER UNSIGNED NOT NULL DEFAULT '0',

group_legend INTEGER UNSIGNED NOT NULL DEFAULT '1'

);