web_user_attributes

CREATE TABLE IF NOT EXISTS `{PREFIX}web_user_attributes` (
`id` int(10) NOT NULL auto_increment,
`internalKey` int(10) NOT NULL default '0',
`fullname` varchar(100) NOT NULL default '',
`role` int(10) NOT NULL default '0',
`email` varchar(100) NOT NULL default '',
`phone` varchar(100) NOT NULL default '',
`mobilephone` varchar(100) NOT NULL default '',
`blocked` int(1) NOT NULL default '0',
`blockeduntil` int(11) NOT NULL default '0',
`blockedafter` int(11) NOT NULL default '0',
`logincount` int(11) NOT NULL default '0',
`lastlogin` int(11) NOT NULL default '0',
`thislogin` int(11) NOT NULL default '0',
`failedlogincount` int(10) NOT NULL default '0',
`sessionid` varchar(100) NOT NULL default '',
`dob` int(10) NOT NULL DEFAULT '0',
`gender` int(1) NOT NULL DEFAULT '0' COMMENT '0 - unknown, 1 - Male 2 - female 3 - other',
`country` varchar(25) NOT NULL default '',
`street` varchar(255) NOT NULL default '',
`city` varchar(255) NOT NULL default '',
`state` varchar(25) NOT NULL default '',
`zip` varchar(25) NOT NULL default '',
`fax` varchar(100) NOT NULL default '',
`photo` varchar(255) NOT NULL default '' COMMENT 'link to photo',
`comment` text,
PRIMARY KEY (`id`),
KEY `userid` (`internalKey`)
) ENGINE=MyISAM COMMENT='Contains information for web users.';