Eli Mesika has uploaded a new change for review.

Change subject: core: squash 
03_00_0280_change_blank_template_default_display_type_to_spice.sql
......................................................................

core: squash 03_00_0280_change_blank_template_default_display_type_to_spice.sql

Change-Id: Iecdfc85d03e10f668ddd515b50244b0f1f6b95ec
Signed-off-by: Eli Mesika <emes...@redhat.com>
---
M backend/manager/dbscripts/insert_data.sql
D 
backend/manager/dbscripts/upgrade/03_00_0280_change_blank_template_default_display_type_to_spice.sql
2 files changed, 1 insertion(+), 2 deletions(-)


  git pull ssh://gerrit.ovirt.org:29418/ovirt-engine refs/changes/65/15465/1

diff --git a/backend/manager/dbscripts/insert_data.sql 
b/backend/manager/dbscripts/insert_data.sql
index 9cedff8..c765e41 100644
--- a/backend/manager/dbscripts/insert_data.sql
+++ b/backend/manager/dbscripts/insert_data.sql
@@ -39,7 +39,7 @@
 insert into network (id,name,description,storage_pool_id) select v_id_0009, 
'engine', 'Management Network', v_storage_pool_id where not exists (select * 
from network);
 insert into network_cluster (network_id, cluster_id, status) select 
v_id_0009,v_cluster_id,1 where not exists (select * from network_cluster);
 insert into image_templates 
(it_guid,os,os_version,creation_date,size,description,bootable) select 
v_id_0000,'-','-','2008/04/01 00:00:00',85899345920,'Blanc Image 
Template',false where not exists (select it_guid from image_templates where 
it_guid = v_id_0000);
-insert into vm_templates 
(vmt_guid,name,mem_size_mb,os,creation_date,child_count,num_of_sockets,cpu_per_socket,description,vds_group_id,domain,num_of_monitors,status)
 select v_id_0000,'Blank' ,512,0,'2008/04/01 00:00:00',0,1,1,'Blank 
template',v_cluster_id,'',1,0 where not exists (select vmt_guid from 
vm_templates where vmt_guid = v_id_0000);
+insert into vm_templates 
(vmt_guid,name,mem_size_mb,os,creation_date,child_count,num_of_sockets,cpu_per_socket,description,vds_group_id,domain,num_of_monitors,status,default_display_type)
 select v_id_0000,'Blank' ,512,0,'2008/04/01 00:00:00',0,1,1,'Blank 
template',v_cluster_id,'',1,0,1 where not exists (select vmt_guid from 
vm_templates where vmt_guid = v_id_0000);
 insert into vm_template_image_map (it_guid,vmt_guid,internal_drive_mapping) 
select v_id_0000,v_id_0000,'1' where not exists (select * from 
vm_template_image_map where it_guid = v_id_0000  and vmt_guid = v_id_0000);
 
 delete from event_map;
diff --git 
a/backend/manager/dbscripts/upgrade/03_00_0280_change_blank_template_default_display_type_to_spice.sql
 
b/backend/manager/dbscripts/upgrade/03_00_0280_change_blank_template_default_display_type_to_spice.sql
deleted file mode 100644
index 8b27c8b..0000000
--- 
a/backend/manager/dbscripts/upgrade/03_00_0280_change_blank_template_default_display_type_to_spice.sql
+++ /dev/null
@@ -1 +0,0 @@
-update vm_templates set default_display_type=1 where 
vmt_guid='00000000-0000-0000-0000-000000000000';


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

Gerrit-MessageType: newchange
Gerrit-Change-Id: Iecdfc85d03e10f668ddd515b50244b0f1f6b95ec
Gerrit-PatchSet: 1
Gerrit-Project: ovirt-engine
Gerrit-Branch: master
Gerrit-Owner: Eli Mesika <emes...@redhat.com>
_______________________________________________
Engine-patches mailing list
Engine-patches@ovirt.org
http://lists.ovirt.org/mailman/listinfo/engine-patches

Reply via email to