View file guest/guest.sql

CREATE TABLE IF NOT EXISTS `bans` (
  `id` int(11) NOT NULL auto_increment,
  `ip` varchar(50) NOT NULL,
  `agent` varchar(300) NOT NULL,
  primary key (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `flood` (
  `id` int(11) NOT NULL auto_increment,
  `ip` varchar(50) NOT NULL,
  `ua` varchar(300) NOT NULL,
  `time` int(11) NOT NULL,
  primary key (`id`)

) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `guest` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(20) NOT NULL,
  `mail` varchar(50) NOT NULL,
  `msg` text NOT NULL,
  `ua` varchar(100) NOT NULL,
  `ip` varchar(30) NOT NULL,
  `dt` varchar(20) NOT NULL,
  `otvet` varchar(255) NOT NULL,
  primary key (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `setting` (
  `copy` varchar(40) NOT NULL,
  `home` varchar(40) NOT NULL,
  `str` int(3) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

INSERT INTO `setting` (`copy`, `home`, `str`) VALUES
('© SmartFan', 'http://gamelton.h1n.ru/guest/', 10);