Shirly Radco has uploaded a new change for review.

Change subject: history: Update statistics table history_id to bigint
......................................................................

history: Update statistics table history_id to bigint

Update host_interface statistics tables
history_id to bigint.

Change-Id: I355e47354ca23899141aa2b0adc570105cbc02ae
Bug-Url: https://bugzilla.redhat.com/1121994
Signed-off-by: Shirly Radco <[email protected]>
---
A packaging/dbscripts/upgrade/03_06_0010_updated_history_id_to_bigint.sql
1 file changed, 5 insertions(+), 0 deletions(-)


  git pull ssh://gerrit.ovirt.org:29418/ovirt-dwh refs/changes/37/32937/1

diff --git 
a/packaging/dbscripts/upgrade/03_06_0010_updated_history_id_to_bigint.sql 
b/packaging/dbscripts/upgrade/03_06_0010_updated_history_id_to_bigint.sql
new file mode 100644
index 0000000..2b3bf86
--- /dev/null
+++ b/packaging/dbscripts/upgrade/03_06_0010_updated_history_id_to_bigint.sql
@@ -0,0 +1,5 @@
+-- Update statistics table history_id to bigint
+
+SELECT fn_db_change_column_type('host_interface_daily_history', 'history_id', 
'integer', 'bigint');
+SELECT fn_db_change_column_type('host_interface_hourly_history', 'history_id', 
'integer', 'bigint');
+SELECT fn_db_change_column_type('host_interface_samples_history', 
'history_id', 'integer', 'bigint');


-- 
To view, visit http://gerrit.ovirt.org/32937
To unsubscribe, visit http://gerrit.ovirt.org/settings

Gerrit-MessageType: newchange
Gerrit-Change-Id: I355e47354ca23899141aa2b0adc570105cbc02ae
Gerrit-PatchSet: 1
Gerrit-Project: ovirt-dwh
Gerrit-Branch: master
Gerrit-Owner: Shirly Radco <[email protected]>
_______________________________________________
Engine-patches mailing list
[email protected]
http://lists.ovirt.org/mailman/listinfo/engine-patches

Reply via email to