Vergleich install/resources/mysql_db_tables.php - 1.6.3 - 1.6.11

  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 5440 2011-04-15 10:18:35Z Tomm $

 * $Id$

 */

$tables[] = "CREATE TABLE mybb_adminlog (

 */

$tables[] = "CREATE TABLE mybb_adminlog (

Zeile 49Zeile 49
	visibility int(1) NOT NULL default '0',
`fields` text NOT NULL,
conditions text NOT NULL,

	visibility int(1) NOT NULL default '0',
`fields` text NOT NULL,
conditions text NOT NULL,

 
	custom_profile_fields text NOT NULL,

	sortby varchar(20) NOT NULL default '',
sortorder varchar(4) NOT NULL default '',
perpage int(4) NOT NULL default '0',

	sortby varchar(20) NOT NULL default '',
sortorder varchar(4) NOT NULL default '',
perpage int(4) NOT NULL default '0',

Zeile 425Zeile 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 459Zeile 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 540Zeile 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 883Zeile 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 913Zeile 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 996Zeile 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),