Файл: install/db_tables/fermer_name.sql
Строк: 17
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=28 ;
INSERT INTO `fermer_name` (`id`, `name`, `cena`,
`dohod`, `rand1`, `rand2`, `oput`, `time`, `level`) 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);