Sandbird

Untitled

Jan 30th, 2022 (edited)
375
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 5.46 KB | None | 0 0
  1. CREATE TABLE `coords` (
  2.   `id` int(11) NOT NULL,
  3.   `region_gr` varchar(128) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  4.   `region_en` varchar(128) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  5.   `lat` decimal(18,6) DEFAULT NULL,
  6.   `lon` decimal(18,6) DEFAULT NULL
  7. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  8.  
  9.  
  10. INSERT INTO `coords` (`id`, `region_gr`, `region_en`, `lat`, `lon`) VALUES
  11. (1, 'Άγιο Όρος', 'Mount Athos', '40.264500', '24.215300'),
  12. (2, 'Αιτωλοακαρνανίας', 'Aetolia-Acarnania', '38.708400', '21.379900'),
  13. (3, 'Αν. Αττικής', 'East Attica', '38.045800', '23.858500'),
  14. (4, 'Άνδρου', 'Andros', '37.838100', '24.938600'),
  15. (5, 'Αργολίδας', 'Argolis', '37.652500', '22.858200'),
  16. (6, 'Αρκαδίας', 'Arcadia', '37.555800', '22.333800'),
  17. (7, 'Άρτας', 'Arta', '39.158200', '20.987700'),
  18. (8, 'Αττικής', 'Athens Prefecture', '38.045800', '23.858500'),
  19. (9, 'Αχαΐας', 'Achaea', '38.115900', '21.952200'),
  20. (10, 'Βοιωτίας', 'Boeotia', '38.366400', '23.096500'),
  21. (11, 'Γρεβενών', 'Grevena', '40.083800', '21.427300'),
  22. (12, 'Δράμας', 'Drama', '41.150200', '24.146900'),
  23. (13, 'Δυτ. Αττικής', 'West Attica', '38.096800', '23.430000'),
  24. (14, 'Εύβοιας', 'Euboea', '38.523600', '23.858500'),
  25. (15, 'Ευρυτανίας', 'Evrytania', '39.003200', '21.713800'),
  26. (16, 'Ζακύνθου', 'Zakynthos', '37.787000', '20.899900'),
  27. (17, 'Ηλείας', 'Elis', '37.704500', '21.570700'),
  28. (18, 'Ημαθίας', 'Imathia', '40.606000', '22.143000'),
  29. (19, 'Ηρακλείου', 'Heraklion', '35.338700', '25.144200'),
  30. (20, 'Θάσου', 'Thasos', '40.684500', '24.648400'),
  31. (21, 'Θεσπρωτίας', 'Thesprotia', '39.493500', '20.378500'),
  32. (22, 'Θεσσαλονίκης', 'Thessaloniki', '40.640100', '22.944400'),
  33. (23, 'Θήρας', 'Santorini', '36.393200', '25.461500'),
  34. (24, 'Ιθάκης', 'Ithaca', '38.428500', '20.676500'),
  35. (25, 'Ικαρίας', 'Icaria', '37.596700', '26.112300'),
  36. (26, 'Ιωαννίνων', 'Ioannina', '39.665000', '20.853700'),
  37. (27, 'Καβάλας', 'Kavala', '40.937600', '24.412900'),
  38. (28, 'Καλύμνου', 'Kalymnos', '36.953300', '26.979800'),
  39. (29, 'Καρδίτσας', 'Karditsa', '39.364000', '21.921400'),
  40. (30, 'Καρπάθου-Κάσου', 'Karpathos-Kasos', '35.401100', '26.926400'),
  41. (31, 'Καστοριάς', 'Kastoria', '40.519300', '21.268700'),
  42. (32, 'Κέας-Κύθνου', 'Kea-Kythnos', '37.607600', '24.310400'),
  43. (33, 'Κέρκυρας', 'Corfu', '39.625000', '19.922300'),
  44. (34, 'Κεφαλληνίας', 'Cephalonia', '38.175400', '20.569200'),
  45. (35, 'Κιλκίς', 'Kilkis', '40.993700', '22.875400'),
  46. (36, 'Κοζάνης', 'Kozani', '40.300600', '21.788800'),
  47. (37, 'Κορινθίας', 'Corinthia', '38.002300', '22.524500'),
  48. (38, 'Κω', 'Kos', '36.891500', '27.287700'),
  49. (39, 'Λακωνίας', 'Laconia', '37.029900', '22.524500'),
  50. (40, 'Λάρισας', 'Larissa', '39.639000', '22.419100'),
  51. (41, 'Λασιθίου', 'Lasithi', '35.081200', '25.710200'),
  52. (42, 'Λέσβου', 'Lesbos', '39.264500', '26.277700'),
  53. (43, 'Λευκάδας', 'Lefkada', '38.706600', '20.640700'),
  54. (44, 'Λήμνου', 'Lemnos', '39.919800', '25.141500'),
  55. (45, 'Μαγνησίας', 'Magnesia', '39.268600', '22.762900'),
  56. (46, 'Μεσσηνίας', 'Messenia', '37.142500', '21.952200'),
  57. (47, 'Μήλου', 'Milos', '36.691400', '24.393600'),
  58. (48, 'Μυκόνου', 'Mykonos', '37.446700', '25.328900'),
  59. (49, 'Νάξου', 'Naxos', '37.103600', '25.377700'),
  60. (50, 'Βορ. Τομ. Αθηνών', 'North Athens Regional Unit', '38.070800', '23.834700'),
  61. (51, 'Δυτ. Τομ Αθηνών', 'West Athens Regional Unit', '38.013900', '23.680000'),
  62. (52, 'Έβρου', 'Evros', '41.244400', '26.135900'),
  63. (53, 'Κεντρ. τομ. Αθηνών', 'Central Athens Regional Unit', '37.978700', '23.751400'),
  64. (54, 'Νήσων Αττικής', 'Islands Regional Unit', '37.558900', '23.215600'),
  65. (55, 'Νότ. Τομ. Αθηνών', 'South Athens Regional Unit', '37.898600', '23.751400'),
  66. (56, 'Ξάνθης', 'Xanthi', '41.136300', '24.887700'),
  67. (57, 'Πάρου', 'Paros', '37.085400', '25.151500'),
  68. (58, 'Πειραιώς', 'Piraeus', '37.943000', '23.647000'),
  69. (59, 'Πέλλας', 'Pella', '40.914800', '22.143000'),
  70. (60, 'Πιερίας', 'Pieria', '40.266900', '22.476800'),
  71. (61, 'Πρέβεζας', 'Preveza', '38.959300', '20.751700'),
  72. (62, 'Ρεθύμνου', 'Rethymno', '35.365600', '24.492000'),
  73. (63, 'Ροδόπης', 'Rhodope', '41.079600', '25.568100'),
  74. (64, 'Ρόδου', 'Rhodes', '36.435000', '28.217500'),
  75. (65, 'Σάμου', 'Samos', '37.754800', '26.977800'),
  76. (66, 'Σερρών', 'Serres', '41.086400', '23.548400'),
  77. (67, 'Σποράδων', 'Sporades', '39.116700', '23.716700'),
  78. (68, 'Σύρου', 'Syros', '37.438500', '24.913900'),
  79. (69, 'Τήνου', 'Tinos', '37.577300', '25.165200'),
  80. (70, 'Τρικάλων', 'Trikala', '39.555700', '21.767900'),
  81. (71, 'Φθιώτιδας', 'Phthiotis', '38.999800', '22.333800'),
  82. (72, 'Φλώρινας', 'Florina', '40.784500', '21.413100'),
  83. (73, 'Φωκίδας', 'Phocis', '38.559900', '22.143000'),
  84. (74, 'Χαλκιδικής', 'Chalkidiki', '40.369500', '23.287100'),
  85. (75, 'Χανίων', 'Chania', '35.513800', '24.018000'),
  86. (76, 'Χίου', 'Chios', '38.368200', '26.131000');
  87.  
  88. ALTER TABLE `coords`
  89.   ADD PRIMARY KEY (`id`),
  90.   ADD KEY `id` (`id`),
  91.   ADD KEY `lat` (`lat`),
  92.   ADD KEY `lon` (`lon`);
  93.  
  94. ALTER TABLE `coords`
  95.   MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=77;
Add Comment
Please, Sign In to add comment