Contents

class CreateEmailtemplates < ActiveRecord::Migration
  def self.up
    create_table :emailtemplates do |t|
      t.integer  :account_id,           :null=>false
      t.enum     :emailtemplate_type,   :limit=>[:PRODUCT, :ORDER, :INVOICE, :CUSTOMER]
      t.enum     :emailtemplate_senton, :limit=>[:CREATED, :PROCESSED, :COMPLETED, :CANCELED]
      t.string   :emailtemplate_name,   :limit=>255
      t.string   :emailtemplate_subject,:limit=>255
      t.text     :emailtemplate_body
      t.timestamps
    end
    add_index :emailtemplates, [:account_id, :emailtemplate_type,:emailtemplate_senton], :unique => true, :name=>"index_accont_emailtemplate_type_senton"
  end

  def self.down
    drop_table :emailtemplates
  end
end

Version data entries

5 entries across 5 versions & 2 rubygems

Version	Path
smukherjee-openbill-0.1.5	db/migrate/20090519071741_create_emailtemplates.rb
smukherjee-openbill-0.1.6	db/migrate/20090519071741_create_emailtemplates.rb
smukherjee-openbill-0.1.7	db/migrate/20090519071741_create_emailtemplates.rb
openbill-0.1.5	db/migrate/20090519071741_create_emailtemplates.rb
openbill-0.1.6	db/migrate/20090519071741_create_emailtemplates.rb