مشكل في التسجيل

CREATE TABLE `user` ( 
  `userid` int(10) unsigned NOT NULL auto_increment, 
  `usergroupid` smallint(5) unsigned NOT NULL default '0', 
  `membergroupids` char(250) NOT NULL default '', 
  `displaygroupid` smallint(5) unsigned NOT NULL default '0', 
  `username` varchar(100) NOT NULL default '', 
  `password` char(32) NOT NULL default '', 
  `passworddate` date NOT NULL default '0000-00-00', 
  `email` char(100) NOT NULL default '', 
  `styleid` smallint(5) unsigned NOT NULL default '0', 
  `parentemail` char(50) NOT NULL default '', 
  `homepage` char(100) NOT NULL default '', 
  `icq` char(20) NOT NULL default '', 
  `aim` char(20) NOT NULL default '', 
  `yahoo` char(32) NOT NULL default '', 
  `msn` char(100) NOT NULL default '', 
  `skype` char(32) NOT NULL default '', 
  `showvbcode` smallint(5) unsigned NOT NULL default '0', 
  `showbirthday` smallint(5) unsigned NOT NULL default '2', 
  `usertitle` char(250) NOT NULL default '', 
  `customtitle` smallint(6) NOT NULL default '0', 
  `joindate` int(10) unsigned NOT NULL default '0', 
  `daysprune` smallint(6) NOT NULL default '0', 
  `lastvisit` int(10) unsigned NOT NULL default '0', 
  `lastactivity` int(10) unsigned NOT NULL default '0', 
  `lastpost` int(10) unsigned NOT NULL default '0', 
  `lastpostid` int(10) unsigned NOT NULL default '0', 
  `posts` int(10) unsigned NOT NULL default '0', 
  `reputation` int(11) NOT NULL default '10', 
  `reputationlevelid` int(10) unsigned NOT NULL default '1', 
  `timezoneoffset` char(4) NOT NULL default '', 
  `pmpopup` smallint(6) NOT NULL default '0', 
  `avatarid` smallint(6) NOT NULL default '0', 
  `avatarrevision` int(10) unsigned NOT NULL default '0', 
  `profilepicrevision` int(10) unsigned NOT NULL default '0', 
  `sigpicrevision` int(10) unsigned NOT NULL default '0', 
  `options` int(10) unsigned NOT NULL default '33554447', 
  `birthday` char(10) NOT NULL default '', 
  `birthday_search` date NOT NULL default '0000-00-00', 
  `maxposts` smallint(6) NOT NULL default '-1', 
  `startofweek` smallint(6) NOT NULL default '1', 
  `ipaddress` char(15) NOT NULL default '', 
  `referrerid` int(10) unsigned NOT NULL default '0', 
  `languageid` smallint(5) unsigned NOT NULL default '0', 
  `emailstamp` int(10) unsigned NOT NULL default '0', 
  `threadedmode` smallint(5) unsigned NOT NULL default '0', 
  `autosubscribe` smallint(6) NOT NULL default '-1', 
  `pmtotal` smallint(5) unsigned NOT NULL default '0', 
  `pmunread` smallint(5) unsigned NOT NULL default '0', 
  `salt` char(3) NOT NULL default '', 
  `ipoints` int(10) unsigned NOT NULL default '0', 
  `infractions` int(10) unsigned NOT NULL default '0', 
  `warnings` int(10) unsigned NOT NULL default '0', 
  `infractiongroupids` varchar(255) NOT NULL default '', 
  `infractiongroupid` smallint(5) unsigned NOT NULL default '0', 
  `adminoptions` int(10) unsigned NOT NULL default '0', 
  `profilevisits` int(10) unsigned NOT NULL default '0', 
  `friendcount` int(10) unsigned NOT NULL default '0', 
  `friendreqcount` int(10) unsigned NOT NULL default '0', 
  `vmunreadcount` int(10) unsigned NOT NULL default '0', 
  `vmmoderatedcount` int(10) unsigned NOT NULL default '0', 
  `socgroupinvitecount` int(10) unsigned NOT NULL default '0', 
  `socgroupreqcount` int(10) unsigned NOT NULL default '0', 
  `pcunreadcount` int(10) unsigned NOT NULL default '0', 
  `pcmoderatedcount` int(10) unsigned NOT NULL default '0', 
  `gmmoderatedcount` int(10) unsigned NOT NULL default '0', 
  `mwaextraadmin3_imageresizer_mode` enum('none','enlarge','samewindow','newwindow') default NULL, 
  `mwaextraadmin3_imageresizer_maxwidth` smallint(5) unsigned default NULL, 
  `mwaextraadmin3_imageresizer_maxheight` smallint(5) unsigned default NULL, 
  PRIMARY KEY  (`userid`), 
  KEY `usergroupid` (`usergroupid`), 
  KEY `username` (`username`), 
  KEY `birthday` (`birthday`,`showbirthday`), 
  KEY `birthday_search` (`birthday_search`), 
  KEY `referrerid` (`referrerid`), 
  KEY `lastactivity` (`lastactivity`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

 CREATE TABLE `useractivation` ( 
  `useractivationid` int(10) unsigned NOT NULL auto_increment, 
  `userid` int(10) unsigned NOT NULL default '0', 
  `dateline` int(10) unsigned NOT NULL default '0', 
  `activationid` varchar(40) NOT NULL default '', 
  `type` smallint(5) unsigned NOT NULL default '0', 
  `usergroupid` smallint(5) unsigned NOT NULL default '0', 
  `emailchange` smallint(5) unsigned NOT NULL default '0', 
  PRIMARY KEY  (`useractivationid`), 
  UNIQUE KEY `userid` (`userid`,`type`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

 CREATE TABLE `userban` ( 
  `userid` int(10) unsigned NOT NULL default '0', 
  `usergroupid` smallint(5) unsigned NOT NULL default '0', 
  `displaygroupid` smallint(5) unsigned NOT NULL default '0', 
  `usertitle` varchar(250) NOT NULL default '', 
  `customtitle` smallint(6) NOT NULL default '0', 
  `adminid` int(10) unsigned NOT NULL default '0', 
  `bandate` int(10) unsigned NOT NULL default '0', 
  `liftdate` int(10) unsigned NOT NULL default '0', 
  `reason` varchar(250) NOT NULL default '', 
  PRIMARY KEY  (`userid`), 
  KEY `liftdate` (`liftdate`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

 CREATE TABLE `userchangelog` ( 
  `changeid` int(10) unsigned NOT NULL auto_increment, 
  `userid` int(10) unsigned NOT NULL default '0', 
  `fieldname` varchar(250) NOT NULL default '', 
  `newvalue` varchar(250) NOT NULL default '', 
  `oldvalue` varchar(250) NOT NULL default '', 
  `adminid` int(10) unsigned NOT NULL default '0', 
  `change_time` int(10) unsigned NOT NULL default '0', 
  `change_uniq` varchar(32) NOT NULL default '', 
  PRIMARY KEY  (`changeid`), 
  KEY `userid` (`userid`,`change_time`), 
  KEY `change_time` (`change_time`), 
  KEY `change_uniq` (`change_uniq`), 
  KEY `fieldname` (`fieldname`,`change_time`), 
  KEY `adminid` (`adminid`,`change_time`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

 CREATE TABLE `usercss` ( 
  `userid` int(10) unsigned NOT NULL default '0', 
  `selector` varchar(30) NOT NULL default '', 
  `property` varchar(30) NOT NULL default '', 
  `value` varchar(255) NOT NULL default '', 
  PRIMARY KEY  (`userid`,`selector`,`property`), 
  KEY `property` (`property`,`userid`,`value`(20)) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

 CREATE TABLE `usercsscache` ( 
  `userid` int(10) unsigned NOT NULL default '0', 
  `cachedcss` text, 
  `buildpermissions` int(10) unsigned NOT NULL default '0', 
  PRIMARY KEY  (`userid`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

 CREATE TABLE `userfield` ( 
  `userid` int(10) unsigned NOT NULL default '0', 
  `temp` mediumtext, 
  `field1` mediumtext, 
  `field2` mediumtext, 
  `field3` mediumtext, 
  `field4` mediumtext, 
  `field631` mediumtext NOT NULL, 
  `field632` mediumtext NOT NULL, 
  PRIMARY KEY  (`userid`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

CREATE TABLE `usergroup` ( 
  `usergroupid` smallint(5) unsigned NOT NULL auto_increment, 
  `title` char(100) NOT NULL default '', 
  `description` varchar(250) NOT NULL default '', 
  `usertitle` char(100) NOT NULL default '', 
  `passwordexpires` smallint(5) unsigned NOT NULL default '0', 
  `passwordhistory` smallint(5) unsigned NOT NULL default '0', 
  `pmquota` smallint(5) unsigned NOT NULL default '0', 
  `pmsendmax` smallint(5) unsigned NOT NULL default '5', 
  `opentag` text, 
  `closetag` text, 
  `canoverride` smallint(5) unsigned NOT NULL default '0', 
  `ispublicgroup` smallint(5) unsigned NOT NULL default '0', 
  `forumpermissions` int(10) unsigned NOT NULL default '0', 
  `pmpermissions` int(10) unsigned NOT NULL default '0', 
  `calendarpermissions` int(10) unsigned NOT NULL default '0', 
  `wolpermissions` int(10) unsigned NOT NULL default '0', 
  `adminpermissions` int(10) unsigned NOT NULL default '0', 
  `genericpermissions` int(10) unsigned NOT NULL default '0', 
  `genericpermissions2` int(10) unsigned NOT NULL default '0', 
  `genericoptions` int(10) unsigned NOT NULL default '0', 
  `signaturepermissions` int(10) unsigned NOT NULL default '0', 
  `visitormessagepermissions` int(10) unsigned NOT NULL default '0', 
  `attachlimit` int(10) unsigned NOT NULL default '0', 
  `avatarmaxwidth` smallint(5) unsigned NOT NULL default '0', 
  `avatarmaxheight` smallint(5) unsigned NOT NULL default '0', 
  `avatarmaxsize` int(10) unsigned NOT NULL default '0', 
  `profilepicmaxwidth` smallint(5) unsigned NOT NULL default '0', 
  `profilepicmaxheight` smallint(5) unsigned NOT NULL default '0', 
  `profilepicmaxsize` int(10) unsigned NOT NULL default '0', 
  `sigpicmaxwidth` smallint(5) unsigned NOT NULL default '0', 
  `sigpicmaxheight` smallint(5) unsigned NOT NULL default '0', 
  `sigpicmaxsize` int(10) unsigned NOT NULL default '0', 
  `sigmaximages` smallint(5) unsigned NOT NULL default '0', 
  `sigmaxsizebbcode` smallint(5) unsigned NOT NULL default '0', 
  `sigmaxchars` smallint(5) unsigned NOT NULL default '0', 
  `sigmaxrawchars` smallint(5) unsigned NOT NULL default '0', 
  `sigmaxlines` smallint(5) unsigned NOT NULL default '0', 
  `usercsspermissions` int(10) unsigned NOT NULL default '0', 
  `albumpermissions` int(10) unsigned NOT NULL default '0', 
  `albumpicmaxwidth` smallint(5) unsigned NOT NULL default '0', 
  `albumpicmaxheight` smallint(5) unsigned NOT NULL default '0', 
  `albumpicmaxsize` int(10) unsigned NOT NULL default '0', 
  `albummaxpics` int(10) unsigned NOT NULL default '0', 
  `albummaxsize` int(10) unsigned NOT NULL default '0', 
  `socialgrouppermissions` int(10) unsigned NOT NULL default '0', 
  `pmthrottlequantity` int(10) unsigned NOT NULL default '0', 
  `groupiconmaxsize` int(10) unsigned NOT NULL default '0', 
  `maximumsocialgroups` int(10) unsigned NOT NULL default '0', 
  `maxnewthread` int(10) unsigned NOT NULL default '0', 
  `maxnewtime` int(11) NOT NULL default '0', 
  `maxnewpost` int(11) NOT NULL default '0', 
  `maxnewposttime` int(11) NOT NULL default '0', 
  PRIMARY KEY  (`usergroupid`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

 CREATE TABLE `usergroupleader` ( 
  `usergroupleaderid` smallint(5) unsigned NOT NULL auto_increment, 
  `userid` int(10) unsigned NOT NULL default '0', 
  `usergroupid` smallint(5) unsigned NOT NULL default '0', 
  PRIMARY KEY  (`usergroupleaderid`), 
  KEY `ugl` (`userid`,`usergroupid`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

 CREATE TABLE `usergrouprequest` ( 
  `usergrouprequestid` int(10) unsigned NOT NULL auto_increment, 
  `userid` int(10) unsigned NOT NULL default '0', 
  `usergroupid` smallint(5) unsigned NOT NULL default '0', 
  `reason` varchar(250) NOT NULL default '', 
  `dateline` int(10) unsigned NOT NULL default '0', 
  PRIMARY KEY  (`usergrouprequestid`), 
  UNIQUE KEY `userid` (`userid`,`usergroupid`), 
  KEY `usergroupid` (`usergroupid`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

 CREATE TABLE `userlist` ( 
  `userid` int(10) unsigned NOT NULL default '0', 
  `relationid` int(10) unsigned NOT NULL default '0', 
  `type` enum('buddy','ignore') NOT NULL default 'buddy', 
  `friend` enum('yes','no','pending','denied') NOT NULL default 'no', 
  PRIMARY KEY  (`userid`,`relationid`,`type`), 
  KEY `relationid` (`relationid`,`type`,`friend`), 
  KEY `userid` (`userid`,`type`,`friend`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

 CREATE TABLE `usernote` ( 
  `usernoteid` int(10) unsigned NOT NULL auto_increment, 
  `userid` int(10) unsigned NOT NULL default '0', 
  `posterid` int(10) unsigned NOT NULL default '0', 
  `username` varchar(100) NOT NULL default '', 
  `dateline` int(10) unsigned NOT NULL default '0', 
  `message` mediumtext, 
  `title` varchar(255) NOT NULL default '', 
  `allowsmilies` smallint(6) NOT NULL default '0', 
  PRIMARY KEY  (`usernoteid`), 
  KEY `userid` (`userid`), 
  KEY `posterid` (`posterid`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

CREATE TABLE `userpromotion` ( 
  `userpromotionid` int(10) unsigned NOT NULL auto_increment, 
  `usergroupid` int(10) unsigned NOT NULL default '0', 
  `joinusergroupid` int(10) unsigned NOT NULL default '0', 
  `reputation` int(11) NOT NULL default '0', 
  `date` int(10) unsigned NOT NULL default '0', 
  `posts` int(10) unsigned NOT NULL default '0', 
  `strategy` smallint(6) NOT NULL default '0', 
  `type` smallint(6) NOT NULL default '2', 
  PRIMARY KEY  (`userpromotionid`), 
  KEY `usergroupid` (`usergroupid`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

 CREATE TABLE `usertextfield` ( 
  `userid` int(10) unsigned NOT NULL default '0', 
  `subfolders` mediumtext, 
  `pmfolders` mediumtext, 
  `buddylist` mediumtext, 
  `ignorelist` mediumtext, 
  `signature` mediumtext, 
  `searchprefs` mediumtext, 
  `rank` mediumtext, 
  PRIMARY KEY  (`userid`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

CREATE TABLE `usertitle` ( 
  `usertitleid` smallint(5) unsigned NOT NULL auto_increment, 
  `minposts` int(10) unsigned NOT NULL default '0', 
  `title` char(250) NOT NULL default '', 
  PRIMARY KEY  (`usertitleid`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

CREATE TABLE `visitormessage` ( 
  `vmid` int(10) unsigned NOT NULL auto_increment, 
  `userid` int(10) unsigned NOT NULL default '0', 
  `postuserid` int(10) unsigned NOT NULL default '0', 
  `postusername` varchar(100) NOT NULL default '', 
  `dateline` int(10) unsigned NOT NULL default '0', 
  `state` enum('visible','moderation','deleted') NOT NULL default 'visible', 
  `title` varchar(255) NOT NULL default '', 
  `pagetext` mediumtext, 
  `ipaddress` int(10) unsigned NOT NULL default '0', 
  `allowsmilie` smallint(5) unsigned NOT NULL default '0', 
  `reportthreadid` int(10) unsigned NOT NULL default '0', 
  `messageread` smallint(5) unsigned NOT NULL default '0', 
  PRIMARY KEY  (`vmid`), 
  KEY `postuserid` (`postuserid`,`userid`,`state`), 
  KEY `userid` (`userid`,`dateline`,`state`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

 CREATE TABLE `visitormessage_hash` ( 
  `postuserid` int(10) unsigned NOT NULL default '0', 
  `userid` int(10) unsigned NOT NULL default '0', 
  `dupehash` varchar(32) NOT NULL default '', 
  `dateline` int(10) unsigned NOT NULL default '0', 
  KEY `postuserid` (`postuserid`,`dupehash`), 
  KEY `dateline` (`dateline`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

CREATE TABLE `word` ( 
  `wordid` int(10) unsigned NOT NULL auto_increment, 
  `title` char(50) NOT NULL default '', 
  PRIMARY KEY  (`wordid`), 
  UNIQUE KEY `title` (`title`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;