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

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

 */

$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 54Zeile 54
	perpage int(4) NOT NULL default '0',
view_type varchar(6) NOT NULL default '',
PRIMARY KEY(vid)

	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 69
  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 88
  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 98
  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 109
  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 125
  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 140
  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 156
  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 165
  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 173
  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 191
  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 211
  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 233
  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 279
  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 287
  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 295
  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 304
  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 316
  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 327
  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 335
  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 345
  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 363
	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 376
  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 390
	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 400
	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 412
  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 427Zeile 427
  canmovetononmodforum int(1) NOT NULL default '0',
KEY uid (id, fid),
PRIMARY KEY (mid)

  canmovetononmodforum int(1) NOT NULL default '0',
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 438
	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 449
  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 465Zeile 465
  multiple int(1) NOT NULL default '0',
public int(1) NOT NULL default '0',
PRIMARY KEY (pid)

  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 475
  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 502
  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 526
  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 541Zeile 541
  editable int(1) NOT NULL default '0',
hidden int(1) NOT NULL default '0',
PRIMARY KEY (fid)

  editable int(1) NOT NULL default '0',
hidden int(1) NOT NULL default '0',
PRIMARY KEY (fid)

) TYPE=MyISAM;";

) ENGINE=MyISAM;";



$tables[] = "CREATE TABLE mybb_promotions (



$tables[] = "CREATE TABLE mybb_promotions (

Zeile 563Zeile 563
  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 574
  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 588
  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 602
  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 615
  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 634
  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 644
  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 658
  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 669
  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 680
	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 688
	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 706
	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 714
	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 732
  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 750
  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 761
	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 770
	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 780
  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 819
  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 827
  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 839
  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 847
  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 914Zeile 914
  maxwarningsday int(3) NOT NULL default '3',
canmodcp int(1) NOT NULL default '0',
PRIMARY KEY (gid)

  maxwarningsday int(3) NOT NULL default '3',
canmodcp int(1) NOT NULL default '0',
PRIMARY KEY (gid)

) TYPE=MyISAM;";

) ENGINE=MyISAM;";



$tables[] = "CREATE TABLE mybb_users (



$tables[] = "CREATE TABLE mybb_users (

Zeile 1004Zeile 1004
  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 1013
  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 1028
	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 1046
	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;";


?>


?>