Vergleich install/resources/mysql_db_tables.php - 1.4.1 - 1.4.7

  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 3981 2008-07-04 21:24:03Z Tikitiki $

 * $Id: mysql_db_tables.php 4322 2009-02-21 23:00:49Z Tikitiki $

 */

$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 470Zeile 471
  dateline bigint(30) NOT NULL default '0',
message text NOT NULL,
ipaddress varchar(30) NOT NULL default '',

  dateline bigint(30) NOT NULL default '0',
message text NOT NULL,
ipaddress varchar(30) NOT NULL default '',

  longipaddress int(10) NOT NULL default '0',

  longipaddress int(11) NOT NULL default '0',

  includesig int(1) NOT NULL default '0',
smilieoff int(1) NOT NULL default '0',
edituid int unsigned NOT NULL default '0',

  includesig int(1) NOT NULL default '0',
smilieoff int(1) NOT NULL default '0',
edituid int unsigned NOT NULL default '0',

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 941Zeile 942
  reputation bigint(30) NOT NULL default '0',
regip varchar(50) NOT NULL default '',
lastip varchar(50) NOT NULL default '',

  reputation bigint(30) NOT NULL default '0',
regip varchar(50) NOT NULL default '',
lastip varchar(50) NOT NULL default '',

  longregip int(10) NOT NULL default '0',
longlastip int(10) NOT NULL default '0',

  longregip int(11) NOT NULL default '0',
longlastip int(11) NOT NULL default '0',

  language varchar(50) NOT NULL default '',
timeonline bigint(30) NOT NULL default '0',
showcodebuttons int(1) NOT NULL default '1',

  language varchar(50) NOT NULL default '',
timeonline bigint(30) NOT NULL default '0',
showcodebuttons int(1) NOT NULL default '1',

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;";