| Zeile 538 | Zeile 538 |
|---|
subject varchar(120) NOT NULL default '',
icon smallint unsigned NOT NULL default '0',
uid int unsigned NOT NULL default '0',
|
subject varchar(120) NOT NULL default '',
icon smallint unsigned NOT NULL default '0',
uid int unsigned NOT NULL default '0',
|
username varchar(80) NOT NULL default '',
dateline int unsigned NOT NULL default '0',
message text NOT NULL,
ipaddress varbinary(16) NOT NULL default '',
includesig tinyint(1) NOT NULL default '0',
smilieoff tinyint(1) NOT NULL default '0',
| username varchar(120) NOT NULL default '',
dateline int unsigned NOT NULL default '0',
message text NOT NULL,
ipaddress varbinary(16) NOT NULL default '',
includesig tinyint(1) NOT NULL default '0',
smilieoff tinyint(1) NOT NULL default '0',
|
edituid int unsigned NOT NULL default '0',
edittime int unsigned NOT NULL default '0',
editreason varchar(150) NOT NULL default '',
| edituid int unsigned NOT NULL default '0',
edittime int unsigned NOT NULL default '0',
editreason varchar(150) NOT NULL default '',
|
| Zeile 583 | Zeile 583 |
|---|
$tables[] = "CREATE TABLE mybb_profilefields (
fid smallint unsigned NOT NULL auto_increment,
|
$tables[] = "CREATE TABLE mybb_profilefields (
fid smallint unsigned NOT NULL auto_increment,
|
name varchar(100) NOT NULL default '',
description text NOT NULL,
| name varchar(100) NOT NULL default '',
description text NOT NULL,
|
disporder smallint unsigned NOT NULL default '0',
type text NOT NULL,
regex text NOT NULL,
| disporder smallint unsigned NOT NULL default '0',
type text NOT NULL,
regex text NOT NULL,
|
| Zeile 763 | Zeile 763 |
|---|
image varchar(220) NOT NULL default '',
disporder smallint unsigned NOT NULL default '0',
showclickable tinyint(1) NOT NULL default '0',
|
image varchar(220) NOT NULL default '',
disporder smallint unsigned NOT NULL default '0',
showclickable tinyint(1) NOT NULL default '0',
|
PRIMARY KEY (sid)
) ENGINE=MyISAM;";
| PRIMARY KEY (sid)
) ENGINE=MyISAM;";
|
$tables[] = "CREATE TABLE mybb_spamlog (
sid int unsigned NOT NULL auto_increment,
username varchar(120) NOT NULL DEFAULT '',
email varchar(220) NOT NULL DEFAULT '',
ipaddress varbinary(16) NOT NULL default '',
|
$tables[] = "CREATE TABLE mybb_spamlog (
sid int unsigned NOT NULL auto_increment,
username varchar(120) NOT NULL DEFAULT '',
email varchar(220) NOT NULL DEFAULT '',
ipaddress varbinary(16) NOT NULL default '',
|
dateline int unsigned NOT NULL default '0',
| dateline int unsigned NOT NULL default '0',
|
data text NOT NULL,
PRIMARY KEY (sid)
) ENGINE=MyISAM;";
| data text NOT NULL,
PRIMARY KEY (sid)
) ENGINE=MyISAM;";
|
| Zeile 811 | Zeile 811 |
|---|
logging tinyint(1) NOT NULL default '0',
locked int unsigned NOT NULL default '0',
PRIMARY KEY (tid)
|
logging tinyint(1) NOT NULL default '0',
locked int unsigned NOT NULL default '0',
PRIMARY KEY (tid)
|
) ENGINE=MyISAM;";
| ) ENGINE=MyISAM;";
|
$tables[] = "CREATE TABLE mybb_tasklog (
lid int unsigned NOT NULL auto_increment,
|
$tables[] = "CREATE TABLE mybb_tasklog (
lid int unsigned NOT NULL auto_increment,
|
| Zeile 827 | Zeile 827 |
|---|
title varchar(100) NOT NULL default '',
isdefault tinyint(1) NOT NULL default '0',
PRIMARY KEY (gid)
|
title varchar(100) NOT NULL default '',
isdefault tinyint(1) NOT NULL default '0',
PRIMARY KEY (gid)
|
) ENGINE=MyISAM;";
| ) ENGINE=MyISAM;";
|
$tables[] = "CREATE TABLE mybb_templates (
tid int unsigned NOT NULL auto_increment,
title varchar(120) NOT NULL default '',
| $tables[] = "CREATE TABLE mybb_templates (
tid int unsigned NOT NULL auto_increment,
title varchar(120) NOT NULL default '',
|
| Zeile 838 | Zeile 838 |
|---|
status varchar(10) NOT NULL default '',
dateline int unsigned NOT NULL default '0',
KEY sid (sid, title),
|
status varchar(10) NOT NULL default '',
dateline int unsigned NOT NULL default '0',
KEY sid (sid, title),
|
PRIMARY KEY (tid)
) ENGINE=MyISAM;";
| PRIMARY KEY (tid)
) ENGINE=MyISAM;";
|
$tables[] = "CREATE TABLE mybb_templatesets (
sid smallint unsigned NOT NULL auto_increment,
title varchar(120) NOT NULL default '',
| $tables[] = "CREATE TABLE mybb_templatesets (
sid smallint unsigned NOT NULL auto_increment,
title varchar(120) NOT NULL default '',
|
| Zeile 856 | Zeile 856 |
|---|
stylesheets text NOT NULL,
allowedgroups text NOT NULL,
PRIMARY KEY (tid)
|
stylesheets text NOT NULL,
allowedgroups text NOT NULL,
PRIMARY KEY (tid)
|
) ENGINE=MyISAM;";
| ) ENGINE=MyISAM;";
|
$tables[] = "CREATE TABLE mybb_themestylesheets (
sid int unsigned NOT NULL auto_increment,
|
$tables[] = "CREATE TABLE mybb_themestylesheets (
sid int unsigned NOT NULL auto_increment,
|
| Zeile 868 | Zeile 868 |
|---|
lastmodified int unsigned NOT NULL default '0',
KEY tid (tid),
PRIMARY KEY (sid)
|
lastmodified int unsigned NOT NULL default '0',
KEY tid (tid),
PRIMARY KEY (sid)
|
) ENGINE=MyISAM;";
| ) ENGINE=MyISAM;";
|
$tables[] = "CREATE TABLE mybb_threadprefixes (
pid int unsigned NOT NULL auto_increment,
|
$tables[] = "CREATE TABLE mybb_threadprefixes (
pid int unsigned NOT NULL auto_increment,
|
| Zeile 902 | Zeile 902 |
|---|
icon smallint unsigned NOT NULL default '0',
poll int unsigned NOT NULL default '0',
uid int unsigned NOT NULL default '0',
|
icon smallint unsigned NOT NULL default '0',
poll int unsigned NOT NULL default '0',
uid int unsigned NOT NULL default '0',
|
username varchar(80) NOT NULL default '',
| username varchar(120) NOT NULL default '',
|
dateline int unsigned NOT NULL default '0',
firstpost int unsigned NOT NULL default '0',
lastpost int unsigned NOT NULL default '0',
| dateline int unsigned NOT NULL default '0',
firstpost int unsigned NOT NULL default '0',
lastpost int unsigned NOT NULL default '0',
|
| Zeile 1071 | Zeile 1071 |
|---|
lastvisit int unsigned NOT NULL default '0',
lastpost int unsigned NOT NULL default '0',
website varchar(200) NOT NULL default '',
|
lastvisit int unsigned NOT NULL default '0',
lastpost int unsigned NOT NULL default '0',
website varchar(200) NOT NULL default '',
|
icq varchar(10) 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 '',
|