Attempt to enable hstore using migration

Ref #1789

1 files changed, 9 insertions, 2 deletions

diff --git a/db/migrate/20160928084508_create_line_referential_sync_messages.rb b/db/migrate/20160928084508_create_line_referential_sync_messages.rb
index dfd673ab6..75ab6fb78 100644
--- a/db/migrate/20160928084508_create_line_referential_sync_messages.rb
+++ b/db/migrate/20160928084508_create_line_referential_sync_messages.rb
@@ -1,13 +1,20 @@
 class CreateLineReferentialSyncMessages < ActiveRecord::Migration
-  def change
+  def self.up
+    execute 'CREATE EXTENSION IF NOT EXISTS hstore SCHEMA shared_extensions;'
+
     create_table :line_referential_sync_messages do |t|
       t.integer :criticity
       t.string :message_key
       t.hstore :message_attributs
       t.references :line_referential_sync
-
       t.timestamps
     end
+
     add_index :line_referential_sync_messages, :line_referential_sync_id, name: 'line_referential_sync_id'
   end
+
+  def self.down
+    execute 'DROP EXTENSION IF EXISTS hstore SCHEMA shared_extensions;'
+    drop_table :line_referential_sync_messages
+  end
 end