Vergleich install/resources/mysql_db_tables.php - 1.6.4 - 1.6.10

  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 5428 2011-04-07 15:49:37Z 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 541Zeile 542
  required int(1) NOT NULL default '0',
editable int(1) NOT NULL default '0',
hidden int(1) NOT NULL default '0',

  required int(1) NOT NULL default '0',
editable int(1) NOT NULL default '0',
hidden int(1) NOT NULL default '0',

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

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


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


Zeile 884Zeile 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 914Zeile 917
  canreceivewarnings int(1) NOT NULL default '0',
maxwarningsday int(3) NOT NULL default '3',
canmodcp int(1) NOT NULL default '0',

  canreceivewarnings int(1) NOT NULL default '0',
maxwarningsday int(3) NOT NULL default '3',
canmodcp int(1) NOT NULL default '0',

 
  showinbirthdaylist int(1) NOT NULL default '0',
canoverridepm int(1) NOT NULL default '0',
canusesig int(1) NOT NULL default '0',
canusesigxposts bigint(30) NOT NULL default '0',
signofollow int(1) NOT NULL default '0',

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


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


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