1 files changed, 58 insertions, 0 deletions
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