
ALTER TABLE `user` ADD `fermer_money` int(11) NOT NULL default '1000';

ALTER TABLE `user` ADD `fermer_oput` int(11) NOT NULL default '0';

CREATE TABLE IF NOT EXISTS `fermer_gr` (
  `id` int(11) NOT NULL auto_increment,
  `id_user` int(11) NOT NULL,
  `semen` int(11) NOT NULL,
  `woter` int(11) NOT NULL default '0',
  `kol` varchar(1024) default NULL,
  `time` varchar(1024) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1036 ;

CREATE TABLE IF NOT EXISTS `fermer_dog` (
  `id` int(11) NOT NULL auto_increment,
  `id_user` int(11) NOT NULL,
  `time` varchar(1024) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1036 ;

CREATE TABLE IF NOT EXISTS `fermer_vor` (
  `id` int(11) NOT NULL auto_increment,
  `id_user` int(11) NOT NULL,
  `gr` int(11) default NULL,
  `time` varchar(1024) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1036 ;

CREATE TABLE IF NOT EXISTS `fermer_sclad` (
  `id` int(11) NOT NULL auto_increment,
  `id_user` int(11) NOT NULL,
  `semen` int(11) NOT NULL,
  `kol` int(11) NOT NULL,
  `time` varchar(1024) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1036 ;

CREATE TABLE IF NOT EXISTS `fermer_semen` (
  `id` int(11) NOT NULL auto_increment,
  `id_user` int(11) NOT NULL,
  `semen` int(11) NOT NULL,
  `kol` int(11) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1036 ;

CREATE TABLE IF NOT EXISTS `fermer_udobr` (
  `id` int(11) NOT NULL auto_increment,
  `id_user` int(11) NOT NULL,
  `udobr` int(11) NOT NULL,
  `kol` int(11) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1036 ;

CREATE TABLE IF NOT EXISTS `fermer_udobr_name` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `name` varchar(1024) NOT NULL,
  `cena` varchar(1024) NOT NULL,
  `time` varchar(1024) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 ;


INSERT INTO `fermer_udobr_name` (`id`, `name`, `cena`, `time`) VALUES
(1, 'Удобрение Простое', 50, 3600),
(2, 'Удобрение', 200, 14400),
(3, 'Супер Удобрение', 500, 18000),
(4, 'Секретное Удобрение', 1000, 36000);

CREATE TABLE IF NOT EXISTS `fermer_name` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `name` varchar(1024) NOT NULL,
  `cena` varchar(1024) NOT NULL,
  `dohod` varchar(1024) NOT NULL,
  `rand1` varchar(1024) NOT NULL,
  `rand2` varchar(1024) NOT NULL,
  `oput` varchar(1024) NOT NULL,
  `time` varchar(1024) default NULL,
  `level` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 ;

INSERT INTO `fermer_name` (`id`, `name`, `level`, `time`,`cena`,`dohod`,`rand1`,`rand2`,`oput`) VALUES
(1, 'Белая репа', 0, 18000, 150, 10, 15, 18, 20),
(2, 'Морковь', 0, 21600, 200, 15, 14, 16, 35),
(3, 'Кукуруза', 0, 36000, 500, 5, 100, 120, 50),
(4, 'Картофель', 0, 72000, 650, 13, 50, 55, 60),
(5, 'Баклажан', 0, 129600, 700, 35, 20, 25, 65),
(6, 'Помидор', 5, 172800, 800, 40, 20, 25, 70),
(7, 'Горох', 5, 172800, 850, 50, 17, 22, 75),
(8, 'Перец чили', 6, 216000, 900, 60, 15, 19, 80),
(9, 'Тыква', 6, 216000, 1000, 100, 10, 15, 100),
(10, 'Яблоко', 7, 259200, 1500, 20, 75, 90, 120),
(11, 'Клубника', 10, 259200, 3000, 100, 300, 330, 200),
(12, 'Арбуз', 11, 302400, 5000, 1000, 5, 10, 400),
(13, 'Банан', 13, 302400, 6000, 50, 300, 325, 800),
(14, 'Персик', 15, 345600, 8000, 60, 133, 160, 1100),
(15, 'Апельсин', 18, 345600, 10000, 100, 100, 140, 1500),
(16, 'Виноград', 20, 388800, 13000, 50, 260, 300, 2000),
(17, 'Лимон', 20, 345600, 15000, 150, 100, 140, 2500),
(18, 'Ананас', 21, 388800, 18000, 200, 90, 110, 3000),
(19, 'Глаз дракона', 22, 345600, 20000, 200, 200, 230, 3500),
(20, 'Вишня', 35, 388800, 22000, 20, 1100, 1200, 4000),
(21, 'Манго', 28, 388800, 23000, 100, 230, 260, 4500),
(22, 'Киви', 30, 432000, 26000, 200, 130, 150, 5000),
(23, 'Пшеница', 32, 432000, 28000, 30, 933, 1000, 5500),
(24, 'Груша', 35, 432000, 30000, 100, 300, 350, 6000),
(25, 'Арахис', 38, 432000, 33000, 50, 660, 710, 6500),
(26, 'Сахарная трость', 40, 518400, 38000, 200, 190, 230, 7000),
(27, 'Какао', 45, 518400, 45000, 50, 900, 950, 7500);



