MySQL Navi - Tabelle

--
-- Table structure for table `navi_categories`
--

CREATE TABLE IF NOT EXISTS `navi_categories` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `sub` INT(11) NOT NULL,
  `navilevel` INT(11) NOT NULL,
  `name` VARCHAR(32) CHARACTER SET latin1 NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=16 ;

--
-- Dumping data for table `navi_categories`
--

INSERT INTO `navi_categories` (`id`, `sub`, `navilevel`, `name`) VALUES
(7, 5, 0, 'Holzfäller'),
(2, 0, 0, 'Los Santos'),
(3, 0, 0, 'San Fierro'),
(4, 0, 0, 'Las Venturas'),
(5, 0, 0, 'Jobs'),
(6, 0, 0, 'Sonstiges'),
(8, 5, 0, 'Minenarbeiter'),
(9, 5, 0, 'Bauer'),
(10, 5, 0, 'Trucker'),
(11, 5, 0, 'Fischer'),
(15, 5, 0, 'Mechaniker'),
(14, 0, 1, 'Illegales');

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

--
-- Table structure for table `navi_places`
--

CREATE TABLE IF NOT EXISTS `navi_places` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `category` INT(10) UNSIGNED NOT NULL,
  `name` VARCHAR(128) CHARACTER SET latin1 NOT NULL,
  `posx` FLOAT NOT NULL,
  `posy` FLOAT NOT NULL,
  `posz` FLOAT NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=43 ;

--
-- Dumping data for table `navi_places`
--

INSERT INTO `navi_places` (`id`, `category`, `name`, `posx`, `posy`, `posz`) VALUES
(1, 2, 'Autohaus Coutt and Schutz', 2155.09, -1167.06, 23.55),
(2, 2, 'Arbeitsamt', 912, -990.8, 38),
(3, 2, 'Los Santos Police Department', 1529.23, -1672.51, 13.3828),
(4, 2, 'Krankenhaus', 1200.63, -1323.54, 13.3984),
(5, 2, 'Zivilisten Spawn', 346.292, -1770.08, 5.0473),
(6, 2, 'Rathaus', 1480.54, -1732.03, 13.3828),
(7, 2, 'Burgershot North ', 1216.3, -913.172, 42.9178),
(8, 2, 'Burgershot South', 825.813, -1624.87, 13.3828),
(9, 2, 'Ammunation ', 1350.64, -1279.14, 13.3828),
(10, 2, 'Taxi-Station', 1275.24, -1337.26, 13.06),
(11, 3, 'Autohaus Otto''s Autos', -1635.35, 1207.68, 7.0391),
(12, 3, 'San Fierro Police Department', -1605.51, 731.367, 11.8112),
(13, 3, 'Krankenhaus ', -2666.66, 573.148, 14.4544),
(14, 3, 'Autohaus Wang Cars', -1989.54, 288.627, 34.1947),
(15, 3, 'Fahrschule', -2864.49, 467.445, 4.8464),
(16, 2, 'Flughafen Los Santos', -1426.09, -292.61, 14.1484),
(17, 3, 'Flughafen San Fierro', 1961.54, -2183.94, 13.5469),
(18, 4, 'Flughafen Las Venturas', 1725.58, 1602.53, 10.0139),
(20, 7, 'Holzfäller-Lager', -837.867, -139.904, 62.8566),
(21, 8, 'Bergmine Las Venturas', 857.115, 866.383, 13.3516),
(22, 9, 'Bauernhof der Blueberry Acker', -51.58, 17.4, 3.12),
(23, 11, 'Hafen Los Santos', 2598.76, -2396.06, 13.5051),
(24, 10, 'Erzlager der Bergmine', 370.447, 981.245, 29.7576),
(25, 10, 'Fischlager vom Hafen Los Santos', 2760.44, -2453.48, 13.5461),
(26, 10, 'Truckdepot Fleischberg', 73.6198, -211.111, 1.4451),
(27, 10, 'Holzlager bei Blueberry', -837.867, -139.904, 62.8566),
(28, 10, 'Sägewerk in Angel Pine', -1976.76, -2445.38, 30.625),
(29, 10, 'Stahlwerk bei San Fierro', -1039.26, -587.89, 32),
(30, 14, 'Stahlwerk bei San Fierro', -1039.26, -587.89, 32),
(31, 14, 'Materialverarbeitung in Las Venturas', 2463.63, 1963.48, 10.8203),
(32, 14, 'Drogenlabor in San Fierro', -2137.76, -188.741, 34.8835),
(33, 14, 'Bauernhof in Blueberry', -51.58, 17.4, 3.12),
(38, 4, 'Flugzeug- und Bootshändler', 2287.67, 626.821, 10.8512),
(36, 6, 'Nächster Pay n Spray', 0, 0, 0),
(39, 15, 'Mechaniker Basis', 1411.83, -1648.69, 13.3828),
(40, 2, 'ZIP Kleidungsgeschäft', 1459.69, -1140.98, 24.053),
(41, 2, 'Fahrradhändler', 342.85, -1352.17, 14.5078),
(42, 2, 'Werbecenter', 1316.32, -1559.33, 13.3906);