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

Keine Änderungen Hinzugefügt Modifiziert Entfernt
Zeile 6	Zeile 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 17	Zeile 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 29	Zeile 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 39	Zeile 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 49	Zeile 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 69	Zeile 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 88	Zeile 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 98	Zeile 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 109	Zeile 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 125	Zeile 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 140	Zeile 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 156	Zeile 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 165	Zeile 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 173	Zeile 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 191	Zeile 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 211	Zeile 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 233	Zeile 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 279	Zeile 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 287	Zeile 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 295	Zeile 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 304	Zeile 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 316	Zeile 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 327	Zeile 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 335	Zeile 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 345	Zeile 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 363	Zeile 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 376	Zeile 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 390	Zeile 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 400	Zeile 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 412	Zeile 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 425	Zeile 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 438	Zeile 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 449	Zeile 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 465	Zeile 467
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 475	Zeile 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 502	Zeile 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 526	Zeile 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 540	Zeile 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 563	Zeile 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 574	Zeile 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 588	Zeile 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 602	Zeile 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 615	Zeile 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 634	Zeile 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 644	Zeile 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 658	Zeile 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 669	Zeile 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 680	Zeile 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 688	Zeile 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 706	Zeile 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 714	Zeile 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 732	Zeile 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 750	Zeile 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 761	Zeile 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 770	Zeile 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 780	Zeile 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 819	Zeile 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 827	Zeile 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 839	Zeile 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 847	Zeile 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 883	Zeile 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 913	Zeile 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 1004	Zeile 1013
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 1013	Zeile 1022
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 1028	Zeile 1037
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 1046	Zeile 1055
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;";
?>	?>