| Zeile 82 | Zeile 82 |
|---|
pid int unsigned NOT NULL default '0',
posthash varchar(50) NOT NULL default '',
uid int unsigned NOT NULL default '0',
|
pid int unsigned NOT NULL default '0',
posthash varchar(50) NOT NULL default '',
uid int unsigned NOT NULL default '0',
|
filename varchar(120) NOT NULL default '',
| filename varchar(255) NOT NULL default '',
|
filetype varchar(120) NOT NULL default '',
filesize int(10) unsigned NOT NULL default '0',
|
filetype varchar(120) NOT NULL default '',
filesize int(10) unsigned NOT NULL default '0',
|
attachname varchar(120) NOT NULL default '',
| attachname varchar(255) NOT NULL default '',
|
downloads int unsigned NOT NULL default '0',
dateuploaded int unsigned NOT NULL default '0',
visible tinyint(1) NOT NULL default '0',
| downloads int unsigned NOT NULL default '0',
dateuploaded int unsigned NOT NULL default '0',
visible tinyint(1) NOT NULL default '0',
|
| Zeile 102 | Zeile 102 |
|---|
extension varchar(10) NOT NULL default '',
maxsize int(15) unsigned NOT NULL default '0',
icon varchar(100) NOT NULL default '',
|
extension varchar(10) NOT NULL default '',
maxsize int(15) unsigned NOT NULL default '0',
icon varchar(100) NOT NULL default '',
|
| | enabled tinyint(1) NOT NULL default '1',
forcedownload tinyint(1) NOT NULL default '0',
`groups` TEXT NOT NULL,
forums TEXT NOT NULL,
avatarfile tinyint(1) NOT NULL default '0',
|
PRIMARY KEY (atid)
) ENGINE=MyISAM;";
| PRIMARY KEY (atid)
) ENGINE=MyISAM;";
|
| Zeile 119 | Zeile 124 |
|---|
$tables[] = "CREATE TABLE mybb_badwords (
bid int unsigned NOT NULL auto_increment,
badword varchar(100) NOT NULL default '',
|
$tables[] = "CREATE TABLE mybb_badwords (
bid int unsigned NOT NULL auto_increment,
badword varchar(100) NOT NULL default '',
|
| | regex tinyint(1) NOT NULL default '0',
|
replacement varchar(100) NOT NULL default '',
PRIMARY KEY (bid)
) ENGINE=MyISAM;";
| replacement varchar(100) NOT NULL default '',
PRIMARY KEY (bid)
) ENGINE=MyISAM;";
|
| Zeile 139 | Zeile 145 |
|---|
oldgroup int unsigned NOT NULL default '0',
oldadditionalgroups text NOT NULL,
olddisplaygroup int unsigned NOT NULL default '0',
|
oldgroup int unsigned NOT NULL default '0',
oldadditionalgroups text NOT NULL,
olddisplaygroup int unsigned NOT NULL default '0',
|
admin int unsigned NOT NULL default '0',
| `admin` int unsigned NOT NULL default '0',
|
dateline int unsigned NOT NULL default '0',
bantime varchar(50) NOT NULL default '',
lifted int unsigned NOT NULL default '0',
| dateline int unsigned NOT NULL default '0',
bantime varchar(50) NOT NULL default '',
lifted int unsigned NOT NULL default '0',
|
| Zeile 248 | Zeile 254 |
|---|
candeleteposts tinyint(1) NOT NULL default '0',
candeletethreads tinyint(1) NOT NULL default '0',
caneditattachments tinyint(1) NOT NULL default '0',
|
candeleteposts tinyint(1) NOT NULL default '0',
candeletethreads tinyint(1) NOT NULL default '0',
caneditattachments tinyint(1) NOT NULL default '0',
|
| | canviewdeletionnotice tinyint(1) NOT NULL default '0',
|
modposts tinyint(1) NOT NULL default '0',
modthreads tinyint(1) NOT NULL default '0',
mod_edit_posts tinyint(1) NOT NULL default '0',
| modposts tinyint(1) NOT NULL default '0',
modthreads tinyint(1) NOT NULL default '0',
mod_edit_posts tinyint(1) NOT NULL default '0',
|
| Zeile 476 | Zeile 483 |
|---|
name varchar(200) NOT NULL,
description text NOT NULL,
forums text NOT NULL,
|
name varchar(200) NOT NULL,
description text NOT NULL,
forums text NOT NULL,
|
groups text NOT NULL,
| `groups` text NOT NULL,
|
type char(1) NOT NULL default '',
postoptions text NOT NULL,
threadoptions text NOT NULL,
| type char(1) NOT NULL default '',
postoptions text NOT NULL,
threadoptions text NOT NULL,
|
| Zeile 492 | Zeile 499 |
|---|
active tinyint(1) NOT NULL default '0',
parseorder smallint unsigned NOT NULL default '0',
PRIMARY KEY(cid)
|
active tinyint(1) NOT NULL default '0',
parseorder smallint unsigned NOT NULL default '0',
PRIMARY KEY(cid)
|
) ENGINE=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 510 | Zeile 517 |
|---|
maxoptions smallint unsigned NOT NULL default '0',
KEY tid (tid),
PRIMARY KEY (pid)
|
maxoptions smallint unsigned NOT NULL default '0',
KEY tid (tid),
PRIMARY KEY (pid)
|
) ENGINE=MyISAM;";
| ) ENGINE=MyISAM;";
|
$tables[] = "CREATE TABLE mybb_pollvotes (
vid int unsigned NOT NULL auto_increment,
pid int unsigned NOT NULL default '0',
uid int unsigned NOT NULL default '0',
voteoption smallint unsigned NOT NULL default '0',
dateline int unsigned NOT NULL default '0',
|
$tables[] = "CREATE TABLE mybb_pollvotes (
vid int unsigned NOT NULL auto_increment,
pid int unsigned NOT NULL default '0',
uid int unsigned NOT NULL default '0',
voteoption smallint unsigned NOT NULL default '0',
dateline int unsigned NOT NULL default '0',
|
| | ipaddress varbinary(16) NOT NULL default '',
|
KEY pid (pid, uid),
PRIMARY KEY (vid)
) ENGINE=MyISAM;";
| KEY pid (pid, uid),
PRIMARY KEY (vid)
) ENGINE=MyISAM;";
|
| Zeile 530 | Zeile 538 |
|---|
subject varchar(120) NOT NULL default '',
icon smallint unsigned NOT NULL default '0',
uid int unsigned NOT NULL default '0',
|
subject varchar(120) NOT NULL default '',
icon smallint unsigned NOT NULL default '0',
uid int unsigned NOT NULL default '0',
|
username varchar(80) NOT NULL default '',
| username varchar(120) NOT NULL default '',
|
dateline int unsigned NOT NULL default '0',
message text NOT NULL,
ipaddress varbinary(16) NOT NULL default '',
| dateline int unsigned NOT NULL default '0',
message text NOT NULL,
ipaddress varbinary(16) NOT NULL default '',
|
| Zeile 660 | Zeile 668 |
|---|
id3 int unsigned NOT NULL default '0',
uid int unsigned NOT NULL default '0',
reportstatus tinyint(1) NOT NULL default '0',
|
id3 int unsigned NOT NULL default '0',
uid int unsigned NOT NULL default '0',
reportstatus tinyint(1) NOT NULL default '0',
|
| | reasonid smallint unsigned NOT NULL default '0',
|
reason varchar(250) NOT NULL default '',
type varchar(50) NOT NULL default '',
reports int unsigned NOT NULL default '0',
| reason varchar(250) NOT NULL default '',
type varchar(50) NOT NULL default '',
reports int unsigned NOT NULL default '0',
|
| Zeile 668 | Zeile 677 |
|---|
lastreport int unsigned NOT NULL default '0',
KEY reportstatus (reportstatus),
KEY lastreport (lastreport),
|
lastreport int unsigned NOT NULL default '0',
KEY reportstatus (reportstatus),
KEY lastreport (lastreport),
|
| | PRIMARY KEY (rid)
) ENGINE=MyISAM;";
$tables[] = "CREATE TABLE mybb_reportreasons (
rid int unsigned NOT NULL auto_increment,
title varchar(250) NOT NULL default '',
appliesto varchar(250) NOT NULL default '',
extra tinyint(1) NOT NULL default '0',
disporder smallint unsigned NOT NULL default '0',
|
PRIMARY KEY (rid)
) ENGINE=MyISAM;";
| PRIMARY KEY (rid)
) ENGINE=MyISAM;";
|
| Zeile 857 | Zeile 875 |
|---|
prefix varchar(120) NOT NULL default '',
displaystyle varchar(200) NOT NULL default '',
forums text NOT NULL,
|
prefix varchar(120) NOT NULL default '',
displaystyle varchar(200) NOT NULL default '',
forums text NOT NULL,
|
groups text NOT NULL,
| `groups` text NOT NULL,
|
PRIMARY KEY (pid)
) ENGINE=MyISAM;";
| PRIMARY KEY (pid)
) ENGINE=MyISAM;";
|
| Zeile 884 | Zeile 902 |
|---|
icon smallint unsigned NOT NULL default '0',
poll int unsigned NOT NULL default '0',
uid int unsigned NOT NULL default '0',
|
icon smallint unsigned NOT NULL default '0',
poll int unsigned NOT NULL default '0',
uid int unsigned NOT NULL default '0',
|
username varchar(80) NOT NULL default '',
| username varchar(120) NOT NULL default '',
|
dateline int unsigned NOT NULL default '0',
firstpost int unsigned NOT NULL default '0',
lastpost int unsigned NOT NULL default '0',
| dateline int unsigned NOT NULL default '0',
firstpost int unsigned NOT NULL default '0',
lastpost int unsigned NOT NULL default '0',
|
| Zeile 966 | Zeile 984 |
|---|
candeleteposts tinyint(1) NOT NULL default '0',
candeletethreads tinyint(1) NOT NULL default '0',
caneditattachments tinyint(1) NOT NULL default '0',
|
candeleteposts tinyint(1) NOT NULL default '0',
candeletethreads tinyint(1) NOT NULL default '0',
caneditattachments tinyint(1) NOT NULL default '0',
|
| | canviewdeletionnotice tinyint(1) NOT NULL default '0',
|
canpostpolls tinyint(1) NOT NULL default '0',
canvotepolls tinyint(1) NOT NULL default '0',
canundovotes tinyint(1) NOT NULL default '0',
| canpostpolls tinyint(1) NOT NULL default '0',
canvotepolls tinyint(1) NOT NULL default '0',
canundovotes tinyint(1) NOT NULL default '0',
|
| Zeile 995 | Zeile 1014 |
|---|
canratemembers tinyint(1) NOT NULL default '0',
canchangename tinyint(1) NOT NULL default '0',
canbereported tinyint(1) NOT NULL default '0',
|
canratemembers tinyint(1) NOT NULL default '0',
canchangename tinyint(1) NOT NULL default '0',
canbereported tinyint(1) NOT NULL default '0',
|
| | canbeinvisible tinyint(1) NOT NULL default '1',
|
canchangewebsite tinyint(1) NOT NULL default '1',
showforumteam tinyint(1) NOT NULL default '0',
usereputationsystem tinyint(1) NOT NULL default '0',
| canchangewebsite tinyint(1) NOT NULL default '1',
showforumteam tinyint(1) NOT NULL default '0',
usereputationsystem tinyint(1) NOT NULL default '0',
|
| Zeile 1051 | Zeile 1071 |
|---|
lastvisit int unsigned NOT NULL default '0',
lastpost int unsigned NOT NULL default '0',
website varchar(200) NOT NULL default '',
|
lastvisit int unsigned NOT NULL default '0',
lastpost int unsigned NOT NULL default '0',
website varchar(200) NOT NULL default '',
|
icq varchar(10) NOT NULL default '',
aim varchar(50) NOT NULL default '',
yahoo varchar(50) NOT NULL default '',
| |
skype varchar(75) NOT NULL default '',
google varchar(75) NOT NULL default '',
birthday varchar(15) NOT NULL default '',
| skype varchar(75) NOT NULL default '',
google varchar(75) NOT NULL default '',
birthday varchar(15) NOT NULL default '',
|
| Zeile 1112 | Zeile 1129 |
|---|
suspendsigtime int unsigned NOT NULL default '0',
coppauser tinyint(1) NOT NULL default '0',
classicpostbit tinyint(1) NOT NULL default '0',
|
suspendsigtime int unsigned NOT NULL default '0',
coppauser tinyint(1) NOT NULL default '0',
classicpostbit tinyint(1) NOT NULL default '0',
|
loginattempts smallint(2) unsigned NOT NULL default '1',
| loginattempts smallint(2) unsigned NOT NULL default '0',
loginlockoutexpiry int unsigned NOT NULL default '0',
|
usernotes text NOT NULL,
sourceeditor tinyint(1) NOT NULL default '0',
UNIQUE KEY username (username),
| usernotes text NOT NULL,
sourceeditor tinyint(1) NOT NULL default '0',
UNIQUE KEY username (username),
|