Vergleich install/resources/mysql_db_tables.php - 1.4.2 - 1.4.15

  Keine Änderungen   Hinzugefügt   Modifiziert   Entfernt
Zeile 6Zeile 6
 * Website: http://www.mybboard.net
* License: http://www.mybboard.net/about/license
*

 * Website: http://www.mybboard.net
* License: http://www.mybboard.net/about/license
*

 * $Id: mysql_db_tables.php 4184 2008-09-10 04:40:17Z Tikitiki $

 * $Id: mysql_db_tables.php 5379 2011-02-21 11:06:42Z Tomm $

 */

$tables[] = "CREATE TABLE mybb_adminlog (

 */

$tables[] = "CREATE TABLE mybb_adminlog (

Zeile 22Zeile 22
$tables[] = "CREATE TABLE mybb_adminoptions (
uid int(10) NOT NULL default '0',
cpstyle varchar(50) NOT NULL default '',

$tables[] = "CREATE TABLE mybb_adminoptions (
uid int(10) NOT NULL default '0',
cpstyle varchar(50) NOT NULL default '',

 
  codepress int(1) NOT NULL default '1',

  notes text NOT NULL,
permissions text NOT NULL,
defaultviews text NOT NULL,

  notes text NOT NULL,
permissions text NOT NULL,
defaultviews text NOT NULL,

Zeile 188Zeile 189
  dateline int(10) unsigned NOT NULL default '0',
starttime int(10) unsigned NOT NULL default '0',
endtime int(10) unsigned NOT NULL default '0',

  dateline int(10) unsigned NOT NULL default '0',
starttime int(10) unsigned NOT NULL default '0',
endtime int(10) unsigned NOT NULL default '0',

  timezone int(3) NOT NULL default '0',

  timezone varchar(4) NOT NULL default '0',

  ignoretimezone int(1) NOT NULL default '0',
usingtime int(1) NOT NULL default '0',
repeats text NOT NULL,

  ignoretimezone int(1) NOT NULL default '0',
usingtime int(1) NOT NULL default '0',
repeats text NOT NULL,

Zeile 481Zeile 482
  KEY uid (uid),
KEY visible (visible),
KEY dateline (dateline),

  KEY uid (uid),
KEY visible (visible),
KEY dateline (dateline),

 
  KEY longipaddress (longipaddress),

  PRIMARY KEY (pid)
) TYPE=MyISAM;";


  PRIMARY KEY (pid)
) TYPE=MyISAM;";


Zeile 603Zeile 605
  nopermission int(1) NOT NULL default '0',
location1 int(10) NOT NULL default '0',
location2 int(10) NOT NULL default '0',

  nopermission int(1) NOT NULL default '0',
location1 int(10) NOT NULL default '0',
location2 int(10) NOT NULL default '0',

  loginattempts tinyint(2) NOT NULL default '1',
failedlogin bigint(30) NOT NULL default '0',

 
  PRIMARY KEY(sid),
KEY location1 (location1),
KEY location2 (location2),
KEY time (time),

  PRIMARY KEY(sid),
KEY location1 (location1),
KEY location2 (location2),
KEY time (time),

  KEY uid (uid)


  KEY uid (uid),
KEY ip (ip)

) TYPE=MyISAM;";

$tables[] = "CREATE TABLE mybb_settinggroups (

) TYPE=MyISAM;";

$tables[] = "CREATE TABLE mybb_settinggroups (

Zeile 690Zeile 691
	dateline bigint(30) NOT NULL default '0',
data text NOT NULL,
PRIMARY KEY (lid)

	dateline bigint(30) NOT NULL default '0',
data text NOT NULL,
PRIMARY KEY (lid)

) TYPE=MyISAM;";


) TYPE=MyISAM;";


$tables[] = "CREATE TABLE mybb_templategroups (
gid int unsigned NOT NULL auto_increment,
prefix varchar(50) NOT NULL default '',

$tables[] = "CREATE TABLE mybb_templategroups (
gid int unsigned NOT NULL auto_increment,
prefix varchar(50) NOT NULL default '',

Zeile 955Zeile 956
  suspensiontime bigint(30) NOT NULL default '0',
coppauser int(1) NOT NULL default '0',
classicpostbit int(1) NOT NULL default '0',

  suspensiontime bigint(30) NOT NULL default '0',
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',

  UNIQUE KEY username (username),
KEY usergroup (usergroup),
KEY birthday (birthday),

  UNIQUE KEY username (username),
KEY usergroup (usergroup),
KEY birthday (birthday),

 
  KEY longregip (longregip),
KEY longlastip (longlastip),

  PRIMARY KEY (uid)
) TYPE=MyISAM;";


  PRIMARY KEY (uid)
) TYPE=MyISAM;";