-
Notifications
You must be signed in to change notification settings - Fork 1
/
Copy pathtowns_script.sql
123 lines (119 loc) · 4.61 KB
/
towns_script.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
insert into towns (name)
values
('Αθήνα'),
('Αιγάλεω'),
('Άνω Λιόσια'),
('Αχαρνές'),
('Βόρειος Τομεάς'),
('Βούλα'),
('Γέρακας'),
('Γλυφάδα'),
('Ελληνικό'),
('Καισαριανή'),
('Καλλιθέα'),
('Νέα Ιωνία'),
('Παιανία'),
('Παλλήνη'),
('Πειραιάς'),
('Περιστέρι'),
('Χαλάνδρι');
insert into areas (area, town_name)
values ('Κέντρο', 'Αθήνα');
insert into areas (area, town_name)
values ('Γκάζι', 'Αθήνα');
insert into areas (area, town_name)
values ('Μεταξουργείο', 'Αθήνα');
insert into areas (area, town_name)
values ('Φιλοθέη', 'Αθήνα');
insert into areas (area, town_name)
values ('Κολωνάκι', 'Αθήνα');
insert into areas (area, town_name)
values ('Πατήσια', 'Αθήνα');
insert into areas (area, town_name)
values ('Αιγάλεω', 'Αιγάλεω');
insert into areas (area, town_name)
values ('Πέτρου Ράλλη', 'Αιγάλεω');
insert into areas (area, town_name)
values ('Τατόι', 'Αχαρνές');
insert into areas (area, town_name)
values ('Κόκκινος Μύλος', 'Αχαρνές');
insert into areas (area, town_name)
values ('Βαρυμπόμπη', 'Αχαρνές');
insert into areas (area, town_name)
values ('Ολυμπιακό Χωριό', 'Αχαρνές');
insert into areas (area, town_name)
values ('Σταυρός', 'Γέρακας');
insert into areas (area, town_name)
values ('Μπαλάνα', 'Γέρακας');
insert into areas (area, town_name)
values ('Γαργηττός', 'Γέρακας');
insert into areas (area, town_name)
values ('Νταμάρια', 'Παιανία');
insert into areas (area, town_name)
values ('Φούρεσι', 'Παιανία');
insert into areas (area, town_name)
values ('Γλυκάνερα', 'Παιανία');
insert into areas (area, town_name)
values ('Μουσείο Βορρέ', 'Παιανία');
insert into areas (area, town_name)
values ('Τζιτζιφιές', 'Καλλιθέα');
insert into areas (area, town_name)
values ('Χαροκόπου', 'Καλλιθέα');
insert into areas (area, town_name)
values ('Χρυσάκη', 'Καλλιθέα');
insert into areas (area, town_name)
values ('Κέντρο', 'Νέα Ιωνία');
insert into areas (area, town_name)
values ('Περισσός', 'Νέα Ιωνία');
insert into areas (area, town_name)
values ('Πευκάκια', 'Νέα Ιωνία');
insert into areas (area, town_name)
values ('Καλογρέζα', 'Νέα Ιωνία');
insert into areas (area, town_name)
values ('Χαρβάτι', 'Παλλήνη');
insert into areas (area, town_name)
values ('Πανόραμα', 'Παλλήνη');
insert into areas (area, town_name)
values ('Λιμένας Ζέας', 'Πειραιάς');
insert into areas (area, town_name)
values ('Μικρολίμανο', 'Πειραιάς');
insert into areas (area, town_name)
values ('Καστέλλα', 'Πειραιάς');
insert into areas (area, town_name)
values ('Νέο Φάληρο', 'Πειραιάς');
insert into areas (area, town_name)
values ('Χατζηκυριάκειο', 'Πειραιάς');
insert into areas (area, town_name)
values ('Ανθούπολη', 'Περιστέρι');
insert into areas (area, town_name)
values ('Μπουρνάζι', 'Περιστέρι');
insert into areas (area, town_name)
values ('Πολύδροσο', 'Χαλανδρι');
insert into areas (area, town_name)
values ('Φραγκοκκλησία', 'Χαλάνδρι');
insert into areas (area, town_name)
values ('Ίλιον', 'Άνω Λιόσια');
insert into areas (area, town_name)
values ('Πανόραμα', 'Βούλα');
insert into areas (area, town_name)
values ('Άνω Γλυφάδα', 'Γλυφάδα');
insert into areas (area, town_name)
values ('Τερψιθέα', 'Γλυφάδα');
insert into areas (area, town_name)
values ('Κάτω Γλυφάδα', 'Γλυφάδα');
insert into areas (area, town_name)
values ('Άργυρούπολη', 'Ελληνικό');
insert into areas (area, town_name)
values ('Ηλιούπολη', 'Ελληνικό');
insert into areas (area, town_name)
values ('Άγιος Κοσμάς', 'Ελληνικό');
insert into areas (area, town_name)
values ('Κάραβελ', 'Καισαριανή');
insert into areas (area, town_name)
values ('Σκοπευτήριο', 'Καισαριανή');
insert into areas (area, town_name)
values ('Ηράκλειο', 'Βόρειος Τομέας');
insert into areas (area, town_name)
values ('Μαρούσι', 'Βόρειος Τομέας');
insert into areas (area, town_name)
values ('Κηφισιά', 'Βόρειος Τομέας');