created puzzle and score tables

2 files changed, 23 insertions, 0 deletions

@@ -0,0 +1,11 @@
+class CreateWittlePuzzles < ActiveRecord::Migration[7.1]
+  def change
+    create_table :wittle_puzzles do |t|
+      t.text :data
+      t.text :solved_data
+      t.string :category
+
+      t.timestamps
+    end
+  end
+end
@@ -0,0 +1,12 @@
+class CreateWittleScores < ActiveRecord::Migration[7.1]
+  def change
+    create_table :wittle_scores do |t|
+      t.references :puzzle, null: false, foreign_key: true
+      t.string :name
+      t.string :ip
+      t.integer :seconds_taken
+
+      t.timestamps
+    end
+  end
+end