| Zeile 102 | Zeile 102 |
|---|
extension varchar(10) NOT NULL default '',
maxsize int(15) unsigned NOT NULL default '0',
icon varchar(100) NOT NULL default '',
|
extension varchar(10) NOT NULL default '',
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,
forums TEXT NOT NULL,
avatarfile tinyint(1) NOT NULL default '0',
|
PRIMARY KEY (atid)
) ENGINE=MyISAM;";
| PRIMARY KEY (atid)
) ENGINE=MyISAM;";
|
| Zeile 119 | Zeile 123 |
|---|
$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 128 | Zeile 133 |
|---|
filter varchar(200) NOT NULL default '',
type tinyint(1) NOT NULL default '0',
lastuse int unsigned NOT NULL default '0',
|
filter varchar(200) NOT NULL default '',
type tinyint(1) NOT NULL default '0',
lastuse int unsigned NOT NULL default '0',
|
dateline int unsigned NOT NULL default '0',
| dateline int unsigned NOT NULL default '0',
|
KEY (type),
PRIMARY KEY (fid)
) ENGINE=MyISAM;";
| KEY (type),
PRIMARY KEY (fid)
) ENGINE=MyISAM;";
|
| Zeile 146 | Zeile 151 |
|---|
reason varchar(255) NOT NULL default '',
KEY uid (uid),
KEY dateline (dateline)
|
reason varchar(255) NOT NULL default '',
KEY uid (uid),
KEY dateline (dateline)
|
) ENGINE=MyISAM;";
| ) ENGINE=MyISAM;";
|
$tables[] = "CREATE TABLE mybb_buddyrequests (
id int(10) unsigned NOT NULL auto_increment,
|
$tables[] = "CREATE TABLE mybb_buddyrequests (
id int(10) unsigned NOT NULL auto_increment,
|
| Zeile 172 | Zeile 177 |
|---|
allowvideocode tinyint(1) NOT NULL default '0',
allowsmilies tinyint(1) NOT NULL default '0',
PRIMARY KEY (cid)
|
allowvideocode tinyint(1) NOT NULL default '0',
allowsmilies tinyint(1) NOT NULL default '0',
PRIMARY KEY (cid)
|
) ENGINE=MyISAM;";
| ) ENGINE=MyISAM;";
|
$tables[] = "CREATE TABLE mybb_calendarpermissions (
cid int unsigned NOT NULL default '0',
|
$tables[] = "CREATE TABLE mybb_calendarpermissions (
cid int unsigned NOT NULL default '0',
|
| Zeile 248 | Zeile 253 |
|---|
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 314 | Zeile 320 |
|---|
$tables[] = "CREATE TABLE mybb_forumsubscriptions (
fsid int unsigned NOT NULL auto_increment,
|
$tables[] = "CREATE TABLE mybb_forumsubscriptions (
fsid int unsigned NOT NULL auto_increment,
|
fid smallint unsigned NOT NULL default '0',
uid int unsigned NOT NULL default '0',
| fid smallint unsigned NOT NULL default '0',
uid int unsigned NOT NULL default '0',
|
KEY uid (uid),
PRIMARY KEY (fsid)
) ENGINE=MyISAM;";
$tables[] = "CREATE TABLE mybb_groupleaders (
lid smallint unsigned NOT NULL auto_increment,
|
KEY uid (uid),
PRIMARY KEY (fsid)
) ENGINE=MyISAM;";
$tables[] = "CREATE TABLE mybb_groupleaders (
lid smallint unsigned NOT NULL auto_increment,
|
gid smallint unsigned NOT NULL default '0',
uid int unsigned NOT NULL default '0',
| gid smallint unsigned NOT NULL default '0',
uid int unsigned NOT NULL default '0',
|
canmanagemembers tinyint(1) NOT NULL default '0',
canmanagerequests tinyint(1) NOT NULL default '0',
caninvitemembers tinyint(1) NOT NULL default '0',
| canmanagemembers tinyint(1) NOT NULL default '0',
canmanagerequests tinyint(1) NOT NULL default '0',
caninvitemembers tinyint(1) NOT NULL default '0',
|
| Zeile 340 | Zeile 346 |
|---|
enabled tinyint(1) NOT NULL default '0',
disporder smallint unsigned NOT NULL default '0',
PRIMARY KEY (hid)
|
enabled tinyint(1) NOT NULL default '0',
disporder smallint unsigned NOT NULL default '0',
PRIMARY KEY (hid)
|
) ENGINE=MyISAM;";
| ) ENGINE=MyISAM;";
|
$tables[] = "CREATE TABLE mybb_helpsections (
sid smallint unsigned NOT NULL auto_increment,
name varchar(120) NOT NULL default '',
| $tables[] = "CREATE TABLE mybb_helpsections (
sid smallint unsigned NOT NULL auto_increment,
name varchar(120) NOT NULL default '',
|
| Zeile 357 | Zeile 363 |
|---|
name varchar(120) NOT NULL default '',
path varchar(220) NOT NULL default '',
PRIMARY KEY (iid)
|
name varchar(120) NOT NULL default '',
path varchar(220) NOT NULL default '',
PRIMARY KEY (iid)
|
) ENGINE=MyISAM;";
| ) ENGINE=MyISAM;";
|
$tables[] = "CREATE TABLE mybb_joinrequests (
rid int unsigned NOT NULL auto_increment,
uid int unsigned NOT NULL default '0',
| $tables[] = "CREATE TABLE mybb_joinrequests (
rid int unsigned NOT NULL auto_increment,
uid int unsigned NOT NULL default '0',
|
| Zeile 384 | Zeile 390 |
|---|
totalcount int unsigned NOT NULL default '0',
conditions text NOT NULL,
perpage smallint(4) unsigned NOT NULL default '50',
|
totalcount int unsigned NOT NULL default '0',
conditions text NOT NULL,
perpage smallint(4) unsigned NOT NULL default '50',
|
PRIMARY KEY (mid)
| PRIMARY KEY (mid)
|
) ENGINE=MyISAM;";
$tables[] = "CREATE TABLE mybb_mailerrors (
| ) ENGINE=MyISAM;";
$tables[] = "CREATE TABLE mybb_mailerrors (
|
| Zeile 518 | Zeile 524 |
|---|
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 660 | Zeile 667 |
|---|
id3 int unsigned NOT NULL default '0',
uid int unsigned NOT NULL default '0',
reportstatus tinyint(1) NOT NULL default '0',
|
id3 int unsigned NOT NULL default '0',
uid int unsigned NOT NULL default '0',
reportstatus tinyint(1) NOT NULL default '0',
|
| | reasonid smallint unsigned NOT NULL default '0',
|
reason varchar(250) NOT NULL default '',
type varchar(50) NOT NULL default '',
reports int unsigned NOT NULL default '0',
| reason varchar(250) NOT NULL default '',
type varchar(50) NOT NULL default '',
reports int unsigned NOT NULL default '0',
|
| Zeile 668 | Zeile 676 |
|---|
lastreport int unsigned NOT NULL default '0',
KEY reportstatus (reportstatus),
KEY lastreport (lastreport),
|
lastreport int unsigned NOT NULL default '0',
KEY reportstatus (reportstatus),
KEY lastreport (lastreport),
|
| | PRIMARY KEY (rid)
) ENGINE=MyISAM;";
$tables[] = "CREATE TABLE mybb_reportreasons (
rid int unsigned NOT NULL auto_increment,
title varchar(250) NOT NULL default '',
appliesto varchar(250) NOT NULL default '',
extra tinyint(1) NOT NULL default '0',
disporder smallint unsigned NOT NULL default '0',
|
PRIMARY KEY (rid)
) ENGINE=MyISAM;";
| PRIMARY KEY (rid)
) ENGINE=MyISAM;";
|
| Zeile 966 | Zeile 983 |
|---|
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 1052 | Zeile 1070 |
|---|
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 '',
| yahoo varchar(50) NOT NULL default '',
skype varchar(75) NOT NULL default '',
google varchar(75) NOT NULL default '',
|
| Zeile 1112 | Zeile 1129 |
|---|
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),
|