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 end def down drop_table :sites, if_exists: true drop_table :site_nodes, if_exists: true end end