Add a list of languages and fix a few issues with the schema. Also get

[rails.git] / db / migrate / 034_create_languages.rb

diff --git a/db/migrate/034_create_languages.rb b/db/migrate/034_create_languages.rb
index daaf2199190d4c1669415bcf8633843cb5337956..cb6c392637e04931b1127b9c9281cb8767d26fda 100644 (file)
--- a/db/migrate/034_create_languages.rb
+++ b/db/migrate/034_create_languages.rb
@@ -3,17 +3,19 @@ require 'lib/migrate'
 class CreateLanguages < ActiveRecord::Migration
   def self.up
     create_table :languages, innodb_table do |t|
 class CreateLanguages < ActiveRecord::Migration
   def self.up
     create_table :languages, innodb_table do |t|

-      t.string :code, :limit => 5, :null => false
-      t.string :name, :null => false
-      t.boolean :translation_available, :null => false, :default => false
+      t.string :code, :null => false
+      t.string :english_name, :null => false
+      t.string :native_name

     end
 
     add_primary_key :languages, [:code]
 
     end
 
     add_primary_key :languages, [:code]
 

-    Language.create do |l|
-      l.code = 'en'
-      l.name = 'English'
-      l.translation_available = true
+    YAML.load(File.read(RAILS_ROOT + "/config/languages.yml")).each do |k,v|
+      Language.create do |l|
+        l.code = k
+        l.english_name = v["english"]
+        l.native_name = v["native"]
+      end

     end
 
     add_foreign_key :users, [:locale], :languages, [:code]
     end
 
     add_foreign_key :users, [:locale], :languages, [:code]