From f6ce43a1d0fc58c09a10dd04e15b04082c7b0327 Mon Sep 17 00:00:00 2001
From: Stephane Gamard <stephane.gamard@searchbox.com>
Date: Wed, 4 Jun 2014 16:53:43 +0200
Subject: [PATCH] SONAR-5329 - Field renaming in DB

---
 .../main/resources/org/sonar/core/log/db/LogMapper.xml    | 4 ++--
 .../resources/org/sonar/core/persistence/schema-h2.ddl    | 4 ++--
 .../webapp/WEB-INF/db/migrate/540_create_log_table.rb     | 8 ++++----
 3 files changed, 8 insertions(+), 8 deletions(-)

diff --git a/sonar-core/src/main/resources/org/sonar/core/log/db/LogMapper.xml b/sonar-core/src/main/resources/org/sonar/core/log/db/LogMapper.xml
index 61f964cbfcd..ddc966578a8 100644
--- a/sonar-core/src/main/resources/org/sonar/core/log/db/LogMapper.xml
+++ b/sonar-core/src/main/resources/org/sonar/core/log/db/LogMapper.xml
@@ -11,9 +11,9 @@
     <select id="selectByKey" parameterType="map" resultType="Log">
       SELECT
         l.payload_field as "payload",
-        l.time_field as "time",
+        l.created_at as "time",
         l.execution_time_field as "executionTime",
-        l.author_field as "author",
+        l.user_login as "author",
         l.data_field as "data"
       FROM logs l
       WHERE l.time_field=#{key.time}
diff --git a/sonar-core/src/main/resources/org/sonar/core/persistence/schema-h2.ddl b/sonar-core/src/main/resources/org/sonar/core/persistence/schema-h2.ddl
index 653080d15b5..bf7ced267bd 100644
--- a/sonar-core/src/main/resources/org/sonar/core/persistence/schema-h2.ddl
+++ b/sonar-core/src/main/resources/org/sonar/core/persistence/schema-h2.ddl
@@ -557,9 +557,9 @@ CREATE TABLE "PERM_TEMPLATES_GROUPS" (
 
 
 CREATE TABLE "LOGS" (
-  "TIME_FIELD" TIMESTAMP,
+  "CREATED_AT" TIMESTAMP,
   "EXECUTION_TIME_FIELD" LONG,
-  "AUTHOR_FIELD" VARCHAR(30),
+  "USER_LOGIN" VARCHAR(30),
   "PAYLOAD_FIELD" VARCHAR(250),
   "DATA_FIELD" CLOB(2147483647)
 );
diff --git a/sonar-server/src/main/webapp/WEB-INF/db/migrate/540_create_log_table.rb b/sonar-server/src/main/webapp/WEB-INF/db/migrate/540_create_log_table.rb
index d81366d5973..eff627f51e3 100644
--- a/sonar-server/src/main/webapp/WEB-INF/db/migrate/540_create_log_table.rb
+++ b/sonar-server/src/main/webapp/WEB-INF/db/migrate/540_create_log_table.rb
@@ -21,10 +21,10 @@ class CreateLogTable < ActiveRecord::Migration
 
   def self.up
     create_table 'logs'do |t|
-      t.column 'time_field',   :datetime, :null => false
-      t.column 'execution_time_field', :long
-      t.column 'author_field', :string
-      t.column 'data_field', :blob
+      t.column 'created_at',   :datetime, :null => false
+      t.column 'execution_time_field', :int
+      t.column 'user_login', :string
+      t.column 'data_field', :text
       t.column 'payload_field', :string
     end
 
-- 
2.39.5