Vergleich install/resources/mysql_db_tables.php - 1.8.0 - 1.8.7

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

 
  authsecret varchar(16) NOT NULL default '',
recovery_codes varchar(177) NOT NULL default '',

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


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


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

$tables[] = "CREATE TABLE mybb_adminviews (

) ENGINE=MyISAM;";

$tables[] = "CREATE TABLE mybb_adminviews (

Zeile 54Zeile 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 81Zeile 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 97Zeile 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 '',
PRIMARY KEY (atid)
) ENGINE=MyISAM;";

  icon varchar(100) NOT NULL default '',
PRIMARY KEY (atid)
) ENGINE=MyISAM;";

Zeile 135Zeile 138
  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 146Zeile 149
) 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 161Zeile 164
  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 210Zeile 213
$tables[] = "CREATE TABLE mybb_events (
eid int unsigned NOT NULL auto_increment,
cid int unsigned NOT NULL default '0',

$tables[] = "CREATE TABLE mybb_events (
eid int unsigned NOT NULL auto_increment,
cid int unsigned NOT NULL default '0',

  uid int unsigned NOT NULL default '0',

  uid int unsigned NOT NULL default '0',

  name varchar(120) NOT NULL default '',
description text NOT NULL,
visible tinyint(1) NOT NULL default '0',

  name varchar(120) NOT NULL default '',
description text NOT NULL,
visible tinyint(1) NOT NULL default '0',

Zeile 380Zeile 383
	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',

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

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


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


Zeile 492Zeile 495
) ENGINE=MyISAM;";

$tables[] = "CREATE TABLE mybb_polls (

) ENGINE=MyISAM;";

$tables[] = "CREATE TABLE mybb_polls (

  pid int unsigned NOT NULL auto_increment,
tid int unsigned NOT NULL default '0',

  pid int unsigned NOT NULL auto_increment,
tid int unsigned NOT NULL default '0',

  question varchar(200) NOT NULL default '',
dateline int unsigned NOT NULL default '0',
options text NOT NULL,

  question varchar(200) NOT NULL default '',
dateline int unsigned NOT NULL default '0',
options text NOT NULL,

Zeile 600Zeile 603
  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',

  warningstype char(2) NOT NULL default '',
requirements varchar(200) NOT NULL default '',
originalusergroup varchar(120) NOT NULL default '0',

Zeile 699Zeile 702
  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 862Zeile 865
  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 887Zeile 890
  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 921Zeile 924
  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 937Zeile 939

$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 971Zeile 973
  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 997Zeile 999
  showforumteam tinyint(1) NOT NULL default '0',
usereputationsystem tinyint(1) NOT NULL default '0',
cangivereputations tinyint(1) NOT NULL default '0',

  showforumteam tinyint(1) NOT NULL default '0',
usereputationsystem tinyint(1) NOT NULL default '0',
cangivereputations tinyint(1) NOT NULL default '0',

 
  candeletereputations tinyint(1) NOT NULL default '0',

  reputationpower int unsigned NOT NULL default '0',
maxreputationsday int unsigned NOT NULL default '0',
maxreputationsperuser int unsigned NOT NULL default '0',

  reputationpower int unsigned NOT NULL default '0',
maxreputationsday int unsigned NOT NULL default '0',
maxreputationsperuser int unsigned NOT NULL default '0',

Zeile 1006Zeile 1009
  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 1034Zeile 1037
  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 1073Zeile 1076
  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 1098Zeile 1101
  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 1109Zeile 1112
  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 1123Zeile 1126
  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;";