Vergleich install/resources/mysql_db_tables.php - 1.8.0 - 1.8.18

  Keine Änderungen   Hinzugefügt   Modifiziert   Entfernt
Zeile 29Zeile 29
  defaultviews text NOT NULL,
loginattempts smallint unsigned NOT NULL default '0',
loginlockoutexpiry int unsigned NOT NULL default '0',

  defaultviews text NOT NULL,
loginattempts smallint unsigned NOT NULL default '0',
loginlockoutexpiry int unsigned NOT NULL default '0',

 
  authsecret varchar(16) NOT NULL default '',
recovery_codes varchar(177) NOT NULL default '',

  PRIMARY KEY (uid)
) ENGINE=MyISAM;";


  PRIMARY KEY (uid)
) ENGINE=MyISAM;";


Zeile 40Zeile 42
  dateline int unsigned NOT NULL default '0',
lastactive int unsigned NOT NULL default '0',
data TEXT NOT NULL,

  dateline int unsigned NOT NULL default '0',
lastactive int unsigned NOT NULL default '0',
data TEXT NOT NULL,

  useragent varchar(100) NOT NULL default ''


  useragent varchar(200) NOT NULL default '',
authenticated tinyint(1) NOT NULL default '0'

) ENGINE=MyISAM;";

$tables[] = "CREATE TABLE mybb_adminviews (

) ENGINE=MyISAM;";

$tables[] = "CREATE TABLE mybb_adminviews (

Zeile 54Zeile 57
	custom_profile_fields text NOT NULL,
sortby varchar(20) NOT NULL default '',
sortorder varchar(4) NOT NULL default '',

	custom_profile_fields text NOT NULL,
sortby varchar(20) NOT NULL default '',
sortorder varchar(4) NOT NULL default '',

	perpage smallint(4) NOT NULL default '0',

	perpage smallint(4) unsigned NOT NULL default '0',

	view_type varchar(6) NOT NULL default '',
PRIMARY KEY (vid)
) ENGINE=MyISAM;";

	view_type varchar(6) NOT NULL default '',
PRIMARY KEY (vid)
) ENGINE=MyISAM;";

Zeile 81Zeile 84
  uid int unsigned NOT NULL default '0',
filename varchar(120) NOT NULL default '',
filetype varchar(120) NOT NULL default '',

  uid int unsigned NOT NULL default '0',
filename varchar(120) NOT NULL default '',
filetype varchar(120) NOT NULL default '',

  filesize int(10) NOT NULL default '0',

  filesize int(10) unsigned NOT NULL default '0',

  attachname varchar(120) NOT NULL default '',
downloads int unsigned NOT NULL default '0',
dateuploaded int unsigned NOT NULL default '0',

  attachname varchar(120) NOT NULL default '',
downloads int unsigned NOT NULL default '0',
dateuploaded int unsigned NOT NULL default '0',

Zeile 97Zeile 100
  name varchar(120) NOT NULL default '',
mimetype varchar(120) NOT NULL default '',
extension varchar(10) NOT NULL default '',

  name varchar(120) NOT NULL default '',
mimetype varchar(120) NOT NULL default '',
extension varchar(10) NOT NULL default '',

  maxsize int(15) NOT NULL default '0',

  maxsize int(15) unsigned NOT NULL default '0',

  icon varchar(100) NOT NULL default '',

  icon varchar(100) NOT NULL default '',

 
  enabled tinyint(1) NOT NULL default '1',
`groups` TEXT NOT NULL,
forums TEXT NOT NULL,
avatarfile tinyint(1) NOT NULL default '0',

  PRIMARY KEY (atid)
) ENGINE=MyISAM;";

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

  PRIMARY KEY (atid)
) ENGINE=MyISAM;";

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

  uid int unsigned NOT NULL default '0',

  uid int unsigned NOT NULL default '0',

  dateline int unsigned NOT NULL default '0',
code varchar(100) NOT NULL default '',
type char(1) NOT NULL default '',

  dateline int unsigned NOT NULL default '0',
code varchar(100) NOT NULL default '',
type char(1) NOT NULL default '',

Zeile 116Zeile 123
$tables[] = "CREATE TABLE mybb_badwords (
bid int unsigned NOT NULL auto_increment,
badword varchar(100) NOT NULL default '',

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

 
  regex tinyint(1) NOT NULL default '0',

  replacement varchar(100) NOT NULL default '',
PRIMARY KEY (bid)
) ENGINE=MyISAM;";

  replacement varchar(100) NOT NULL default '',
PRIMARY KEY (bid)
) ENGINE=MyISAM;";

Zeile 135Zeile 143
  gid int unsigned NOT NULL default '0',
oldgroup int unsigned NOT NULL default '0',
oldadditionalgroups text NOT NULL,

  gid int unsigned NOT NULL default '0',
oldgroup int unsigned NOT NULL default '0',
oldadditionalgroups text NOT NULL,

  olddisplaygroup int NOT NULL default '0',

  olddisplaygroup int unsigned NOT NULL default '0',

  admin int unsigned NOT NULL default '0',
dateline int unsigned NOT NULL default '0',
bantime varchar(50) NOT NULL default '',

  admin int unsigned NOT NULL default '0',
dateline int unsigned NOT NULL default '0',
bantime varchar(50) NOT NULL default '',

Zeile 146Zeile 154
) ENGINE=MyISAM;";

$tables[] = "CREATE TABLE mybb_buddyrequests (

) ENGINE=MyISAM;";

$tables[] = "CREATE TABLE mybb_buddyrequests (

 id int(10) UNSIGNED NOT NULL auto_increment,
uid bigint(30) UNSIGNED NOT NULL,
touid bigint(30) UNSIGNED NOT NULL,
date int(11) UNSIGNED NOT NULL,
KEY (uid),
KEY (touid),
PRIMARY KEY (id)

  id int(10) unsigned NOT NULL auto_increment,
uid int unsigned NOT NULL default '0',
touid int unsigned NOT NULL default '0',
date int unsigned NOT NULL default '0',
KEY (uid),
KEY (touid),
PRIMARY KEY (id)

) ENGINE=MyISAM;";

$tables[] = "CREATE TABLE mybb_calendars (

) ENGINE=MyISAM;";

$tables[] = "CREATE TABLE mybb_calendars (

Zeile 161Zeile 169
  disporder smallint unsigned NOT NULL default '0',
startofweek tinyint(1) NOT NULL default '0',
showbirthdays tinyint(1) NOT NULL default '0',

  disporder smallint unsigned NOT NULL default '0',
startofweek tinyint(1) NOT NULL default '0',
showbirthdays tinyint(1) NOT NULL default '0',

  eventlimit smallint(3) NOT NULL default '0',

  eventlimit smallint(3) unsigned NOT NULL default '0',

  moderation tinyint(1) NOT NULL default '0',
allowhtml tinyint(1) NOT NULL default '0',
allowmycode tinyint(1) NOT NULL default '0',

  moderation tinyint(1) NOT NULL default '0',
allowhtml tinyint(1) NOT NULL default '0',
allowmycode tinyint(1) NOT NULL default '0',

Zeile 245Zeile 253
  candeleteposts tinyint(1) NOT NULL default '0',
candeletethreads tinyint(1) NOT NULL default '0',
caneditattachments tinyint(1) NOT NULL default '0',

  candeleteposts tinyint(1) NOT NULL default '0',
candeletethreads tinyint(1) NOT NULL default '0',
caneditattachments tinyint(1) NOT NULL default '0',

 
  canviewdeletionnotice tinyint(1) NOT NULL default '0',

  modposts tinyint(1) NOT NULL default '0',
modthreads tinyint(1) NOT NULL default '0',
mod_edit_posts tinyint(1) NOT NULL default '0',

  modposts tinyint(1) NOT NULL default '0',
modthreads tinyint(1) NOT NULL default '0',
mod_edit_posts tinyint(1) NOT NULL default '0',

Zeile 311Zeile 320

$tables[] = "CREATE TABLE mybb_forumsubscriptions (
fsid int unsigned NOT NULL auto_increment,


$tables[] = "CREATE TABLE mybb_forumsubscriptions (
fsid int unsigned NOT NULL auto_increment,

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

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

  PRIMARY KEY (fsid)
) ENGINE=MyISAM;";


  PRIMARY KEY (fsid)
) ENGINE=MyISAM;";


Zeile 330Zeile 339
$tables[] = "CREATE TABLE mybb_helpdocs (
hid smallint unsigned NOT NULL auto_increment,
sid smallint unsigned NOT NULL default '0',

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

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

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

  document text NOT NULL,
usetranslation tinyint(1) NOT NULL default '0',
enabled tinyint(1) NOT NULL default '0',

  document text NOT NULL,
usetranslation tinyint(1) NOT NULL default '0',
enabled tinyint(1) NOT NULL default '0',

Zeile 347Zeile 356
  enabled tinyint(1) NOT NULL default '0',
disporder smallint unsigned NOT NULL default '0',
PRIMARY KEY (sid)

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

) ENGINE=MyISAM;";


) ENGINE=MyISAM;";


$tables[] = "CREATE TABLE mybb_icons (
iid smallint unsigned NOT NULL auto_increment,
name varchar(120) NOT NULL default '',

$tables[] = "CREATE TABLE mybb_icons (
iid smallint unsigned NOT NULL auto_increment,
name varchar(120) NOT NULL default '',

Zeile 380Zeile 389
	sentcount int unsigned NOT NULL default '0',
totalcount int unsigned NOT NULL default '0',
conditions text NOT NULL,

	sentcount int unsigned NOT NULL default '0',
totalcount int unsigned NOT NULL default '0',
conditions text NOT NULL,

	perpage smallint(4) NOT NULL default '50',
PRIMARY KEY (mid)
) ENGINE=MyISAM;";


	perpage smallint(4) unsigned NOT NULL default '50',
PRIMARY KEY (mid)
) ENGINE=MyISAM;";


$tables[] = "CREATE TABLE mybb_mailerrors (
eid int unsigned NOT NULL auto_increment,
subject varchar(200) NOT NULL default '',

$tables[] = "CREATE TABLE mybb_mailerrors (
eid int unsigned NOT NULL auto_increment,
subject varchar(200) NOT NULL default '',

Zeile 473Zeile 482
	name varchar(200) NOT NULL,
description text NOT NULL,
forums text NOT NULL,

	name varchar(200) NOT NULL,
description text NOT NULL,
forums text NOT NULL,

	groups text NOT NULL,

	`groups` text NOT NULL,

	type char(1) NOT NULL default '',
postoptions text NOT NULL,
threadoptions text NOT NULL,

	type char(1) NOT NULL default '',
postoptions text NOT NULL,
threadoptions text NOT NULL,

Zeile 515Zeile 524
  uid int unsigned NOT NULL default '0',
voteoption smallint unsigned NOT NULL default '0',
dateline int unsigned NOT NULL default '0',

  uid int unsigned NOT NULL default '0',
voteoption smallint unsigned NOT NULL default '0',
dateline int unsigned NOT NULL default '0',

 
  ipaddress varbinary(16) NOT NULL default '',

  KEY pid (pid, uid),
PRIMARY KEY (vid)
) ENGINE=MyISAM;";

  KEY pid (pid, uid),
PRIMARY KEY (vid)
) ENGINE=MyISAM;";

Zeile 600Zeile 610
  description text NOT NULL,
enabled tinyint(1) NOT NULL default '1',
logging tinyint(1) NOT NULL default '0',

  description text NOT NULL,
enabled tinyint(1) NOT NULL default '1',
logging tinyint(1) NOT NULL default '0',

  posts int NOT NULL default '0',

  posts int unsigned NOT NULL default '0',

  posttype char(2) NOT NULL default '',

  posttype char(2) NOT NULL default '',

  threads int NOT NULL default '0',

  threads int unsigned NOT NULL default '0',

  threadtype char(2) NOT NULL default '',

  threadtype char(2) NOT NULL default '',

  registered int NOT NULL default '0',

  registered int unsigned NOT NULL default '0',

  registeredtype varchar(20) NOT NULL default '',

  registeredtype varchar(20) NOT NULL default '',

  online int NOT NULL default '0',

  online int unsigned NOT NULL default '0',

  onlinetype varchar(20) NOT NULL default '',
reputations int NOT NULL default '0',
reputationtype char(2) NOT NULL default '',

  onlinetype varchar(20) NOT NULL default '',
reputations int NOT NULL default '0',
reputationtype char(2) NOT NULL default '',

  referrals int NOT NULL default '0',

  referrals int unsigned NOT NULL default '0',

  referralstype char(2) NOT NULL default '',

  referralstype char(2) NOT NULL default '',

  warnings int NOT NULL default '0',

  warnings int unsigned NOT NULL default '0',

  warningstype char(2) NOT NULL default '',
requirements varchar(200) NOT NULL default '',
originalusergroup varchar(120) NOT NULL default '0',
newusergroup smallint unsigned NOT NULL default '0',
usergrouptype varchar(120) NOT NULL default '0',
PRIMARY KEY (pid)

  warningstype char(2) NOT NULL default '',
requirements varchar(200) NOT NULL default '',
originalusergroup varchar(120) NOT NULL default '0',
newusergroup smallint unsigned NOT NULL default '0',
usergrouptype varchar(120) NOT NULL default '0',
PRIMARY KEY (pid)

) ENGINE=MyISAM;";


) ENGINE=MyISAM;";


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

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

Zeile 641Zeile 651
  incorrect int unsigned NOT NULL default 0,
active tinyint(1) NOT NULL default '0',
PRIMARY KEY (qid)

  incorrect int unsigned NOT NULL default 0,
active tinyint(1) NOT NULL default '0',
PRIMARY KEY (qid)

) ENGINE=MyISAM;";


) ENGINE=MyISAM;";


$tables[] = "CREATE TABLE mybb_questionsessions (
sid varchar(32) NOT NULL default '',
qid int unsigned NOT NULL default '0',

$tables[] = "CREATE TABLE mybb_questionsessions (
sid varchar(32) NOT NULL default '',
qid int unsigned NOT NULL default '0',

Zeile 657Zeile 667
  id3 int unsigned NOT NULL default '0',
uid int unsigned NOT NULL default '0',
reportstatus tinyint(1) NOT NULL default '0',

  id3 int unsigned NOT NULL default '0',
uid int unsigned NOT NULL default '0',
reportstatus tinyint(1) NOT NULL default '0',

 
  reasonid smallint unsigned NOT NULL default '0',

  reason varchar(250) NOT NULL default '',
type varchar(50) NOT NULL default '',
reports int unsigned NOT NULL default '0',

  reason varchar(250) NOT NULL default '',
type varchar(50) NOT NULL default '',
reports int unsigned NOT NULL default '0',

Zeile 665Zeile 676
  lastreport int unsigned NOT NULL default '0',
KEY reportstatus (reportstatus),
KEY lastreport (lastreport),

  lastreport int unsigned NOT NULL default '0',
KEY reportstatus (reportstatus),
KEY lastreport (lastreport),

 
  PRIMARY KEY (rid)
) ENGINE=MyISAM;";

$tables[] = "CREATE TABLE mybb_reportreasons (
rid int unsigned NOT NULL auto_increment,
title varchar(250) NOT NULL default '',
appliesto varchar(250) NOT NULL default '',
extra tinyint(1) NOT NULL default '0',
disporder smallint unsigned NOT NULL default '0',

  PRIMARY KEY (rid)
) ENGINE=MyISAM;";


  PRIMARY KEY (rid)
) ENGINE=MyISAM;";


Zeile 699Zeile 719
  ip varbinary(16) NOT NULL default '',
time int unsigned NOT NULL default '0',
location varchar(150) NOT NULL default '',

  ip varbinary(16) NOT NULL default '',
time int unsigned NOT NULL default '0',
location varchar(150) NOT NULL default '',

  useragent varchar(100) NOT NULL default '',

  useragent varchar(200) NOT NULL default '',

  anonymous tinyint(1) NOT NULL default '0',
nopermission tinyint(1) NOT NULL default '0',

  anonymous tinyint(1) NOT NULL default '0',
nopermission tinyint(1) NOT NULL default '0',

  location1 int(10) NOT NULL default '0',
location2 int(10) NOT NULL default '0',

  location1 int(10) unsigned NOT NULL default '0',
location2 int(10) unsigned NOT NULL default '0',

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

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

Zeile 854Zeile 874
	prefix varchar(120) NOT NULL default '',
displaystyle varchar(200) NOT NULL default '',
forums text NOT NULL,

	prefix varchar(120) NOT NULL default '',
displaystyle varchar(200) NOT NULL default '',
forums text NOT NULL,

	groups text NOT NULL,

	`groups` text NOT NULL,

	PRIMARY KEY (pid)
) ENGINE=MyISAM;";


	PRIMARY KEY (pid)
) ENGINE=MyISAM;";


Zeile 862Zeile 882
  rid int unsigned NOT NULL auto_increment,
tid int unsigned NOT NULL default '0',
uid int unsigned NOT NULL default '0',

  rid int unsigned NOT NULL auto_increment,
tid int unsigned NOT NULL default '0',
uid int unsigned NOT NULL default '0',

  rating smallint unsigned NOT NULL default '0',

  rating tinyint(1) unsigned NOT NULL default '0',

  ipaddress varbinary(16) NOT NULL default '',
KEY tid (tid, uid),
PRIMARY KEY (rid)

  ipaddress varbinary(16) NOT NULL default '',
KEY tid (tid, uid),
PRIMARY KEY (rid)

Zeile 887Zeile 907
  lastpost int unsigned NOT NULL default '0',
lastposter varchar(120) NOT NULL default '',
lastposteruid int unsigned NOT NULL default '0',

  lastpost int unsigned NOT NULL default '0',
lastposter varchar(120) NOT NULL default '',
lastposteruid int unsigned NOT NULL default '0',

  views int(100) NOT NULL default '0',
replies int(100) NOT NULL default '0',

  views int(100) unsigned NOT NULL default '0',
replies int(100) unsigned NOT NULL default '0',

  closed varchar(30) NOT NULL default '',
sticky tinyint(1) NOT NULL default '0',
numratings smallint unsigned NOT NULL default '0',

  closed varchar(30) NOT NULL default '',
sticky tinyint(1) NOT NULL default '0',
numratings smallint unsigned NOT NULL default '0',

Zeile 921Zeile 941
  tid int unsigned NOT NULL default '0',
notification tinyint(1) NOT NULL default '0',
dateline int unsigned NOT NULL default '0',

  tid int unsigned NOT NULL default '0',
notification tinyint(1) NOT NULL default '0',
dateline int unsigned NOT NULL default '0',

  subscriptionkey varchar(32) NOT NULL default '',

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

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

Zeile 937Zeile 956

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


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

  type smallint(2) NOT NULL default '2',

  type tinyint(1) unsigned NOT NULL default '2',

  title varchar(120) NOT NULL default '',
description text NOT NULL,
namestyle varchar(200) NOT NULL default '{username}',
usertitle varchar(120) NOT NULL default '',

  title varchar(120) NOT NULL default '',
description text NOT NULL,
namestyle varchar(200) NOT NULL default '{username}',
usertitle varchar(120) NOT NULL default '',

  stars smallint(4) NOT NULL default '0',

  stars smallint(4) unsigned NOT NULL default '0',

  starimage varchar(120) NOT NULL default '',
image varchar(120) NOT NULL default '',
disporder smallint(6) unsigned NOT NULL,

  starimage varchar(120) NOT NULL default '',
image varchar(120) NOT NULL default '',
disporder smallint(6) unsigned NOT NULL,

Zeile 964Zeile 983
  candeleteposts tinyint(1) NOT NULL default '0',
candeletethreads tinyint(1) NOT NULL default '0',
caneditattachments tinyint(1) NOT NULL default '0',

  candeleteposts tinyint(1) NOT NULL default '0',
candeletethreads tinyint(1) NOT NULL default '0',
caneditattachments tinyint(1) NOT NULL default '0',

 
  canviewdeletionnotice tinyint(1) NOT NULL default '0',

  canpostpolls tinyint(1) NOT NULL default '0',
canvotepolls tinyint(1) NOT NULL default '0',
canundovotes tinyint(1) NOT NULL default '0',

  canpostpolls tinyint(1) NOT NULL default '0',
canvotepolls tinyint(1) NOT NULL default '0',
canundovotes tinyint(1) NOT NULL default '0',

Zeile 971Zeile 991
  cansendpms tinyint(1) NOT NULL default '0',
cantrackpms tinyint(1) NOT NULL default '0',
candenypmreceipts tinyint(1) NOT NULL default '0',

  cansendpms tinyint(1) NOT NULL default '0',
cantrackpms tinyint(1) NOT NULL default '0',
candenypmreceipts tinyint(1) NOT NULL default '0',

  pmquota int(3) NOT NULL default '0',
maxpmrecipients int(4) NOT NULL default '5',

  pmquota int(3) unsigned NOT NULL default '0',
maxpmrecipients int(4) unsigned NOT NULL default '5',

  cansendemail tinyint(1) NOT NULL default '0',
cansendemailoverride tinyint(1) NOT NULL default '0',

  cansendemail tinyint(1) NOT NULL default '0',
cansendemailoverride tinyint(1) NOT NULL default '0',

  maxemails int(3) NOT NULL default '5',
emailfloodtime int(3) NOT NULL default '5',

  maxemails int(3) unsigned NOT NULL default '5',
emailfloodtime int(3) unsigned NOT NULL default '5',

  canviewmemberlist tinyint(1) NOT NULL default '0',
canviewcalendar tinyint(1) NOT NULL default '0',
canaddevents tinyint(1) NOT NULL default '0',

  canviewmemberlist tinyint(1) NOT NULL default '0',
canviewcalendar tinyint(1) NOT NULL default '0',
canaddevents tinyint(1) NOT NULL default '0',

Zeile 997Zeile 1017
  showforumteam tinyint(1) NOT NULL default '0',
usereputationsystem tinyint(1) NOT NULL default '0',
cangivereputations tinyint(1) NOT NULL default '0',

  showforumteam tinyint(1) NOT NULL default '0',
usereputationsystem tinyint(1) NOT NULL default '0',
cangivereputations tinyint(1) NOT NULL default '0',

 
  candeletereputations tinyint(1) NOT NULL default '0',

  reputationpower int unsigned NOT NULL default '0',
maxreputationsday int unsigned NOT NULL default '0',
maxreputationsperuser int unsigned NOT NULL default '0',

  reputationpower int unsigned NOT NULL default '0',
maxreputationsday int unsigned NOT NULL default '0',
maxreputationsperuser int unsigned NOT NULL default '0',

Zeile 1006Zeile 1027
  cancustomtitle tinyint(1) NOT NULL default '0',
canwarnusers tinyint(1) NOT NULL default '0',
canreceivewarnings tinyint(1) NOT NULL default '0',

  cancustomtitle tinyint(1) NOT NULL default '0',
canwarnusers tinyint(1) NOT NULL default '0',
canreceivewarnings tinyint(1) NOT NULL default '0',

  maxwarningsday int(3) NOT NULL default '3',

  maxwarningsday int(3) unsigned NOT NULL default '3',

  canmodcp tinyint(1) NOT NULL default '0',
showinbirthdaylist tinyint(1) NOT NULL default '0',
canoverridepm tinyint(1) NOT NULL default '0',
canusesig tinyint(1) NOT NULL default '0',
canusesigxposts smallint unsigned NOT NULL default '0',
signofollow tinyint(1) NOT NULL default '0',

  canmodcp tinyint(1) NOT NULL default '0',
showinbirthdaylist tinyint(1) NOT NULL default '0',
canoverridepm tinyint(1) NOT NULL default '0',
canusesig tinyint(1) NOT NULL default '0',
canusesigxposts smallint unsigned NOT NULL default '0',
signofollow tinyint(1) NOT NULL default '0',

  edittimelimit int(4) NOT NULL default '0',
maxposts int(4) NOT NULL default '0',

  edittimelimit int(4) unsigned NOT NULL default '0',
maxposts int(4) unsigned NOT NULL default '0',

  showmemberlist tinyint(1) NOT NULL default '1',
canmanageannounce tinyint(1) NOT NULL default '0',
canmanagemodqueue tinyint(1) NOT NULL default '0',

  showmemberlist tinyint(1) NOT NULL default '1',
canmanageannounce tinyint(1) NOT NULL default '0',
canmanagemodqueue tinyint(1) NOT NULL default '0',

Zeile 1034Zeile 1055
  salt varchar(10) NOT NULL default '',
loginkey varchar(50) NOT NULL default '',
email varchar(220) NOT NULL default '',

  salt varchar(10) NOT NULL default '',
loginkey varchar(50) NOT NULL default '',
email varchar(220) NOT NULL default '',

  postnum int(10) NOT NULL default '0',
threadnum int(10) NOT NULL default '0',

  postnum int(10) unsigned NOT NULL default '0',
threadnum int(10) unsigned NOT NULL default '0',

  avatar varchar(200) NOT NULL default '',
avatardimensions varchar(10) NOT NULL default '',
avatartype varchar(10) NOT NULL default '0',

  avatar varchar(200) NOT NULL default '',
avatardimensions varchar(10) NOT NULL default '',
avatartype varchar(10) NOT NULL default '0',

Zeile 1049Zeile 1070
  lastpost int unsigned NOT NULL default '0',
website varchar(200) NOT NULL default '',
icq varchar(10) NOT NULL default '',

  lastpost int unsigned NOT NULL default '0',
website varchar(200) NOT NULL default '',
icq varchar(10) NOT NULL default '',

  aim varchar(50) NOT NULL default '',

 
  yahoo varchar(50) NOT NULL default '',
skype varchar(75) NOT NULL default '',
google varchar(75) NOT NULL default '',

  yahoo varchar(50) NOT NULL default '',
skype varchar(75) NOT NULL default '',
google varchar(75) NOT NULL default '',

Zeile 1073Zeile 1093
  showavatars tinyint(1) NOT NULL default '0',
showquickreply tinyint(1) NOT NULL default '0',
showredirect tinyint(1) NOT NULL default '0',

  showavatars tinyint(1) NOT NULL default '0',
showquickreply tinyint(1) NOT NULL default '0',
showredirect tinyint(1) NOT NULL default '0',

  ppp smallint(6) NOT NULL default '0',
tpp smallint(6) NOT NULL default '0',
daysprune smallint(6) NOT NULL default '0',

  ppp smallint(6) unsigned NOT NULL default '0',
tpp smallint(6) unsigned NOT NULL default '0',
daysprune smallint(6) unsigned NOT NULL default '0',

  dateformat varchar(4) NOT NULL default '',
timeformat varchar(4) NOT NULL default '',
timezone varchar(5) NOT NULL default '',

  dateformat varchar(4) NOT NULL default '',
timeformat varchar(4) NOT NULL default '',
timezone varchar(5) NOT NULL default '',

Zeile 1098Zeile 1118
  language varchar(50) NOT NULL default '',
timeonline int unsigned NOT NULL default '0',
showcodebuttons tinyint(1) NOT NULL default '1',

  language varchar(50) NOT NULL default '',
timeonline int unsigned NOT NULL default '0',
showcodebuttons tinyint(1) NOT NULL default '1',

  totalpms int(10) NOT NULL default '0',
unreadpms int(10) NOT NULL default '0',
warningpoints int(3) NOT NULL default '0',

  totalpms int(10) unsigned NOT NULL default '0',
unreadpms int(10) unsigned NOT NULL default '0',
warningpoints int(3) unsigned NOT NULL default '0',

  moderateposts tinyint(1) NOT NULL default '0',
moderationtime int unsigned NOT NULL default '0',
suspendposting tinyint(1) NOT NULL default '0',

  moderateposts tinyint(1) NOT NULL default '0',
moderationtime int unsigned NOT NULL default '0',
suspendposting tinyint(1) NOT NULL default '0',

Zeile 1109Zeile 1129
  suspendsigtime int unsigned NOT NULL default '0',
coppauser tinyint(1) NOT NULL default '0',
classicpostbit tinyint(1) NOT NULL default '0',

  suspendsigtime int unsigned NOT NULL default '0',
coppauser tinyint(1) NOT NULL default '0',
classicpostbit tinyint(1) NOT NULL default '0',

  loginattempts tinyint(2) NOT NULL default '1',


  loginattempts smallint(2) unsigned NOT NULL default '0',
loginlockoutexpiry int unsigned NOT NULL default '0',

  usernotes text NOT NULL,
sourceeditor tinyint(1) NOT NULL default '0',
UNIQUE KEY username (username),

  usernotes text NOT NULL,
sourceeditor tinyint(1) NOT NULL default '0',
UNIQUE KEY username (username),

Zeile 1123Zeile 1144
  utid smallint unsigned NOT NULL auto_increment,
posts int unsigned NOT NULL default '0',
title varchar(250) NOT NULL default '',

  utid smallint unsigned NOT NULL auto_increment,
posts int unsigned NOT NULL default '0',
title varchar(250) NOT NULL default '',

  stars smallint(4) NOT NULL default '0',

  stars smallint(4) unsigned NOT NULL default '0',

  starimage varchar(120) NOT NULL default '',
PRIMARY KEY (utid)
) ENGINE=MyISAM;";

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

  starimage varchar(120) NOT NULL default '',
PRIMARY KEY (utid)
) ENGINE=MyISAM;";

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

	percentage smallint(3) NOT NULL default '0',

	percentage smallint(3) unsigned NOT NULL default '0',

	action text NOT NULL,
PRIMARY KEY (lid)
) ENGINE=MyISAM;";

	action text NOT NULL,
PRIMARY KEY (lid)
) ENGINE=MyISAM;";