22 lines
17 KiB
Plaintext
22 lines
17 KiB
Plaintext
|
#This file is part of SECONDO.
|
|||
|
|
|
|||
|
|
#Copyright (C) 2004, University in Hagen, Department of Computer Science,
|
|||
|
|
#Database Systems for New Applications.
|
|||
|
|
|
|||
|
|
#SECONDO is free software; you can redistribute it and/or modify
|
|||
|
|
#it under the terms of the GNU General Public License as published by
|
|||
|
|
#the Free Software Foundation; either version 2 of the License, or
|
|||
|
|
#(at your option) any later version.
|
|||
|
|
|
|||
|
|
#SECONDO is distributed in the hope that it will be useful,
|
|||
|
|
#but WITHOUT ANY WARRANTY; without even the implied warranty of
|
|||
|
|
#MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
|
|||
|
|
#GNU General Public License for more details.
|
|||
|
|
|
|||
|
|
#You should have received a copy of the GNU General Public License
|
|||
|
|
#along with SECONDO; if not, write to the Free Software
|
|||
|
|
#Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
|
|||
|
|
|
|||
|
|
(create Orte : (rel(tuple((Kennzeichen string)(Ort string)(Vorwahl string)(BevT int)))));
|
|||
|
|
(update Orte := ((rel(tuple((Kennzeichen string)(Ort string)(Vorwahl string)(BevT int))))(("AC" "Aachen" "0241" 256)("AA" "Aalen/Wuerttemberg" "07361" 63)("WAF" "Ahlen/Westfalen" "02382" 55)("AW" "Bad Neuenahr/Ahrweil." "02641" 27)("AIC" "Aichach-Friedberg" "08251" 16)("BL" "Albstadt" "07431/32/35" 47)("AC" "Alsdort/Rheinland" "02404" 46)("ABG" "Altenburg" "03447" 55)("AK" "Altenkirchen/W'wald" "02681" 7)("A<>" "Altoetting" "08671" 11)("AZ" "Alzey" "06731" 16)("AM" "Amberg/Oberpfalz" "09621" 44)("AS" "Krs. Amberg-Sulzbach" "-" 43)("ANA" "Annaberg-Buchholz" "03733" 27)("AN" "Ansbach/Mittelfranken" "0981" 38)("APO" "Apolda" "03644" 27)("HSK" "Arnsberg" "02931" 78)("ARN" "Arnstadt" "03628" 26)("AB" "Aschaffenburg" "06021" 60)("ASL" "Aschersleben" "03473" 27)("ASl" "LKR Aue-Schwarzenberg" "03771" 33)("<22>" "Auerbach (Vogtland)" "03744" 22)("A" "Augsburg" "0821" 246)("SU" "St. Augustin" "02241" 55)("AUR" "Aurich (Ostfriesland)" "04941" 35)("BAD" "Baden-Baden" "07221" 49)("BL" "Balingen" "07433" 30)("BA" "Bamberg" "0951" 71)("Bl" "Bautzen" "03591" 52)("BT" "Bayreuth" "0921" 72)("WAF" "Beckum" "02521" 38)("BSK" "Beeskow" "03366" 9)("BEL" "Belzig" "033841" 8)("BGL" "Berchtesg. Land/Bad Reichenhall" "08652" 16)("R<>G" "Bergen, Krs. Ruegen" "03838" 16)("BM" "Bergheim/Erft" "02271" 62)("GL" "Bergisch Gladbach" "02202" 102)("UN" "Bergkamen" "02307" 53)("B" "Berlin" "030" 3410)("BBG" "Bemburg/Saale" "03471" 35)("BC" "Biberach/Riss" "07351" 31)("BI" "Bielefeld" "0521" 325)("LB" "Bietigheim-Bissingen" "07142" 40)("BIR" "Birkenfeld/Nahe" "06782" 7)("BIT" "Bitburg" "06561" 11)("BTF" "Bitterteld" "03493" 17)("BOR" "Bocholt (Kr. Borken)" "02871" 71)("BO" "Bochum" "0234" 382)("BB" "Boeblingen" "07031" 41)("BN." "Bonn" "0228" 291)("BOR" "Borken/Westf." "02861" 34)("BN" "Bomheim/Rheinl." "02222" 44)("BOT" "Bottrop" "02041" 122)("BRA" "Brake (Unterweser)" "04401" 17)("BRB" "Brandenburg" "03381" 78)("BS" "Braunschweig" "0531" 248)("HB" "Bremen, Hansestadt" "0421" 660)("HB" "Bremerhaven" "0471" 135)("KA" "Bruchsal" "07251" 37)("BM" "Bruehl/Rheinland" "02232" 43)("BRG" "Burg" "03921" 24)("HF" "Buende/Westfalen" "05223" 44)("B<>S" "Buesingen am Hochrhein" "07734" 1)("CW" "Calw/Hirsau" "07051" 23)("RE" "Castrop-Rauxel" "02305" 79)("CE" "Celle" "05141" 71)("CHA" "Cham/Oberpfalz" "09971" 17)("C" "Chemnitz" "0371" 314)("CLP" "Cloppenburg" "04471" 22)("CO" "Coburg" "09561" 45)("COC" "Cochem" "02671" 6)("C<>" "Coesfeld/Westfalen" "02541" 34)("CB" "Cottbus" "0355" 125)("CUX" "Cuxhaven" "04721" 57)("AZE" "Coswig (Kr.Anhalt-Zerbst)" "034903" 9)("DAH" "Dachau" "08131" 33)("DAN" "Dannenberg/Elbe" "05861" 9)("DA" "Darmstadt" "06151" 134)("DAU" "Daun" "06592" 9)("DEG" "Deggendorf" "0991" 34)("DZ" "Delitzsch" "034202" 27)("DEL" "Delmenhorst" "04221" 71)("DM" "Demmin" "03998" 14)("DE" "Dessau" "0340" 104)("UP" "Detmold" "05231" 73)("DH" "Diepholz" "05441" 15)("DLG" "Dillingen/Donau" "09071" 18)("DGF" "Dingolfing" "08731" 15)("WES" "Dinslaken" "02064" 71)("DW" "Dippoldiswalde" "03504" 8)("DBR" "Doberan, Bad" "038203" 11)("DL" "Doebeln" "03431" 24)("DON" "Donauwoerth" "0906" 18)("NE" "Dormagen" "02133" 63)("RE" "Dorsten" "02362" 80)("DO" "Dortmund" "0231" 570)("DD" "Dresden" "0351" 520)("C<>" "Duelmen" "02594" 40)("DN" "Dueren" "02421" 90)("D<>W" "Duerkheim, Bad" "06322" 18)("D" "Duesseldort" "0211" 566)("DU" "Duisburg" "0203" 528)("EBE" "Ebersberg/Oberb." "08092" 9)("BAR" "Eberswalde (Kr. Barnim)" "03334" 55)("EIC" "Kreis Eichsfeld" "-" 0)("EI" "Eichstaett/Bayern/Kreis" "08421" 13)("ESA" "Eisenach" "03691" 50)("EIS" "Eisenberg" "036691" 11)("EH" "Eisenhuettenstadt" "03364" 52)("EIL" "Eisleben" "03475" 22)("PI" "Elmshorn" "04121" 47)("EMD" "Emden" "04921" 53)("EM" "Emmendingen" "07641" 25)("EMS" "Ems, Bad" "02603" 10)("EL" "Emsland/Meppen" "05931" 33)("EN" "Ennepetal" "02333" 34)("ERB" "Erbach/Odenwald" "06062" 11)("ED" "Erding" "08122" 30)("BM" "Erftstadt" "02235" 50)("EF" "Erfurt" "0361" 218)("HS" "Erkelenz/Heinsberg" "02431" 43)("ME" "Erkrath" "0211" 49)("ER" "Erlangen" "09131" 101)("ERH" "Krs. Erlangen-Hoechstadt" "-" 0)("ESW" "Eschwege" "05651" 23)("AC" "Eschweiler/
|