Vergleich install/resources/mysql_db_tables.php - 1.6.5 - 1.6.18

  Keine Änderungen   Hinzugefügt   Modifiziert   Entfernt
Zeile 6Zeile 6
 * Website: http://mybb.com
* License: http://mybb.com/about/license
*

 * Website: http://mybb.com
* License: http://mybb.com/about/license
*

 * $Id: mysql_db_tables.php 5616 2011-09-20 13:24:59Z Tomm $

 * $Id$

 */

$tables[] = "CREATE TABLE mybb_adminlog (

 */

$tables[] = "CREATE TABLE mybb_adminlog (

Zeile 47Zeile 47
	title varchar(100) NOT NULL default '',
type varchar(6) NOT NULL default '',
visibility int(1) NOT NULL default '0',

	title varchar(100) NOT NULL default '',
type varchar(6) NOT NULL default '',
visibility int(1) NOT NULL default '0',

	fields text NOT NULL,

	`fields` text NOT NULL,

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

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

Zeile 426Zeile 426
  canopenclosethreads int(1) NOT NULL default '0',
canmanagethreads int(1) NOT NULL default '0',
canmovetononmodforum int(1) NOT NULL default '0',

  canopenclosethreads int(1) NOT NULL default '0',
canmanagethreads int(1) NOT NULL default '0',
canmovetononmodforum int(1) NOT NULL default '0',

 
  canusecustomtools int(1) NOT NULL default '0',

  KEY uid (id, fid),
PRIMARY KEY (mid)
) ENGINE=MyISAM;";

  KEY uid (id, fid),
PRIMARY KEY (mid)
) ENGINE=MyISAM;";

Zeile 460Zeile 461
  options text NOT NULL,
votes text NOT NULL,
numoptions smallint unsigned NOT NULL default '0',

  options text NOT NULL,
votes text NOT NULL,
numoptions smallint unsigned NOT NULL default '0',

  numvotes smallint unsigned NOT NULL default '0',

  numvotes text NOT NULL,

  timeout bigint(30) NOT NULL default '0',
closed int(1) NOT NULL default '0',
multiple int(1) NOT NULL default '0',

  timeout bigint(30) NOT NULL default '0',
closed int(1) NOT NULL default '0',
multiple int(1) NOT NULL default '0',

Zeile 885Zeile 886
  pmquota int(3) NOT NULL default '0',
maxpmrecipients int(4) NOT NULL default '5',
cansendemail int(1) NOT NULL default '0',

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

 
  cansendemailoverride int(1) NOT NULL default '0',

  maxemails int(3) NOT NULL default '5',
canviewmemberlist int(1) NOT NULL default '0',
canviewcalendar int(1) NOT NULL default '0',

  maxemails int(3) NOT NULL default '5',
canviewmemberlist int(1) NOT NULL default '0',
canviewcalendar int(1) NOT NULL default '0',

Zeile 1003Zeile 1005
  coppauser int(1) NOT NULL default '0',
classicpostbit int(1) NOT NULL default '0',
loginattempts tinyint(2) NOT NULL default '1',

  coppauser int(1) NOT NULL default '0',
classicpostbit int(1) NOT NULL default '0',
loginattempts tinyint(2) NOT NULL default '1',

  failedlogin bigint(30) NOT NULL default '0',

 
  usernotes text NOT NULL,
UNIQUE KEY username (username),
KEY usergroup (usergroup),

  usernotes text NOT NULL,
UNIQUE KEY username (username),
KEY usergroup (usergroup),