| Zeile 6 | Zeile 6 |
|---|
* Website: http://www.mybboard.com
* License: http://www.mybboard.com/eula.html
*
|
* Website: http://www.mybboard.com
* License: http://www.mybboard.com/eula.html
*
|
* $Id: mysql_db_tables.php 2077 2006-08-14 07:27:40Z chris $
| * $Id: mysql_db_tables.php 2269 2006-09-26 23:59:14Z Tikitiki $
|
*/
$tables[] = "CREATE TABLE mybb_adminlog (
| */
$tables[] = "CREATE TABLE mybb_adminlog (
|
| Zeile 15 | Zeile 15 |
|---|
scriptname varchar(50) NOT NULL default '',
action varchar(50) NOT NULL default '',
querystring varchar(150) NOT NULL default '',
|
scriptname varchar(50) NOT NULL default '',
action varchar(50) NOT NULL default '',
querystring varchar(150) NOT NULL default '',
|
ipaddress varchar(50) NOT NULL default ''
| ipaddress varchar(50) NOT NULL default '',
KEY scriptname (scriptname, action)
|
) TYPE=MyISAM;";
| ) TYPE=MyISAM;";
|
| Zeile 67 | Zeile 68 |
|---|
allowhtml char(3) NOT NULL default '',
allowmycode char(3) NOT NULL default '',
allowsmilies char(3) NOT NULL default '',
|
allowhtml char(3) NOT NULL default '',
allowmycode char(3) NOT NULL default '',
allowsmilies char(3) NOT NULL default '',
|
| | KEY fid (fid),
|
PRIMARY KEY (aid)
) TYPE=MyISAM;";
| PRIMARY KEY (aid)
) TYPE=MyISAM;";
|
| Zeile 82 | Zeile 84 |
|---|
downloads int unsigned NOT NULL default '0',
visible int(1) NOT NULL default '0',
thumbnail varchar(120) NOT NULL default '',
|
downloads int unsigned NOT NULL default '0',
visible int(1) NOT NULL default '0',
thumbnail varchar(120) NOT NULL default '',
|
| | KEY posthash (posthash),
KEY pid (pid, visible),
KEY uid (uid),
|
PRIMARY KEY (aid)
) TYPE=MyISAM;";
| PRIMARY KEY (aid)
) TYPE=MyISAM;";
|
| Zeile 122 | Zeile 127 |
|---|
dateline bigint(30) NOT NULL default '0',
bantime varchar(50) NOT NULL default '',
lifted bigint(30) NOT NULL default '0',
|
dateline bigint(30) NOT NULL default '0',
bantime varchar(50) NOT NULL default '',
lifted bigint(30) NOT NULL default '0',
|
reason varchar(255) NOT NULL default ''
| reason varchar(255) NOT NULL default '',
KEY uid (uid),
KEY dateline (dateline)
|
) TYPE=MyISAM;";
$tables[] = "CREATE TABLE mybb_captcha (
imagehash varchar(32) NOT NULL default '',
imagestring varchar(8) NOT NULL default '',
|
) TYPE=MyISAM;";
$tables[] = "CREATE TABLE mybb_captcha (
imagehash varchar(32) NOT NULL default '',
imagestring varchar(8) NOT NULL default '',
|
dateline bigint(30) NOT NULL default '0'
| dateline bigint(30) NOT NULL default '0',
KEY imagehash (imagehash),
KEY dateline (dateline)
|
) TYPE=MyISAM;";
$tables[] = "CREATE TABLE mybb_datacache (
| ) TYPE=MyISAM;";
$tables[] = "CREATE TABLE mybb_datacache (
|
| Zeile 144 | Zeile 153 |
|---|
date varchar(50) NOT NULL default '',
description text NOT NULL default '',
private char(3) NOT NULL default '',
|
date varchar(50) NOT NULL default '',
description text NOT NULL default '',
private char(3) NOT NULL default '',
|
| | KEY private (private),
|
PRIMARY KEY (eid)
) TYPE=MyISAM;";
| PRIMARY KEY (eid)
) TYPE=MyISAM;";
|
| Zeile 152 | Zeile 162 |
|---|
uid int unsigned NOT NULL default '0',
tid int unsigned NOT NULL default '0',
type char(1) NOT NULL default '',
|
uid int unsigned NOT NULL default '0',
tid int unsigned NOT NULL default '0',
type char(1) NOT NULL default '',
|
| | KEY uid (uid),
KEY tid (tid,type),
|
PRIMARY KEY (fid)
) TYPE=MyISAM;";
| PRIMARY KEY (fid)
) TYPE=MyISAM;";
|
| Zeile 295 | Zeile 307 |
|---|
pid int unsigned NOT NULL default '0',
action text NOT NULL default '',
data text NOT NULL default '',
|
pid int unsigned NOT NULL default '0',
action text NOT NULL default '',
data text NOT NULL default '',
|
ipaddress varchar(50) NOT NULL default ''
| ipaddress varchar(50) NOT NULL default '',
KEY tid (tid)
|
) TYPE=MyISAM;";
$tables[] = "CREATE TABLE mybb_moderators (
| ) TYPE=MyISAM;";
$tables[] = "CREATE TABLE mybb_moderators (
|
| Zeile 308 | Zeile 321 |
|---|
canopenclosethreads char(3) NOT NULL default '',
canmanagethreads char(3) NOT NULL default '',
canmovetononmodforum char(3) NOT NULL default '',
|
canopenclosethreads char(3) NOT NULL default '',
canmanagethreads char(3) NOT NULL default '',
canmovetononmodforum char(3) NOT NULL default '',
|
| | KEY uid (uid, fid),
|
PRIMARY KEY (mid)
) TYPE=MyISAM;";
| PRIMARY KEY (mid)
) TYPE=MyISAM;";
|
| Zeile 354 | Zeile 368 |
|---|
uid int unsigned NOT NULL default '0',
voteoption smallint unsigned NOT NULL default '0',
dateline bigint(30) NOT NULL default '0',
|
uid int unsigned NOT NULL default '0',
voteoption smallint unsigned NOT NULL default '0',
dateline bigint(30) NOT NULL default '0',
|
| | KEY pid (pid, uid),
|
PRIMARY KEY (vid)
) TYPE=MyISAM;";
| PRIMARY KEY (vid)
) TYPE=MyISAM;";
|
| Zeile 375 | Zeile 390 |
|---|
edittime int(10) NOT NULL default '0',
visible int(1) NOT NULL default '0',
posthash varchar(32) NOT NULL default '',
|
edittime int(10) NOT NULL default '0',
visible int(1) NOT NULL default '0',
posthash varchar(32) NOT NULL default '',
|
| | KEY tid (tid, uid),
KEY uid (uid),
KEY dateline (dateline),
|
PRIMARY KEY (pid)
) TYPE=MyISAM;";
| PRIMARY KEY (pid)
) TYPE=MyISAM;";
|
| Zeile 394 | Zeile 412 |
|---|
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)
) TYPE=MyISAM;";
| PRIMARY KEY (pmid)
) TYPE=MyISAM;";
|
| Zeile 422 | Zeile 442 |
|---|
reportstatus int(1) NOT NULL default '0',
reason varchar(250) NOT NULL default '',
dateline bigint(30) NOT NULL default '0',
|
reportstatus int(1) NOT NULL default '0',
reason varchar(250) NOT NULL default '',
dateline bigint(30) NOT NULL default '0',
|
| | KEY fid (fid),
KEY dateline (dateline),
|
PRIMARY KEY (rid)
) TYPE=MyISAM;";
| PRIMARY KEY (rid)
) TYPE=MyISAM;";
|
| Zeile 432 | Zeile 454 |
|---|
reputation bigint(30) NOT NULL default '0',
dateline bigint(30) NOT NULL default '0',
comments text NOT NULL,
|
reputation bigint(30) NOT NULL default '0',
dateline bigint(30) NOT NULL default '0',
comments text NOT NULL,
|
| | KEY uid (uid),
KEY dateline (dateline),
|
PRIMARY KEY(rid)
) TYPE=MyISAM;";
| PRIMARY KEY(rid)
) TYPE=MyISAM;";
|
| Zeile 463 | Zeile 487 |
|---|
failedlogin bigint(30) NOT NULL default '0',
PRIMARY KEY(sid),
KEY location1 (location1),
|
failedlogin bigint(30) NOT NULL default '0',
PRIMARY KEY(sid),
KEY location1 (location1),
|
KEY location2 (location2)
| KEY location2 (location2),
KEY time (time),
KEY uid (uid)
|
) TYPE=MyISAM;";
$tables[] = "CREATE TABLE mybb_settinggroups (
| ) TYPE=MyISAM;";
$tables[] = "CREATE TABLE mybb_settinggroups (
|
| Zeile 545 | Zeile 571 |
|---|
uid int unsigned NOT NULL default '0',
rating smallint unsigned NOT NULL default '0',
ipaddress varchar(30) NOT NULL default '',
|
uid int unsigned NOT NULL default '0',
rating smallint unsigned NOT NULL default '0',
ipaddress varchar(30) NOT NULL default '',
|
| | KEY tid (tid, uid),
|
PRIMARY KEY (rid)
) TYPE=MyISAM;";
| PRIMARY KEY (rid)
) TYPE=MyISAM;";
|
| Zeile 573 | Zeile 600 |
|---|
unapprovedposts int(10) unsigned NOT NULL default '0',
attachmentcount int(10) unsigned NOT NULL default '0',
deletetime int(10) unsigned NOT NULL default '0',
|
unapprovedposts int(10) unsigned NOT NULL default '0',
attachmentcount int(10) unsigned NOT NULL default '0',
deletetime int(10) unsigned NOT NULL default '0',
|
| | KEY fid (fid, visible, sticky),
KEY dateline (dateline),
KEY lastpost (lastpost, fid),
KEY firstpost (firstpost),
KEY uid (uid),
|
PRIMARY KEY (tid)
) TYPE=MyISAM;";
| PRIMARY KEY (tid)
) TYPE=MyISAM;";
|
| Zeile 580 | Zeile 612 |
|---|
tid int unsigned NOT NULL default '0',
uid int unsigned NOT NULL default '0',
dateline int(10) NOT NULL default '0',
|
tid int unsigned NOT NULL default '0',
uid int unsigned NOT NULL default '0',
dateline int(10) NOT NULL default '0',
|
| | KEY dateline (dateline),
|
UNIQUE KEY tiduid (tid,uid)
) TYPE=MyISAM;";
| UNIQUE KEY tiduid (tid,uid)
) TYPE=MyISAM;";
|
| Zeile 713 | Zeile 746 |
|---|
totalpms int(10) NOT NULL default '0',
newpms int(10) NOT NULL default '0',
unreadpms int(10) NOT NULL default '0',
|
totalpms int(10) NOT NULL default '0',
newpms int(10) NOT NULL default '0',
unreadpms int(10) NOT NULL default '0',
|
| | KEY username (username),
KEY usergroup (usergroup),
KEY birthday (birthday),
|
PRIMARY KEY (uid)
) TYPE=MyISAM;";
| PRIMARY KEY (uid)
) TYPE=MyISAM;";
|