CREATE TABLE IF NOT EXISTS `cat` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL,
  `mesto` int(11) NOT NULL,
  `ico` varchar(255) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT EXISTS `comments` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(30) NOT NULL,
  `comment` varchar(500) NOT NULL,
  `ip` varchar(100) NOT NULL,
  `brauser` varchar(100) NOT NULL,
  `time` int(11) NOT NULL,
  `game` int(11) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;


CREATE TABLE IF NOT EXISTS `file` (
  `id` int(11) NOT NULL auto_increment,
  `game` varchar(255) NOT NULL,
  `file` varchar(255) NOT NULL,
  `desc` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT EXISTS `game` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL,
  `count` int(11) NOT NULL,
  `desc` longtext NOT NULL,
  `cat` int(11) NOT NULL,
  `time` int(11) NOT NULL,
  `eload` int(11) NOT NULL,
  `ratep` int(11) NOT NULL,
  `ratem` int(11) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;


CREATE TABLE IF NOT EXISTS `gb` (
  `id` int(11) NOT NULL auto_increment,
  `msg` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `ip` varchar(255) NOT NULL,
  `brauser` varchar(255) NOT NULL,
  `time` varchar(255) NOT NULL,
  `answer` varchar(255) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT EXISTS `gb_admin` (
  `id` int(11) NOT NULL auto_increment,
  `link` varchar(255) NOT NULL,
  `num` varchar(255) NOT NULL,
  `smiles` varchar(255) NOT NULL,
  `antimat` varchar(255) NOT NULL,
  `status` varchar(255) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;


INSERT INTO `gb_admin` (`id`, `link`, `num`, `smiles`, `antimat`, `status`) VALUES
(1, '192.168.7.254', '7', '1', '1', '1');

CREATE TABLE IF NOT EXISTS `gb_ban` (
  `id` int(11) NOT NULL auto_increment,
  `ip` varchar(255) NOT NULL,
  `agent` varchar(255) NOT NULL,
  `time` varchar(255) NOT NULL,
  `p` varchar(255) NOT NULL,
  `ban` varchar(255) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT EXISTS `news` (
  `id` int(11) NOT NULL auto_increment,
  `time` varchar(255) NOT NULL,
  `news` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;

CREATE TABLE IF NOT EXISTS `rate` (
  `id` int(11) NOT NULL auto_increment,
  `rate` text NOT NULL,
  `ip` text NOT NULL,
  `game` int(11) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;

CREATE TABLE IF NOT EXISTS `rek_link` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL,
  `link` varchar(255) NOT NULL,
  `time` varchar(255) NOT NULL,
  `color` text NOT NULL,
  `mesto` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2;


CREATE TABLE IF NOT EXISTS `rek_logs` (
  `id` int(11) NOT NULL auto_increment,
  `browser` varchar(255) NOT NULL,
  `ip` varchar(255) NOT NULL,
  `operator` varchar(255) NOT NULL,
  `data` varchar(255) NOT NULL,
  `count` varchar(255) NOT NULL,
  `link_id` varchar(255) NOT NULL,
  `date` varchar(255) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2;


CREATE TABLE IF NOT EXISTS `screen` (
  `id` int(11) NOT NULL auto_increment,
  `url` varchar(255) NOT NULL,
  `game` int(11) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT EXISTS `settings` (
  `id` int(11) NOT NULL auto_increment,
  `num` varchar(11) NOT NULL,
  `time_new` varchar(11) NOT NULL,
  `copy` varchar(255) NOT NULL,
  `min_num_comment` varchar(255) NOT NULL,
  `max_num_comment` varchar(255) NOT NULL default '500',
  `min_num_name` varchar(255) NOT NULL default '3',
  `max_num_name` varchar(255) NOT NULL default '25',
  `errorrekl` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

INSERT INTO `settings` (`id`, `num`, `time_new`, `copy`, `min_num_comment`, `max_num_comment`, `min_num_name`, `max_num_name`, `errorrekl`) VALUES
(1, '5', '86400', 'localhost', '5', '500', '25', '25', 'http://localhost');

CREATE TABLE IF NOT EXISTS `smiles` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(11) NOT NULL,
  `smile` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC AUTO_INCREMENT=25 ;

INSERT INTO `smiles` (`id`, `name`, `smile`) VALUES
(1, ':)', ').gif'),
(2, ':(', '(.gif'),
(3, ':D', 'D.gif'),
(4, ':Q', '23.gif'),
(5, ':X', '24.gif'),
(6, ':-|', '25.gif'),
(7, ':R', '26.gif'),
(8, ':F', '28.gif'),
(9, ':Z', '29.gif'),
(10, ':-Z', '30.gif'),
(11, ':?', '31.gif'),
(12, ':@', '32.gif'),
(13, ';/', '33.gif'),
(14, ';/', '34.gif'),
(15, '%)', '35.gif'),
(16, '%(', '36.gif'),
(17, '%-(', '37.gif'),
(18, '%]', '38.gif'),
(19, '%O', '39.gif'),
(20, ':hack:', '40.gif'),
(21, ':happy:', '41.gif'),
(22, ':heart:', '42.gif'),
(23, ':hello:', '43.gif'),
(24, 'sps', 'sps.gif');