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

  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 102Zeile 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 119Zeile 123
$tables[] = "CREATE TABLE mybb_badwords (
bid int unsigned NOT NULL auto_increment,
badword varchar(100) NOT NULL default '',

$tables[] = "CREATE TABLE mybb_badwords (
bid int unsigned NOT NULL auto_increment,
badword varchar(100) NOT NULL default '',

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

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

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

Zeile 128Zeile 133
  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 146Zeile 151
  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 172Zeile 177
  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 248Zeile 253
  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 384Zeile 390
	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 476Zeile 482
	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 518Zeile 524
  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 660Zeile 667
  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 676
  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 857Zeile 874
	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 966Zeile 983
  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',

Zeile 1052Zeile 1070
  lastpost int unsigned NOT NULL default '0',
website varchar(200) NOT NULL default '',
icq varchar(10) NOT NULL default '',

  lastpost int unsigned NOT NULL default '0',
website varchar(200) NOT NULL default '',
icq varchar(10) NOT NULL default '',

  aim varchar(50) 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 '',

Zeile 1112Zeile 1128
  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 smallint(2) unsigned NOT NULL default '1',


  loginattempts smallint(2) unsigned NOT NULL default '0',
loginlockoutexpiry int unsigned NOT NULL default '0',

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