--
-- Структура таблицы `2news`
--

CREATE TABLE IF NOT EXISTS `2news` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `msg` varchar(10000) DEFAULT NULL,
  `time` int(11) NOT NULL,
  `title` varchar(32) DEFAULT NULL,
  `main_time` int(11) NOT NULL DEFAULT '0',
  `link` varchar(64) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `time` (`time`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Структура таблицы `2news_komm`
--

CREATE TABLE IF NOT EXISTS `2news_komm` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_user` int(11) NOT NULL,
  `msg` varchar(1024) NOT NULL,
  `time` int(11) NOT NULL,
  `id_2news` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Структура таблицы `2news_read`
--

CREATE TABLE IF NOT EXISTS `2news_read` (
  `id_2news` int(11) NOT NULL,
  `id_user` int(11) NOT NULL,
  KEY `id_2news` (`id_2news`,`id_user`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Сведения о прочтении новости';

-- --------------------------------------------------------

--
-- Структура таблицы `fermer_dog`
--

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=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Структура таблицы `fermer_gr`
--

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=utf8 AUTO_INCREMENT=1 ;

--
-- Структура таблицы `fermer_name`
--

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 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

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




--
-- Структура таблицы `fermer_sclad`
--

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=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------


--
-- Структура таблицы `fermer_semen`
--

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=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Структура таблицы `fermer_udobr`
--

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=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Структура таблицы `fermer_udobr_name`
--

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 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------
INSERT INTO `fermer_udobr_name` VALUES 
(1,'Удобрение Простое','50','3600'),
(2,'Удобрение','200','14400'),
(3,'Супер Удобрение','500','18000'),
(4,'Секретное Удобрение','1000','36000')	;
--
-- Структура таблицы `fermer_vor`
--

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=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Структура таблицы `fin_in`
--

CREATE TABLE IF NOT EXISTS `fin_in` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user` int(11) NOT NULL,
  `time` int(11) NOT NULL,
  `oper` varchar(255) NOT NULL,
  `cena` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Структура таблицы `fin_oper`
--

CREATE TABLE IF NOT EXISTS `fin_oper` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user` int(11) NOT NULL,
  `time` int(11) NOT NULL,
  `oper` varchar(255) NOT NULL,
  `cena` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Структура таблицы `islam_club`
--

CREATE TABLE IF NOT EXISTS `islam_club` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_user` int(11) NOT NULL DEFAULT '0',
  `time` int(11) NOT NULL,
  `msg` varchar(1024) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `time` (`time`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Структура таблицы `k_closet`
--

CREATE TABLE IF NOT EXISTS `k_closet` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `vid` int(11) NOT NULL,
  `uid` int(11) NOT NULL,
  `name` varchar(50) NOT NULL,
  `opis` varchar(512) NOT NULL,
  `path` varchar(15) NOT NULL,
  `type` varchar(15) NOT NULL,
  `cena` int(11) NOT NULL,
  `pol` int(11) NOT NULL,
  `sex` int(11) NOT NULL,
  `shik` int(11) NOT NULL,
  `del` int(11) NOT NULL,
  `sport` int(11) NOT NULL,
  `epat` int(11) NOT NULL,
  `glam` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Структура таблицы `k_reeltor`
--

CREATE TABLE IF NOT EXISTS `k_reeltor` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `opis` varchar(512) NOT NULL,
  `path` varchar(15) NOT NULL,
  `type` varchar(15) NOT NULL,
  `cena` int(11) NOT NULL,
  `shik` int(11) NOT NULL,
  `del` int(11) NOT NULL,
  `glam` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Структура таблицы `k_shop`
--

CREATE TABLE IF NOT EXISTS `k_shop` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `opis` varchar(512) NOT NULL,
  `path` varchar(15) NOT NULL,
  `type` varchar(15) NOT NULL,
  `cena` int(11) NOT NULL,
  `pol` int(11) NOT NULL,
  `sex` int(11) NOT NULL,
  `shik` int(11) NOT NULL,
  `del` int(11) NOT NULL,
  `sport` int(11) NOT NULL,
  `epat` int(11) NOT NULL,
  `glam` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Структура таблицы `k_storage`
--

CREATE TABLE IF NOT EXISTS `k_storage` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `vid` int(11) NOT NULL,
  `uid` int(11) NOT NULL,
  `name` varchar(50) NOT NULL,
  `opis` varchar(512) NOT NULL,
  `path` varchar(15) NOT NULL,
  `type` varchar(15) NOT NULL,
  `cena` int(11) NOT NULL,
  `shik` int(11) NOT NULL,
  `del` int(11) NOT NULL,
  `glam` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Структура таблицы `k_user`
--

CREATE TABLE IF NOT EXISTS `k_user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `vid` int(11) NOT NULL,
  `uid` int(11) NOT NULL,
  `name` varchar(50) NOT NULL,
  `opis` varchar(512) NOT NULL,
  `path` varchar(15) NOT NULL,
  `type` varchar(15) NOT NULL,
  `cena` int(11) NOT NULL,
  `pol` int(11) NOT NULL,
  `sex` int(11) NOT NULL,
  `shik` int(11) NOT NULL,
  `del` int(11) NOT NULL,
  `sport` int(11) NOT NULL,
  `epat` int(11) NOT NULL,
  `glam` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Структура таблицы `k_user_house`
--

CREATE TABLE IF NOT EXISTS `k_user_house` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `vid` int(11) NOT NULL,
  `uid` int(11) NOT NULL,
  `name` varchar(50) NOT NULL,
  `opis` varchar(512) NOT NULL,
  `path` varchar(15) NOT NULL,
  `type` varchar(15) NOT NULL,
  `cena` int(11) NOT NULL,
  `shik` int(11) NOT NULL,
  `del` int(11) NOT NULL,
  `glam` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;



ALTER TABLE `user` ADD  `fermer_money` int(11) NOT NULL DEFAULT '1000';
  ALTER TABLE `user` ADD `fermer_doggy` varchar(122)  COLLATE utf8_unicode_ci DEFAULT '0'NOT NULL;
  ALTER TABLE `user` ADD `fermer_oput` int(11) NOT NULL DEFAULT '0';
