Omer Frenkel has uploaded a new change for review.
Change subject: core: change supported emulated machines field type
......................................................................
core: change supported emulated machines field type
currently vdsDynamic.supportedEmulatedMachines is varchar(255)
this can be exceeded by the server, so changed to text
also changed definition of v_hbas field to text in stored procedures
since its text in the table
Change-Id: I59f4e3c8dd30ed8796ed15431d25c5a7fa785718
Signed-off-by: Omer Frenkel <ofren...@redhat.com>
---
A
packaging/dbscripts/upgrade/03_06_1150_change_supported_emulated_machines_to_text.sql
M packaging/dbscripts/vds_sp.sql
2 files changed, 7 insertions(+), 4 deletions(-)
git pull ssh://gerrit.ovirt.org:29418/ovirt-engine refs/changes/45/39145/1
diff --git
a/packaging/dbscripts/upgrade/03_06_1150_change_supported_emulated_machines_to_text.sql
b/packaging/dbscripts/upgrade/03_06_1150_change_supported_emulated_machines_to_text.sql
new file mode 100644
index 0000000..5498efb
--- /dev/null
+++
b/packaging/dbscripts/upgrade/03_06_1150_change_supported_emulated_machines_to_text.sql
@@ -0,0 +1,3 @@
+-- change vds_dynamic.supported_emulated_machines to text
+-- currently it has max of 255 chars, but this can be exceeded for example if
using the virt-preview repo
+SELECT fn_db_change_column_type('vds_dynamic', 'supported_emulated_machines',
'varchar', 'text');
diff --git a/packaging/dbscripts/vds_sp.sql b/packaging/dbscripts/vds_sp.sql
index 6795bf5..7f454cc 100644
--- a/packaging/dbscripts/vds_sp.sql
+++ b/packaging/dbscripts/vds_sp.sql
@@ -202,8 +202,8 @@
v_hw_serial_number VARCHAR(255),
v_hw_uuid VARCHAR(255),
v_hw_family VARCHAR(255),
- v_hbas VARCHAR(255),
- v_supported_emulated_machines VARCHAR(255),
+ v_hbas TEXT,
+ v_supported_emulated_machines TEXT,
v_controlled_by_pm_policy BOOLEAN,
v_kdump_status SMALLINT,
v_selinux_enforce_mode INTEGER,
@@ -288,8 +288,8 @@
v_hw_serial_number VARCHAR(255),
v_hw_uuid VARCHAR(255),
v_hw_family VARCHAR(255),
- v_hbas VARCHAR(255),
- v_supported_emulated_machines VARCHAR(255),
+ v_hbas TEXT,
+ v_supported_emulated_machines TEXT,
v_kdump_status SMALLINT,
v_selinux_enforce_mode INTEGER,
v_auto_numa_balancing SMALLINT,
--
To view, visit https://gerrit.ovirt.org/39145
To unsubscribe, visit https://gerrit.ovirt.org/settings
Gerrit-MessageType: newchange
Gerrit-Change-Id: I59f4e3c8dd30ed8796ed15431d25c5a7fa785718
Gerrit-PatchSet: 1
Gerrit-Project: ovirt-engine
Gerrit-Branch: master
Gerrit-Owner: Omer Frenkel <ofren...@redhat.com>
_______________________________________________
Engine-patches mailing list
Engine-patches@ovirt.org
http://lists.ovirt.org/mailman/listinfo/engine-patches
