-- 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,7),
  Latitude Double (12,7), 
  x INT4 DEFAULT NULL,
  y INT4 DEFAULT NULL,
  PRIMARY KEY (ID)
);
SHOW WARNINGS;

-- 
-- datas of stops 
-- 

INSERT INTO stops (ID, Name, PandR, Mould_gating, Area, Longitude, Latitude, x, y) VALUES 
(1, 'Sesto Maggio FS',         'N',      'Y',         11,	9.238429,	45.541525,	16035,	15270),
(2, 'Sesto Rondo',             'N',      'Y',         11,	9.231005,	45.534191,	15465,	14025),
(3, 'Sesto Marelli',           'Y',      'Y',         11,	9.228172,	45.523758,	15180,	12780),
(4, 'Villa San Giovanni',      'N',      'N',          7,	9.226241,	45.517414,	15030,	12255),
(5, 'Precotto',                'N',      'N',          7,	9.224653,	45.512061,	14895, 	11610),
(6, 'Gorla',                   'N',      'N',          7,	9.222851,  	45.506467,  14770, 	11025),
(7, 'Turro',                   'N',      'N',          7,	9.221134,  	45.500782, 	14625, 	10335),
(8, 'Rovereto',                'N',      'N',          6,	9.219375,  	45.495940, 	14505,   9735),
(9, 'Pasteur',                 'N',      'N',          6,	9.217916,  	45.490675, 	14400,   9225),
(10, 'Loreto',                 'N',      'N',          3,	9.216886,  	45.486072, 	14295,   8745),
(11, 'Lima',                   'N',      'N',          3,	9.210792,  	45.480505, 	13845,   8070),
(12, 'Porta Venezia',          'N',      'N',          3,	9.205642,  	45.474637, 	13560,	 7680),
(13, 'Palestro',               'N',      'N',          3,	9.201865,  	45.471417, 	13140,	 7065),
(14, 'San Babila',             'N',      'Y',          1,	9.197273,  	45.466572, 	12810,	 6600),
(15, 'Duomo',                  'N',      'N',          1,	9.189205,  	45.464405, 	11970,	 6300),
(16, 'Cordusio',               'N',      'N',          1,	9.185944,  	45.465488, 	11925,	 6465),
(17, 'Cairoli',                'N',      'Y',          1,	9.182124,  	45.468137, 	11610,	 6795),
(18, 'Cadorna F.N.Triennale',  'N',      'Y',          1,	9.176760,  	45.468438, 	11205,	 6705),
(19, 'Conciliazione',          'N',      'N',          4,	9.166288,  	45.467445, 	10380,	 6660),
(20, 'Pagano',                 'N',      'N',          4,	9.160838,  	45.468077,   9960,	 6750),
(21, 'Wagner',                 'N',      'N',          4,	9.155002,  	45.467595,   9690,	 6705),
(22, 'De Angeli',              'N',      'N',          4,	9.149551,  	45.466572,   9075,	 6555),
(23, 'Gambara',                'N',      'N',          4,	9.143329,  	45.464766,   8550,	 6375),
(24, 'Bande Nere',             'N',      'N',          8,	9.136720,  	45.461876,   8160,	 6060),
(25, 'Primaticcio',            'N',      'N',          8,	9.129210,  	45.459529,   7530,	 5745),
(26, 'Inganni',                'N',      'N',          8,	9.122515,  	45.457452,   6960,	 5550),
(27, 'Bisceglie',              'Y',      'Y',          8,	9.113202,   45.455585,   6315,	 5295),
(28, 'Buonarroti',             'N',      'N',          4,	9.155302,  	45.470214,   9540,	 6990),
(29, 'Amendola Fiera',         'N',      'N',          4,	9.151096,  	45.473434,   9165,	 7380),
(30, 'Lotto',                  'N',      'Y',          4,	9.143629,  	45.479362,   8565,	 8025),
(31, 'QT8',                    'N',      'N',          8,	9.137235,  	45.485741,   7950,	 8805),
(32, 'Lampugnano',             'Y',      'Y',          8,	9.124746,  	45.488449,   7320,	 9090),
(33, 'Uruguay',                'N',      'N',          8,	9.120712,  	45.493232,   6780,	 9525),
(34, 'Bonola',                 'N',      'N',          8,	9.110627,   45.497654,   6015,	 9930),
(35, 'Sant Leonardo',          'N',      'N',          8,	9.101744,  	45.501234,   5325,	10380),
(36, 'Molino Dorino',          'Y',      'Y',          8,	9.095092,   45.505836,   4830,	10785),
(37, 'Pero',                   'N',      'N',         12,	9.089427,  	45.509836,   4170,	11205),
(38, 'RHO Fiera',              'N',      'N',         12,	9.086809,  	45.519429,   3000,	12825),
(39, 'Abbiategrasso',          'N',      'N',          5,   9.177747,  	45.430323,  11160,	 2520),
(40, 'Famagosta',              'Y',      'Y',          5,	9.168649,  	45.437731,  10605,	 3255),
(41, 'Romol',                  'Y',      'Y',          2,	9.167447,  	45.444115,  10485,	 4065),
(42, 'Porta Genova',           'N',      'Y',          2,	9.170022,  	45.452364,  10635,	 5055),
(43, 'Sant Agostino',          'N',      'N',          2,	9.169722,  	45.458535,  10665,	 5670),
(44, 'Sant Ambrogio',          'N',      'N',          1,	9.173069,   45.461545,  10920,	 6015),
(45, 'Lanza',                  'N',      'N',          1,	9.182081,   45.472140,  11625,	 7140),
(46, 'Moscova',                'N',      'N',          1,	9.184270,   45.477797,  11820,	 7860),
(47, 'Porta Garibaldi F.S.',   'N',      'Y',          1,	9.186630,  	45.483966,  12060,	 8445),
(48, 'Gioia',                  'N',      'N',          3,	9.195385,  	45.484778,  12630,	 8565),
(49, 'Centrale F.S.',          'N',      'Y',          3,	9.202981,  	45.485079,  13215,	 8550),
(50, 'Caiazzo',                'N',      'N',          3,	9.209075,   45.485380, 	13755,	 8655),
(51, 'Piola',                  'N',      'N',          6,	9.223666,  	45.480265,  14955,	 8145),
(52, 'Lambrate F.S.',          'N',      'Y',          6,	9.235640,   45.484537,  15735,	 8535),
(53, 'Udine',                  'N',      'N',          6,	9.236970,  	45.491036,  15870,	 9285),
(54, 'Cimiano',                'N',      'N',          6,	9.240704,  	45.499399,  16230,	10275),
(55, 'Crescenzago',            'Y',      'N',          6,	9.248214,  	45.505144,  16710,	10815),
(56, 'Cascina Gobba',          'Y',      'Y',          6,	9.260316,   45.511069,  17670,	11505),
(57, 'Cologno Sud',            'N',      'Y',         10,	9.274778,   45.520030,  18825,	12570),
(58, 'Cologno Centro',         'N',      'N',         10,	9.282932,  	45.527457,  19350,	13245),
(59, 'Cologno Nord',           'Y',      'Y',         10,	9.290786,  	45.533980,  19875,	13920),
(60, 'Vimodrone',              'N',      'N',         10,	9.286366,  	45.515550,  19380,	11955),
(61, 'Cascina Burrona',        'N',      'N',         10,	9.297266,   45.517233,  19950,	11835),
(62, 'Cernusco S.N.',          'N',      'N',         10,	9.330912,   45.520932,  20565,	11670),
(63, 'Villa Fiorita',          'N',      'N',         10,	9.345503,  	45.520511,  21360,	11445),
(64, 'Cascina De Pecchi',      'N',      'N',         10,	9.363055,   45.521894,  21945,	11235),
(65, 'Bussero',                'N',      'N',         10,	9.375758,  	45.525202,  22260,	10725),
(66, 'Villa Pompea',           'N',      'N',         10,	9.385500,  	45.527908, 	22350,	10455),
(67, 'Gorgonzola',             'N',      'N',         10,	9.403524,  	45.536626,  22425,	10185),
(68, 'Cascina Antonietta',     'N',      'N',         10,	9.423652,   45.542006,  22485,	 9735),
(69, 'Gessate',                'Y',      'Y',         10,	9.437041,  	45.545342,  22545,	 9285),
(70, 'Maciachini',             'N',      'N',          8,	9.184356,  	45.497714,  11865,	 9990),
(71, 'Zara',                   'N',      'N',          3,	9.192510,  	45.492330,  12450,	 9450),
(72, 'Sondrio',                'N',      'N',          3,	9.200664,  	45.489441,  13005,	 9195),
(73, 'Repubblica',             'N',      'N',          3,	9.196973,  	45.478911,  12915,	 8100),
(74, 'Turati',                 'N',      'N',          1,	9.194183,  	45.475540,  12615,	 7440),
(75, 'Montenapoleone',         'N',      'N',          1,	9.192467,  	45.470123, 	12450,	 6945),
(76, 'Missori',                'N',      'N',          1,	9.187703,  	45.460943,  12120,	 5895),
(77, 'Crocetta',               'N',      'N',          2,	9.194570,  	45.456428, 	12705,	 5370),
(78, 'Porta Romana',           'N',      'N',          2,	9.202981,  	45.451852,  13260,	 4905),
(79, 'Lodi T.I.B.B',           'N',      'N',          2,	9.210362,  	45.446734, 	13815,	 4425),
(80, 'Brenta',                 'N',      'N',          5,	9.218559,  	45.442368,  14580,	 3930),
(81, 'Corvetto',               'N',      'N',          5,	9.223881,  	45.440351,  14805,	 3690),
(82, 'Porto Di Mare',          'N',      'N',          5,	9.230361,  	45.437129, 	15360,	 3300),
(83, 'Rogoredo F.S.',          'N',      'N',          5,	9.238858,  	45.432852,  16035,	 2910),
(84, 'Sant Donato',            'Y',      'Y',          9,	9.256196,  	45.428998, 	17430,	 2535),
(85, 'Novate Milanese',        'N',      'N',         12,	9.132471,  	45.533048,   7770,	13950),
(86, 'Quatro Oggiaro',         'N',      'N',          8,	9.145303,  	45.519278,   8745,	12405),
(87, 'Bovisa',                 'N',      'Y',          8,	9.159250,  	45.502587,   9780,	10590),
(88, 'Lancetti',               'N',      'N',          4,	9.175730,  	45.494616,  10920,	 9645),
(89, 'Dateo',                  'N',      'N',          3,	9.216499,  	45.467655,  14355,	 6735),
(90, 'Porta Vittoria',         'N',      'N',          6,	9.223366,  	45.459649,  14865,	 5805),
(91, 'Bruzzano',               'N',      'N',          8,	9.171610,  	45.529080, 	10785,	13515),
(92, 'Affori FNM',             'N',      'N',          8,	9.165730,  	45.518346,  10320,	12285),
(93, 'Domodossola',            'N',      'N',          4,	9.162254,  	45.480686,	10050,	 8175),
(94, 'Certosa',                'N',      'N',          8,	9.134316,  	45.506738,   7815,  11055),
(95, 'Villapizzone',           'N',      'N',          8,	9.151053,  	45.501926,   9345,  10380),
(96, 'Segrate',                'N',      'N',          6,	9.298425,  	45.480776,  19065,   9840),
(97, 'Pioltello',              'N',      'N',          6,	9.327736,  	45.485921,  20655,  11925),
(98, 'Greco',                  'N',      'N',          7,	9.214010,   45.512272,  14115,  11715),
(99, 'Sant Christoforo',       'N',      'N',          5,	9.131784,  	45.443121,   7575,   3840);
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,
  Colour_line VARCHAR(15),
  PRIMARY KEY (ID)
);
SHOW WARNINGS;

-- 
-- datas table routes
-- 

INSERT INTO routes (ID, Name, Colour, Foundation, Colour_line) VALUES 
(1,  'M1A',	'rot',  	'1964-11-01',	'#FF0000'),
(2,  'M1B', 'rot',  	'1964-11-01',	'#FF0000'),
(3,  'M2A', 'grün', 	'1969-01-01',	'#00FF00'),
(4,  'M2B', 'grün', 	'1969-01-01',	'#00FF00'),
(5,  'M3' , 'gelb', 	'1990-05-01',	'#FFFF00'),
(6,  'S1' , 'blau', 	'0000-00-00',	'#0033FF'),
(7,  'S2' , 'blau', 	'0000-00-00',	'#0033FF'),
(8,  'S3' , 'blau', 	'0000-00-00',	'#0033FF'),
(9,  'S4' , 'blau', 	'0000-00-00',	'#0033FF'),
(10, 'S5',  'blau', 	'0000-00-00',	'#0033FF'),
(11, 'S6',  'blau', 	'0000-00-00',	'#0033FF'),
(12, 'S9',  'blau', 	'0000-00-00',	'#0033FF'),
(13, 'S10', 'blau',		'0000-00-00',	'#0033FF');
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 farezone (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 stops_routes
--

DROP TABLE IF EXISTS stops_routes;
SHOW WARNINGS;
CREATE TABLE IF NOT EXISTS stops_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 stops_routes
-- 

INSERT INTO stops_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(50) BINARY,
  Typ INT2,
  Longitude Double (12,7),
  Latitude Double (12,7),
  x INT4 DEFAULT NULL,
  y INT4 DEFAULT NULL,
  PRIMARY KEY (ID)
 );
SHOW WARNINGS;

-- 
-- datas of table pois
-- 

INSERT INTO pois (ID, Name, Typ, Longitude, Latitude, x, y) VALUES 
(1,		'Basilica Sant Ambrogio',			  	      1,	9.174882,	45.462117,	11115,	6090),
(2,		'Biblioteca Ambrosiana',					  2,	9.185879,	45.463728,  11865,	6210),
(3,		'Castello Sforzesco', 				  	      3,	9.179506,	45.470289,	11415,	6960),
(4,		'Duomos Museum',					       	  4,	9.192789,	45.463916,	12210,	6285),
(5,		'Galleria Vittorio Emanuelle II',     	      5,	9.190010,	45.465609,	12495,	6300),
(6,		'Santa Maria delle Grazie', 			      1,	9.170698,	45.465993,	10785,	6525),
(7,		'San Maurizio', 					          1,	9.166093,	45.464616,	11355,	6435),
(8,		'Dom de Milan',						          1,	9.191705,	45.464239,	12360,	6285),
(9,		'Museo della Scienza e della Technica',	      4,	9.170913,	45.462983,	10740,	6090),
(10,	'Poldi-Pezzoli',					          4,	9.191442,	45.468250,	12270,	6390),
(11,	'Pinacoteca di Brera', 					      6,	9.188052,	45.471974,	13620,	7155),
(12,	'Scala', 								      7,	9.189272,	45.464836,	12165,	6690);
SHOW WARNINGS;

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

-- 
-- table construction of type_poi
-- 

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

-- 
-- datas of table type_poi
-- 

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