phpBB.de

#
# phpBB Backup Script
# Dump of tables for phpbb_
# DATE : 03-04-2008 20:06:55 GMT
#
# Table: phpbb_acl_groups
DROP TABLE IF EXISTS phpbb_acl_groups;
CREATE TABLE `phpbb_acl_groups` (
`group_id` mediumint(8) unsigned NOT NULL default '0',
`forum_id` mediumint(8) unsigned NOT NULL default '0',
`auth_option_id` mediumint(8) unsigned NOT NULL default '0',
`auth_role_id` mediumint(8) unsigned NOT NULL default '0',
`auth_setting` tinyint(2) NOT NULL default '0',
KEY `group_id` (`group_id`),
KEY `auth_opt_id` (`auth_option_id`),
KEY `auth_role_id` (`auth_role_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

INSERT INTO phpbb_acl_groups (group_id, forum_id, auth_option_id, auth_role_id, auth_setting) VALUES (1, 0, 85, 0, 1),(1, 0, 93, 0, 1),(1, 0, 110, 0, 1),(5, 0, 0, 5, 0),(5, 0, 0, 1, 0),(2, 0, 0, 6, 0),(3, 0, 0, 6, 0),(4, 0, 0, 5, 0),(4, 0, 0, 10, 0),(1, 1, 0, 17, 0),(2, 1, 0, 17, 0),(3, 1, 0, 17, 0),(6, 1, 0, 17, 0),(1, 2, 0, 17, 0),(2, 2, 0, 15, 0),(3, 2, 0, 15, 0),(4, 2, 0, 21, 0),(5, 2, 0, 14, 0),(5, 2, 0, 10, 0),(6, 2, 0, 19, 0);

# Table: phpbb_acl_options