Merge branch 'main' into feature/406

backend/app/controllers/materials_controller.rb

@@ -236,10 +236,10 @@ class MaterialsController < ApplicationController
     nil
   end
 
-  def resolve_material_tag! locale, tag_name_raw
-    tag_name = TagName.find_undiscard_or_create_by!(language_code: locale.language_code,
-                                                    name: tag_name_raw)
-    tag_name.tag || Tag.create!(tag_name:, category: :material)
+  def resolve_material_tag! tag_name_raw
+    tag_name = TagName.find_undiscard_or_create_by!(name: tag_name_raw)
+    tag = tag_name.tag
+    tag || Tag.create!(tag_name:, category: :material)
   end
 
   def material_index_needs_tag_name? filters

backend/app/controllers/posts_controller.rb

@@ -311,7 +311,6 @@ class PostsController < ApplicationController
     base_version_no = parse_base_version_no
     return render_bad_request('base_version_no は必須です．') if !(force) && !(base_version_no)
 
-    locale = Locale.find_by(code: params[:locale].presence) || Locale.nipponese
     title = params[:title].presence
     tag_names = params[:tags].to_s.split
     original_created_from = params[:original_created_from]
@@ -333,8 +332,7 @@ class PostsController < ApplicationController
         base_snapshot = post_snapshot_from_version(base_version)
         current_snapshot = post_snapshot_from_record(post)
       end
-      incoming_snapshot = post_incoming_snapshot(locale:,
-                                                 title:,
+      incoming_snapshot = post_incoming_snapshot(title:,
                                                  original_created_from:,
                                                  original_created_before:,
                                                  tag_names:,
@@ -363,7 +361,7 @@ class PostsController < ApplicationController
             end
           end
 
-      apply_post_snapshot!(locale, post, snapshot_to_apply)
+      apply_post_snapshot!(post, snapshot_to_apply)
     end
 
     return render json: conflict_json, status: :conflict if conflict_json
@@ -735,11 +733,11 @@ class PostsController < ApplicationController
     end
   end
 
-  def post_incoming_snapshot locale:, title:, original_created_from:, original_created_before:,
+  def post_incoming_snapshot title:, original_created_from:, original_created_before:,
                              tag_names:, video_ms_param:, duration_param:, parent_post_ids:
     validate_original_created_values!(original_created_from, original_created_before)
-    Tag.normalise_tags!(locale, tag_names, with_tagme: false, deny_deprecated: true,
-                                           with_sections: true) =>
+    Tag.normalise_tags!(tag_names, with_tagme: false, deny_deprecated: true,
+                                        with_sections: true) =>
         { tags:, sections: }
 
     tags = Tag.expand_parent_tags(tags).reject(&:deprecated?)
@@ -875,7 +873,7 @@ class PostsController < ApplicationController
     (added_by_current & removed_by_me).present? || (removed_by_current & added_by_me).present?
   end
 
-  def apply_post_snapshot! locale, post, snapshot
+  def apply_post_snapshot! post, snapshot
     PostVersionRecorder.ensure_snapshot!(post, created_by_user: current_user)
 
     post.update!(title: snapshot[:title],
@@ -883,10 +881,10 @@ class PostsController < ApplicationController
                  original_created_from: snapshot[:original_created_from],
                  original_created_before: snapshot[:original_created_before])
 
-    Tag.normalise_tags!(locale, snapshot[:tag_names],
-                        with_tagme: false,
-                        deny_deprecated: true,
-                        with_sections: true) => { tags: editable_tags, sections: }
+    Tag.normalise_tags!(snapshot[:tag_names], with_tagme: false,
+                                               deny_deprecated: true,
+                                               with_sections: true) =>
+        { tags: editable_tags, sections: }
     TagVersioning.record_tag_snapshots!(editable_tags, created_by_user: current_user)
 
     readonly_tags = post.tags.nico.to_a

backend/app/models/language.rb

@@ -1,3 +0,0 @@
-class Language < ApplicationRecord
-  has_many :languages, class_name: 'Locale', foreign_key: :language_code
-end

backend/app/models/locale.rb

@@ -1,24 +0,0 @@
-class Locale < ApplicationRecord
-  after_create_commit :generate_tag_names!
-
-  belongs_to :language, foreign_key: :language_code, primary_key: :code
-  belongs_to :script, foreign_key: :script_code, primary_key: :code
-
-  def self.nipponese = Locale.find('ja')
-
-  private
-
-  def generate_tag_names!
-    tag_ids = TagName.where(language_code:, primary_flg: true).pluck(:tag_id)
-    Tag.where.not(id: tag_ids).find_each do
-      TagName.create!(tag_id: _1.id,
-                      language_code:,
-                      name: TagName.generate_name(self, _1, _1.name),
-                      script_code:,
-                      primary_flg: true,
-                      # TODO: 公証実装したら書く．
-                      # auto_generated: true,
-                      canonical_id: nil)
-    end
-  end
-end

backend/app/models/script.rb

@@ -1,3 +0,0 @@
-class Script < ApplicationRecord
-  ;
-end

backend/app/models/tag.rb

@@ -56,7 +56,6 @@ class Tag < ApplicationRecord
   has_many :tag_versions
   has_many :nico_tag_versions
 
-  has_many :tag_names
   belongs_to :tag_name
   delegate :wiki_page, to: :tag_name
 
@@ -106,20 +105,18 @@ class Tag < ApplicationRecord
 
   def has_deerjikists = deerjikists.loaded? ? deerjikists.any? : deerjikists.exists?
 
-  def self.tagme = find_or_create_by_tag_name!(Locale.nipponese, 'タグ希望', category: :meta)
-  def self.bot = find_or_create_by_tag_name!(Locale.nipponese, 'bot操作', category: :meta)
-  def self.no_deerjikist =
-      find_or_create_by_tag_name!(Locale.nipponese, 'ニジラー情報不詳', category: :meta)
-  def self.video = find_or_create_by_tag_name!(Locale.nipponese, '動画', category: :meta)
-  def self.niconico = find_or_create_by_tag_name!(Locale.nipponese, 'ニコニコ', category: :meta)
-  def self.youtube = find_or_create_by_tag_name!(Locale.nipponese, 'YouTube', category: :meta)
+  def self.tagme = find_or_create_by_tag_name!('タグ希望', category: :meta)
+  def self.bot = find_or_create_by_tag_name!('bot操作', category: :meta)
+  def self.no_deerjikist = find_or_create_by_tag_name!('ニジラー情報不詳', category: :meta)
+  def self.video = find_or_create_by_tag_name!('動画', category: :meta)
+  def self.niconico = find_or_create_by_tag_name!('ニコニコ', category: :meta)
+  def self.youtube = find_or_create_by_tag_name!('YouTube', category: :meta)
 
-  def self.normalise_tags! locale, tag_names,
-                           with_tagme: true,
-                           with_no_deerjikist: true,
-                           deny_nico: true,
-                           deny_deprecated: false,
-                           with_sections: false
+  def self.normalise_tags! tag_names, with_tagme: true,
+                                      with_no_deerjikist: true,
+                                      deny_nico: true,
+                                      deny_deprecated: false,
+                                      with_sections: false
     if deny_nico && tag_names.any? { |n| n.downcase.start_with?('nico:') }
       raise NicoTagNormalisationError
     end
@@ -148,7 +145,7 @@ class Tag < ApplicationRecord
 
       name = TagName.canonicalise(name).first
 
-      find_or_create_by_tag_name!(locale, name, category: (cat || :general)).tap do |tag|
+      find_or_create_by_tag_name!(name, category: (cat || :general)).tap do |tag|
         if deny_deprecated && tag.deprecated?
           raise DeprecatedTagNormalisationError, [tag.name]
         end
@@ -236,23 +233,13 @@ class Tag < ApplicationRecord
     [left_end_ms, right_end_ms].max
   end
 
-  def self.find_or_create_by_tag_name! locale, name, category:
-    language_code = locale.language_code
-    name = name.to_s.strip
+  def self.find_or_create_by_tag_name! name, category:
+    tn = TagName.find_undiscard_or_create_by!(name: name.to_s.strip)
+    tn = tn.canonical if tn.canonical_id?
 
-    tn = TagName.find_or_create_by!(language_code:, name:) do
-      _1.script_code = locale.script_code
-      _1.primary_flg = true
+    Tag.find_undiscard_or_create_by!(tag_name_id: tn.id) do |t|
+      t.category = category
     end
-
-    tag = tn.tag
-    unless tag
-      tag = Tag.find_undiscard_or_create_by!(tag_name_id: tn.id) do
-        _1.category = category
-      end
-    end
-
-    tag
   rescue ActiveRecord::RecordNotUnique
     retry
   end

backend/app/models/tag_name.rb

@@ -1,7 +1,7 @@
 class TagName < ApplicationRecord
   include MyDiscard
 
-  belongs_to :tag
+  has_one :tag
   has_one :wiki_page
 
   belongs_to :canonical, class_name: 'TagName', optional: true
@@ -23,12 +23,6 @@ class TagName < ApplicationRecord
     names.map { |name| tns[name]&.canonical&.name || name }.uniq
   end
 
-  def self.generate_name locale, tag, name
-    # TODO: 言語ごとの自動命名ロジック完成したら書く．
-
-    "Tag_##{ tag.id }"
-  end
-
   private
 
   def canonical_must_be_canonical

backend/db/migrate/20260919000000_create_languages.rb

@@ -1,20 +0,0 @@
-class CreateLanguages < ActiveRecord::Migration[8.0]
-  def up
-    create_table :languages, id: { type: :string, limit: 16 }, primary_key: :code do |t|
-      t.string :name, null: false
-      t.datetime :deprecated_at, index: true
-      t.datetime :created_at, null: false
-    end
-
-    execute <<~SQL
-      INSERT INTO
-        languages(code, name, created_at)
-      VALUES
-        ('ja', '日本語', #{ connection.quote Time.current })
-    SQL
-  end
-
-  def down
-    drop_table :languages
-  end
-end

backend/db/migrate/20260919010000_create_scripts.rb

@@ -1,20 +0,0 @@
-class CreateScripts < ActiveRecord::Migration[8.0]
-  def up
-    create_table :scripts, id: { type: 'CHAR(4)' }, primary_key: :code do |t|
-      t.string :name, null: false
-      t.datetime :deprecated_at, index: true
-      t.datetime :created_at, null: false
-    end
-
-    execute <<~SQL
-      INSERT INTO
-        scripts(code, name, created_at)
-      VALUES
-        ('Jpan', '漢字および仮名文字', #{ connection.quote Time.current })
-    SQL
-  end
-
-  def down
-    drop_table :scripts
-  end
-end

backend/db/migrate/20260919020000_create_locales.rb

@@ -1,25 +0,0 @@
-class CreateLocales < ActiveRecord::Migration[8.0]
-  def up
-    create_table :locales, id: { type: :string, limit: 32 }, primary_key: :code do |t|
-      t.string :language_code, limit: 16, null: false, index: true
-      t.column :script_code, 'CHAR(4)', null: false
-      t.string :name, null: false
-      t.datetime :deprecated_at, index: true
-      t.datetime :created_at, null: false
-
-      t.foreign_key :languages, column: :language_code, primary_key: :code
-      t.foreign_key :scripts, column: :script_code, primary_key: :code
-    end
-
-    execute <<~SQL
-      INSERT INTO
-        locales(code, language_code, script_code, name, created_at)
-      VALUES
-        ('ja', 'ja', 'Jpan', '日本語', #{ connection.quote Time.current })
-    SQL
-  end
-
-  def down
-    drop_table :locales
-  end
-end

backend/db/migrate/20260919030000_add_columns_to_tag_names.rb

@@ -1,59 +0,0 @@
-class AddColumnsToTagNames < ActiveRecord::Migration[8.0]
-  def up
-    add_reference :tag_names, :tag, after: :id, foreign_key: true
-    add_column :tag_names, :language_code, :string,
-               limit: 16, null: false, after: :tag_id, default: 'ja'
-    add_column :tag_names, :script_code, 'CHAR(4)',
-               null: false, after: :name, default: 'Jpan'
-    add_column :tag_names, :primary_flg, :boolean,
-               null: false, after: :script_code, default: true
-
-    add_foreign_key :tag_names, :languages, column: :language_code, primary_key: :code
-    add_foreign_key :tag_names, :scripts, column: :script_code, primary_key: :code
-
-    remove_index :tag_names, :name
-    add_index :tag_names, [:language_code, :name], unique: true
-
-    change_column_default :tag_names, :language_code, from: 'ja', to: nil
-    change_column_default :tag_names, :script_code, from: 'Jpan', to: nil
-
-    execute <<~SQL
-      UPDATE
-        tag_names tn
-        LEFT JOIN
-          tags AS t
-          ON
-            t.tag_name_id = COALESCE(tn.canonical_id, tn.id)
-      SET
-        tn.tag_id = t.id
-      , tn.primary_flg = CASE
-                         WHEN tn.canonical_id IS NULL THEN
-                           1
-                         ELSE
-                           0
-                         END
-    SQL
-
-    change_column_default :tag_names, :primary_flg, from: true, to: nil
-
-    add_column :tag_names, :primary_tag_id, :bigint,
-               as: 'CASE WHEN primary_flg THEN tag_id ELSE NULL END'
-    add_index :tag_names, [:primary_tag_id, :language_code], unique: true
-  end
-
-  def down
-    remove_index :tag_names, [:primary_tag_id, :language_code]
-    remove_column :tag_names, :primary_tag_id
-
-    remove_foreign_key :tag_names, column: :language_code
-    remove_foreign_key :tag_names, column: :script_code
-
-    remove_index :tag_names, [:language_code, :name]
-    add_index :tag_names, :name, unique: true
-
-    remove_column :tag_names, :primary_flg
-    remove_column :tag_names, :script_code
-    remove_column :tag_names, :language_code
-    remove_reference :tag_names, :tag, foreign_key: true
-  end
-end

backend/db/schema.rb

@@ -72,6 +72,7 @@ ActiveRecord::Schema[8.0].define(version: 2026_07_27_123600) do
     t.index ["correct_post_id"], name: "index_gekanator_games_on_correct_post_id"
     t.index ["guessed_post_id"], name: "index_gekanator_games_on_guessed_post_id"
     t.index ["user_id"], name: "index_gekanator_games_on_user_id"
+    t.check_constraint "`question_count` >= 0", name: "chk_gekanator_games_question_count_nonnegative"
   end
 
   create_table "gekanator_question_examples", charset: "utf8mb4", collation: "utf8mb4_0900_ai_ci", force: :cascade do |t|
@@ -274,9 +275,10 @@ ActiveRecord::Schema[8.0].define(version: 2026_07_27_123600) do
     t.datetime "created_at", null: false
     t.bigint "created_by_user_id"
     t.index ["created_at"], name: "index_nico_tag_versions_on_created_at"
-    t.index ["created_by_user_id", "created_at"], name: "index_nico_tag_versions_on_created_by_user_id_and_created_at"
-    t.index ["tag_id", "created_at"], name: "index_nico_tag_versions_on_tag_id_and_created_at"
+    t.index ["created_by_user_id", "created_at"], name: "index_nico_tag_versions_on_created_by_user_id_and_created_at", order: { created_at: :desc }
+    t.index ["tag_id", "created_at"], name: "index_nico_tag_versions_on_tag_id_and_created_at", order: { created_at: :desc }
     t.index ["tag_id", "version_no"], name: "index_nico_tag_versions_on_tag_id_and_version_no", unique: true
+    t.check_constraint "`version_no` > 0", name: "nico_tag_versions_version_no_positive"
   end
 
   create_table "post_implications", primary_key: ["post_id", "parent_post_id"], charset: "utf8mb4", collation: "utf8mb4_0900_ai_ci", force: :cascade do |t|
@@ -285,13 +287,14 @@ ActiveRecord::Schema[8.0].define(version: 2026_07_27_123600) do
     t.datetime "created_at", null: false
     t.datetime "updated_at", null: false
     t.index ["parent_post_id"], name: "index_post_implications_on_parent_post_id"
+    t.check_constraint "`post_id` <> `parent_post_id`", name: "chk_post_implications_no_self"
   end
 
   create_table "post_similarities", primary_key: ["post_id", "target_post_id"], charset: "utf8mb4", collation: "utf8mb4_0900_ai_ci", force: :cascade do |t|
     t.bigint "post_id", null: false
     t.bigint "target_post_id", null: false
     t.float "cos", null: false
-    t.index ["post_id", "cos"], name: "index_post_similarities_on_post_id_and_cos"
+    t.index ["post_id", "cos"], name: "index_post_similarities_on_post_id_and_cos", order: { cos: :desc }
     t.index ["target_post_id"], name: "index_post_similarities_on_target_post_id"
   end
 
@@ -358,6 +361,8 @@ ActiveRecord::Schema[8.0].define(version: 2026_07_27_123600) do
     t.index ["post_id"], name: "index_post_versions_on_post_id"
     t.index ["video_ms", "post_id"], name: "idx_post_versions_video_ms_post_id"
     t.check_constraint "(`video_ms` is null) or (`video_ms` > 0)", name: "chk_post_versions_video_ms_positive"
+    t.check_constraint "`event_type` in (_utf8mb4'create',_utf8mb4'update',_utf8mb4'discard',_utf8mb4'restore')", name: "post_versions_event_type_valid"
+    t.check_constraint "`version_no` > 0", name: "post_versions_version_no_positive"
     t.check_constraint "json_schema_valid(_utf8mb4'{\"type\":\"array\",\"items\":{\"type\":\"object\",\"properties\":{\"id\":{\"type\":\"integer\",\"minimum\":1},\"version_no\":{\"type\":\"integer\",\"minimum\":1},\"name\":{\"type\":\"string\",\"minLength\":1},\"category\":{\"type\":\"string\",\"enum\":[\"deerjikist\",\"meme\",\"character\",\"general\",\"material\",\"meta\",\"nico\"]},\"sections\":{\"type\":\"array\",\"items\":{\"type\":\"object\",\"properties\":{\"begin_ms\":{\"type\":\"integer\",\"minimum\":0},\"end_ms\":{\"type\":[\"integer\",\"null\"],\"minimum\":0}},\"required\":[\"begin_ms\",\"end_ms\"],\"additionalProperties\":false}}},\"required\":[\"id\",\"version_no\",\"name\",\"category\",\"sections\"],\"additionalProperties\":false}}',`tags_json`)", name: "chk_post_versions_tags_json_schema"
   end
 
@@ -376,6 +381,7 @@ ActiveRecord::Schema[8.0].define(version: 2026_07_27_123600) do
     t.index ["url"], name: "index_posts_on_url", unique: true
     t.index ["video_ms", "id"], name: "idx_posts_video_ms_id"
     t.check_constraint "(`video_ms` is null) or (`video_ms` > 0)", name: "chk_posts_video_ms_positive"
+    t.check_constraint "`version_no` > 0", name: "chk_posts_version_no_positive"
   end
 
   create_table "settings", charset: "utf8mb4", collation: "utf8mb4_0900_ai_ci", force: :cascade do |t|
@@ -383,18 +389,25 @@ ActiveRecord::Schema[8.0].define(version: 2026_07_27_123600) do
     t.datetime "created_at", null: false
     t.datetime "updated_at", null: false
     t.string "theme", default: "system", null: false
-    t.string "display_density", default: "comfortable", null: false
-    t.string "font_size", default: "normal", null: false
-    t.integer "post_list_limit", default: 50, null: false
-    t.string "post_list_order", default: "created_at_desc", null: false
-    t.string "viewed_post_display", default: "show", null: false
-    t.boolean "tag_autocomplete_nico", default: true, null: false
     t.string "auto_fetch_title", default: "manual", null: false
     t.string "auto_fetch_thumbnail", default: "manual", null: false
     t.string "wiki_editor_mode", default: "split", null: false
     t.index ["user_id"], name: "index_settings_on_user_id", unique: true
   end
 
+  create_table "wiki_assets", charset: "utf8mb4", collation: "utf8mb4_0900_ai_ci", force: :cascade do |t|
+    t.bigint "wiki_page_id", null: false
+    t.integer "no", null: false
+    t.string "alt_text"
+    t.binary "sha256", limit: 32, null: false
+    t.bigint "created_by_user_id", null: false
+    t.datetime "created_at", null: false
+    t.datetime "updated_at", null: false
+    t.index ["created_by_user_id"], name: "index_wiki_assets_on_created_by_user_id"
+    t.index ["wiki_page_id", "no"], name: "index_wiki_assets_on_wiki_page_id_and_no", unique: true
+    t.index ["wiki_page_id", "sha256"], name: "index_wiki_assets_on_wiki_page_id_and_sha256", unique: true
+  end
+
   create_table "tag_implications", charset: "utf8mb4", collation: "utf8mb4_0900_ai_ci", force: :cascade do |t|
     t.bigint "tag_id", null: false
     t.bigint "parent_tag_id", null: false
@@ -430,7 +443,7 @@ ActiveRecord::Schema[8.0].define(version: 2026_07_27_123600) do
     t.bigint "tag_id", null: false
     t.bigint "target_tag_id", null: false
     t.float "cos", null: false
-    t.index ["tag_id", "cos"], name: "index_tag_similarities_on_tag_id_and_cos"
+    t.index ["tag_id", "cos"], name: "index_tag_similarities_on_tag_id_and_cos", order: { cos: :desc }
     t.index ["target_tag_id"], name: "index_tag_similarities_on_target_tag_id"
   end
 
@@ -446,9 +459,10 @@ ActiveRecord::Schema[8.0].define(version: 2026_07_27_123600) do
     t.datetime "created_at", null: false
     t.bigint "created_by_user_id"
     t.index ["created_at"], name: "index_tag_versions_on_created_at"
-    t.index ["created_by_user_id", "created_at"], name: "index_tag_versions_on_created_by_user_id_and_created_at"
-    t.index ["tag_id", "created_at"], name: "index_tag_versions_on_tag_id_and_created_at"
+    t.index ["created_by_user_id", "created_at"], name: "index_tag_versions_on_created_by_user_id_and_created_at", order: { created_at: :desc }
+    t.index ["tag_id", "created_at"], name: "index_tag_versions_on_tag_id_and_created_at", order: { created_at: :desc }
     t.index ["tag_id", "version_no"], name: "index_tag_versions_on_tag_id_and_version_no", unique: true
+    t.check_constraint "`version_no` > 0", name: "tag_versions_version_no_positive"
   end
 
   create_table "tags", charset: "utf8mb4", collation: "utf8mb4_0900_ai_ci", force: :cascade do |t|
@@ -464,6 +478,7 @@ ActiveRecord::Schema[8.0].define(version: 2026_07_27_123600) do
     t.index ["discarded_at"], name: "index_tags_on_discarded_at"
     t.index ["tag_name_id"], name: "index_tags_on_tag_name_id", unique: true
     t.check_constraint "(`deprecated_at` is null) or (`category` <> _utf8mb4'nico')", name: "chk_tags_deprecated_at_not_nico"
+    t.check_constraint "`version_no` > 0", name: "chk_tags_version_no_positive"
   end
 
   create_table "theatre_comments", primary_key: ["theatre_id", "no"], charset: "utf8mb4", collation: "utf8mb4_0900_ai_ci", force: :cascade do |t|
@@ -617,11 +632,13 @@ ActiveRecord::Schema[8.0].define(version: 2026_07_27_123600) do
     t.datetime "created_at", null: false
     t.datetime "updated_at", null: false
     t.datetime "discarded_at"
+    t.integer "next_asset_no", default: 1, null: false
     t.integer "version_no", null: false
     t.index ["created_user_id"], name: "index_wiki_pages_on_created_user_id"
     t.index ["discarded_at"], name: "index_wiki_pages_on_discarded_at"
     t.index ["tag_name_id"], name: "index_wiki_pages_on_tag_name_id", unique: true
     t.index ["updated_user_id"], name: "index_wiki_pages_on_updated_user_id"
+    t.check_constraint "`version_no` > 0", name: "chk_wiki_pages_version_no_positive"
   end
 
   create_table "wiki_revision_lines", charset: "utf8mb4", collation: "utf8mb4_0900_ai_ci", force: :cascade do |t|
@@ -666,6 +683,8 @@ ActiveRecord::Schema[8.0].define(version: 2026_07_27_123600) do
     t.index ["created_by_user_id"], name: "index_wiki_versions_on_created_by_user_id"
     t.index ["wiki_page_id", "version_no"], name: "index_wiki_versions_on_wiki_page_id_and_version_no", unique: true
     t.index ["wiki_page_id"], name: "index_wiki_versions_on_wiki_page_id"
+    t.check_constraint "`event_type` in (_utf8mb4'create',_utf8mb4'update',_utf8mb4'discard',_utf8mb4'restore')", name: "wiki_versions_event_type_valid"
+    t.check_constraint "`version_no` > 0", name: "wiki_versions_version_no_positive"
   end
 
   add_foreign_key "active_storage_attachments", "active_storage_blobs", column: "blob_id"
@@ -747,6 +766,8 @@ ActiveRecord::Schema[8.0].define(version: 2026_07_27_123600) do
   add_foreign_key "user_post_views", "posts"
   add_foreign_key "user_post_views", "users"
   add_foreign_key "user_theme_slots", "users"
+  add_foreign_key "wiki_assets", "users", column: "created_by_user_id"
+  add_foreign_key "wiki_assets", "wiki_pages"
   add_foreign_key "wiki_pages", "tag_names"
   add_foreign_key "wiki_pages", "users", column: "created_user_id"
   add_foreign_key "wiki_pages", "users", column: "updated_user_id"