9 files changed, 87 insertions, 0 deletions

diff --git a/db/migrate/20260627233640_upgrade_events_and_nodes_for_standalone_events.rb b/db/migrate/20260627233640_upgrade_events_and_nodes_for_standalone_events.rb
new file mode 100644
index 0000000..2605e5c
--- /dev/null
+++ b/db/migrate/20260627233640_upgrade_events_and_nodes_for_standalone_events.rb
@@ -0,0 +1,22 @@
+class UpgradeEventsAndNodesForStandaloneEvents < ActiveRecord::Migration[8.1]
+  def up
+    # Events: make node optional, add missing fields
+    change_column_null :events, :node_id, true
+    add_column :events, :title,       :string
+    add_column :events, :description, :text
+
+    # Occurrences: make node optional
+    change_column_null :occurrences, :node_id, true
+
+    # Nodes: add external URL
+    add_column :nodes, :external_url, :string
+  end
+
+  def down
+    remove_column :nodes,       :external_url
+    change_column_null :occurrences, :node_id, false
+    remove_column :events, :description
+    remove_column :events, :title
+    change_column_null :events, :node_id, false
+  end
+end
diff --git a/db/migrate/20260705152316_add_default_template_name_to_nodes.rb b/db/migrate/20260705152316_add_default_template_name_to_nodes.rb
new file mode 100644
index 0000000..ec2d8ea
--- /dev/null
+++ b/db/migrate/20260705152316_add_default_template_name_to_nodes.rb
@@ -0,0 +1,13 @@
+class AddDefaultTemplateNameToNodes < ActiveRecord::Migration[8.1]
+  def up
+    add_column :nodes, :default_template_name, :string
+
+    Node.find_each do |node|
+      node.update_column(:default_template_name, "update") if node.update?
+    end
+  end
+
+  def down
+    remove_column :nodes, :default_template_name
+  end
+end
diff --git a/db/migrate/20260706014551_add_foreign_key_on_occurrences_event_id.rb b/db/migrate/20260706014551_add_foreign_key_on_occurrences_event_id.rb
new file mode 100644
index 0000000..a8df681
--- /dev/null
+++ b/db/migrate/20260706014551_add_foreign_key_on_occurrences_event_id.rb
@@ -0,0 +1,6 @@
+class AddForeignKeyOnOccurrencesEventId < ActiveRecord::Migration[8.1]
+  def change
+    add_index :occurrences, :event_id
+    add_foreign_key :occurrences, :events, on_delete: :cascade, deferrable: :immediate
+  end
+end
diff --git a/db/migrate/20260706014724_drop_custom_rrule_from_events.rb b/db/migrate/20260706014724_drop_custom_rrule_from_events.rb
new file mode 100644
index 0000000..7e27ba7
--- /dev/null
+++ b/db/migrate/20260706014724_drop_custom_rrule_from_events.rb
@@ -0,0 +1,5 @@
+class DropCustomRruleFromEvents < ActiveRecord::Migration[8.1]
+  def change
+    remove_column :events, :custom_rrule, :string
+  end
+end
diff --git a/db/migrate/20260706030547_add_preview_token_to_pages.rb b/db/migrate/20260706030547_add_preview_token_to_pages.rb
new file mode 100644
index 0000000..794cbb2
--- /dev/null
+++ b/db/migrate/20260706030547_add_preview_token_to_pages.rb
@@ -0,0 +1,6 @@
+class AddPreviewTokenToPages < ActiveRecord::Migration[8.1]
+  def change
+    add_column :pages, :preview_token, :string
+    add_index :pages, :preview_token, unique: true
+  end
+end
diff --git a/db/migrate/20260708095943_add_autosave_id_to_nodes.rb b/db/migrate/20260708095943_add_autosave_id_to_nodes.rb
new file mode 100644
index 0000000..eedcc00
--- /dev/null
+++ b/db/migrate/20260708095943_add_autosave_id_to_nodes.rb
@@ -0,0 +1,5 @@
+class AddAutosaveIdToNodes < ActiveRecord::Migration[8.1]
+  def change
+    add_column :nodes, :autosave_id, :integer
+  end
+end
diff --git a/db/migrate/20260714233414_create_node_actions.rb b/db/migrate/20260714233414_create_node_actions.rb
new file mode 100644
index 0000000..6c18285
--- /dev/null
+++ b/db/migrate/20260714233414_create_node_actions.rb
@@ -0,0 +1,19 @@
+class CreateNodeActions < ActiveRecord::Migration[8.1]
+  def change
+    create_table :node_actions do |t|
+      t.references :node, foreign_key: { on_delete: :nullify }
+      t.references :page, foreign_key: { on_delete: :nullify }
+      t.references :user, foreign_key: { on_delete: :nullify }
+      t.string   :action, null: false
+      t.string   :locale
+      t.string   :inferred_from
+      t.jsonb    :metadata, null: false
+      t.datetime :occurred_at, null: false
+
+      t.timestamps
+    end
+
+    add_index :node_actions, [:node_id, :occurred_at]
+    add_index :node_actions, :action
+  end
+end
diff --git a/db/migrate/20260716165542_add_password_digest_to_users.rb b/db/migrate/20260716165542_add_password_digest_to_users.rb
new file mode 100644
index 0000000..df711d7
--- /dev/null
+++ b/db/migrate/20260716165542_add_password_digest_to_users.rb
@@ -0,0 +1,5 @@
+class AddPasswordDigestToUsers < ActiveRecord::Migration[8.1]
+  def change
+    add_column :users, :password_digest, :string
+  end
+end
diff --git a/db/migrate/20260717192043_drop_nested_set_columns_from_nodes.rb b/db/migrate/20260717192043_drop_nested_set_columns_from_nodes.rb
new file mode 100644
index 0000000..697ab77
--- /dev/null
+++ b/db/migrate/20260717192043_drop_nested_set_columns_from_nodes.rb
@@ -0,0 +1,6 @@
+class DropNestedSetColumnsFromNodes < ActiveRecord::Migration[8.1]
+  def change
+    remove_column :nodes, :lft, :integer
+    remove_column :nodes, :rgt, :integer
+  end
+end