Vergleich install/resources/mysql_db_tables.php - 1.8.16 - 1.8.39

  Keine Änderungen   Hinzugefügt   Modifiziert   Entfernt
Zeile 82Zeile 82
  pid int unsigned NOT NULL default '0',
  posthash varchar(50) NOT NULL default '',
  uid int unsigned NOT NULL default '0',

 
  pid int unsigned NOT NULL default '0',
  posthash varchar(50) NOT NULL default '',
  uid int unsigned NOT NULL default '0',

  filename varchar(120) NOT NULL default '',

  filename varchar(255) NOT NULL default '',

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

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

  attachname varchar(120) NOT NULL default '',

  attachname varchar(255) NOT NULL default '',

  downloads int unsigned NOT NULL default '0',
  dateuploaded int unsigned NOT NULL default '0',
  visible tinyint(1) NOT NULL default '0',

  downloads int unsigned NOT NULL default '0',
  dateuploaded int unsigned NOT NULL default '0',
  visible tinyint(1) NOT NULL default '0',

Zeile 103Zeile 103
  maxsize int(15) unsigned NOT NULL default '0',
  icon varchar(100) NOT NULL default '',
  enabled tinyint(1) NOT NULL default '1',

 
  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,


  forcedownload tinyint(1) NOT NULL default '0',
  `groups` TEXT NOT NULL,

  forums TEXT NOT NULL,
  avatarfile tinyint(1) NOT NULL default '0',
  PRIMARY KEY (atid)

  forums TEXT NOT NULL,
  avatarfile tinyint(1) NOT NULL default '0',
  PRIMARY KEY (atid)

Zeile 144Zeile 145
  oldgroup int unsigned NOT NULL default '0',
  oldadditionalgroups text NOT NULL,
  olddisplaygroup int unsigned NOT NULL default '0',

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

  admin 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 '',
  lifted int unsigned NOT NULL default '0',

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

Zeile 482Zeile 483
	name varchar(200) NOT NULL,
	description text NOT NULL,
	forums text NOT NULL,

 
	name varchar(200) NOT NULL,
	description text NOT NULL,
	forums text NOT NULL,

	groups text NOT NULL,

	`groups` text NOT NULL,

	type char(1) NOT NULL default '',
	postoptions text NOT NULL,
	threadoptions text NOT NULL,

	type char(1) NOT NULL default '',
	postoptions text NOT NULL,
	threadoptions text NOT NULL,

Zeile 537Zeile 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 582Zeile 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 762Zeile 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 '',

$tables[] = "CREATE TABLE mybb_spamlog (
	sid int unsigned NOT NULL auto_increment,
	username varchar(120) NOT NULL DEFAULT '',

Zeile 874Zeile 875
	prefix varchar(120) NOT NULL default '',
	displaystyle varchar(200) NOT NULL default '',
	forums text NOT NULL,

 
	prefix varchar(120) NOT NULL default '',
	displaystyle varchar(200) NOT NULL default '',
	forums text NOT NULL,

	groups text NOT NULL,

	`groups` text NOT NULL,

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


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


Zeile 901Zeile 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 1013Zeile 1014
  canratemembers tinyint(1) NOT NULL default '0',
  canchangename tinyint(1) NOT NULL default '0',
  canbereported tinyint(1) NOT NULL default '0',

 
  canratemembers tinyint(1) NOT NULL default '0',
  canchangename tinyint(1) NOT NULL default '0',
  canbereported tinyint(1) NOT NULL default '0',

 
  canbeinvisible tinyint(1) NOT NULL default '1',

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

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

Zeile 1069Zeile 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 '',
  yahoo varchar(50) 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 '',