Files
turbovault-app/db/migrate/20260328200226_create_igdb_games.rb
2026-03-28 19:24:29 -04:00

21 lines
517 B
Ruby

class CreateIgdbGames < ActiveRecord::Migration[8.1]
def change
create_table :igdb_games do |t|
t.bigint :igdb_id, null: false
t.string :name, null: false
t.string :slug
t.string :cover_url
t.text :summary
t.date :first_release_date
t.integer :match_count, default: 0, null: false
t.datetime :last_synced_at
t.timestamps
end
add_index :igdb_games, :igdb_id, unique: true
add_index :igdb_games, :name
add_index :igdb_games, :slug
end
end