SQL RCRacing.com Database

[hhhd556]

taken from the raids

Date: 2015-03

Entries: 221k

Hash: vBulletin

Спойлер: tables

-- Adminer 4.3.1 MySQL dump

SET NAMES utf8;
SET time_zone = '+00:00';
SET foreign_key_checks = 0;
SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';

DROP TABLE IF EXISTS user;
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 '33570831',
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(30) 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',
assetposthash varchar(32) NOT NULL DEFAULT '',
fbuserid varchar(255) NOT NULL DEFAULT '',
fbjoindate int(10) unsigned NOT NULL DEFAULT '0',
fbname varchar(255) NOT NULL DEFAULT '',
logintype enum('vb','fb') NOT NULL DEFAULT 'vb',
fbaccesstoken varchar(255) NOT NULL DEFAULT '',
bloggroupreqcount int(10) unsigned NOT NULL DEFAULT '0',
showblogcss int(11) NOT NULL DEFAULT '1',
newrepcount smallint(5) unsigned NOT NULL DEFAULT '0',
panjo_selling tinyint(1) DEFAULT NULL,
PRIMARY KEY (userid),
KEY usergroupid (usergroupid),

Botea Tudor, [23.11.20 23:43]
KEY username (username),
KEY birthday (birthday,showbirthday),
KEY birthday_search (birthday_search),
KEY referrerid (referrerid),
KEY fbuserid (fbuserid),
KEY email (email),
KEY lastactivity (lastactivity)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

Спойлер: sample

1, 6, '', 0, 'Grid Admin', '3374ae1afe088fe341ef44fdeae63f75', '2013-09-22', 'steveprc@gmail.com', 0, '', '', '', '', '', '', '', 2, 2, 'Administrator', 0, 1307867280, 0, 1474864336, 1486825358, 1308500220, 0, 6, 10, 1, '0', 0, 0, 0, 0, 0, 11552855, '', '0000-00-00', -1, 1, '', 0, 0, 0, 0, -1, 0, 0, 'Iq=W1FJ6+ocSt{:iO-\\i_uumwiA\"vf', 0, 0, 0, '', 0, 0, 4023, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', 0, '', 'vb', '', 0, 1, 0, NULL),
(2, 6, '', 0, 'Mike', '6e7e4643d310bbdbe9141a69acededdf', '2013-09-21', 'mjm@sgrid.com', 0, '', 'http://www.sgrid.com', '', 'sgrid', '', '', '', 2, 3, 'Janitor', 1, 1307889540, -1, 1474769756, 1475440819, 1474766743, 10246, 2866, 10, 5, '-5', 1, 0, 0, 0, 0, 45632983, '12-22-1943', '1943-12-22', -1, 1, '', 0, 0, 0, 0, -1, 202, 0, 'Q{vU\\GJ:=$wbm1Z\":zMvM1j.Is^\"Mz', 0, 0, 0, '', 0, 0, 12158, 0, 0, 0, 0, 0, 0, 0, 0, 0, '286b1b01a853def4e88c6e18b61ca631', '100001357765548', 1308976697, 'Mike Sgrid', 'vb', '155034214565618|648c1f3093f8237d9e0b75414af4363d', 0, 1, 0, NULL),
(4, 5, '', 0, 'Stephen B', '5c00276cc0c573f75f19bba8df92b8d3', '2011-06-14', 'stephenb@airage.com', 1, '', '', '', '', '', '', '', 1, 0, 'Currently: Gluing Tires', 1, 1308026040, -1, 1314056982, 1344985170, 1313183424, 3481, 48, 10, 5, '-8', 0, 0, 0, 0, 0, 45108439, '', '0000-00-00', -1, 1, '', 0, 0, 0, 0, -1, 15, 0, 'LKTjqpc_-ArIESf5aYxzTE0bL1\'mvM', 0, 0, 0, '', 0, 0, 2745, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', 0, '', 'vb', '', 0, 1, 0, NULL),
(5, 2, '', 2, 'KendallB', '290fcc89c2cc19489b54b08c48ecff2c', '2011-06-20', 'kendallb@amainhobbies.com', 0, '', 'http://www.amainhobbies.com', '', '', '', '', '', 1, 0, 'Amain Hobbies', 1, 1308249300, -1, 1334539183, 1344634459, 1334539183, 7944, 28, 10, 5, '-5', 1, 0, 0, 0, 0, 45112535, '10-15-1970', '1970-10-15', -1, -1, '', 0, 0, 1328743988, 0, 1, 12, 0, 'dC\'~%8jk%aA$$4MjU_a.!>0]gT8ve@', 0, 0, 0, '', 0, 0, 2190, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '610566597', 1308594496, 'Kendall Bennett', 'vb', 'AAACNALdJhvIBACZBpx8biMQF4w1MdTfJavCtu6XvnBfXs5kLKrklNsVKRT8IIc95jYyOQtzbf6tthJRcm59wbCU1VgdZCEtdbxDJ12DwZDZD', 0, 1, 0, NULL),
(6, 9, '2', 2, 'Scott Martin', 'ebc9e75b29c924ebbdaa56fdab6f2b13', '2011-07-05', 'scott@motionpicturesphotography.com', 3, '', 'http://www.flickr.com/photos/scott-martin', '', '', '', '', '', 1, 0, 'Senior Member', 0, 1308282060, -1, 1350519873, 1351806848, 1349358049, 9760, 457, 10, 5, '-6', 1, 0, 0, 0, 0, 45112535, '', '0000-00-00', -1, 1, '', 0, 0, 0, 0, -1, 52, 0, ')XM\\5;L<\\bPow;P}mjl=Pq>tYZmra(', 0, 0, 0, '', 0, 0, 5368, 0, 0, 1, 0, 0, 0, 0, 0, 0, '66dd013564b661017ee3747f10d37769', '', 0, '', 'vb', '', 0, 1, 0, NULL),

RCRacing.com

MediaFire is a simple to use free service that lets you put all your photos, documents, music, and video in a single place so you can access them anywhere and share them everywhere.

www.mediafire.com