-- phpMyAdmin SQL Dump
-- version 2.8.1
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Erstellungszeit: 14. Januar 2007 um 18:41
-- Server Version: 3.23.58
-- PHP-Version: 4.1.2
-- 
-- Datenbank: milano
-- 
DROP DATABASE IF EXISTS milano;
SHOW WARNINGS;
CREATE DATABASE IF NOT EXISTS milano;
SHOW WARNINGS;
USE milano;
SHOW WARNINGS;
----------------------------------------------------------------------------------------------------------------------------

-- 
-- table construction of stops;
-- 

DROP TABLE IF EXISTS stops;

SHOW WARNINGS;
CREATE TABLE IF NOT EXISTS stops (
  ID INT2,
  Name VARCHAR(50) BINARY,
  PandR ENUM ("Y", "N"),
  Mould_gating ENUM ("Y", "N"),
  Area INT2,
  Longitude Double (12,10),
  Latitude Double (12,10),
  PRIMARY KEY (ID)
);
SHOW WARNINGS;

-- 
-- datas of stops
-- 

INSERT INTO stops (ID, Name, PandR, Mould_gating, Area, Longitude, Latitude) VALUES 
(1, 'Sesto Maggio FS',         'N',      'Y',         11,	9.1881408,	45.4636889),
(2, 'Sesto Rondò',             'N',      'Y',         11,	9.2310369,	45.5342152),
(3, 'Sesto Marelli',           'Y',      'Y',         11,	9.2281871,	45.5238336),
(4, 'Villa San Giovanni',      'N',      'N',         7,	9.2262639,	45.5174656),
(5, 'Precotto',                'N',      'N',         7,	9.2241224,	45.5122460),
(6, 'Gorla',                   'N',      'N',         7,	9.2250183,	45.5054903),
(7, 'Turro',                   'N',      'N',         7,	9.2222705,	45.5003223),
(8, 'Rovereto',                'N',      'N',         6,	9.2197260,	45.4957816),
(9, 'Pasteur',                 'N',      'N',         6,	9.2179343,	45.4907295),
(10, 'Loreto',                 'N',      'N',         3,	9.2171184,	45.4862896),
(11, 'Lima',                   'N',      'N',         3,	9.2110464,	45.4805750),
(12, 'Porta Venezia',          'N',      'N',         3,	9.2052465,	45.4743049),
(13, 'Palestro',               'N',      'N',         3,	9.2018907,	45.4714531),
(14, 'San Babila',             'N',      'Y',         1,	9.1981752,	45.4669361),
(15, 'Duomo',                  'N',      'N',         1,	9.1892213,	45.4644613),
(16, 'Cordusio',               'N',      'N',         1,	9.1861329,	45.4650334),
(17, 'Cairoli',                'N',      'Y',         1,	9.1820759,	45.4682893),
(18, 'Cadorna F.N.Triennale',  'N',      'Y',         1,	9.1767772,	45.4684755),
(19, 'Conciliazione',          'N',      'N',         4,	9.1663420,	45.4675200),
(20, 'Pagano',                 'N',      'N',         4,	9.1608649,	45.4681257),
(21, 'Wagner',                 'N',      'N',         4,	9.1550446,	45.4676479),
(22, 'De Angeli',              'N',      'N',         4,	9.1497941,	45.4666697),
(23, 'Gambara',                'N',      'N',         4,	9.1432589,	45.4648873),
(24, 'Bande Nere',             'N',      'N',         8,	9.1370992,	45.4617081),
(25, 'Primaticcio',            'N',      'N',         8,	9.1292605,	45.4596020),
(26, 'Inganni',                'N',      'N',         8,	9.1225308,	45.4574845),
(27, 'Bisceglie',              'Y',      'Y',         8,	9.1132370,	45.4556567),
(28, 'Buonarroti',             'N',      'N',         4,	9.1553557,	45.4702738),
(29, 'Amendola Fiera',         'N',      'N',         4,	9.1511258,	45.4734572),
(30, 'Lotto',                  'N',      'Y',         4,	9.1428270,	45.4801300),
(31, 'QT8',                    'N',      'N',         8,	9.1376565,	45.4864778),
(32, 'Lampugnano',             'Y',      'Y',         8,	9.1197240,	45.4958320),
(33, 'Uruguay',                'N',      'N',         8,	9.1207552,	45.4932772),
(34, 'Bonola',                 'N',      'N',         8,	9.1109826,	45.4974793),
(35, 'Sant Leonardo',          'N',      'N',         8,	9.1017973,	45.5012788),
(36, 'Molino Dorino',          'Y',      'Y',         8,	9.0951213,	45.5059099),
(37, 'Pero',                   'N',      'N',         12,	9.0866393,	45.5089861),
(38, 'RHO Fiera',              'N',      'N',         12,	9.0868601,	45.5194662),
(39, 'Abbiategrasso',          'N',      'N',         5,	8.9198249,	45.3930345),
(40, 'Famagosta',              'Y',      'Y',         5,	9.1686916,	45.4377574),
(41, 'Romol',                  'Y',      'Y',         2,	9.1674685,	45.4441823),
(42, 'Porta Genova',           'N',      'Y',         2,	9.1734953,	45.4554208),
(43, 'Sant Agostino',          'N',      'N',         2,	9.1697645,	45.4585804),
(44, 'Sant Ambrogio',          'N',      'N',         1,	9.1759224,	45.4625487),
(45, 'Lanza',                  'N',      'N',         1,	9.1822859,	45.4717621),
(46, 'Moscova',                'N',      'N',         1,	9.1843691,	45.4779777),
(47, 'Porta Garibaldi F.S.',   'N',      'Y',         1,	9.1866463,	45.4839995),
(48, 'Gioia',                  'N',      'N',         3,	9.1954011,	45.4848006),
(49, 'Centrale F.S.',          'N',      'Y',         3,	9.2030333,	45.4851231),
(50, 'Caiazzo',                'N',      'N',         3,	9.2100151,	45.4855518),
(51, 'Piola',                  'N',      'N',         6,	9.2236890,	45.4803041),
(52, 'Lambrate F.S.',          'N',      'Y',         6,	9.2414943,	45.4810511),
(53, 'Udine',                  'N',      'N',         6,	9.2370021,	45.4910585),
(54, 'Cimiano',                'N',      'N',         6,	9.2407358,	45.4994665),
(55, 'Crescenzago',            'Y',      'N',         6,	9.2489644,	45.5072409),
(56, 'Cascina Gobba',          'Y',      'Y',         6,	9.2603642,	45.5110912),
(57, 'Cologno Sud',            'N',      'Y',         10,	9.2747945,	45.5200976),
(58, 'Cologno Centro',         'N',      'N',         10,	9.2829537,	45.5275167),
(59, 'Cologno Nord',           'Y',      'Y',         10,	9.2907751,	45.5340104),
(60, 'Vimodrone',              'N',      'N',         10,	9.2852229,	45.5134926),
(61, 'Cascina Burrona',        'N',      'N',         10,	9.2973089,	45.5172824),
(62, 'Cernusco S.N.',          'N',      'N',         10,	9.3323686,	45.5266377),
(63, 'Villa Fiorita',          'N',      'N',         10,	9.3455189,	45.5205600),
(64, 'Cascina De Pecchi',      'N',      'N',         10,	9.3682300,	45.5548985),
(65, 'Bussero',                'N',      'N',         10,	9.3727514,	45.5383105),
(66, 'Villa Pompea',           'N',      'N',         10,	9.3879294,	45.5244433),
(67, 'Gorgonzola',             'N',      'N',         10,	9.4057000,	45.5307050),
(68, 'Cascina Antonietta',     'N',      'N',         10,	9.4216530,	45.5407253),
(69, 'Gessate',                'Y',      'Y',         10,	9.4349877,	45.5557712),
(70, 'Maciachini',             'N',      'N',         8,	9.1847795,	45.4977632),
(71, 'Zara',                   'N',      'N',         3,	9.1881408,	45.4636889),
(72, 'Sondrio',                'N',      'N',         3,	9.2007065,	45.4894828),
(73, 'Repubblica',             'N',      'N',         3,	9.1969809,	45.4784404),
(74, 'Turati',                 'N',      'N',         1,	9.1942316,	45.4755647),
(75, 'Montenapoleone',         'N',      'N',         1,	9.1924855,	45.4702023),
(76, 'Missori',                'N',      'N',         1,	9.1882788,	45.4608787),
(77, 'Crocetta',               'N',      'N',         2,	9.1950054,	45.4564224),
(78, 'Porta Romana',           'N',      'N',         2,	9.2027456,	45.4530257),
(79, 'Lodi T.I.B.B',           'N',      'N',         2,	9.2133089,	45.4455507),
(80, 'Brenta',                 'N',      'N',         5,	9.2185834,	45.4424049),
(81, 'Corvetto',               'N',      'N',         5,	9.2239197,	45.4404270),
(82, 'Porto Di Mare',          'N',      'N',         5,	9.2304119,	45.4371617),
(83, 'Rogoredo F.S.',          'N',      'N',         5,	9.2388904,	45.4328901),
(84, 'Sant Donato',            'Y',      'Y',         9,	9.2562389,	45.4290427),
(85, 'Novate Milanese',        'N',      'N',         12,	9.1407814,	45.5317635),
(86, 'Quatro Oggiaro',         'N',      'N',         8,	9.1353123,	45.5184678),
(87, 'Bovisa',                 'N',      'Y',         8,	9.1666542,	45.5059201),
(88, 'Lancetti',               'N',      'N',         4,	9.1762161,	45.4953392),
(89, 'Dateo',                  'N',      'N',         3,	9.2166728,	45.4682122),
(90, 'Porta Vittoria',         'N',      'N',         6,	9.2070268,	45.4628749),
(91, 'Bruzzano',               'N',      'N',         8,	9.1734147,	45.5285775),
(92, 'Affori FNM',             'N',      'N',         8,	9.1591430,	45.5025120),
(93, 'Domodossola',            'N',      'N',         4,	9.1616531,	45.4813972),
(94, 'Certosa',                'N',      'N',         8,	9.2696604,	45.4102297),
(95, 'Villapizzone',           'N',      'N',         8,	9.1491215,	45.5015040),
(96, 'Segrate',                'N',      'N',         6,	9.2916939,	45.5011454),
(97, 'Pioltello',              'N',      'N',         6,	9.3311340,	45.5040180),
(98, 'Greco',                  'N',      'N',         7,	9.2123017,	45.5016713),
(99, 'Sant Christoforo',       'N',      'N',         5,	9.1554365,	45.4493481);
SHOW WARNINGS;

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

--
-- table construction of routes
-- 

DROP TABLE IF EXISTS routes;
SHOW WARNINGS;
CREATE TABLE IF NOT EXISTS routes (
  ID INT2,
  Name VARCHAR(50) BINARY,
  Colour VARCHAR(50) BINARY,
  Foundation DATE,
  PRIMARY KEY (ID)
);
SHOW WARNINGS;

-- 
-- datas table routes
-- 

INSERT INTO routes (ID, Name, Colour, Foundation) VALUES 
(1, 'M1A', 'red',  '1964-11-01'),
(2, 'M1B', 'red',  '1964-11-01'),
(3, 'M2A', 'green', '1969-01-01'),
(4, 'M2B', 'green', '1969-01-01'),
(5, 'M3' , 'yellow', '1990-05-01'),
(6, 'S1' , 'blue', '0000-00-00'),
(7, 'S2' , 'blue', '0000-00-00'),
(8, 'S3' , 'blue', '0000-00-00'),
(9, 'S4' , 'blue', '0000-00-00'),
(10, 'S5', 'blue', '0000-00-00'),
(11, 'S6', 'blue', '0000-00-00'),
(12, 'S9', 'blue', '0000-00-00'),
(13, 'S10', 'blue','0000-00-00');
SHOW WARNINGS;

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

-- 
-- table construction of farezone
-- 

DROP TABLE IF EXISTS farezone;
SHOW WARNINGS;
CREATE TABLE IF NOT EXISTS farezone (
  ID INT2,
  Name VARCHAR (30) BINARY,
  Price DECIMAL (9,2),
  PRIMARY KEY (ID,Name)
);
SHOW WARNINGS;

-- 
-- datas of farezone
-- 

INSERT INTO fare_zone (ID, Name, Price) VALUES
(1,  'Zone 1',   2.00),
(2,  'Zone 2',   1.30),
(3,  'Zone 3',   1.30),
(4,  'Zone 4',   1.30),
(5,  'Zone 5',   1.60),
(6,  'Zone 6',   1.60),
(7,  'Zone 7',   1.60),
(8,  'Zone 8',   1.60),
(9,  'Zone 9',   1.90),
(10, 'Zone 10',  1.90),
(11, 'Zone 11',  1.90),
(12, 'Zone 12',  1.90);
SHOW WARNINGS;

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

-- 
-- table construction of stopes_routes
--

DROP TABLE IF EXISTS stopes_routes;
SHOW WARNINGS;
CREATE TABLE IF NOT EXISTS stopes_routes (
  ID INT2,
  ID_Routes INT2,
  ID_Stops INT2,
  Succession INT2 UNSIGNED DEFAULT NULL,
  Driving_time TIME DEFAULT NULL,
  Distance INT4 DEFAULT NULL,
  PRIMARY KEY (ID),
  FOREIGN KEY (ID_Routes) REFERENCES routes(ID),
  FOREIGN KEY (ID_Stops) REFERENCES stops(ID)
);
SHOW WARNINGS;

-- 
-- datas of table stopes_routes
-- 

INSERT INTO stopes_routes (ID, ID_Routes, ID_Stops, Succession, Driving_time, Distance) VALUES 
(1,1,1,0,		'00:00:00',	 0),
(2,1,2,1,		'00:01:00',	675),
(3,1,3,2,		'00:03:00',	1785),
(4,1,4,3,		'00:04:00',	2475),
(5,1,5,4,		'00:05:00',	3120),
(6,1,6,5,		'00:07:00',	3720),
(7,1,7,6,		'00:08:00',	4410),
(8,1,8,7,    	'00:09:00',	5025),
(9,1,9,8,    	'00:11:00',	5550),
(10,1,10,9,  	'00:12:00',	6030),
(11,1,11,10, 	'00:13:00',	6840),
(12,1,12,11, 	'00:15:00',	7320),
(13,1,13,12, 	'00:16:00',	8070),
(14,1,14,13, 	'00:18:00',	8700),
(15,1,15,14, 	'00:19:00',	9435),
(16,1,16,15, 	'00:20:00',	9735),
(17,1,17,16, 	'00:21:00',	10170),
(18,1,18,17, 	'00:22:00',	10725),
(19,1,19,18, 	'00:24:00',	11550),
(20,1,20,19, 	'00:25:00',	11970),
(21,1,21,20, 	'00:26:00',	12405),
(22,1,22,21, 	'00:28:00',	12885),
(23,1,23,22, 	'00:29:00',	13425),
(24,1,24,23, 	'00:30:00',	13935),
(25,1,25,24, 	'00:31:00',	14655),
(26,1,26,25, 	'00:32:00',	15270),
(27,1,27,26, 	'00:33:00',	15945),
(28,2,1,0,   	'00:00:00',	0),
(29,2,2,1,   	'00:01:00',	675),
(30,2,3,2,   	'00:03:00',	1785),
(31,2,4,3,   	'00:04:00',	2475),
(32,2,5,4,   	'00:05:00',	3120),
(33,2,6,5,   	'00:07:00',	3720),
(34,2,7,6,   	'00:08:00',	4410),
(35,2,8,7,   	'00:09:00',	5025),
(36,2,9,8,   	'00:11:00',	5550),
(37,2,10,9,  	'00:12:00',	6030),
(38,2,11,10, 	'00:13:00',	6840),
(39,2,12,11, 	'00:15:00',	7320),
(40,2,13,12, 	'00:16:00',	8070),
(41,2,14,13, 	'00:18:00',	8700),
(42,2,15,14, 	'00:19:00',	9435),
(43,2,16,15, 	'00:20:00',	9735),
(44,2,17,16, 	'00:21:00',	10170),
(45,2,18,17, 	'00:22:00',	10725),
(46,2,19,18, 	'00:24:00',	11550),
(47,2,20,19, 	'00:25:00',	11970),
(48,2,28,20, 	'00:26:00',	12465),
(49,2,29,21, 	'00:28:00',	12990),
(50,2,30,22, 	'00:29:00',	13860),
(51,2,31,23, 	'00:31:00',	14835),
(52,2,32,24, 	'00:32:00',	15525),
(53,2,33,25, 	'00:34:00',	16215),
(54,2,34,26, 	'00:35:00',	17085),
(55,2,35,27, 	'00:36:00',	17925),
(56,2,36,28, 	'00:38:00',	18585),
(57,2,37,29, 	'00:39:00',	19395),
(58,2,38,30, 	'00:43:00',	22020),
(59,3,39,0,  	'00:00:00',	0),
(60,3,40,1,  	'00:02:00',	1200),
(61,3,41,2,  	'00:04:00',	2010),
(62,3,42,3,  	'00:06:00',	3015),
(63,3,43,4,  	'00:07:00',	4185),
(64,3,44,5,  	'00:08:00',	4620),
(65,3,18,6,  	'00:10:00',	5370),
(66,3,45,7,  	'00:11:00',	6000),
(67,3,46,8,  	'00:13:00',	6780),
(68,3,47,9,  	'00:15:00',	7485),
(69,3,48,10, 	'00:17:00',	8355),
(70,3,49,11, 	'00:18:00',	8940),
(71,3,50,12, 	'00:19:00',	9495),
(72,3,10,13, 	'00:20:00',	9915),
(73,3,51,14, 	'00:22:00',	10860),
(74,3,52,15, 	'00:23:00',	11730),
(75,3,53,16, 	'00:25:00',	12585),
(76,3,54,17, 	'00:27:00',	13755),
(77,3,55,18, 	'00:29:00',	14490),
(78,3,56,19, 	'00:31:00',	15735),
(79,3,57,20, 	'00:34:00',	17385),
(80,3,58,21, 	'00:36:00',	18345),
(81,3,59,22, 	'00:38:00',	19485),
(82,4,39,0,  	'00:00:00',	0),
(83,4,40,1,  	'00:02:00',	1200),
(84,4,41,2,  	'00:04:00',	2010),
(85,4,42,3,  	'00:06:00',	3015),
(86,4,43,4,  	'00:07:00',	4185),
(87,4,44,5,  	'00:08:00',	4620),
(88,4,18,6,  	'00:10:00',	5370),
(89,4,45,7,  	'00:11:00',	6000),
(90,4,46,8,  	'00:13:00',	6780),
(91,4,47,9,  	'00:15:00',	7485),
(92,4,48,10, 	'00:17:00',	8355),
(93,4,49,11, 	'00:18:00',	8940),
(94,4,50,12, 	'00:19:00',	9495),
(95,4,10,13, 	'00:20:00',	9915),
(96,4,51,14, 	'00:22:00',	10860),
(97,4,52,15, 	'00:23:00',	11730),
(98,4,53,16, 	'00:25:00',	12585),
(99,4,54,17, 	'00:27:00',	13755),
(100,4,55,18,	'00:29:00',	14490),
(101,4,56,19,	'00:31:00',	15735),
(102,4,60,20,	'00:34:00',	18240),
(103,4,61,21,	'00:36:00',	19500),
(104,4,62,22,	'00:40:00',	22380),
(105,4,63,23,	'00:41:00',	23325),
(106,4,64,24,	'00:43:00',	24465),
(107,4,65,25,	'00:44:00',	25245),
(108,4,66,26,	'00:46:00',	26640),
(109,4,67,27,	'00:48:00',	29865),
(110,4,68,28,	'00:50:00',	31140),
(111,4,69,29,	'00:51:00',	32220),
(112,5,70,0, 	'00:00:00',	0),
(113,5,71,1, 	'00:01:00',	990),
(114,5,72,2, 	'00:02:00',	1620),
(115,5,49,3, 	'00:03:00',	2310),
(116,5,73,4, 	'00:05:00',	2835),
(117,5,74,5, 	'00:06:00',	3555),
(118,5,75,6, 	'00:08:00',	4110),
(119,5,15,7, 	'00:09:00',	4860),
(120,5,76,8, 	'00:11:00',	5265),
(121,5,77,9, 	'00:12:00',	6045),
(122,5,78,10,	'00:13:00',	6765),
(123,5,79,11,	'00:15:00',	7500),
(124,5,80,12,	'00:16:00',	8355),
(125,5,81,13,	'00:17:00',	8760),
(126,5,82,14,	'00:19:00',	9435),
(127,5,83,15,	'00:20:00',	10185),
(128,5,84,16,	'00:22:00',	11715),
(129,6,85,0, 	'00:00:00',	0),
(131,6,87,2, 	'00:06:00',	3945),
(132,6,88,3, 	'00:08:00',	5595),
(133,6,47,4, 	'00:09:00',	7440),
(134,6,73,5, 	'00:10:00',	8370),
(135,6,12,6, 	'00:11:00',	9120),
(136,6,89,7, 	'00:12:00',	10545),
(137,6,90,8, 	'00:13:00',	12105),
(138,7,91,0, 	'00:00:00',	0),
(139,7,92,1, 	'00:02:00',	1320),
(140,7,87,2, 	'00:04:00',	3165),
(141,7,88,3, 	'00:06:00',	4815),
(142,7,47,4, 	'00:07:00',	6660),
(143,7,73,5, 	'00:08:00',	7590),
(144,7,12,6, 	'00:09:00',	8340),
(145,7,89,7, 	'00:10:00',	9765),
(146,7,90,8, 	'00:12:00',	11325),
(147,8,85,0, 	'00:00:00',	0),
(148,8,86,1, 	'00:03:00',	1845),
(149,8,87,2, 	'00:06:00',	3945),
(150,8,93,3, 	'00:08:00',	6075),
(151,8,18,4, 	'00:09:00',	7875),
(152,9,91,0, 	'00:00:00',	0),
(153,9,92,1, 	'00:02:00',	1320),
(154,9,87,2, 	'00:04:00',	3165),
(155,9,93,3, 	'00:06:01',	5295),
(156,9,18,4, 	'00:07:00',	7095),
(157,10,38,0,	'00:00:00',	0),
(158,10,94,1,	'00:06:00',	4950),
(159,10,95,2,	'00:08:00',	6630),
(160,10,88,3,	'00:09:00',	8385),
(161,10,47,4,	'00:10:00',	10230),
(162,10,73,5,	'00:11:00',	11160),
(163,10,12,6,	'00:12:00',	11910),
(164,10,89,7,	'00:13:00',	13335),
(165,10,90,8,	'00:15:00',	14895),
(166,10,96,9,	'00:18:00',	20970),
(167,10,97,10,	'00:21:00',	22440),
(168,11,38,0,	'00:00:00',	0),
(169,11,94,1,	'00:06:00',	4950),
(170,11,95,2,	'00:08:00',	6630),
(171,11,88,3,	'00:09:00',	8385),
(172,11,47,4,	'00:10:00',	10230),
(173,11,73,5,	'00:11:00',	11160),
(174,11,12,6,	'00:12:00',	11910),
(175,11,89,7,	'00:13:00',	13335),
(176,11,90,8,	'00:15:00',	14895),
(177,12,1,0, 	'00:00:00',	0),
(178,12,98,1,	'00:05:00',	3375),
(179,12,47,2,	'00:09:00',	7395),
(180,12,73,3,	'00:10:00',	8325),
(181,12,12,4,	'00:11:00',	9075),
(182,12,89,5,	'00:12:00',	10500),
(183,12,90,6,	'00:14:00',	12060),
(184,12,78,7,	'00:17:00',	16005),
(185,12,99,8,	'00:27:00',	23130),
(186,13,87,0,	'00:00:00',	0),
(187,13,88,1,	'00:02:00',	1650),
(188,13,47,2,	'00:03:00',	3495),
(189,13,73,3,	'00:04:00',	4425),
(190,13,12,4,	'00:05:00',	5175),
(191,13,89,5,	'00:06:00',	6600),
(192,13,90,6,	'00:08:00',	8160);
SHOW WARNINGS;

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

-- 
-- table construction of pois
-- 

DROP TABLE IF EXISTS pois;
SHOW WARNINGS;
CREATE TABLE IF NOT EXISTS pois (
  ID INT2 UNSIGNED NOT NULL,
  Name VARCHAR(100) BINARY,
  Typ INT2,
  Longitude Double (12,10),
  Latitude Double (12,10),
  Info TEXT,
  PRIMARY KEY (ID)
 );
SHOW WARNINGS;

-- 
-- datas of table pois
-- 

INSERT INTO pois (ID, Name, Typ, Longitude, Latitude, Info) VALUES 
(1,		'Basilika Sant` Ambrogio',				1,	9.1759224,	45.4625487,	'Eine der ältesten Kirchen Mailands. Das Museum enthält eine Schatzkammer mit kirchlichen Gegenständen.'),
(2, 	'Bibliothek Amrosiana',					2,	9.1881408,	45.4636889,	'Die Bibliothek aus dem Jahre um 1609 zählt zu den ersten öffentlichen Bibliotheken Europas. Derzeit befinden sich ungefähr 750 000 Bücher hier. Angeschlossen ist eine Pinakothek mit wertvollen Gemälden.'),
(3, 	'Castello Sforzesco',					3,	9.1803019,	45.4696756,	'Das Schloss wurde im 14. Jh. einst als Verteidigungsburg errichtet und beherbergt heute das Kunstmuseum mit alten Musikinstrumenten und Exponaten aus der Bildhauerei.'),
(4, 	'Dommuseum',							4,	9.1913785,	45.4628568,	'Die Geschichte und Bauweise des Doms, sowie Wandteppiche und alte Kirchenfenster zeigt das Dommuseum in den Räumlichkeiten des Königlichen Palastes.'),
(5, 	'Galleria Viottio Emanuelle II',		5,	9.1900149,	45.4656046, 'Überdachte Fußgängerzone mit exklusiven Geschäften und Restaurants. Unter der Glaskuppel befinden sich auf dem Boden vier Fußbodenmosaike, welche Landwirtschaft, Kunst, Wissenschaft und Industrie darstellen.'),
(6, 	'Kirche Santa Maria delle Grazie',		1,	9.1705000,	45.4659000,	'Dieses gotische Gotteshaus zählt zu den schönsten ganz Italiens. Neben dem kunsthistorischen eindrucksvollen Baustil ist im Innern das berühmteste Gemälde der Welt, das Abendmahl von Leonardo da Vinci zu betrachten.'),
(7, 	'Kirche San Maurizio',					1,	9.1711196,	45.4657265,	'Die Klosterkirche stammt aus dem frühen 16. Jh. und wurde im Renaissancestil erbaut. Besonders erwähnenswert ist der zweigeteilte Innenraum mit Fresken.'),
(8, 	'Mailänder Dom',						1,	9.1911701,	45.4642000, 'Die drittgrößte Kirche der Welt ist das berühmteste  Bauwerk der Stadt. Mit dem Bau des 157m langen und aus weißem Marmor bestehenden Gotteshauses wurde 1386 begonnen. Die Fassade wurde je doch erst um 1805 vollendet.'),
(9, 	'Museum für Wissenschaft und Technik',	4,	9.1696319,	45.4626251,	'Das Museum befindet sich im ehmaligen Kloster San Vittore aus dem 16. Jh. und enthält eine Sammlung der Geschichte der Industrie und Technik.'),
(10,	'Museum Poldi-Pezzoli',					4,	9.1914023,	45.4687017,	'In den Räumlichkeiten des Palastes werden Gemälde, Porzellan, Möbel, Schmuck und Uhren aus verschiedenen Jahrhunderten gezeigt. Graf Poldi Pezzoli, der einst hier wohnte, war selbst ein großer Kunstsammler.'),
(11,	'Panacoteca di Brera',					6,	9.1880605,	45.4719828,	'In dem schönen Palazzo befindet sich eine Gemäldesammlung mit über 2 000 Werken. Sie zählt zu den schönsten Kunstsammlungen der Welt.'),
(12,	'Scala',								7,	9.1903061,	45,4671502,	'Das von außen schlicht wirkende Gebäude wurde 1778 errichtet. Der prunkvolle Theaterraum wurde im neoklassizistischen Stil errichtet. Interessant ist auch ein Besuch des Theatermuseums.');
SHOW WARNINGS;

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

-- 
-- table construction of type
-- 

DROP TABLE IF EXISTS type;
SHOW WARNINGS;
CREATE TABLE IF NOT EXISTS type(
  ID INT2,
  Name VARCHAR(50) BINARY,
  PRIMARY KEY (ID)
);
SHOW WARNINGS;

-- 
-- datas of table type
-- 

INSERT INTO type (ID, Name) VALUES 
(1,	'Kirche'),
(2,	'Bibliothek'), 
(3, 'Schloss'), 
(4, 'Museum'), 
(5, 'Fußgängerzone'),
(6, 'Galerie'),
(7, 'Oper');
SHOW WARNINGS;
