2 files changed, 88 insertions, 0 deletions
diff --git a/db/to-dos/20120119160732_emergency_numbers_germany.rb b/db/to-dos/20120119160732_emergency_numbers_germany.rb
new file mode 100644
index 0000000..9dd9131
--- /dev/null
+++ b/db/to-dos/20120119160732_emergency_numbers_germany.rb
@@ -0,0 +1,30 @@
+# ruby encoding: utf-8
+
+class EmergencyNumbersGermany < ActiveRecord::Migration
+
+  def up
+    # add_column :phone_numbers, :uuid, :string
+    # add_index :phone_numbers, :uuid
+
+    germany = Country.find_by_name('Germany')
+
+    ################################################################
+    # Emergency numbers which shouldn't be used as extensions
+    ################################################################
+    notruf_nummern = germany.phone_number_ranges.find_or_create_by_name(SERVICE_NUMBERS)
+    notruf_nummern.phone_numbers.find_or_create_by_name_and_number('Polizei', '110')
+    notruf_nummern.phone_numbers.find_or_create_by_name_and_number('Feuerwehr', '112')
+    notruf_nummern.phone_numbers.find_or_create_by_name_and_number('Zentrale Behördenrufnummer', '115')
+    notruf_nummern.phone_numbers.find_or_create_by_name_and_number('Krankenwagen', '19222')
+    notruf_nummern.phone_numbers.find_or_create_by_name_and_number('Weisser Ring e. V.', '116006')
+    notruf_nummern.phone_numbers.find_or_create_by_name_and_number('Nummer gegen Kummer e. V.', '116111')
+    notruf_nummern.phone_numbers.find_or_create_by_name_and_number('Zentrale Anlaufstelle zur Sperrung elektronischer Berechtigungen', '116116')
+    notruf_nummern.phone_numbers.find_or_create_by_name_and_number('Kassenärztliche Vereinigung: ärztliche Bereitschaftsdienste', '116117')
+    notruf_nummern.phone_numbers.find_or_create_by_name_and_number('Katholische Bundesarbeitsgemeinschaft für Ehe-, Familien- und Lebensberatung, Telefonseelsorge', '116123')
+  end
+
+  def down
+    germany = Country.find_by_name('Germany')
+    germany.phone_number_ranges.where(:name => SERVICE_NUMBERS).destroy_all
+  end
+end
diff --git a/db/to-dos/20120223142004_add_more_german_area_codes.rb b/db/to-dos/20120223142004_add_more_german_area_codes.rb
new file mode 100644
index 0000000..2eb2554
--- /dev/null
+++ b/db/to-dos/20120223142004_add_more_german_area_codes.rb
@@ -0,0 +1,58 @@
+# encoding: UTF-8
+
+class AddMoreGermanAreaCodes < ActiveRecord::Migration
+  def up
+    # http://www.bundesnetzagentur.de/cln_1912/DE/Sachgebiete/Telekommunikation/RegulierungTelekommunikation/Nummernverwaltung/Nummernverwaltung_node.html
+
+    germany = Country.find_by_name('Germany')
+    german_service_number_range = germany.phone_number_ranges.find_by_name('service_numbers')
+
+    # Harmonisierte Dienste von sozialem Wert
+    #
+    (0..9).each do |x|
+      (0..9).each do |y|
+        (0..9).each do |z|
+          german_service_number_range.phone_numbers.create( 
+                            :name => "Harmonisierte Dienste von sozialem Wert", 
+                            :number => "116#{x}#{y}#{z}" 
+                                                          )
+        end
+      end
+    end 
+
+    # Auskunftsdienste
+    #
+    (0..9).each do |x|
+      (0..9).each do |y|
+          german_service_number_range.phone_numbers.create( 
+                            :name => "Auskunftsdienste", 
+                            :number => "118#{x}#{y}" 
+                                                          )
+      end
+    end
+
+    # Online-Dienste
+    #
+    (0..9).each do |x|
+      (0..9).each do |y|
+        (0..9).each do |z|
+          AreaCode.create( 
+                           :country_id => germany.id, 
+                           :name => 'Online-Dienste', 
+                           :area_code => "19#{x}#{y}#{z}"
+                         )
+        end
+      end
+    end
+
+    AreaCode.create(:country_id => germany.id, :name => 'Neuartige Dienste', :area_code => '12')
+    AreaCode.create(:country_id => germany.id, :name => 'Massenverkehrs-Dienste', :area_code => '137')
+    AreaCode.create(:country_id => germany.id, :name => 'Nutzergruppen', :area_code => '18')
+    AreaCode.create(:country_id => germany.id, :name => 'Internationale Virtuelle Private Netze', :area_code => '181')
+    AreaCode.create(:country_id => germany.id, :name => 'Nationale Teilnehmernummern', :area_code => '32')
+    AreaCode.create(:country_id => germany.id, :name => 'Anwählprogramme (Dialer)', :area_code => '9009')
+  end
+
+  def down
+  end
+end