Sha256: d7d2c54da92069f1ca949ef6c056b190e196b86f0098600eb8fb4d7c1d9fb085

Contents?: true

Size: 1.43 KB

Versions: 16

Compression:

Stored size: 1.43 KB

Contents

class CreateContacts < ActiveRecord::Migration
  def self.up
    create_table :contacts, :force => true do |t|
      t.string      :uuid,   :limit => 36
      t.references  :user
      t.references  :lead
      t.integer     :assigned_to
      t.integer     :reports_to
      t.string      :first_name,  :limit => 64, :null => false, :default => ""
      t.string      :last_name,   :limit => 64, :null => false, :default => ""
      t.string      :access,      :limit => 8, :default => "Public"
      t.string      :title,       :limit => 64
      t.string      :department,  :limit => 64
      t.string      :source,      :limit => 32
      t.string      :email,       :limit => 64
      t.string      :alt_email,   :limit => 64
      t.string      :phone,       :limit => 32
      t.string      :mobile,      :limit => 32
      t.string      :fax,         :limit => 32
      t.string      :blog,        :limit => 128
      t.string      :linkedin,    :limit => 128
      t.string      :facebook,    :limit => 128
      t.string      :twitter,     :limit => 128
      t.string      :address
      t.date        :born_on
      t.boolean     :do_not_call, :null => false, :default => false
      t.datetime    :deleted_at
      t.timestamps
    end

    add_index :contacts, [ :user_id, :last_name, :deleted_at ], :unique => true, :name => 'id_last_name_deleted'
    add_index :contacts, :assigned_to
  end

  def self.down
    drop_table :contacts
  end
end

Version data entries

16 entries across 16 versions & 1 rubygems

Version Path
fat_free_crm-0.13.6 db/migrate/20100928030607_create_contacts.rb
fat_free_crm-0.13.5 db/migrate/20100928030607_create_contacts.rb
fat_free_crm-0.13.4 db/migrate/20100928030607_create_contacts.rb
fat_free_crm-0.13.3 db/migrate/20100928030607_create_contacts.rb
fat_free_crm-0.13.2 db/migrate/20100928030607_create_contacts.rb
fat_free_crm-0.12.3 db/migrate/20100928030607_create_contacts.rb
fat_free_crm-0.12.2 db/migrate/20100928030607_create_contacts.rb
fat_free_crm-0.13.1 db/migrate/20100928030607_create_contacts.rb
fat_free_crm-0.12.1 db/migrate/20100928030607_create_contacts.rb
fat_free_crm-0.13.0 db/migrate/20100928030607_create_contacts.rb
fat_free_crm-0.12.0 db/migrate/20100928030607_create_contacts.rb
fat_free_crm-0.11.4 db/migrate/20100928030607_create_contacts.rb
fat_free_crm-0.11.3 db/migrate/20100928030607_create_contacts.rb
fat_free_crm-0.11.2 db/migrate/20100928030607_create_contacts.rb
fat_free_crm-0.11.1 db/migrate/20100928030607_create_contacts.rb
fat_free_crm-0.11.0 db/migrate/20100928030607_create_contacts.rb