| 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 92 | Zeile 92 |
|---|
mimetype varchar(120) NOT NULL default '',
extension varchar(10) NOT NULL default '',
maxsize int(15) NOT NULL default '0',
|
mimetype varchar(120) NOT NULL default '',
extension varchar(10) NOT NULL default '',
maxsize int(15) NOT NULL default '0',
|
icon varchar(100) NOT NULL default ''
| 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'
|
);";
$tables[] = "CREATE TABLE mybb_awaitingactivation (
| );";
$tables[] = "CREATE TABLE mybb_awaitingactivation (
|
| Zeile 108 | 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 155 | Zeile 161 |
|---|
);";
$tables[] = "CREATE TABLE mybb_calendarpermissions (
|
);";
$tables[] = "CREATE TABLE mybb_calendarpermissions (
|
cid int NOT NULL default '0',
| cid int NOT NULL default '0',
|
gid int NOT NULL default '0',
canviewcalendar tinyint(1) NOT NULL default '0',
canaddevents tinyint(1) NOT NULL default '0',
canbypasseventmod tinyint(1) NOT NULL default '0',
canmoderateevents tinyint(1) NOT NULL default '0'
|
gid int NOT NULL default '0',
canviewcalendar tinyint(1) NOT NULL default '0',
canaddevents tinyint(1) NOT NULL default '0',
canbypasseventmod tinyint(1) NOT NULL default '0',
canmoderateevents tinyint(1) NOT NULL default '0'
|
);";
| );";
|
$tables[] = "CREATE TABLE mybb_captcha (
imagehash varchar(32) NOT NULL default '',
imagestring varchar(8) NOT NULL default '',
| $tables[] = "CREATE TABLE mybb_captcha (
imagehash varchar(32) NOT NULL default '',
imagestring varchar(8) NOT NULL default '',
|
| Zeile 184 | Zeile 190 |
|---|
tids text NOT NULL,
dateline int NOT NULL default '0',
inputs text NOT NULL
|
tids text NOT NULL,
dateline int NOT NULL default '0',
inputs text NOT NULL
|
);";
| );";
|
$tables[] = "CREATE TABLE mybb_events (
eid INTEGER PRIMARY KEY,
cid int NOT NULL default '0',
| $tables[] = "CREATE TABLE mybb_events (
eid INTEGER PRIMARY KEY,
cid int NOT NULL default '0',
|
| Zeile 216 | Zeile 222 |
|---|
canonlyreplyownthreads tinyint(1) NOT NULL default '0',
canpostattachments tinyint(1) NOT NULL default '0',
canratethreads tinyint(1) NOT NULL default '0',
|
canonlyreplyownthreads tinyint(1) NOT NULL default '0',
canpostattachments tinyint(1) NOT NULL default '0',
canratethreads tinyint(1) NOT NULL default '0',
|
caneditposts tinyint(1) NOT NULL default '0',
candeleteposts tinyint(1) NOT NULL default '0',
candeletethreads tinyint(1) NOT NULL default '0',
| caneditposts 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',
|
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 281 | Zeile 288 |
|---|
$tables[] = "CREATE TABLE mybb_forumsubscriptions (
fsid INTEGER PRIMARY KEY,
|
$tables[] = "CREATE TABLE mybb_forumsubscriptions (
fsid INTEGER PRIMARY KEY,
|
fid smallint NOT NULL default '0',
| fid smallint NOT NULL default '0',
|
uid int NOT NULL default '0'
);";
| uid int NOT NULL default '0'
);";
|
| Zeile 463 | 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 589 | Zeile 597 |
|---|
id3 int NOT NULL default '0',
uid int NOT NULL default '0',
reportstatus tinyint(1) NOT NULL default '0',
|
id3 int NOT NULL default '0',
uid int NOT NULL default '0',
reportstatus tinyint(1) NOT NULL default '0',
|
| | reasonid smallint NOT NULL default '0',
|
reason varchar(250) NOT NULL default '',
type varchar(50) NOT NULL default '',
reports int NOT NULL default '0',
reporters text NOT NULL,
dateline int NOT NULL default '0',
lastreport int NOT NULL default '0'
|
reason varchar(250) NOT NULL default '',
type varchar(50) NOT NULL default '',
reports int NOT NULL default '0',
reporters text NOT NULL,
dateline int NOT NULL default '0',
lastreport int NOT NULL default '0'
|
| | );";
$tables[] = "CREATE TABLE mybb_reportreasons (
rid INTEGER PRIMARY KEY,
title varchar(250) NOT NULL default '',
appliesto varchar(250) NOT NULL default '',
extra tinyint(1) NOT NULL default '0',
disporder smallint NOT NULL default '0'
|
);";
$tables[] = "CREATE TABLE mybb_reputation (
| );";
$tables[] = "CREATE TABLE mybb_reputation (
|
| Zeile 852 | 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 881 | 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 937 | 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 997 | 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'
);";
|