Kod:
CREATE TABLE IF NOT EXISTS `jos_3comprofiler` (
`id` int(11) NOT NULL default '0',
`user_id` int(11) NOT NULL default '0',
`firstname` varchar(100) default NULL,
`middlename` varchar(100) default NULL,
`lastname` varchar(100) default NULL,
`hits` int(11) NOT NULL default '0',
`message_last_sent` datetime NOT NULL default '0000-00-00 00:00:00',
`message_number_sent` int(11) NOT NULL default '0',
`avatar` varchar(255) default NULL,
`avatarapproved` tinyint(4) NOT NULL default '1',
`approved` tinyint(4) NOT NULL default '1',
`confirmed` tinyint(4) NOT NULL default '1',
`lastupdatedate` datetime NOT NULL default '0000-00-00 00:00:00',
`registeripaddr` varchar(50) NOT NULL default '',
`cbactivation` varchar(50) NOT NULL default '',
`banned` tinyint(4) NOT NULL default '0',
`banneddate` datetime default NULL,
`unbanneddate` datetime default NULL,
`bannedby` int(11) default NULL,
`unbannedby` int(11) default NULL,
`bannedreason` mediumtext,
`acceptedterms` tinyint(1) NOT NULL default '0',
`pu_profilename` varchar(255) default NULL,
`website` varchar(255) default NULL,
`location` varchar(255) default NULL,
`occupation` varchar(255) default NULL,
`interests` varchar(255) default NULL,
`company` varchar(255) default NULL,
`address` varchar(255) default NULL,
`city` varchar(255) default NULL,
`state` varchar(255) default NULL,
`zipcode` varchar(255) default NULL,
`country` varchar(255) default NULL,
`phone` varchar(255) default NULL,
`fax` varchar(255) default NULL,
`cb_mynotes` mediumtext,
`fbviewtype` varchar(255) NOT NULL default '_UE_FB_VIEWTYPE_FLAT',
`fbordering` varchar(255) NOT NULL default '_UE_FB_ORDERING_OLDEST',
`fbsignature` mediumtext,
PRIMARY KEY (`id`),
UNIQUE KEY `user_id` (`user_id`),
KEY `apprconfbanid` (`approved`,`confirmed`,`banned`,`id`),
KEY `avatappr_apr_conf_ban_avatar` (`avatarapproved`,`approved`,`confirmed`,`banned`,`avatar`),
KEY `lastupdatedate` (`lastupdatedate`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
może to wina w sql