Lines Matching +full:- +full:1
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
19 --
20 -- Database: `mybb`
21 --
23 -- --------------------------------------------------------
25 --
26 -- Table structure for table `mybb_usergroups`
27 --
31 `type` tinyint(1) unsigned NOT NULL DEFAULT '2',
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',
67 `cansendemail` tinyint(1) NOT NULL DEFAULT '0',
68 `cansendemailoverride` tinyint(1) NOT NULL DEFAULT '0',
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',
96 `candisplaygroup` tinyint(1) 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',
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',
107 `signofollow` tinyint(1) 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'
121 --
122 -- Dumping data for table `mybb_usergroups`
123 --
126 …1, 1, 'Guests', 'The default group that all visitors are assigned to unless they''re logged in.', …
127 …1, 'Registered', 'After registration, all users are placed in this group by default.', '{username}…
128 …1, 'Super Moderators', 'These users can moderate any forum.', '<span style="color: #CC00CC;"><stro…
129 …1, 'Administrators', 'The group all administrators belong to.', '<span style="color: green;"><stro…
130 …1, 'Awaiting Activation', 'Users that have not activated their account by email or manually been a…
131 …1, 'Moderators', 'These users moderate specific forums.', '<span style="color: #CC00CC;"><strong>{…
132 …1, 'Banned', 'The default user group to which members that are banned are moved to.', '<s>{usernam…
134 --
135 -- Indexes for dumped tables
136 --
138 --
139 -- Indexes for table `mybb_usergroups`
140 --
144 --
145 -- AUTO_INCREMENT for dumped tables
146 --
148 --
149 -- AUTO_INCREMENT for table `mybb_usergroups`
150 --
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
174 --
175 -- Database: `mybb`
176 --
178 -- --------------------------------------------------------
180 --
181 -- Table structure for table `mybb_users`
182 --
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',
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',
236 `dst` tinyint(1) NOT NULL DEFAULT '0',
237 `dstcorrection` tinyint(1) NOT NULL DEFAULT '0',
241 `away` tinyint(1) NOT NULL DEFAULT '0',
254 `showcodebuttons` tinyint(1) NOT NULL DEFAULT '1',
258 `moderateposts` tinyint(1) NOT NULL DEFAULT '0',
260 `suspendposting` tinyint(1) NOT NULL DEFAULT '0',
262 `suspendsignature` tinyint(1) 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',
268 `sourceeditor` tinyint(1) NOT NULL DEFAULT '0'
271 --
272 -- Dumping data for table `mybb_users`
273 --
276 …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,…
277 …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,…
278 …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,…
279 …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,…
281 --
282 -- Indexes for dumped tables
283 --
285 --
286 -- Indexes for table `mybb_users`
287 --
295 --
296 -- AUTO_INCREMENT for dumped tables
297 --
299 --
300 -- AUTO_INCREMENT for table `mybb_users`
301 --