about summary refs log tree commit diff stats
path: root/db
diff options
context:
space:
mode:
Diffstat (limited to 'db')
-rw-r--r--db/migrate/20231030181439_create_wittle_puzzles.wittle.rb12
-rw-r--r--db/migrate/20231030181440_create_wittle_scores.wittle.rb13
-rw-r--r--db/schema.rb20
3 files changed, 44 insertions, 1 deletions
diff --git a/db/migrate/20231030181439_create_wittle_puzzles.wittle.rb b/db/migrate/20231030181439_create_wittle_puzzles.wittle.rb new file mode 100644 index 0000000..9accf92 --- /dev/null +++ b/db/migrate/20231030181439_create_wittle_puzzles.wittle.rb
@@ -0,0 +1,12 @@
1# This migration comes from wittle (originally 20231028205751)
2class CreateWittlePuzzles < ActiveRecord::Migration[7.1]
3 def change
4 create_table :wittle_puzzles do |t|
5 t.text :data
6 t.text :solved_data
7 t.string :category
8
9 t.timestamps
10 end
11 end
12end
diff --git a/db/migrate/20231030181440_create_wittle_scores.wittle.rb b/db/migrate/20231030181440_create_wittle_scores.wittle.rb new file mode 100644 index 0000000..5110221 --- /dev/null +++ b/db/migrate/20231030181440_create_wittle_scores.wittle.rb
@@ -0,0 +1,13 @@
1# This migration comes from wittle (originally 20231028210722)
2class CreateWittleScores < ActiveRecord::Migration[7.1]
3 def change
4 create_table :wittle_scores do |t|
5 t.references :puzzle, null: false
6 t.string :name
7 t.string :ip
8 t.integer :seconds_taken
9
10 t.timestamps
11 end
12 end
13end
diff --git a/db/schema.rb b/db/schema.rb index 541f1c1..b036d7f 100644 --- a/db/schema.rb +++ b/db/schema.rb
@@ -10,7 +10,7 @@
10# 10#
11# It's strongly recommended that you check this file into your version control system. 11# It's strongly recommended that you check this file into your version control system.
12 12
13ActiveRecord::Schema[7.0].define(version: 2023_10_21_020306) do 13ActiveRecord::Schema[7.1].define(version: 2023_10_30_181440) do
14 create_table "active_storage_attachments", force: :cascade do |t| 14 create_table "active_storage_attachments", force: :cascade do |t|
15 t.string "name", null: false 15 t.string "name", null: false
16 t.string "record_type", null: false 16 t.string "record_type", null: false
@@ -416,6 +416,24 @@ ActiveRecord::Schema[7.0].define(version: 2023_10_21_020306) do
416 t.index ["votable_type", "votable_id"], name: "index_votes_on_votable" 416 t.index ["votable_type", "votable_id"], name: "index_votes_on_votable"
417 end 417 end
418 418
419 create_table "wittle_puzzles", force: :cascade do |t|
420 t.text "data"
421 t.text "solved_data"
422 t.string "category"
423 t.datetime "created_at", null: false
424 t.datetime "updated_at", null: false
425 end
426
427 create_table "wittle_scores", force: :cascade do |t|
428 t.integer "puzzle_id", null: false
429 t.string "name"
430 t.string "ip"
431 t.integer "seconds_taken"
432 t.datetime "created_at", null: false
433 t.datetime "updated_at", null: false
434 t.index ["puzzle_id"], name: "index_wittle_scores_on_puzzle_id"
435 end
436
419 add_foreign_key "active_storage_attachments", "active_storage_blobs", column: "blob_id" 437 add_foreign_key "active_storage_attachments", "active_storage_blobs", column: "blob_id"
420 add_foreign_key "active_storage_variant_records", "active_storage_blobs", column: "blob_id" 438 add_foreign_key "active_storage_variant_records", "active_storage_blobs", column: "blob_id"
421 add_foreign_key "blogs", "users" 439 add_foreign_key "blogs", "users"