CREATE TABLE `ferma_guest` (
  `id` int(11) NOT NULL auto_increment,
  `adm` tinyint(1) NOT NULL default '0',
  `time` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `name` varchar(25) NOT NULL,
  `text` text NOT NULL,
  `ip` int(11) NOT NULL,
  `browser` tinytext NOT NULL,
  `admin` varchar(25) NOT NULL,
  `otvet` text NOT NULL,
  `otime` int(11) NOT NULL,
  `edit_who` varchar(20) NOT NULL,
  `edit_time` int(11) NOT NULL,
  `edit_count` tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `adm` (`adm`),
  KEY `time` (`time`),
  KEY `ip` (`ip`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


CREATE TABLE IF NOT EXISTS `ferma_config` (
  `id` int(11) NOT NULL auto_increment,
  `kurs` int(11) NOT NULL,
  `kurs2` int(11) NOT NULL,
  `cena_ferma` int(11) NOT NULL,
  `level_2` int(11) NOT NULL,
  `level_3` int(11) NOT NULL,
  `level_4` int(11) NOT NULL,
  `level_5` int(11) NOT NULL,
  `level_6` int(11) NOT NULL,
  `level_7` int(11) NOT NULL,
  `level_8` int(11) NOT NULL,
  `level_9` int(11) NOT NULL,
  `level_10` int(11) NOT NULL,
  `bonus` int(11) NOT NULL,
  KEY `id` (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
INSERT INTO `ferma_config` (  `id`,   `kurs`,   `kurs2`,   `cena_ferma`,   `level_2`,   `level_3`,   `level_4`,   `level_5`,   `level_6`,   `level_7`,   `level_8`,   `level_9`,   `level_10`,   `bonus`)
VALUES ('1', '20', '25', '50', '250', '500', '750', '1000', '1500', '2000', '2500', '5000', '10000', '1000');

CREATE TABLE IF NOT EXISTS `gratka` (
  `id` int(11) NOT NULL auto_increment,
  `ferma` int(11) NOT NULL,
  `name` text NOT NULL,
  `kol` int(11) NOT NULL,
  `date` int(11) NOT NULL,
  `date2` int(11) NOT NULL,
  `dohot` int(11) NOT NULL,
  `semid` int(11) NOT NULL,
  `vred` int(11) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT EXISTS `semena` (
  `id` int(11) NOT NULL auto_increment,
  `name` TEXT NOT NULL,
  `date` int(11) NOT NULL,
  `cena` int(11) NOT NULL default '0',
  `cena2` int(11) NOT NULL default '0',
  `level` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC AUTO_INCREMENT=41 ;


INSERT INTO `semena` (`id`, `name`, `date`, `cena`, `cena2`, `level`) VALUES
('1', 'Лук (Ботун)', '900', '10', '5', '1'),
('2', 'Укроп', '900', '15', '7', '1'),
('3', 'Петрушка', '900', '20', '10', '1'),
('4', 'Салат', '900', '20', '10', '1'),
('5', 'Редис', '1200', '25', '12', '2'),
('6', 'Горох', '1200', '30', '15', '2'),
('7', 'Бобы', '1200', '35', '17', '2'),
('8', 'Фасоль', '1200', '40', '20', '2'),
('9', 'Чеснок', '1800', '40', '20', '3'),
('10', 'Щавель', '1800', '45', '22', '3'),
('11', 'Репа', '1800', '50', '25', '3'),
('12', 'Редька', '1800', '55', '27', '3'),
('13', 'Огурцы', '2700', '60', '30', '4'),
('14', 'Морковь', '2700', '70', '35', '4'),
('15', 'Свекла', '2700', '80', '40', '4'),
('16', 'Лук (Репчетый)', '2700', '90', '45', '4'),
('17', 'Помидоры', '1800', '100', '50', '5'),
('18', 'Арбузы', '1800', '110', '55', '5'),
('19', 'Дыни', '1800', '120', '60', '5'),
('20', 'Кобачки', '1800', '125', '62', '5'),
('21', 'Картофель', '2700', '150', '75', '6'),
('22', 'Кукуруза', '2700', '170', '85', '6'),
('23', 'Артишоки', '2700', '180', '90', '1'),
('24', 'Перец', '2700', '200', '100', '6'),
('25', 'Пшеница', '3600', '300', '150', '7'),
('26', 'Овес', '3600', '350', '175', '7'),
('27', 'Гречиха', '3600', '400', '200', '7'),
('28', 'Рис', '3600', '500', '250', '7'),
('29', 'Виноград', '3600', '600', '300', '8'),
('30', 'Сливы', '3600', '500', '250', '8'),
('31', 'Вишня', '3600', '550', '275', '8'),
('32', 'Персики', '3600', '650', '325', '8'),
('33', 'Кокосы', '1800', '400', '200', '9'),
('34', 'Ананасы', '1800', '450', '225', '9'),
('35', 'Бананы', '1800', '500', '250', '9'),
('36', 'Гуава', '1800', '550', '275', '9'),
('37', 'Апельсины', '3600', '1000', '500', '10'),
('38', 'Грейтфрукт', '3600', '1300', '650', '10'),
('39', 'Мандарины', '3600', '1500', '750', '10'),
('40', 'Лимоны', '3600', '2000', '1000', '10'); 

CREATE TABLE IF NOT EXISTS `ferma` (
  `id` int(11) NOT NULL auto_increment,
  `user` int(11) NOT NULL,
  `name` text NOT NULL,
  `opyt` int(11) NOT NULL,
  `level` int(11) NOT NULL,
  `date` int(11) NOT NULL,
  `mesto` int(11) NOT NULL,
  `dohot` int(11) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT EXISTS `ferma_log` (
  `id` int(11) NOT NULL auto_increment,
  `ferma` int(11) NOT NULL,
  `tema` text NOT NULL,
  `mess` text NOT NULL,
  `level` int(11) NOT NULL,
  `date` int(11) NOT NULL,  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
ALTER TABLE `users` ADD `money` int(11) NOT NULL default '0'