class AddHasMagicFieldsTables < ActiveRecord::Migration
  def change
    create_table :magic_fields do |t|
      t.column :name,           :string
      t.column :label_name_en,    :string
      t.column :label_name_cn,    :string
      t.column :datatype,       :string, :default => "string"
      t.column :default,        :string
      t.column :is_required,    :boolean, :default => false
      t.column :include_blank,  :boolean, :default => false
      t.column :allow_other,    :boolean, :default => true
      t.column :type_scoped,    :string
      t.column :created_at,     :datetime
      t.column :updated_at,     :datetime
    end
    
    create_table :magic_attributes do |t|
      t.column :magic_field_id, :integer
      t.column :value, :string
      t.column :created_at, :datetime
      t.column :updated_at, :datetime
    end
    
    
    create_table :magic_field_relationships do |t|
      t.column :magic_field_id, :integer
      t.column :owner_id, :integer
      t.column :owner_type, :string
      t.column :name, :string
      t.column :type_scoped,   :string
      t.column :created_at, :datetime
      t.column :updated_at, :datetime
    end
    
    create_table :magic_attribute_relationships do |t|
      t.column :magic_attribute_id, :integer
      t.column :owner_id, :integer
      t.column :owner_type, :string
      t.column :created_at, :datetime
      t.column :updated_at, :datetime
    end  

    add_index :magic_attribute_relationships, [:magic_attribute_id, :owner_id, :owner_type], name:"magic_attribute_id_owner", :unique => true
    add_index :magic_field_relationships, [:magic_field_id, :owner_id, :owner_type], name:"magic_field_id_owner", :unique => true
    add_index :magic_field_relationships, [:name, :type_scoped, :owner_id, :owner_type], name:"magic_field_name_owner", :unique => true
  end

end