1 files changed, 63 insertions, 0 deletions
diff --git a/db/migrate/20120119161152_snom_phones.rb b/db/migrate/20120119161152_snom_phones.rb
new file mode 100644
index 0000000..88c35f9
--- /dev/null
+++ b/db/migrate/20120119161152_snom_phones.rb
@@ -0,0 +1,63 @@
+# ruby encoding: utf-8
+
+class SnomPhones < ActiveRecord::Migration
+  def up
+  ################################################################
+  # Manufacturers
+  ################################################################
+  add_column :phone_models, :uuid, :string rescue puts "column already added"
+  snom = Manufacturer.find_or_create_by_ieee_name('SNOM Technology AG', 
+            {
+              :name => "SNOM Technology AG",
+              :homepage_url => 'http://www.snom.com'
+            }
+          )
+
+
+  ################################################################
+  # OUIs
+  ################################################################
+
+  snom.ouis.find_or_create_by_value('000413')
+
+
+  ################################################################
+  # Phone models
+  ################################################################
+
+  snom300 = snom.phone_models.create(:name => 'Snom 300', 
+                                    :product_homepage_url => 'http://www.snom.com/en/products/ip-phones/snom-300/',
+                                    :product_manual_homepage_url => 'http://wiki.snom.com/Snom300/Documentation')
+
+  snom320 = snom.phone_models.create(:name => 'Snom 320', 
+                                :product_homepage_url => 'http://www.snom.com/en/products/ip-phones/snom-320/',
+                                :product_manual_homepage_url => 'http://wiki.snom.com/Snom320/Documentation')
+
+  snom360 = snom.phone_models.create(:name => 'Snom 360', 
+                                :product_homepage_url => 'http://www.snom.com/en/products/ip-phones/snom-360/',
+                                :product_manual_homepage_url => 'http://wiki.snom.com/Snom360/Documentation')
+
+  snom370 = snom.phone_models.create(:name => 'Snom 370', 
+                                :product_homepage_url => 'http://www.snom.com/en/products/ip-phones/snom-370/',
+                                :product_manual_homepage_url => 'http://wiki.snom.com/Snom370/Documentation')
+
+  snom820 = snom.phone_models.create(:name => 'Snom 820', 
+                                :product_homepage_url => 'http://www.snom.com/en/products/ip-phones/snom-820/',
+                                :product_manual_homepage_url => 'http://wiki.snom.com/Snom820/Documentation')
+                                
+  snom821 = snom.phone_models.create(:name => 'Snom 821', 
+                                :product_homepage_url => 'http://www.snom.com/en/products/ip-phones/snom-821/',
+                                :product_manual_homepage_url => 'http://wiki.snom.com/Snom821/Documentation')
+                          
+  snom870 = snom.phone_models.create(:name => 'Snom 870', 
+                                :product_homepage_url => 'http://www.snom.com/en/products/ip-phones/snom-870/',
+                                :product_manual_homepage_url => 'http://wiki.snom.com/Snom870/Documentation')                                                     
+
+  end
+
+  def down
+    Manufacturer.destroy_all
+    Oui.destroy_all
+    PhoneModel.destroy_all
+  end
+end