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 252 | 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 480 | 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 522 | 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 871 | 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 980 | 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 1009 | 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 1066 | 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 1126 | 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),
|