forked from sztupy/valasztas-adatbazis
-
Notifications
You must be signed in to change notification settings - Fork 1
/
Copy pathsznapilf.sql
295 lines (295 loc) · 8.73 KB
/
sznapilf.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
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
INSERT INTO sznapilf (valtip,maz,taz,sorsz,nemz,a,f) VALUES
('L','05','226','030',5,0,0),
('L','05','226','030',7,0,0),
('L','05','226','030',2,0,0),
('L','05','226','030',13,0,0),
('L','01','004','064',5,1,1),
('L','01','004','064',6,0,0),
('L','01','004','064',9,0,0),
('L','01','004','064',3,0,0),
('L','01','021','015',5,4,4),
('L','01','021','015',7,0,0),
('L','05','276','014',5,2,2),
('L','05','276','014',7,0,0),
('L','05','276','014',9,0,0),
('L','05','276','014',11,2,2),
('L','01','005','008',5,3,3),
('L','01','005','008',7,2,0),
('L','01','005','008',4,0,0),
('L','01','007','011',5,1,1),
('L','01','007','011',1,2,0),
('L','01','007','011',13,1,0),
('L','01','007','011',3,1,1),
('L','01','007','011',4,0,0),
('L','01','007','011',10,0,0),
('L','01','022','009',5,2,1),
('L','01','022','009',10,0,0),
('L','07','013','008',5,1,1),
('L','07','013','008',7,0,0),
('L','07','013','008',8,0,0),
('L','04','003','011',5,6,6),
('L','04','003','011',11,0,0),
('L','07','024','021',5,0,0),
('L','07','024','021',9,1,1),
('L','07','024','021',13,0,0),
('L','01','008','060',5,1,1),
('L','01','008','060',1,0,0),
('L','01','008','060',2,1,1),
('L','01','008','060',13,1,0),
('L','01','008','060',3,0,0),
('L','01','008','060',11,0,0),
('L','01','008','060',4,0,0),
('L','04','004','061',5,0,0),
('L','04','004','061',6,0,0),
('L','04','004','061',8,0,0),
('L','04','004','061',11,1,1),
('L','01','010','019',5,3,3),
('L','01','010','019',7,1,0),
('L','01','010','019',9,0,0),
('L','01','010','019',3,0,0),
('L','04','026','030',5,2,0),
('L','04','026','030',7,0,0),
('L','04','026','030',8,0,0),
('L','02','181','003',5,6,6),
('L','02','181','003',7,2,0),
('L','02','181','003',3,2,2),
('L','05','326','009',5,0,0),
('L','05','326','009',7,1,1),
('L','05','326','009',9,1,1),
('L','01','011','065',5,1,1),
('L','01','011','065',3,0,0),
('L','01','012','006',5,0,0),
('L','01','012','006',6,0,0),
('L','01','012','006',1,2,2),
('L','01','012','006',3,0,0),
('L','01','012','006',11,0,0),
('L','04','059','016',5,0,0),
('L','04','059','016',1,0,0),
('L','04','059','016',8,0,0),
('L','04','059','016',11,0,0),
('L','02','217','052',5,1,1),
('L','02','217','052',3,0,0),
('L','02','217','052',10,0,0),
('L','02','217','078',5,5,5),
('L','02','217','078',7,0,0),
('L','02','217','078',9,0,0),
('L','02','217','078',3,4,4),
('L','02','217','078',4,0,0),
('L','02','217','078',10,0,0),
('L','06','024','049',5,0,0),
('L','06','024','049',9,0,0),
('L','06','024','049',2,0,0),
('L','06','024','049',13,0,0),
('L','01','013','062',5,2,2),
('L','01','013','062',8,0,0),
('L','01','014','012',5,1,0),
('L','01','014','012',2,2,1),
('L','01','014','012',4,0,0),
('L','02','263','005',5,9,6),
('L','02','263','005',7,0,0),
('L','02','263','005',3,2,2),
('L','03','004','030',5,0,0),
('L','03','004','030',3,0,0),
('L','05','153','005',5,1,1),
('L','05','153','005',7,0,0),
('L','05','153','005',9,0,0),
('L','06','051','310',5,1,1),
('L','06','051','310',13,0,0),
('L','06','051','310',8,0,0),
('L','06','051','310',11,0,0),
('L','06','051','310',10,0,0),
('L','06','051','411',5,2,2),
('L','06','051','411',13,0,0),
('L','06','051','411',8,0,0),
('L','06','051','411',11,0,0),
('L','06','051','411',4,0,0),
('L','06','051','411',10,4,3),
('L','01','015','051',5,1,0),
('L','01','015','051',1,0,0),
('L','01','016','022',5,0,0),
('L','01','016','022',9,1,1),
('L','01','016','022',13,0,0),
('L','06','053','004',7,0,0),
('L','01','017','016',5,0,0),
('L','01','017','016',9,0,0),
('L','03','056','009',5,0,0),
('L','03','056','009',6,0,0),
('L','03','056','009',7,0,0),
('L','03','056','009',13,0,0),
('L','03','056','009',11,0,0),
('L','05','196','012',5,0,0),
('L','05','196','012',7,2,2),
('L','05','202','004',10,0,0),
('L','01','002','010',5,0,0),
('L','01','002','010',13,0,0),
('L','01','002','010',4,0,0),
('L','01','018','034',5,0,0),
('L','01','018','034',7,1,0),
('L','01','018','034',2,0,0),
('L','03','060','045',5,0,0),
('L','03','060','045',6,0,0),
('L','03','060','045',2,0,0),
('L','03','060','050',8,1,0),
('L','01','003','047',5,0,0),
('L','01','003','047',6,2,2),
('L','01','003','047',9,3,3),
('L','03','065','013',5,0,0),
('L','03','065','013',7,1,0),
('L','05','202','116',5,0,0),
('L','05','202','116',9,0,0),
('L','05','202','116',2,0,0),
('L','05','202','116',11,0,0),
('L','01','020','006',5,5,4),
('L','01','020','006',7,0,0),
('L','01','020','006',3,0,0),
('L','03','066','008',5,0,0),
('L','03','066','008',7,2,0),
('L','11','052','030',5,0,0),
('L','11','052','030',7,5,2),
('L','11','052','030',9,0,0),
('L','11','052','030',4,0,0),
('L','14','047','023',5,2,2),
('L','14','047','023',6,0,0),
('L','14','047','023',13,0,0),
('L','18','095','010',3,0,0),
('L','18','095','010',12,0,0),
('L','15','175','011',5,0,0),
('L','11','073','014',5,0,0),
('L','11','073','014',7,185,94),
('L','11','073','014',10,0,0),
('L','18','167','017',5,0,0),
('L','18','167','017',3,0,0),
('L','18','167','017',4,0,0),
('L','12','028','011',5,0,0),
('L','12','028','011',7,0,0),
('L','14','085','001',5,0,0),
('L','14','085','001',7,1,0),
('L','14','087','004',5,0,0),
('L','14','087','004',7,0,0),
('L','14','087','004',3,0,0),
('L','14','087','004',11,0,0),
('L','19','203','002',5,6,5),
('L','19','203','002',6,0,0),
('L','19','203','002',4,0,0),
('L','12','038','008',5,0,0),
('L','12','038','008',7,0,0),
('L','16','077','002',5,0,0),
('L','16','077','002',7,0,0),
('L','16','077','002',9,1,0),
('L','16','077','002',13,0,0),
('L','18','186','059',5,5,5),
('L','18','186','059',3,0,0),
('L','16','094','002',7,0,0),
('L','12','065','025',5,0,0),
('L','12','065','025',4,0,0),
('L','14','126','011',5,1,0),
('L','14','126','011',2,1,0),
('L','14','126','011',10,2,2),
('L','16','112','003',5,0,0),
('L','16','112','003',7,0,0),
('L','16','112','003',13,0,0),
('L','16','119','002',5,0,0),
('L','16','119','002',6,1,0),
('L','16','119','002',9,1,1),
('L','16','119','002',13,1,0),
('L','13','003','001',5,0,0),
('L','13','003','001',7,18,9),
('L','13','003','001',11,0,0),
('L','14','134','006',5,3,2),
('L','14','134','006',1,0,0),
('L','14','134','006',10,0,0),
('L','16','119','073',5,0,0),
('L','16','119','073',7,0,0),
('L','16','119','073',9,0,0),
('L','16','119','073',13,0,0),
('L','16','119','073',10,0,0),
('L','19','153','002',5,0,0),
('L','19','153','002',7,1,0),
('L','13','103','010',5,0,0),
('L','13','103','010',7,0,0),
('L','13','103','010',11,0,0),
('L','20','093','011',5,0,0),
('L','14','169','023',5,2,1),
('L','14','169','023',9,1,1),
('L','14','169','023',2,2,2),
('L','14','169','023',13,3,3),
('L','14','169','023',11,0,0),
('L','14','177','001',5,11,10),
('L','14','177','001',13,0,0),
('L','14','177','001',11,0,0),
('L','16','224','003',5,0,0),
('L','16','224','003',6,1,0),
('L','16','224','003',7,0,0),
('L','16','224','003',13,0,0),
('L','19','026','001',5,3,2),
('L','14','014','002',5,23,23),
('L','15','020','003',5,3,3),
('L','15','020','003',7,0,0),
('L','15','020','003',3,1,1),
('L','17','020','022',5,0,0),
('L','17','020','022',6,1,0),
('L','17','020','022',7,1,1),
('L','19','188','006',5,1,1),
('L','14','017','007',5,0,0),
('L','14','017','007',8,0,0),
('L','14','025','008',5,0,0),
('L','14','025','008',6,1,1),
('L','14','025','008',11,1,1),
('L','14','025','008',4,0,0),
('L','14','025','008',10,0,0),
('L','15','091','037',5,2,2),
('L','17','079','016',5,0,0),
('L','17','095','005',5,0,0),
('L','17','095','005',7,0,0),
('L','11','027','005',5,0,0),
('L','11','027','005',7,2,1),
('L','11','027','005',2,0,0),
('L','11','027','005',10,0,0),
('L','14','034','010',5,2,2),
('L','15','123','002',5,0,0),
('L','15','123','002',7,0,0),
('L','14','038','017',5,6,6),
('L','07','094','091',5,0,0),
('L','10','039','012',5,0,0),
('L','10','039','012',7,2,1),
('L','10','039','012',11,0,0),
('L','10','046','016',5,0,0),
('L','10','046','016',7,1,0),
('L','10','046','016',10,0,0),
('L','08','027','002',5,0,0),
('L','08','059','009',5,1,1),
('L','08','059','009',7,1,0),
('L','08','059','053',5,0,0),
('L','11','016','007',5,0,0),
('L','11','016','007',7,0,0),
('L','20','134','017',5,0,0),
('L','20','134','017',7,0,0),
('L','20','134','017',3,0,0),
('L','08','104','024',5,0,0),
('L','08','104','024',3,0,0),
('L','08','104','024',12,1,1),
('L','08','150','026',5,1,1),
('L','08','150','026',7,2,1),
('L','08','150','026',1,0,0),
('L','08','150','026',3,2,2),
('L','09','009','005',7,0,0),
('L','20','231','024',5,0,0),
('L','09','018','018',5,0,0),
('L','09','018','018',7,0,0),
('L','09','018','018',4,0,0),
('L','09','018','131',5,1,0),
('L','09','018','131',7,0,0),
('L','09','018','134',5,0,0),
('L','09','018','134',2,0,0),
('L','09','018','134',13,0,0),
('L','09','030','018',5,0,0),
('L','09','030','018',7,2,0),
('L','09','030','018',13,0,0),
('L','09','035','002',5,2,1),
('L','09','035','002',7,3,1),
('L','09','035','002',8,0,0),
('L','07','094','056',5,1,1),
('L','07','094','056',6,0,0),
('L','10','025','031',5,0,0),
('L','10','025','031',7,0,0),
('L','10','025','031',2,0,0);