| Zeile 6 | Zeile 6 |
|---|
* Website: http://mybb.com
* License: http://mybb.com/about/license
*
|
* Website: http://mybb.com
* License: http://mybb.com/about/license
*
|
* $Id: mysql_db_tables.php 5125 2010-07-27 07:28:03Z RyanGordon $
| * $Id$
|
*/
$tables[] = "CREATE TABLE mybb_adminlog (
| */
$tables[] = "CREATE TABLE mybb_adminlog (
|
| Zeile 17 | Zeile 17 |
|---|
action varchar(50) NOT NULL default '',
data text NOT NULL,
KEY module (module, action)
|
action varchar(50) NOT NULL default '',
data text NOT NULL,
KEY module (module, action)
|
) TYPE=MyISAM;";
| ) ENGINE=MyISAM;";
|
$tables[] = "CREATE TABLE mybb_adminoptions (
uid int NOT NULL default '0',
|
$tables[] = "CREATE TABLE mybb_adminoptions (
uid int NOT NULL default '0',
|
| Zeile 29 | Zeile 29 |
|---|
loginattempts int unsigned NOT NULL default '0',
loginlockoutexpiry int unsigned NOT NULL default '0',
PRIMARY KEY (uid)
|
loginattempts int unsigned NOT NULL default '0',
loginlockoutexpiry int unsigned NOT NULL default '0',
PRIMARY KEY (uid)
|
) TYPE=MyISAM;";
| ) ENGINE=MyISAM;";
|
$tables[] = "CREATE TABLE mybb_adminsessions (
sid varchar(32) NOT NULL default '',
|
$tables[] = "CREATE TABLE mybb_adminsessions (
sid varchar(32) NOT NULL default '',
|
| Zeile 39 | Zeile 39 |
|---|
dateline bigint(30) NOT NULL default '0',
lastactive bigint(30) NOT NULL default '0',
data TEXT NOT NULL
|
dateline bigint(30) NOT NULL default '0',
lastactive bigint(30) NOT NULL default '0',
data TEXT NOT NULL
|
) TYPE=MyISAM;";
| ) ENGINE=MyISAM;";
|
$tables[] = "CREATE TABLE mybb_adminviews (
vid int unsigned NOT NULL auto_increment,
|
$tables[] = "CREATE TABLE mybb_adminviews (
vid int unsigned NOT NULL auto_increment,
|
| Zeile 49 | Zeile 49 |
|---|
visibility int(1) NOT NULL default '0',
`fields` text NOT NULL,
conditions text NOT NULL,
|
visibility int(1) NOT NULL default '0',
`fields` text NOT NULL,
conditions text NOT NULL,
|
| | custom_profile_fields text NOT NULL,
|
sortby varchar(20) NOT NULL default '',
sortorder varchar(4) NOT NULL default '',
perpage int(4) NOT NULL default '0',
view_type varchar(6) NOT NULL default '',
PRIMARY KEY(vid)
|
sortby varchar(20) NOT NULL default '',
sortorder varchar(4) NOT NULL default '',
perpage int(4) NOT NULL default '0',
view_type varchar(6) NOT NULL default '',
PRIMARY KEY(vid)
|
) TYPE=MyISAM;";
| ) ENGINE=MyISAM;";
|
$tables[] = "CREATE TABLE mybb_announcements (
aid int unsigned NOT NULL auto_increment,
|
$tables[] = "CREATE TABLE mybb_announcements (
aid int unsigned NOT NULL auto_increment,
|
| Zeile 69 | Zeile 70 |
|---|
allowsmilies int(1) NOT NULL default '0',
KEY fid (fid),
PRIMARY KEY (aid)
|
allowsmilies int(1) NOT NULL default '0',
KEY fid (fid),
PRIMARY KEY (aid)
|
) TYPE=MyISAM;";
| ) ENGINE=MyISAM;";
|
$tables[] = "CREATE TABLE mybb_attachments (
aid int unsigned NOT NULL auto_increment,
|
$tables[] = "CREATE TABLE mybb_attachments (
aid int unsigned NOT NULL auto_increment,
|
| Zeile 88 | Zeile 89 |
|---|
KEY pid (pid, visible),
KEY uid (uid),
PRIMARY KEY (aid)
|
KEY pid (pid, visible),
KEY uid (uid),
PRIMARY KEY (aid)
|
) TYPE=MyISAM;";
| ) ENGINE=MyISAM;";
|
$tables[] = "CREATE TABLE mybb_attachtypes (
atid int unsigned NOT NULL auto_increment,
|
$tables[] = "CREATE TABLE mybb_attachtypes (
atid int unsigned NOT NULL auto_increment,
|
| Zeile 98 | Zeile 99 |
|---|
maxsize int(15) NOT NULL default '0',
icon varchar(100) NOT NULL default '',
PRIMARY KEY (atid)
|
maxsize int(15) NOT NULL default '0',
icon varchar(100) NOT NULL default '',
PRIMARY KEY (atid)
|
) TYPE=MyISAM;";
| ) ENGINE=MyISAM;";
|
$tables[] = "CREATE TABLE mybb_awaitingactivation (
aid int unsigned NOT NULL auto_increment,
|
$tables[] = "CREATE TABLE mybb_awaitingactivation (
aid int unsigned NOT NULL auto_increment,
|
| Zeile 109 | Zeile 110 |
|---|
oldgroup bigint(30) NOT NULL default '0',
misc varchar(255) NOT NULL default '',
PRIMARY KEY (aid)
|
oldgroup bigint(30) NOT NULL default '0',
misc varchar(255) NOT NULL default '',
PRIMARY KEY (aid)
|
) TYPE=MyISAM;";
| ) ENGINE=MyISAM;";
|
$tables[] = "CREATE TABLE mybb_badwords (
bid int unsigned NOT NULL auto_increment,
badword varchar(100) NOT NULL default '',
replacement varchar(100) NOT NULL default '',
PRIMARY KEY (bid)
|
$tables[] = "CREATE TABLE mybb_badwords (
bid int unsigned NOT NULL auto_increment,
badword varchar(100) NOT NULL default '',
replacement varchar(100) NOT NULL default '',
PRIMARY KEY (bid)
|
) TYPE=MyISAM;";
| ) ENGINE=MyISAM;";
|
$tables[] = "CREATE TABLE mybb_banfilters (
fid int unsigned NOT NULL auto_increment,
|
$tables[] = "CREATE TABLE mybb_banfilters (
fid int unsigned NOT NULL auto_increment,
|
| Zeile 125 | Zeile 126 |
|---|
lastuse bigint(30) NOT NULL default '0',
dateline bigint(30) NOT NULL default '0',
PRIMARY KEY (fid)
|
lastuse bigint(30) NOT NULL default '0',
dateline bigint(30) NOT NULL default '0',
PRIMARY KEY (fid)
|
) TYPE=MyISAM;";
| ) ENGINE=MyISAM;";
|
$tables[] = "CREATE TABLE mybb_banned (
uid int unsigned NOT NULL default '0',
|
$tables[] = "CREATE TABLE mybb_banned (
uid int unsigned NOT NULL default '0',
|
| Zeile 140 | Zeile 141 |
|---|
reason varchar(255) NOT NULL default '',
KEY uid (uid),
KEY dateline (dateline)
|
reason varchar(255) NOT NULL default '',
KEY uid (uid),
KEY dateline (dateline)
|
) TYPE=MyISAM;";
| ) ENGINE=MyISAM;";
|
$tables[] = "CREATE TABLE mybb_calendars (
cid int unsigned NOT NULL auto_increment,
|
$tables[] = "CREATE TABLE mybb_calendars (
cid int unsigned NOT NULL auto_increment,
|
| Zeile 156 | Zeile 157 |
|---|
allowvideocode int(1) NOT NULL default '0',
allowsmilies int(1) NOT NULL default '0',
PRIMARY KEY(cid)
|
allowvideocode int(1) NOT NULL default '0',
allowsmilies int(1) NOT NULL default '0',
PRIMARY KEY(cid)
|
) TYPE=MyISAM;";
| ) ENGINE=MyISAM;";
|
$tables[] = "CREATE TABLE mybb_calendarpermissions (
cid int unsigned NOT NULL default '0',
|
$tables[] = "CREATE TABLE mybb_calendarpermissions (
cid int unsigned NOT NULL default '0',
|
| Zeile 165 | Zeile 166 |
|---|
canaddevents int(1) NOT NULL default '0',
canbypasseventmod int(1) NOT NULL default '0',
canmoderateevents int(1) NOT NULL default '0'
|
canaddevents int(1) NOT NULL default '0',
canbypasseventmod int(1) NOT NULL default '0',
canmoderateevents int(1) NOT NULL default '0'
|
) TYPE=MyISAM;";
| ) ENGINE=MyISAM;";
|
$tables[] = "CREATE TABLE mybb_captcha (
imagehash varchar(32) NOT NULL default '',
|
$tables[] = "CREATE TABLE mybb_captcha (
imagehash varchar(32) NOT NULL default '',
|
| Zeile 173 | Zeile 174 |
|---|
dateline bigint(30) NOT NULL default '0',
KEY imagehash (imagehash),
KEY dateline (dateline)
|
dateline bigint(30) NOT NULL default '0',
KEY imagehash (imagehash),
KEY dateline (dateline)
|
) TYPE=MyISAM;";
| ) ENGINE=MyISAM;";
|
$tables[] = "CREATE TABLE mybb_datacache (
title varchar(50) NOT NULL default '',
cache mediumtext NOT NULL,
PRIMARY KEY(title)
|
$tables[] = "CREATE TABLE mybb_datacache (
title varchar(50) NOT NULL default '',
cache mediumtext NOT NULL,
PRIMARY KEY(title)
|
) TYPE=MyISAM;";
| ) ENGINE=MyISAM;";
|
$tables[] = "CREATE TABLE mybb_delayedmoderation (
did int unsigned NOT NULL auto_increment,
|
$tables[] = "CREATE TABLE mybb_delayedmoderation (
did int unsigned NOT NULL auto_increment,
|
| Zeile 191 | Zeile 192 |
|---|
dateline bigint(30) NOT NULL default '0',
inputs text NOT NULL,
PRIMARY KEY (did)
|
dateline bigint(30) NOT NULL default '0',
inputs text NOT NULL,
PRIMARY KEY (did)
|
) TYPE=MyISAM;";
| ) ENGINE=MyISAM;";
|
$tables[] = "CREATE TABLE mybb_events (
eid int unsigned NOT NULL auto_increment,
|
$tables[] = "CREATE TABLE mybb_events (
eid int unsigned NOT NULL auto_increment,
|
| Zeile 211 | Zeile 212 |
|---|
KEY daterange (starttime, endtime),
KEY private (private),
PRIMARY KEY (eid)
|
KEY daterange (starttime, endtime),
KEY private (private),
PRIMARY KEY (eid)
|
) TYPE=MyISAM;";
| ) ENGINE=MyISAM;";
|
$tables[] = "CREATE TABLE mybb_forumpermissions (
pid int unsigned NOT NULL auto_increment,
|
$tables[] = "CREATE TABLE mybb_forumpermissions (
pid int unsigned NOT NULL auto_increment,
|
| Zeile 233 | Zeile 234 |
|---|
canvotepolls int(1) NOT NULL default '0',
cansearch int(1) NOT NULL default '0',
PRIMARY KEY (pid)
|
canvotepolls int(1) NOT NULL default '0',
cansearch int(1) NOT NULL default '0',
PRIMARY KEY (pid)
|
) TYPE=MyISAM;";
| ) ENGINE=MyISAM;";
|
$tables[] = "CREATE TABLE mybb_forums (
fid smallint unsigned NOT NULL auto_increment,
|
$tables[] = "CREATE TABLE mybb_forums (
fid smallint unsigned NOT NULL auto_increment,
|
| Zeile 279 | Zeile 280 |
|---|
defaultsortby varchar(10) NOT NULL default '',
defaultsortorder varchar(4) NOT NULL default '',
PRIMARY KEY (fid)
|
defaultsortby varchar(10) NOT NULL default '',
defaultsortorder varchar(4) NOT NULL default '',
PRIMARY KEY (fid)
|
) TYPE=MyISAM;";
| ) ENGINE=MyISAM;";
|
$tables[] = "CREATE TABLE mybb_forumsread (
fid int unsigned NOT NULL default '0',
|
$tables[] = "CREATE TABLE mybb_forumsread (
fid int unsigned NOT NULL default '0',
|
| Zeile 287 | Zeile 288 |
|---|
dateline int(10) NOT NULL default '0',
KEY dateline (dateline),
UNIQUE KEY fid (fid,uid)
|
dateline int(10) NOT NULL default '0',
KEY dateline (dateline),
UNIQUE KEY fid (fid,uid)
|
) TYPE=MyISAM;";
| ) ENGINE=MyISAM;";
|
$tables[] = "CREATE TABLE mybb_forumsubscriptions (
|
$tables[] = "CREATE TABLE mybb_forumsubscriptions (
|
| Zeile 295 | Zeile 296 |
|---|
fid smallint unsigned NOT NULL default '0',
uid int unsigned NOT NULL default '0',
PRIMARY KEY (fsid)
|
fid smallint unsigned NOT NULL default '0',
uid int unsigned NOT NULL default '0',
PRIMARY KEY (fsid)
|
) TYPE=MyISAM;";
| ) ENGINE=MyISAM;";
|
$tables[] = "CREATE TABLE mybb_groupleaders (
lid smallint unsigned NOT NULL auto_increment,
|
$tables[] = "CREATE TABLE mybb_groupleaders (
lid smallint unsigned NOT NULL auto_increment,
|
| Zeile 304 | Zeile 305 |
|---|
canmanagemembers int(1) NOT NULL default '0',
canmanagerequests int(1) NOT NULL default '0',
PRIMARY KEY (lid)
|
canmanagemembers int(1) NOT NULL default '0',
canmanagerequests int(1) NOT NULL default '0',
PRIMARY KEY (lid)
|
) TYPE=MyISAM;";
| ) ENGINE=MyISAM;";
|
$tables[] = "CREATE TABLE mybb_helpdocs (
hid smallint unsigned NOT NULL auto_increment,
|
$tables[] = "CREATE TABLE mybb_helpdocs (
hid smallint unsigned NOT NULL auto_increment,
|
| Zeile 316 | Zeile 317 |
|---|
enabled int(1) NOT NULL default '0',
disporder smallint unsigned NOT NULL default '0',
PRIMARY KEY (hid)
|
enabled int(1) NOT NULL default '0',
disporder smallint unsigned NOT NULL default '0',
PRIMARY KEY (hid)
|
) TYPE=MyISAM;";
| ) ENGINE=MyISAM;";
|
$tables[] = "CREATE TABLE mybb_helpsections (
|
$tables[] = "CREATE TABLE mybb_helpsections (
|
| Zeile 327 | Zeile 328 |
|---|
enabled int(1) NOT NULL default '0',
disporder smallint unsigned NOT NULL default '0',
PRIMARY KEY (sid)
|
enabled int(1) NOT NULL default '0',
disporder smallint unsigned NOT NULL default '0',
PRIMARY KEY (sid)
|
) TYPE=MyISAM;";
| ) ENGINE=MyISAM;";
|
$tables[] = "CREATE TABLE mybb_icons (
|
$tables[] = "CREATE TABLE mybb_icons (
|
| Zeile 335 | Zeile 336 |
|---|
name varchar(120) NOT NULL default '',
path varchar(220) NOT NULL default '',
PRIMARY KEY (iid)
|
name varchar(120) NOT NULL default '',
path varchar(220) NOT NULL default '',
PRIMARY KEY (iid)
|
) TYPE=MyISAM;";
| ) ENGINE=MyISAM;";
|
$tables[] = "CREATE TABLE mybb_joinrequests (
|
$tables[] = "CREATE TABLE mybb_joinrequests (
|
| Zeile 345 | Zeile 346 |
|---|
reason varchar(250) NOT NULL default '',
dateline bigint(30) NOT NULL default '0',
PRIMARY KEY (rid)
|
reason varchar(250) NOT NULL default '',
dateline bigint(30) NOT NULL default '0',
PRIMARY KEY (rid)
|
) TYPE=MyISAM;";
| ) ENGINE=MyISAM;";
|
$tables[] = "CREATE TABLE mybb_massemails (
mid int unsigned NOT NULL auto_increment,
|
$tables[] = "CREATE TABLE mybb_massemails (
mid int unsigned NOT NULL auto_increment,
|
| Zeile 363 | Zeile 364 |
|---|
conditions text NOT NULL,
perpage smallint(4) NOT NULL default '50',
PRIMARY KEY(mid)
|
conditions text NOT NULL,
perpage smallint(4) NOT NULL default '50',
PRIMARY KEY(mid)
|
) TYPE=MyISAM;";
| ) ENGINE=MyISAM;";
|
$tables[] = "CREATE TABLE mybb_mailerrors (
eid int unsigned NOT NULL auto_increment,
|
$tables[] = "CREATE TABLE mybb_mailerrors (
eid int unsigned NOT NULL auto_increment,
|
| Zeile 376 | Zeile 377 |
|---|
smtperror varchar(200) NOT NULL default '',
smtpcode int(5) NOT NULL default '0',
PRIMARY KEY (eid)
|
smtperror varchar(200) NOT NULL default '',
smtpcode int(5) NOT NULL default '0',
PRIMARY KEY (eid)
|
) TYPE=MyISAM;";
| ) ENGINE=MyISAM;";
|
$tables[] = "CREATE TABLE mybb_maillogs (
mid int unsigned NOT NULL auto_increment,
|
$tables[] = "CREATE TABLE mybb_maillogs (
mid int unsigned NOT NULL auto_increment,
|
| Zeile 390 | Zeile 391 |
|---|
tid int unsigned NOT NULL default '0',
ipaddress varchar(20) NOT NULL default '',
PRIMARY KEY (mid)
|
tid int unsigned NOT NULL default '0',
ipaddress varchar(20) NOT NULL default '',
PRIMARY KEY (mid)
|
) TYPE=MyISAM;";
| ) ENGINE=MyISAM;";
|
$tables[] = "CREATE TABLE mybb_mailqueue (
mid int unsigned NOT NULL auto_increment,
|
$tables[] = "CREATE TABLE mybb_mailqueue (
mid int unsigned NOT NULL auto_increment,
|
| Zeile 400 | Zeile 401 |
|---|
message text NOT NULL,
headers text NOT NULL,
PRIMARY KEY (mid)
|
message text NOT NULL,
headers text NOT NULL,
PRIMARY KEY (mid)
|
) TYPE=MyISAM;";
| ) ENGINE=MyISAM;";
|
$tables[] = "CREATE TABLE mybb_moderatorlog (
uid int unsigned NOT NULL default '0',
|
$tables[] = "CREATE TABLE mybb_moderatorlog (
uid int unsigned NOT NULL default '0',
|
| Zeile 412 | Zeile 413 |
|---|
data text NOT NULL,
ipaddress varchar(50) NOT NULL default '',
KEY tid (tid)
|
data text NOT NULL,
ipaddress varchar(50) NOT NULL default '',
KEY tid (tid)
|
) TYPE=MyISAM;";
| ) ENGINE=MyISAM;";
|
$tables[] = "CREATE TABLE mybb_moderators (
mid smallint unsigned NOT NULL auto_increment,
|
$tables[] = "CREATE TABLE mybb_moderators (
mid smallint unsigned NOT NULL auto_increment,
|
| Zeile 425 | Zeile 426 |
|---|
canopenclosethreads int(1) NOT NULL default '0',
canmanagethreads int(1) NOT NULL default '0',
canmovetononmodforum int(1) NOT NULL default '0',
|
canopenclosethreads int(1) NOT NULL default '0',
canmanagethreads int(1) NOT NULL default '0',
canmovetononmodforum int(1) NOT NULL default '0',
|
| | canusecustomtools int(1) NOT NULL default '0',
|
KEY uid (id, fid),
PRIMARY KEY (mid)
|
KEY uid (id, fid),
PRIMARY KEY (mid)
|
) TYPE=MyISAM;";
| ) ENGINE=MyISAM;";
|
$tables[] = "CREATE TABLE mybb_modtools (
tid smallint unsigned NOT NULL auto_increment,
|
$tables[] = "CREATE TABLE mybb_modtools (
tid smallint unsigned NOT NULL auto_increment,
|
| Zeile 438 | Zeile 440 |
|---|
postoptions text NOT NULL,
threadoptions text NOT NULL,
PRIMARY KEY (tid)
|
postoptions text NOT NULL,
threadoptions text NOT NULL,
PRIMARY KEY (tid)
|
) TYPE=MyISAM;";
| ) ENGINE=MyISAM;";
|
$tables[] = "CREATE TABLE mybb_mycode (
cid int unsigned NOT NULL auto_increment,
|
$tables[] = "CREATE TABLE mybb_mycode (
cid int unsigned NOT NULL auto_increment,
|
| Zeile 449 | Zeile 451 |
|---|
active int(1) NOT NULL default '0',
parseorder smallint unsigned NOT NULL default '0',
PRIMARY KEY(cid)
|
active int(1) NOT NULL default '0',
parseorder smallint unsigned NOT NULL default '0',
PRIMARY KEY(cid)
|
) TYPE=MyISAM;";
| ) ENGINE=MyISAM;";
|
$tables[] = "CREATE TABLE mybb_polls (
pid int unsigned NOT NULL auto_increment,
|
$tables[] = "CREATE TABLE mybb_polls (
pid int unsigned NOT NULL auto_increment,
|
| Zeile 459 | Zeile 461 |
|---|
options text NOT NULL,
votes text NOT NULL,
numoptions smallint unsigned NOT NULL default '0',
|
options text NOT NULL,
votes text NOT NULL,
numoptions smallint unsigned NOT NULL default '0',
|
numvotes smallint unsigned NOT NULL default '0',
| numvotes text NOT NULL,
|
timeout bigint(30) NOT NULL default '0',
closed int(1) NOT NULL default '0',
multiple int(1) NOT NULL default '0',
public int(1) NOT NULL default '0',
PRIMARY KEY (pid)
|
timeout bigint(30) NOT NULL default '0',
closed int(1) NOT NULL default '0',
multiple int(1) NOT NULL default '0',
public int(1) NOT NULL default '0',
PRIMARY KEY (pid)
|
) TYPE=MyISAM;";
| ) ENGINE=MyISAM;";
|
$tables[] = "CREATE TABLE mybb_pollvotes (
vid int unsigned NOT NULL auto_increment,
|
$tables[] = "CREATE TABLE mybb_pollvotes (
vid int unsigned NOT NULL auto_increment,
|
| Zeile 475 | Zeile 477 |
|---|
dateline bigint(30) NOT NULL default '0',
KEY pid (pid, uid),
PRIMARY KEY (vid)
|
dateline bigint(30) NOT NULL default '0',
KEY pid (pid, uid),
PRIMARY KEY (vid)
|
) TYPE=MyISAM;";
| ) ENGINE=MyISAM;";
|
$tables[] = "CREATE TABLE mybb_posts (
pid int unsigned NOT NULL auto_increment,
|
$tables[] = "CREATE TABLE mybb_posts (
pid int unsigned NOT NULL auto_increment,
|
| Zeile 502 | Zeile 504 |
|---|
KEY dateline (dateline),
KEY longipaddress (longipaddress),
PRIMARY KEY (pid)
|
KEY dateline (dateline),
KEY longipaddress (longipaddress),
PRIMARY KEY (pid)
|
) TYPE=MyISAM;";
| ) ENGINE=MyISAM;";
|
$tables[] = "CREATE TABLE mybb_privatemessages (
|
$tables[] = "CREATE TABLE mybb_privatemessages (
|
| Zeile 526 | Zeile 528 |
|---|
KEY uid (uid, folder),
KEY toid (toid),
PRIMARY KEY (pmid)
|
KEY uid (uid, folder),
KEY toid (toid),
PRIMARY KEY (pmid)
|
) TYPE=MyISAM;";
| ) ENGINE=MyISAM;";
|
$tables[] = "CREATE TABLE mybb_profilefields (
|
$tables[] = "CREATE TABLE mybb_profilefields (
|
| Zeile 540 | Zeile 542 |
|---|
required int(1) NOT NULL default '0',
editable int(1) NOT NULL default '0',
hidden int(1) NOT NULL default '0',
|
required int(1) NOT NULL default '0',
editable int(1) NOT NULL default '0',
hidden int(1) NOT NULL default '0',
|
| | postnum bigint(30) NOT NULL default '0',
|
PRIMARY KEY (fid)
|
PRIMARY KEY (fid)
|
) TYPE=MyISAM;";
| ) ENGINE=MyISAM;";
|
$tables[] = "CREATE TABLE mybb_promotions (
|
$tables[] = "CREATE TABLE mybb_promotions (
|
| Zeile 563 | Zeile 566 |
|---|
newusergroup smallint unsigned NOT NULL default '0',
usergrouptype varchar(120) NOT NULL default '0',
PRIMARY KEY (pid)
|
newusergroup smallint unsigned NOT NULL default '0',
usergrouptype varchar(120) NOT NULL default '0',
PRIMARY KEY (pid)
|
) TYPE=MyISAM;";
| ) ENGINE=MyISAM;";
|
$tables[] = "CREATE TABLE mybb_promotionlogs (
plid int unsigned NOT NULL auto_increment,
|
$tables[] = "CREATE TABLE mybb_promotionlogs (
plid int unsigned NOT NULL auto_increment,
|
| Zeile 574 | Zeile 577 |
|---|
dateline bigint(30) NOT NULL default '0',
type varchar(9) NOT NULL default 'primary',
PRIMARY KEY(plid)
|
dateline bigint(30) NOT NULL default '0',
type varchar(9) NOT NULL default 'primary',
PRIMARY KEY(plid)
|
) TYPE=MyISAM;";
| ) ENGINE=MyISAM;";
|
$tables[] = "CREATE TABLE mybb_reportedposts (
rid int unsigned NOT NULL auto_increment,
|
$tables[] = "CREATE TABLE mybb_reportedposts (
rid int unsigned NOT NULL auto_increment,
|
| Zeile 588 | Zeile 591 |
|---|
KEY fid (fid),
KEY dateline (dateline),
PRIMARY KEY (rid)
|
KEY fid (fid),
KEY dateline (dateline),
PRIMARY KEY (rid)
|
) TYPE=MyISAM;";
| ) ENGINE=MyISAM;";
|
$tables[] = "CREATE TABLE mybb_reputation (
rid int unsigned NOT NULL auto_increment,
|
$tables[] = "CREATE TABLE mybb_reputation (
rid int unsigned NOT NULL auto_increment,
|
| Zeile 602 | Zeile 605 |
|---|
KEY pid (pid),
KEY dateline (dateline),
PRIMARY KEY (rid)
|
KEY pid (pid),
KEY dateline (dateline),
PRIMARY KEY (rid)
|
) TYPE=MyISAM;";
| ) ENGINE=MyISAM;";
|
$tables[] = "CREATE TABLE mybb_searchlog (
sid varchar(32) NOT NULL default '',
|
$tables[] = "CREATE TABLE mybb_searchlog (
sid varchar(32) NOT NULL default '',
|
| Zeile 615 | Zeile 618 |
|---|
querycache text NOT NULL,
keywords text NOT NULL,
PRIMARY KEY (sid)
|
querycache text NOT NULL,
keywords text NOT NULL,
PRIMARY KEY (sid)
|
) TYPE=MyISAM;";
| ) ENGINE=MyISAM;";
|
$tables[] = "CREATE TABLE mybb_sessions (
sid varchar(32) NOT NULL default '',
|
$tables[] = "CREATE TABLE mybb_sessions (
sid varchar(32) NOT NULL default '',
|
| Zeile 634 | Zeile 637 |
|---|
KEY time (time),
KEY uid (uid),
KEY ip (ip)
|
KEY time (time),
KEY uid (uid),
KEY ip (ip)
|
) TYPE=MyISAM;";
| ) ENGINE=MyISAM;";
|
$tables[] = "CREATE TABLE mybb_settinggroups (
gid smallint unsigned NOT NULL auto_increment,
|
$tables[] = "CREATE TABLE mybb_settinggroups (
gid smallint unsigned NOT NULL auto_increment,
|
| Zeile 644 | Zeile 647 |
|---|
disporder smallint unsigned NOT NULL default '0',
isdefault int(1) NOT NULL default '0',
PRIMARY KEY (gid)
|
disporder smallint unsigned NOT NULL default '0',
isdefault int(1) NOT NULL default '0',
PRIMARY KEY (gid)
|
) TYPE=MyISAM;";
| ) ENGINE=MyISAM;";
|
$tables[] = "CREATE TABLE mybb_settings (
|
$tables[] = "CREATE TABLE mybb_settings (
|
| Zeile 658 | Zeile 661 |
|---|
gid smallint unsigned NOT NULL default '0',
isdefault int(1) NOT NULL default '0',
PRIMARY KEY (sid)
|
gid smallint unsigned NOT NULL default '0',
isdefault int(1) NOT NULL default '0',
PRIMARY KEY (sid)
|
) TYPE=MyISAM;";
| ) ENGINE=MyISAM;";
|
$tables[] = "CREATE TABLE mybb_smilies (
|
$tables[] = "CREATE TABLE mybb_smilies (
|
| Zeile 669 | Zeile 672 |
|---|
disporder smallint unsigned NOT NULL default '0',
showclickable int(1) NOT NULL default '0',
PRIMARY KEY (sid)
|
disporder smallint unsigned NOT NULL default '0',
showclickable int(1) NOT NULL default '0',
PRIMARY KEY (sid)
|
) TYPE=MyISAM;";
| ) ENGINE=MyISAM;";
|
$tables[] = "CREATE TABLE mybb_spiders (
sid int unsigned NOT NULL auto_increment,
|
$tables[] = "CREATE TABLE mybb_spiders (
sid int unsigned NOT NULL auto_increment,
|
| Zeile 680 | Zeile 683 |
|---|
useragent varchar(200) NOT NULL default '',
lastvisit bigint(30) NOT NULL default '0',
PRIMARY KEY (sid)
|
useragent varchar(200) NOT NULL default '',
lastvisit bigint(30) NOT NULL default '0',
PRIMARY KEY (sid)
|
) TYPE=MyISAM;";
| ) ENGINE=MyISAM;";
|
$tables[] = "CREATE TABLE mybb_stats (
dateline bigint(30) NOT NULL default '0',
|
$tables[] = "CREATE TABLE mybb_stats (
dateline bigint(30) NOT NULL default '0',
|
| Zeile 688 | Zeile 691 |
|---|
numthreads int unsigned NOT NULL default '0',
numposts int unsigned NOT NULL default '0',
PRIMARY KEY(dateline)
|
numthreads int unsigned NOT NULL default '0',
numposts int unsigned NOT NULL default '0',
PRIMARY KEY(dateline)
|
) TYPE=MyISAM;";
| ) ENGINE=MyISAM;";
|
$tables[] = "CREATE TABLE mybb_tasks (
tid int unsigned NOT NULL auto_increment,
|
$tables[] = "CREATE TABLE mybb_tasks (
tid int unsigned NOT NULL auto_increment,
|
| Zeile 706 | Zeile 709 |
|---|
logging int(1) NOT NULL default '0',
locked bigint(30) NOT NULL default '0',
PRIMARY KEY (tid)
|
logging int(1) NOT NULL default '0',
locked bigint(30) NOT NULL default '0',
PRIMARY KEY (tid)
|
) TYPE=MyISAM;";
| ) ENGINE=MyISAM;";
|
$tables[] = "CREATE TABLE mybb_tasklog (
lid int unsigned NOT NULL auto_increment,
|
$tables[] = "CREATE TABLE mybb_tasklog (
lid int unsigned NOT NULL auto_increment,
|
| Zeile 714 | Zeile 717 |
|---|
dateline bigint(30) NOT NULL default '0',
data text NOT NULL,
PRIMARY KEY (lid)
|
dateline bigint(30) NOT NULL default '0',
data text NOT NULL,
PRIMARY KEY (lid)
|
) TYPE=MyISAM;";
| ) ENGINE=MyISAM;";
|
$tables[] = "CREATE TABLE mybb_templategroups (
gid int unsigned NOT NULL auto_increment,
prefix varchar(50) NOT NULL default '',
title varchar(100) NOT NULL default '',
PRIMARY KEY (gid)
|
$tables[] = "CREATE TABLE mybb_templategroups (
gid int unsigned NOT NULL auto_increment,
prefix varchar(50) NOT NULL default '',
title varchar(100) NOT NULL default '',
PRIMARY KEY (gid)
|
) TYPE=MyISAM;";
| ) ENGINE=MyISAM;";
|
$tables[] = "CREATE TABLE mybb_templates (
tid int unsigned NOT NULL auto_increment,
|
$tables[] = "CREATE TABLE mybb_templates (
tid int unsigned NOT NULL auto_increment,
|
| Zeile 732 | Zeile 735 |
|---|
status varchar(10) NOT NULL default '',
dateline int(10) NOT NULL default '0',
PRIMARY KEY (tid)
|
status varchar(10) NOT NULL default '',
dateline int(10) NOT NULL default '0',
PRIMARY KEY (tid)
|
) TYPE=MyISAM;";
| ) ENGINE=MyISAM;";
|
$tables[] = "CREATE TABLE mybb_templatesets (
sid smallint unsigned NOT NULL auto_increment,
title varchar(120) NOT NULL default '',
PRIMARY KEY (sid)
|
$tables[] = "CREATE TABLE mybb_templatesets (
sid smallint unsigned NOT NULL auto_increment,
title varchar(120) NOT NULL default '',
PRIMARY KEY (sid)
|
) TYPE=MyISAM;";
| ) ENGINE=MyISAM;";
|
$tables[] = "CREATE TABLE mybb_themes (
|
$tables[] = "CREATE TABLE mybb_themes (
|
| Zeile 750 | Zeile 753 |
|---|
stylesheets text NOT NULL,
allowedgroups text NOT NULL,
PRIMARY KEY (tid)
|
stylesheets text NOT NULL,
allowedgroups text NOT NULL,
PRIMARY KEY (tid)
|
) TYPE=MyISAM;";
| ) ENGINE=MyISAM;";
|
$tables[] = "CREATE TABLE mybb_themestylesheets(
sid int unsigned NOT NULL auto_increment,
|
$tables[] = "CREATE TABLE mybb_themestylesheets(
sid int unsigned NOT NULL auto_increment,
|
| Zeile 761 | Zeile 764 |
|---|
cachefile varchar(100) NOT NULL default '',
lastmodified bigint(30) NOT NULL default '0',
PRIMARY KEY(sid)
|
cachefile varchar(100) NOT NULL default '',
lastmodified bigint(30) NOT NULL default '0',
PRIMARY KEY(sid)
|
) TYPE=MyISAM;";
| ) ENGINE=MyISAM;";
|
$tables[] = "CREATE TABLE mybb_threadprefixes (
pid int unsigned NOT NULL auto_increment,
|
$tables[] = "CREATE TABLE mybb_threadprefixes (
pid int unsigned NOT NULL auto_increment,
|
| Zeile 770 | Zeile 773 |
|---|
forums text NOT NULL,
groups text NOT NULL,
PRIMARY KEY(pid)
|
forums text NOT NULL,
groups text NOT NULL,
PRIMARY KEY(pid)
|
) TYPE=MyISAM;";
| ) ENGINE=MyISAM;";
|
$tables[] = "CREATE TABLE mybb_threadratings (
rid int unsigned NOT NULL auto_increment,
|
$tables[] = "CREATE TABLE mybb_threadratings (
rid int unsigned NOT NULL auto_increment,
|
| Zeile 780 | Zeile 783 |
|---|
ipaddress varchar(30) NOT NULL default '',
KEY tid (tid, uid),
PRIMARY KEY (rid)
|
ipaddress varchar(30) NOT NULL default '',
KEY tid (tid, uid),
PRIMARY KEY (rid)
|
) TYPE=MyISAM;";
| ) ENGINE=MyISAM;";
|
$tables[] = "CREATE TABLE mybb_threadviews (
tid int unsigned NOT NULL default '0',
KEY (tid)
|
$tables[] = "CREATE TABLE mybb_threadviews (
tid int unsigned NOT NULL default '0',
KEY (tid)
|
) TYPE=MyISAM;";
| ) ENGINE=MyISAM;";
|
$tables[] = "CREATE TABLE mybb_threads (
|
$tables[] = "CREATE TABLE mybb_threads (
|
| Zeile 819 | Zeile 822 |
|---|
KEY firstpost (firstpost),
KEY uid (uid),
PRIMARY KEY (tid)
|
KEY firstpost (firstpost),
KEY uid (uid),
PRIMARY KEY (tid)
|
) TYPE=MyISAM;";
| ) ENGINE=MyISAM;";
|
$tables[] = "CREATE TABLE mybb_threadsread (
tid int unsigned NOT NULL default '0',
|
$tables[] = "CREATE TABLE mybb_threadsread (
tid int unsigned NOT NULL default '0',
|
| Zeile 827 | Zeile 830 |
|---|
dateline int(10) NOT NULL default '0',
KEY dateline (dateline),
UNIQUE KEY tid (tid,uid)
|
dateline int(10) NOT NULL default '0',
KEY dateline (dateline),
UNIQUE KEY tid (tid,uid)
|
) TYPE=MyISAM;";
| ) ENGINE=MyISAM;";
|
$tables[] = "CREATE TABLE mybb_threadsubscriptions (
sid int unsigned NOT NULL auto_increment,
|
$tables[] = "CREATE TABLE mybb_threadsubscriptions (
sid int unsigned NOT NULL auto_increment,
|
| Zeile 839 | Zeile 842 |
|---|
KEY uid (uid),
KEY tid (tid,notification),
PRIMARY KEY (sid)
|
KEY uid (uid),
KEY tid (tid,notification),
PRIMARY KEY (sid)
|
) TYPE=MyISAM;";
| ) ENGINE=MyISAM;";
|
$tables[] = "CREATE TABLE mybb_userfields (
ufid int unsigned NOT NULL default '0',
|
$tables[] = "CREATE TABLE mybb_userfields (
ufid int unsigned NOT NULL default '0',
|
| Zeile 847 | Zeile 850 |
|---|
fid2 text NOT NULL,
fid3 text NOT NULL,
PRIMARY KEY (ufid)
|
fid2 text NOT NULL,
fid3 text NOT NULL,
PRIMARY KEY (ufid)
|
) TYPE=MyISAM;";
| ) ENGINE=MyISAM;";
|
$tables[] = "CREATE TABLE mybb_usergroups (
gid smallint unsigned NOT NULL auto_increment,
|
$tables[] = "CREATE TABLE mybb_usergroups (
gid smallint unsigned NOT NULL auto_increment,
|
| Zeile 883 | Zeile 886 |
|---|
pmquota int(3) NOT NULL default '0',
maxpmrecipients int(4) NOT NULL default '5',
cansendemail int(1) NOT NULL default '0',
|
pmquota int(3) NOT NULL default '0',
maxpmrecipients int(4) NOT NULL default '5',
cansendemail int(1) NOT NULL default '0',
|
| | cansendemailoverride int(1) NOT NULL default '0',
|
maxemails int(3) NOT NULL default '5',
canviewmemberlist int(1) NOT NULL default '0',
canviewcalendar int(1) NOT NULL default '0',
| maxemails int(3) NOT NULL default '5',
canviewmemberlist int(1) NOT NULL default '0',
canviewcalendar int(1) NOT NULL default '0',
|
| Zeile 913 | Zeile 917 |
|---|
canreceivewarnings int(1) NOT NULL default '0',
maxwarningsday int(3) NOT NULL default '3',
canmodcp int(1) NOT NULL default '0',
|
canreceivewarnings int(1) NOT NULL default '0',
maxwarningsday int(3) NOT NULL default '3',
canmodcp int(1) NOT NULL default '0',
|
| | showinbirthdaylist int(1) NOT NULL default '0',
canoverridepm int(1) NOT NULL default '0',
canusesig int(1) NOT NULL default '0',
canusesigxposts bigint(30) NOT NULL default '0',
signofollow int(1) NOT NULL default '0',
|
PRIMARY KEY (gid)
|
PRIMARY KEY (gid)
|
) TYPE=MyISAM;";
| ) ENGINE=MyISAM;";
|
$tables[] = "CREATE TABLE mybb_users (
|
$tables[] = "CREATE TABLE mybb_users (
|
| Zeile 996 | Zeile 1005 |
|---|
coppauser int(1) NOT NULL default '0',
classicpostbit int(1) NOT NULL default '0',
loginattempts tinyint(2) NOT NULL default '1',
|
coppauser int(1) NOT NULL default '0',
classicpostbit int(1) NOT NULL default '0',
loginattempts tinyint(2) NOT NULL default '1',
|
failedlogin bigint(30) NOT NULL default '0',
| |
usernotes text NOT NULL,
UNIQUE KEY username (username),
KEY usergroup (usergroup),
| usernotes text NOT NULL,
UNIQUE KEY username (username),
KEY usergroup (usergroup),
|
| Zeile 1004 | Zeile 1012 |
|---|
KEY longregip (longregip),
KEY longlastip (longlastip),
PRIMARY KEY (uid)
|
KEY longregip (longregip),
KEY longlastip (longlastip),
PRIMARY KEY (uid)
|
) TYPE=MyISAM;";
| ) ENGINE=MyISAM;";
|
$tables[] = "CREATE TABLE mybb_usertitles (
utid smallint unsigned NOT NULL auto_increment,
|
$tables[] = "CREATE TABLE mybb_usertitles (
utid smallint unsigned NOT NULL auto_increment,
|
| Zeile 1013 | Zeile 1021 |
|---|
stars smallint(4) NOT NULL default '0',
starimage varchar(120) NOT NULL default '',
PRIMARY KEY (utid)
|
stars smallint(4) NOT NULL default '0',
starimage varchar(120) NOT NULL default '',
PRIMARY KEY (utid)
|
) TYPE=MyISAM;";
| ) ENGINE=MyISAM;";
|
$tables[] = "CREATE TABLE mybb_warninglevels (
lid int unsigned NOT NULL auto_increment,
percentage int(3) NOT NULL default '0',
action text NOT NULL,
PRIMARY KEY (lid)
|
$tables[] = "CREATE TABLE mybb_warninglevels (
lid int unsigned NOT NULL auto_increment,
percentage int(3) NOT NULL default '0',
action text NOT NULL,
PRIMARY KEY (lid)
|
) TYPE=MyISAM;";
| ) ENGINE=MyISAM;";
|
$tables[] = "CREATE TABLE mybb_warningtypes (
tid int unsigned NOT NULL auto_increment,
|
$tables[] = "CREATE TABLE mybb_warningtypes (
tid int unsigned NOT NULL auto_increment,
|
| Zeile 1028 | Zeile 1036 |
|---|
points int unsigned NOT NULL default '0',
expirationtime bigint(30) NOT NULL default '0',
PRIMARY KEY (tid)
|
points int unsigned NOT NULL default '0',
expirationtime bigint(30) NOT NULL default '0',
PRIMARY KEY (tid)
|
) TYPE=MyISAM;";
| ) ENGINE=MyISAM;";
|
$tables[] = "CREATE TABLE mybb_warnings (
wid int unsigned NOT NULL auto_increment,
|
$tables[] = "CREATE TABLE mybb_warnings (
wid int unsigned NOT NULL auto_increment,
|
| Zeile 1046 | Zeile 1054 |
|---|
revokereason text NOT NULL,
notes text NOT NULL,
PRIMARY KEY (wid)
|
revokereason text NOT NULL,
notes text NOT NULL,
PRIMARY KEY (wid)
|
) TYPE=MyISAM;";
| ) ENGINE=MyISAM;";
|
?>
|
?>
|