Shahar Havivi has posted comments on this change. Change subject: DB: Vm Init - new Feature ......................................................................
Patch Set 18: (2 comments) http://gerrit.ovirt.org/#/c/23022/18/packaging/dbscripts/upgrade/03_04_0490_add_vm_init_table.sql File packaging/dbscripts/upgrade/03_04_0490_add_vm_init_table.sql: Line 36: -- Name: vm_static_vm_init; Type: FK CONSTRAINT; Schema: public; Owner: engine Line 37: -- Line 38: ALTER TABLE ONLY vm_init Line 39: ADD CONSTRAINT vm_static_vm_init FOREIGN KEY (vm_id) REFERENCES vm_static(vm_guid) ON DELETE CASCADE; Line 40: ALTER TABLE ONLY vm_init > TWS Done Line 41: ADD CONSTRAINT pk_vm_init PRIMARY KEY (vm_id); Line 37: -- Line 38: ALTER TABLE ONLY vm_init Line 39: ADD CONSTRAINT vm_static_vm_init FOREIGN KEY (vm_id) REFERENCES vm_static(vm_guid) ON DELETE CASCADE; Line 40: ALTER TABLE ONLY vm_init Line 41: ADD CONSTRAINT pk_vm_init PRIMARY KEY (vm_id); > Better approach of the 2 ALTER statements above is to add them to the CREAT Thank you Eli -- To view, visit http://gerrit.ovirt.org/23022 To unsubscribe, visit http://gerrit.ovirt.org/settings Gerrit-MessageType: comment Gerrit-Change-Id: If6230e0543712cc8a8efd48ba45406ea43d0f778 Gerrit-PatchSet: 18 Gerrit-Project: ovirt-engine Gerrit-Branch: master Gerrit-Owner: Shahar Havivi <[email protected]> Gerrit-Reviewer: Arik Hadas <[email protected]> Gerrit-Reviewer: Eli Mesika <[email protected]> Gerrit-Reviewer: Eli Mesika <[email protected]> Gerrit-Reviewer: Gilad Chaplik <[email protected]> Gerrit-Reviewer: Michal Skrivanek <[email protected]> Gerrit-Reviewer: Omer Frenkel <[email protected]> Gerrit-Reviewer: Roy Golan <[email protected]> Gerrit-Reviewer: Shahar Havivi <[email protected]> Gerrit-Reviewer: Tomas Jelinek <[email protected]> Gerrit-Reviewer: oVirt Jenkins CI Server Gerrit-HasComments: Yes _______________________________________________ Engine-patches mailing list [email protected] http://lists.ovirt.org/mailman/listinfo/engine-patches
