Add started at and props to user_product_tour table (#73299)

kobryan0619 · web-flow · commit f6697598769a · 2026-06-17T13:43:47.000-05:00
diff --git a/dashboard/app/models/user_product_tour.rb b/dashboard/app/models/user_product_tour.rb
@@ -6,6 +6,8 @@
 #  user_id      :integer          not null
 #  tour_name    :string(255)      not null
 #  completed_at :datetime         not null
+#  started_at   :datetime
+#  properties   :json
 #
 # Indexes
 #
diff --git a/dashboard/db/migrate/20260616120000_add_started_at_and_properties_to_user_product_tours.rb b/dashboard/db/migrate/20260616120000_add_started_at_and_properties_to_user_product_tours.rb
@@ -0,0 +1,6 @@
+class AddStartedAtAndPropertiesToUserProductTours < ActiveRecord::Migration[7.0]
+  def change
+    add_column :user_product_tours, :started_at, :datetime
+    add_column :user_product_tours, :properties, :json
+  end
+end
diff --git a/dashboard/db/schema.rb b/dashboard/db/schema.rb
@@ -10,7 +10,7 @@
 #
 # It's strongly recommended that you check this file into your version control system.
 
-ActiveRecord::Schema[7.0].define(version: 2026_06_01_152016) do
+ActiveRecord::Schema[7.0].define(version: 2026_06_16_120000) do
   create_table "activities", id: :integer, charset: "utf8mb3", collation: "utf8mb3_unicode_ci", force: :cascade do |t|
     t.integer "user_id"
     t.integer "level_id"
@@ -2732,6 +2732,8 @@
     t.integer "user_id", null: false
     t.string "tour_name", null: false
     t.datetime "completed_at", null: false
+    t.datetime "started_at"
+    t.json "properties"
     t.index ["user_id", "tour_name"], name: "index_user_product_tours_on_user_id_and_tour_name", unique: true
   end
 

Original file line number	Diff line number	Diff line change
`@@ -6,6 +6,8 @@`
`6`	`6`	`# user_id :integer not null`
`7`	`7`	`# tour_name :string(255) not null`
`8`	`8`	`# completed_at :datetime not null`
	`9`	`+# started_at :datetime`
	`10`	`+# properties :json`
`9`	`11`	`#`
`10`	`12`	`# Indexes`
`11`	`13`	`#`