--
-- Структура таблицы `shop`
--
CREATE TABLE `shop` (
`otdel` int(2) NOT NULL default '0',
`name` varchar(255) character set cp1251 NOT NULL default '',
`kol` int(11) NOT NULL default '0',
KEY `otdel` (`otdel`),
KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Дамп данных таблицы `shop`
--
INSERT INTO `shop` VALUES (1, 'knife1', 998);
INSERT INTO `shop` VALUES (1, 'knife2', 999);
INSERT INTO `shop` VALUES (1, 'knife3', 997);
INSERT INTO `shop` VALUES (1, 'knife4', 999);
INSERT INTO `shop` VALUES (1, 'knife5', 999);
INSERT INTO `shop` VALUES (1, 'knife6', 999);
INSERT INTO `shop` VALUES (1, 'knife7', 999);
INSERT INTO `shop` VALUES (1, 'knife8', 999);
INSERT INTO `shop` VALUES (1, 'knife9', 999);
INSERT INTO `shop` VALUES (1, 'knife10', 999);
INSERT INTO `shop` VALUES (1, 'knife11', 999);
INSERT INTO `shop` VALUES (2, 'sword1', 999);
INSERT INTO `shop` VALUES (2, 'sword2', 999);
INSERT INTO `shop` VALUES (2, 'sword3', 998);
INSERT INTO `shop` VALUES (2, 'sword4', 999);
INSERT INTO `shop` VALUES (2, 'sword5', 999);
INSERT INTO `shop` VALUES (2, 'sword6', 999);
INSERT INTO `shop` VALUES (2, 'sword7', 999);
INSERT INTO `shop` VALUES (2, 'sword8', 999);
INSERT INTO `shop` VALUES (2, 'sword9', 999);
INSERT INTO `shop` VALUES (2, 'sword10', 999);
INSERT INTO `shop` VALUES (2, 'sword11', 999);
INSERT INTO `shop` VALUES (2, 'sword12', 999);
INSERT INTO `shop` VALUES (2, 'sword13', 999);
INSERT INTO `shop` VALUES (2, 'sword14', 999);
INSERT INTO `shop` VALUES (2, 'sword15', 999);
INSERT INTO `shop` VALUES (2, 'sword16', 999);
INSERT INTO `shop` VALUES (2, 'sword17', 999);
INSERT INTO `shop` VALUES (2, 'sword18', 999);
INSERT INTO `shop` VALUES (2, 'sword19', 999);
INSERT INTO `shop` VALUES (2, 'sword20', 999);
INSERT INTO `shop` VALUES (2, 'sword21', 999);
INSERT INTO `shop` VALUES (2, 'sword22', 999);
INSERT INTO `shop` VALUES (2, 'sword23', 999);
INSERT INTO `shop` VALUES (2, 'sword24', 999);
INSERT INTO `shop` VALUES (2, 'sword25', 999);
INSERT INTO `shop` VALUES (2, 'sword26', 999);
INSERT INTO `shop` VALUES (2, 'sword27', 998);
INSERT INTO `shop` VALUES (2, 'sword28', 998);
INSERT INTO `shop` VALUES (3, 'axe1', 999);
INSERT INTO `shop` VALUES (3, 'axe2', 999);
INSERT INTO `shop` VALUES (3, 'axe3', 999);
INSERT INTO `shop` VALUES (3, 'axe4', 999);
INSERT INTO `shop` VALUES (3, 'axe5', 999);
INSERT INTO `shop` VALUES (3, 'axe6', 998);
INSERT INTO `shop` VALUES (3, 'axe7', 999);
INSERT INTO `shop` VALUES (3, 'axe8', 999);
INSERT INTO `shop` VALUES (3, 'axe9', 999);
INSERT INTO `shop` VALUES (3, 'axe10', 999);
INSERT INTO `shop` VALUES (3, 'axe11', 999);
INSERT INTO `shop` VALUES (3, 'axe12', 999);
INSERT INTO `shop` VALUES (3, 'axe13', 999);
INSERT INTO `shop` VALUES (3, 'axe14', 999);
INSERT INTO `shop` VALUES (3, 'axe15', 999);
INSERT INTO `shop` VALUES (3, 'axe16', 999);
INSERT INTO `shop` VALUES (3, 'axe17', 999);
INSERT INTO `shop` VALUES (3, 'axe18', 999);
INSERT INTO `shop` VALUES (3, 'axe19', 999);
INSERT INTO `shop` VALUES (3, 'axe20', 999);
INSERT INTO `shop` VALUES (4, 'hammer1', 999);
INSERT INTO `shop` VALUES (4, 'hammer2', 999);
INSERT INTO `shop` VALUES (4, 'hammer3', 997);
INSERT INTO `shop` VALUES (4, 'hammer4', 999);
INSERT INTO `shop` VALUES (4, 'hammer5', 999);
INSERT INTO `shop` VALUES (4, 'hammer6', 999);
INSERT INTO `shop` VALUES (3, 'axe21', 999);
INSERT INTO `shop` VALUES (4, 'hammer7', 997);
INSERT INTO `shop` VALUES (4, 'hammer8', 999);
INSERT INTO `shop` VALUES (4, 'hammer9', 999);
INSERT INTO `shop` VALUES (4, 'hammer10', 999);
INSERT INTO `shop` VALUES (4, 'hammer11', 999);
INSERT INTO `shop` VALUES (4, 'hammer12', 999);
INSERT INTO `shop` VALUES (4, 'hammer13', 999);
INSERT INTO `shop` VALUES (4, 'hammer14', 999);
INSERT INTO `shop` VALUES (4, 'hammer15', 999);
INSERT INTO `shop` VALUES (4, 'hammer16', 999);
INSERT INTO `shop` VALUES (4, 'hammer17', 999);
INSERT INTO `shop` VALUES (4, 'hammer18', 999);
INSERT INTO `shop` VALUES (4, 'hammer19', 999);
INSERT INTO `shop` VALUES (4, 'hammer20', 999);
INSERT INTO `shop` VALUES (4, 'hammer21', 999);
INSERT INTO `shop` VALUES (4, 'hammer22', 998);
INSERT INTO `shop` VALUES (2, 'sword29', 999);
INSERT INTO `shop` VALUES (2, 'sword30', 998);
INSERT INTO `shop` VALUES (2, 'sword31', 999);
INSERT INTO `shop` VALUES (3, 'axe22', 999);
INSERT INTO `shop` VALUES (6, 'helmet1', 994);
INSERT INTO `shop` VALUES (6, 'helmet2', 999);
INSERT INTO `shop` VALUES (6, 'helmet3', 998);
INSERT INTO `shop` VALUES (6, 'helmet4', 999);
INSERT INTO `shop` VALUES (6, 'helmet5', 999);
INSERT INTO `shop` VALUES (6, 'helmet6', 999);
INSERT INTO `shop` VALUES (6, 'helmet7', 999);
INSERT INTO `shop` VALUES (6, 'helmet8', 998);
INSERT INTO `shop` VALUES (6, 'helmet9', 999);
INSERT INTO `shop` VALUES (6, 'helmet10', 999);
INSERT INTO `shop` VALUES (6, 'helmet11', 999);
INSERT INTO `shop` VALUES (6, 'helmet12', 998);
INSERT INTO `shop` VALUES (6, 'helmet13', 998);
INSERT INTO `shop` VALUES (6, 'helmet14', 999);
INSERT INTO `shop` VALUES (6, 'helmet15', 999);
INSERT INTO `shop` VALUES (6, 'helmet16', 999);
INSERT INTO `shop` VALUES (6, 'helmet17', 998);
INSERT INTO `shop` VALUES (6, 'helmet18', 999);
INSERT INTO `shop` VALUES (6, 'helmet19', 999);
INSERT INTO `shop` VALUES (6, 'helmet20', 999);
INSERT INTO `shop` VALUES (6, 'helmet21', 999);
INSERT INTO `shop` VALUES (6, 'helmet22', 999);
INSERT INTO `shop` VALUES (6, 'helmet23', 999);
INSERT INTO `shop` VALUES (6, 'helmet24', 999);
INSERT INTO `shop` VALUES (6, 'helmet25', 999);
INSERT INTO `shop` VALUES (6, 'helmet26', 999);
INSERT INTO `shop` VALUES (6, 'helmet27', 999);
INSERT INTO `shop` VALUES (6, 'helmet28', 999);
INSERT INTO `shop` VALUES (6, 'helmet29', 999);
INSERT INTO `shop` VALUES (6, 'helmet30', 999);
INSERT INTO `shop` VALUES (6, 'helmet31', 998);
INSERT INTO `shop` VALUES (6, 'helmet32', 999);
INSERT INTO `shop` VALUES (6, 'helmet33', 999);
INSERT INTO `shop` VALUES (6, 'helmet34', 999);
INSERT INTO `shop` VALUES (6, 'helmet35', 998);
-- --------------------------------------------------------