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 128 | Zeile 132 |
---|
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 150 |
---|
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 176 |
---|
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 252 |
---|
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 319 |
---|
$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 345 |
---|
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 362 |
---|
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 389 |
---|
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 523 |
---|
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 666 |
---|
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 675 |
---|
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 982 |
---|
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',
|