| Zeile 3 | Zeile 3 |
|---|
* MyBB 1.2
* Copyright � 2006 MyBB Group, All Rights Reserved
*
|
* MyBB 1.2
* Copyright � 2006 MyBB Group, All Rights Reserved
*
|
* Website: http://www.mybboard.com
* License: http://www.mybboard.com/eula.html
| * Website: http://www.mybboard.net
* License: http://www.mybboard.net/eula.html
|
*
|
*
|
* $Id: mysql_db_tables.php 2389 2006-11-07 22:59:42Z Tikitiki $
| * $Id: mysql_db_tables.php 3531 2007-12-02 01:21:43Z chris $
|
*/
$tables[] = "CREATE TABLE mybb_adminlog (
| */
$tables[] = "CREATE TABLE mybb_adminlog (
|
| Zeile 17 | Zeile 17 |
|---|
querystring varchar(150) NOT NULL default '',
ipaddress varchar(50) NOT NULL default '',
KEY scriptname (scriptname, action)
|
querystring varchar(150) NOT NULL default '',
ipaddress varchar(50) NOT NULL default '',
KEY scriptname (scriptname, action)
|
) TYPE=MyISAM;";
| ) TYPE=MyISAM{$charset};";
|
|
|
| Zeile 45 | Zeile 45 |
|---|
canrunmaint char(3) NOT NULL default '',
canrundbtools char(3) NOT NULL default '',
PRIMARY KEY (uid)
|
canrunmaint char(3) NOT NULL default '',
canrundbtools char(3) NOT NULL default '',
PRIMARY KEY (uid)
|
) TYPE=MyISAM;";
| ) TYPE=MyISAM{$charset};";
|
$tables[] = "CREATE TABLE mybb_adminsessions (
sid varchar(32) NOT NULL default '',
|
$tables[] = "CREATE TABLE mybb_adminsessions (
sid varchar(32) NOT NULL default '',
|
| Zeile 54 | Zeile 54 |
|---|
ip varchar(40) NOT NULL default '',
dateline bigint(30) NOT NULL default '0',
lastactive bigint(30) NOT NULL default '0'
|
ip varchar(40) NOT NULL default '',
dateline bigint(30) NOT NULL default '0',
lastactive bigint(30) NOT NULL default '0'
|
) TYPE=MyISAM;";
| ) TYPE=MyISAM{$charset};";
|
$tables[] = "CREATE TABLE mybb_announcements (
|
$tables[] = "CREATE TABLE mybb_announcements (
|
| Zeile 70 | Zeile 70 |
|---|
allowsmilies char(3) NOT NULL default '',
KEY fid (fid),
PRIMARY KEY (aid)
|
allowsmilies char(3) NOT NULL default '',
KEY fid (fid),
PRIMARY KEY (aid)
|
) TYPE=MyISAM;";
| ) TYPE=MyISAM{$charset};";
|
$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;";
| ) TYPE=MyISAM{$charset};";
|
$tables[] = "CREATE TABLE mybb_attachtypes (
|
$tables[] = "CREATE TABLE mybb_attachtypes (
|
| Zeile 99 | 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;";
| ) TYPE=MyISAM{$charset};";
|
$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 110 | 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;";
| ) TYPE=MyISAM{$charset};";
|
$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;";
| ) TYPE=MyISAM{$charset};";
|
$tables[] = "CREATE TABLE mybb_banned (
uid int unsigned NOT NULL default '0',
gid int unsigned NOT NULL default '0',
oldgroup int unsigned NOT NULL default '0',
|
$tables[] = "CREATE TABLE mybb_banned (
uid int unsigned NOT NULL default '0',
gid int unsigned NOT NULL default '0',
oldgroup int unsigned NOT NULL default '0',
|
| | oldadditionalgroups text NOT NULL,
olddisplaygroup int NOT NULL default '0',
|
admin int unsigned NOT NULL default '0',
dateline bigint(30) NOT NULL default '0',
bantime varchar(50) NOT NULL default '',
| admin int unsigned NOT NULL default '0',
dateline bigint(30) NOT NULL default '0',
bantime varchar(50) NOT NULL default '',
|
| Zeile 130 | Zeile 132 |
|---|
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;";
| ) TYPE=MyISAM{$charset};";
|
$tables[] = "CREATE TABLE mybb_captcha (
imagehash varchar(32) NOT NULL default '',
|
$tables[] = "CREATE TABLE mybb_captcha (
imagehash varchar(32) NOT NULL default '',
|
| Zeile 138 | Zeile 140 |
|---|
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;";
| ) TYPE=MyISAM{$charset};";
|
$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;";
| ) TYPE=MyISAM{$charset};";
|
$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 155 | Zeile 157 |
|---|
private char(3) NOT NULL default '',
KEY private (private),
PRIMARY KEY (eid)
|
private char(3) NOT NULL default '',
KEY private (private),
PRIMARY KEY (eid)
|
) TYPE=MyISAM;";
| ) TYPE=MyISAM{$charset};";
|
$tables[] = "CREATE TABLE mybb_favorites (
fid int unsigned NOT NULL auto_increment,
|
$tables[] = "CREATE TABLE mybb_favorites (
fid int unsigned NOT NULL auto_increment,
|
| Zeile 165 | Zeile 167 |
|---|
KEY uid (uid),
KEY tid (tid,type),
PRIMARY KEY (fid)
|
KEY uid (uid),
KEY tid (tid,type),
PRIMARY KEY (fid)
|
) TYPE=MyISAM;";
| ) TYPE=MyISAM{$charset};";
|
$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 186 | Zeile 188 |
|---|
canvotepolls char(3) NOT NULL default '',
cansearch char(3) NOT NULL default '',
PRIMARY KEY (pid)
|
canvotepolls char(3) NOT NULL default '',
cansearch char(3) NOT NULL default '',
PRIMARY KEY (pid)
|
) TYPE=MyISAM;";
| ) TYPE=MyISAM{$charset};";
|
$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 230 | Zeile 232 |
|---|
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;";
| ) TYPE=MyISAM{$charset};";
|
$tables[] = "CREATE TABLE mybb_forumsubscriptions (
fsid int unsigned NOT NULL auto_increment,
fid smallint unsigned NOT NULL default '0',
uid int unsigned NOT NULL default '0',
PRIMARY KEY (fsid)
|
$tables[] = "CREATE TABLE mybb_forumsubscriptions (
fsid int unsigned NOT NULL auto_increment,
fid smallint unsigned NOT NULL default '0',
uid int unsigned NOT NULL default '0',
PRIMARY KEY (fsid)
|
) TYPE=MyISAM;";
| ) TYPE=MyISAM{$charset};";
|
$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 246 | Zeile 248 |
|---|
canmanagemembers char(3) NOT NULL default '',
canmanagerequests char(3) NOT NULL default '',
PRIMARY KEY (lid)
|
canmanagemembers char(3) NOT NULL default '',
canmanagerequests char(3) NOT NULL default '',
PRIMARY KEY (lid)
|
) TYPE=MyISAM;";
| ) TYPE=MyISAM{$charset};";
|
$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 258 | Zeile 260 |
|---|
enabled char(3) NOT NULL default '',
disporder smallint unsigned NOT NULL default '0',
PRIMARY KEY (hid)
|
enabled char(3) NOT NULL default '',
disporder smallint unsigned NOT NULL default '0',
PRIMARY KEY (hid)
|
) TYPE=MyISAM;";
| ) TYPE=MyISAM{$charset};";
|
$tables[] = "CREATE TABLE mybb_helpsections (
|
$tables[] = "CREATE TABLE mybb_helpsections (
|
| Zeile 269 | Zeile 271 |
|---|
enabled char(3) NOT NULL default '',
disporder smallint unsigned NOT NULL default '0',
PRIMARY KEY (sid)
|
enabled char(3) NOT NULL default '',
disporder smallint unsigned NOT NULL default '0',
PRIMARY KEY (sid)
|
) TYPE=MyISAM;";
| ) TYPE=MyISAM{$charset};";
|
$tables[] = "CREATE TABLE mybb_icons (
|
$tables[] = "CREATE TABLE mybb_icons (
|
| Zeile 277 | Zeile 279 |
|---|
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;";
| ) TYPE=MyISAM{$charset};";
|
$tables[] = "CREATE TABLE mybb_joinrequests (
|
$tables[] = "CREATE TABLE mybb_joinrequests (
|
| Zeile 287 | Zeile 289 |
|---|
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;";
| ) TYPE=MyISAM{$charset};";
|
$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 297 | Zeile 299 |
|---|
message text NOT NULL,
headers text NOT NULL,
PRIMARY KEY(mid)
|
message text NOT NULL,
headers text NOT NULL,
PRIMARY KEY(mid)
|
);";
| ) TYPE=MyISAM{$charset};";
|
$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 309 | Zeile 311 |
|---|
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;";
| ) TYPE=MyISAM{$charset};";
|
$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 323 | Zeile 325 |
|---|
canmovetononmodforum char(3) NOT NULL default '',
KEY uid (uid, fid),
PRIMARY KEY (mid)
|
canmovetononmodforum char(3) NOT NULL default '',
KEY uid (uid, fid),
PRIMARY KEY (mid)
|
) TYPE=MyISAM;";
| ) TYPE=MyISAM{$charset};";
|
$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 334 | Zeile 336 |
|---|
postoptions text NOT NULL,
threadoptions text NOT NULL,
PRIMARY KEY (tid)
|
postoptions text NOT NULL,
threadoptions text NOT NULL,
PRIMARY KEY (tid)
|
) TYPE=MyISAM;";
| ) TYPE=MyISAM{$charset};";
|
$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 344 | Zeile 346 |
|---|
replacement text NOT NULL,
active char(3) NOT NULL default '',
PRIMARY KEY(cid)
|
replacement text NOT NULL,
active char(3) NOT NULL default '',
PRIMARY KEY(cid)
|
) TYPE=MyISAM;";
| ) TYPE=MyISAM{$charset};";
|
$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 360 | Zeile 362 |
|---|
multiple char(3) NOT NULL default '',
public char(3) NOT NULL default '',
PRIMARY KEY (pid)
|
multiple char(3) NOT NULL default '',
public char(3) NOT NULL default '',
PRIMARY KEY (pid)
|
) TYPE=MyISAM;";
| ) TYPE=MyISAM{$charset};";
|
$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 370 | Zeile 372 |
|---|
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;";
| ) TYPE=MyISAM{$charset};";
|
$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 394 | Zeile 396 |
|---|
KEY uid (uid),
KEY dateline (dateline),
PRIMARY KEY (pid)
|
KEY uid (uid),
KEY dateline (dateline),
PRIMARY KEY (pid)
|
) TYPE=MyISAM;";
| ) TYPE=MyISAM{$charset};";
|
$tables[] = "CREATE TABLE mybb_privatemessages (
|
$tables[] = "CREATE TABLE mybb_privatemessages (
|
| Zeile 412 | Zeile 414 |
|---|
smilieoff char(3) NOT NULL default '',
receipt int(1) NOT NULL default '0',
readtime bigint(30) NOT NULL default '0',
|
smilieoff char(3) NOT NULL default '',
receipt int(1) NOT NULL default '0',
readtime bigint(30) NOT NULL default '0',
|
KEY pmid (pmid),
| |
KEY uid (uid, folder),
PRIMARY KEY (pmid)
|
KEY uid (uid, folder),
PRIMARY KEY (pmid)
|
) TYPE=MyISAM;";
| ) TYPE=MyISAM{$charset};";
|
$tables[] = "CREATE TABLE mybb_profilefields (
|
$tables[] = "CREATE TABLE mybb_profilefields (
|
| Zeile 430 | Zeile 431 |
|---|
editable char(3) NOT NULL default '',
hidden char(3) NOT NULL default '',
PRIMARY KEY (fid)
|
editable char(3) NOT NULL default '',
hidden char(3) NOT NULL default '',
PRIMARY KEY (fid)
|
) TYPE=MyISAM;";
| ) TYPE=MyISAM{$charset};";
|
$tables[] = "CREATE TABLE mybb_reportedposts (
|
$tables[] = "CREATE TABLE mybb_reportedposts (
|
| Zeile 445 | Zeile 446 |
|---|
KEY fid (fid),
KEY dateline (dateline),
PRIMARY KEY (rid)
|
KEY fid (fid),
KEY dateline (dateline),
PRIMARY KEY (rid)
|
) TYPE=MyISAM;";
| ) TYPE=MyISAM{$charset};";
|
$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 457 | Zeile 458 |
|---|
KEY uid (uid),
KEY dateline (dateline),
PRIMARY KEY(rid)
|
KEY uid (uid),
KEY dateline (dateline),
PRIMARY KEY(rid)
|
) TYPE=MyISAM;";
| ) TYPE=MyISAM{$charset};";
|
$tables[] = "CREATE TABLE mybb_searchlog (
sid varchar(32) NOT NULL default '',
|
$tables[] = "CREATE TABLE mybb_searchlog (
sid varchar(32) NOT NULL default '',
|
| Zeile 470 | Zeile 471 |
|---|
resulttype varchar(10) NOT NULL default '',
querycache text NOT NULL,
PRIMARY KEY (sid)
|
resulttype varchar(10) NOT NULL default '',
querycache text NOT NULL,
PRIMARY KEY (sid)
|
) TYPE=MyISAM;";
| ) TYPE=MyISAM{$charset};";
|
$tables[] = "CREATE TABLE mybb_sessions (
sid varchar(32) NOT NULL default '',
|
$tables[] = "CREATE TABLE mybb_sessions (
sid varchar(32) NOT NULL default '',
|
| Zeile 490 | Zeile 491 |
|---|
KEY location2 (location2),
KEY time (time),
KEY uid (uid)
|
KEY location2 (location2),
KEY time (time),
KEY uid (uid)
|
) TYPE=MyISAM;";
| ) TYPE=MyISAM{$charset};";
|
$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 500 | Zeile 501 |
|---|
disporder smallint unsigned NOT NULL default '0',
isdefault char(3) NOT NULL default '',
PRIMARY KEY (gid)
|
disporder smallint unsigned NOT NULL default '0',
isdefault char(3) NOT NULL default '',
PRIMARY KEY (gid)
|
) TYPE=MyISAM;";
| ) TYPE=MyISAM{$charset};";
|
$tables[] = "CREATE TABLE mybb_settings (
|
$tables[] = "CREATE TABLE mybb_settings (
|
| Zeile 513 | Zeile 514 |
|---|
disporder smallint unsigned NOT NULL default '0',
gid smallint unsigned NOT NULL default '0',
PRIMARY KEY (sid)
|
disporder smallint unsigned NOT NULL default '0',
gid smallint unsigned NOT NULL default '0',
PRIMARY KEY (sid)
|
) TYPE=MyISAM;";
| ) TYPE=MyISAM{$charset};";
|
$tables[] = "CREATE TABLE mybb_smilies (
|
$tables[] = "CREATE TABLE mybb_smilies (
|
| Zeile 524 | Zeile 525 |
|---|
disporder smallint unsigned NOT NULL default '0',
showclickable char(3) NOT NULL default '',
PRIMARY KEY (sid)
|
disporder smallint unsigned NOT NULL default '0',
showclickable char(3) NOT NULL default '',
PRIMARY KEY (sid)
|
) TYPE=MyISAM;";
| ) TYPE=MyISAM{$charset};";
|
$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;";
| ) TYPE=MyISAM{$charset};";
|
$tables[] = "CREATE TABLE mybb_templates (
tid int unsigned NOT NULL auto_increment,
title varchar(120) NOT NULL default '',
template text NOT NULL,
sid int(10) NOT NULL default '0',
|
$tables[] = "CREATE TABLE mybb_templates (
tid int unsigned NOT NULL auto_increment,
title varchar(120) NOT NULL default '',
template text NOT NULL,
sid int(10) NOT NULL default '0',
|
version varchar(20) NOT NULL default '0',
| version int unsigned NOT NULL default '0',
|
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;";
| ) TYPE=MyISAM{$charset};";
|
$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;";
| ) TYPE=MyISAM{$charset};";
|
$tables[] = "CREATE TABLE mybb_themes (
|
$tables[] = "CREATE TABLE mybb_themes (
|
| Zeile 563 | Zeile 564 |
|---|
allowedgroups text NOT NULL,
csscached bigint(30) NOT NULL default '0',
PRIMARY KEY (tid)
|
allowedgroups text NOT NULL,
csscached bigint(30) NOT NULL default '0',
PRIMARY KEY (tid)
|
) TYPE=MyISAM;";
| ) TYPE=MyISAM{$charset};";
|
$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 573 | Zeile 574 |
|---|
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;";
| ) TYPE=MyISAM{$charset};";
|
$tables[] = "CREATE TABLE mybb_threads (
|
$tables[] = "CREATE TABLE mybb_threads (
|
| Zeile 606 | Zeile 607 |
|---|
KEY firstpost (firstpost),
KEY uid (uid),
PRIMARY KEY (tid)
|
KEY firstpost (firstpost),
KEY uid (uid),
PRIMARY KEY (tid)
|
) TYPE=MyISAM;";
| ) TYPE=MyISAM{$charset};";
|
$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 614 | Zeile 615 |
|---|
dateline int(10) NOT NULL default '0',
KEY dateline (dateline),
UNIQUE KEY tiduid (tid,uid)
|
dateline int(10) NOT NULL default '0',
KEY dateline (dateline),
UNIQUE KEY tiduid (tid,uid)
|
) TYPE=MyISAM;";
| ) TYPE=MyISAM{$charset};";
|
$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 622 | Zeile 623 |
|---|
fid2 text NOT NULL,
fid3 text NOT NULL,
PRIMARY KEY (ufid)
|
fid2 text NOT NULL,
fid3 text NOT NULL,
PRIMARY KEY (ufid)
|
) TYPE=MyISAM;";
| ) TYPE=MyISAM{$charset};";
|
$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 679 | Zeile 680 |
|---|
attachquota bigint(30) NOT NULL default '0',
cancustomtitle char(3) NOT NULL default '',
PRIMARY KEY (gid)
|
attachquota bigint(30) NOT NULL default '0',
cancustomtitle char(3) NOT NULL default '',
PRIMARY KEY (gid)
|
) TYPE=MyISAM;";
| ) TYPE=MyISAM{$charset};";
|
$tables[] = "CREATE TABLE mybb_users (
|
$tables[] = "CREATE TABLE mybb_users (
|
| Zeile 750 | Zeile 751 |
|---|
KEY usergroup (usergroup),
KEY birthday (birthday),
PRIMARY KEY (uid)
|
KEY usergroup (usergroup),
KEY birthday (birthday),
PRIMARY KEY (uid)
|
) TYPE=MyISAM;";
| ) TYPE=MyISAM{$charset};";
|
$tables[] = "CREATE TABLE mybb_usertitles (
|
$tables[] = "CREATE TABLE mybb_usertitles (
|
| Zeile 760 | Zeile 761 |
|---|
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;";
| ) TYPE=MyISAM{$charset};";
|
?>
|
?>
|