diff db/migrate/20130710182539_add_queries_visibility.rb @ 1526:404aa68d4227

Merge from live branch

--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/db/migrate/20130710182539_add_queries_visibility.rb	Thu Sep 11 12:46:20 2014 +0100
@@ -0,0 +1,13 @@
+class AddQueriesVisibility < ActiveRecord::Migration
+  def up
+    add_column :queries, :visibility, :integer, :default => 0
+    Query.where(:is_public => true).update_all(:visibility => 2)
+    remove_column :queries, :is_public
+  end
+
+  def down
+    add_column :queries, :is_public, :boolean, :default => true, :null => false
+    Query.where('visibility <> ?', 2).update_all(:is_public => false)
+    remove_column :queries, :visibility
+  end
+end