upgrade auth, user and game

3 files changed, 7 insertions, 0 deletions

diff --git a/db/migrate/20240428013649_create_users.rb b/db/migrate/20240428013649_create_users.rb
index 04a58c6..5eaaf2c 100644
--- a/db/migrate/20240428013649_create_users.rb
+++ b/db/migrate/20240428013649_create_users.rb
@@ -1,6 +1,7 @@
 class CreateUsers < ActiveRecord::Migration[7.1]
   def change
     create_table :users do |t|
+      t.string :user_name # we need this for game urls
       t.string :identifier
       t.string :access_token_digest
       t.string :salt
diff --git a/db/migrate/20240509225147_create_games.rb b/db/migrate/20240509225147_create_games.rb
index af8f77b..6303c3c 100644
--- a/db/migrate/20240509225147_create_games.rb
+++ b/db/migrate/20240509225147_create_games.rb
@@ -1,7 +1,9 @@
 class CreateGames < ActiveRecord::Migration[7.1]
   def change
     create_table :games do |t|
+      t.belongs_to :user
       t.string :title
+      t.string :titleSlug
       #t.text :body
       #t.integer :status, default: 0
       #t.references :user, null: false, foreign_key: true
diff --git a/db/schema.rb b/db/schema.rb
index 3131a91..eca4cd1 100644
--- a/db/schema.rb
+++ b/db/schema.rb
@@ -54,12 +54,16 @@ ActiveRecord::Schema[7.1].define(version: 2024_05_09_225147) do
   end
 
   create_table "games", force: :cascade do |t|
+    t.bigint "user_id"
     t.string "title"
+    t.string "titleSlug"
     t.datetime "created_at", null: false
     t.datetime "updated_at", null: false
+    t.index ["user_id"], name: "index_games_on_user_id"
   end
 
   create_table "users", force: :cascade do |t|
+    t.string "user_name"
     t.string "identifier"
     t.string "access_token_digest"
     t.string "salt"