# Copyright 2021 Google LLC
#
# Use of this source code is governed by an MIT-style
# license that can be found in the LICENSE file or at
# https://opensource.org/licenses/MIT.

class CreateTables < ActiveRecord::Migration[6.0]
  def change
    connection.ddl_batch do
      create_table :singers do |t|
        t.string :first_name
        t.string :last_name
        # `lock_version` is the default name for an optimistic lock version column in ActiveRecord.
        t.integer :lock_version
      end

      create_table :albums do |t|
        t.string :title
        t.numeric :marketing_budget
        t.references :singer, index: false, foreign_key: true
        # `lock_version` is the default name for an optimistic lock version column in ActiveRecord.
        t.integer :lock_version
      end
    end
  end
end