Sha256: e0a1215aff1ba4b7b2555cf06fdd13536e3ba26f2793a1688a4210a4e6b37c73

Contents?: true

Size: 1.06 KB

Versions: 7

Compression:

Stored size: 1.06 KB

Contents

class CreateSites < ActiveRecord::Migration[5.0]
  def up
    return if ActiveRecord::Base.connection.table_exists? :sites

    create_table 'site_nodes', force: :cascade do |t|
      t.string   'name',                   null: false
      t.integer  'sort', default: 0, null: false
      t.datetime 'created_at'
      t.datetime 'updated_at'
    end

    add_index 'site_nodes', ['sort'], name: 'index_site_nodes_on_sort', using: :btree

    create_table 'sites', force: :cascade do |t|
      t.integer  'user_id'
      t.integer  'site_node_id'
      t.string   'name',         null: false
      t.string   'url',          null: false
      t.string   'desc'
      t.datetime 'deleted_at'
      t.datetime 'created_at'
      t.datetime 'updated_at'
    end

    add_index 'sites', ['site_node_id'], name: 'index_sites_on_site_node_id', using: :btree
    add_index 'sites', ['url'], name: 'index_sites_on_url', using: :btree
    add_index :sites, [:site_node_id, :deleted_at]
  end

  def down
    drop_table :sites, if_exists: true
    drop_table :site_nodes, if_exists: true
  end
end

Version data entries

7 entries across 7 versions & 1 rubygems

Version Path
homeland-site-0.3.3 db/migrate/20170321125706_create_sites.rb
homeland-site-0.3.2 db/migrate/20170321125706_create_sites.rb
homeland-site-0.3.1 db/migrate/20170321125706_create_sites.rb
homeland-site-0.3.0 db/migrate/20170321125706_create_sites.rb
homeland-site-0.2.1 db/migrate/20170321125706_create_sites.rb
homeland-site-0.2.0 db/migrate/20170321125706_create_sites.rb
homeland-site-0.1.2 db/migrate/20170321125706_create_sites.rb