upgrade etmen senin için daha sağlıklı olacaktır
3.8.2 tabloları ekledim





whoread

CREATE TABLE IF NOT EXISTS `whoread` (
  `userid` int(10) unsigned NOT NULL default '0',
  `threadid` int(10) unsigned NOT NULL default '0',
  `dateline` int(10) unsigned NOT NULL default '0',
  `ipaddress` varchar(20) NOT NULL default '',
  PRIMARY KEY  (`userid`,`threadid`),
  KEY `dateline` (`threadid`,`dateline`),
  KEY `ipaddress` (`ipaddress`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

usercsscache

CREATE TABLE IF NOT EXISTS `usercsscache` (
  `userid` int(10) unsigned NOT NULL default '0',
  `cachedcss` text,
  `buildpermissions` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

upgradelog

CREATE TABLE IF NOT EXISTS `upgradelog` (
  `upgradelogid` int(10) unsigned NOT NULL auto_increment,
  `script` varchar(50) NOT NULL default '',
  `steptitle` varchar(250) NOT NULL default '',
  `step` smallint(5) unsigned NOT NULL default '0',
  `startat` int(10) unsigned NOT NULL default '0',
  `perpage` smallint(5) unsigned NOT NULL default '0',
  `dateline` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`upgradelogid`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=21 ;

useractivation

CREATE TABLE IF NOT EXISTS `useractivation` (
  `useractivationid` int(10) unsigned NOT NULL auto_increment,
  `userid` int(10) unsigned NOT NULL default '0',
  `dateline` int(10) unsigned NOT NULL default '0',
  `activationid` varchar(40) NOT NULL default '',
  `type` smallint(5) unsigned NOT NULL default '0',
  `usergroupid` smallint(5) unsigned NOT NULL default '0',
  `emailchange` smallint(5) unsigned NOT NULL default '0',
  PRIMARY KEY  (`useractivationid`),
  UNIQUE KEY `userid` (`userid`,`type`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

userban

CREATE TABLE IF NOT EXISTS `userban` (
  `userid` int(10) unsigned NOT NULL default '0',
  `usergroupid` smallint(5) unsigned NOT NULL default '0',
  `displaygroupid` smallint(5) unsigned NOT NULL default '0',
  `usertitle` varchar(250) NOT NULL default '',
  `customtitle` smallint(6) NOT NULL default '0',
  `adminid` int(10) unsigned NOT NULL default '0',
  `bandate` int(10) unsigned NOT NULL default '0',
  `liftdate` int(10) unsigned NOT NULL default '0',
  `reason` varchar(250) NOT NULL default '',
  PRIMARY KEY  (`userid`),
  KEY `liftdate` (`liftdate`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

userchangelog

CREATE TABLE IF NOT EXISTS `userchangelog` (
  `changeid` int(10) unsigned NOT NULL auto_increment,
  `userid` int(10) unsigned NOT NULL default '0',
  `fieldname` varchar(250) NOT NULL default '',
  `newvalue` varchar(250) NOT NULL default '',
  `oldvalue` varchar(250) NOT NULL default '',
  `adminid` int(10) unsigned NOT NULL default '0',
  `change_time` int(10) unsigned NOT NULL default '0',
  `change_uniq` varchar(32) NOT NULL default '',
  PRIMARY KEY  (`changeid`),
  KEY `userid` (`userid`,`change_time`),
  KEY `change_time` (`change_time`),
  KEY `change_uniq` (`change_uniq`),
  KEY `fieldname` (`fieldname`,`change_time`),
  KEY `adminid` (`adminid`,`change_time`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=16 ;

usercss

CREATE TABLE IF NOT EXISTS `usercss` (
  `userid` int(10) unsigned NOT NULL default '0',
  `selector` varchar(30) NOT NULL default '',
  `property` varchar(30) NOT NULL default '',
  `value` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`userid`,`selector`,`property`),
  KEY `property` (`property`,`userid`,`value`(20))
) ENGINE=MyISAM DEFAULT CHARSET=latin1;