Sha256: 4186c78cf09c311b0779d52dcec14e0a42b42bbf823c8d21da008444b0154c77

Contents?: true

Size: 1.36 KB

Versions: 10

Compression:

Stored size: 1.36 KB

Contents

class CreatePeople < ActiveRecord::Migration
  def change
    create_table :people do |t|
      t.integer :sex, default: 1  , null: false
      t.integer :birth_year,  null: false, default: 0
      t.integer :birth_month, null: false, default: 0
      t.integer :birth_day,   null: false, default: 0
      t.string  :blood_type
      t.integer :created_by, null: false
      t.integer :updated_by, null: false
      t.timestamps
    end

    create_table :person_texts do |t|
      t.integer :parent_id, null: false
      t.integer :lang_id, null: false
      t.integer :created_by, null: false
      t.integer :updated_by, null: false
      t.timestamps
    end
    add_index :person_texts, [:parent_id,:lang_id], unique: true

    create_table :person_names do |t|
      t.integer :person_id, null: false
      t.integer :revision, null: false, default: 0
      t.date :modified_on, null: false
      t.timestamps
    end
    add_index :person_names, [:person_id,:revision], unique: true

    create_table :person_name_texts do |t|
      t.integer :parent_id, null: false
      t.integer :lang_id, null: false
      t.string :first_name, null: true
      t.string :first_name_pron, null: true
      t.string :last_name, null: true
      t.string :last_name_pron, null: true
    end
    add_index :person_name_texts, [:parent_id,:lang_id], unique: true, name: :idx_person_name_texts
  end
end

Version data entries

10 entries across 10 versions & 1 rubygems

Version Path
we_bridge_rails_engine_users-0.1.10 db/migrate/20150612005752_create_people.rb
we_bridge_rails_engine_users-0.1.9 db/migrate/20150612005752_create_people.rb
we_bridge_rails_engine_users-0.1.8 db/migrate/20150612005752_create_people.rb
we_bridge_rails_engine_users-0.1.7 db/migrate/20150612005752_create_people.rb
we_bridge_rails_engine_users-0.1.6 db/migrate/20150612005752_create_people.rb
we_bridge_rails_engine_users-0.1.5 db/migrate/20150612005752_create_people.rb
we_bridge_rails_engine_users-0.1.4 db/migrate/20150612005752_create_people.rb
we_bridge_rails_engine_users-0.1.3 db/migrate/20150612005752_create_people.rb
we_bridge_rails_engine_users-0.1.2 db/migrate/20150612005752_create_people.rb
we_bridge_rails_engine_users-0.1.0 db/migrate/20150612005752_create_people.rb