| 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: mysql_db_tables.php 5440 2011-04-15 10:18:35Z Tomm $
|
*/
$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 54 | Zeile 54 |
|---|
perpage int(4) NOT NULL default '0',
view_type varchar(6) NOT NULL default '',
PRIMARY KEY(vid)
|
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 69 |
|---|
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 88 |
|---|
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 98 |
|---|
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 109 |
|---|
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 125 |
|---|
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 140 |
|---|
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 156 |
|---|
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 165 |
|---|
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 173 |
|---|
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 191 |
|---|
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 211 |
|---|
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 233 |
|---|
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 279 |
|---|
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 287 |
|---|
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 295 |
|---|
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 304 |
|---|
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 316 |
|---|
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 327 |
|---|
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 335 |
|---|
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 345 |
|---|
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 363 |
|---|
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 376 |
|---|
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 390 |
|---|
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 400 |
|---|
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 412 |
|---|
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 427 | Zeile 427 |
|---|
canmovetononmodforum int(1) NOT NULL default '0',
KEY uid (id, fid),
PRIMARY KEY (mid)
|
canmovetononmodforum int(1) NOT NULL default '0',
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 438 |
|---|
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 449 |
|---|
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 465 | Zeile 465 |
|---|
multiple int(1) NOT NULL default '0',
public int(1) NOT NULL default '0',
PRIMARY KEY (pid)
|
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 475 |
|---|
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 502 |
|---|
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 526 |
|---|
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 541 | Zeile 541 |
|---|
editable int(1) NOT NULL default '0',
hidden int(1) NOT NULL default '0',
PRIMARY KEY (fid)
|
editable int(1) NOT NULL default '0',
hidden int(1) NOT NULL default '0',
PRIMARY KEY (fid)
|
) TYPE=MyISAM;";
| ) ENGINE=MyISAM;";
|
$tables[] = "CREATE TABLE mybb_promotions (
|
$tables[] = "CREATE TABLE mybb_promotions (
|
| Zeile 563 | Zeile 563 |
|---|
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 574 |
|---|
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 588 |
|---|
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 602 |
|---|
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 615 |
|---|
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 634 |
|---|
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 644 |
|---|
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 658 |
|---|
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 669 |
|---|
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 680 |
|---|
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 688 |
|---|
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 706 |
|---|
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 714 |
|---|
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 732 |
|---|
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 750 |
|---|
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 761 |
|---|
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 770 |
|---|
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 780 |
|---|
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 819 |
|---|
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 827 |
|---|
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 839 |
|---|
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 847 |
|---|
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 914 | Zeile 914 |
|---|
maxwarningsday int(3) NOT NULL default '3',
canmodcp int(1) NOT NULL default '0',
PRIMARY KEY (gid)
|
maxwarningsday int(3) NOT NULL default '3',
canmodcp int(1) NOT NULL default '0',
PRIMARY KEY (gid)
|
) TYPE=MyISAM;";
| ) ENGINE=MyISAM;";
|
$tables[] = "CREATE TABLE mybb_users (
|
$tables[] = "CREATE TABLE mybb_users (
|
| Zeile 1004 | Zeile 1004 |
|---|
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 1013 |
|---|
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 1028 |
|---|
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 1046 |
|---|
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;";
|
?>
|
?>
|