Arik Hadas has posted comments on this change.

Change subject: engine: add cpu profile to vm flow
......................................................................


Patch Set 2: Code-Review+2

(2 comments)

http://gerrit.ovirt.org/#/c/31628/2/packaging/dbscripts/upgrade/03_06_0260_add_cpu_profile_id_to_vm_static.sql
File packaging/dbscripts/upgrade/03_06_0260_add_cpu_profile_id_to_vm_static.sql:

Line 1: -- add cpu profile id filed to vm_static
s\filed\field
Line 2: SELECT fn_db_add_column('vm_static', 'cpu_profile_id', 'UUID NULL');
Line 3: 
Line 4: -- Create index for cpu profile
Line 5: DROP INDEX IF EXISTS IDX_vm_static_cpu_profile_id;


Line 4: -- Create index for cpu profile
Line 5: DROP INDEX IF EXISTS IDX_vm_static_cpu_profile_id;
Line 6: CREATE INDEX IDX_vm_static_cpu_profile_id ON vm_static(cpu_profile_id);
Line 7: 
Line 8: -- Add FK an handle cascade
an -> and ?
Line 9: ALTER TABLE vm_static ADD CONSTRAINT FK_vm_static_cpu_profile_id 
FOREIGN KEY(cpu_profile_id)
Line 10: REFERENCES cpu_profiles(id) MATCH SIMPLE ON UPDATE NO ACTION ON DELETE 
SET NULL;
Line 11: 
Line 12: --- Create cpu profile for every cluster greater than 3.5


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

Gerrit-MessageType: comment
Gerrit-Change-Id: Ib01e4ab9e6d471d56fb972c8a4ee3e8dd8616db7
Gerrit-PatchSet: 2
Gerrit-Project: ovirt-engine
Gerrit-Branch: master
Gerrit-Owner: Gilad Chaplik <gchap...@redhat.com>
Gerrit-Reviewer: Arik Hadas <aha...@redhat.com>
Gerrit-Reviewer: Gilad Chaplik <gchap...@redhat.com>
Gerrit-Reviewer: automat...@ovirt.org
Gerrit-Reviewer: oVirt Jenkins CI Server
Gerrit-HasComments: Yes
_______________________________________________
Engine-patches mailing list
Engine-patches@ovirt.org
http://lists.ovirt.org/mailman/listinfo/engine-patches

Reply via email to