Disable running on shared runners

3 files changed, 12 insertions, 1 deletions

diff --git a/CHANGELOG b/CHANGELOG
index 2a02c06..fb5015e 100644
--- a/CHANGELOG
+++ b/CHANGELOG
@@ -2,6 +2,9 @@ v7.10.0
   - Projects sorting by last commit date
   - Add project search at runner page
 
+v7.9.2
+  - [Security] Already existing projects should not be served by shared runners
+
 v7.9.1
   - [Security] Adding explicit is_shared parameter to runner
   - [Security] By default new projects are not served by shared runners
diff --git a/db/migrate/20150330001111_disable_shared_runners.rb b/db/migrate/20150330001111_disable_shared_runners.rb
new file mode 100644
index 0000000..dbb32ba
--- /dev/null
+++ b/db/migrate/20150330001111_disable_shared_runners.rb
@@ -0,0 +1,8 @@
+class DisableSharedRunners < ActiveRecord::Migration
+  def up
+    execute("UPDATE projects SET shared_runners_enabled = false WHERE id IN (SELECT project_id FROM runner_projects)");
+  end
+
+  def down
+  end
+end
diff --git a/db/schema.rb b/db/schema.rb
index f066143..e194f7a 100644
--- a/db/schema.rb
+++ b/db/schema.rb
@@ -11,7 +11,7 @@
 #
 # It's strongly recommended that you check this file into your version control system.
 
-ActiveRecord::Schema.define(version: 20150324001227) do
+ActiveRecord::Schema.define(version: 20150330001111) do
 
   # These are extensions that must be enabled in order to support this database
   enable_extension "plpgsql"