ALTER TABLE `$table_settings` ADD `ads` set('on','off') NOT NULL default 'on';
DROP TABLE IF EXISTS `$table_adrecord`;
CREATE TABLE `$table_adrecord` (
  `rid` int(100) NOT NULL auto_increment,
  `aid` int(100) NOT NULL default '0',
  `time` int(100) NOT NULL default '0',
  `browser` varchar(100) NOT NULL default '',
  `os` varchar(100) NOT NULL default '',
  UNIQUE KEY `rid` (`rid`)
) TYPE=MyISAM PACK_KEYS=1;

DROP TABLE IF EXISTS `$table_ads`;
CREATE TABLE `$table_ads` (
  `aid` int(100) NOT NULL auto_increment,
  `name` text NOT NULL,
  `url` text NOT NULL,
  `img` text NOT NULL,
  `adoption` tinyint(1) NOT NULL default '1',
  UNIQUE KEY `aid` (`aid`)
) TYPE=MyISAM;