Zeile 76 | Zeile 76 |
---|
pid int(10) NOT NULL default '0', posthash varchar(50) NOT NULL default '', uid int NOT NULL default '0',
|
pid int(10) NOT NULL default '0', posthash varchar(50) NOT NULL default '', uid int 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) NOT NULL default '0',
|
filetype varchar(120) NOT NULL default '', filesize int(10) NOT NULL default '0',
|
attachname varchar(120) NOT NULL default '',
| attachname varchar(255) NOT NULL default '',
|
downloads int NOT NULL default '0', dateuploaded int NOT NULL default '0', visible tinyint(1) NOT NULL default '0',
| downloads int NOT NULL default '0', dateuploaded int NOT NULL default '0', visible tinyint(1) NOT NULL default '0',
|
Zeile 112 | Zeile 112 |
---|
$tables[] = "CREATE TABLE mybb_badwords ( bid INTEGER PRIMARY KEY, badword varchar(100) NOT NULL default '',
|
$tables[] = "CREATE TABLE mybb_badwords ( bid INTEGER PRIMARY KEY, badword varchar(100) NOT NULL default '',
|
| regex tinyint(1) NOT NULL default '0',
|
replacement varchar(100) NOT NULL default '' );";
| replacement varchar(100) NOT NULL default '' );";
|
Zeile 224 | Zeile 225 |
---|
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 467 | Zeile 469 |
---|
pid int NOT NULL default '0', uid int NOT NULL default '0', voteoption smallint NOT NULL default '0',
|
pid int NOT NULL default '0', uid int NOT NULL default '0', voteoption smallint NOT NULL default '0',
|
dateline int NOT NULL default '0'
| dateline int NOT NULL default '0', ipaddress blob(16) NOT NULL default ''
|
);";
$tables[] = "CREATE TABLE mybb_posts (
| );";
$tables[] = "CREATE TABLE mybb_posts (
|
Zeile 865 | Zeile 868 |
---|
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 950 | Zeile 954 |
---|
lastpost int NOT NULL default '0', website varchar(200) NOT NULL default '', icq varchar(10) NOT NULL default '',
|
lastpost int 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 1010 | Zeile 1012 |
---|
suspendsigtime int NOT NULL default '0', coppauser tinyint(1) NOT NULL default '0', classicpostbit tinyint(1) NOT NULL default '0',
|
suspendsigtime int NOT NULL default '0', coppauser tinyint(1) NOT NULL default '0', classicpostbit tinyint(1) NOT NULL default '0',
|
loginattempts smallint(2) NOT NULL default '1',
| loginattempts smallint(2) NOT NULL default '0', loginlockoutexpiry int NOT NULL default '0',
|
usernotes TEXT NOT NULL, sourceeditor tinyint(1) NOT NULL default '0' );";
| usernotes TEXT NOT NULL, sourceeditor tinyint(1) NOT NULL default '0' );";
|