Merge branch 'erdgeist-revive-events'

6 files changed, 57 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