#442

backend/app/controllers/post_versions_controller.rb

@@ -14,8 +14,9 @@ class PostVersionsController < ApplicationController
 
     offset = (page - 1) * limit
 
-    q = HistoryAccess.visible(version_scope)
+    q = HistoryAccess.visible(PostVersion.all)
     q = q.where('post_versions.post_id = ?', post_id) if post_id
+    q = q.with_previous_version if tag_id || external_tag_id
     if external_tag_id || (tag_id && !(Tag.exists?(id: tag_id)))
       q = q.where('JSON_CONTAINS(post_versions.tags_json,' +
                   "JSON_OBJECT('external_tag_id', #{ external_tag_id || tag_id })) " +
@@ -28,9 +29,12 @@ class PostVersionsController < ApplicationController
 
     count = q.except(:select, :order, :limit, :offset).count
 
-    versions = q.order(Arel.sql('post_versions.created_at DESC, post_versions.id DESC'))
+    ids = q.order(Arel.sql('post_versions.created_at DESC, post_versions.id DESC'))
                 .limit(limit)
                 .offset(offset)
+                .pluck('post_versions.id')
+    versions = HistoryAccess.visible(version_scope.where(id: ids))
+        .order(Arel.sql('post_versions.created_at DESC, post_versions.id DESC'))
 
     render json: { versions: serialise_versions(versions, locale.language_code), count:, population_count: HistoryAccess.population_count(PostVersion) }
   end

backend/app/controllers/posts_controller.rb

@@ -39,18 +39,16 @@ class PostsController < ApplicationController
 
     pt_max_sql =
         HistoryAccess.visible(PostVersion.all)
-        .select('post_id, MAX(created_at) AS max_updated_at')
-        .group('post_id')
+        .where('post_versions.post_id = posts.id')
+        .select('MAX(post_versions.created_at)')
         .to_sql
 
     updated_at_all_sql =
         'GREATEST(posts.updated_at,' +
-        'COALESCE(pt_max.max_updated_at, posts.updated_at))'
+        "COALESCE((#{ pt_max_sql }), posts.updated_at))"
 
     q =
         filtered_posts(locale)
-        .joins("LEFT JOIN (#{ pt_max_sql }) pt_max ON pt_max.post_id = posts.id")
-        .reselect('posts.*', Arel.sql("#{ updated_at_all_sql } AS updated_at_all"))
         .preload(:external_tags, :uploaded_user, :parents, :children,
                  post_tags: [:sections, { tag: [:deerjikists, :materials,
                                                 :tag_names, :tag_descriptions] }])
@@ -88,12 +86,15 @@ class PostsController < ApplicationController
              .limit(limit)
              .offset(offset)
              .to_a
+    latest_version_times = HistoryAccess.visible(PostVersion.where(post_id: posts.map(&:id)))
+        .group(:post_id).maximum(:created_at)
 
     q = q.except(:select, :order)
 
     render json: { posts: posts.map { |post|
       PostRepr.base(post, language_code: locale.language_code)
-              .merge(updated_at: post.updated_at_all).tap do |json|
+              .merge(updated_at: [post.updated_at, latest_version_times[post.id]].compact.max)
+              .tap do |json|
         json['thumbnail'] =
             if post.thumbnail.attached?
               rails_storage_proxy_url(post.thumbnail, only_path: false)

backend/app/models/event.rb

@@ -1,9 +0,0 @@
-class Event < ApplicationRecord
-  has_many :post_versions
-  has_many :tag_versions
-  has_many :material_versions
-  has_many :tag_description_versions
-  has_many :tag_group_versions
-
-  belongs_to :created_by_user, class_name: 'User', optional: true
-end

backend/app/models/history_access.rb

@@ -109,11 +109,15 @@ class HistoryAccess < ActiveSupport::CurrentAttributes
       # conservatively; never expose a private linked name through an external tag.
       names = "JSON_MERGE_PRESERVE(JSON_ARRAY(private_tag.name), " +
           "COALESCE(JSON_EXTRACT(private_tag.names, '$**.name'), JSON_ARRAY()))"
-      ["NOT EXISTS (SELECT 1 FROM tag_versions private_tag " +
+      # DISTINCT prevents merging this independent name set into the correlated scan.
+      # Keep byte-distinct names even when the column collation considers them equal.
+      private_names = 'SELECT DISTINCT private_name.name, ' +
+          'CAST(private_name.name AS BINARY) AS name_bytes FROM tag_versions private_tag ' +
           "JOIN (#{ discarded_keys('tag_versions', 'tag_id') }) blocked " +
           "ON blocked.tag_id = private_tag.tag_id " +
           "JOIN JSON_TABLE(#{ names }, '$[*]' COLUMNS (name TEXT PATH '$')) private_name " +
-          "WHERE private_name.name <> '' AND " +
+          "WHERE private_name.name <> ''"
+      ["NOT EXISTS (SELECT 1 FROM (#{ private_names }) private_name WHERE " +
           "LOCATE(CONCAT(' ', private_name.name, ' '), " +
           "CONCAT(' ', COALESCE(#{ row }.linked_tags, ''), ' ')) > 0)"]
     when 'tag_versions'

backend/app/models/material_version.rb

@@ -11,5 +11,7 @@ class MaterialVersion < ApplicationRecord
   belongs_to :parent, class_name: 'Material', optional: true
   belongs_to :updated_by_user, class_name: 'User', optional: true
 
-  def export_paths_hash = export_paths_json || { }
+  def export_paths_hash
+    export_paths_json || {}
+  end
 end

backend/app/models/version_record.rb

@@ -19,8 +19,6 @@ module VersionRecord
 
     belongs_to :created_by_user, class_name: 'User', optional: true
 
-    belongs_to :event
-
     enum :event_type, event_type_map, prefix: true, validate: true
 
     validates :version_no, presence: true, numericality: { only_integer: true, greater_than: 0 }

backend/app/services/material_version_recorder.rb

@@ -1,23 +1,20 @@
 class MaterialVersionRecorder < VersionRecorder
   EVENT_TYPES = ['create', 'update', 'discard', 'restore'].freeze
 
-  def self.record! material:, event_type:, event:, created_by_user:, file_snapshot: nil
-    new(material:, event_type:, event:, created_by_user:, file_snapshot:).record!
+  def self.record! material:, event_type:, created_by_user:, file_snapshot: nil
+    new(material:, event_type:, created_by_user:, file_snapshot:).record!
   end
 
-  def initialize material:, event_type:, event:, created_by_user:, file_snapshot: nil
+  def initialize material:, event_type:, created_by_user:, file_snapshot: nil
     @file_snapshot = file_snapshot
 
-    super(record: material, event_type:, event:, created_by_user:)
+    super(record: material, event_type:, created_by_user:)
   end
 
   def self.ensure_snapshot! material, created_by_user:
     return if material.material_versions.exists?
 
-    event = Event.create!(event_type: 'materials.create',
-                          created_by_user:,
-                          created_at: material.created_at)
-    record!(material:, event_type: :create, event:,
+    record!(material:, event_type: :create,
             created_by_user: material.created_by_user || created_by_user)
   end
 

backend/app/services/post_version_recorder.rb

@@ -1,19 +1,16 @@
 class PostVersionRecorder < VersionRecorder
-  def self.record! post:, event_type:, event:, created_by_user:
-    new(post:, event_type:, event:, created_by_user:).record!
+  def self.record! post:, event_type:, created_by_user:
+    new(post:, event_type:, created_by_user:).record!
   end
 
-  def initialize post:, event_type:, event:, created_by_user:
-    super(record: post, event_type:, event:, created_by_user:)
+  def initialize post:, event_type:, created_by_user:
+    super(record: post, event_type:, created_by_user:)
   end
 
   def self.ensure_snapshot! post, created_by_user:
     return if post.post_versions.exists?
 
-    event = Event.create!(event_type: 'posts.create',
-                          created_by_user:,
-                          created_at: post.created_at)
-    record!(post:, event_type: :create, event:, created_by_user:)
+    record!(post:, event_type: :create, created_by_user:)
   end
 
   private

backend/app/services/tag_version_recorder.rb

@@ -1,13 +1,13 @@
 class TagVersionRecorder < VersionRecorder
-  def self.record! tag:, event_type:, event:, created_by_user:, **_options
+  def self.record! tag:, event_type:, created_by_user:, **_options
     Tag.transaction do
       SharedResourceIdAllocator.lock_space!(Tag, 'tags')
-      new(tag:, event_type:, event:, created_by_user:).record!
+      new(tag:, event_type:, created_by_user:).record!
     end
   end
 
-  def initialize tag:, event_type:, event:, created_by_user:
-    super(record: tag, event_type:, event:, created_by_user:)
+  def initialize tag:, event_type:, created_by_user:
+    super(record: tag, event_type:, created_by_user:)
   end
 
   private

backend/app/services/version_recorder.rb

@@ -1,10 +1,9 @@
 class VersionRecorder
   EVENT_TYPES = ['create', 'update', 'discard', 'restore'].freeze
 
-  def initialize record:, event_type:, event:, created_by_user:
+  def initialize record:, event_type:, created_by_user:
     @record = record
     @event_type = event_type.to_s
-    @event = event
     @created_by_user = created_by_user
 
     validate_event_type!
@@ -43,9 +42,8 @@ class VersionRecorder
   def base_attributes latest
     { version_no: (latest&.version_no || 0) + 1,
       event_type: @event_type,
-      event: @event,
-      created_by_user: @created_by_user,
-      created_at: Time.current }
+      created_at: Time.current,
+      created_by_user: @created_by_user }
   end
 
   def update_record_version_no! version_no

backend/db/migrate/20261102000000_create_events.rb

@@ -1,19 +0,0 @@
-class CreateEvents < ActiveRecord::Migration[8.0]
-  def change
-    create_table :events do |t|
-      t.string :event_type, null: false, index: true
-      t.text :reason
-      t.references :reverted_from_event, foreign_key: { to_table: :events }
-      t.json :metadata
-      t.binary :ip_address, limit: 16, index: true
-      t.references :created_by_user, index: true, foreign_key: false
-      t.datetime :created_at, null: false, index: true
-    end
-
-    add_reference :post_versions, :event, foreign_key: true, after: :original_created_before
-    add_reference :tag_versions, :event, foreign_key: true, after: :deprecated_at
-    add_reference :material_versions, :event, foreign_key: true
-    add_reference :tag_description_versions, :event, foreign_key: true, after: :source_version_no
-    add_reference :tag_group_versions, :event, foreign_key: true, after: :placements
-  end
-end

backend/db/migrate/20261102010000_backfill_events_from_existing_versions.rb

@@ -1,207 +0,0 @@
-class BackfillEventsFromExistingVersions < ActiveRecord::Migration[8.0]
-  class MigrationEvent < ActiveRecord::Base
-    self.table_name = 'events'
-  end
-
-  class MigrationPostVersion < ActiveRecord::Base
-    self.table_name = 'post_versions'
-  end
-
-  class MigrationTagVersion < ActiveRecord::Base
-    self.table_name = 'tag_versions'
-  end
-
-  class MigrationMaterialVersion < ActiveRecord::Base
-    self.table_name = 'material_versions'
-  end
-
-  class MigrationTagDescriptionVersion < ActiveRecord::Base
-    self.table_name = 'tag_description_versions'
-  end
-
-  class MigrationTagGroupVersion < ActiveRecord::Base
-    self.table_name = 'tag_group_versions'
-  end
-
-  class MigrationLocale < ActiveRecord::Base
-    self.table_name = 'locales'
-  end
-
-  def up
-    # create → posts.create
-    # update → posts.update
-    raise if MigrationPostVersion.where.not(event_type: ['create', 'update']).exists?
-
-    # create → materials.create
-    # update → materials.update
-    if MigrationMaterialVersion.where.not(event_type: ['create', 'update']).exists?
-      raise
-    end
-
-    # create → posts.create / posts.update / materials.create / materials.update / unknown
-    # update → tags.update / locales.create
-    # discard → unknown
-    if MigrationTagVersion.where.not(event_type: ['create', 'update', 'discard']).exists?
-      raise
-    end
-
-    # create → tag_descriptions.create
-    # update → tag_descriptions.update
-    if MigrationTagDescriptionVersion.where.not(event_type: ['create', 'update']).exists?
-      raise
-    end
-
-    # create → tag_groups.create
-    # update → tag_groups.update
-    if MigrationTagGroupVersion.where.not(event_type: ['create', 'update']).exists?
-      raise
-    end
-
-    # post_versions の Backfill
-    MigrationPostVersion.find_each do |pv|
-      ev = MigrationEvent.create!(event_type: "posts.#{ pv.event_type }",
-                                  reason: nil,
-                                  reverted_from_event_id: nil,
-                                  metadata: nil,
-                                  ip_address: nil,
-                                  created_by_user_id: pv.created_by_user_id,
-                                  created_at: pv.created_at)
-      pv.update_columns(event_id: ev.id)
-    end
-
-    # material_versions の Backfill
-    MigrationMaterialVersion.find_each do |m|
-      ev = MigrationEvent.create!(event_type: "materials.#{ m.event_type }",
-                                  reason: nil,
-                                  reverted_from_event_id: nil,
-                                  metadata: nil,
-                                  ip_address: nil,
-                                  created_by_user_id: m.created_by_user_id,
-                                  created_at: m.created_at)
-      m.update_columns(event_id: ev.id)
-    end
-
-    # ロカール追加に伴ふ該当語言のタグ名称追加異動のみ分離
-    ids_cause_of_locale_creation = []
-    MigrationLocale.where('created_at > ?', MigrationLocale.minimum(:created_at)).find_each do |l|
-      ev = MigrationEvent.create!(event_type: 'locales.create',
-                                  reason: nil,
-                                  reverted_from_event_id: nil,
-                                  metadata: nil,
-                                  ip_address: nil,
-                                  created_by_user_id: nil,
-                                  created_at: l.created_at)
-
-      MigrationTagVersion
-          .where('created_at > ?', l.created_at)
-          .where(event_type: 'update', event_id: nil)
-          .find_each do |t|
-        next unless t.names.key?(l.language_code)
-
-        prev = MigrationTagVersion.find_by(tag_id: t.tag_id, version_no: t.version_no - 1)
-        next if prev.nil? || prev.names.key?(l.language_code)
-
-        t.update_columns(event_id: ev.id)
-
-        ids_cause_of_locale_creation << t.id
-      end
-
-      ev.destroy! unless MigrationTagVersion.where(event_id: ev.id).exists?
-    end
-
-    # tag_versions の Backfill
-    MigrationTagVersion.where.not(id: ids_cause_of_locale_creation).find_each do |t|
-      ev =
-          case t.event_type
-          when 'create'
-            post =
-                MigrationPostVersion
-                .where('JSON_CONTAINS(tags_json, ?) <> 0', { tag_id: t.tag_id }.to_json)
-                .find_by(created_at: MigrationPostVersion
-                                     .where('JSON_CONTAINS(tags_json, ?) <> 0',
-                                            { tag_id: t.tag_id }.to_json)
-                                     .minimum(:created_at))
-            material =
-                MigrationMaterialVersion
-                .where(tag_id: t.tag_id)
-                .find_by(created_at: MigrationMaterialVersion
-                                     .where(tag_id: t.tag_id)
-                                     .minimum(:created_at))
-            if post
-              if material
-                if post.created_at < material.created_at
-                  MigrationEvent.find(post.event_id)
-                else
-                  MigrationEvent.find(material.event_id)
-                end
-              else
-                MigrationEvent.find(post.event_id)
-              end
-            else
-              if material
-                MigrationEvent.find(material.event_id)
-              else
-                MigrationEvent.create!(event_type: 'unknown',
-                                       reason: nil,
-                                       reverted_from_event_id: nil,
-                                       metadata: nil,
-                                       ip_address: nil,
-                                       created_by_user_id: t.created_by_user_id,
-                                       created_at: t.created_at)
-              end
-            end
-          when 'update'
-            MigrationEvent.create!(event_type: 'tags.update',
-                                   reason: nil,
-                                   reverted_from_event_id: nil,
-                                   metadata: nil,
-                                   ip_address: nil,
-                                   created_by_user_id: t.created_by_user_id,
-                                   created_at: t.created_at)
-          when 'discard'
-            MigrationEvent.create!(event_type: 'unknown',
-                                   reason: nil,
-                                   reverted_from_event_id: nil,
-                                   metadata: nil,
-                                   ip_address: nil,
-                                   created_by_user_id: t.created_by_user_id,
-                                   created_at: t.created_at)
-          end
-      t.update_columns(event_id: ev.id)
-    end
-
-    # tag_description_versions の Backfill
-    MigrationTagDescriptionVersion.find_each do |td|
-      ev = MigrationEvent.create!(event_type: "tag_descriptions.#{ td.event_type }",
-                                  reason: nil,
-                                  reverted_from_event_id: nil,
-                                  metadata: nil,
-                                  ip_address: nil,
-                                  created_by_user_id: td.created_by_user_id,
-                                  created_at: td.created_at)
-      td.update_columns(event_id: ev.id)
-    end
-
-    # tag_group_versions の Backfill
-    MigrationTagGroupVersion.find_each do |tg|
-      ev = MigrationEvent.create!(event_type: "tag_groups.#{ tg.event_type }",
-                                  reason: nil,
-                                  reverted_from_event_id: nil,
-                                  metadata: nil,
-                                  ip_address: nil,
-                                  created_by_user_id: tg.created_by_user_id,
-                                  created_at: tg.created_at)
-      tg.update_columns(event_id: ev.id)
-    end
-
-    change_column_null :post_versions, :event_id, false
-    change_column_null :tag_versions, :event_id, false
-    change_column_null :material_versions, :event_id, false
-    change_column_null :tag_description_versions, :event_id, false
-    change_column_null :tag_group_versions, :event_id, false
-  end
-
-  def down
-    raise ActiveRecord::IrreversibleMigration, '戻せません．'
-  end
-end

backend/db/schema.rb

@@ -10,7 +10,7 @@
 #
 # It's strongly recommended that you check this file into your version control system.
 
-ActiveRecord::Schema[8.0].define(version: 2026_11_02_010000) do
+ActiveRecord::Schema[8.0].define(version: 2026_10_15_010000) do
   create_table "active_storage_attachments", charset: "utf8mb4", collation: "utf8mb4_0900_ai_ci", force: :cascade do |t|
     t.string "name", null: false
     t.string "record_type", null: false
@@ -48,21 +48,6 @@ ActiveRecord::Schema[8.0].define(version: 2026_11_02_010000) do
     t.index ["tag_id"], name: "index_deerjikists_on_tag_id"
   end
 
-  create_table "events", charset: "utf8mb4", collation: "utf8mb4_0900_ai_ci", force: :cascade do |t|
-    t.string "event_type", null: false
-    t.text "reason"
-    t.bigint "reverted_from_event_id"
-    t.json "metadata"
-    t.binary "ip_address", limit: 16
-    t.bigint "created_by_user_id"
-    t.datetime "created_at", null: false
-    t.index ["created_at"], name: "index_events_on_created_at"
-    t.index ["created_by_user_id"], name: "index_events_on_created_by_user_id"
-    t.index ["event_type"], name: "index_events_on_event_type"
-    t.index ["ip_address"], name: "index_events_on_ip_address"
-    t.index ["reverted_from_event_id"], name: "index_events_on_reverted_from_event_id"
-  end
-
   create_table "external_tags", charset: "utf8mb4", collation: "utf8mb4_0900_ai_ci", force: :cascade do |t|
     t.string "platform", limit: 16, null: false
     t.string "name", null: false
@@ -265,10 +250,8 @@ ActiveRecord::Schema[8.0].define(version: 2026_11_02_010000) do
     t.string "source_path"
     t.string "source_file_id"
     t.string "normalized_source_key"
-    t.bigint "event_id", null: false
     t.index ["created_by_user_id"], name: "index_material_versions_on_created_by_user_id"
     t.index ["discarded_at"], name: "index_material_versions_on_discarded_at"
-    t.index ["event_id"], name: "index_material_versions_on_event_id"
     t.index ["file_blob_id"], name: "index_material_versions_on_file_blob_id"
     t.index ["material_id", "version_no"], name: "index_material_versions_on_material_id_and_version_no", unique: true
     t.index ["material_id"], name: "index_material_versions_on_material_id"
@@ -397,12 +380,10 @@ ActiveRecord::Schema[8.0].define(version: 2026_11_02_010000) do
     t.text "parent_post_ids", null: false
     t.datetime "original_created_from"
     t.datetime "original_created_before"
-    t.bigint "event_id", null: false
     t.datetime "created_at", null: false
     t.bigint "created_by_user_id"
     t.integer "video_ms"
     t.index ["created_by_user_id"], name: "index_post_versions_on_created_by_user_id"
-    t.index ["event_id"], name: "index_post_versions_on_event_id"
     t.index ["post_id", "version_no"], name: "index_post_versions_on_post_id_and_version_no", unique: true
     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"
@@ -467,11 +448,9 @@ ActiveRecord::Schema[8.0].define(version: 2026_11_02_010000) do
     t.text "body", null: false
     t.string "source_language_code", limit: 16
     t.integer "source_version_no"
-    t.bigint "event_id", null: false
     t.bigint "created_by_user_id"
     t.datetime "created_at", null: false
     t.index ["created_by_user_id"], name: "index_tag_description_versions_on_created_by_user_id"
-    t.index ["event_id"], name: "index_tag_description_versions_on_event_id"
     t.index ["tag_id", "language_code", "version_no"], name: "idx_on_tag_id_language_code_version_no_ced77e57e6", unique: true
     t.index ["tag_id", "source_language_code", "source_version_no"], name: "fk_rails_4f13094dbc"
     t.index ["tag_id"], name: "index_tag_description_versions_on_tag_id"
@@ -554,11 +533,9 @@ ActiveRecord::Schema[8.0].define(version: 2026_11_02_010000) do
     t.text "description"
     t.json "members", null: false
     t.json "placements", null: false
-    t.bigint "event_id", null: false
     t.bigint "created_by_user_id"
     t.datetime "created_at", null: false
     t.index ["created_by_user_id"], name: "index_tag_group_versions_on_created_by_user_id"
-    t.index ["event_id"], name: "index_tag_group_versions_on_event_id"
     t.index ["tag_group_id", "version_no"], name: "index_tag_group_versions_on_tag_group_id_and_version_no", unique: true
     t.index ["tag_group_id"], name: "index_tag_group_versions_on_tag_group_id"
     t.check_constraint "`version_no` > 0", name: "chk_tag_group_versions_version_no_positive"
@@ -634,13 +611,11 @@ ActiveRecord::Schema[8.0].define(version: 2026_11_02_010000) do
     t.text "aliases", null: false
     t.text "parent_tag_ids", null: false
     t.datetime "deprecated_at"
-    t.bigint "event_id", null: false
     t.datetime "created_at", null: false
     t.bigint "created_by_user_id"
     t.json "names", null: false
     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", order: { created_at: :desc }
-    t.index ["event_id"], name: "index_tag_versions_on_event_id"
     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"
@@ -796,7 +771,6 @@ ActiveRecord::Schema[8.0].define(version: 2026_11_02_010000) do
 
   add_foreign_key "active_storage_attachments", "active_storage_blobs", column: "blob_id"
   add_foreign_key "active_storage_variant_records", "active_storage_blobs", column: "blob_id"
-  add_foreign_key "events", "events", column: "reverted_from_event_id"
   add_foreign_key "gekanator_ai_runs", "gekanator_question_suggestions"
   add_foreign_key "gekanator_games", "posts", column: "correct_post_id"
   add_foreign_key "gekanator_games", "posts", column: "guessed_post_id"
@@ -818,7 +792,6 @@ ActiveRecord::Schema[8.0].define(version: 2026_11_02_010000) do
   add_foreign_key "material_sync_sources", "users", column: "created_by_user_id"
   add_foreign_key "material_sync_sources", "users", column: "updated_by_user_id"
   add_foreign_key "material_sync_suppressions", "users", column: "created_by_user_id"
-  add_foreign_key "material_versions", "events"
   add_foreign_key "material_versions", "materials"
   add_foreign_key "material_versions", "materials", column: "parent_id"
   add_foreign_key "material_versions", "users", column: "created_by_user_id"
@@ -840,12 +813,10 @@ ActiveRecord::Schema[8.0].define(version: 2026_11_02_010000) do
   add_foreign_key "post_tags", "posts"
   add_foreign_key "post_tags", "tags"
   add_foreign_key "post_tags", "users", column: "created_user_id"
-  add_foreign_key "post_versions", "events"
   add_foreign_key "post_versions", "posts"
   add_foreign_key "post_versions", "users", column: "created_by_user_id"
   add_foreign_key "posts", "users", column: "uploaded_user_id"
   add_foreign_key "settings", "users"
-  add_foreign_key "tag_description_versions", "events"
   add_foreign_key "tag_description_versions", "tag_description_versions", column: ["tag_id", "source_language_code", "source_version_no"], primary_key: ["tag_id", "language_code", "version_no"]
   add_foreign_key "tag_descriptions", "languages", column: "language_code", primary_key: "code"
   add_foreign_key "tag_descriptions", "tag_description_versions", column: ["tag_id", "source_language_code", "source_version_no"], primary_key: ["tag_id", "language_code", "version_no"]
@@ -864,7 +835,6 @@ ActiveRecord::Schema[8.0].define(version: 2026_11_02_010000) do
   add_foreign_key "tag_group_tags", "tag_groups"
   add_foreign_key "tag_group_tags", "tags"
   add_foreign_key "tag_group_tags", "users", column: "created_by_user_id"
-  add_foreign_key "tag_group_versions", "events"
   add_foreign_key "tag_groups", "users", column: "created_by_user_id"
   add_foreign_key "tag_groups", "users", column: "updated_by_user_id"
   add_foreign_key "tag_implications", "tags"
@@ -874,7 +844,6 @@ ActiveRecord::Schema[8.0].define(version: 2026_11_02_010000) do
   add_foreign_key "tag_names", "tags"
   add_foreign_key "tag_similarities", "tags"
   add_foreign_key "tag_similarities", "tags", column: "target_tag_id"
-  add_foreign_key "tag_versions", "events"
   add_foreign_key "tag_versions", "users", column: "created_by_user_id"
   add_foreign_key "theatre_comments", "theatres"
   add_foreign_key "theatre_comments", "users"

backend/spec/db/tag_group_constraints_spec.rb

@@ -102,7 +102,6 @@ RSpec.describe 'Tag group persistence constraints' do
     6.times { nodes = [{ 'tag_id' => tag.id, 'children' => nodes }] }
     reject_statement do
       insert_group_row('tag_group_versions', {
-          event_id: create_event!(event_type: 'unknown').id,
           tag_group_id: group_id, version_no: 2, event_type: 'update', name: '制約確認',
           members: [{ 'tag_id' => tag.id, 'version_no' => tag.version_no }].to_json,
           placements: nodes.to_json, created_at: Time.current })

backend/spec/db/tag_version_names_spec.rb

@@ -10,7 +10,6 @@ RSpec.describe 'TagVersion names database constraint' do
 
   def insert_snapshot!(snapshot)
     TagVersion.insert_all!([{ tag_id: tag.id, version_no: 1, event_type: 'create',
-                             event_id: create_event!(event_type: 'unknown').id,
                              name: 'snapshot_name', category: 'general',
                              aliases: '', parent_tag_ids: '', names: snapshot,
                              created_at: Time.current }])

backend/spec/models/history_access_spec.rb

@@ -9,9 +9,7 @@ RSpec.describe HistoryAccess do
     locale
     rows = ['ja', 'ain'].flat_map do |language|
       ['create', 'discard', 'restore'].each_with_index.map do |event, index|
-        TagDescriptionVersion.create!(
-            event_id: create_event!(event_type: 'unknown').id,
-            tag_id: tag.id, language_code: language,
+        TagDescriptionVersion.create!(tag_id: tag.id, language_code: language,
             version_no: index + 1, event_type: language == 'ain' ? 'update' : event,
             body: "#{ language } #{ index }", created_at: Time.utc(2024))
       end
@@ -30,9 +28,7 @@ RSpec.describe HistoryAccess do
     public_metadata = described_class.set(user: nil) { described_class.authority }
     admin = create(:user, :admin)
     admin_metadata = described_class.set(user: admin) { described_class.authority }
-    TagVersion.create!(
-        event_id: create_event!(event_type: 'unknown').id,
-        tag:, version_no: 1, event_type: 'discard', name: 'private',
+    TagVersion.create!(tag:, version_no: 1, event_type: 'discard', name: 'private',
         category: 'general',
         names: { ja: { name: 'private', script_code: 'Jpan',
                        auto_generated: false, aliases: [] } },
@@ -56,9 +52,7 @@ RSpec.describe HistoryAccess do
     blob = ActiveStorage::Blob.create_before_direct_upload!(filename: 'private.png',
         byte_size: 1, checksum: Base64.strict_encode64('checksum'), content_type: 'image/png')
     ActiveStorage::Attachment.create!(name: 'thumbnail', record: post, blob:)
-    PostVersion.create!(
-        event_id: create_event!(event_type: 'unknown').id,
-        post:, version_no: 1, event_type: 'discard', url: post.url,
+    PostVersion.create!(post:, version_no: 1, event_type: 'discard', url: post.url,
         title: 'private', tags: '', tags_json: [], parent_post_ids: '', created_at: Time.utc(2024))
     variant = ActiveStorage::VariantRecord.create!(blob:, variation_digest: 'spec-variation')
     derived = ActiveStorage::Blob.create_before_direct_upload!(filename: 'derived.png',
@@ -84,9 +78,7 @@ RSpec.describe 'Counts artifact policy and external references' do
 
   it 'does not expose a private linked tag name through an external history snapshot' do
     tag = create(:tag, primary_name: 'private-linked-name')
-    TagVersion.create!(
-        event_id: create_event!(event_type: 'unknown').id,
-        tag:, version_no: 1, event_type: 'discard', name: 'private-linked-name',
+    TagVersion.create!(tag:, version_no: 1, event_type: 'discard', name: 'private-linked-name',
         category: 'general', aliases: '', parent_tag_ids: '', created_at: Time.utc(2024),
         names: { ja: { name: 'private-linked-name', script_code: 'Jpan',
                        auto_generated: false, aliases: [] } })
@@ -95,9 +87,7 @@ RSpec.describe 'Counts artifact policy and external references' do
         name: 'nico:public-external', linked_tags: 'private-linked-name',
         created_at: Time.utc(2024))
     post = create(:post)
-    snapshot = PostVersion.create!(
-        event_id: create_event!(event_type: 'unknown').id,
-        post:, version_no: 1, event_type: 'create',
+    snapshot = PostVersion.create!(post:, version_no: 1, event_type: 'create',
         title: 'external reference', url: post.url, tags: '',
         tags_json: [{ external_tag_id: external.id }], parent_post_ids: '',
         created_at: Time.utc(2024, 2))
@@ -122,17 +112,13 @@ RSpec.describe 'Counts artifact policy and external references' do
     child = create(:tag, primary_name: 'referencing child')
     [[parent, 'discard', '', 'private parent'],
      [child, 'create', parent.id.to_s, 'referencing child']].each do |tag, event, parents, name|
-      TagVersion.create!(
-          event_id: create_event!(event_type: 'unknown').id,
-          tag:, version_no: 1, event_type: event, name:,
+      TagVersion.create!(tag:, version_no: 1, event_type: event, name:,
           category: 'general', aliases: '', parent_tag_ids: parents, created_at: Time.utc(2023),
           names: { ja: { name:, script_code: 'Jpan',
                          auto_generated: false, aliases: [] } })
     end
     post = create(:post)
-    row = PostVersion.create!(
-        event_id: create_event!(event_type: 'unknown').id,
-        post:, version_no: 1, event_type: 'create', title: 'snapshot',
+    row = PostVersion.create!(post:, version_no: 1, event_type: 'create', title: 'snapshot',
         url: post.url, tags: '', parent_post_ids: '',
         tags_json: [{ tag_id: child.id, version_no: 1, name: 'referencing child', sections: [] }],
         created_at: Time.utc(2024))

backend/spec/models/locale_activation_spec.rb

@@ -23,22 +23,9 @@ RSpec.describe 'Locale activation', type: :model do
         .and_raise('backfill failed')
   end
 
-  it 'groups all tag histories from locale creation into one event' do
-    previous_ids = TagVersion.pluck(:id)
-
-    expect { build_locale.save! }.to change { event_rows.length }.by(1)
-
-    event = event_rows.last
-    expect(event).to include('event_type' => 'locales.create', 'created_by_user_id' => nil)
-    versions = TagVersion.where.not(id: previous_ids)
-    expect(versions.pluck(:tag_id)).to include(first.id, second.id)
-    expect(versions.pluck(:event_id).uniq).to eq([event.fetch('id')])
-  end
-
   it 'rolls back a newly created locale and the preceding generated names' do
     locale = build_locale
     fail_second_generation!
-    events = event_rows
 
     expect { locale.save! }.to raise_error('backfill failed')
 
@@ -46,7 +33,6 @@ RSpec.describe 'Locale activation', type: :model do
     expect(generated_names).to be_empty
     expect(first.reload.name('ja')).to eq('activation_first')
     expect(second.reload.name('ja')).to eq('activation_second')
-    expect(event_rows).to eq(events)
   end
 
   it 'does not backfill while the locale is inactive' do
@@ -59,14 +45,7 @@ RSpec.describe 'Locale activation', type: :model do
     locale = build_locale(deprecated_at: Time.current)
     locale.save!
 
-    previous_ids = TagVersion.pluck(:id)
-    expect { locale.update!(deprecated_at: nil) }.to change { event_rows.length }.by(1)
-
-    event = event_rows.last
-    expect(event).to include('event_type' => 'locales.restore', 'created_by_user_id' => nil)
-    versions = TagVersion.where.not(id: previous_ids)
-    expect(versions.pluck(:tag_id)).to include(first.id, second.id)
-    expect(versions.pluck(:event_id).uniq).to eq([event.fetch('id')])
+    locale.update!(deprecated_at: nil)
 
     expect(generated_names.pluck(:tag_id)).to contain_exactly(first.id, second.id)
     expect(generated_names).to all(have_attributes(
@@ -78,13 +57,11 @@ RSpec.describe 'Locale activation', type: :model do
     locale.save!
     previous_deprecated_at = locale.reload.deprecated_at
     fail_second_generation!
-    events = event_rows
 
     expect { locale.update!(deprecated_at: nil) }.to raise_error('backfill failed')
 
     expect(locale.reload.deprecated_at).to eq(previous_deprecated_at)
     expect(generated_names).to be_empty
-    expect(event_rows).to eq(events)
   end
 
   it 'preserves a human primary through deactivation and repeated activation' do

backend/spec/models/post_version_spec.rb

@@ -12,20 +12,20 @@ RSpec.describe PostVersion, type: :model do
 
   let!(:post_version) do
     PostVersion.create!(
-        event_id: create_event!(event_type: 'unknown').id,
-        post: post_record,
-        version_no: 1,
-        event_type: 'create',
-        title: post_record.title,
-        url: post_record.url,
-        thumbnail_base: post_record.thumbnail_base,
-        tags: post_record.snapshot_tag_names.join(' '),
-        tags_json: post_record.snapshot_tags_json,
-        parent_post_ids: post_record.snapshot_parent_post_ids.join(' '),
-        original_created_from: post_record.original_created_from,
-        original_created_before: post_record.original_created_before,
-        created_at: Time.current,
-        created_by_user: nil)
+      post: post_record,
+      version_no: 1,
+      event_type: 'create',
+      title: post_record.title,
+      url: post_record.url,
+      thumbnail_base: post_record.thumbnail_base,
+      tags: post_record.snapshot_tag_names.join(' '),
+      tags_json: post_record.snapshot_tags_json,
+      parent_post_ids: post_record.snapshot_parent_post_ids.join(' '),
+      original_created_from: post_record.original_created_from,
+      original_created_before: post_record.original_created_before,
+      created_at: Time.current,
+      created_by_user: nil
+    )
   end
 
   it 'is read only after create' do

backend/spec/models/tag_name_sanitisation_rule_spec.rb

@@ -34,31 +34,6 @@ RSpec.describe TagNameSanitisationRule, type: :model do
       described_class.create!(priority: 10, source_pattern: 'foo_', replacement: 'foo')
     end
 
-    it 'groups renames, merges and affected post histories into one event' do
-      target = create(:tag, primary_name: 'foobar')
-      source = create(:tag, primary_name: 'temporary_source')
-      renamed = create(:tag, primary_name: 'temporary_rename')
-      source.tag_name('ja').update_columns(name: 'foo_bar')
-      renamed.tag_name('ja').update_columns(name: 'foo_baz')
-      post = create(:post)
-      PostTag.create!(post:, tag: source)
-      previous_tag_ids = TagVersion.pluck(:id)
-      previous_post_ids = PostVersion.pluck(:id)
-
-      expect { described_class.apply! }.to change { event_rows.length }.by(1)
-
-      event = event_rows.last
-      expect(event).to include(
-          'event_type' => 'tag_name_sanitisation_rules.apply', 'created_by_user_id' => nil)
-      tag_versions = TagVersion.where.not(id: previous_tag_ids)
-      expect(tag_versions.pluck(:tag_id).uniq).to contain_exactly(target.id, source.id, renamed.id)
-      expect(tag_versions.pluck(:event_type)).to include('discard', 'update')
-      expect(tag_versions.pluck(:event_id).uniq).to eq([event.fetch('id')])
-      post_versions = PostVersion.where.not(id: previous_post_ids)
-      expect(post_versions.pluck(:post_id).uniq).to eq([post.id])
-      expect(post_versions.pluck(:event_id).uniq).to eq([event.fetch('id')])
-    end
-
     [:primary, :alias].each do |source_kind|
       it "keeps the primary identity when a #{ source_kind } collides within its Tag" do
         tag = create(:tag, primary_name: source_kind == :primary ? 'temporary' : 'foobar')
@@ -108,7 +83,6 @@ RSpec.describe TagNameSanitisationRule, type: :model do
       PostTag.create!(post:, tag: source)
       models = [Tag, TagName, TagVersion, TagDescription, TagDescriptionVersion, PostTag]
       snapshots = models.map { |model| model.order(*Array(model.primary_key)).map(&:attributes) }
-      events = event_rows
 
       expect { described_class.apply! }.to raise_error(ActiveRecord::RecordInvalid)
 
@@ -116,7 +90,6 @@ RSpec.describe TagNameSanitisationRule, type: :model do
         model.order(*Array(model.primary_key)).map(&:attributes)
       end
       expect(after_state).to eq(snapshots)
-      expect(event_rows).to eq(events)
       expect(post.reload.tags).to contain_exactly(source)
       expect(target.reload.name('ja')).to eq('foobar')
     end

backend/spec/models/tag_spec.rb

@@ -665,20 +665,20 @@ RSpec.describe Tag, type: :model do
 
     def create_post_version_for!(post, version_no: 1, event_type: 'create', created_by_user: nil)
       PostVersion.create!(
-          event_id: create_event!(event_type: 'unknown').id,
-          post: post,
-          version_no: version_no,
-          event_type: event_type,
-          title: post.title,
-          url: post.url,
-          thumbnail_base: post.thumbnail_base,
-          tags: snapshot_tags(post),
-          tags_json: post.snapshot_tags_json,
-          parent_post_ids: post.snapshot_parent_post_ids.join(' '),
-          original_created_from: post.original_created_from,
-          original_created_before: post.original_created_before,
-          created_at: Time.current,
-          created_by_user: created_by_user)
+        post: post,
+        version_no: version_no,
+        event_type: event_type,
+        title: post.title,
+        url: post.url,
+        thumbnail_base: post.thumbnail_base,
+        tags: snapshot_tags(post),
+        tags_json: post.snapshot_tags_json,
+        parent_post_ids: post.snapshot_parent_post_ids.join(' '),
+        original_created_from: post.original_created_from,
+        original_created_before: post.original_created_before,
+        created_at: Time.current,
+        created_by_user: created_by_user
+      )
     end
 
     context 'when post versions are enabled' do

backend/spec/models/version_record_spec.rb

@@ -6,18 +6,17 @@ RSpec.describe VersionRecord, type: :model do
 
   it 'makes TagVersion read only after create' do
     version = TagVersion.create!(
-        event_id: create_event!(event_type: 'unknown').id,
-        tag: tag,
-        version_no: 1,
-        event_type: 'create',
-        name: primary_tag_name_for(tag, 'ja').name,
-        category: tag.category,
-        aliases: '',
-        names: { ja: { name: primary_tag_name_for(tag, 'ja').name,
-                       script_code: 'Jpan', auto_generated: false, aliases: [] } },
-        parent_tag_ids: '',
-        created_at: Time.current,
-        created_by_user: nil)
+      tag: tag,
+      version_no: 1,
+      event_type: 'create',
+      name: primary_tag_name_for(tag, 'ja').name,
+      category: tag.category,
+      aliases: '',
+      names: { ja: { name: primary_tag_name_for(tag, 'ja').name,
+                     script_code: 'Jpan', auto_generated: false, aliases: [] } },
+      parent_tag_ids: '',
+      created_at: Time.current,
+      created_by_user: nil)
 
     expect {
       version.update!(name: 'changed')
@@ -26,18 +25,17 @@ RSpec.describe VersionRecord, type: :model do
 
   it 'prevents TagVersion destroy' do
     version = TagVersion.create!(
-        event_id: create_event!(event_type: 'unknown').id,
-        tag: tag,
-        version_no: 1,
-        event_type: 'create',
-        name: primary_tag_name_for(tag, 'ja').name,
-        category: tag.category,
-        aliases: '',
-        names: { ja: { name: primary_tag_name_for(tag, 'ja').name,
-                       script_code: 'Jpan', auto_generated: false, aliases: [] } },
-        parent_tag_ids: '',
-        created_at: Time.current,
-        created_by_user: nil)
+      tag: tag,
+      version_no: 1,
+      event_type: 'create',
+      name: primary_tag_name_for(tag, 'ja').name,
+      category: tag.category,
+      aliases: '',
+      names: { ja: { name: primary_tag_name_for(tag, 'ja').name,
+                     script_code: 'Jpan', auto_generated: false, aliases: [] } },
+      parent_tag_ids: '',
+      created_at: Time.current,
+      created_by_user: nil)
 
     expect {
       version.destroy!

backend/spec/rails_helper.rb

@@ -44,7 +44,6 @@ RSpec.configure do |config|
   end
 
   config.include TestRecords
-  config.include EventRecords
   config.include RakeTaskHelper
 
   # FactoryBot の create / create_list を使へるやぅにする

backend/spec/requests/counts_download_spec.rb

@@ -84,9 +84,7 @@ RSpec.describe 'Counts native GET acknowledgement', type: :request do
     expect(response).to have_http_status(:not_found)
     job, file, attempt = ready_job('json')
     record = create(:post)
-    PostVersion.create!(
-        event_id: create_event!(event_type: 'unknown').id,
-        post: record, version_no: 1, event_type: 'discard', title: 'private',
+    PostVersion.create!(post: record, version_no: 1, event_type: 'discard', title: 'private',
         url: record.url, tags: '', tags_json: [], parent_post_ids: '', created_at: Time.utc(2024))
     get "/counts/export/files/#{ file }", params: { job:, attempt: }
     expect(response).to have_http_status(:not_found)

backend/spec/requests/counts_history_boundaries_spec.rb

@@ -8,9 +8,7 @@ RSpec.describe 'History boundaries shared with Counts', type: :request do
 
   before do
     ['create', 'discard'].each_with_index do |event, index|
-      TagDescriptionVersion.create!(
-          event_id: create_event!(event_type: 'unknown').id,
-          tag_id: tag.id, language_code: 'ja',
+      TagDescriptionVersion.create!(tag_id: tag.id, language_code: 'ja',
           version_no: index + 1, event_type: event, body: 'private body',
           created_at: Time.utc(2024))
     end

backend/spec/requests/counts_spec.rb

@@ -10,16 +10,12 @@ RSpec.describe 'Legacy Counts API', type: :request do
                  category: 'general', sections: [] }
     [1, 2, 3].each do |number|
       time = Time.utc(2024, number == 3 ? 2 : 1, number, 0, 0)
-      PostVersion.create!(
-          event_id: create_event!(event_type: 'unknown').id,
-          post:, version_no: number,
+      PostVersion.create!(post:, version_no: number,
           event_type: number == 1 ? 'create' : 'update',
           tags: '', url: post.url, title: "Snapshot #{ number }", parent_post_ids: '',
           tags_json: number == 1 ? [snapshot] : [],
           created_by_user: number == 3 ? nil : actor, created_at: time)
-      TagVersion.create!(
-          event_id: create_event!(event_type: 'unknown').id,
-          tag:, version_no: number,
+      TagVersion.create!(tag:, version_no: number,
           event_type: number == 1 ? 'create' : 'update',
           name: 'counts tag', category: 'general', aliases: '', parent_tag_ids: '',
           names: { ja: { name: 'counts tag', script_code: 'Jpan',

backend/spec/requests/counts_table_spec.rb

@@ -14,9 +14,7 @@ RSpec.describe 'Counts table API', type: :request do
   end
 
   before do
-    TagVersion.create!(
-        event_id: create_event!(event_type: 'unknown').id,
-        tag:, version_no: 1, event_type: 'create', name: 'alpha',
+    TagVersion.create!(tag:, version_no: 1, event_type: 'create', name: 'alpha',
         category: 'general', aliases: '', parent_tag_ids: '',
         names: { ja: { name: 'alpha', script_code: 'Jpan', auto_generated: false,  aliases: [] } },
         created_at: Time.utc(2023))
@@ -26,9 +24,7 @@ RSpec.describe 'Counts table API', type: :request do
         { tag_id: tag.id, version_no: 1, name: 'alpha', category: 'general', sections: [] },
         { external_tag_id: external.id }]
     [1, 2, 3].each do |number|
-      PostVersion.create!(
-          event_id: create_event!(event_type: 'unknown').id,
-          post: record, version_no: number,
+      PostVersion.create!(post: record, version_no: number,
           event_type: number == 1 ? 'create' : 'update', url: record.url,
           title: "snapshot #{ number }", tags: '', parent_post_ids: '',
           tags_json: snapshots.first(number == 1 ? 2 : (number == 2 ? 1 : 0)),
@@ -138,9 +134,7 @@ RSpec.describe 'Counts table API', type: :request do
   end
 
   it 'checks the current latest flag beyond the execution timestamp' do
-    PostVersion.create!(
-        event_id: create_event!(event_type: 'unknown').id,
-        post: record, version_no: 4, event_type: 'update',
+    PostVersion.create!(post: record, version_no: 4, event_type: 'update',
         url: record.url, title: 'after execution', tags: '', tags_json: [],
         parent_post_ids: '', created_at: Time.utc(2025, 2, 1))
     result = query
@@ -194,16 +188,12 @@ RSpec.describe 'Counts table API', type: :request do
       tag.tag_names.find_by!(language_code: 'ja', primary_flg: true)
           .update!(name: 'renamed-alpha')
       create(:tag_name, :alias, tag:, name: 'alpha-alias')
-      TagVersion.create!(
-          event_id: create_event!(event_type: 'unknown').id,
-          tag:, version_no: 2, event_type: 'update', name: 'renamed-alpha',
+      TagVersion.create!(tag:, version_no: 2, event_type: 'update', name: 'renamed-alpha',
           category: 'general', aliases: 'alpha-alias', parent_tag_ids: '',
           names: { ja: { name: 'renamed-alpha', script_code: 'Jpan', auto_generated: false,
                          aliases: [{ name: 'alpha-alias', script_code: 'Jpan' }] } },
           created_at: Time.utc(2024, 2, 1))
-      PostVersion.create!(
-          event_id: create_event!(event_type: 'unknown').id,
-          post: record, version_no: 4, event_type: 'update',
+      PostVersion.create!(post: record, version_no: 4, event_type: 'update',
           url: record.url, title: 'after rename', tags: '', parent_post_ids: '',
           tags_json: [{ tag_id: tag.id, version_no: 2, name: 'renamed-alpha',
                         category: 'general', sections: [] }],
@@ -267,9 +257,7 @@ RSpec.describe 'Counts table API', type: :request do
 
   it 'reports column overflow separately from malformed input' do
     101.times do |index|
-      PostVersion.create!(
-          event_id: create_event!(event_type: 'unknown').id,
-          post: record, version_no: index + 4,
+      PostVersion.create!(post: record, version_no: index + 4,
           event_type: 'update', url: record.url, title: "column #{ index }",
           tags: '', tags_json: [], parent_post_ids: '', created_at: Time.utc(2024, 3))
     end
@@ -313,9 +301,7 @@ RSpec.describe 'Counts table API', type: :request do
         sign_in_as(create(:user, role)) if role
         # Equal timestamps deliberately require version ordering, not a date comparison.
         ['discard', 'restore', 'discard', 'restore'].each_with_index do |event, index|
-          PostVersion.create!(
-              event_id: create_event!(event_type: 'unknown').id,
-              post: record, version_no: index + 4, event_type: event,
+          PostVersion.create!(post: record, version_no: index + 4, event_type: event,
               url: record.url, title: event == 'restore' ? 'restored' : 'private snapshot',
               tags: '', tags_json: [], parent_post_ids: '', created_at: Time.utc(2024, 3))
         end
@@ -343,9 +329,7 @@ RSpec.describe 'Counts table API', type: :request do
       end
 
       it 'does not resolve private condition names even when the result set is empty' do
-        TagVersion.create!(
-            event_id: create_event!(event_type: 'unknown').id,
-            tag:, version_no: 2, event_type: 'discard', name: 'secret tag',
+        TagVersion.create!(tag:, version_no: 2, event_type: 'discard', name: 'secret tag',
             category: 'general', aliases: '', parent_tag_ids: '',
             names: { ja: { name: 'secret tag', script_code: 'Jpan', auto_generated: false, aliases: [] } },
             created_at: Time.utc(2024, 2))
@@ -361,9 +345,7 @@ RSpec.describe 'Counts table API', type: :request do
     end
   end
   it 'includes private history in the public timeline without an exclusion count' do
-    PostVersion.create!(
-        event_id: create_event!(event_type: 'unknown').id,
-        post: record, version_no: 4, event_type: 'discard', url: record.url,
+    PostVersion.create!(post: record, version_no: 4, event_type: 'discard', url: record.url,
         title: 'hidden title', tags: '', tags_json: [], parent_post_ids: '',
         created_at: Time.utc(2024, 3))
     result = query(mode: 'summary', rows: 'created_at:month', cols: 'event_type')

backend/spec/requests/materials_spec.rb

@@ -314,7 +314,6 @@ RSpec.describe 'Materials API', type: :request do
           .and change(Tag, :count).by(1)
           .and change(TagName, :count).by(1)
           .and change(MaterialVersion, :count).by(1)
-          .and change { event_rows.length }.by(1)
 
         expect(response).to have_http_status(:created)
 
@@ -326,12 +325,6 @@ RSpec.describe 'Materials API', type: :request do
         expect(material.file.attached?).to be(true)
         expect(material.version_no).to eq(1)
         expect(material.material_versions.first.event_type).to eq('create')
-        event = event_rows.last
-        expect(event).to include(
-            'event_type' => 'materials.create',
-            'created_by_user_id' => member_user.id)
-        expect(material.material_versions.first.event_id).to eq(event.fetch('id'))
-        expect(material.tag.tag_versions.pluck(:event_id)).to eq([event.fetch('id')])
         expect(material.material_export_items.first.export_path).to eq('伊地知ニジカ/created.png')
         expect(material.material_versions.first.export_paths_json).to eq(
           'legacy_drive' => '伊地知ニジカ/created.png'
@@ -516,7 +509,6 @@ RSpec.describe 'Materials API', type: :request do
             export_paths: { legacy_drive: '伊地知ニジカ/updated.jpg' }
           }
         end.to change(MaterialVersion, :count).by(2)
-            .and change { event_rows.length }.by(1)
 
         expect(response).to have_http_status(:ok)
 
@@ -525,12 +517,6 @@ RSpec.describe 'Materials API', type: :request do
         expect(material.tag.category).to eq('material')
         expect(material.url).to eq('https://example.com/updated-source')
         expect(material.updated_by_user).to eq(member_user)
-        event = event_rows.last
-        expect(event).to include(
-            'event_type' => 'materials.update',
-            'created_by_user_id' => member_user.id)
-        expect(material.material_versions.pluck(:event_id).uniq).to eq([event.fetch('id')])
-        expect(material.tag.tag_versions.pluck(:event_id)).to eq([event.fetch('id')])
         expect(material.file.attached?).to be(true)
         expect(material.file.blob.id).not_to eq(old_blob_id)
         expect(ActiveStorage::Blob.where(id: old_blob_id).exists?).to be(true)
@@ -646,7 +632,6 @@ RSpec.describe 'Materials API', type: :request do
         MaterialVersionRecorder.record!(material:, event_type: :create,
                                         created_by_user: member_user)
         TagVersioning.ensure_snapshot!(tag, created_by_user: member_user)
-        events = event_rows
 
         expect do
           put "/materials/#{ material.id }", params: {
@@ -658,7 +643,6 @@ RSpec.describe 'Materials API', type: :request do
 
         expect(response).to have_http_status(:ok)
         expect(material.reload.version_no).to eq(1)
-        expect(event_rows).to eq(events)
       end
 
       it 'records update version when only export_path changes' do
@@ -823,12 +807,6 @@ RSpec.describe 'Materials API', type: :request do
 
     it 'creates source suppression as member' do
       sign_in_as(member_user)
-      materials = ['a', 'b'].map do |name|
-        Material.create!(
-            source_kind: 'google_drive_file', source_file_id: "blocked-#{ name }",
-            source_path: "伊地知ニジカ/危険素材/#{ name }.png",
-            url: "https://example.com/blocked-#{ name }", created_by_user: member_user)
-      end
 
       expect do
         post '/materials/suppressions', params: {
@@ -837,7 +815,6 @@ RSpec.describe 'Materials API', type: :request do
           reason: 'copyright_high_risk'
         }
       end.to change(MaterialSyncSuppression, :count).by(1)
-          .and change { event_rows.length }.by(1)
 
       expect(response).to have_http_status(:created)
       expect(json).to include(
@@ -845,14 +822,6 @@ RSpec.describe 'Materials API', type: :request do
         'drive_path' => '伊地知ニジカ/危険素材',
         'normalized_source_key' => 'google_drive_path_prefix:伊地知ニジカ/危険素材'
       )
-      event = event_rows.last
-      expect(event).to include(
-          'event_type' => 'materials.block', 'created_by_user_id' => member_user.id)
-      expect(materials.map { _1.reload.discarded? }).to eq([true, true])
-      versions = MaterialVersion.where(material_id: materials.map(&:id))
-      expect(versions.where(event_type: 'discard').pluck(:material_id))
-          .to match_array(materials.map(&:id))
-      expect(versions.pluck(:event_id).uniq).to eq([event.fetch('id')])
     end
   end
 
@@ -891,19 +860,11 @@ RSpec.describe 'Materials API', type: :request do
       end
 
       it 'discards the material and returns 204' do
-        expect { delete "/materials/#{ material.id }" }
-            .to change { event_rows.length }.by(1)
+        delete "/materials/#{ material.id }"
 
         expect(response).to have_http_status(:no_content)
         expect(Material.find_by(id: material.id)).to be_nil
         expect(Material.with_discarded.find(material.id)).to be_discarded
-        event = event_rows.last
-        expect(event).to include(
-            'event_type' => 'materials.destroy',
-            'created_by_user_id' => member_user.id)
-        versions = MaterialVersion.where(material_id: material.id)
-        expect(versions.order(:version_no).last.event_type).to eq('discard')
-        expect(versions.pluck(:event_id).uniq).to eq([event.fetch('id')])
       end
     end
   end

backend/spec/requests/nico_tags_spec.rb

@@ -177,7 +177,6 @@ RSpec.describe 'NicoTags', type: :request do
         }
       }.to change(TagVersion, :count).by(2)
        .and change(NicoTagVersion, :count).by(1)
-       .and change { event_rows.length }.by(1)
 
       expect(response).to have_http_status(:ok)
 
@@ -187,10 +186,6 @@ RSpec.describe 'NicoTags', type: :request do
       linked_versions = TagVersion.where(tag: [linked_a, linked_b]).order(:tag_id)
       expect(linked_versions.map(&:event_type)).to eq(['create', 'create'])
       expect(linked_versions.map(&:created_by_user_id)).to all(eq(admin.id))
-      event = event_rows.last
-      expect(event).to include(
-          'event_type' => 'tags.update', 'created_by_user_id' => admin.id)
-      expect(linked_versions.pluck(:event_id).uniq).to eq([event.fetch('id')])
 
       versions = nico_tag.reload.nico_tag_versions.order(:version_no)
       expect(versions.map(&:event_type)).to eq(['create', 'update'])

backend/spec/requests/post_history_privacy_spec.rb

@@ -0,0 +1,94 @@
+require 'rails_helper'
+
+RSpec.describe 'Post history privacy', type: :request do
+  let(:origin) { Time.utc(2020, 1, 1) }
+  let!(:post_record) do
+    create(:post, title: 'current', created_at: origin, updated_at: origin)
+  end
+  let!(:other_post) do
+    create(:post, created_at: origin, updated_at: origin + 3.days + 1.hour)
+  end
+  let!(:tag) { create(:tag, primary_name: 'private-history-tag') }
+  let!(:external) { create(:external_tag, name: 'external-history-tag') }
+
+  before do
+    ['create', 'discard'].each_with_index do |event, index|
+      TagVersion.create!(tag:, version_no: index + 1, event_type: event,
+          name: 'private-history-tag', category: 'general', aliases: '', parent_tag_ids: '',
+          names: { ja: { name: 'private-history-tag', script_code: 'Jpan',
+                         auto_generated: false, aliases: [] } },
+          created_at: origin + index.hours)
+    end
+    NicoTagVersion.create!(external_tag: external, version_no: 1, event_type: 'create',
+        name: 'nico:external-history-tag', linked_tags: 'private-history-tag',
+        created_at: origin)
+    ['create', 'discard', 'restore', 'update'].each_with_index do |event, index|
+      snapshots =
+          if index < 2
+            [{ tag_id: tag.id, version_no: 1, name: 'private-history-tag', sections: [] }]
+          elsif index == 3
+            [{ external_tag_id: external.id }]
+          else
+            []
+          end
+      PostVersion.create!(post: post_record, version_no: index + 1, event_type: event,
+          title: "version #{ index + 1 }", url: post_record.url, tags: '',
+          tags_json: snapshots, parent_post_ids: '', created_at: origin + (index + 1).days)
+    end
+  end
+
+  ['anonymous', 'member', 'admin'].each do |role|
+    context "as #{ role }" do
+      before do
+        sign_in_as(create(:user, role.to_sym)) unless role == 'anonymous'
+      end
+
+      it 'uses only authorised history timestamps for display' do
+        get '/posts'
+        expect(response).to have_http_status(:ok)
+        row = response.parsed_body.fetch('posts').find { _1.fetch('id') == post_record.id }
+        expected = origin + (role == 'admin' ? 4 : 3).days
+        expect(Time.zone.parse(row.fetch('updated_at'))).to eq(expected)
+      end
+
+      it 'uses the same visibility for date bounds and count' do
+        get '/posts', params: { updated_from: (origin + 4.days).iso8601,
+                                updated_to: (origin + 4.days).iso8601 }
+        expect(response).to have_http_status(:ok)
+        ids = response.parsed_body.fetch('posts').pluck('id')
+        expect(ids).to eq(role == 'admin' ? [post_record.id] : [])
+        expect(response.parsed_body.fetch('count')).to eq(ids.length)
+      end
+
+      it 'sorts using authorised timestamps in both directions' do
+        ['asc', 'desc'].each do |direction|
+          get '/posts', params: { order: "updated_at:#{ direction }" }
+          expect(response).to have_http_status(:ok)
+          expected = role == 'admin' ? [other_post.id, post_record.id] :
+              [post_record.id, other_post.id]
+          expected.reverse! if direction == 'desc'
+          expect(response.parsed_body.fetch('posts').pluck('id')).to eq(expected)
+        end
+      end
+
+      it 'counts only visible versions and masks a private previous version' do
+        get '/posts/versions', params: { post: post_record.id }
+        expect(response).to have_http_status(:ok)
+        body = response.parsed_body
+        expected = role == 'admin' ? [4, 3, 2, 1] : [3]
+        expect(body.fetch('count')).to eq(expected.length)
+        expect(body.fetch('versions').pluck('version_no')).to eq(expected)
+        restored = body.fetch('versions').find { _1.fetch('version_no') == 3 }
+        expect(restored.fetch('title').fetch('prev')).to eq(role == 'admin' ? 'version 2' : nil)
+      end
+
+      it 'uses only an authorised previous version for tag filtering' do
+        get '/posts/versions', params: { post: post_record.id, tag: tag.id }
+        expect(response).to have_http_status(:ok)
+        expected = role == 'admin' ? [3, 2, 1] : []
+        expect(response.parsed_body.fetch('versions').pluck('version_no')).to eq(expected)
+        expect(response.parsed_body.fetch('count')).to eq(expected.length)
+      end
+    end
+  end
+end

backend/spec/requests/posts_spec.rb

@@ -50,8 +50,6 @@ RSpec.describe 'Posts API', type: :request do
             post:,
             version_no: 1,
             event_type: 'create',
-            event_id: create_event!(
-                event_type: 'posts.create', created_by_user: post.uploaded_user).id,
             title: post.title,
             url: post.url,
             thumbnail_base: post.thumbnail_base,
@@ -1029,7 +1027,7 @@ RSpec.describe 'Posts API', type: :request do
 
     it 'dry-runs without persisting posts or new tags' do
       sign_in_as(member)
-      counts = [Post.count, Tag.count, TagName.count, event_rows.length]
+      counts = [Post.count, Tag.count, TagName.count]
 
       post '/posts?dry=1', params: post_write_params(
           title: 'dry-run post',
@@ -1045,7 +1043,7 @@ RSpec.describe 'Posts API', type: :request do
           [{ 'name' => 'new_dry_run_tag',
              'category' => 'character',
              'section_literals' => [] }])
-      expect([Post.count, Tag.count, TagName.count, event_rows.length]).to eq(counts)
+      expect([Post.count, Tag.count, TagName.count]).to eq(counts)
     end
 
     it 'dry-runs an existing URL without validating its upload' do
@@ -2220,20 +2218,20 @@ RSpec.describe 'Posts API', type: :request do
 
     def create_post_version! post, version_no:, event_type:, created_by_user:, created_at:
       PostVersion.create!(
-          event_id: create_event!(event_type: 'unknown').id,
-          post:,
-          version_no:,
-          event_type:,
-          title: post.title,
-          url: post.url,
-          thumbnail_base: post.thumbnail_base,
-          tags: snapshot_tags(post),
-          tags_json: post.snapshot_tags_json,
-          parent_post_ids: post.snapshot_parent_post_ids.join(' '),
-          original_created_from: post.original_created_from,
-          original_created_before: post.original_created_before,
-          created_at:,
-          created_by_user:)
+        post:,
+        version_no:,
+        event_type:,
+        title: post.title,
+        url: post.url,
+        thumbnail_base: post.thumbnail_base,
+        tags: snapshot_tags(post),
+        tags_json: post.snapshot_tags_json,
+        parent_post_ids: post.snapshot_parent_post_ids.join(' '),
+        original_created_from: post.original_created_from,
+        original_created_before: post.original_created_before,
+        created_at:,
+        created_by_user:
+      )
     end
 
     let!(:v1) do
@@ -2561,7 +2559,6 @@ RSpec.describe 'Posts API', type: :request do
             tags: 'spec_tag',
             thumbnail: dummy_upload)
       end.to change(PostVersion, :count).by(1)
-          .and change { event_rows.length }.by(1)
 
       expect(response).to have_http_status(:created)
 
@@ -2573,13 +2570,6 @@ RSpec.describe 'Posts API', type: :request do
       expect(version.url).to eq('https://example.com/versioned-post')
       expect(version.created_by_user_id).to eq(member.id)
       expect(version.tags).to eq(snapshot_tags(created_post))
-      event = event_rows.last
-      expect(event).to include(
-          'event_type' => 'posts.create', 'created_by_user_id' => member.id)
-      expect(version.event_id).to eq(event.fetch('id'))
-      tag_versions = TagVersion.where(tag_id: created_post.tags.select(:id))
-      expect(tag_versions).not_to be_empty
-      expect(tag_versions.pluck(:event_id).uniq).to eq([event.fetch('id')])
     end
 
     it 'creates next version on PUT /posts/:id when snapshot changes' do
@@ -2595,7 +2585,6 @@ RSpec.describe 'Posts API', type: :request do
             title: 'updated title',
             tags: 'spec_tag_2')
       end.to change(PostVersion, :count).by(1)
-          .and change { event_rows.length }.by(1)
 
       expect(response).to have_http_status(:ok)
 
@@ -2605,12 +2594,6 @@ RSpec.describe 'Posts API', type: :request do
       expect(version.title).to eq('updated title')
       expect(version.created_by_user_id).to eq(member.id)
       expect(version.tags).to eq(snapshot_tags(post_record.reload))
-      event = event_rows.last
-      expect(event).to include(
-          'event_type' => 'posts.update', 'created_by_user_id' => member.id)
-      expect(version.event_id).to eq(event.fetch('id'))
-      tag_version = TagVersion.find_by!(tag_id: tag_name2.reload.tag_id, version_no: 1)
-      expect(tag_version.event_id).to eq(event.fetch('id'))
     end
 
     it 'does not create a new version on PUT /posts/:id when snapshot is unchanged' do
@@ -2619,7 +2602,6 @@ RSpec.describe 'Posts API', type: :request do
       PostTag.create!(post: post_record, tag: Tag.no_deerjikist)
       base_version = create_post_version_for!(post_record.reload)
 
-      events = event_rows
       expect {
         put "/posts/#{post_record.id}", params: post_write_params(
             base_version_no: base_version.version_no,
@@ -2633,12 +2615,10 @@ RSpec.describe 'Posts API', type: :request do
       expect(version.version_no).to eq(1)
       expect(version.event_type).to eq('create')
       expect(version.tags).to eq(snapshot_tags(post_record))
-      expect(event_rows).to eq(events)
     end
 
     it 'does not create a version when POST /posts is invalid' do
       sign_in_as(member)
-      events = event_rows
 
       expect do
         post '/posts', params: post_write_params(
@@ -2649,13 +2629,11 @@ RSpec.describe 'Posts API', type: :request do
       end.not_to change(PostVersion, :count)
 
       expect(response).to have_http_status(:unprocessable_entity)
-      expect(event_rows).to eq(events)
     end
 
     it 'does not create a version when PUT /posts/:id is invalid' do
       sign_in_as(member)
       base_version = create_post_version_for!(post_record)
-      events = event_rows
 
       expect do
         put "/posts/#{post_record.id}", params: post_write_params(
@@ -2667,7 +2645,6 @@ RSpec.describe 'Posts API', type: :request do
       end.not_to change(PostVersion, :count)
 
       expect(response).to have_http_status(:unprocessable_entity)
-      expect(event_rows).to eq(events)
     end
 
     it 'rejects second-bearing original created timestamps on POST /posts' do

backend/spec/requests/sitemap_entries_spec.rb

@@ -119,9 +119,7 @@ RSpec.describe 'Sitemap entries API', type: :request do
       # Legacy empty bodies can exist even though the write service rejects them.
       empty = TagDescription.create!(tag: empty_tag, language_code: 'ain',
                                      body: '', version_no: 1)
-      TagDescriptionVersion.create!(
-          event_id: create_event!(event_type: 'unknown').id,
-          tag_id: empty_tag.id, language_code: 'ain',
+      TagDescriptionVersion.create!(tag_id: empty_tag.id, language_code: 'ain',
                                     body: '', version_no: 1, event_type: 'create',
                                     created_by_user_id: user.id, created_at: Time.current)
 

backend/spec/requests/tag_children_spec.rb

@@ -53,13 +53,8 @@ RSpec.describe "TagChildren", type: :request do
         expect { do_request }
           .to change { parent.reload.children.ids.include?(child.id) }
           .from(false).to(true)
-          .and change { event_rows.length }.by(1)
 
         expect(response).to have_http_status(:no_content)
-        event = event_rows.last
-        expect(event).to include(
-            'event_type' => 'tags.update', 'created_by_user_id' => admin.id)
-        expect(child.tag_versions.pluck(:event_id).uniq).to eq([event.fetch('id')])
       end
 
       it 'returns 422 and does not create relation when the new link makes a cycle' do
@@ -137,7 +132,6 @@ RSpec.describe "TagChildren", type: :request do
         expect {
           do_request
         }.to change(TagVersion, :count).by(2)
-            .and change { event_rows.length }.by(1)
 
         expect(response).to have_http_status(:no_content)
 
@@ -146,10 +140,6 @@ RSpec.describe "TagChildren", type: :request do
         expect(versions.first.parent_tag_ids.split).to include(parent.id.to_s)
         expect(versions.second.parent_tag_ids).to eq('')
         expect(versions.second.created_by_user_id).to eq(admin.id)
-        event = event_rows.last
-        expect(event).to include(
-            'event_type' => 'tags.update', 'created_by_user_id' => admin.id)
-        expect(versions.pluck(:event_id).uniq).to eq([event.fetch('id')])
       end
     end
 

backend/spec/requests/tag_description_wiki_spec.rb

@@ -8,7 +8,6 @@ RSpec.describe 'Tag description Wiki compatibility', type: :request do
   let!(:versions) do
     ['A', 'A', 'new-version'].each_with_index.map do |body, index|
       TagDescriptionVersion.create!(
-          event_id: create_event!(event_type: 'unknown').id,
           tag_id: tag.id, language_code: 'ja', version_no: index + 1,
           event_type: index.zero? ? 'create' : 'update', body:,
           created_by_user_id: user.id, created_at: Time.current)
@@ -74,7 +73,6 @@ RSpec.describe 'Tag description Wiki compatibility', type: :request do
     let!(:other_tag) { create(:tag, primary_name: 'other_description_contract') }
     let!(:other_version) do
       TagDescriptionVersion.create!(
-          event_id: create_event!(event_type: 'unknown').id,
           tag_id: other_tag.id, language_code: 'ja', version_no: 1,
           event_type: 'create', body: 'other tag history',
           created_by_user_id: user.id, created_at: Time.current)

backend/spec/requests/tag_descriptions_spec.rb

@@ -13,7 +13,7 @@ RSpec.describe 'Tag description native API', type: :request do
   def stored_state
     [TagDescription, TagDescriptionVersion, TagName, TagVersion].map do |model|
       model.order(:id).map(&:attributes)
-    end + [event_rows]
+    end
   end
 
   def fail_save model
@@ -91,8 +91,6 @@ RSpec.describe 'Tag description native API', type: :request do
     let!(:version) do
       TagDescriptionVersion.create!(
           tag_id: tag.id, language_code: 'ja', body: 'native version', version_no: 1,
-          event_id: create_event!(
-              event_type: 'tag_descriptions.create', created_by_user: author).id,
           event_type: 'create', created_by_user_id: author.id, created_at: Time.current)
     end
     let(:name_endpoint) { "/tags/name/#{ tag_name.name }/description" }
@@ -187,7 +185,6 @@ RSpec.describe 'Tag description native API', type: :request do
         expect { native_write(body: 'created natively') }
             .to change(TagDescription, :count).by(1)
             .and change(TagDescriptionVersion, :count).by(1)
-            .and change { event_rows.length }.by(1)
         expect(response).to have_http_status(:created)
         description = TagDescription.find_by!(tag_id: tag.id, language_code: 'ja')
         expect_current(description)
@@ -195,10 +192,6 @@ RSpec.describe 'Tag description native API', type: :request do
         expect(version).to have_attributes(
             body: 'created natively', version_no: 1, event_type: 'create',
             created_by_user_id: editor.id)
-        event = event_rows.last
-        expect(event).to include(
-            'event_type' => 'tag_descriptions.create', 'created_by_user_id' => editor.id)
-        expect(version.event_id).to eq(event.fetch('id'))
         get "/wiki/#{ description.id }"
         expect(response).to have_http_status(:ok)
         expect(json).to include('body' => description.body, 'revision_id' => version.id)
@@ -230,7 +223,6 @@ RSpec.describe 'Tag description native API', type: :request do
         expect(description.version_no).to eq(1)
         expect { native_write(body: 'after') }
             .to change(TagDescriptionVersion, :count).by(1)
-            .and change { event_rows.length }.by(1)
         expect(response).to have_http_status(:ok)
         expect(description.reload).to have_attributes(
             body: 'after', version_no: 2,
@@ -242,10 +234,6 @@ RSpec.describe 'Tag description native API', type: :request do
         expect(version).to have_attributes(
             tag_id: tag.id, language_code: 'ja', version_no: 2, event_type: 'update',
             body: 'after', created_by_user_id: editor.id)
-        event = event_rows.last
-        expect(event).to include(
-            'event_type' => 'tag_descriptions.update', 'created_by_user_id' => editor.id)
-        expect(version.event_id).to eq(event.fetch('id'))
         expect(revision.body).to eq(version.body)
         expect(description_versions(page).order(:version_no).last.body).to eq(version.body)
         get "/wiki/#{ description.id }"

backend/spec/requests/tag_groups_spec.rb

@@ -121,14 +121,10 @@ RSpec.describe 'Tag group native API', type: :request do
     [:create, :update].each do |operation|
       it "#{ operation }s structured data and keeps unplaced membership" do
         previous = group_version(group_id, 1)
-        expect { native_write(operation) }.to change { event_rows.length }.by(1)
+        native_write(operation)
         expect(response).to have_http_status(operation == :create ? :created : :ok)
         id = operation == :create ? json.fetch('id') : group_id
         number = operation == :create ? 1 : 2
-        event = event_rows.last
-        event_type = operation == :create ? 'tag_groups.create' : 'tag_groups.update'
-        expect(event).to include('event_type' => event_type, 'created_by_user_id' => user.id)
-        expect(group_version(id, number).fetch('event_id')).to eq(event.fetch('id'))
         expect_group_snapshot(
             id, number:, members: snapshot_members, placements:, description: '全体の説明')
         expect(group_version(group_id, 1)).to eq(previous)

backend/spec/requests/tag_versions_spec.rb

@@ -30,7 +30,6 @@ RSpec.describe 'TagVersions API', type: :request do
   )
     version =
         TagVersion.create!(
-            event_id: create_event!(event_type: 'unknown').id,
             tag: tag,
             version_no: version_no,
             event_type: event_type,

backend/spec/requests/tags_spec.rb

@@ -705,7 +705,6 @@ RSpec.describe 'Tags API', type: :request do
         expect {
           patch "/tags/#{tag.id}", params: { name: 'new_tag_name', category: 'meme' }
         }.to change(TagVersion, :count).by(2)
-            .and change { event_rows.length }.by(1)
 
         expect(response).to have_http_status(:ok)
 
@@ -720,10 +719,6 @@ RSpec.describe 'Tags API', type: :request do
         expect(version_primary_name(versions.second, 'ja')).to eq('new_tag_name')
         expect(versions.second.category).to eq('meme')
         expect(versions.second.created_by_user_id).to eq(member_user.id)
-        event = event_rows.last
-        expect(event).to include(
-            'event_type' => 'tags.update', 'created_by_user_id' => member_user.id)
-        expect(versions.pluck(:event_id).uniq).to eq([event.fetch('id')])
       end
 
       it 'updates deprecated state and records it in tag versions' do
@@ -1280,7 +1275,6 @@ RSpec.describe 'Tags API', type: :request do
             deprecated: '0',
           }
         }.to change(TagVersion, :count).by(2)
-            .and change { event_rows.length }.by(1)
 
         expect(response).to have_http_status(:ok)
 
@@ -1296,10 +1290,6 @@ RSpec.describe 'Tags API', type: :request do
         expect(versions.second.category).to eq('meta')
         expect(version_alias_names(versions.second, 'ja')).to include('spec_tag')
         expect(versions.second.created_by_user_id).to eq(member_user.id)
-        event = event_rows.last
-        expect(event).to include(
-            'event_type' => 'tags.update', 'created_by_user_id' => member_user.id)
-        expect(versions.pluck(:event_id).uniq).to eq([event.fetch('id')])
       end
 
       it '同じ tag の旧 alias へ戻しても rename できる' do

backend/spec/services/counts_export_spec.rb

@@ -143,9 +143,7 @@ RSpec.describe 'Counts export contracts' do
     expect(CountsExportDownload.find(token, 'owner')).not_to be_nil
     expect(CountsExportDownload.find(token, 'other')).to be_nil
     post = create(:post)
-    PostVersion.create!(
-        event_id: create_event!(event_type: 'unknown').id,
-        post:, version_no: 1, event_type: 'discard', url: post.url,
+    PostVersion.create!(post:, version_no: 1, event_type: 'discard', url: post.url,
         title: 'private', tags: '', tags_json: [], parent_post_ids: '', created_at: Time.utc(2024))
     expect(CountsExportDownload.find(token, 'owner')).to be_nil
   end

backend/spec/services/counts_pivot_security_spec.rb

@@ -13,9 +13,7 @@ RSpec.describe 'Counts masked pivot contracts' do
   let!(:tags) do
     ['A', 'B', 'C'].map do |name|
       tag = create(:tag, primary_name: name)
-      TagVersion.create!(
-          event_id: create_event!(event_type: 'unknown').id,
-          tag:, version_no: 1, event_type: 'create', name:,
+      TagVersion.create!(tag:, version_no: 1, event_type: 'create', name:,
           category: 'general', aliases: '', parent_tag_ids: '',
           names: { ja: { name:, script_code: 'Jpan', auto_generated: false, aliases: [] } },
           created_at: Time.utc(2023))
@@ -27,16 +25,12 @@ RSpec.describe 'Counts masked pivot contracts' do
     [[0, 1], [0], [1, 2]].each_with_index do |indexes, index|
       post = create(:post)
       snapshot = indexes.map { { tag_id: tags[_1].id, version_no: 1, sections: [] } }
-      PostVersion.create!(
-          event_id: create_event!(event_type: 'unknown').id,
-          post:, version_no: 1, event_type: 'create',
+      PostVersion.create!(post:, version_no: 1, event_type: 'create',
           title: "hidden-title-#{ index }", url: post.url, tags: '', tags_json: snapshot,
           parent_post_ids: '', created_by_user: member, created_at: Time.utc(2024, 1))
       next if index == 2
 
-      PostVersion.create!(
-          event_id: create_event!(event_type: 'unknown').id,
-          post:, version_no: 2, event_type: 'discard',
+      PostVersion.create!(post:, version_no: 2, event_type: 'discard',
           title: "private-discard-#{ index }", url: post.url, tags: '', tags_json: [],
           parent_post_ids: '', created_by_user: member, created_at: Time.utc(2024, 2))
     end
@@ -104,16 +98,12 @@ RSpec.describe 'Counts masked pivot contracts' do
 
   it 'uses changed-record membership for totals and hides changes to private predecessors' do
     post = PostVersion.order(:id).last.post
-    PostVersion.create!(
-        event_id: create_event!(event_type: 'unknown').id,
-        post:, version_no: 2, event_type: 'update', title: 'changed-public-title',
+    PostVersion.create!(post:, version_no: 2, event_type: 'update', title: 'changed-public-title',
         url: post.url, tags: '',
         tags_json: [{ tag_id: tags.last.id, version_no: 1, sections: [] }],
         parent_post_ids: '', created_at: Time.utc(2024, 3))
     restored = PostVersion.order(:id).first.post
-    PostVersion.create!(
-        event_id: create_event!(event_type: 'unknown').id,
-        post: restored, version_no: 3, event_type: 'restore',
+    PostVersion.create!(post: restored, version_no: 3, event_type: 'restore',
         title: 'restored-public-title', url: restored.url, tags: '',
         tags_json: [{ tag_id: tags.first.id, version_no: 1, sections: [] }], parent_post_ids: '',
         created_at: Time.utc(2024, 4))
@@ -144,9 +134,7 @@ RSpec.describe 'Counts masked pivot contracts' do
 
   it 'keeps NULL as a public data value rather than treating it as a rollup' do
     post = create(:post)
-    PostVersion.create!(
-        event_id: create_event!(event_type: 'unknown').id,
-        post:, version_no: 1, event_type: 'create', title: 'public bot',
+    PostVersion.create!(post:, version_no: 1, event_type: 'create', title: 'public bot',
         url: post.url, tags: '', tags_json: [], parent_post_ids: '', created_at: Time.utc(2024, 5))
     page = result(nil, 'rows' => 'user', 'cols' => 'event_type')
     expect(page[:cells].select { _1[:values].first.nil? }.sum { _1[:count] }).to eq(1)
@@ -157,9 +145,7 @@ RSpec.describe 'Counts masked pivot contracts' do
   it 'sorts public numeric values numerically alongside a masked group' do
     post = PostVersion.order(:id).last.post
     [2, 10].each do |number|
-      PostVersion.create!(
-          event_id: create_event!(event_type: 'unknown').id,
-          post:, version_no: number, event_type: 'update',
+      PostVersion.create!(post:, version_no: number, event_type: 'update',
           title: 'public numeric sort', url: post.url, tags: '', tags_json: [],
           parent_post_ids: '', created_at: Time.utc(2024, 5))
     end

backend/spec/services/material_sync_importer_spec.rb

@@ -56,7 +56,6 @@ RSpec.describe MaterialSyncImporter do
                                profile: 'legacy_drive',
                                export_path: '素材/a.png',
                                created_by_user: user)
-    events = event_rows
 
     result =
         described_class.import!(
@@ -74,7 +73,6 @@ RSpec.describe MaterialSyncImporter do
     expect(result.action).to eq(:unchanged)
     expect(material.reload.tag).to eq(tag)
     expect(material.url).to eq('https://example.com/human')
-    expect(event_rows).to eq(events)
   end
 
   it 'suppresses a Google Drive candidate by relative path prefix' do

backend/spec/services/material_sync_runner_spec.rb

@@ -14,47 +14,6 @@ RSpec.describe MaterialSyncRunner do
   let(:drive_client) { instance_double(GoogleDrive::ApiClient) }
 
   describe '#sync!' do
-    it 'groups created and updated materials across sync sources into one event' do
-      existing = Material.create!(
-          source_kind: 'google_drive_file', source_file_id: 'existing-file',
-          source_path: 'old.png', url: 'https://example.com/existing',
-          created_by_user: user, updated_by_user: user)
-      source
-      MaterialSyncSource.create!(
-          name: 'Second Drive source', source_kind: 'google_drive_path',
-          source_file_id: 'folder-456', profile: 'legacy_drive',
-          created_by_user: user, updated_by_user: user)
-      allow(GoogleDrive::ApiClient).to receive(:new).and_return(drive_client)
-      allow(drive_client).to receive(:each_material_file_under_folder) do |folder_id, &block|
-        id = folder_id == 'folder-123' ? 'existing-file' : 'new-file'
-        block.call(id:, name: "#{ id }.png", mime_type: 'image/png',
-                   relative_path: "素材/#{ id }.png", sha256_checksum: nil,
-                   web_view_link: "https://drive.google.com/file/d/#{ id }/view")
-      end
-      allow(drive_client).to receive(:download_to_tempfile) do |id, **|
-        Tempfile.new(['sync-event', '.png']).tap do |file|
-          file.binmode
-          file.write(id)
-          file.rewind
-        end
-      end
-      allow(MaterialThumbnailGenerator).to receive(:generate!)
-      previous_ids = MaterialVersion.pluck(:id)
-
-      result = nil
-      expect { result = described_class.sync_enabled! }
-          .to change { event_rows.length }.by(1)
-
-      expect(result).to have_attributes(imported: 1, updated: 1, failed: 0)
-      event = event_rows.last
-      expect(event.fetch('event_type')).to eq('materials.sync')
-      created = Material.find_by!(source_file_id: 'new-file')
-      versions = MaterialVersion.where.not(id: previous_ids)
-      expect(versions.pluck(:material_id).uniq).to contain_exactly(existing.id, created.id)
-      expect(versions.pluck(:event_type)).to include('create', 'update')
-      expect(versions.pluck(:event_id).uniq).to eq([event.fetch('id')])
-    end
-
     it 'imports google drive path candidates as they are yielded' do
       first_entry = { id: 'file-1',
                       name: 'a.png',

backend/spec/services/post_bulk_creator_spec.rb

@@ -88,86 +88,3 @@ RSpec.describe PostBulkCreator do
     expect(creator).to have_received(:create!).with(locale).once
   end
 end
-
-RSpec.describe 'PostBulkCreator event grouping', type: :model do
-  self.use_transactional_tests = false
-
-  before do
-    expect(Rails.env.test?).to be(true)
-    expect(ApplicationRecord.connection.open_transactions).to eq(0)
-    @prefix = "bulk_event_#{ SecureRandom.hex(8) }"
-    @actor = create(:user, :member)
-    allow(PostCreatePreflight).to receive(:new) do |attributes:, **|
-      specs = [{ name: attributes.fetch(:title), category: :general }]
-      instance_double(PostCreatePreflight, run: attributes.merge(
-          existing_post_id: nil, snapshot_tag_specs: specs, post_tag_specs: specs,
-          normalised_parent_post_ids: [], tag_sections: { }, video_ms: nil))
-    end
-  end
-
-  after do
-    if @actor
-      posts = Post.where(uploaded_user: @actor)
-      PostTagSection.where(post_id: posts.select(:id)).delete_all
-      PostTag.where(post_id: posts.select(:id)).delete_all
-      PostVersion.where(post_id: posts.select(:id)).delete_all
-      posts.delete_all
-      tag_ids = TagName.where(name: ["#{ @prefix }_1", "#{ @prefix }_2"]).pluck(:tag_id)
-      TagVersion.where(tag_id: tag_ids).delete_all
-      TagName.where(tag_id: tag_ids).delete_all
-      Tag.where(id: tag_ids).delete_all
-      EventRecords::EventRow.where(created_by_user_id: @actor.id).delete_all
-      @actor.delete
-    end
-  end
-
-  it 'shares one creation event between real workers and their tag histories' do
-    posts = [1, 2].map do |number|
-      { title: "#{ @prefix }_#{ number }",
-        url: "https://example.com/#{ @prefix }/#{ number }" }
-    end
-
-    result = nil
-    expect {
-      result = PostBulkCreator.new(actor: @actor, posts:, thumbnails: { })
-          .run(Locale.nipponese)
-    }.to change { event_rows.length }.by(1)
-
-    expect(result.fetch(:results).map { _1.fetch(:status) }).to eq(['created', 'created'])
-    event = event_rows.last
-    expect(event).to include(
-        'event_type' => 'posts.create', 'created_by_user_id' => @actor.id)
-    versions = PostVersion.where(created_by_user_id: @actor.id)
-    expect(versions.count).to eq(2)
-    expect(versions.pluck(:event_id).uniq).to eq([event.fetch('id')])
-    tag_versions = TagVersion.where(created_by_user_id: @actor.id)
-    expect(tag_versions.count).to eq(2)
-    expect(tag_versions.pluck(:event_id).uniq).to eq([event.fetch('id')])
-  end
-
-  it 'does not leave an event when every row fails validation' do
-    preflight = instance_double(PostCreatePreflight)
-    allow(PostCreatePreflight).to receive(:new).and_return(preflight)
-    allow(preflight).to receive(:run).and_raise(
-        PostCreatePreflight::ValidationFailed.new(fields: { url: ['invalid'] }))
-    events = event_rows
-
-    result = PostBulkCreator.new(
-        actor: @actor, posts: [{ title: 'invalid' }], thumbnails: { }).run(Locale.nipponese)
-
-    expect(result.fetch(:results).map { _1.fetch(:status) }).to eq(['failed'])
-    expect(event_rows).to eq(events)
-  end
-
-  it 'does not leave an event when every row is skipped' do
-    preflight = instance_double(PostCreatePreflight, run: { existing_post_id: 123 })
-    allow(PostCreatePreflight).to receive(:new).and_return(preflight)
-    events = event_rows
-
-    result = PostBulkCreator.new(
-        actor: @actor, posts: [{ title: 'existing' }], thumbnails: { }).run(Locale.nipponese)
-
-    expect(result.fetch(:results).map { _1.fetch(:status) }).to eq(['skipped'])
-    expect(event_rows).to eq(events)
-  end
-end

backend/spec/services/shared_resource_id_allocator_mysql_spec.rb

@@ -16,7 +16,6 @@ RSpec.describe 'Shared resource IDs across MySQL connections', type: :model do
     @tag = create(:tag, primary_name: "#{ @prefix }_owner")
     @group = TagGroup.create!(name: "#{ @prefix }_owner", version_no: 1)
     @tag_ids = Queue.new
-    @event_ids = Queue.new
     @threads = []
     @release = Queue.new
   end
@@ -43,9 +42,6 @@ RSpec.describe 'Shared resource IDs across MySQL connections', type: :model do
       ids << @tag.id if @tag
       TagName.where(tag_id: ids).delete_all
       Tag.where(id: ids).delete_all
-      event_ids = []
-      event_ids << @event_ids.pop until @event_ids.empty? if @event_ids
-      EventRecords::EventRow.where(id: event_ids).delete_all
     end
   end
 
@@ -76,17 +72,11 @@ RSpec.describe 'Shared resource IDs across MySQL connections', type: :model do
     when :description
       TagDescription.create!(tag: @tag, language_code: 'ja', body: '', version_no: 1)
     when :description_version
-      event = create_event!(event_type: 'unknown')
-      @event_ids << event.id
       TagDescriptionVersion.create!(
-          event_id: event.id,
           tag_id: @tag.id, language_code: 'ja', body: 'body', version_no: 1,
           event_type: 'create', created_at: Time.current)
     when :group_version
-      event = create_event!(event_type: 'unknown')
-      @event_ids << event.id
       TagGroupVersion.create!(
-          event_id: event.id,
           tag_group: @group, name: @group.name, version_no: 1, event_type: 'create',
           members: [], placements: [], created_at: Time.current)
     when :group

backend/spec/services/shared_resource_id_allocator_spec.rb

@@ -15,12 +15,10 @@ RSpec.describe SharedResourceIdAllocator do
       TagGroup.new(id:, name: "group #{ number }", version_no: number)
     when 'tag_description_versions'
       TagDescriptionVersion.new(
-          event_id: create_event!(event_type: 'unknown').id,
           id:, tag_id: tag.id, language_code: 'ja', body: 'body', version_no: number,
           event_type: 'create', created_at: Time.current)
     when 'tag_group_versions'
       TagGroupVersion.new(
-          event_id: create_event!(event_type: 'unknown').id,
           id:, tag_group_id: group.id, name: group.name, version_no: number,
           event_type: 'create', members: [], placements: [], created_at: Time.current)
     end
@@ -84,7 +82,6 @@ RSpec.describe SharedResourceIdAllocator do
   it 'reserves a Tag ID referenced only by remaining description history' do
     high = [Tag.maximum(:id).to_i, ExternalTag.maximum(:id).to_i].max + 1000
     TagDescriptionVersion.create!(
-        event_id: create_event!(event_type: 'unknown').id,
         tag_id: high, language_code: 'ja', version_no: 1, body: 'history',
         event_type: 'create', created_at: Time.current)
     expect(create(:tag).id).to be > high

backend/spec/services/youtube/sync_spec.rb

@@ -42,41 +42,6 @@ RSpec.describe Youtube::Sync do
   end
 
   describe '#sync!' do
-    it 'groups created and updated post histories into one sync event' do
-      allow(PostVersionRecorder).to receive(:record!).and_call_original
-      allow(PostVersionRecorder).to receive(:ensure_snapshot!).and_call_original
-      existing = create(:post, url: 'https://youtu.be/video-1', title: 'old title')
-      allow(sync).to receive(:query_terms).and_return([])
-      allow(sync).to receive(:playlist_ids).and_return(['PL123'])
-      allow(client).to receive(:playlist_items).with(playlist_id: 'PL123', page_token: nil)
-          .and_return('items' => [
-              { 'contentDetails' => { 'videoId' => 'video-1' } },
-              { 'contentDetails' => { 'videoId' => 'video-2' } }])
-      allow(client).to receive(:videos).with(['video-1', 'video-2'])
-          .and_return('items' => [
-              youtube_video_item(id: 'video-1', title: 'updated', channel_id: 'UC_NONE'),
-              youtube_video_item(id: 'video-2', title: 'created', channel_id: 'UC_NONE')])
-      previous_post_ids = PostVersion.pluck(:id)
-      previous_tag_ids = TagVersion.pluck(:id)
-
-      expect { sync.sync! }.to change { event_rows.length }.by(1)
-
-      event = event_rows.last
-      expect(event).to include('event_type' => 'posts.sync', 'created_by_user_id' => nil)
-      versions = PostVersion.where.not(id: previous_post_ids)
-      created = Post.find_by!(url: 'https://www.youtube.com/watch?v=video-2')
-      expect(versions.pluck(:post_id).uniq).to contain_exactly(existing.id, created.id)
-      expect(versions.pluck(:event_type)).to include('create', 'update')
-      expect(versions.pluck(:event_id).uniq).to eq([event.fetch('id')])
-      tag_versions = TagVersion.where.not(id: previous_tag_ids)
-      expect(tag_versions).not_to be_empty
-      expect(tag_versions.pluck(:event_id).uniq).to eq([event.fetch('id')])
-
-      events = event_rows
-      expect { sync.sync! }.not_to change(PostVersion, :count)
-      expect(event_rows).to eq(events)
-    end
-
     it 'returns without fetching video details when no video ids are discovered' do
       allow(sync).to receive(:query_terms).and_return([])
       allow(sync).to receive(:playlist_ids).and_return([])

backend/spec/support/event_records.rb

@@ -1,15 +0,0 @@
-module EventRecords
-  # Read the database contract without requiring an application Event model.
-  class EventRow < ActiveRecord::Base
-    self.table_name = 'events'
-  end
-
-  def event_rows
-    EventRow.order(:id).map(&:attributes)
-  end
-
-  def create_event! event_type:, created_by_user: nil
-    EventRow.create!(event_type:, created_by_user_id: created_by_user&.id,
-                     created_at: Time.current)
-  end
-end

backend/spec/support/tag_group_records.rb

@@ -3,13 +3,11 @@ require 'cgi'
 # SQL fixtures use the migration contract without inventing application models.
 # Include explicitly; these helpers must not affect unrelated examples.
 module TagGroupRecords
-  include EventRecords
-
   GROUP_TABLES = [
       'tag_groups', 'tag_group_tags', 'tag_group_groups',
       'tag_group_placements', 'tag_group_versions'].freeze
   WRITE_TABLES = GROUP_TABLES + [
-      'events', 'tag_names', 'tag_description_versions',
+      'tag_names', 'tag_description_versions',
       'tag_descriptions']
 
   def group_connection = ApplicationRecord.connection
@@ -116,7 +114,6 @@ module TagGroupRecords
     group_id = insert_group_row('tag_groups', attributes)
     insert_group_row('tag_group_versions', {
         tag_group_id: group_id, version_no: 1, event_type: 'create',
-        event_id: create_event!(event_type: 'tag_groups.create', created_by_user: user).id,
         name:, description:, members: members.to_json, placements: placements.to_json,
         created_by_user_id: user.id, created_at: now })
     members.each do |member|

backend/spec/tasks/nico_sync_spec.rb

@@ -174,20 +174,20 @@ RSpec.describe 'nico:sync' do
 
   def create_post_version_for!(post, version_no: 1, event_type: 'create', created_by_user: nil)
     PostVersion.create!(
-        event_id: create_event!(event_type: 'unknown').id,
-        post: post,
-        version_no: version_no,
-        event_type: event_type,
-        title: post.title,
-        url: post.url,
-        thumbnail_base: post.thumbnail_base,
-        tags: snapshot_tags(post),
-        tags_json: post.snapshot_tags_json,
-        parent_post_ids: post.snapshot_parent_post_ids.join(' '),
-        original_created_from: post.original_created_from,
-        original_created_before: post.original_created_before,
-        created_at: Time.current,
-        created_by_user: created_by_user)
+      post: post,
+      version_no: version_no,
+      event_type: event_type,
+      title: post.title,
+      url: post.url,
+      thumbnail_base: post.thumbnail_base,
+      tags: snapshot_tags(post),
+      tags_json: post.snapshot_tags_json,
+      parent_post_ids: post.snapshot_parent_post_ids.join(' '),
+      original_created_from: post.original_created_from,
+      original_created_before: post.original_created_before,
+      created_at: Time.current,
+      created_by_user: created_by_user
+    )
   end
 
   it '新規 post 作成時に version 1 を作る' do
@@ -209,7 +209,6 @@ RSpec.describe 'nico:sync' do
     expect {
       run_rake_task('nico:sync')
     }.to change(PostVersion, :count).by(1)
-        .and change { event_rows.length }.by(1)
 
     post = Post.find_by!(url: 'https://www.nicovideo.jp/watch/sm9')
     version = post.post_versions.order(:version_no).last
@@ -218,32 +217,6 @@ RSpec.describe 'nico:sync' do
     expect(version.event_type).to eq('create')
     expect(version.created_by_user).to be_nil
     expect(version.tags).to eq(snapshot_tags(post.reload))
-    event = event_rows.last
-    expect(event).to include('event_type' => 'posts.sync', 'created_by_user_id' => nil)
-    expect(version.event_id).to eq(event.fetch('id'))
-  end
-
-  it 'groups created and updated post histories into one sync event' do
-    existing = create(:post, title: 'old', url: 'https://www.nicovideo.jp/watch/sm9')
-    stub_python([
-        { 'code' => 'sm9', 'title' => 'updated', 'tags' => [] },
-        { 'code' => 'sm10', 'title' => 'created', 'tags' => [] }])
-    allow(URI).to receive(:open).and_return(StringIO.new('<html></html>'))
-    previous_post_ids = PostVersion.pluck(:id)
-    previous_tag_ids = TagVersion.pluck(:id)
-
-    expect { run_rake_task('nico:sync') }.to change { event_rows.length }.by(1)
-
-    event = event_rows.last
-    expect(event).to include('event_type' => 'posts.sync', 'created_by_user_id' => nil)
-    created = Post.find_by!(url: 'https://www.nicovideo.jp/watch/sm10')
-    versions = PostVersion.where.not(id: previous_post_ids)
-    expect(versions.pluck(:post_id).uniq).to contain_exactly(existing.id, created.id)
-    expect(versions.pluck(:event_type)).to include('create', 'update')
-    expect(versions.pluck(:event_id).uniq).to eq([event.fetch('id')])
-    tag_versions = TagVersion.where.not(id: previous_tag_ids)
-    expect(tag_versions).not_to be_empty
-    expect(tag_versions.pluck(:event_id).uniq).to eq([event.fetch('id')])
   end
 
   it '既存 post の内容または tags が変わったとき update version を作る' do
@@ -309,7 +282,6 @@ RSpec.describe 'nico:sync' do
     }])
 
     allow(URI).to receive(:open).and_return(StringIO.new('<html></html>'))
-    events = event_rows
 
     expect {
       run_rake_task('nico:sync')
@@ -319,7 +291,6 @@ RSpec.describe 'nico:sync' do
     expect(version.version_no).to eq(1)
     expect(version.event_type).to eq('create')
     expect(version.tags).to eq(snapshot_tags(post.reload))
-    expect(event_rows).to eq(events)
   end
 
   it '新規 nico tag に nico tag version を作る' do