Если кому надо вот фрагмент работающей БД. Только те таблицы, которые я там указывал выше.
--
-- Table structure for table `jos_session`
--
CREATE TABLE IF NOT EXISTS `jos_session` (
`username` varchar(150) DEFAULT '',
`time` varchar(14) DEFAULT '',
`session_id` varchar(200) NOT NULL DEFAULT '0',
`guest` tinyint(4) DEFAULT '1',
`userid` int(11) DEFAULT '0',
`usertype` varchar(50) DEFAULT '',
`gid` tinyint(3) unsigned NOT NULL DEFAULT '0',
`client_id` tinyint(3) unsigned NOT NULL DEFAULT '0',
`data` longtext,
PRIMARY KEY (`session_id`(64)),
KEY `whosonline` (`guest`,`usertype`),
KEY `userid` (`userid`),
KEY `time` (`time`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `jos_session`
--
INSERT INTO `jos_session` (`username`, `time`, `session_id`, `guest`, `userid`, `usertype`, `gid`, `client_id`, `data`) VALUES
('admin', '1276479552', '7b51a278db0eeaa6fc5c84a87430b9d8', 0, 62, 'Super Administrator', 25, 1, '__default|a:8:{s:22:"session.client.browser";s:85:"Mozilla/5.0 (Windows; U; Windows NT 5.1; ru; rv:1.9.2.2) Gecko/20100316 Firefox/3.6.2";s:15:"session.counter";i:149;s:8:"registry";O:9:"JRegistry":3:{s:17:"_defaultNameSpace";s:7:"session";s:9:"_registry";a:6:{s:7:"session";a:1:{s:4:"data";O:8:"stdClass":15:');
--
-- Table structure for table `jos_users`
--
CREATE TABLE IF NOT EXISTS `jos_users` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL DEFAULT '',
`username` varchar(150) NOT NULL DEFAULT '',
`email` varchar(100) NOT NULL DEFAULT '',
`password` varchar(100) NOT NULL DEFAULT '',
`usertype` varchar(25) NOT NULL DEFAULT '',
`block` tinyint(4) NOT NULL DEFAULT '0',
`sendEmail` tinyint(4) DEFAULT '0',
`gid` tinyint(3) unsigned NOT NULL DEFAULT '1',
`registerDate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`lastvisitDate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`activation` varchar(100) NOT NULL DEFAULT '',
`params` text NOT NULL,
PRIMARY KEY (`id`),
KEY `usertype` (`usertype`),
KEY `idx_name` (`name`),
KEY `gid_block` (`gid`,`block`),
KEY `username` (`username`),
KEY `email` (`email`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=63 ;
--
-- Dumping data for table `jos_users`
--
INSERT INTO `jos_users` (`id`, `name`, `username`, `email`, `password`, `usertype`, `block`, `sendEmail`, `gid`, `registerDate`, `lastvisitDate`, `activation`, `params`) VALUES
(62, 'Administrator', 'admin', 'eee@eee.pl', '9943b2bb7541240276f4270c5c506135:tKMajim4nXb3guBMyAwlrcbgHCxmmBGi', 'Super Administrator', 0, 1, 25, '2010-04-04 02:46:18', '2010-06-14 00:50:48', '', 'admin_language=ru-RU\nlanguage=ru-RU\neditor=\nhelpsite=\ntimezone=0\n\n');
-- --------------------------------------------------------
-- --------------------------------------------------------
--
-- Table structure for table `jos_core_acl_aro`
--
CREATE TABLE IF NOT EXISTS `jos_core_acl_aro` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`section_value` varchar(240) NOT NULL DEFAULT '0',
`value` varchar(240) NOT NULL DEFAULT '',
`order_value` int(11) NOT NULL DEFAULT '0',
`name` varchar(255) NOT NULL DEFAULT '',
`hidden` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
UNIQUE KEY `jos_section_value_value_aro` (`section_value`(100),`value`(100)),
KEY `jos_gacl_hidden_aro` (`hidden`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=11 ;
--
-- Dumping data for table `jos_core_acl_aro`
--
INSERT INTO `jos_core_acl_aro` (`id`, `section_value`, `value`, `order_value`, `name`, `hidden`) VALUES
(10, 'users', '62', 0, 'Administrator', 0);
-- --------------------------------------------------------
--
-- Table structure for table `jos_core_acl_aro_groups`
--
CREATE TABLE IF NOT EXISTS `jos_core_acl_aro_groups` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`parent_id` int(11) NOT NULL DEFAULT '0',
`name` varchar(255) NOT NULL DEFAULT '',
`lft` int(11) NOT NULL DEFAULT '0',
`rgt` int(11) NOT NULL DEFAULT '0',
`value` varchar(255) NOT NULL DEFAULT '',
PRIMARY KEY (`id`),
KEY `jos_gacl_parent_id_aro_groups` (`parent_id`),
KEY `jos_gacl_lft_rgt_aro_groups` (`lft`,`rgt`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=31 ;
--
-- Dumping data for table `jos_core_acl_aro_groups`
--
INSERT INTO `jos_core_acl_aro_groups` (`id`, `parent_id`, `name`, `lft`, `rgt`, `value`) VALUES
(17, 0, 'ROOT', 1, 22, 'ROOT'),
(28, 17, 'USERS', 2, 21, 'USERS'),
(29, 28, 'Public Frontend', 3, 12, 'Public Frontend'),
(18, 29, 'Registered', 4, 11, 'Registered'),
(19, 18, 'Author', 5, 10, 'Author'),
(20, 19, 'Editor', 6, 9, 'Editor'),
(21, 20, 'Publisher', 7, 8, 'Publisher'),
(30, 28, 'Public Backend', 13, 20, 'Public Backend'),
(23, 30, 'Manager', 14, 19, 'Manager'),
(24, 23, 'Administrator', 15, 18, 'Administrator'),
(25, 24, 'Super Administrator', 16, 17, 'Super Administrator');
-- --------------------------------------------------------
--
-- Table structure for table `jos_core_acl_aro_map`
--
CREATE TABLE IF NOT EXISTS `jos_core_acl_aro_map` (
`acl_id` int(11) NOT NULL DEFAULT '0',
`section_value` varchar(230) NOT NULL DEFAULT '0',
`value` varchar(100) NOT NULL,
PRIMARY KEY (`acl_id`,`section_value`,`value`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `jos_core_acl_aro_map`
--
-- --------------------------------------------------------
--
-- Table structure for table `jos_core_acl_aro_sections`
--
CREATE TABLE IF NOT EXISTS `jos_core_acl_aro_sections` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`value` varchar(230) NOT NULL DEFAULT '',
`order_value` int(11) NOT NULL DEFAULT '0',
`name` varchar(230) NOT NULL DEFAULT '',
`hidden` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
UNIQUE KEY `jos_gacl_value_aro_sections` (`value`),
KEY `jos_gacl_hidden_aro_sections` (`hidden`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=11 ;
--
-- Dumping data for table `jos_core_acl_aro_sections`
--
INSERT INTO `jos_core_acl_aro_sections` (`id`, `value`, `order_value`, `name`, `hidden`) VALUES
(10, 'users', 1, 'Users', 0);
-- --------------------------------------------------------
--
-- Table structure for table `jos_core_acl_groups_aro_map`
--
CREATE TABLE IF NOT EXISTS `jos_core_acl_groups_aro_map` (
`group_id` int(11) NOT NULL DEFAULT '0',
`section_value` varchar(240) NOT NULL DEFAULT '',
`aro_id` int(11) NOT NULL DEFAULT '0',
UNIQUE KEY `group_id_aro_id_groups_aro_map` (`group_id`,`section_value`,`aro_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `jos_core_acl_groups_aro_map`
--
INSERT INTO `jos_core_acl_groups_aro_map` (`group_id`, `section_value`, `aro_id`) VALUES
(25, '', 10);
-- --------------------------------------------------------
--
-- Table structure for table `jos_core_log_items`
--
CREATE TABLE IF NOT EXISTS `jos_core_log_items` (
`time_stamp` date NOT NULL DEFAULT '0000-00-00',
`item_table` varchar(50) NOT NULL DEFAULT '',
`item_id` int(11) unsigned NOT NULL DEFAULT '0',
`hits` int(11) unsigned NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `jos_core_log_items`
--
-- --------------------------------------------------------
--
-- Table structure for table `jos_core_log_searches`
--
CREATE TABLE IF NOT EXISTS `jos_core_log_searches` (
`search_term` varchar(128) NOT NULL DEFAULT '',
`hits` int(11) unsigned NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `jos_core_log_searches`
--
-- --------------------------------------------------------