[Ovirt-devel] [PATCH server] DB change to support larger numbers.

[Jason Guiditta]

Fix migration number, 029 was already taken.

Since we store mem, storage, etc in KB, we need an 8 byte int.
This patch change all tables with this type of data to support larger size.

Signed-off-by: Jason Guiditta <jguiditt at redhat.com>
---
 src/db/migrate/030_update_integer_size.rb |   22 ++++++++++++++++++++++
 1 files changed, 22 insertions(+), 0 deletions(-)
 create mode 100644 src/db/migrate/030_update_integer_size.rb

diff --git a/src/db/migrate/030_update_integer_size.rb b/src/db/migrate/030_update_integer_size.rb
new file mode 100644
index 0000000..5c67d48
--- /dev/null
+++ b/src/db/migrate/030_update_integer_size.rb
@@ -0,0 +1,22 @@
+class UpdateIntegerSize < ActiveRecord::Migration
+  def self.up
+    #Since we store mem, storage, etc in KB, we need an 8 byte int.
+    #Change all tables with this type of data to support larger size
+
+    change_column :hosts, :memory, :integer, :limit => 8
+    change_column :storage_volumes, :size, :integer, :limit => 8
+    change_column :quotas, :total_vmemory, :integer, :limit => 8
+    change_column :quotas, :total_storage, :integer, :limit => 8
+    change_column :vms, :memory_allocated, :integer, :limit => 8
+    change_column :vms, :memory_used, :integer, :limit => 8
+  end
+
+  def self.down
+    change_column :hosts, :memory, :integer, :limit => 4
+    change_column :storage_volumes, :size, :integer, :limit => 4
+    change_column :quotas, :total_vmemory, :integer, :limit => 4
+    change_column :quotas, :total_storage, :integer, :limit => 4
+    change_column :vms, :memory_allocated, :integer, :limit => 4
+    change_column :vms, :memory_used, :integer, :limit => 4
+  end
+end
-- 
1.5.6.5