| 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 224 | Zeile 226 |
|---|
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 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 475 | Zeile 479 |
|---|
tid int NOT NULL default '0',
replyto int NOT NULL default '0',
fid smallint NOT NULL default '0',
|
tid int NOT NULL default '0',
replyto int NOT NULL default '0',
fid smallint NOT NULL default '0',
|
subject varchar(120) NOT NULL default '',
icon smallint NOT NULL default '0',
uid int NOT NULL default '0',
username varchar(80) NOT NULL default '',
| subject varchar(120) NOT NULL default '',
icon smallint NOT NULL default '0',
uid int NOT NULL default '0',
username varchar(120) NOT NULL default '',
|
dateline int NOT NULL default '0',
message TEXT NOT NULL,
ipaddress blob(16) NOT NULL default '',
|
dateline int NOT NULL default '0',
message TEXT NOT NULL,
ipaddress blob(16) NOT NULL default '',
|
includesig tinyint(1) NOT NULL default '0',
smilieoff tinyint(1) NOT NULL default '0',
| includesig tinyint(1) NOT NULL default '0',
smilieoff tinyint(1) NOT NULL default '0',
|
edituid int NOT NULL default '0',
edittime int(10) NOT NULL default '0',
editreason varchar(150) NOT NULL default '',
| edituid int NOT NULL default '0',
edittime int(10) NOT NULL default '0',
editreason varchar(150) NOT NULL default '',
|
| Zeile 508 | Zeile 512 |
|---|
smilieoff tinyint(1) NOT NULL default '0',
receipt tinyint(1) NOT NULL default '0',
readtime int NOT NULL default '0',
|
smilieoff tinyint(1) NOT NULL default '0',
receipt tinyint(1) NOT NULL default '0',
readtime int NOT NULL default '0',
|
ipaddress blob(16) NOT NULL default ''
| ipaddress blob(16) NOT NULL default ''
|
);";
$tables[] = "CREATE TABLE mybb_profilefields (
| );";
$tables[] = "CREATE TABLE mybb_profilefields (
|
| Zeile 630 | Zeile 634 |
|---|
resulttype varchar(10) NOT NULL default '',
querycache TEXT NOT NULL,
keywords TEXT NOT NULL
|
resulttype varchar(10) NOT NULL default '',
querycache TEXT NOT NULL,
keywords TEXT NOT NULL
|
);";
| );";
|
$tables[] = "CREATE TABLE mybb_sessions (
sid varchar(32) NOT NULL default '',
uid int NOT NULL default '0',
| $tables[] = "CREATE TABLE mybb_sessions (
sid varchar(32) NOT NULL default '',
uid int NOT NULL default '0',
|
| Zeile 795 | Zeile 799 |
|---|
icon smallint NOT NULL default '0',
poll int NOT NULL default '0',
uid int NOT NULL default '0',
|
icon smallint NOT NULL default '0',
poll int NOT NULL default '0',
uid int NOT NULL default '0',
|
username varchar(80) NOT NULL default '',
| username varchar(120) NOT NULL default '',
|
dateline int NOT NULL default '0',
firstpost int NOT NULL default '0',
lastpost int NOT NULL default '0',
| dateline int NOT NULL default '0',
firstpost int NOT NULL default '0',
lastpost int NOT NULL default '0',
|
| Zeile 865 | Zeile 869 |
|---|
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 894 | 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 949 | Zeile 955 |
|---|
lastvisit int NOT NULL default '0',
lastpost int NOT NULL default '0',
website varchar(200) NOT NULL default '',
|
lastvisit int NOT NULL default '0',
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 1013 |
|---|
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'
);";
|