Vergleich install/resources/mysql_db_tables.php - 1.8.4 - 1.8.8

  Keine Änderungen   Hinzugefügt   Modifiziert   Entfernt
Zeile 29Zeile 29
  defaultviews text NOT NULL,
loginattempts smallint unsigned NOT NULL default '0',
loginlockoutexpiry int unsigned NOT NULL default '0',

  defaultviews text NOT NULL,
loginattempts smallint unsigned NOT NULL default '0',
loginlockoutexpiry int unsigned NOT NULL default '0',

  2fasecret varchar(16) NOT NULL default '',

  authsecret varchar(16) NOT NULL default '',

  recovery_codes varchar(177) NOT NULL default '',
PRIMARY KEY (uid)
) ENGINE=MyISAM;";

  recovery_codes varchar(177) NOT NULL default '',
PRIMARY KEY (uid)
) ENGINE=MyISAM;";

Zeile 42Zeile 42
  dateline int unsigned NOT NULL default '0',
lastactive int unsigned NOT NULL default '0',
data TEXT NOT NULL,

  dateline int unsigned NOT NULL default '0',
lastactive int unsigned NOT NULL default '0',
data TEXT NOT NULL,

  useragent varchar(100) NOT NULL default '',

  useragent varchar(200) NOT NULL default '',

  authenticated tinyint(1) NOT NULL default '0'
) ENGINE=MyISAM;";


  authenticated tinyint(1) NOT NULL default '0'
) ENGINE=MyISAM;";


Zeile 57Zeile 57
	custom_profile_fields text NOT NULL,
sortby varchar(20) NOT NULL default '',
sortorder varchar(4) NOT NULL default '',

	custom_profile_fields text NOT NULL,
sortby varchar(20) NOT NULL default '',
sortorder varchar(4) NOT NULL default '',

	perpage smallint(4) NOT NULL default '0',

	perpage smallint(4) unsigned NOT NULL default '0',

	view_type varchar(6) NOT NULL default '',
PRIMARY KEY (vid)
) ENGINE=MyISAM;";

	view_type varchar(6) NOT NULL default '',
PRIMARY KEY (vid)
) ENGINE=MyISAM;";

Zeile 84Zeile 84
  uid int unsigned NOT NULL default '0',
filename varchar(120) NOT NULL default '',
filetype varchar(120) NOT NULL default '',

  uid int unsigned NOT NULL default '0',
filename varchar(120) NOT NULL default '',
filetype varchar(120) NOT NULL default '',

  filesize int(10) NOT NULL default '0',

  filesize int(10) unsigned NOT NULL default '0',

  attachname varchar(120) NOT NULL default '',
downloads int unsigned NOT NULL default '0',
dateuploaded int unsigned NOT NULL default '0',

  attachname varchar(120) NOT NULL default '',
downloads int unsigned NOT NULL default '0',
dateuploaded int unsigned NOT NULL default '0',

Zeile 100Zeile 100
  name varchar(120) NOT NULL default '',
mimetype varchar(120) NOT NULL default '',
extension varchar(10) NOT NULL default '',

  name varchar(120) NOT NULL default '',
mimetype varchar(120) NOT NULL default '',
extension varchar(10) NOT NULL default '',

  maxsize int(15) NOT NULL default '0',

  maxsize int(15) unsigned NOT NULL default '0',

  icon varchar(100) NOT NULL default '',

  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;";

$tables[] = "CREATE TABLE mybb_awaitingactivation (
aid int unsigned NOT NULL auto_increment,

  PRIMARY KEY (atid)
) ENGINE=MyISAM;";

$tables[] = "CREATE TABLE mybb_awaitingactivation (
aid int unsigned NOT NULL auto_increment,

  uid int unsigned NOT NULL default '0',

  uid int unsigned NOT NULL default '0',

  dateline int unsigned NOT NULL default '0',
code varchar(100) NOT NULL default '',
type char(1) NOT NULL default '',

  dateline int unsigned NOT NULL default '0',
code varchar(100) NOT NULL default '',
type char(1) NOT NULL default '',

Zeile 138Zeile 142
  gid int unsigned NOT NULL default '0',
oldgroup int unsigned NOT NULL default '0',
oldadditionalgroups text NOT NULL,

  gid int unsigned NOT NULL default '0',
oldgroup int unsigned NOT NULL default '0',
oldadditionalgroups text NOT NULL,

  olddisplaygroup int NOT NULL default '0',

  olddisplaygroup int unsigned NOT NULL default '0',

  admin int unsigned NOT NULL default '0',
dateline int unsigned NOT NULL default '0',
bantime varchar(50) NOT NULL default '',

  admin int unsigned NOT NULL default '0',
dateline int unsigned NOT NULL default '0',
bantime varchar(50) NOT NULL default '',

Zeile 149Zeile 153
) ENGINE=MyISAM;";

$tables[] = "CREATE TABLE mybb_buddyrequests (

) ENGINE=MyISAM;";

$tables[] = "CREATE TABLE mybb_buddyrequests (

 id int(10) UNSIGNED NOT NULL auto_increment,
uid bigint(30) UNSIGNED NOT NULL,
touid bigint(30) UNSIGNED NOT NULL,
date int(11) UNSIGNED NOT NULL,
KEY (uid),
KEY (touid),
PRIMARY KEY (id)

  id int(10) unsigned NOT NULL auto_increment,
uid int unsigned NOT NULL default '0',
touid int unsigned NOT NULL default '0',
date int unsigned NOT NULL default '0',
KEY (uid),
KEY (touid),
PRIMARY KEY (id)

) ENGINE=MyISAM;";

$tables[] = "CREATE TABLE mybb_calendars (

) ENGINE=MyISAM;";

$tables[] = "CREATE TABLE mybb_calendars (

Zeile 164Zeile 168
  disporder smallint unsigned NOT NULL default '0',
startofweek tinyint(1) NOT NULL default '0',
showbirthdays tinyint(1) NOT NULL default '0',

  disporder smallint unsigned NOT NULL default '0',
startofweek tinyint(1) NOT NULL default '0',
showbirthdays tinyint(1) NOT NULL default '0',

  eventlimit smallint(3) NOT NULL default '0',

  eventlimit smallint(3) unsigned NOT NULL default '0',

  moderation tinyint(1) NOT NULL default '0',
allowhtml tinyint(1) NOT NULL default '0',
allowmycode tinyint(1) NOT NULL default '0',

  moderation tinyint(1) NOT NULL default '0',
allowhtml tinyint(1) NOT NULL default '0',
allowmycode tinyint(1) NOT NULL default '0',

Zeile 383Zeile 387
	sentcount int unsigned NOT NULL default '0',
totalcount int unsigned NOT NULL default '0',
conditions text NOT NULL,

	sentcount int unsigned NOT NULL default '0',
totalcount int unsigned NOT NULL default '0',
conditions text NOT NULL,

	perpage smallint(4) NOT NULL default '50',
PRIMARY KEY (mid)
) ENGINE=MyISAM;";


	perpage smallint(4) unsigned NOT NULL default '50',
PRIMARY KEY (mid)
) ENGINE=MyISAM;";


$tables[] = "CREATE TABLE mybb_mailerrors (
eid int unsigned NOT NULL auto_increment,
subject varchar(200) NOT NULL default '',

$tables[] = "CREATE TABLE mybb_mailerrors (
eid int unsigned NOT NULL auto_increment,
subject varchar(200) NOT NULL default '',

Zeile 603Zeile 607
  description text NOT NULL,
enabled tinyint(1) NOT NULL default '1',
logging tinyint(1) NOT NULL default '0',

  description text NOT NULL,
enabled tinyint(1) NOT NULL default '1',
logging tinyint(1) NOT NULL default '0',

  posts int NOT NULL default '0',

  posts int unsigned NOT NULL default '0',

  posttype char(2) NOT NULL default '',

  posttype char(2) NOT NULL default '',

  threads int NOT NULL default '0',

  threads int unsigned NOT NULL default '0',

  threadtype char(2) NOT NULL default '',

  threadtype char(2) NOT NULL default '',

  registered int NOT NULL default '0',

  registered int unsigned NOT NULL default '0',

  registeredtype varchar(20) NOT NULL default '',

  registeredtype varchar(20) NOT NULL default '',

  online int NOT NULL default '0',

  online int unsigned NOT NULL default '0',

  onlinetype varchar(20) NOT NULL default '',
reputations int NOT NULL default '0',
reputationtype char(2) NOT NULL default '',

  onlinetype varchar(20) NOT NULL default '',
reputations int NOT NULL default '0',
reputationtype char(2) NOT NULL default '',

  referrals int NOT NULL default '0',

  referrals int unsigned NOT NULL default '0',

  referralstype char(2) NOT NULL default '',

  referralstype char(2) NOT NULL default '',

  warnings int NOT NULL default '0',

  warnings int unsigned NOT NULL default '0',

  warningstype char(2) NOT NULL default '',
requirements varchar(200) NOT NULL default '',
originalusergroup varchar(120) NOT NULL default '0',
newusergroup smallint unsigned NOT NULL default '0',
usergrouptype varchar(120) NOT NULL default '0',
PRIMARY KEY (pid)

  warningstype char(2) NOT NULL default '',
requirements varchar(200) NOT NULL default '',
originalusergroup varchar(120) NOT NULL default '0',
newusergroup smallint unsigned NOT NULL default '0',
usergrouptype varchar(120) NOT NULL default '0',
PRIMARY KEY (pid)

) ENGINE=MyISAM;";


) ENGINE=MyISAM;";


$tables[] = "CREATE TABLE mybb_promotionlogs (
plid int unsigned NOT NULL auto_increment,
pid int unsigned NOT NULL default '0',

$tables[] = "CREATE TABLE mybb_promotionlogs (
plid int unsigned NOT NULL auto_increment,
pid int unsigned NOT NULL default '0',

Zeile 644Zeile 648
  incorrect int unsigned NOT NULL default 0,
active tinyint(1) NOT NULL default '0',
PRIMARY KEY (qid)

  incorrect int unsigned NOT NULL default 0,
active tinyint(1) NOT NULL default '0',
PRIMARY KEY (qid)

) ENGINE=MyISAM;";


) ENGINE=MyISAM;";


$tables[] = "CREATE TABLE mybb_questionsessions (
sid varchar(32) NOT NULL default '',
qid int unsigned NOT NULL default '0',

$tables[] = "CREATE TABLE mybb_questionsessions (
sid varchar(32) NOT NULL default '',
qid int unsigned NOT NULL default '0',

Zeile 660Zeile 664
  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 668Zeile 673
  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 702Zeile 716
  ip varbinary(16) NOT NULL default '',
time int unsigned NOT NULL default '0',
location varchar(150) NOT NULL default '',

  ip varbinary(16) NOT NULL default '',
time int unsigned NOT NULL default '0',
location varchar(150) NOT NULL default '',

  useragent varchar(100) NOT NULL default '',

  useragent varchar(200) NOT NULL default '',

  anonymous tinyint(1) NOT NULL default '0',
nopermission tinyint(1) NOT NULL default '0',

  anonymous tinyint(1) NOT NULL default '0',
nopermission tinyint(1) NOT NULL default '0',

  location1 int(10) NOT NULL default '0',
location2 int(10) NOT NULL default '0',

  location1 int(10) unsigned NOT NULL default '0',
location2 int(10) unsigned NOT NULL default '0',

  PRIMARY KEY(sid),
KEY location (location1, location2),
KEY time (time),

  PRIMARY KEY(sid),
KEY location (location1, location2),
KEY time (time),

Zeile 865Zeile 879
  rid int unsigned NOT NULL auto_increment,
tid int unsigned NOT NULL default '0',
uid int unsigned NOT NULL default '0',

  rid int unsigned NOT NULL auto_increment,
tid int unsigned NOT NULL default '0',
uid int unsigned NOT NULL default '0',

  rating smallint unsigned NOT NULL default '0',

  rating tinyint(1) unsigned NOT NULL default '0',

  ipaddress varbinary(16) NOT NULL default '',
KEY tid (tid, uid),
PRIMARY KEY (rid)

  ipaddress varbinary(16) NOT NULL default '',
KEY tid (tid, uid),
PRIMARY KEY (rid)

Zeile 890Zeile 904
  lastpost int unsigned NOT NULL default '0',
lastposter varchar(120) NOT NULL default '',
lastposteruid int unsigned NOT NULL default '0',

  lastpost int unsigned NOT NULL default '0',
lastposter varchar(120) NOT NULL default '',
lastposteruid int unsigned NOT NULL default '0',

  views int(100) NOT NULL default '0',
replies int(100) NOT NULL default '0',

  views int(100) unsigned NOT NULL default '0',
replies int(100) unsigned NOT NULL default '0',

  closed varchar(30) NOT NULL default '',
sticky tinyint(1) NOT NULL default '0',
numratings smallint unsigned NOT NULL default '0',

  closed varchar(30) NOT NULL default '',
sticky tinyint(1) NOT NULL default '0',
numratings smallint unsigned NOT NULL default '0',

Zeile 924Zeile 938
  tid int unsigned NOT NULL default '0',
notification tinyint(1) NOT NULL default '0',
dateline int unsigned NOT NULL default '0',

  tid int unsigned NOT NULL default '0',
notification tinyint(1) NOT NULL default '0',
dateline int unsigned NOT NULL default '0',

  subscriptionkey varchar(32) NOT NULL default '',

 
  KEY uid (uid),
KEY tid (tid, notification),
PRIMARY KEY (sid)

  KEY uid (uid),
KEY tid (tid, notification),
PRIMARY KEY (sid)

Zeile 940Zeile 953

$tables[] = "CREATE TABLE mybb_usergroups (
gid smallint unsigned NOT NULL auto_increment,


$tables[] = "CREATE TABLE mybb_usergroups (
gid smallint unsigned NOT NULL auto_increment,

  type smallint(2) NOT NULL default '2',

  type tinyint(1) unsigned NOT NULL default '2',

  title varchar(120) NOT NULL default '',
description text NOT NULL,
namestyle varchar(200) NOT NULL default '{username}',
usertitle varchar(120) NOT NULL default '',

  title varchar(120) NOT NULL default '',
description text NOT NULL,
namestyle varchar(200) NOT NULL default '{username}',
usertitle varchar(120) NOT NULL default '',

  stars smallint(4) NOT NULL default '0',

  stars smallint(4) unsigned NOT NULL default '0',

  starimage varchar(120) NOT NULL default '',
image varchar(120) NOT NULL default '',
disporder smallint(6) unsigned NOT NULL,

  starimage varchar(120) NOT NULL default '',
image varchar(120) NOT NULL default '',
disporder smallint(6) unsigned NOT NULL,

Zeile 974Zeile 987
  cansendpms tinyint(1) NOT NULL default '0',
cantrackpms tinyint(1) NOT NULL default '0',
candenypmreceipts tinyint(1) NOT NULL default '0',

  cansendpms tinyint(1) NOT NULL default '0',
cantrackpms tinyint(1) NOT NULL default '0',
candenypmreceipts tinyint(1) NOT NULL default '0',

  pmquota int(3) NOT NULL default '0',
maxpmrecipients int(4) NOT NULL default '5',

  pmquota int(3) unsigned NOT NULL default '0',
maxpmrecipients int(4) unsigned NOT NULL default '5',

  cansendemail tinyint(1) NOT NULL default '0',
cansendemailoverride tinyint(1) NOT NULL default '0',

  cansendemail tinyint(1) NOT NULL default '0',
cansendemailoverride tinyint(1) NOT NULL default '0',

  maxemails int(3) NOT NULL default '5',
emailfloodtime int(3) NOT NULL default '5',

  maxemails int(3) unsigned NOT NULL default '5',
emailfloodtime int(3) unsigned NOT NULL default '5',

  canviewmemberlist tinyint(1) NOT NULL default '0',
canviewcalendar tinyint(1) NOT NULL default '0',
canaddevents tinyint(1) NOT NULL default '0',

  canviewmemberlist tinyint(1) NOT NULL default '0',
canviewcalendar tinyint(1) NOT NULL default '0',
canaddevents tinyint(1) NOT NULL default '0',

Zeile 1010Zeile 1023
  cancustomtitle tinyint(1) NOT NULL default '0',
canwarnusers tinyint(1) NOT NULL default '0',
canreceivewarnings tinyint(1) NOT NULL default '0',

  cancustomtitle tinyint(1) NOT NULL default '0',
canwarnusers tinyint(1) NOT NULL default '0',
canreceivewarnings tinyint(1) NOT NULL default '0',

  maxwarningsday int(3) NOT NULL default '3',

  maxwarningsday int(3) unsigned NOT NULL default '3',

  canmodcp tinyint(1) NOT NULL default '0',
showinbirthdaylist tinyint(1) NOT NULL default '0',
canoverridepm tinyint(1) NOT NULL default '0',
canusesig tinyint(1) NOT NULL default '0',
canusesigxposts smallint unsigned NOT NULL default '0',
signofollow tinyint(1) NOT NULL default '0',

  canmodcp tinyint(1) NOT NULL default '0',
showinbirthdaylist tinyint(1) NOT NULL default '0',
canoverridepm tinyint(1) NOT NULL default '0',
canusesig tinyint(1) NOT NULL default '0',
canusesigxposts smallint unsigned NOT NULL default '0',
signofollow tinyint(1) NOT NULL default '0',

  edittimelimit int(4) NOT NULL default '0',
maxposts int(4) NOT NULL default '0',

  edittimelimit int(4) unsigned NOT NULL default '0',
maxposts int(4) unsigned NOT NULL default '0',

  showmemberlist tinyint(1) NOT NULL default '1',
canmanageannounce tinyint(1) NOT NULL default '0',
canmanagemodqueue tinyint(1) NOT NULL default '0',

  showmemberlist tinyint(1) NOT NULL default '1',
canmanageannounce tinyint(1) NOT NULL default '0',
canmanagemodqueue tinyint(1) NOT NULL default '0',

Zeile 1038Zeile 1051
  salt varchar(10) NOT NULL default '',
loginkey varchar(50) NOT NULL default '',
email varchar(220) NOT NULL default '',

  salt varchar(10) NOT NULL default '',
loginkey varchar(50) NOT NULL default '',
email varchar(220) NOT NULL default '',

  postnum int(10) NOT NULL default '0',
threadnum int(10) NOT NULL default '0',

  postnum int(10) unsigned NOT NULL default '0',
threadnum int(10) unsigned NOT NULL default '0',

  avatar varchar(200) NOT NULL default '',
avatardimensions varchar(10) NOT NULL default '',
avatartype varchar(10) NOT NULL default '0',

  avatar varchar(200) NOT NULL default '',
avatardimensions varchar(10) NOT NULL default '',
avatartype varchar(10) NOT NULL default '0',

Zeile 1077Zeile 1090
  showavatars tinyint(1) NOT NULL default '0',
showquickreply tinyint(1) NOT NULL default '0',
showredirect tinyint(1) NOT NULL default '0',

  showavatars tinyint(1) NOT NULL default '0',
showquickreply tinyint(1) NOT NULL default '0',
showredirect tinyint(1) NOT NULL default '0',

  ppp smallint(6) NOT NULL default '0',
tpp smallint(6) NOT NULL default '0',
daysprune smallint(6) NOT NULL default '0',

  ppp smallint(6) unsigned NOT NULL default '0',
tpp smallint(6) unsigned NOT NULL default '0',
daysprune smallint(6) unsigned NOT NULL default '0',

  dateformat varchar(4) NOT NULL default '',
timeformat varchar(4) NOT NULL default '',
timezone varchar(5) NOT NULL default '',

  dateformat varchar(4) NOT NULL default '',
timeformat varchar(4) NOT NULL default '',
timezone varchar(5) NOT NULL default '',

Zeile 1102Zeile 1115
  language varchar(50) NOT NULL default '',
timeonline int unsigned NOT NULL default '0',
showcodebuttons tinyint(1) NOT NULL default '1',

  language varchar(50) NOT NULL default '',
timeonline int unsigned NOT NULL default '0',
showcodebuttons tinyint(1) NOT NULL default '1',

  totalpms int(10) NOT NULL default '0',
unreadpms int(10) NOT NULL default '0',
warningpoints int(3) NOT NULL default '0',

  totalpms int(10) unsigned NOT NULL default '0',
unreadpms int(10) unsigned NOT NULL default '0',
warningpoints int(3) unsigned NOT NULL default '0',

  moderateposts tinyint(1) NOT NULL default '0',
moderationtime int unsigned NOT NULL default '0',
suspendposting tinyint(1) NOT NULL default '0',

  moderateposts tinyint(1) NOT NULL default '0',
moderationtime int unsigned NOT NULL default '0',
suspendposting tinyint(1) NOT NULL default '0',

Zeile 1113Zeile 1126
  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 tinyint(2) NOT NULL default '1',

  loginattempts smallint(2) unsigned NOT NULL default '1',

  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),

Zeile 1127Zeile 1140
  utid smallint unsigned NOT NULL auto_increment,
posts int unsigned NOT NULL default '0',
title varchar(250) NOT NULL default '',

  utid smallint unsigned NOT NULL auto_increment,
posts int unsigned NOT NULL default '0',
title varchar(250) NOT NULL default '',

  stars smallint(4) NOT NULL default '0',

  stars smallint(4) unsigned NOT NULL default '0',

  starimage varchar(120) NOT NULL default '',
PRIMARY KEY (utid)
) ENGINE=MyISAM;";

$tables[] = "CREATE TABLE mybb_warninglevels (
lid int unsigned NOT NULL auto_increment,

  starimage varchar(120) NOT NULL default '',
PRIMARY KEY (utid)
) ENGINE=MyISAM;";

$tables[] = "CREATE TABLE mybb_warninglevels (
lid int unsigned NOT NULL auto_increment,

	percentage smallint(3) NOT NULL default '0',

	percentage smallint(3) unsigned NOT NULL default '0',

	action text NOT NULL,
PRIMARY KEY (lid)
) ENGINE=MyISAM;";

	action text NOT NULL,
PRIMARY KEY (lid)
) ENGINE=MyISAM;";