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=15 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, 1350573366, 1350574819, 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, 20, 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, 20, 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, 1308237530, 1310024025, 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, 107, 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, 19, 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, 1276769340, -1, 1276769371, 1276769340, 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, 142, 0, 0, 0, 0, 0, 0, 0, 0, 0)
	,(6, 2, NULL, 0, 'Tarik', '3f101f009d401417c249349c76eb7151', '2011-06-22', 'stacom@gmail.com', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 'Junior Member', 0, 1308779122, 0, 1308779172, 1309546292, 0, 0, 0, 10, 5, 0, 0, 0, 0, 0, 0, 3146069, NULL, '0000-00-00', -1, -1, '196.217.200.62', 0, 2, 0, 0, -1, 0, 0, 'xCQ', 0, 0, 0, NULL, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0)
	,(7, 3, NULL, 0, 'said013', '36b0fc4174f77cf39a1aea110a28ae65', '2011-07-10', 'said0103@gmail.com', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 'Junior Member', 0, 1310315970, 0, 1310315970, 1310316491, 0, 0, 0, 10, 5, 0, 0, 0, 0, 0, 0, 3146069, NULL, '0000-00-00', -1, -1, '41.248.105.191', 0, 2, 0, 0, -1, 0, 0, '&wR', 0, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0)
	,(8, 3, NULL, 0, 'tofiq', 'bf0bc606d6e10d65c14d7f6bf02a96e6', '2011-07-11', 'sup2@live.fr', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 'Junior Member', 0, 1310395874, 0, 1310395874, 1310395893, 0, 0, 0, 10, 5, 0, 0, 0, 0, 0, 0, 3145813, NULL, '0000-00-00', -1, -1, '41.250.179.27', 0, 2, 0, 0, -1, 0, 0, '*7}', 0, 0, 0, NULL, 0, 0, 266, 0, 0, 0, 0, 0, 0, 0, 0, 0)
	,(9, 2, NULL, 0, 'eabdellatif', 'b3ccdd20a5c3b8f0edefcecc410fb9e6', '2011-08-15', 'network.ab@gmail.com', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 'Junior Member', 0, 1313413558, 0, 1313448538, 1313448538, 1313414074, 0, 1, 10, 5, 0, 0, 0, 0, 0, 0, 3145797, NULL, '0000-00-00', -1, -1, '196.206.207.254', 0, 2, 0, 0, -1, 0, 0, 'moe', 0, 0, 0, NULL, 0, 0, 141, 0, 0, 0, 0, 0, 0, 0, 0, 0)
	,(10, 2, NULL, 0, 'softghost', '4dca73d6a383c6710fd99f1c81de77eb', '2011-11-23', 'softghost@gmail.com', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 'Junior Member', 0, 1322081084, 0, 1322081201, 1326145738, 1322081188, 3, 1, 10, 5, 0, 0, 0, 0, 0, 0, 3146069, NULL, '0000-00-00', -1, -1, '41.141.74.237', 0, 2, 0, 0, -1, 0, 0, '\"zB', 0, 0, 0, NULL, 0, 0, 116, 0, 0, 0, 0, 0, 0, 0, 0, 0)
	,(11, 2, NULL, 0, 'mouhssibe1982', '2cf749f6900578bab7e5d5f4f58acbc8', '2011-11-26', 'mouhssine1982@gmail.com', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 'Junior Member', 0, 1322332679, 0, 1322333022, 1322345795, 0, 0, 0, 10, 5, 0, 0, 0, 0, 0, 0, 3145813, NULL, '0000-00-00', -1, -1, '41.141.72.85', 0, 2, 0, 0, -1, 0, 0, 'j\'O', 0, 0, 0, NULL, 0, 0, 407, 0, 0, 0, 0, 0, 0, 0, 0, 0)
	,(12, 2, NULL, 0, 'devdas', 'cac9453f42e57920c89aa7731c39e32a', '2012-08-19', 'hicham5@live.fr', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 'Junior Member', 0, 1345383531, 0, 1345383531, 1345384897, 1345384055, 0, 1, 10, 5, 0, 0, 0, 0, 0, 0, 3145813, NULL, '0000-00-00', -1, -1, '41.141.150.58', 0, 2, 0, 0, -1, 0, 0, 'mjG', 0, 0, 0, NULL, 0, 0, 94, 0, 0, 0, 0, 0, 0, 0, 0, 0)
	,(13, 2, NULL, 0, 'Arwebo', 'b5e52a17c1747e9a4ecbc3f691eab4c2', '2012-09-20', 'xx_hassan1_xx@yahoo.fr', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 'Junior Member', 0, 1348120494, 0, 1348120494, 1348120540, 0, 0, 0, 10, 5, 0, 0, 0, 0, 0, 0, 3145797, NULL, '0000-00-00', -1, -1, '41.92.34.68', 0, 2, 0, 0, -1, 0, 0, 'L\\`', 0, 0, 0, NULL, 0, 0, 89, 0, 0, 0, 0, 0, 0, 0, 0, 0)
	,(14, 2, NULL, 0, 'devnaz', '1c55a7b0fecc39965a4c5a2db3ccc420', '2012-11-26', 'dev-naz@live.fr', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 'Junior Member', 0, 1353934487, 0, 1353935129, 1354356844, 1353934526, 0, 1, 10, 5, 0, 0, 0, 0, 0, 0, 3145813, NULL, '0000-00-00', -1, -1, '41.143.25.100', 0, 2, 0, 0, -1, 0, 0, '=4!', 0, 0, 0, NULL, 0, 0, 384, 0, 0, 0, 0, 0, 0, 0, 0, 0);

