CREATE TABLE `user` (
  `userid` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `usergroupid` smallint(5) unsigned NOT NULL DEFAULT '0',
  `membergroupids` char(250) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `displaygroupid` smallint(5) unsigned NOT NULL DEFAULT '0',
  `username` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `password` char(32) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `passworddate` date NOT NULL DEFAULT '0000-00-00',
  `email` char(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `styleid` smallint(5) unsigned NOT NULL DEFAULT '0',
  `parentemail` char(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `homepage` char(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `icq` char(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `aim` char(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `yahoo` char(32) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `msn` char(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `skype` char(32) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `showvbcode` smallint(5) unsigned NOT NULL DEFAULT '0',
  `showbirthday` smallint(5) unsigned NOT NULL DEFAULT '2',
  `usertitle` char(250) COLLATE utf8_unicode_ci 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) COLLATE utf8_unicode_ci 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) COLLATE utf8_unicode_ci 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) COLLATE utf8_unicode_ci 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) COLLATE utf8_unicode_ci 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) COLLATE utf8_unicode_ci 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',
  PRIMARY KEY (`userid`),
  KEY `usergroupid` (`usergroupid`),
  KEY `username` (`username`),
  KEY `birthday` (`birthday`,`showbirthday`),
  KEY `birthday_search` (`birthday_search`),
  KEY `referrerid` (`referrerid`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
INSERT INTO `user` (`userid`, `usergroupid`, `membergroupids`, `displaygroupid`, `username`, `password`, `passworddate`, `email`, `styleid`, `parentemail`, `homepage`, `icq`, `aim`, `yahoo`, `msn`, `skype`, `showvbcode`, `showbirthday`, `usertitle`, `customtitle`, `joindate`, `daysprune`, `lastvisit`, `lastactivity`, `lastpost`, `lastpostid`, `posts`, `reputation`, `reputationlevelid`, `timezoneoffset`, `pmpopup`, `avatarid`, `avatarrevision`, `profilepicrevision`, `sigpicrevision`, `options`, `birthday`, `birthday_search`, `maxposts`, `startofweek`, `ipaddress`, `referrerid`, `languageid`, `emailstamp`, `threadedmode`, `autosubscribe`, `pmtotal`, `pmunread`, `salt`, `ipoints`, `infractions`, `warnings`, `infractiongroupids`, `infractiongroupid`, `adminoptions`, `profilevisits`, `friendcount`, `friendreqcount`, `vmunreadcount`, `vmmoderatedcount`, `socgroupinvitecount`, `socgroupreqcount`, `pcunreadcount`, `pcmoderatedcount`, `gmmoderatedcount`) VALUES 
	(1, 6, NULL, 0, 'boniek', '28a3c54fb752d74e9e8c885bd4c9d934', '2012-10-18', 'guillaume.lohez@ovh.net', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 2, 2, 'Administrator', 0, 1276175700, 0, 1350573873, 1350574828, 1276245731, 0, 0, 10, 1, 0, 0, 0, 0, 0, 0, 11536471, NULL, '0000-00-00', -1, 1, NULL, 0, 1, 0, 0, -1, 0, 0, 'bee', 0, 0, 0, NULL, 0, 0, 79, 0, 0, 0, 0, 0, 0, 0, 0, 0)
	,(2, 6, NULL, 0, 'Germain', 'a821720771aba43d2f72c6633f51a60b', '2010-06-10', 'geg@ovh.net', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 'Administrator', 0, 1276176540, -1, 1276176624, 1276176540, 0, 0, 0, 10, 5, 0, 0, 0, 0, 0, 0, 3145813, NULL, '0000-00-00', -1, -1, NULL, 0, 0, 0, 0, -1, 0, 0, 'H@[', 0, 0, 0, NULL, 0, 0, 100, 0, 0, 0, 0, 0, 0, 0, 0, 0)
	,(3, 6, NULL, 0, 'Aurelien', 'a929895d3a2a3bba3bd8538edd67a5eb', '2011-06-01', 'zorel@ovh.net', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 'OVH Team', 2, 1276176600, -1, 1307551742, 1307551742, 0, 0, 0, 10, 5, 0, 0, 0, 0, 0, 0, 3145813, NULL, '0000-00-00', -1, -1, NULL, 0, 2, 0, 0, -1, 0, 0, 'u_l', 0, 0, 0, NULL, 0, 0, 87, 0, 0, 0, 0, 0, 0, 0, 0, 0)
	,(4, 6, NULL, 0, 'Beluc', '2fdaa92f4d51d0ec1393968ef05e96da', '2010-06-10', 'marc-antoine.becu@ovh.net', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 'Administrator', 0, 1276176780, -1, 1276176833, 1276176780, 0, 0, 0, 10, 5, 0, 0, 0, 0, 0, 0, 3145813, NULL, '0000-00-00', -1, -1, NULL, 0, 0, 0, 0, -1, 0, 0, '_rX', 0, 0, 0, NULL, 0, 0, 95, 0, 0, 0, 0, 0, 0, 0, 0, 0)
	,(5, 6, '5,7', 0, 'alexandre', '26bf26b7c42efb20703ef34d13e4269a', '2010-06-17', 'alexandre@ovh.net', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 'Administrator', 0, 1276769220, -1, 1276769220, 1276785864, 0, 0, 0, 10, 5, 0, 0, 0, 0, 0, 0, 3145813, NULL, '0000-00-00', -1, -1, NULL, 0, 0, 0, 0, -1, 0, 0, 'qP9', 0, 0, 0, NULL, 0, 0, 1699, 0, 0, 0, 0, 0, 0, 0, 0, 0);

