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

  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 5428 2011-04-07 15:49:37Z 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 47Zeile 47
	title varchar(100) NOT NULL default '',
	type varchar(6) NOT NULL default '',
	visibility int(1) NOT NULL default '0',

 
	title varchar(100) NOT NULL default '',
	type varchar(6) NOT NULL default '',
	visibility int(1) NOT NULL default '0',

	`fields` text NOT NULL,

	fields text NOT NULL,

	conditions 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 427Zeile 428
  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 439
	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 450
  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 466
  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 476
  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 503
  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 527
  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 542
  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 564
  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 575
  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 589
  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 603
  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 616
  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 635
  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 645
  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 659
  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 670
  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 681
	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 689
	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 707
	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 715
	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 733
  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 751
  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 762
	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 771
	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 781
  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 820
  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 828
  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 840
  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 848
  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 915
  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 1005
  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 1014
  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 1029
	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 1047
	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;";


?>


?>