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

  Keine Änderungen   Hinzugefügt   Modifiziert   Entfernt
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 128Zeile 132
  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 150
  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 176
  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 252
  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 314Zeile 319

$tables[] = "CREATE TABLE mybb_forumsubscriptions (
fsid int unsigned NOT NULL auto_increment,


$tables[] = "CREATE TABLE mybb_forumsubscriptions (
fsid int unsigned NOT NULL auto_increment,

  fid smallint unsigned NOT NULL default '0',
uid int unsigned NOT NULL default '0',

  fid smallint unsigned NOT NULL default '0',
uid int unsigned NOT NULL default '0',

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

$tables[] = "CREATE TABLE mybb_groupleaders (
lid smallint unsigned NOT NULL auto_increment,

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

$tables[] = "CREATE TABLE mybb_groupleaders (
lid smallint unsigned NOT NULL auto_increment,

  gid smallint unsigned NOT NULL default '0',
uid int unsigned NOT NULL default '0',

  gid smallint unsigned NOT NULL default '0',
uid int unsigned NOT NULL default '0',

  canmanagemembers tinyint(1) NOT NULL default '0',
canmanagerequests tinyint(1) NOT NULL default '0',
caninvitemembers tinyint(1) NOT NULL default '0',

  canmanagemembers tinyint(1) NOT NULL default '0',
canmanagerequests tinyint(1) NOT NULL default '0',
caninvitemembers tinyint(1) NOT NULL default '0',

Zeile 340Zeile 345
  enabled tinyint(1) NOT NULL default '0',
disporder smallint unsigned NOT NULL default '0',
PRIMARY KEY (hid)

  enabled tinyint(1) NOT NULL default '0',
disporder smallint unsigned NOT NULL default '0',
PRIMARY KEY (hid)

) ENGINE=MyISAM;";


) ENGINE=MyISAM;";


$tables[] = "CREATE TABLE mybb_helpsections (
sid smallint unsigned NOT NULL auto_increment,
name varchar(120) NOT NULL default '',

$tables[] = "CREATE TABLE mybb_helpsections (
sid smallint unsigned NOT NULL auto_increment,
name varchar(120) NOT NULL default '',

Zeile 357Zeile 362
  name varchar(120) NOT NULL default '',
path varchar(220) NOT NULL default '',
PRIMARY KEY (iid)

  name varchar(120) NOT NULL default '',
path varchar(220) NOT NULL default '',
PRIMARY KEY (iid)

) ENGINE=MyISAM;";


) ENGINE=MyISAM;";


$tables[] = "CREATE TABLE mybb_joinrequests (
rid int unsigned NOT NULL auto_increment,
uid int unsigned NOT NULL default '0',

$tables[] = "CREATE TABLE mybb_joinrequests (
rid int unsigned NOT NULL auto_increment,
uid int unsigned NOT NULL default '0',

Zeile 384Zeile 389
	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 660Zeile 665
  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 674
  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 966Zeile 981
  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',