1-- phpMyAdmin SQL Dump 2-- version 4.4.14 3-- http://www.phpmyadmin.net 4-- 5-- Host: 127.0.0.1 6-- Generation Time: Aug 19, 2016 at 04:02 PM 7-- Server version: 5.5.45 8-- PHP Version: 5.4.45 9 10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; 11SET time_zone = "+00:00"; 12 13 14/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; 15/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; 16/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; 17/*!40101 SET NAMES utf8mb4 */; 18 19-- 20-- Database: `mybb` 21-- 22 23-- -------------------------------------------------------- 24 25-- 26-- Table structure for table `mybb_usergroups` 27-- 28 29CREATE TABLE `mybb_usergroups` ( 30 `gid` smallint(5) unsigned NOT NULL, 31 `type` tinyint(1) unsigned NOT NULL DEFAULT '2', 32 `title` varchar(120) NOT NULL DEFAULT '', 33 `description` text NOT NULL DEFAULT '', 34 `namestyle` varchar(200) NOT NULL DEFAULT '{username}', 35 `usertitle` varchar(120) NOT NULL DEFAULT '', 36 `stars` smallint(4) unsigned NOT NULL DEFAULT '0', 37 `starimage` varchar(120) NOT NULL DEFAULT '', 38 `image` varchar(120) NOT NULL DEFAULT '', 39 `disporder` smallint(6) unsigned NOT NULL DEFAULT '0', 40 `isbannedgroup` tinyint(1) NOT NULL DEFAULT '0', 41 `canview` tinyint(1) NOT NULL DEFAULT '0', 42 `canviewthreads` tinyint(1) NOT NULL DEFAULT '0', 43 `canviewprofiles` tinyint(1) NOT NULL DEFAULT '0', 44 `candlattachments` tinyint(1) NOT NULL DEFAULT '0', 45 `canviewboardclosed` tinyint(1) NOT NULL DEFAULT '0', 46 `canpostthreads` tinyint(1) NOT NULL DEFAULT '0', 47 `canpostreplys` tinyint(1) NOT NULL DEFAULT '0', 48 `canpostattachments` tinyint(1) NOT NULL DEFAULT '0', 49 `canratethreads` tinyint(1) NOT NULL DEFAULT '0', 50 `modposts` tinyint(1) NOT NULL DEFAULT '0', 51 `modthreads` tinyint(1) NOT NULL DEFAULT '0', 52 `mod_edit_posts` tinyint(1) NOT NULL DEFAULT '0', 53 `modattachments` tinyint(1) NOT NULL DEFAULT '0', 54 `caneditposts` tinyint(1) NOT NULL DEFAULT '0', 55 `candeleteposts` tinyint(1) NOT NULL DEFAULT '0', 56 `candeletethreads` tinyint(1) NOT NULL DEFAULT '0', 57 `caneditattachments` tinyint(1) NOT NULL DEFAULT '0', 58 `canpostpolls` tinyint(1) NOT NULL DEFAULT '0', 59 `canvotepolls` tinyint(1) NOT NULL DEFAULT '0', 60 `canundovotes` tinyint(1) NOT NULL DEFAULT '0', 61 `canusepms` tinyint(1) NOT NULL DEFAULT '0', 62 `cansendpms` tinyint(1) NOT NULL DEFAULT '0', 63 `cantrackpms` tinyint(1) NOT NULL DEFAULT '0', 64 `candenypmreceipts` tinyint(1) NOT NULL DEFAULT '0', 65 `pmquota` int(3) unsigned NOT NULL DEFAULT '0', 66 `maxpmrecipients` int(4) unsigned NOT NULL DEFAULT '5', 67 `cansendemail` tinyint(1) NOT NULL DEFAULT '0', 68 `cansendemailoverride` tinyint(1) NOT NULL DEFAULT '0', 69 `maxemails` int(3) unsigned NOT NULL DEFAULT '5', 70 `emailfloodtime` int(3) unsigned NOT NULL DEFAULT '5', 71 `canviewmemberlist` tinyint(1) NOT NULL DEFAULT '0', 72 `canviewcalendar` tinyint(1) NOT NULL DEFAULT '0', 73 `canaddevents` tinyint(1) NOT NULL DEFAULT '0', 74 `canbypasseventmod` tinyint(1) NOT NULL DEFAULT '0', 75 `canmoderateevents` tinyint(1) NOT NULL DEFAULT '0', 76 `canviewonline` tinyint(1) NOT NULL DEFAULT '0', 77 `canviewwolinvis` tinyint(1) NOT NULL DEFAULT '0', 78 `canviewonlineips` tinyint(1) NOT NULL DEFAULT '0', 79 `cancp` tinyint(1) NOT NULL DEFAULT '0', 80 `issupermod` tinyint(1) NOT NULL DEFAULT '0', 81 `cansearch` tinyint(1) NOT NULL DEFAULT '0', 82 `canusercp` tinyint(1) NOT NULL DEFAULT '0', 83 `canuploadavatars` tinyint(1) NOT NULL DEFAULT '0', 84 `canratemembers` tinyint(1) NOT NULL DEFAULT '0', 85 `canchangename` tinyint(1) NOT NULL DEFAULT '0', 86 `canbereported` tinyint(1) NOT NULL DEFAULT '0', 87 `canchangewebsite` tinyint(1) NOT NULL DEFAULT '1', 88 `showforumteam` tinyint(1) NOT NULL DEFAULT '0', 89 `usereputationsystem` tinyint(1) NOT NULL DEFAULT '0', 90 `cangivereputations` tinyint(1) NOT NULL DEFAULT '0', 91 `candeletereputations` tinyint(1) NOT NULL DEFAULT '0', 92 `reputationpower` int(10) unsigned NOT NULL DEFAULT '0', 93 `maxreputationsday` int(10) unsigned NOT NULL DEFAULT '0', 94 `maxreputationsperuser` int(10) unsigned NOT NULL DEFAULT '0', 95 `maxreputationsperthread` int(10) unsigned NOT NULL DEFAULT '0', 96 `candisplaygroup` tinyint(1) NOT NULL DEFAULT '0', 97 `attachquota` int(10) unsigned NOT NULL DEFAULT '0', 98 `cancustomtitle` tinyint(1) NOT NULL DEFAULT '0', 99 `canwarnusers` tinyint(1) NOT NULL DEFAULT '0', 100 `canreceivewarnings` tinyint(1) NOT NULL DEFAULT '0', 101 `maxwarningsday` int(3) unsigned NOT NULL DEFAULT '3', 102 `canmodcp` tinyint(1) NOT NULL DEFAULT '0', 103 `showinbirthdaylist` tinyint(1) NOT NULL DEFAULT '0', 104 `canoverridepm` tinyint(1) NOT NULL DEFAULT '0', 105 `canusesig` tinyint(1) NOT NULL DEFAULT '0', 106 `canusesigxposts` smallint(5) unsigned NOT NULL DEFAULT '0', 107 `signofollow` tinyint(1) NOT NULL DEFAULT '0', 108 `edittimelimit` int(4) unsigned NOT NULL DEFAULT '0', 109 `maxposts` int(4) unsigned NOT NULL DEFAULT '0', 110 `showmemberlist` tinyint(1) NOT NULL DEFAULT '1', 111 `canmanageannounce` tinyint(1) NOT NULL DEFAULT '0', 112 `canmanagemodqueue` tinyint(1) NOT NULL DEFAULT '0', 113 `canmanagereportedcontent` tinyint(1) NOT NULL DEFAULT '0', 114 `canviewmodlogs` tinyint(1) NOT NULL DEFAULT '0', 115 `caneditprofiles` tinyint(1) NOT NULL DEFAULT '0', 116 `canbanusers` tinyint(1) NOT NULL DEFAULT '0', 117 `canviewwarnlogs` tinyint(1) NOT NULL DEFAULT '0', 118 `canuseipsearch` tinyint(1) NOT NULL DEFAULT '0' 119) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8; 120 121-- 122-- Dumping data for table `mybb_usergroups` 123-- 124 125INSERT INTO `mybb_usergroups` (`gid`, `type`, `title`, `description`, `namestyle`, `usertitle`, `stars`, `starimage`, `image`, `disporder`, `isbannedgroup`, `canview`, `canviewthreads`, `canviewprofiles`, `candlattachments`, `canviewboardclosed`, `canpostthreads`, `canpostreplys`, `canpostattachments`, `canratethreads`, `modposts`, `modthreads`, `mod_edit_posts`, `modattachments`, `caneditposts`, `candeleteposts`, `candeletethreads`, `caneditattachments`, `canpostpolls`, `canvotepolls`, `canundovotes`, `canusepms`, `cansendpms`, `cantrackpms`, `candenypmreceipts`, `pmquota`, `maxpmrecipients`, `cansendemail`, `cansendemailoverride`, `maxemails`, `emailfloodtime`, `canviewmemberlist`, `canviewcalendar`, `canaddevents`, `canbypasseventmod`, `canmoderateevents`, `canviewonline`, `canviewwolinvis`, `canviewonlineips`, `cancp`, `issupermod`, `cansearch`, `canusercp`, `canuploadavatars`, `canratemembers`, `canchangename`, `canbereported`, `canchangewebsite`, `showforumteam`, `usereputationsystem`, `cangivereputations`, `candeletereputations`, `reputationpower`, `maxreputationsday`, `maxreputationsperuser`, `maxreputationsperthread`, `candisplaygroup`, `attachquota`, `cancustomtitle`, `canwarnusers`, `canreceivewarnings`, `maxwarningsday`, `canmodcp`, `showinbirthdaylist`, `canoverridepm`, `canusesig`, `canusesigxposts`, `signofollow`, `edittimelimit`, `maxposts`, `showmemberlist`, `canmanageannounce`, `canmanagemodqueue`, `canmanagereportedcontent`, `canviewmodlogs`, `caneditprofiles`, `canbanusers`, `canviewwarnlogs`, `canuseipsearch`) VALUES 126(1, 1, 'Guests', 'The default group that all visitors are assigned to unless they''re logged in.', '{username}', 'Unregistered', 0, '', '', 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 5, 0, 0, 5, 5, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0), 127(2, 1, 'Registered', 'After registration, all users are placed in this group by default.', '{username}', '', 0, 'images/star.png', '', 0, 0, 1, 1, 1, 1, 0, 1, 1, 1, 1, 0, 0, 0, 0, 1, 1, 1, 1, 1, 1, 0, 1, 1, 1, 1, 200, 5, 1, 0, 5, 5, 1, 1, 1, 0, 0, 1, 0, 0, 0, 0, 1, 1, 1, 1, 1, 1, 1, 0, 1, 1, 1, 1, 5, 0, 0, 1, 0, 1, 0, 1, 0, 0, 1, 0, 1, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0), 128(3, 1, 'Super Moderators', 'These users can moderate any forum.', '<span style="color: #CC00CC;"><strong>{username}</strong></span>', 'Super Moderator', 6, 'images/star.png', '', 0, 0, 1, 1, 1, 1, 0, 1, 1, 1, 1, 0, 0, 0, 0, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 250, 5, 1, 0, 10, 5, 1, 1, 1, 1, 1, 1, 1, 1, 0, 1, 1, 1, 1, 1, 1, 0, 1, 1, 1, 1, 1, 1, 10, 0, 0, 1, 0, 1, 1, 1, 3, 1, 1, 0, 1, 0, 0, 0, 0, 1, 1, 1, 1, 1, 1, 1, 1, 1), 129(4, 1, 'Administrators', 'The group all administrators belong to.', '<span style="color: green;"><strong><em>{username}</em></strong></span>', 'Administrator', 7, 'images/star.png', '', 0, 0, 1, 1, 1, 1, 1, 1, 1, 1, 1, 0, 0, 0, 0, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 0, 0, 1, 0, 0, 0, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 0, 1, 1, 1, 1, 1, 2, 0, 0, 0, 1, 0, 1, 1, 1, 0, 1, 1, 0, 1, 0, 0, 0, 0, 1, 1, 1, 1, 1, 1, 1, 1, 1), 130(5, 1, 'Awaiting Activation', 'Users that have not activated their account by email or manually been activated yet.', '{username}', 'Account not Activated', 0, 'images/star.png', '', 0, 0, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 20, 5, 0, 0, 5, 5, 1, 1, 0, 0, 0, 1, 0, 0, 0, 0, 1, 1, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0), 131(6, 1, 'Moderators', 'These users moderate specific forums.', '<span style="color: #CC00CC;"><strong>{username}</strong></span>', 'Moderator', 5, 'images/star.png', '', 0, 0, 1, 1, 1, 1, 0, 1, 1, 1, 1, 0, 0, 0, 0, 1, 1, 1, 1, 1, 1, 0, 1, 1, 1, 1, 250, 5, 1, 0, 5, 5, 1, 1, 0, 0, 0, 1, 0, 0, 0, 0, 1, 1, 1, 1, 1, 0, 1, 1, 1, 1, 1, 1, 10, 0, 0, 1, 0, 1, 1, 1, 3, 1, 1, 0, 1, 0, 0, 0, 0, 1, 1, 1, 1, 1, 1, 1, 1, 1), 132(7, 1, 'Banned', 'The default user group to which members that are banned are moved to.', '<s>{username}</s>', 'Banned', 0, 'images/star.png', '', 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 5, 5, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0); 133 134-- 135-- Indexes for dumped tables 136-- 137 138-- 139-- Indexes for table `mybb_usergroups` 140-- 141ALTER TABLE `mybb_usergroups` 142 ADD PRIMARY KEY (`gid`); 143 144-- 145-- AUTO_INCREMENT for dumped tables 146-- 147 148-- 149-- AUTO_INCREMENT for table `mybb_usergroups` 150-- 151ALTER TABLE `mybb_usergroups` 152 MODIFY `gid` smallint(5) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=8; 153/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; 154/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; 155/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; 156-- phpMyAdmin SQL Dump 157-- version 4.4.14 158-- http://www.phpmyadmin.net 159-- 160-- Host: 127.0.0.1 161-- Generation Time: Aug 19, 2016 at 03:47 PM 162-- Server version: 5.5.45 163-- PHP Version: 5.4.45 164 165SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; 166SET time_zone = "+00:00"; 167 168 169/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; 170/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; 171/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; 172/*!40101 SET NAMES utf8mb4 */; 173 174-- 175-- Database: `mybb` 176-- 177 178-- -------------------------------------------------------- 179 180-- 181-- Table structure for table `mybb_users` 182-- 183 184CREATE TABLE `mybb_users` ( 185 `uid` int(10) unsigned NOT NULL, 186 `username` varchar(120) NOT NULL DEFAULT '', 187 `password` varchar(120) NOT NULL DEFAULT '', 188 `salt` varchar(10) NOT NULL DEFAULT '', 189 `loginkey` varchar(50) NOT NULL DEFAULT '', 190 `email` varchar(220) NOT NULL DEFAULT '', 191 `postnum` int(10) unsigned NOT NULL DEFAULT '0', 192 `threadnum` int(10) unsigned NOT NULL DEFAULT '0', 193 `avatar` varchar(200) NOT NULL DEFAULT '', 194 `avatardimensions` varchar(10) NOT NULL DEFAULT '', 195 `avatartype` varchar(10) NOT NULL DEFAULT '0', 196 `usergroup` smallint(5) unsigned NOT NULL DEFAULT '0', 197 `additionalgroups` varchar(200) NOT NULL DEFAULT '', 198 `displaygroup` smallint(5) unsigned NOT NULL DEFAULT '0', 199 `usertitle` varchar(250) NOT NULL DEFAULT '', 200 `regdate` int(10) unsigned NOT NULL DEFAULT '0', 201 `lastactive` int(10) unsigned NOT NULL DEFAULT '0', 202 `lastvisit` int(10) unsigned NOT NULL DEFAULT '0', 203 `lastpost` int(10) unsigned NOT NULL DEFAULT '0', 204 `website` varchar(200) NOT NULL DEFAULT '', 205 `icq` varchar(10) NOT NULL DEFAULT '', 206 `aim` varchar(50) NOT NULL DEFAULT '', 207 `yahoo` varchar(50) NOT NULL DEFAULT '', 208 `skype` varchar(75) NOT NULL DEFAULT '', 209 `google` varchar(75) NOT NULL DEFAULT '', 210 `birthday` varchar(15) NOT NULL DEFAULT '', 211 `birthdayprivacy` varchar(4) NOT NULL DEFAULT 'all', 212 `signature` text NOT NULL DEFAULT '', 213 `allownotices` tinyint(1) NOT NULL DEFAULT '0', 214 `hideemail` tinyint(1) NOT NULL DEFAULT '0', 215 `subscriptionmethod` tinyint(1) NOT NULL DEFAULT '0', 216 `invisible` tinyint(1) NOT NULL DEFAULT '0', 217 `receivepms` tinyint(1) NOT NULL DEFAULT '0', 218 `receivefrombuddy` tinyint(1) NOT NULL DEFAULT '0', 219 `pmnotice` tinyint(1) NOT NULL DEFAULT '0', 220 `pmnotify` tinyint(1) NOT NULL DEFAULT '0', 221 `buddyrequestspm` tinyint(1) NOT NULL DEFAULT '1', 222 `buddyrequestsauto` tinyint(1) NOT NULL DEFAULT '0', 223 `threadmode` varchar(8) NOT NULL DEFAULT '', 224 `showimages` tinyint(1) NOT NULL DEFAULT '0', 225 `showvideos` tinyint(1) NOT NULL DEFAULT '0', 226 `showsigs` tinyint(1) NOT NULL DEFAULT '0', 227 `showavatars` tinyint(1) NOT NULL DEFAULT '0', 228 `showquickreply` tinyint(1) NOT NULL DEFAULT '0', 229 `showredirect` tinyint(1) NOT NULL DEFAULT '0', 230 `ppp` smallint(6) unsigned NOT NULL DEFAULT '0', 231 `tpp` smallint(6) unsigned NOT NULL DEFAULT '0', 232 `daysprune` smallint(6) unsigned NOT NULL DEFAULT '0', 233 `dateformat` varchar(4) NOT NULL DEFAULT '', 234 `timeformat` varchar(4) NOT NULL DEFAULT '', 235 `timezone` varchar(5) NOT NULL DEFAULT '', 236 `dst` tinyint(1) NOT NULL DEFAULT '0', 237 `dstcorrection` tinyint(1) NOT NULL DEFAULT '0', 238 `buddylist` text NOT NULL DEFAULT '', 239 `ignorelist` text NOT NULL DEFAULT '', 240 `style` smallint(5) unsigned NOT NULL DEFAULT '0', 241 `away` tinyint(1) NOT NULL DEFAULT '0', 242 `awaydate` int(10) unsigned NOT NULL DEFAULT '0', 243 `returndate` varchar(15) NOT NULL DEFAULT '', 244 `awayreason` varchar(200) NOT NULL DEFAULT '', 245 `pmfolders` text NOT NULL DEFAULT '', 246 `notepad` text NOT NULL DEFAULT '', 247 `referrer` int(10) unsigned NOT NULL DEFAULT '0', 248 `referrals` int(10) unsigned NOT NULL DEFAULT '0', 249 `reputation` int(11) NOT NULL DEFAULT '0', 250 `regip` varbinary(16) NOT NULL DEFAULT '', 251 `lastip` varbinary(16) NOT NULL DEFAULT '', 252 `language` varchar(50) NOT NULL DEFAULT '', 253 `timeonline` int(10) unsigned NOT NULL DEFAULT '0', 254 `showcodebuttons` tinyint(1) NOT NULL DEFAULT '1', 255 `totalpms` int(10) unsigned NOT NULL DEFAULT '0', 256 `unreadpms` int(10) unsigned NOT NULL DEFAULT '0', 257 `warningpoints` int(3) unsigned NOT NULL DEFAULT '0', 258 `moderateposts` tinyint(1) NOT NULL DEFAULT '0', 259 `moderationtime` int(10) unsigned NOT NULL DEFAULT '0', 260 `suspendposting` tinyint(1) NOT NULL DEFAULT '0', 261 `suspensiontime` int(10) unsigned NOT NULL DEFAULT '0', 262 `suspendsignature` tinyint(1) NOT NULL DEFAULT '0', 263 `suspendsigtime` int(10) unsigned NOT NULL DEFAULT '0', 264 `coppauser` tinyint(1) NOT NULL DEFAULT '0', 265 `classicpostbit` tinyint(1) NOT NULL DEFAULT '0', 266 `loginattempts` smallint(2) unsigned NOT NULL DEFAULT '1', 267 `usernotes` text NOT NULL DEFAULT '', 268 `sourceeditor` tinyint(1) NOT NULL DEFAULT '0' 269) ENGINE=MyISAM AUTO_INCREMENT=88 DEFAULT CHARSET=utf8; 270 271-- 272-- Dumping data for table `mybb_users` 273-- 274 275INSERT INTO `mybb_users` (`uid`, `username`, `password`, `salt`, `loginkey`, `email`, `postnum`, `threadnum`, `avatar`, `avatardimensions`, `avatartype`, `usergroup`, `additionalgroups`, `displaygroup`, `usertitle`, `regdate`, `lastactive`, `lastvisit`, `lastpost`, `website`, `icq`, `aim`, `yahoo`, `skype`, `google`, `birthday`, `birthdayprivacy`, `signature`, `allownotices`, `hideemail`, `subscriptionmethod`, `invisible`, `receivepms`, `receivefrombuddy`, `pmnotice`, `pmnotify`, `buddyrequestspm`, `buddyrequestsauto`, `threadmode`, `showimages`, `showvideos`, `showsigs`, `showavatars`, `showquickreply`, `showredirect`, `ppp`, `tpp`, `daysprune`, `dateformat`, `timeformat`, `timezone`, `dst`, `dstcorrection`, `buddylist`, `ignorelist`, `style`, `away`, `awaydate`, `returndate`, `awayreason`, `pmfolders`, `notepad`, `referrer`, `referrals`, `reputation`, `regip`, `lastip`, `language`, `timeonline`, `showcodebuttons`, `totalpms`, `unreadpms`, `warningpoints`, `moderateposts`, `moderationtime`, `suspendposting`, `suspensiontime`, `suspendsignature`, `suspendsigtime`, `coppauser`, `classicpostbit`, `loginattempts`, `usernotes`, `sourceeditor`) VALUES 276(84, 'Test One', '6e90cf918ebce3a577fd72cea919dc64', '0pBnrIIv', 'xALZxWcfw18AhO6M7YxptBrxZqyrJB04CWlyaIniO3ZyMn6P1f', 'no_one@nowhere.com', 0, 0, '', '', '', 2, '', 0, '', 1471614765, 1471614765, 1471614765, 0, '', '0', '', '', '', '', '', 'all', '', 1, 1, 0, 0, 1, 0, 1, 1, 1, 0, 'linear', 1, 1, 1, 1, 1, 1, 0, 0, 0, '0', '0', '0', 0, 2, '', '', 0, 0, 0, '0', '', '', '', 0, 0, 0, '', '', '', 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, '', 0), 277(85, 'Test Two', 'e85f6b7e5804b42d7c7d99329dc1a43f', 'NSX3xNT1', 'VucYxl7EGnsoqVW75COGNAdB0YgtWHc9RFqo4LxIhhtpEFxdIE', 'no_one@nowhere.com', 0, 0, '', '', '', 3, '', 0, '', 1471614850, 1471614850, 1471614850, 0, '', '0', '', '', '', '', '', 'all', '', 1, 1, 0, 0, 1, 0, 1, 1, 1, 0, 'linear', 1, 1, 1, 1, 1, 1, 0, 0, 0, '0', '0', '0', 0, 2, '', '', 0, 0, 0, '0', '', '', '', 0, 0, 0, '', '', '', 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, '', 0), 278(86, 'Test Three', '3669c9583702ca6e32c7817f4bc34f5f', 'CVEbGFXH', 'GivwOlOKuvpfTs8Dc263fNnPdSQW1k1C1fHt7gukTJdRvTZGca', 'no_one@nowhere.com', 0, 0, '', '', '', 4, '', 0, '', 1471615021, 1471615021, 1471615021, 0, '', '0', '', '', '', '', '', 'all', '', 1, 1, 0, 0, 1, 0, 1, 1, 1, 0, 'linear', 1, 1, 1, 1, 1, 1, 0, 0, 0, '0', '0', '0', 0, 2, '', '', 0, 0, 0, '0', '', '', '', 0, 0, 0, '', '', '', 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, '', 0), 279(87, 'Test Four', '693a0cd028c9adb4cb28d8a8be3dc7af', 'x6q7QFmU', 'S4oU92jET3yjvbiganAKCYde9ksoacJeb4sC247qvYftgwsYmu', 'no_one@nowhere.com', 0, 0, '', '', '', 6, '', 0, '', 1471615064, 1471615064, 1471615064, 0, '', '0', '', '', '', '', '', 'all', '', 1, 1, 0, 0, 1, 0, 1, 1, 1, 0, 'linear', 1, 1, 1, 1, 1, 1, 0, 0, 0, '0', '0', '0', 0, 2, '', '', 0, 0, 0, '0', '', '', '', 0, 0, 0, '', '', '', 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, '', 0); 280 281-- 282-- Indexes for dumped tables 283-- 284 285-- 286-- Indexes for table `mybb_users` 287-- 288ALTER TABLE `mybb_users` 289 ADD PRIMARY KEY (`uid`), 290 ADD UNIQUE KEY `username` (`username`), 291 ADD KEY `usergroup` (`usergroup`), 292 ADD KEY `regip` (`regip`), 293 ADD KEY `lastip` (`lastip`); 294 295-- 296-- AUTO_INCREMENT for dumped tables 297-- 298 299-- 300-- AUTO_INCREMENT for table `mybb_users` 301-- 302ALTER TABLE `mybb_users` 303 MODIFY `uid` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=88; 304/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; 305/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; 306/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; 307