2 files changed, 69 insertions, 0 deletions
diff --git a/db/migrate/20171217104241_create_gallery_links_gallery_links.refinery_gallery_links.rb b/db/migrate/20171217104241_create_gallery_links_gallery_links.refinery_gallery_links.rb
new file mode 100644
index 0000000..03a5865
--- /dev/null
+++ b/db/migrate/20171217104241_create_gallery_links_gallery_links.refinery_gallery_links.rb
@@ -0,0 +1,31 @@
+# This migration comes from refinery_gallery_links (originally 1)
+class CreateGalleryLinksGalleryLinks < ActiveRecord::Migration
+
+  def up
+    create_table :refinery_gallery_links do |t|
+      t.string :title
+      t.string :url
+      t.string :photographer
+      t.text :description
+      t.integer :image_id
+      t.integer :position
+
+      t.timestamps
+    end
+
+  end
+
+  def down
+    if defined?(::Refinery::UserPlugin)
+      ::Refinery::UserPlugin.destroy_all({:name => "refinerycms-gallery_links"})
+    end
+
+    if defined?(::Refinery::Page)
+      ::Refinery::Page.delete_all({:link_url => "/gallery_links/gallery_links"})
+    end
+
+    drop_table :refinery_gallery_links
+
+  end
+
+end
diff --git a/db/migrate/20180107152351_replace_title_with_date_bands_venue.refinery_gallery_links.rb b/db/migrate/20180107152351_replace_title_with_date_bands_venue.refinery_gallery_links.rb
new file mode 100644
index 0000000..2f79338
--- /dev/null
+++ b/db/migrate/20180107152351_replace_title_with_date_bands_venue.refinery_gallery_links.rb
@@ -0,0 +1,38 @@
+# This migration comes from refinery_gallery_links (originally 2)
+class ReplaceTitleWithDateBandsVenue < ActiveRecord::Migration
+  def up
+    add_column :refinery_gallery_links, :date, :date, null: false, default: '2000-01-01', index: true
+    add_column :refinery_gallery_links, :bands, :string, null: false, default: 'Unkown bands', index: true
+    add_column :refinery_gallery_links, :venue, :string, index: true
+
+    Refinery::GalleryLinks::GalleryLink.all.each do |g|
+      m = g.title.match /^(.+) (\d{2}\/\d{2}\/\d{2}) @ ([^.]+).$/
+      if m
+        g.date = Date.strptime(m[2], '%d/%m/%y')
+        g.bands = m[1]
+        g.venue = m[3]
+      else
+        g.date = Date.today
+        g.bands = g.title
+        g.venue = nil
+      end
+
+      g.save!
+    end
+
+    remove_column :refinery_gallery_links, :title
+  end
+
+  def down
+    add_column :refineru_gallery_links, title, index: true
+
+    Refinery::GalleryLinks::GalleryLink.all.each do |g|
+      g.title = "#{g.bands} #{g.strftime('%d/%m/%y')} @ #{g.venue}."
+      g.save!
+    end
+
+    remove_column :refinery_gallery_links, :venue
+    remove_column :refinery_gallery_links, :bands
+    remove_column :refinery_gallery_links, :date
+  end
+end