   `name` varchar(100) NOT NULL,
   `class_id` int(11) NOT NULL,
   `coordinates` text NOT NULL,
+  `coords_center_lat` float NOT NULL,
+  `coords_center_lng` float NOT NULL,
   `owner_data_id` int(11) DEFAULT NULL,
   `reason` text NOT NULL,
   `date` date DEFAULT NULL,

  PRIMARY KEY (`parameter_id`),
  KEY `fk_stats_resources1_idx` (`resource_id`),
  KEY `fk_stats_resource_attributes1_idx` (`attribute_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=167 ;

--
-- Дамп данных таблицы `parameter`
--

INSERT INTO `parameter` (`parameter_id`, `value`, `resource_id`, `attribute_id`) VALUES
(110, 40, 97, 1),
(111, 20, 98, 1),
(134, 3476, 106, 1),
(139, 1500, 110, 1),
(141, 1234, 113, 2),
(152, 1, 144, 1),
(153, 1638, 144, 7),
(154, 95900, 145, 4),
(155, 190000, 145, 1),
(156, 1252, 145, 7),
(157, 60, 146, 2),
(158, 1190, 146, 1),
(159, 112370, 146, 4),
(160, 1366, 146, 7),
(161, 95902, 147, 4),
(162, 1252, 147, 7),
(163, 19180, 148, 4),
(164, 571, 148, 7),
(165, 0, 149, 4),
(166, 9210, 149, 7);

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


  `address` varchar(100) NOT NULL,
  `registrar_key` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`personal_data_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=173 ;

--
-- Дамп данных таблицы `personal_data`
