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 94 | Zeile 94 |
---|
maxsize int(15) NOT NULL default '0', icon varchar(100) NOT NULL default '', enabled tinyint(1) NOT NULL default '1',
|
maxsize int(15) 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'
| groups TEXT NOT NULL, forums TEXT NOT NULL, avatarfile tinyint(1) NOT NULL default '0'
|
Zeile 112 | Zeile 113 |
---|
$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 468 | Zeile 470 |
---|
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 896 | Zeile 899 |
---|
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 952 | Zeile 956 |
---|
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 1012 | Zeile 1014 |
---|
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' );";
|