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=17 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, 1350574179, 1350574833, 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, 19, 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', '43f15bdd53d2705c2b143294974c9a7d', '2010-06-10', 'zorel@ovh.net', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 'OVH Team', 2, 1276176600, -1, 1276176688, 1276176600, 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, 20, 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, 22, 0, 0, 0, 0, 0, 0, 0, 0, 0)
	,(5, 6, '5,7', 0, 'alexandre', 'f275ecda3813cdc178925631bade2aae', '2011-02-21', 'alexandre@ovh.net', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 'Administrator', 0, 1276769280, -1, 1298296916, 1298298326, 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, 21, 0, 0, 0, 0, 0, 0, 0, 0, 0)
	,(6, 2, NULL, 0, 'ahmed', '0dbb9ad2d6d3999d9cac27f36a1c21ca', '2011-02-21', 'ahmed.ayadi@topnet.tn', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 'Junior Member', 0, 1298298015, 0, 1298298015, 1298298048, 0, 0, 0, 10, 5, 0, 0, 0, 0, 0, 0, 3145813, NULL, '0000-00-00', -1, -1, '196.203.89.152', 0, 2, 0, 0, -1, 0, 0, '>de', 0, 0, 0, NULL, 0, 0, 98, 0, 0, 0, 0, 0, 0, 0, 0, 0)
	,(7, 2, NULL, 0, 'mahmoudix', '288373c320aac0e55aeecfd89f01d78d', '2011-03-01', 'mahmoud.mozrani@ovh.net', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 'Junior Member', 0, 1298969806, 0, 1298969839, 1299416461, 0, 0, 0, 10, 5, 0, 0, 0, 0, 0, 0, 3145813, NULL, '0000-00-00', -1, -1, '41.226.250.226', 0, 2, 0, 0, -1, 0, 0, '0)v', 0, 0, 0, NULL, 0, 0, 116, 0, 0, 0, 0, 0, 0, 0, 0, 0)
	,(8, 2, NULL, 0, 'eltunisiano', '603dc45d79b9af9b2205d345d3ab885a', '2011-03-02', 'eltunisiano@gmail.com', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 'Junior Member', 0, 1299068303, 0, 1299068303, 1299068340, 0, 0, 0, 10, 5, 0, 0, 0, 0, 0, 0, 3145813, NULL, '0000-00-00', -1, -1, '41.224.17.89', 0, 2, 0, 0, -1, 0, 0, 'yZ&', 0, 0, 0, NULL, 0, 0, 199, 0, 0, 0, 0, 0, 0, 0, 0, 0)
	,(9, 2, NULL, 0, 'kimoo133', '29160277728904a2e593340e15a874ae', '2011-03-15', 'kimoo133@gmail.com', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 'Junior Member', 0, 1300219701, 0, 1300219782, 1306772346, 0, 0, 0, 10, 5, 0, 0, 0, 0, 0, 0, 3145813, NULL, '0000-00-00', -1, -1, '41.230.62.78', 0, 2, 0, 0, -1, 0, 0, ':en', 0, 0, 0, NULL, 0, 0, 48, 0, 0, 0, 0, 0, 0, 0, 0, 0)
	,(10, 3, NULL, 0, 'servicescms', 'bc870b671fe8fca92928b0b2908234b6', '2011-05-08', 'contact@servicescms.com', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 'Junior Member', 0, 1304890566, 0, 1304890566, 1304890566, 0, 0, 0, 10, 5, 0, 0, 0, 0, 0, 0, 3146069, NULL, '0000-00-00', -1, -1, '41.230.223.240', 0, 2, 0, 0, -1, 0, 0, 't~l', 0, 0, 0, NULL, 0, 0, 73, 0, 0, 0, 0, 0, 0, 0, 0, 0)
	,(11, 2, NULL, 0, 'Mohamed', 'c6900ff52d93c7f1b44e1c0c9e67993c', '2011-06-09', 'hammabassia@hotmail.com', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 'Junior Member', 0, 1307654152, 0, 1307654774, 1342010578, 0, 0, 0, 10, 5, 0, 0, 0, 0, 0, 0, 3145797, NULL, '0000-00-00', -1, -1, '197.28.167.165', 0, 2, 0, 0, -1, 0, 0, 'C*t', 0, 0, 0, NULL, 0, 0, 77, 0, 0, 0, 0, 0, 0, 0, 0, 0)
	,(12, 2, NULL, 0, 'morsino', '69245536f75d1966f0c43d53d303433e', '2011-08-18', 'jallouli.morsi@gmail.com', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 'Junior Member', 0, 1313674532, 0, 1313674955, 1313681501, 1313674955, 0, 1, 10, 5, 0, 0, 0, 0, 0, 0, 3145813, NULL, '0000-00-00', -1, -1, '41.224.95.183', 0, 2, 0, 0, -1, 0, 0, 'DLc', 0, 0, 0, NULL, 0, 0, 366, 0, 0, 0, 0, 0, 0, 0, 0, 0)
	,(13, 2, NULL, 0, 'bassem', '8f7a5296fe574cd189e533f39796c85d', '2011-11-26', 'bl1412@gmail.com', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 'Junior Member', 0, 1322310701, 0, 1322310701, 1322312063, 1322311599, 0, 1, 10, 5, 1, 0, 0, 0, 0, 0, 3145749, NULL, '0000-00-00', -1, -1, '41.227.248.88', 0, 2, 0, 0, -1, 0, 0, '6u\'', 0, 0, 0, NULL, 0, 0, 337, 0, 0, 0, 0, 0, 0, 0, 0, 0)
	,(14, 3, NULL, 0, '&#1590;1683', 'ed0cc728e075b2133ad9594913cffffb', '2012-01-17', 'tbolbi@gmail.com', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 'Junior Member', 0, 1326801109, 0, 1326801223, 1326801223, 0, 0, 0, 10, 5, 0, 0, 0, 0, 0, 0, 3146069, NULL, '0000-00-00', -1, -1, '41.227.100.45', 0, 2, 0, 0, -1, 0, 0, '06`', 0, 0, 0, NULL, 0, 0, 214, 0, 0, 0, 0, 0, 0, 0, 0, 0)
	,(15, 2, NULL, 0, 'PACHA', 'd4875f75de94b0e6def154b38c735665', '2012-04-20', 'zalloumi.achraf@gmail.com', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 'Junior Member', 0, 1334936588, 0, 1334936588, 1334936653, 0, 0, 0, 10, 5, 0, 0, 0, 0, 0, 0, 3145813, NULL, '0000-00-00', -1, -1, '197.15.73.109', 0, 2, 0, 0, -1, 0, 0, '#]W', 0, 0, 0, NULL, 0, 0, 346, 0, 0, 0, 0, 0, 0, 0, 0, 0)
	,(16, 2, NULL, 0, 'agencep', '6c419bba8c6403938343c353d3c11985', '2012-08-06', 'sliti.sabri@gmail.com', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 'Junior Member', 0, 1344264960, 0, 1344264960, 1344265111, 1344265088, 4, 1, 10, 5, 0, 0, 0, 0, 0, 0, 3146069, NULL, '0000-00-00', -1, -1, '197.0.159.172', 0, 2, 0, 0, -1, 0, 0, '9By', 0, 0, 0, NULL, 0, 0, 509, 0, 0, 0, 0, 0, 0, 0, 0, 0);

