Replace table ANALYSIS_REPORTS by CE_QUEUE and CE_ACTIVITY

5 files changed, 149 insertions, 0 deletions

diff --git a/server/sonar-web/src/main/webapp/WEB-INF/db/migrate/414_add_scan_and_dry_run_permissions.rb b/server/sonar-web/src/main/webapp/WEB-INF/db/migrate/414_add_scan_and_dry_run_permissions.rb
index c8ba5db51d7..d46065fdecc 100644
--- a/server/sonar-web/src/main/webapp/WEB-INF/db/migrate/414_add_scan_and_dry_run_permissions.rb
+++ b/server/sonar-web/src/main/webapp/WEB-INF/db/migrate/414_add_scan_and_dry_run_permissions.rb
@@ -39,6 +39,10 @@ class AddScanAndDryRunPermissions < ActiveRecord::Migration
     # -- Role dryRunScan --
     # Anyone
     GroupRole.create(:group_id => nil, :role => 'dryRunScan', :resource_id => nil)
+
+    # -- Role provisioning --
+    # Anyone
+    GroupRole.create(:group_id => nil, :role => 'provisioning', :resource_id => nil)
   end
 
 end
diff --git a/server/sonar-web/src/main/webapp/WEB-INF/db/migrate/931_create_ce_activity.rb b/server/sonar-web/src/main/webapp/WEB-INF/db/migrate/931_create_ce_activity.rb
new file mode 100644
index 00000000000..e2bb4cb8fa5
--- /dev/null
+++ b/server/sonar-web/src/main/webapp/WEB-INF/db/migrate/931_create_ce_activity.rb
@@ -0,0 +1,45 @@
+#
+# SonarQube, open source software quality management tool.
+# Copyright (C) 2008-2014 SonarSource
+# mailto:contact AT sonarsource DOT com
+#
+# SonarQube is free software; you can redistribute it and/or
+# modify it under the terms of the GNU Lesser General Public
+# License as published by the Free Software Foundation; either
+# version 3 of the License, or (at your option) any later version.
+#
+# SonarQube is distributed in the hope that it will be useful,
+# but WITHOUT ANY WARRANTY; without even the implied warranty of
+# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
+# Lesser General Public License for more details.
+#
+# You should have received a copy of the GNU Lesser General Public License
+# along with this program; if not, write to the Free Software Foundation,
+# Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301, USA.
+#
+#
+# SonarQube 5.2
+#
+class CreateCeActivity < ActiveRecord::Migration
+
+  def self.up
+    create_table 'ce_activity' do |t|
+      t.column 'uuid', :string, :limit => 40, :null => false
+      t.column 'task_type', :string, :limit => 15, :null => false
+      t.column 'component_uuid', :string, :limit => 40, :null => true
+      t.column 'status', :string, :limit => 15, :null => false
+      t.column 'is_last', :boolean, :null => false
+      t.column 'is_last_key', :string, :limit => 55, :null => false
+      t.column 'submitter_login', :string, :limit => 255, :null => true
+      t.column 'submitted_at', :big_integer, :null => false
+      t.column 'started_at', :big_integer, :null => true
+      t.column 'finished_at', :big_integer, :null => true
+      t.column 'created_at', :big_integer, :null => false
+      t.column 'updated_at', :big_integer, :null => false
+      t.column 'execution_time_ms', :big_integer, :null => true
+    end
+    add_index 'ce_activity', 'uuid', :name => 'ce_activity_uuid', :unique => true
+  end
+
+end
+
diff --git a/server/sonar-web/src/main/webapp/WEB-INF/db/migrate/932_create_ce_queue.rb b/server/sonar-web/src/main/webapp/WEB-INF/db/migrate/932_create_ce_queue.rb
new file mode 100644
index 00000000000..e8d0be4da42
--- /dev/null
+++ b/server/sonar-web/src/main/webapp/WEB-INF/db/migrate/932_create_ce_queue.rb
@@ -0,0 +1,40 @@
+#
+# SonarQube, open source software quality management tool.
+# Copyright (C) 2008-2014 SonarSource
+# mailto:contact AT sonarsource DOT com
+#
+# SonarQube is free software; you can redistribute it and/or
+# modify it under the terms of the GNU Lesser General Public
+# License as published by the Free Software Foundation; either
+# version 3 of the License, or (at your option) any later version.
+#
+# SonarQube is distributed in the hope that it will be useful,
+# but WITHOUT ANY WARRANTY; without even the implied warranty of
+# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
+# Lesser General Public License for more details.
+#
+# You should have received a copy of the GNU Lesser General Public License
+# along with this program; if not, write to the Free Software Foundation,
+# Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301, USA.
+#
+#
+# SonarQube 5.2
+#
+class CreateCeQueue < ActiveRecord::Migration
+
+  def self.up
+    create_table 'ce_queue' do |t|
+      t.column 'uuid', :string, :limit => 40, :null => false
+      t.column 'task_type', :string, :limit => 15, :null => false
+      t.column 'component_uuid', :string, :limit => 40, :null => true
+      t.column 'status', :string, :limit => 15, :null => false
+      t.column 'submitter_login', :string, :limit => 255, :null => true
+      t.column 'started_at', :big_integer, :null => true
+      t.column 'created_at', :big_integer, :null => false
+      t.column 'updated_at', :big_integer, :null => false
+    end
+    add_index 'ce_queue', 'uuid', :name => 'ce_queue_uuid', :unique => true
+  end
+
+end
+
diff --git a/server/sonar-web/src/main/webapp/WEB-INF/db/migrate/933_drop_table_analysis_reports.rb b/server/sonar-web/src/main/webapp/WEB-INF/db/migrate/933_drop_table_analysis_reports.rb
new file mode 100644
index 00000000000..36e925b47e9
--- /dev/null
+++ b/server/sonar-web/src/main/webapp/WEB-INF/db/migrate/933_drop_table_analysis_reports.rb
@@ -0,0 +1,30 @@
+#
+# SonarQube, open source software quality management tool.
+# Copyright (C) 2008-2014 SonarSource
+# mailto:contact AT sonarsource DOT com
+#
+# SonarQube is free software; you can redistribute it and/or
+# modify it under the terms of the GNU Lesser General Public
+# License as published by the Free Software Foundation; either
+# version 3 of the License, or (at your option) any later version.
+#
+# SonarQube is distributed in the hope that it will be useful,
+# but WITHOUT ANY WARRANTY; without even the implied warranty of
+# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
+# Lesser General Public License for more details.
+#
+# You should have received a copy of the GNU Lesser General Public License
+# along with this program; if not, write to the Free Software Foundation,
+# Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301, USA.
+#
+#
+# SonarQube 5.2
+#
+class DropTableAnalysisReports < ActiveRecord::Migration
+
+  def self.up
+    drop_table 'analysis_reports'
+  end
+
+end
+
diff --git a/server/sonar-web/src/main/webapp/WEB-INF/db/migrate/934_remove_analysis_reports_from_activities.rb b/server/sonar-web/src/main/webapp/WEB-INF/db/migrate/934_remove_analysis_reports_from_activities.rb
new file mode 100644
index 00000000000..3c877912ab3
--- /dev/null
+++ b/server/sonar-web/src/main/webapp/WEB-INF/db/migrate/934_remove_analysis_reports_from_activities.rb
@@ -0,0 +1,30 @@
+#
+# SonarQube, open source software quality management tool.
+# Copyright (C) 2008-2014 SonarSource
+# mailto:contact AT sonarsource DOT com
+#
+# SonarQube is free software; you can redistribute it and/or
+# modify it under the terms of the GNU Lesser General Public
+# License as published by the Free Software Foundation; either
+# version 3 of the License, or (at your option) any later version.
+#
+# SonarQube is distributed in the hope that it will be useful,
+# but WITHOUT ANY WARRANTY; without even the implied warranty of
+# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
+# Lesser General Public License for more details.
+#
+# You should have received a copy of the GNU Lesser General Public License
+# along with this program; if not, write to the Free Software Foundation,
+# Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301, USA.
+#
+#
+# SonarQube 5.2
+#
+class RemoveAnalysisReportsFromActivities < ActiveRecord::Migration
+
+  def self.up
+    execute_java_migration('org.sonar.db.version.v52.RemoveAnalysisReportsFromActivities')
+  end
+
+end
+