Vergleich install/resources/mysql_db_tables.php - 1.6.2 - 1.6.13

  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 5125 2010-07-27 07:28:03Z RyanGordon $

 * $Id$

 */

$tables[] = "CREATE TABLE mybb_adminlog (

 */

$tables[] = "CREATE TABLE mybb_adminlog (

Zeile 17Zeile 17
  action varchar(50) NOT NULL default '',
data text NOT NULL,
KEY module (module, action)

  action varchar(50) NOT NULL default '',
data text NOT NULL,
KEY module (module, action)

) TYPE=MyISAM;";

) ENGINE=MyISAM;";


$tables[] = "CREATE TABLE mybb_adminoptions (
uid int NOT NULL default '0',


$tables[] = "CREATE TABLE mybb_adminoptions (
uid int NOT NULL default '0',

Zeile 29Zeile 29
  loginattempts int unsigned NOT NULL default '0',
loginlockoutexpiry int unsigned NOT NULL default '0',
PRIMARY KEY (uid)

  loginattempts int unsigned NOT NULL default '0',
loginlockoutexpiry int unsigned NOT NULL default '0',
PRIMARY KEY (uid)

) TYPE=MyISAM;";

) ENGINE=MyISAM;";


$tables[] = "CREATE TABLE mybb_adminsessions (
sid varchar(32) NOT NULL default '',


$tables[] = "CREATE TABLE mybb_adminsessions (
sid varchar(32) NOT NULL default '',

Zeile 39Zeile 39
  dateline bigint(30) NOT NULL default '0',
lastactive bigint(30) NOT NULL default '0',
data TEXT NOT NULL

  dateline bigint(30) NOT NULL default '0',
lastactive bigint(30) NOT NULL default '0',
data TEXT NOT NULL

) TYPE=MyISAM;";

) ENGINE=MyISAM;";


$tables[] = "CREATE TABLE mybb_adminviews (
vid int unsigned NOT NULL auto_increment,


$tables[] = "CREATE TABLE mybb_adminviews (
vid int unsigned NOT NULL auto_increment,

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',
view_type varchar(6) NOT NULL default '',
PRIMARY KEY(vid)

	sortby varchar(20) NOT NULL default '',
sortorder varchar(4) NOT NULL default '',
perpage int(4) NOT NULL default '0',
view_type varchar(6) NOT NULL default '',
PRIMARY KEY(vid)

) TYPE=MyISAM;";

) ENGINE=MyISAM;";


$tables[] = "CREATE TABLE mybb_announcements (
aid int unsigned NOT NULL auto_increment,


$tables[] = "CREATE TABLE mybb_announcements (
aid int unsigned NOT NULL auto_increment,

Zeile 69Zeile 70
  allowsmilies int(1) NOT NULL default '0',
KEY fid (fid),
PRIMARY KEY (aid)

  allowsmilies int(1) NOT NULL default '0',
KEY fid (fid),
PRIMARY KEY (aid)

) TYPE=MyISAM;";

) ENGINE=MyISAM;";


$tables[] = "CREATE TABLE mybb_attachments (
aid int unsigned NOT NULL auto_increment,


$tables[] = "CREATE TABLE mybb_attachments (
aid int unsigned NOT NULL auto_increment,

Zeile 88Zeile 89
  KEY pid (pid, visible),
KEY uid (uid),
PRIMARY KEY (aid)

  KEY pid (pid, visible),
KEY uid (uid),
PRIMARY KEY (aid)

) TYPE=MyISAM;";

) ENGINE=MyISAM;";


$tables[] = "CREATE TABLE mybb_attachtypes (
atid int unsigned NOT NULL auto_increment,


$tables[] = "CREATE TABLE mybb_attachtypes (
atid int unsigned NOT NULL auto_increment,

Zeile 98Zeile 99
  maxsize int(15) NOT NULL default '0',
icon varchar(100) NOT NULL default '',
PRIMARY KEY (atid)

  maxsize int(15) NOT NULL default '0',
icon varchar(100) NOT NULL default '',
PRIMARY KEY (atid)

) TYPE=MyISAM;";

) ENGINE=MyISAM;";


$tables[] = "CREATE TABLE mybb_awaitingactivation (
aid int unsigned NOT NULL auto_increment,


$tables[] = "CREATE TABLE mybb_awaitingactivation (
aid int unsigned NOT NULL auto_increment,

Zeile 109Zeile 110
  oldgroup bigint(30) NOT NULL default '0',
misc varchar(255) NOT NULL default '',
PRIMARY KEY (aid)

  oldgroup bigint(30) NOT NULL default '0',
misc varchar(255) NOT NULL default '',
PRIMARY KEY (aid)

) TYPE=MyISAM;";

) ENGINE=MyISAM;";


$tables[] = "CREATE TABLE mybb_badwords (
bid int unsigned NOT NULL auto_increment,
badword varchar(100) NOT NULL default '',
replacement varchar(100) NOT NULL default '',
PRIMARY KEY (bid)


$tables[] = "CREATE TABLE mybb_badwords (
bid int unsigned NOT NULL auto_increment,
badword varchar(100) NOT NULL default '',
replacement varchar(100) NOT NULL default '',
PRIMARY KEY (bid)

) TYPE=MyISAM;";

) ENGINE=MyISAM;";


$tables[] = "CREATE TABLE mybb_banfilters (
fid int unsigned NOT NULL auto_increment,


$tables[] = "CREATE TABLE mybb_banfilters (
fid int unsigned NOT NULL auto_increment,

Zeile 125Zeile 126
  lastuse bigint(30) NOT NULL default '0',
dateline bigint(30) NOT NULL default '0',
PRIMARY KEY (fid)

  lastuse bigint(30) NOT NULL default '0',
dateline bigint(30) NOT NULL default '0',
PRIMARY KEY (fid)

) TYPE=MyISAM;";

) ENGINE=MyISAM;";


$tables[] = "CREATE TABLE mybb_banned (
uid int unsigned NOT NULL default '0',


$tables[] = "CREATE TABLE mybb_banned (
uid int unsigned NOT NULL default '0',

Zeile 140Zeile 141
  reason varchar(255) NOT NULL default '',
KEY uid (uid),
KEY dateline (dateline)

  reason varchar(255) NOT NULL default '',
KEY uid (uid),
KEY dateline (dateline)

) TYPE=MyISAM;";

) ENGINE=MyISAM;";


$tables[] = "CREATE TABLE mybb_calendars (
cid int unsigned NOT NULL auto_increment,


$tables[] = "CREATE TABLE mybb_calendars (
cid int unsigned NOT NULL auto_increment,

Zeile 156Zeile 157
  allowvideocode int(1) NOT NULL default '0',
allowsmilies int(1) NOT NULL default '0',
PRIMARY KEY(cid)

  allowvideocode int(1) NOT NULL default '0',
allowsmilies int(1) NOT NULL default '0',
PRIMARY KEY(cid)

) TYPE=MyISAM;";

) ENGINE=MyISAM;";


$tables[] = "CREATE TABLE mybb_calendarpermissions (
cid int unsigned NOT NULL default '0',


$tables[] = "CREATE TABLE mybb_calendarpermissions (
cid int unsigned NOT NULL default '0',

Zeile 165Zeile 166
  canaddevents int(1) NOT NULL default '0',
canbypasseventmod int(1) NOT NULL default '0',
canmoderateevents int(1) NOT NULL default '0'

  canaddevents int(1) NOT NULL default '0',
canbypasseventmod int(1) NOT NULL default '0',
canmoderateevents int(1) NOT NULL default '0'

) TYPE=MyISAM;";

) ENGINE=MyISAM;";


$tables[] = "CREATE TABLE mybb_captcha (
imagehash varchar(32) NOT NULL default '',


$tables[] = "CREATE TABLE mybb_captcha (
imagehash varchar(32) NOT NULL default '',

Zeile 173Zeile 174
  dateline bigint(30) NOT NULL default '0',
KEY imagehash (imagehash),
KEY dateline (dateline)

  dateline bigint(30) NOT NULL default '0',
KEY imagehash (imagehash),
KEY dateline (dateline)

) TYPE=MyISAM;";

) ENGINE=MyISAM;";


$tables[] = "CREATE TABLE mybb_datacache (
title varchar(50) NOT NULL default '',
cache mediumtext NOT NULL,
PRIMARY KEY(title)


$tables[] = "CREATE TABLE mybb_datacache (
title varchar(50) NOT NULL default '',
cache mediumtext NOT NULL,
PRIMARY KEY(title)

) TYPE=MyISAM;";

) ENGINE=MyISAM;";


$tables[] = "CREATE TABLE mybb_delayedmoderation (
did int unsigned NOT NULL auto_increment,


$tables[] = "CREATE TABLE mybb_delayedmoderation (
did int unsigned NOT NULL auto_increment,

Zeile 191Zeile 192
  dateline bigint(30) NOT NULL default '0',
inputs text NOT NULL,
PRIMARY KEY (did)

  dateline bigint(30) NOT NULL default '0',
inputs text NOT NULL,
PRIMARY KEY (did)

) TYPE=MyISAM;";

) ENGINE=MyISAM;";


$tables[] = "CREATE TABLE mybb_events (
eid int unsigned NOT NULL auto_increment,


$tables[] = "CREATE TABLE mybb_events (
eid int unsigned NOT NULL auto_increment,

Zeile 211Zeile 212
  KEY daterange (starttime, endtime),
KEY private (private),
PRIMARY KEY (eid)

  KEY daterange (starttime, endtime),
KEY private (private),
PRIMARY KEY (eid)

) TYPE=MyISAM;";

) ENGINE=MyISAM;";


$tables[] = "CREATE TABLE mybb_forumpermissions (
pid int unsigned NOT NULL auto_increment,


$tables[] = "CREATE TABLE mybb_forumpermissions (
pid int unsigned NOT NULL auto_increment,

Zeile 233Zeile 234
  canvotepolls int(1) NOT NULL default '0',
cansearch int(1) NOT NULL default '0',
PRIMARY KEY (pid)

  canvotepolls int(1) NOT NULL default '0',
cansearch int(1) NOT NULL default '0',
PRIMARY KEY (pid)

) TYPE=MyISAM;";

) ENGINE=MyISAM;";


$tables[] = "CREATE TABLE mybb_forums (
fid smallint unsigned NOT NULL auto_increment,


$tables[] = "CREATE TABLE mybb_forums (
fid smallint unsigned NOT NULL auto_increment,

Zeile 279Zeile 280
  defaultsortby varchar(10) NOT NULL default '',
defaultsortorder varchar(4) NOT NULL default '',
PRIMARY KEY (fid)

  defaultsortby varchar(10) NOT NULL default '',
defaultsortorder varchar(4) NOT NULL default '',
PRIMARY KEY (fid)

) TYPE=MyISAM;";

) ENGINE=MyISAM;";


$tables[] = "CREATE TABLE mybb_forumsread (
fid int unsigned NOT NULL default '0',


$tables[] = "CREATE TABLE mybb_forumsread (
fid int unsigned NOT NULL default '0',

Zeile 287Zeile 288
  dateline int(10) NOT NULL default '0',
KEY dateline (dateline),
UNIQUE KEY fid (fid,uid)

  dateline int(10) NOT NULL default '0',
KEY dateline (dateline),
UNIQUE KEY fid (fid,uid)

) TYPE=MyISAM;";

) ENGINE=MyISAM;";



$tables[] = "CREATE TABLE mybb_forumsubscriptions (



$tables[] = "CREATE TABLE mybb_forumsubscriptions (

Zeile 295Zeile 296
  fid smallint unsigned NOT NULL default '0',
uid int unsigned NOT NULL default '0',
PRIMARY KEY (fsid)

  fid smallint unsigned NOT NULL default '0',
uid int unsigned NOT NULL default '0',
PRIMARY KEY (fsid)

) TYPE=MyISAM;";

) ENGINE=MyISAM;";


$tables[] = "CREATE TABLE mybb_groupleaders (
lid smallint unsigned NOT NULL auto_increment,


$tables[] = "CREATE TABLE mybb_groupleaders (
lid smallint unsigned NOT NULL auto_increment,

Zeile 304Zeile 305
  canmanagemembers int(1) NOT NULL default '0',
canmanagerequests int(1) NOT NULL default '0',
PRIMARY KEY (lid)

  canmanagemembers int(1) NOT NULL default '0',
canmanagerequests int(1) NOT NULL default '0',
PRIMARY KEY (lid)

) TYPE=MyISAM;";

) ENGINE=MyISAM;";


$tables[] = "CREATE TABLE mybb_helpdocs (
hid smallint unsigned NOT NULL auto_increment,


$tables[] = "CREATE TABLE mybb_helpdocs (
hid smallint unsigned NOT NULL auto_increment,

Zeile 316Zeile 317
  enabled int(1) NOT NULL default '0',
disporder smallint unsigned NOT NULL default '0',
PRIMARY KEY (hid)

  enabled int(1) NOT NULL default '0',
disporder smallint unsigned NOT NULL default '0',
PRIMARY KEY (hid)

) TYPE=MyISAM;";

) ENGINE=MyISAM;";



$tables[] = "CREATE TABLE mybb_helpsections (



$tables[] = "CREATE TABLE mybb_helpsections (

Zeile 327Zeile 328
  enabled int(1) NOT NULL default '0',
disporder smallint unsigned NOT NULL default '0',
PRIMARY KEY (sid)

  enabled int(1) NOT NULL default '0',
disporder smallint unsigned NOT NULL default '0',
PRIMARY KEY (sid)

) TYPE=MyISAM;";

) ENGINE=MyISAM;";



$tables[] = "CREATE TABLE mybb_icons (



$tables[] = "CREATE TABLE mybb_icons (

Zeile 335Zeile 336
  name varchar(120) NOT NULL default '',
path varchar(220) NOT NULL default '',
PRIMARY KEY (iid)

  name varchar(120) NOT NULL default '',
path varchar(220) NOT NULL default '',
PRIMARY KEY (iid)

) TYPE=MyISAM;";

) ENGINE=MyISAM;";



$tables[] = "CREATE TABLE mybb_joinrequests (



$tables[] = "CREATE TABLE mybb_joinrequests (

Zeile 345Zeile 346
  reason varchar(250) NOT NULL default '',
dateline bigint(30) NOT NULL default '0',
PRIMARY KEY (rid)

  reason varchar(250) NOT NULL default '',
dateline bigint(30) NOT NULL default '0',
PRIMARY KEY (rid)

) TYPE=MyISAM;";

) ENGINE=MyISAM;";


$tables[] = "CREATE TABLE mybb_massemails (
mid int unsigned NOT NULL auto_increment,


$tables[] = "CREATE TABLE mybb_massemails (
mid int unsigned NOT NULL auto_increment,

Zeile 363Zeile 364
	conditions text NOT NULL,
perpage smallint(4) NOT NULL default '50',
PRIMARY KEY(mid)

	conditions text NOT NULL,
perpage smallint(4) NOT NULL default '50',
PRIMARY KEY(mid)

) TYPE=MyISAM;";

) ENGINE=MyISAM;";


$tables[] = "CREATE TABLE mybb_mailerrors (
eid int unsigned NOT NULL auto_increment,


$tables[] = "CREATE TABLE mybb_mailerrors (
eid int unsigned NOT NULL auto_increment,

Zeile 376Zeile 377
  smtperror varchar(200) NOT NULL default '',
smtpcode int(5) NOT NULL default '0',
PRIMARY KEY (eid)

  smtperror varchar(200) NOT NULL default '',
smtpcode int(5) NOT NULL default '0',
PRIMARY KEY (eid)

) TYPE=MyISAM;";

) ENGINE=MyISAM;";


$tables[] = "CREATE TABLE mybb_maillogs (
mid int unsigned NOT NULL auto_increment,


$tables[] = "CREATE TABLE mybb_maillogs (
mid int unsigned NOT NULL auto_increment,

Zeile 390Zeile 391
	tid int unsigned NOT NULL default '0',
ipaddress varchar(20) NOT NULL default '',
PRIMARY KEY (mid)

	tid int unsigned NOT NULL default '0',
ipaddress varchar(20) NOT NULL default '',
PRIMARY KEY (mid)

) TYPE=MyISAM;";

) ENGINE=MyISAM;";


$tables[] = "CREATE TABLE mybb_mailqueue (
mid int unsigned NOT NULL auto_increment,


$tables[] = "CREATE TABLE mybb_mailqueue (
mid int unsigned NOT NULL auto_increment,

Zeile 400Zeile 401
	message text NOT NULL,
headers text NOT NULL,
PRIMARY KEY (mid)

	message text NOT NULL,
headers text NOT NULL,
PRIMARY KEY (mid)

) TYPE=MyISAM;";

) ENGINE=MyISAM;";


$tables[] = "CREATE TABLE mybb_moderatorlog (
uid int unsigned NOT NULL default '0',


$tables[] = "CREATE TABLE mybb_moderatorlog (
uid int unsigned NOT NULL default '0',

Zeile 412Zeile 413
  data text NOT NULL,
ipaddress varchar(50) NOT NULL default '',
KEY tid (tid)

  data text NOT NULL,
ipaddress varchar(50) NOT NULL default '',
KEY tid (tid)

) TYPE=MyISAM;";

) ENGINE=MyISAM;";


$tables[] = "CREATE TABLE mybb_moderators (
mid smallint unsigned NOT NULL auto_increment,


$tables[] = "CREATE TABLE mybb_moderators (
mid smallint unsigned NOT NULL auto_increment,

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)

  KEY uid (id, fid),
PRIMARY KEY (mid)

) TYPE=MyISAM;";

) ENGINE=MyISAM;";


$tables[] = "CREATE TABLE mybb_modtools (
tid smallint unsigned NOT NULL auto_increment,


$tables[] = "CREATE TABLE mybb_modtools (
tid smallint unsigned NOT NULL auto_increment,

Zeile 438Zeile 440
	postoptions text NOT NULL,
threadoptions text NOT NULL,
PRIMARY KEY (tid)

	postoptions text NOT NULL,
threadoptions text NOT NULL,
PRIMARY KEY (tid)

) TYPE=MyISAM;";

) ENGINE=MyISAM;";


$tables[] = "CREATE TABLE mybb_mycode (
cid int unsigned NOT NULL auto_increment,


$tables[] = "CREATE TABLE mybb_mycode (
cid int unsigned NOT NULL auto_increment,

Zeile 449Zeile 451
  active int(1) NOT NULL default '0',
parseorder smallint unsigned NOT NULL default '0',
PRIMARY KEY(cid)

  active int(1) NOT NULL default '0',
parseorder smallint unsigned NOT NULL default '0',
PRIMARY KEY(cid)

) TYPE=MyISAM;";

) ENGINE=MyISAM;";


$tables[] = "CREATE TABLE mybb_polls (
pid int unsigned NOT NULL auto_increment,


$tables[] = "CREATE TABLE mybb_polls (
pid int unsigned NOT NULL auto_increment,

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',
public int(1) NOT NULL default '0',
PRIMARY KEY (pid)

  timeout bigint(30) NOT NULL default '0',
closed int(1) NOT NULL default '0',
multiple int(1) NOT NULL default '0',
public int(1) NOT NULL default '0',
PRIMARY KEY (pid)

) TYPE=MyISAM;";

) ENGINE=MyISAM;";


$tables[] = "CREATE TABLE mybb_pollvotes (
vid int unsigned NOT NULL auto_increment,


$tables[] = "CREATE TABLE mybb_pollvotes (
vid int unsigned NOT NULL auto_increment,

Zeile 475Zeile 477
  dateline bigint(30) NOT NULL default '0',
KEY pid (pid, uid),
PRIMARY KEY (vid)

  dateline bigint(30) NOT NULL default '0',
KEY pid (pid, uid),
PRIMARY KEY (vid)

) TYPE=MyISAM;";

) ENGINE=MyISAM;";


$tables[] = "CREATE TABLE mybb_posts (
pid int unsigned NOT NULL auto_increment,


$tables[] = "CREATE TABLE mybb_posts (
pid int unsigned NOT NULL auto_increment,

Zeile 502Zeile 504
  KEY dateline (dateline),
KEY longipaddress (longipaddress),
PRIMARY KEY (pid)

  KEY dateline (dateline),
KEY longipaddress (longipaddress),
PRIMARY KEY (pid)

) TYPE=MyISAM;";

) ENGINE=MyISAM;";



$tables[] = "CREATE TABLE mybb_privatemessages (



$tables[] = "CREATE TABLE mybb_privatemessages (

Zeile 526Zeile 528
  KEY uid (uid, folder),
KEY toid (toid),
PRIMARY KEY (pmid)

  KEY uid (uid, folder),
KEY toid (toid),
PRIMARY KEY (pmid)

) TYPE=MyISAM;";

) ENGINE=MyISAM;";



$tables[] = "CREATE TABLE mybb_profilefields (



$tables[] = "CREATE TABLE mybb_profilefields (

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)

  PRIMARY KEY (fid)

) TYPE=MyISAM;";

) ENGINE=MyISAM;";



$tables[] = "CREATE TABLE mybb_promotions (



$tables[] = "CREATE TABLE mybb_promotions (

Zeile 563Zeile 566
  newusergroup smallint unsigned NOT NULL default '0',
usergrouptype varchar(120) NOT NULL default '0',
PRIMARY KEY (pid)

  newusergroup smallint unsigned NOT NULL default '0',
usergrouptype varchar(120) NOT NULL default '0',
PRIMARY KEY (pid)

) TYPE=MyISAM;";

) ENGINE=MyISAM;";

	
$tables[] = "CREATE TABLE mybb_promotionlogs (
plid int unsigned NOT NULL auto_increment,

	
$tables[] = "CREATE TABLE mybb_promotionlogs (
plid int unsigned NOT NULL auto_increment,

Zeile 574Zeile 577
  dateline bigint(30) NOT NULL default '0',
type varchar(9) NOT NULL default 'primary',
PRIMARY KEY(plid)

  dateline bigint(30) NOT NULL default '0',
type varchar(9) NOT NULL default 'primary',
PRIMARY KEY(plid)

) TYPE=MyISAM;";

) ENGINE=MyISAM;";


$tables[] = "CREATE TABLE mybb_reportedposts (
rid int unsigned NOT NULL auto_increment,


$tables[] = "CREATE TABLE mybb_reportedposts (
rid int unsigned NOT NULL auto_increment,

Zeile 588Zeile 591
  KEY fid (fid),
KEY dateline (dateline),
PRIMARY KEY (rid)

  KEY fid (fid),
KEY dateline (dateline),
PRIMARY KEY (rid)

) TYPE=MyISAM;";

) ENGINE=MyISAM;";


$tables[] = "CREATE TABLE mybb_reputation (
rid int unsigned NOT NULL auto_increment,


$tables[] = "CREATE TABLE mybb_reputation (
rid int unsigned NOT NULL auto_increment,

Zeile 602Zeile 605
  KEY pid (pid),
KEY dateline (dateline),
PRIMARY KEY (rid)

  KEY pid (pid),
KEY dateline (dateline),
PRIMARY KEY (rid)

) TYPE=MyISAM;";

) ENGINE=MyISAM;";


$tables[] = "CREATE TABLE mybb_searchlog (
sid varchar(32) NOT NULL default '',


$tables[] = "CREATE TABLE mybb_searchlog (
sid varchar(32) NOT NULL default '',

Zeile 615Zeile 618
  querycache text NOT NULL,
keywords text NOT NULL,
PRIMARY KEY (sid)

  querycache text NOT NULL,
keywords text NOT NULL,
PRIMARY KEY (sid)

) TYPE=MyISAM;";

) ENGINE=MyISAM;";


$tables[] = "CREATE TABLE mybb_sessions (
sid varchar(32) NOT NULL default '',


$tables[] = "CREATE TABLE mybb_sessions (
sid varchar(32) NOT NULL default '',

Zeile 634Zeile 637
  KEY time (time),
KEY uid (uid),
KEY ip (ip)

  KEY time (time),
KEY uid (uid),
KEY ip (ip)

) TYPE=MyISAM;";

) ENGINE=MyISAM;";


$tables[] = "CREATE TABLE mybb_settinggroups (
gid smallint unsigned NOT NULL auto_increment,


$tables[] = "CREATE TABLE mybb_settinggroups (
gid smallint unsigned NOT NULL auto_increment,

Zeile 644Zeile 647
  disporder smallint unsigned NOT NULL default '0',
isdefault int(1) NOT NULL default '0',
PRIMARY KEY (gid)

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

) TYPE=MyISAM;";

) ENGINE=MyISAM;";



$tables[] = "CREATE TABLE mybb_settings (



$tables[] = "CREATE TABLE mybb_settings (

Zeile 658Zeile 661
  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;";

) ENGINE=MyISAM;";



$tables[] = "CREATE TABLE mybb_smilies (



$tables[] = "CREATE TABLE mybb_smilies (

Zeile 669Zeile 672
  disporder smallint unsigned NOT NULL default '0',
showclickable int(1) NOT NULL default '0',
PRIMARY KEY (sid)

  disporder smallint unsigned NOT NULL default '0',
showclickable int(1) NOT NULL default '0',
PRIMARY KEY (sid)

) TYPE=MyISAM;";

) ENGINE=MyISAM;";


$tables[] = "CREATE TABLE mybb_spiders (
sid int unsigned NOT NULL auto_increment,


$tables[] = "CREATE TABLE mybb_spiders (
sid int unsigned NOT NULL auto_increment,

Zeile 680Zeile 683
	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;";

) ENGINE=MyISAM;";


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


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

Zeile 688Zeile 691
	numthreads int unsigned NOT NULL default '0',
numposts int unsigned NOT NULL default '0',
PRIMARY KEY(dateline)

	numthreads int unsigned NOT NULL default '0',
numposts int unsigned NOT NULL default '0',
PRIMARY KEY(dateline)

) TYPE=MyISAM;";

) ENGINE=MyISAM;";

	
$tables[] = "CREATE TABLE mybb_tasks (
tid int unsigned NOT NULL auto_increment,

	
$tables[] = "CREATE TABLE mybb_tasks (
tid int unsigned NOT NULL auto_increment,

Zeile 706Zeile 709
	logging int(1) NOT NULL default '0',
locked bigint(30) NOT NULL default '0',
PRIMARY KEY (tid)

	logging int(1) NOT NULL default '0',
locked bigint(30) NOT NULL default '0',
PRIMARY KEY (tid)

) TYPE=MyISAM;";

) ENGINE=MyISAM;";


$tables[] = "CREATE TABLE mybb_tasklog (
lid int unsigned NOT NULL auto_increment,


$tables[] = "CREATE TABLE mybb_tasklog (
lid int unsigned NOT NULL auto_increment,

Zeile 714Zeile 717
	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;";

) ENGINE=MyISAM;";


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


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

) TYPE=MyISAM;";

) ENGINE=MyISAM;";


$tables[] = "CREATE TABLE mybb_templates (
tid int unsigned NOT NULL auto_increment,


$tables[] = "CREATE TABLE mybb_templates (
tid int unsigned NOT NULL auto_increment,

Zeile 732Zeile 735
  status varchar(10) NOT NULL default '',
dateline int(10) NOT NULL default '0',
PRIMARY KEY (tid)

  status varchar(10) NOT NULL default '',
dateline int(10) NOT NULL default '0',
PRIMARY KEY (tid)

) TYPE=MyISAM;";

) ENGINE=MyISAM;";


$tables[] = "CREATE TABLE mybb_templatesets (
sid smallint unsigned NOT NULL auto_increment,
title varchar(120) NOT NULL default '',
PRIMARY KEY (sid)


$tables[] = "CREATE TABLE mybb_templatesets (
sid smallint unsigned NOT NULL auto_increment,
title varchar(120) NOT NULL default '',
PRIMARY KEY (sid)

) TYPE=MyISAM;";

) ENGINE=MyISAM;";



$tables[] = "CREATE TABLE mybb_themes (



$tables[] = "CREATE TABLE mybb_themes (

Zeile 750Zeile 753
  stylesheets text NOT NULL,
allowedgroups text NOT NULL,
PRIMARY KEY (tid)

  stylesheets text NOT NULL,
allowedgroups text NOT NULL,
PRIMARY KEY (tid)

) TYPE=MyISAM;";

) ENGINE=MyISAM;";


$tables[] = "CREATE TABLE mybb_themestylesheets(
sid int unsigned NOT NULL auto_increment,


$tables[] = "CREATE TABLE mybb_themestylesheets(
sid int unsigned NOT NULL auto_increment,

Zeile 761Zeile 764
	cachefile varchar(100) NOT NULL default '',
lastmodified bigint(30) NOT NULL default '0',
PRIMARY KEY(sid)

	cachefile varchar(100) NOT NULL default '',
lastmodified bigint(30) NOT NULL default '0',
PRIMARY KEY(sid)

) TYPE=MyISAM;";

) ENGINE=MyISAM;";


$tables[] = "CREATE TABLE mybb_threadprefixes (
pid int unsigned NOT NULL auto_increment,


$tables[] = "CREATE TABLE mybb_threadprefixes (
pid int unsigned NOT NULL auto_increment,

Zeile 770Zeile 773
	forums text NOT NULL,
groups text NOT NULL,
PRIMARY KEY(pid)

	forums text NOT NULL,
groups text NOT NULL,
PRIMARY KEY(pid)

) TYPE=MyISAM;";

) ENGINE=MyISAM;";


$tables[] = "CREATE TABLE mybb_threadratings (
rid int unsigned NOT NULL auto_increment,


$tables[] = "CREATE TABLE mybb_threadratings (
rid int unsigned NOT NULL auto_increment,

Zeile 780Zeile 783
  ipaddress varchar(30) NOT NULL default '',
KEY tid (tid, uid),
PRIMARY KEY (rid)

  ipaddress varchar(30) NOT NULL default '',
KEY tid (tid, uid),
PRIMARY KEY (rid)

) TYPE=MyISAM;";

) ENGINE=MyISAM;";


$tables[] = "CREATE TABLE mybb_threadviews (
tid int unsigned NOT NULL default '0',
KEY (tid)


$tables[] = "CREATE TABLE mybb_threadviews (
tid int unsigned NOT NULL default '0',
KEY (tid)

) TYPE=MyISAM;";

) ENGINE=MyISAM;";



$tables[] = "CREATE TABLE mybb_threads (



$tables[] = "CREATE TABLE mybb_threads (

Zeile 819Zeile 822
  KEY firstpost (firstpost),
KEY uid (uid),
PRIMARY KEY (tid)

  KEY firstpost (firstpost),
KEY uid (uid),
PRIMARY KEY (tid)

) TYPE=MyISAM;";

) ENGINE=MyISAM;";


$tables[] = "CREATE TABLE mybb_threadsread (
tid int unsigned NOT NULL default '0',


$tables[] = "CREATE TABLE mybb_threadsread (
tid int unsigned NOT NULL default '0',

Zeile 827Zeile 830
  dateline int(10) NOT NULL default '0',
KEY dateline (dateline),
UNIQUE KEY tid (tid,uid)

  dateline int(10) NOT NULL default '0',
KEY dateline (dateline),
UNIQUE KEY tid (tid,uid)

) TYPE=MyISAM;";

) ENGINE=MyISAM;";


$tables[] = "CREATE TABLE mybb_threadsubscriptions (
sid int unsigned NOT NULL auto_increment,


$tables[] = "CREATE TABLE mybb_threadsubscriptions (
sid int unsigned NOT NULL auto_increment,

Zeile 839Zeile 842
  KEY uid (uid),
KEY tid (tid,notification),
PRIMARY KEY (sid)

  KEY uid (uid),
KEY tid (tid,notification),
PRIMARY KEY (sid)

) TYPE=MyISAM;";

) ENGINE=MyISAM;";


$tables[] = "CREATE TABLE mybb_userfields (
ufid int unsigned NOT NULL default '0',


$tables[] = "CREATE TABLE mybb_userfields (
ufid int unsigned NOT NULL default '0',

Zeile 847Zeile 850
  fid2 text NOT NULL,
fid3 text NOT NULL,
PRIMARY KEY (ufid)

  fid2 text NOT NULL,
fid3 text NOT NULL,
PRIMARY KEY (ufid)

) TYPE=MyISAM;";

) ENGINE=MyISAM;";


$tables[] = "CREATE TABLE mybb_usergroups (
gid smallint unsigned NOT NULL auto_increment,


$tables[] = "CREATE TABLE mybb_usergroups (
gid smallint unsigned NOT NULL auto_increment,

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)

  PRIMARY KEY (gid)

) TYPE=MyISAM;";

) ENGINE=MyISAM;";



$tables[] = "CREATE TABLE mybb_users (



$tables[] = "CREATE TABLE mybb_users (

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

Zeile 1004Zeile 1012
  KEY longregip (longregip),
KEY longlastip (longlastip),
PRIMARY KEY (uid)

  KEY longregip (longregip),
KEY longlastip (longlastip),
PRIMARY KEY (uid)

) TYPE=MyISAM;";

) ENGINE=MyISAM;";


$tables[] = "CREATE TABLE mybb_usertitles (
utid smallint unsigned NOT NULL auto_increment,


$tables[] = "CREATE TABLE mybb_usertitles (
utid smallint unsigned NOT NULL auto_increment,

Zeile 1013Zeile 1021
  stars smallint(4) NOT NULL default '0',
starimage varchar(120) NOT NULL default '',
PRIMARY KEY (utid)

  stars smallint(4) NOT NULL default '0',
starimage varchar(120) NOT NULL default '',
PRIMARY KEY (utid)

) TYPE=MyISAM;";

) ENGINE=MyISAM;";


$tables[] = "CREATE TABLE mybb_warninglevels (
lid int unsigned NOT NULL auto_increment,
percentage int(3) NOT NULL default '0',
action text NOT NULL,
PRIMARY KEY (lid)


$tables[] = "CREATE TABLE mybb_warninglevels (
lid int unsigned NOT NULL auto_increment,
percentage int(3) NOT NULL default '0',
action text NOT NULL,
PRIMARY KEY (lid)

) TYPE=MyISAM;";

) ENGINE=MyISAM;";


$tables[] = "CREATE TABLE mybb_warningtypes (
tid int unsigned NOT NULL auto_increment,


$tables[] = "CREATE TABLE mybb_warningtypes (
tid int unsigned NOT NULL auto_increment,

Zeile 1028Zeile 1036
	points int unsigned NOT NULL default '0',
expirationtime bigint(30) NOT NULL default '0',
PRIMARY KEY (tid)

	points int unsigned NOT NULL default '0',
expirationtime bigint(30) NOT NULL default '0',
PRIMARY KEY (tid)

) TYPE=MyISAM;";

) ENGINE=MyISAM;";


$tables[] = "CREATE TABLE mybb_warnings (
wid int unsigned NOT NULL auto_increment,


$tables[] = "CREATE TABLE mybb_warnings (
wid int unsigned NOT NULL auto_increment,

Zeile 1046Zeile 1054
	revokereason text NOT NULL,
notes text NOT NULL,
PRIMARY KEY (wid)

	revokereason text NOT NULL,
notes text NOT NULL,
PRIMARY KEY (wid)

) TYPE=MyISAM;";

) ENGINE=MyISAM;";


?>


?>