{% else-1 %}
* Купить рекламу
* Шины и диски для настоящих боссов дороги;
Форум
|
WAP-Мастер
|
Вопросы новичков
|

как залить таблицы в базу даныых?
Обновить | Подписаться | Поднять тему
Чтобы выполнить действие авторизируйтесь или пройдите регистрацию на сайте.
1.
mihamat *
[автор] (21 июл 2013, 14:57) [0/1] [-1] [отв] [спам] [под] +1 | -1

DROP TABLE IF EXISTS `invations`;

CREATE TABLE `invations` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`id_user` int(10) unsigned NOT NULL COMMENT \'Хозяин пригласительного\',
`id_invite` int(10) unsigned DEFAULT NULL COMMENT \'Приглашенный\',
`code` varchar(32) DEFAULT NULL COMMENT \'код пригласительного\',
`time_reg` int(10) unsigned DEFAULT NULL COMMENT \'Время регистрации по пригласительному\',
`email` varchar(32) DEFAULT NULL COMMENT \'Email, на который отправлен пригласительный\',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT=\'Пригласительные\';




DROP TABLE IF EXISTS `kolhoz_ban`;

CREATE TABLE `kolhoz_ban` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_user` int(11) DEFAULT NULL,
`id_who` int(11) DEFAULT NULL,
`msg` varchar(1024) DEFAULT NULL,
`time` int(11) DEFAULT \'0\',
`izg` enum(\'0\',\'1\') DEFAULT \'0\',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;




DROP TABLE IF EXISTS `kolhoz_blacklist`;

CREATE TABLE `kolhoz_blacklist` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_user` int(11) DEFAULT NULL,
`id_ank` int(11) DEFAULT NULL,
`time` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;




DROP TABLE IF EXISTS `kolhoz_chat`;

CREATE TABLE `kolhoz_chat` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_user` int(11) DEFAULT NULL,
`time` int(11) DEFAULT NULL,
`mother` int(11) DEFAULT \'0\',
`pos` int(11) DEFAULT \'0\',
`admod` set(\'0\',\'1\') DEFAULT \'0\',
`type` enum(\'room\',\'komm\') DEFAULT \'room\',
`msg` varchar(10000) DEFAULT NULL,
`opis` varchar(10000) DEFAULT NULL,
`name` varchar(1024) DEFAULT NULL,
`otvet` int(11) DEFAULT \'0\',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;




DROP TABLE IF EXISTS `kolhoz_collective`;

CREATE TABLE `kolhoz_collective` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(24) DEFAULT NULL,
`rating` bigint(255) DEFAULT \'0\',
`money` bigint(255) DEFAULT \'0\',
`rubies` bigint(255) DEFAULT \'0\',
`level` int(11) DEFAULT \'1\',
`tehnika` int(11) DEFAULT \'0\',
`time` int(11) DEFAULT NULL,
`time_obmen` int(11) DEFAULT \'0\',
`station` enum(\'0\',\'1\') DEFAULT \'0\',
`flowerbed` enum(\'0\',\'1\') DEFAULT \'0\',
`rating_gos` bigint(255) DEFAULT \'0\',
`titleText` varchar(64) DEFAULT NULL,
`titleText_user` int(11) DEFAULT NULL,
`titleText_time` int(11) DEFAULT NULL,
`soil` int(11) DEFAULT \'0\',
`irrigate` int(11) DEFAULT \'0\',
`scholl` int(11) DEFAULT \'0\',
`vet` int(11) DEFAULT \'0\',
`bank` int(11) DEFAULT \'0\',
`lib` enum(\'0\',\'1\') DEFAULT \'0\',
`greenhouse` int(11) DEFAULT \'0\',
`school` int(11) DEFAULT \'0\',
`nalog` int(11) DEFAULT \'0\',
`time_nalog` int(11) DEFAULT NULL,
`users_add` int(11) DEFAULT \'0\',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;




DROP TABLE IF EXISTS `kolhoz_collective_ahlist`;

CREATE TABLE `kolhoz_collective_ahlist` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_user` int(11) DEFAULT NULL,
`time` int(11) DEFAULT \'0\',
`heli` enum(\'1\',\'2\',\'3\',\'4\') DEFAULT \'1\',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;




DROP TABLE IF EXISTS `kolhoz_collective_cash`;

CREATE TABLE `kolhoz_collective_cash` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_user` int(11) DEFAULT NULL,
`id_collective` int(11) DEFAULT NULL,
`type` enum(\'rubies\',\'money\') DEFAULT \'rubies\',
`time` int(11) DEFAULT \'0\',
`count` bigint(255) DEFAULT \'0\',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;




DROP TABLE IF EXISTS `kolhoz_collective_chat`;

CREATE TABLE `kolhoz_collective_chat` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_user` int(11) DEFAULT NULL,
`id_collective` int(11) DEFAULT NULL,
`time` int(11) DEFAULT NULL,
`msg` varchar(10000) DEFAULT NULL,
`otvet` int(11) DEFAULT \'0\',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;




DROP TABLE IF EXISTS `kolhoz_collective_club`;

CREATE TABLE `kolhoz_collective_club` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_collective` int(11) DEFAULT NULL,
`id_user` int(11) DEFAULT NULL,
`time` int(11) DEFAULT NULL,
`mother` int(11) DEFAULT \'0\',
`guest` set(\'0\',\'1\') DEFAULT \'0\',
`type` enum(\'razdel\',\'tema\',\'komm\') DEFAULT \'razdel\',
`msg` varchar(10000) DEFAULT NULL,
`name` varchar(1024) DEFAULT NULL,
`locked` enum(\'0\',\'1\') DEFAULT \'0\',
`otvet` int(11) DEFAULT \'0\',
`pined` enum(\'0\',\'1\') DEFAULT \'0\',
`pos` int(11) DEFAULT \'0\',
`time_obnov` int(11) DEFAULT \'0\',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;




DROP TABLE IF EXISTS `kolhoz_collective_comp`;

CREATE TABLE `kolhoz_collective_comp` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`time` int(11) DEFAULT \'0\',
`id_gos` int(11) DEFAULT \'0\',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;




DROP TABLE IF EXISTS `kolhoz_collective_comp_user`;

CREATE TABLE `kolhoz_collective_comp_user` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_user` int(11) DEFAULT \'0\',
`id_comp` int(11) DEFAULT \'0\',
`count` int(11) DEFAULT \'0\',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;




DROP TABLE IF EXISTS `kolhoz_collective_gos`;

CREATE TABLE `kolhoz_collective_gos` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`time` int(11) DEFAULT \'0\',
`id_plant` int(11) DEFAULT \'0\',
`type` enum(\'rating\',\'harvest\') DEFAULT \'rating\',
`active` enum(\'0\',\'1\') DEFAULT \'0\',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;




DROP TABLE IF EXISTS `kolhoz_collective_gos_ct`;

CREATE TABLE `kolhoz_collective_gos_ct` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_collective` int(11) DEFAULT \'0\',
`id_gos` int(11) DEFAULT \'0\',
`count` int(11) DEFAULT \'0\',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;




DROP TABLE IF EXISTS `kolhoz_collective_hangar`;

CREATE TABLE `kolhoz_collective_hangar` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_user` int(11) DEFAULT NULL,
`id_collective` int(11) DEFAULT NULL,
`time` int(11) DEFAULT \'0\',
`gaz` int(11) DEFAULT \'0\',
`heli` enum(\'1\',\'2\',\'3\',\'4\') DEFAULT \'1\',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;




DROP TABLE IF EXISTS `kolhoz_collective_heli`;

CREATE TABLE `kolhoz_collective_heli` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_user` int(11) DEFAULT NULL,
`id_collective` int(11) DEFAULT NULL,
`gaz` int(11) DEFAULT \'0\',
`time` int(11) DEFAULT \'0\',
`heli` enum(\'0\',\'1\',\'2\',\'3\',\'4\') DEFAULT \'0\',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;




DROP TABLE IF EXISTS `kolhoz_collective_history`;

CREATE TABLE `kolhoz_collective_history` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_user` int(11) DEFAULT NULL,
`id_collective` int(11) DEFAULT NULL,
`id_who` int(11) DEFAULT NULL,
`time` int(11) DEFAULT \'0\',
`type` enum(\'in\',\'out\',\'st_up\',\'st_down\') DEFAULT \'in\',
`status` enum(\'1\',\'2\',\'3\',\'4\',\'5\',\'6\',\'7\') DEFAULT \'1\',
`dei` enum(\'who\',\'user\') DEFAULT \'user\',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;




DROP TABLE IF EXISTS `kolhoz_collective_invite`;

CREATE TABLE `kolhoz_collective_invite` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_user` int(11) DEFAULT NULL,
`id_collective` int(11) DEFAULT NULL,
`id_who` int(11) DEFAULT NULL,
`time` int(11) DEFAULT \'0\',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;




DROP TABLE IF EXISTS `kolhoz_collective_rating`;

CREATE TABLE `kolhoz_collective_rating` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_user` int(11) DEFAULT NULL,
`id_collective` int(11) DEFAULT NULL,
`time` int(11) DEFAULT \'0\',
`count` bigint(255) DEFAULT \'0\',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;




DROP TABLE IF EXISTS `kolhoz_collective_rating_gos`;

CREATE TABLE `kolhoz_collective_rating_gos` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_user` int(11) DEFAULT NULL,
`id_collective` int(11) DEFAULT NULL,
`time` int(11) DEFAULT \'0\',
`count` int(11) DEFAULT \'0\',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;




DROP TABLE IF EXISTS `kolhoz_collective_user`;

CREATE TABLE `kolhoz_collective_user` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_user` int(11) DEFAULT NULL,
`id_collective` int(11) DEFAULT NULL,
`rating` bigint(255) DEFAULT \'0\',
`money` bigint(255) DEFAULT \'0\',
`rubies` bigint(255) DEFAULT \'0\',
`time` int(11) DEFAULT \'0\',
`status` enum(\'1\',\'2\',\'3\',\'4\',\'5\',\'6\',\'7\') DEFAULT \'1\',
`rubies_week` bigint(255) DEFAULT \'0\',
`rating_week` bigint(255) DEFAULT \'0\',
`rating_gos` bigint(255) DEFAULT \'0\',
`tehnika` int(11) DEFAULT \'0\',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;




DROP TABLE IF EXISTS `kolhoz_fish`;

CREATE TABLE `kolhoz_fish` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(500) DEFAULT NULL,
`cena` int(11) DEFAULT \'0\',
`rating` int(11) DEFAULT \'0\',
`count` int(11) DEFAULT \'0\',
`time` int(11) DEFAULT NULL,
`money` int(11) DEFAULT \'0\',
`time_soil` int(11) DEFAULT \'0\',
`level` int(11) DEFAULT \'1\',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=21 DEFAULT CHARSET=utf8;

INSERT INTO kolhoz_fish VALUES(\"1\",\"Верховодка\",\"75\",\"8\",\"4\",\"3600\",\"136\",\"60\",\"2\"*;
INSERT INTO kolhoz_fish VALUES(\"2\",\"Бычок\",\"100\",\"40\",\"4\",\"10800\",\"180\",\"180\",\"4\"*;
INSERT INTO kolhoz_fish VALUES(\"3\",\"Красноперка\",\"125\",\"60\",\"4\",\"18000\",\"220\",\"240\",\"6\"*;
INSERT INTO kolhoz_fish VALUES(\"4\",\"Карась\",\"175\",\"120\",\"5\",\"28800\",\"650\",\"600\",\"8\"*;
INSERT INTO kolhoz_fish VALUES(\"5\",\"Плотва\",\"225\",\"650\",\"5\",\"43200\",\"650\",\"780\",\"12\"*;
INSERT INTO kolhoz_fish VALUES(\"6\",\"Линь\",\"350\",\"176\",\"5\",\"64800\",\"800\",\"840\",\"15\"*;
INSERT INTO kolhoz_fish VALUES(\"7\",\"Карп\",\"450\",\"224\",\"5\",\"79200\",\"925\",\"900\",\"18\"*;
INSERT INTO kolhoz_fish VALUES(\"8\",\"Окунь\",\"550\",\"264\",\"4\",\"93600\",\"1050\",\"1080\",\"19\"*;
INSERT INTO kolhoz_fish VALUES(\"9\",\"Толстолобик\",\"600\",\"300\",\"6\",\"115200\",\"1530\",\"1200\",\"22\"*;
INSERT INTO kolhoz_fish VALUES(\"10\",\"Щука\",\"760\",\"352\",\"4\",\"144000\",\"1700\",\"1320\",\"24\"*;
INSERT INTO kolhoz_fish VALUES(\"11\",\"Угорь\",\"900\",\"384\",\"8\",\"172800\",\"1856\",\"1440\",\"26\"*;
INSERT INTO kolhoz_fish VALUES(\"12\",\"Сом\",\"1000\",\"400\",\"5\",\"208800\",\"2466\",\"1560\",\"28\"*;
INSERT INTO kolhoz_fish VALUES(\"13\",\"Белый Амур\",\"1200\",\"420\",\"6\",\"237600\",\"2676\",\"1680\",\"30\"*;
INSERT INTO kolhoz_fish VALUES(\"14\",\"Осетр\",\"1750\",\"460\",\"6\",\"259200\",\"3234\",\"1800\",\"34\"*;
INSERT INTO kolhoz_fish VALUES(\"15\",\"Белуга\",\"2500\",\"500\",\"6\",\"302400\",\"3234\",\"2040\",\"36\"*;
INSERT INTO kolhoz_fish VALUES(\"16\",\"Семга\",\"2750\",\"625\",\"6\",\"345600\",\"4260\",\"2160\",\"38\"*;
INSERT INTO kolhoz_fish VALUES(\"17\",\"Лосось\",\"3000\",\"700\",\"6\",\"388800\",\"4700\",\"2400\",\"42\"*;
INSERT INTO kolhoz_fish VALUES(\"18\",\"Форель\",\"3250\",\"800\",\"6\",\"432000\",\"4800\",\"2640\",\"46\"*;
INSERT INTO kolhoz_fish VALUES(\"19\",\"Стерлядь\",\"3500\",\"900\",\"6\",\"504000\",\"5070\",\"2760\",\"48\"*;
INSERT INTO kolhoz_fish VALUES(\"20\",\"Морской еж\",\"4000\",\"1000\",\"8\",\"648000\",\"5610\",\"2700\",\"50\"*;



DROP TABLE IF EXISTS `kolhoz_forum`;

CREATE TABLE `kolhoz_forum` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_user` int(11) DEFAULT NULL,
`time` int(11) DEFAULT NULL,
`mother` int(11) DEFAULT \'0\',
`admod` set(\'0\',\'1\') DEFAULT \'0\',
`type` enum(\'razdel\',\'tema\',\'komm\') DEFAULT \'razdel\',
`msg` varchar(10000) DEFAULT NULL,
`name` varchar(1024) DEFAULT NULL,
`locked` enum(\'0\',\'1\') DEFAULT \'0\',
`otvet` int(11) DEFAULT \'0\',
`pined` enum(\'0\',\'1\') DEFAULT \'0\',
`pos` int(11) DEFAULT \'0\',
`time_obnov` int(11) DEFAULT \'0\',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;




DROP TABLE IF EXISTS `kolhoz_friends`;

CREATE TABLE `kolhoz_friends` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_user` int(11) DEFAULT NULL,
`id_ank` int(11) DEFAULT NULL,
`time` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;




DROP TABLE IF EXISTS `kolhoz_gift`;

CREATE TABLE `kolhoz_gift` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(1024) DEFAULT NULL,
`cena` int(11) DEFAULT \'0\',
`id_cat` int(11) DEFAULT \'0\',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=51 DEFAULT CHARSET=utf8;

INSERT INTO kolhoz_gift VALUES(\"3\",\"Маргарита\",\"1000\",\"2\"*;
INSERT INTO kolhoz_gift VALUES(\"4\",\"Легкость\",\"500\",\"2\"*;
INSERT INTO kolhoz_gift VALUES(\"5\",\"Аромат\",\"500\",\"2\"*;
INSERT INTO kolhoz_gift VALUES(\"6\",\"Свежесть\",\"500\",\"2\"*;
INSERT INTO kolhoz_gift VALUES(\"7\",\"Бодрость\",\"500\",\"2\"*;
INSERT INTO kolhoz_gift VALUES(\"8\",\"Дижестив\",\"500\",\"2\"*;
INSERT INTO kolhoz_gift VALUES(\"9\",\"Клубника\",\"1000\",\"3\"*;
INSERT INTO kolhoz_gift VALUES(\"10\",\"Ассорти\",\"500\",\"3\"*;
INSERT INTO kolhoz_gift VALUES(\"11\",\"Десерт\",\"500\",\"3\"*;
INSERT INTO kolhoz_gift VALUES(\"12\",\"Малина\",\"500\",\"3\"*;
INSERT INTO kolhoz_gift VALUES(\"13\",\"Мороженое\",\"500\",\"3\"*;
INSERT INTO kolhoz_gift VALUES(\"14\",\"Пирожное\",\"500\",\"3\"*;
INSERT INTO kolhoz_gift VALUES(\"15\",\"Торт\",\"500\",\"3\"*;
INSERT INTO kolhoz_gift VALUES(\"16\",\"Утёнок\",\"1000\",\"4\"*;
INSERT INTO kolhoz_gift VALUES(\"17\",\"Слоник\",\"500\",\"4\"*;
INSERT INTO kolhoz_gift VALUES(\"18\",\"Зайка\",\"500\",\"4\"*;
INSERT INTO kolhoz_gift VALUES(\"19\",\"Лапа\",\"500\",\"4\"*;
INSERT INTO kolhoz_gift VALUES(\"20\",\"Милашка\",\"500\",\"4\"*;
INSERT INTO kolhoz_gift VALUES(\"21\",\"Озорник\",\"500\",\"4\"*;
INSERT INTO kolhoz_gift VALUES(\"22\",\"Золотое сердце\",\"1000\",\"5\"*;
INSERT INTO kolhoz_gift VALUES(\"23\",\"Медальон \\\"Любящее сердце\\\"\",\"500\",\"5\"*;
INSERT INTO kolhoz_gift VALUES(\"24\",\"Медальон \\\"Энергия жизни\\\"\",\"500\",\"5\"*;
INSERT INTO kolhoz_gift VALUES(\"25\",\"Кольцо с сапфиром\",\"500\",\"5\"*;
INSERT INTO kolhoz_gift VALUES(\"26\",\"Кольцо с рубином\",\"500\",\"5\"*;
INSERT INTO kolhoz_gift VALUES(\"27\",\"Обручальное кольцо\",\"500\",\"5\"*;
INSERT INTO kolhoz_gift VALUES(\"28\",\"С любовью\",\"1000\",\"6\"*;
INSERT INTO kolhoz_gift VALUES(\"29\",\"Букет\",\"500\",\"6\"*;
INSERT INTO kolhoz_gift VALUES(\"30\",\"Тебе с нежностью\",\"500\",\"6\"*;
INSERT INTO kolhoz_gift VALUES(\"31\",\"Волшебство\",\"500\",\"6\"*;
INSERT INTO kolhoz_gift VALUES(\"32\",\"Легкого настроения\",\"500\",\"6\"*;
INSERT INTO kolhoz_gift VALUES(\"33\",\"Ромашки\",\"500\",\"6\"*;
INSERT INTO kolhoz_gift VALUES(\"34\",\"Роза\",\"500\",\"6\"*;
INSERT INTO kolhoz_gift VALUES(\"35\",\"Подснежники\",\"500\",\"6\"*;
INSERT INTO kolhoz_gift VALUES(\"36\",\"Букет невесты\",\"500\",\"6\"*;
INSERT INTO kolhoz_gift VALUES(\"37\",\"Джип\",\"10000\",\"7\"*;
INSERT INTO kolhoz_gift VALUES(\"38\",\"Парфюм\",\"10000\",\"7\"*;
INSERT INTO kolhoz_gift VALUES(\"39\",\"Ноутбук\",\"10000\",\"7\"*;
INSERT INTO kolhoz_gift VALUES(\"40\",\"Пистолет\",\"10000\",\"7\"*;
INSERT INTO kolhoz_gift VALUES(\"41\",\"Гламурные тапочки\",\"50000\",\"7\"*;
INSERT INTO kolhoz_gift VALUES(\"42\",\"Сувенир\",\"50000\",\"7\"*;
INSERT INTO kolhoz_gift VALUES(\"43\",\"Rolex\",\"100000\",\"7\"*;
INSERT INTO kolhoz_gift VALUES(\"44\",\"Для Королевы...\",\"100000\",\"7\"*;
INSERT INTO kolhoz_gift VALUES(\"45\",\"Финансовых успехов!\",\"50000\",\"7\"*;
INSERT INTO kolhoz_gift VALUES(\"46\",\"Лови жука\",\"500\",\"8\"*;
INSERT INTO kolhoz_gift VALUES(\"47\",\"Сковорода\",\"500\",\"8\"*;
INSERT INTO kolhoz_gift VALUES(\"48\",\"В добрый путь!\",\"500\",\"8\"*;
INSERT INTO kolhoz_gift VALUES(\"49\",\"Ученье - свет!\",\"500\",\"8\"*;
INSERT INTO kolhoz_gift VALUES(\"50\",\"Вредина\",\"500\",\"8\"*;



DROP TABLE IF EXISTS `kolhoz_gift_cat`;

CREATE TABLE `kolhoz_gift_cat` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(1024) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;

INSERT INTO kolhoz_gift_cat VALUES(\"2\",\"Напитки\"*;
INSERT INTO kolhoz_gift_cat VALUES(\"3\",\"Вкусности\"*;
INSERT INTO kolhoz_gift_cat VALUES(\"4\",\"Игрушки\"*;
INSERT INTO kolhoz_gift_cat VALUES(\"5\",\"Украшения\"*;
INSERT INTO kolhoz_gift_cat VALUES(\"6\",\"Цветы\"*;
INSERT INTO kolhoz_gift_cat VALUES(\"7\",\"Премиум\"*;
INSERT INTO kolhoz_gift_cat VALUES(\"8\",\"Повседневные\"*;



DROP TABLE IF EXISTS `kolhoz_gifts`;

CREATE TABLE `kolhoz_gifts` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_user` int(11) DEFAULT NULL,
`id_kont` int(11) DEFAULT NULL,
`id_gift` int(11) DEFAULT NULL,
`time` int(11) DEFAULT NULL,
`read` set(\'0\',\'1\') DEFAULT \'0\',
`msg` varchar(1024) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;




DROP TABLE IF EXISTS `kolhoz_ground`;

CREATE TABLE `kolhoz_ground` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_user` int(11) DEFAULT NULL,
`id_plant` int(11) DEFAULT \'0\',
`soil` enum(\'0\',\'1\') DEFAULT \'0\',
`time` int(11) DEFAULT \'0\',
`time_water` int(11) DEFAULT \'0\',
`time_soil` int(11) DEFAULT \'0\',
`cultivator` enum(\'0\',\'1\') DEFAULT \'0\',
`first` enum(\'0\',\'1\') DEFAULT \'0\',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;




DROP TABLE IF EXISTS `kolhoz_korm`;

CREATE TABLE `kolhoz_korm` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(500) DEFAULT NULL,
`cena` int(11) DEFAULT \'0\',
`rating` int(11) DEFAULT \'0\',
`time` int(11) DEFAULT NULL,
`level` int(11) DEFAULT \'1\',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

INSERT INTO kolhoz_korm VALUES(\"1\",\"Зерно\",\"50\",\"10\",\"2700\",\"1\"*;
INSERT INTO kolhoz_korm VALUES(\"2\",\"Комбикорм\",\"100\",\"50\",\"8000\",\"10\"*;
INSERT INTO kolhoz_korm VALUES(\"3\",\"Муха\",\"350\",\"100\",\"57600\",\"20\"*;
INSERT INTO kolhoz_korm VALUES(\"4\",\"Рачки\",\"750\",\"400\",\"11880\",\"30\"*;
INSERT INTO kolhoz_korm VALUES(\"5\",\"Крилевые хлопья\",\"1250\",\"800\",\"19440\",\"40\"*;



DROP TABLE IF EXISTS `kolhoz_level`;

CREATE TABLE `kolhoz_level` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`level` varchar(1000) DEFAULT \'0\',
`rating` varchar(1000) DEFAULT \'0\',
`rubies` int(11) DEFAULT \'0\',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=54 DEFAULT CHARSET=utf8;

INSERT INTO kolhoz_level VALUES(\"1\",\"2\",\"100\",\"2\"*;
INSERT INTO kolhoz_level VALUES(\"2\",\"3\",\"250\",\"3\"*;
INSERT INTO kolhoz_level VALUES(\"3\",\"4\",\"495\",\"4\"*;
INSERT INTO kolhoz_level VALUES(\"4\",\"5\",\"798\",\"5\"*;
INSERT INTO kolhoz_level VALUES(\"5\",\"6\",\"1100\",\"6\"*;
INSERT INTO kolhoz_level VALUES(\"6\",\"7\",\"1500\",\"7\"*;
INSERT INTO kolhoz_level VALUES(\"7\",\"8\",\"1900\",\"8\"*;
INSERT INTO kolhoz_level VALUES(\"8\",\"9\",\"2300\",\"9\"*;
INSERT INTO kolhoz_level VALUES(\"9\",\"10\",\"2800\",\"10\"*;
INSERT INTO kolhoz_level VALUES(\"10\",\"11\",\"3300\",\"11\"*;
INSERT INTO kolhoz_level VALUES(\"11\",\"12\",\"3800\",\"12\"*;
INSERT INTO kolhoz_level VALUES(\"12\",\"13\",\"4400\",\"13\"*;
INSERT INTO kolhoz_level VALUES(\"13\",\"14\",\"4900\",\"14\"*;
INSERT INTO kolhoz_level VALUES(\"14\",\"15\",\"5500\",\"15\"*;
INSERT INTO kolhoz_level VALUES(\"15\",\"16\",\"6100\",\"16\"*;
INSERT INTO kolhoz_level VALUES(\"16\",\"17\",\"11700\",\"17\"*;
INSERT INTO kolhoz_level VALUES(\"17\",\"18\",\"21200\",\"18\"*;
INSERT INTO kolhoz_level VALUES(\"18\",\"19\",\"37100\",\"19\"*;
INSERT INTO kolhoz_level VALUES(\"19\",\"20\",\"63700\",\"20\"*;
INSERT INTO kolhoz_level VALUES(\"20\",\"21\",\"107600\",\"21\"*;
INSERT INTO kolhoz_level VALUES(\"21\",\"22\",\"163300\",\"22\"*;
INSERT INTO kolhoz_level VALUES(\"22\",\"23\",\"237000\",\"23\"*;
INSERT INTO kolhoz_level VALUES(\"23\",\"24\",\"398900\",\"24\"*;
INSERT INTO kolhoz_level VALUES(\"24\",\"25\",\"750100\",\"25\"*;
INSERT INTO kolhoz_level VALUES(\"25\",\"26\",\"1510000\",\"26\"*;
INSERT INTO kolhoz_level VALUES(\"26\",\"27\",\"3170000\",\"27\"*;
INSERT INTO kolhoz_level VALUES(\"27\",\"28\",\"6780000\",\"28\"*;
INSERT INTO kolhoz_level VALUES(\"28\",\"29\",\"14630000\",\"29\"*;
INSERT INTO kolhoz_level VALUES(\"29\",\"30\",\"31710000\",\"30\"*;
INSERT INTO kolhoz_level VALUES(\"30\",\"31\",\"50000000\",\"31\"*;
INSERT INTO kolhoz_level VALUES(\"31\",\"32\",\"75000000\",\"32\"*;
INSERT INTO kolhoz_level VALUES(\"32\",\"33\",\"100000000\",\"33\"*;
INSERT INTO kolhoz_level VALUES(\"33\",\"34\",\"125000000\",\"34\"*;
INSERT INTO kolhoz_level VALUES(\"34\",\"35\",\"150000000\",\"35\"*;
INSERT INTO kolhoz_level VALUES(\"35\",\"36\",\"300000000\",\"36\"*;
INSERT INTO kolhoz_level VALUES(\"36\",\"37\",\"600000000\",\"37\"*;
INSERT INTO kolhoz_level VALUES(\"37\",\"38\",\"1200000000\",\"38\"*;
INSERT INTO kolhoz_level VALUES(\"38\",\"39\",\"2400000000\",\"39\"*;
INSERT INTO kolhoz_level VALUES(\"39\",\"40\",\"4800000000\",\"40\"*;
INSERT INTO kolhoz_level VALUES(\"40\",\"41\",\"7000000000\",\"41\"*;
INSERT INTO kolhoz_level VALUES(\"41\",\"42\",\"10000000000\",\"42\"*;
INSERT INTO kolhoz_level VALUES(\"42\",\"43\",\"15000000000\",\"43\"*;
INSERT INTO kolhoz_level VALUES(\"43\",\"44\",\"20000000000\",\"44\"*;
INSERT INTO kolhoz_level VALUES(\"45\",\"45\",\"25000000000\",\"45\"*;
INSERT INTO kolhoz_level VALUES(\"46\",\"46\",\"30000000000\",\"46\"*;
INSERT INTO kolhoz_level VALUES(\"47\",\"47\",\"35000000000\",\"47\"*;
INSERT INTO kolhoz_level VALUES(\"48\",\"48\",\"40000000000\",\"48\"*;
INSERT INTO kolhoz_level VALUES(\"49\",\"49\",\"45000000000\",\"49\"*;
INSERT INTO kolhoz_level VALUES(\"50\",\"50\",\"50000000000\",\"50\"*;
INSERT INTO kolhoz_level VALUES(\"52\",\"51\",\"56000000000\",\"51\"*;
INSERT INTO kolhoz_level VALUES(\"53\",\"52\",\"9223372036854775807\",\"52\"*;



DROP TABLE IF EXISTS `kolhoz_mail`;

CREATE TABLE `kolhoz_mail` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_user` int(11) DEFAULT NULL,
`id_kont` int(11) DEFAULT NULL,
`time` int(11) DEFAULT NULL,
`msg` varchar(1024) DEFAULT NULL,
`read` set(\'0\',\'1\') DEFAULT \'0\',
`type` enum(\'at\',\'to\') DEFAULT \'to\',
`sistem` enum(\'0\',\'1\') DEFAULT \'0\',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;




DROP TABLE IF EXISTS `kolhoz_market`;

CREATE TABLE `kolhoz_market` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_user` int(11) DEFAULT NULL,
`id_plant2` int(11) DEFAULT NULL,
`count` int(11) DEFAULT \'0\',
`arena` enum(\'0\',\'1\') DEFAULT \'0\',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;




DROP TABLE IF EXISTS `kolhoz_pet`;

CREATE TABLE `kolhoz_pet` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(1000) DEFAULT NULL,
`cena` int(11) DEFAULT \'0\',
`money` int(11) DEFAULT \'0\',
`rating` varchar(1000) DEFAULT \'0\',
`level` int(11) DEFAULT \'1\',
`work` varchar(1000) DEFAULT \'0\',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=39 DEFAULT CHARSET=utf8;

INSERT INTO kolhoz_pet VALUES(\"1\",\"Шелкопряд\",\"1000\",\"200\",\"300\",\"10\",\"Приносит шелк\"*;
INSERT INTO kolhoz_pet VALUES(\"2\",\"Курица\",\"10000\",\"500\",\"3000\",\"16\",\"Приносит куриные яйца\"*;
INSERT INTO kolhoz_pet VALUES(\"4\",\"Гусыня\",\"100000\",\"700\",\"5000\",\"22\",\"Приносит гусиные яйца\"*;
INSERT INTO kolhoz_pet VALUES(\"5\",\"Корова\",\"150000\",\"700\",\"6000\",\"18\",\"Приносит молоко\"*;
INSERT INTO kolhoz_pet VALUES(\"6\",\"Овечка\",\"175000\",\"800\",\"8000\",\"20\",\"Приносит шерсть\"*;
INSERT INTO kolhoz_pet VALUES(\"7\",\"Пчела\",\"250000\",\"1000\",\"10000\",\"24\",\"Приносит мёд\"*;
INSERT INTO kolhoz_pet VALUES(\"9\",\"Перепелка\",\"1000000\",\"1500\",\"10000\",\"32\",\"Приносит перепелиные яйца\"*;
INSERT INTO kolhoz_pet VALUES(\"10\",\"Шиншила\",\"1750000\",\"1500\",\"20000\",\"30\",\"Приносит мех\"*;
INSERT INTO kolhoz_pet VALUES(\"11\",\"Крокодил\",\"20000000\",\"3000\",\"50000\",\"35\",\"Приносит кожу\"*;
INSERT INTO kolhoz_pet VALUES(\"12\",\"Марал\",\"25000000\",\"5000\",\"75000\",\"36\",\"Приносит рога\"*;
INSERT INTO kolhoz_pet VALUES(\"13\",\"Лебедь\",\"27000000\",\"6000\",\"65000\",\"38\",\"Приносит пух\"*;
INSERT INTO kolhoz_pet VALUES(\"14\",\"Фламинго\",\"32000000\",\"10000\",\"100000\",\"38\",\"Участвует в выставках\"*;
INSERT INTO kolhoz_pet VALUES(\"15\",\"Бобер\",\"35000000\",\"12000\",\"85000\",\"40\",\"Заготавливает древесину\"*;
INSERT INTO kolhoz_pet VALUES(\"16\",\"Панда\",\"38000000\",\"20000\",\"130000\",\"40\",\"Участвует в выставках\"*;
INSERT INTO kolhoz_pet VALUES(\"17\",\"Страус\",\"37000000\",\"15000\",\"110000\",\"41\",\"Приносит страусиные яйца\"*;
INSERT INTO kolhoz_pet VALUES(\"18\",\"Рысь\",\"40000000\",\"26000\",\"170000\",\"41\",\"Участвует в выставках\"*;
INSERT INTO kolhoz_pet VALUES(\"19\",\"Павлин\",\"39000000\",\"20000\",\"140000\",\"42\",\"Участвует в выставках\"*;
INSERT INTO kolhoz_pet VALUES(\"20\",\"Лиса\",\"45000000\",\"34000\",\"220000\",\"42\",\"Ворует яйца\"*;
INSERT INTO kolhoz_pet VALUES(\"21\",\"Сокол\",\"34000000\",\"26000\",\"185000\",\"43\",\"Участвует в соколиной охоте\"*;
INSERT INTO kolhoz_pet VALUES(\"22\",\"Лев\",\"50000000\",\"44000\",\"285000\",\"43\",\"Участвует в выставках\"*;
INSERT INTO kolhoz_pet VALUES(\"23\",\"Индюк\",\"55000000\",\"32000\",\"200000\",\"44\",\"Приносит индюшачьи яйца\"*;
INSERT INTO kolhoz_pet VALUES(\"24\",\"Свинья\",\"60000000\",\"50000\",\"300000\",\"44\",\"Приносит поросят\"*;
INSERT INTO kolhoz_pet VALUES(\"25\",\"Голубь\",\"58000000\",\"38000\",\"220000\",\"45\",\"Работает почтальоном\"*;
INSERT INTO kolhoz_pet VALUES(\"26\",\"Лошадь\",\"65000000\",\"60000\",\"320000\",\"45\",\"Участвует в скачках\"*;
INSERT INTO kolhoz_pet VALUES(\"27\",\"Аист\",\"61000000\",\"40000\",\"230000\",\"46\",\"Работает почтальоном\"*;
INSERT INTO kolhoz_pet VALUES(\"28\",\"Белка\",\"68000000\",\"65000\",\"340000\",\"46\",\"Заготовляет орешки\"*;
INSERT INTO kolhoz_pet VALUES(\"29\",\"Чайка\",\"65000000\",\"42000\",\"240000\",\"47\",\"Ловит рыбу\"*;
INSERT INTO kolhoz_pet VALUES(\"30\",\"Ёжик\",\"70000000\",\"70000\",\"360000\",\"47\",\"Собирает яблоки\"*;
INSERT INTO kolhoz_pet VALUES(\"31\",\"Пеликан\",\"66000000\",\"44000\",\"250000\",\"48\",\"Ловит рыбу\"*;
INSERT INTO kolhoz_pet VALUES(\"32\",\"Кенгуру\",\"75000000\",\"75000\",\"380000\",\"48\",\"Приносит кенгурят\"*;
INSERT INTO kolhoz_pet VALUES(\"33\",\"Попугай\",\"67000000\",\"46000\",\"260000\",\"49\",\"Разговаривает\"*;
INSERT INTO kolhoz_pet VALUES(\"34\",\"Кролик\",\"80000000\",\"80000\",\"400000\",\"49\",\"Приносит крольчат\"*;
INSERT INTO kolhoz_pet VALUES(\"35\",\"Сова\",\"68000000\",\"50000\",\"270000\",\"50\",\"Ловит грызунов\"*;
INSERT INTO kolhoz_pet VALUES(\"36\",\"Верблюд\",\"500000\",\"30000\",\"300000\",\"50\",\"Дает шерсть\"*;
INSERT INTO kolhoz_pet VALUES(\"38\",\"Слон\",\"1000000\",\"169000\",\"260000\",\"50\",\"Даёт мясо\"*;



DROP TABLE IF EXISTS `kolhoz_petground`;

CREATE TABLE `kolhoz_petground` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_user` int(11) DEFAULT NULL,
`id_pet` int(11) DEFAULT \'0\',
`time` int(11) DEFAULT \'0\',
`time_money` int(11) DEFAULT \'0\',
`level` int(11) DEFAULT \'1\',
`time_money2` int(11) DEFAULT \'0\',
`time_rf` int(11) DEFAULT \'0\',
`last_rf` int(11) DEFAULT \'0\',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;




DROP TABLE IF EXISTS `kolhoz_plant`;

CREATE TABLE `kolhoz_plant` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(500) DEFAULT NULL,
`cena` int(11) DEFAULT \'0\',
`rating` int(11) DEFAULT \'0\',
`count` int(11) DEFAULT \'0\',
`time` int(11) DEFAULT NULL,
`money` int(11) DEFAULT \'0\',
`time_soil` int(11) DEFAULT \'0\',
`level` int(11) DEFAULT \'1\',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=87 DEFAULT CHARSET=utf8;

INSERT INTO kolhoz_plant VALUES(\"5\",\"Укроп\",\"10\",\"10\",\"1\",\"2700\",\"12\",\"60\",\"1\"*;
INSERT INTO kolhoz_plant VALUES(\"6\",\"Петрушка\",\"10\",\"40\",\"1\",\"2700\",\"13\",\"60\",\"1\"*;
INSERT INTO kolhoz_plant VALUES(\"7\",\"Лук\",\"20\",\"20\",\"1\",\"6480\",\"27\",\"60\",\"2\"*;
INSERT INTO kolhoz_plant VALUES(\"8\",\"Хрен\",\"20\",\"80\",\"1\",\"23520\",\"50\",\"60\",\"2\"*;
INSERT INTO kolhoz_plant VALUES(\"9\",\"Мята\",\"30\",\"30\",\"1\",\"9360\",\"42\",\"120\",\"3\"*;
INSERT INTO kolhoz_plant VALUES(\"10\",\"Редис\",\"30\",\"120\",\"1\",\"34920\",\"82\",\"120\",\"3\"*;
INSERT INTO kolhoz_plant VALUES(\"11\",\"Капуста\",\"40\",\"40\",\"3\",\"12240\",\"58\",\"120\",\"4\"*;
INSERT INTO kolhoz_plant VALUES(\"12\",\"Базилик\",\"40\",\"160\",\"3\",\"46320\",\"120\",\"120\",\"4\"*;
INSERT INTO kolhoz_plant VALUES(\"13\",\"Морковь\",\"50\",\"50\",\"3\",\"15120\",\"74\",\"180\",\"5\"*;
INSERT INTO kolhoz_plant VALUES(\"14\",\"Свекла\",\"50\",\"200\",\"3\",\"57720\",\"162\",\"180\",\"5\"*;
INSERT INTO kolhoz_plant VALUES(\"15\",\"Щавель\",\"60\",\"60\",\"4\",\"18000\",\"92\",\"180\",\"6\"*;
INSERT INTO kolhoz_plant VALUES(\"16\",\"Картофель\",\"60\",\"240\",\"4\",\"69120\",\"208\",\"180\",\"6\"*;
INSERT INTO kolhoz_plant VALUES(\"17\",\"Горох\",\"70\",\"70\",\"4\",\"20880\",\"111\",\"240\",\"7\"*;
INSERT INTO kolhoz_plant VALUES(\"18\",\"Перец\",\"70\",\"280\",\"4\",\"80520\",\"258\",\"240\",\"7\"*;
INSERT INTO kolhoz_plant VALUES(\"19\",\"Томат\",\"80\",\"80\",\"6\",\"23760\",\"130\",\"240\",\"8\"*;
INSERT INTO kolhoz_plant VALUES(\"20\",\"Сельдерей\",\"80\",\"320\",\"6\",\"93600\",\"312\",\"240\",\"8\"*;
INSERT INTO kolhoz_plant VALUES(\"21\",\"Брокколи\",\"90\",\"90\",\"6\",\"26640\",\"150\",\"300\",\"9\"*;
INSERT INTO kolhoz_plant VALUES(\"22\",\"Огурец\",\"90\",\"360\",\"6\",\"105600\",\"370\",\"300\",\"9\"*;
INSERT INTO kolhoz_plant VALUES(\"23\",\"Кабачок\",\"100\",\"100\",\"8\",\"29520\",\"171\",\"300\",\"10\"*;
INSERT INTO kolhoz_plant VALUES(\"24\",\"Клубника\",\"100\",\"400\",\"8\",\"115200\",\"432\",\"300\",\"10\"*;
INSERT INTO kolhoz_plant VALUES(\"25\",\"Фасоль\",\"110\",\"110\",\"8\",\"32400\",\"193\",\"360\",\"11\"*;
INSERT INTO kolhoz_plant VALUES(\"26\",\"Баклажан\",\"110\",\"440\",\"8\",\"126000\",\"498\",\"360\",\"11\"*;
INSERT INTO kolhoz_plant VALUES(\"27\",\"Тыква\",\"120\",\"120\",\"6\",\"35280\",\"216\",\"360\",\"12\"*;
INSERT INTO kolhoz_plant VALUES(\"28\",\"Арбуз\",\"120\",\"480\",\"6\",\"136800\",\"567\",\"360\",\"12\"*;
INSERT INTO kolhoz_plant VALUES(\"29\",\"Чеснок\",\"130\",\"130\",\"10\",\"38160\",\"239\",\"420\",\"13\"*;
INSERT INTO kolhoz_plant VALUES(\"31\",\"Спаржа\",\"130\",\"520\",\"10\",\"147600\",\"639\",\"420\",\"13\"*;
INSERT INTO kolhoz_plant VALUES(\"32\",\"Кукуруза\",\"140\",\"140\",\"7\",\"38880\",\"263\",\"420\",\"14\"*;
INSERT INTO kolhoz_plant VALUES(\"33\",\"Патиссон\",\"140\",\"560\",\"7\",\"162000\",\"716\",\"420\",\"14\"*;
INSERT INTO kolhoz_plant VALUES(\"34\",\"Чили\",\"150\",\"150\",\"7\",\"43920\",\"288\",\"480\",\"15\"*;
INSERT INTO kolhoz_plant VALUES(\"35\",\"Дыня\",\"150\",\"600\",\"7\",\"172800\",\"795\",\"480\",\"15\"*;
INSERT INTO kolhoz_plant VALUES(\"36\",\"Ежевика\",\"160\",\"160\",\"13\",\"46800\",\"313\",\"480\",\"16\"*;
INSERT INTO kolhoz_plant VALUES(\"37\",\"Яблоко\",\"160\",\"640\",\"13\",\"183600\",\"878\",\"480\",\"16\"*;
INSERT INTO kolhoz_plant VALUES(\"38\",\"Крыжовник\",\"170\",\"170\",\"13\",\"49680\",\"339\",\"540\",\"17\"*;
INSERT INTO kolhoz_plant VALUES(\"39\",\"Груша\",\"170\",\"680\",\"13\",\"194400\",\"965\",\"540\",\"17\"*;
INSERT INTO kolhoz_plant VALUES(\"40\",\"Виноград\",\"180\",\"180\",\"14\",\"52560\",\"366\",\"540\",\"18\"*;
INSERT INTO kolhoz_plant VALUES(\"41\",\"Бананы\",\"180\",\"720\",\"14\",\"205200\",\"1054\",\"540\",\"18\"*;
INSERT INTO kolhoz_plant VALUES(\"42\",\"Малина\",\"190\",\"190\",\"14\",\"55440\",\"393\",\"600\",\"19\"*;
INSERT INTO kolhoz_plant VALUES(\"43\",\"Грибы\",\"190\",\"760\",\"14\",\"216000\",\"1149\",\"600\",\"19\"*;
INSERT INTO kolhoz_plant VALUES(\"44\",\"Вишня\",\"200\",\"200\",\"13\",\"58320\",\"422\",\"600\",\"20\"*;
INSERT INTO kolhoz_plant VALUES(\"45\",\"Подсолнух\",\"200\",\"800\",\"13\",\"230400\",\"1243\",\"600\",\"20\"*;
INSERT INTO kolhoz_plant VALUES(\"46\",\"Анютины Глазки\",\"210\",\"210\",\"18\",\"61200\",\"451\",\"660\",\"21\"*;
INSERT INTO kolhoz_plant VALUES(\"47\",\"Гибискусы\",\"220\",\"880\",\"13\",\"252000\",\"1446\",\"660\",\"22\"*;
INSERT INTO kolhoz_plant VALUES(\"48\",\"Ландыши\",\"230\",\"230\",\"17\",\"66960\",\"510\",\"720\",\"23\"*;
INSERT INTO kolhoz_plant VALUES(\"49\",\"Колокольчики\",\"240\",\"960\",\"19\",\"273600\",\"1660\",\"720\",\"24\"*;
INSERT INTO kolhoz_plant VALUES(\"50\",\"Тьюльпаны\",\"250\",\"250\",\"17\",\"94320\",\"573\",\"780\",\"25\"*;
INSERT INTO kolhoz_plant VALUES(\"51\",\"Лилии\",\"260\",\"1040\",\"22\",\"298800\",\"1888\",\"780\",\"26\"*;
INSERT INTO kolhoz_plant VALUES(\"52\",\"Гвоздики\",\"270\",\"270\",\"22\",\"78480\",\"638\",\"840\",\"27\"*;
INSERT INTO kolhoz_plant VALUES(\"53\",\"Ромашки\",\"280\",\"1120\",\"27\",\"320400\",\"2127\",\"840\",\"28\"*;
INSERT INTO kolhoz_plant VALUES(\"54\",\"Маки\",\"290\",\"290\",\"27\",\"84240\",\"706\",\"900\",\"29\"*;
INSERT INTO kolhoz_plant VALUES(\"55\",\"Розы\",\"300\",\"1200\",\"26\",\"342000\",\"2379\",\"900\",\"30\"*;
INSERT INTO kolhoz_plant VALUES(\"56\",\"Арахис\",\"310\",\"310\",\"27\",\"90000\",\"776\",\"960\",\"31\"*;
INSERT INTO kolhoz_plant VALUES(\"57\",\"Миндаль\",\"320\",\"1280\",\"27\",\"367200\",\"2643\",\"960\",\"32\"*;
INSERT INTO kolhoz_plant VALUES(\"58\",\"Фундук\",\"330\",\"330\",\"27\",\"97200\",\"849\",\"1020\",\"33\"*;
INSERT INTO kolhoz_plant VALUES(\"59\",\"Кедровый орех\",\"340\",\"1360\",\"29\",\"388800\",\"2919\",\"1020\",\"34\"*;
INSERT INTO kolhoz_plant VALUES(\"60\",\"Кокос\",\"350\",\"350\",\"27\",\"100800\",\"924\",\"1080\",\"35\"*;
INSERT INTO kolhoz_plant VALUES(\"61\",\"Лимон\",\"500\",\"2000\",\"30\",\"435600\",\"2600\",\"1080\",\"36\"*;
INSERT INTO kolhoz_plant VALUES(\"62\",\"Смородина\",\"500\",\"1500\",\"30\",\"165600\",\"1125\",\"1080\",\"37\"*;
INSERT INTO kolhoz_plant VALUES(\"63\",\"Слива\",\"600\",\"2500\",\"30\",\"464400\",\"2700\",\"1140\",\"37\"*;
INSERT INTO kolhoz_plant VALUES(\"64\",\"Облепиха\",\"600\",\"2000\",\"30\",\"176400\",\"1000\",\"1140\",\"38\"*;
INSERT INTO kolhoz_plant VALUES(\"65\",\"Персик\",\"40\",\"3500\",\"400\",\"507600\",\"2800\",\"1140\",\"38\"*;
INSERT INTO kolhoz_plant VALUES(\"66\",\"Черника\",\"480\",\"2500\",\"30\",\"198000\",\"870\",\"1140\",\"38\"*;
INSERT INTO kolhoz_plant VALUES(\"67\",\"Абрикос\",\"39\",\"5000\",\"30\",\"554400\",\"2900\",\"1200\",\"39\"*;
INSERT INTO kolhoz_plant VALUES(\"68\",\"Брусника\",\"450\",\"3500\",\"30\",\"219600\",\"850\",\"1200\",\"39\"*;
INSERT INTO kolhoz_plant VALUES(\"69\",\"Апельсин\",\"460\",\"7000\",\"30\",\"615600\",\"3000\",\"1200\",\"40\"*;
INSERT INTO kolhoz_plant VALUES(\"70\",\"Гранат\",\"470\",\"5000\",\"30\",\"248400\",\"950\",\"1200\",\"40\"*;
INSERT INTO kolhoz_plant VALUES(\"72\",\"Финики\",\"510\",\"10000\",\"30\",\"835200\",\"3000\",\"1260\",\"41\"*;
INSERT INTO kolhoz_plant VALUES(\"73\",\"Хурма\",\"520\",\"8000\",\"30\",\"338400\",\"2000\",\"1260\",\"42\"*;
INSERT INTO kolhoz_plant VALUES(\"74\",\"Киви\",\"530\",\"15000\",\"30\",\"928800\",\"6000\",\"1320\",\"43\"*;
INSERT INTO kolhoz_plant VALUES(\"75\",\"Манго\",\"540\",\"12000\",\"30\",\"399600\",\"3000\",\"1320\",\"44\"*;
INSERT INTO kolhoz_plant VALUES(\"76\",\"Айва\",\"550\",\"25000\",\"30\",\"1044000\",\"10000\",\"1380\",\"45\"*;
INSERT INTO kolhoz_plant VALUES(\"77\",\"Барбарис\",\"560\",\"15000\",\"30\",\"432000\",\"4000\",\"82800\",\"46\"*;
INSERT INTO kolhoz_plant VALUES(\"78\",\"Ирис\",\"570\",\"28000\",\"30\",\"1080000\",\"11000\",\"1380\",\"46\"*;
INSERT INTO kolhoz_plant VALUES(\"79\",\"Календула\",\"580\",\"18000\",\"30\",\"468000\",\"5000\",\"1440\",\"47\"*;
INSERT INTO kolhoz_plant VALUES(\"80\",\"Крапива\",\"590\",\"31000\",\"30\",\"1116000\",\"12000\",\"1440\",\"47\"*;
INSERT INTO kolhoz_plant VALUES(\"81\",\"Кувшинка\",\"600\",\"21000\",\"30\",\"504000\",\"6000\",\"1440\",\"48\"*;
INSERT INTO kolhoz_plant VALUES(\"82\",\"Одуванчик\",\"610\",\"33000\",\"30\",\"1152000\",\"13000\",\"1440\",\"48\"*;
INSERT INTO kolhoz_plant VALUES(\"83\",\"Подорожник\",\"620\",\"24000\",\"30\",\"540000\",\"7000\",\"1500\",\"49\"*;
INSERT INTO kolhoz_plant VALUES(\"84\",\"Сирень\",\"630\",\"36000\",\"30\",\"1188000\",\"14000\",\"1500\",\"49\"*;
INSERT INTO kolhoz_plant VALUES(\"85\",\"Василёк\",\"640\",\"27000\",\"30\",\"576000\",\"8000\",\"1500\",\"50\"*;
INSERT INTO kolhoz_plant VALUES(\"86\",\"Женьшень\",\"650\",\"40000\",\"30\",\"1224000\",\"15000\",\"1500\",\"50\"*;



DROP TABLE IF EXISTS `kolhoz_plant2`;

CREATE TABLE `kolhoz_plant2` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(500) DEFAULT NULL,
`cena` int(11) DEFAULT \'0\',
`rating` int(11) DEFAULT \'0\',
`count` int(11) DEFAULT \'0\',
`time` int(11) DEFAULT NULL,
`rubies` int(11) DEFAULT \'0\',
`time_soil2` int(11) DEFAULT \'0\',
`level` int(11) DEFAULT \'1\',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=318 DEFAULT CHARSET=utf8;

INSERT INTO kolhoz_plant2 VALUES(\"222\",\"Зелень для супа\",\"10\",\"20\",\"1\",\"500\",\"11\",\"0\",\"1\"*;
INSERT INTO kolhoz_plant2 VALUES(\"223\",\"Заправка для борща\",\"12\",\"50\",\"1\",\"800\",\"14\",\"0\",\"2\"*;
INSERT INTO kolhoz_plant2 VALUES(\"224\",\"Щавель солёный\",\"14\",\"150\",\"1\",\"1100\",\"17\",\"0\",\"2\"*;
INSERT INTO kolhoz_plant2 VALUES(\"225\",\"Огонёк\",\"16\",\"250\",\"1\",\"1400\",\"20\",\"0\",\"3\"*;
INSERT INTO kolhoz_plant2 VALUES(\"226\",\"Икра кабачковая\",\"18\",\"350\",\"1\",\"1700\",\"23\",\"0\",\"3\"*;
INSERT INTO kolhoz_plant2 VALUES(\"227\",\"Тёщин язык\",\"20\",\"450\",\"1\",\"2000\",\"26\",\"0\",\"4\"*;
INSERT INTO kolhoz_plant2 VALUES(\"228\",\"Лобио\",\"22\",\"550\",\"1\",\"2300\",\"29\",\"0\",\"4\"*;
INSERT INTO kolhoz_plant2 VALUES(\"229\",\"Лечо\",\"24\",\"650\",\"1\",\"2600\",\"32\",\"0\",\"4\"*;
INSERT INTO kolhoz_plant2 VALUES(\"230\",\"Фасоль с лукоми томатами\",\"26\",\"750\",\"1\",\"2900\",\"35\",\"0\",\"5\"*;
INSERT INTO kolhoz_plant2 VALUES(\"231\",\"Яблочный джем\",\"28\",\"850\",\"1\",\"3200\",\"38\",\"0\",\"5\"*;
INSERT INTO kolhoz_plant2 VALUES(\"232\",\"Ежевичное варенье\",\"30\",\"950\",\"1\",\"3500\",\"41\",\"0\",\"5\"*;
INSERT INTO kolhoz_plant2 VALUES(\"233\",\"Суфле морковно-яблочное\",\"32\",\"1050\",\"1\",\"3800\",\"44\",\"0\",\"6\"*;
INSERT INTO kolhoz_plant2 VALUES(\"234\",\"Квас из винограда\",\"34\",\"1150\",\"1\",\"4100\",\"47\",\"0\",\"7\"*;
INSERT INTO kolhoz_plant2 VALUES(\"235\",\"Постная фасоль\",\"36\",\"1250\",\"1\",\"4400\",\"50\",\"0\",\"7\"*;
INSERT INTO kolhoz_plant2 VALUES(\"236\",\"Аджика \",\"38\",\"1350\",\"1\",\"4700\",\"53\",\"0\",\"8\"*;
INSERT INTO kolhoz_plant2 VALUES(\"237\",\"Винегрет \",\"40\",\"1450\",\"1\",\"5000\",\"56\",\"0\",\"8\"*;
INSERT INTO kolhoz_plant2 VALUES(\"238\",\"Овощное рагу\",\"42\",\"1550\",\"1\",\"5300\",\"59\",\"0\",\"9\"*;
INSERT INTO kolhoz_plant2 VALUES(\"239\",\"Солянка\",\"44\",\"1650\",\"1\",\"5600\",\"62\",\"0\",\"10\"*;
INSERT INTO kolhoz_plant2 VALUES(\"240\",\"Салат из томатов и кабачков \",\"46\",\"1750\",\"1\",\"5900\",\"65\",\"0\",\"10\"*;
INSERT INTO kolhoz_plant2 VALUES(\"241\",\"Огурцы с хреном\",\"48\",\"1850\",\"1\",\"6200\",\"68\",\"0\",\"10\"*;
INSERT INTO kolhoz_plant2 VALUES(\"242\",\"Грибы от Игоряныча\",\"50\",\"1950\",\"1\",\"6500\",\"71\",\"0\",\"12\"*;
INSERT INTO kolhoz_plant2 VALUES(\"243\",\"Грибной паштет \",\"52\",\"2050\",\"1\",\"6800\",\"74\",\"0\",\"12\"*;
INSERT INTO kolhoz_plant2 VALUES(\"244\",\"Гороховый кисель\",\"54\",\"2150\",\"1\",\"7100\",\"77\",\"0\",\"12\"*;
INSERT INTO kolhoz_plant2 VALUES(\"245\",\"Яблочная настойка\",\"56\",\"2250\",\"1\",\"7400\",\"80\",\"0\",\"14\"*;
INSERT INTO kolhoz_plant2 VALUES(\"246\",\"Настойка из вишен\",\"58\",\"2350\",\"1\",\"7700\",\"83\",\"0\",\"14\"*;
INSERT INTO kolhoz_plant2 VALUES(\"247\",\"Мятная настойка\",\"60\",\"2450\",\"1\",\"8000\",\"86\",\"0\",\"16\"*;
INSERT INTO kolhoz_plant2 VALUES(\"248\",\"Грибы маринованные\",\"62\",\"2550\",\"1\",\"8300\",\"89\",\"0\",\"16\"*;
INSERT INTO kolhoz_plant2 VALUES(\"249\",\"Арбузы маринованные\",\"64\",\"2650\",\"1\",\"8600\",\"92\",\"0\",\"16\"*;
INSERT INTO kolhoz_plant2 VALUES(\"250\",\"Мусс ягодный\",\"66\",\"2750\",\"1\",\"8900\",\"95\",\"0\",\"16\"*;
INSERT INTO kolhoz_plant2 VALUES(\"251\",\"Чесночная настойка\",\"68\",\"2850\",\"1\",\"9200\",\"98\",\"0\",\"18\"*;
INSERT INTO kolhoz_plant2 VALUES(\"252\",\"Варенье из крыжовника\",\"70\",\"2950\",\"1\",\"9500\",\"101\",\"0\",\"18\"*;
INSERT INTO kolhoz_plant2 VALUES(\"253\",\"Настойка любительская \",\"72\",\"3050\",\"1\",\"9800\",\"104\",\"0\",\"18\"*;
INSERT INTO kolhoz_plant2 VALUES(\"254\",\"Варенье из винограда \",\"74\",\"3150\",\"1\",\"10100\",\"107\",\"0\",\"19\"*;
INSERT INTO kolhoz_plant2 VALUES(\"255\",\"Томатное пюре \",\"76\",\"3250\",\"1\",\"10400\",\"110\",\"0\",\"21\"*;
INSERT INTO kolhoz_plant2 VALUES(\"256\",\"Брокколи маринованные\",\"78\",\"3350\",\"1\",\"10700\",\"113\",\"0\",\"21\"*;
INSERT INTO kolhoz_plant2 VALUES(\"257\",\"Яблоки с хреном \",\"80\",\"3450\",\"1\",\"11000\",\"116\",\"0\",\"22\"*;
INSERT INTO kolhoz_plant2 VALUES(\"258\",\"Томаты в розовом рассоле\",\"82\",\"3550\",\"1\",\"11300\",\"119\",\"0\",\"22\"*;
INSERT INTO kolhoz_plant2 VALUES(\"259\",\"Крестьянский салат\",\"84\",\"3650\",\"1\",\"11600\",\"122\",\"0\",\"23\"*;
INSERT INTO kolhoz_plant2 VALUES(\"260\",\"Огурцы маринованные\",\"86\",\"3750\",\"1\",\"11900\",\"125\",\"0\",\"23\"*;
INSERT INTO kolhoz_plant2 VALUES(\"261\",\"Клубничная наливка \",\"88\",\"3850\",\"1\",\"12200\",\"128\",\"0\",\"23\"*;
INSERT INTO kolhoz_plant2 VALUES(\"262\",\"Дедов спотыкач\",\"90\",\"3950\",\"1\",\"12500\",\"131\",\"0\",\"23\"*;
INSERT INTO kolhoz_plant2 VALUES(\"263\",\"Джем из дыни\",\"92\",\"4050\",\"1\",\"12800\",\"134\",\"0\",\"23\"*;
INSERT INTO kolhoz_plant2 VALUES(\"264\",\"Банановое варенье\",\"94\",\"4150\",\"1\",\"13100\",\"137\",\"0\",\"25\"*;
INSERT INTO kolhoz_plant2 VALUES(\"265\",\"Клубничный компот\",\"96\",\"4250\",\"1\",\"13400\",\"140\",\"0\",\"2

2.
Rick Grimes * 2.94
(21 июл 2013, 15:01) [0/0] [0] [отв] [спам] [под] +1 | -1

Что это?

3.
mihamat *
[автор] (21 июл 2013, 15:02) [0/0] [0] [отв] [спам] [под] +1 | -1

таблицы
Добавлено 21.07.13 в 15:03:42:
Коментарий слишком большой, старайтесь коротко указать для чего испльзуется эта база данных
Коментарий слишком большой, старайтесь коротко указать для чего испльзуется эта база данных
Коментарий слишком большой, старайтесь коротко указать для чего испльзуется эта база данных
Коментарий слишком большой, старайтесь коротко указать для чего испльзуется эта база данных
Коментарий слишком большой, старайтесь коротко указать для чего испльзуется эта база данных
Коментарий слишком большой, старайтесь коротко указать для чего испльзуется эта база данных
Коментарий слишком большой, старайтесь коротко указать для чего испльзуется эта база данных

4.
Rick Grimes * 2.94
(21 июл 2013, 15:07) [1/0] [1] [отв] [спам] [под] +1 | -1

Почисть базу и перезалей

5.
mihamat *
[автор] (21 июл 2013, 15:10) [0/0] [0] [отв] [спам] [под] +1 | -1

nlight, а что тут ненужное?

6.
The_Red * [мошенник] 0.17
(21 июл 2013, 15:10) [0/0] [0] [отв] [спам] [под] +1 | -1

SQL запросом лей!!!

7.
mihamat *
[автор] (21 июл 2013, 15:15) [0/0] [0] [отв] [спам] [под] +1 | -1

The_Red, как?

8.
The_Red * [мошенник] 0.17
(21 июл 2013, 15:25) [0/0] [0] [отв] [спам] [под] +1 | -1

phpmyadmin > (выбор своей таблицы, и в том окне где \"Импорт\" левее SQL Запрос

Прикрепленные файлы:
* PROFIWM_RU_3946_334481_1.PNG (128.46 кб)
9.
mihamat *
[автор] (21 июл 2013, 15:42) [0/0] [0] [отв] [спам] [под] +1 | -1

The_Red, на keo.su

  • 1 из 1
Чтобы писать сообщения авторизируйтесь или пройдите регистрацию на сайте.
Подписаны: 0
Скачать тему | Файлы темы | Фильтр сообщений
* Правила сайта | * Реакции | * ББ коды | * Поиск
Онлайн: 147 из 27248
Последний:
Alikhan94 *