вот с чистой
DROP TABLE IF EXISTS `#__users`; CREATE TABLE `#__users` ( `id` int(11) NOT NULL AUTO_INCREMENT, `group_id` int(11) NOT NULL DEFAULT '1', `login` varchar(100) NOT NULL, `nickname` varchar(100) NOT NULL, `password` varchar(100) NOT NULL, `email` varchar(100) NOT NULL, `icq` varchar(15) NOT NULL, `regdate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `logdate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `is_locked` int(11) NOT NULL, `is_deleted` int(11) NOT NULL, `rating` int(11) NOT NULL, `points` int(11) NOT NULL, `last_ip` varchar(15) NOT NULL, `status` varchar(255) NOT NULL, `status_date` datetime NOT NULL, `invited_by` int(11) DEFAULT NULL, `invdate` datetime DEFAULT NULL, ) ENGINE=MyISAM DEFAULT CHARSET=cp1251 ROW_FORMAT=DYNAMIC;
DROP TABLE IF EXISTS `#__users`; CREATE TABLE `#__users` ( `id` int(11) NOT NULL AUTO_INCREMENT, `group_id` int(11) NOT NULL DEFAULT '1', `login` varchar(100) NOT NULL, `nickname` varchar(100) NOT NULL, `password` varchar(100) NOT NULL, `email` varchar(100) NOT NULL, `icq` varchar(15) NOT NULL, `regdate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `logdate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `is_locked` int(11) NOT NULL, `is_deleted` int(11) NOT NULL, `is_logged_once` tinyint(4) NOT NULL DEFAULT '0', `rating` int(11) NOT NULL, `points` int(11) NOT NULL, `last_ip` varchar(15) NOT NULL, `status` varchar(255) NOT NULL, `status_date` datetime NOT NULL, `invited_by` int(11) DEFAULT NULL, `invdate` datetime DEFAULT NULL, ) ENGINE=MyISAM DEFAULT CHARSET=cp1251 ROW_FORMAT=DYNAMIC;
`is_logged_once` tinyint(4) NOT NULL DEFAULT '0',
куда б написать об этом баге ???