Merge pull request #150 from af83/5301-add_business_calendars

Refs #5301 First draft for Business Calendars

3 files changed, 32 insertions, 0 deletions

diff --git a/db/migrate/20171214131755_create_business_calendars.rb b/db/migrate/20171214131755_create_business_calendars.rb
new file mode 100644
index 000000000..aa7c1ab12
--- /dev/null
+++ b/db/migrate/20171214131755_create_business_calendars.rb
@@ -0,0 +1,14 @@
+class CreateBusinessCalendars < ActiveRecord::Migration
+  def change
+    create_table :business_calendars do |t|
+      t.string :name
+      t.string :short_name
+      t.string :color
+      t.daterange :date_ranges, array: true
+      t.date :dates, array: true
+      t.belongs_to :organisation, index: true
+
+      t.timestamps null: false
+    end
+  end
+end
diff --git a/db/migrate/20171215144543_rename_business_calendars_to_purchase_windows.rb b/db/migrate/20171215144543_rename_business_calendars_to_purchase_windows.rb
new file mode 100644
index 000000000..d4467d6a7
--- /dev/null
+++ b/db/migrate/20171215144543_rename_business_calendars_to_purchase_windows.rb
@@ -0,0 +1,5 @@
+class RenameBusinessCalendarsToPurchaseWindows < ActiveRecord::Migration
+  def change
+    rename_table :business_calendars, :purchase_windows
+  end
+end
diff --git a/db/migrate/20171215145023_update_purchase_windows_attributes.rb b/db/migrate/20171215145023_update_purchase_windows_attributes.rb
new file mode 100644
index 000000000..48dfb15bc
--- /dev/null
+++ b/db/migrate/20171215145023_update_purchase_windows_attributes.rb
@@ -0,0 +1,13 @@
+class UpdatePurchaseWindowsAttributes < ActiveRecord::Migration
+  def change
+    add_column :purchase_windows, :objectid, :string
+    add_column :purchase_windows, :checksum, :string
+    add_column :purchase_windows, :checksum_source, :text
+
+    remove_column :purchase_windows, :short_name, :string
+    remove_column :purchase_windows, :dates, :date
+    remove_column :purchase_windows, :organisation_id, :integer
+
+    add_reference :purchase_windows, :referential, type: :bigint, index: true
+  end
+end