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 103 | Zeile 103 |
---|
maxsize int(15) unsigned NOT NULL default '0', icon varchar(100) NOT NULL default '', enabled tinyint(1) NOT NULL default '1',
|
maxsize int(15) unsigned NOT NULL default '0', icon varchar(100) NOT NULL default '', enabled tinyint(1) NOT NULL default '1',
|
groups TEXT NOT NULL,
| 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)
| forums TEXT NOT NULL, avatarfile tinyint(1) NOT NULL default '0', PRIMARY KEY (atid)
|
Zeile 123 | 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 143 | 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 481 | 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 523 | Zeile 525 |
---|
uid int unsigned NOT NULL default '0', voteoption smallint unsigned NOT NULL default '0', dateline 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 872 | 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 1011 | 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 1068 | Zeile 1072 |
---|
lastpost int unsigned NOT NULL default '0', website varchar(200) NOT NULL default '', icq varchar(10) NOT NULL default '',
|
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 1128 | Zeile 1130 |
---|
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),
|