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

  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 4224 2008-10-05 11:17:04Z 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 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),

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

Zeile 624Zeile 624


$tables[] = "CREATE TABLE mybb_settings (



$tables[] = "CREATE TABLE mybb_settings (

  sid smallint unsigned NOT NULL auto_increment,

  sid smallint unsigned NOT NULL auto_increment,

  name varchar(120) NOT NULL default '',
title varchar(120) NOT NULL default '',
description text NOT NULL,

  name varchar(120) NOT NULL default '',
title varchar(120) NOT NULL default '',
description text NOT NULL,

Zeile 634Zeile 634
  gid smallint unsigned NOT NULL default '0',
isdefault int(1) NOT NULL default '0',
PRIMARY KEY (sid)

  gid smallint unsigned NOT NULL default '0',
isdefault int(1) NOT NULL default '0',
PRIMARY KEY (sid)

) TYPE=MyISAM;";

) TYPE=MyISAM;";



$tables[] = "CREATE TABLE mybb_smilies (



$tables[] = "CREATE TABLE mybb_smilies (

Zeile 644Zeile 644
  image varchar(220) NOT NULL default '',
disporder smallint unsigned NOT NULL default '0',
showclickable int(1) NOT NULL default '0',

  image varchar(220) NOT NULL default '',
disporder smallint unsigned NOT NULL default '0',
showclickable int(1) NOT NULL default '0',

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


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


$tables[] = "CREATE TABLE mybb_spiders (
sid int unsigned NOT NULL auto_increment,
name varchar(100) NOT NULL default '',

$tables[] = "CREATE TABLE mybb_spiders (
sid int unsigned NOT NULL auto_increment,
name varchar(100) NOT NULL default '',

Zeile 656Zeile 656
	useragent varchar(200) NOT NULL default '',
lastvisit bigint(30) NOT NULL default '0',
PRIMARY KEY (sid)

	useragent varchar(200) NOT NULL default '',
lastvisit bigint(30) NOT NULL default '0',
PRIMARY KEY (sid)

) TYPE=MyISAM;";


) TYPE=MyISAM;";


$tables[] = "CREATE TABLE mybb_stats (
dateline bigint(30) NOT NULL default '0',
numusers int unsigned NOT NULL default '0',

$tables[] = "CREATE TABLE mybb_stats (
dateline bigint(30) NOT NULL default '0',
numusers int unsigned NOT NULL default '0',

Zeile 690Zeile 690
	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,


$tables[] = "CREATE TABLE mybb_templategroups (
gid int unsigned NOT NULL auto_increment,

Zeile 941Zeile 941
  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 955
  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;";