--=_3a2650e5-0f37-4517-8bfb-2025d36037dc Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit Hi, I would like to introduce a change to two tables in oVirt-engine-core. The VM and VM-template share most of their configuration. I am looking to unify the two tables into one table. Currently, if such a change would be made in the DB layer, it would be abstracted by the DAL so no code beyond that layer should be affected, and code changes to that layer should be minimal (since we use views and stored procedures to abstract the DB structure anyway). The major change would be at the DB layer, which will mostly require data migration and changing of the STPs. If anyone has PostgresSQL knowledge and would like to pitch in and help me push this change it would be great. I have more technical details if anyone is interested. Attached is the diff between both tables (vm_static and vm_templates). Regards, Mike --=_3a2650e5-0f37-4517-8bfb-2025d36037dc Content-Type: text/x-patch; name=vm.template.tables.diff Content-Disposition: attachment; filename=vm.template.tables.diff Content-Transfer-Encoding: base64 Miw0YzIsNQo8IGNoaWxkX2NvdW50IGludGVnZXIgTk9UIE5VTEwgREVGQVVMVCAwLAo8IENPTlNU UkFJTlQgcGtfdm1fdGVtcGxhdGVzIFBSSU1BUlkgS0VZICh2bXRfZ3VpZCksCjwgQ09OU1RSQUlO VCB2ZHNfZ3JvdXBzX3ZtX3RlbXBsYXRlcyBGT1JFSUdOIEtFWSAodmRzX2dyb3VwX2lkKSBSRUZF UkVOQ0VTIHZkc19ncm91cHMgKHZkc19ncm91cF9pZCkgTUFUQ0ggU0lNUExFIE9OIFVQREFURSBO TyBBQ1RJT04gT04gREVMRVRFIE5PIEFDVElPTgotLS0KPiBDT05TVFJBSU5UIGZrX3Zkc19zdGF0 aWNfdm1fc3RhdGljIEZPUkVJR04gS0VZIChkZWRpY2F0ZWRfdm1fZm9yX3ZkcykgUkVGRVJFTkNF UyB2ZHNfc3RhdGljICh2ZHNfaWQpIE1BVENIIFNJTVBMRSBPTiBVUERBVEUgTk8gQUNUSU9OIE9O IERFTEVURSBOTyBBQ1RJT04sCj4gQ09OU1RSQUlOVCBwa192bV9zdGF0aWMgUFJJTUFSWSBLRVkg KHZtX2d1aWQpLAo+IENPTlNUUkFJTlQgdmRzX2dyb3Vwc192bV9zdGF0aWMgRk9SRUlHTiBLRVkg KHZkc19ncm91cF9pZCkgUkVGRVJFTkNFUyB2ZHNfZ3JvdXBzICh2ZHNfZ3JvdXBfaWQpIE1BVENI IFNJTVBMRSBPTiBVUERBVEUgTk8gQUNUSU9OIE9OIERFTEVURSBOTyBBQ1RJT04sCj4gQ09OU1RS QUlOVCB2bV90ZW1wbGF0ZXNfdm1fc3RhdGljIEZPUkVJR04gS0VZICh2bXRfZ3VpZCkgUkVGRVJF TkNFUyB2bV90ZW1wbGF0ZXMgKHZtdF9ndWlkKSBNQVRDSCBTSU1QTEUgT04gVVBEQVRFIE5PIEFD VElPTiBPTiBERUxFVEUgTk8gQUNUSU9OCjZjNyw5CjwgY3JlYXRpb25fZGF0ZSB0aW1lc3RhbXAg d2l0aCB0aW1lIHpvbmUgTk9UIE5VTEwsCi0tLQo+IF9jcmVhdGVfZGF0ZSB0aW1lc3RhbXAgd2l0 aCB0aW1lIHpvbmUgREVGQVVMVCAoJ25vdyc6OnRleHQpOjp0aW1lc3RhbXAgd2l0aG91dCB0aW1l IHpvbmUsCj4gY3JlYXRpb25fZGF0ZSB0aW1lc3RhbXAgd2l0aCB0aW1lIHpvbmUsCj4gZGVkaWNh dGVkX3ZtX2Zvcl92ZHMgdXVpZCwKMTRhMTgKPiBpc19pbml0aWFsaXplZCBib29sZWFuLAoyMGMy NCwyNQo8ICJuYW1lIiBjaGFyYWN0ZXIgdmFyeWluZyg0MCkgTk9UIE5VTEwsCi0tLQo+IG1pZ3Jh dGlvbl9zdXBwb3J0IGludGVnZXIgTk9UIE5VTEwgREVGQVVMVCAwLAo+IG1pbl9hbGxvY2F0ZWRf bWVtIGludGVnZXIgTk9UIE5VTEwgREVGQVVMVCAwLAoyNmEzMgo+IHByZWRlZmluZWRfcHJvcGVy dGllcyBjaGFyYWN0ZXIgdmFyeWluZyg0MDAwKSwKMjhkMzMKPCBzdGF0dXMgaW50ZWdlciBOT1Qg TlVMTCwKMzBjMzUKPCBfdXBkYXRlX2RhdGUgdGltZXN0YW1wIHdpdGggdGltZSB6b25lIERFRkFV TFQgbm93KCksCi0tLQo+IF91cGRhdGVfZGF0ZSB0aW1lc3RhbXAgd2l0aCB0aW1lIHpvbmUsCjMx YTM3Cj4gdXNlcmRlZmluZWRfcHJvcGVydGllcyBjaGFyYWN0ZXIgdmFyeWluZyg0MDAwKSwKMzJh MzksNDAKPiB2bV9ndWlkIHV1aWQgTk9UIE5VTEwsCj4gdm1fbmFtZSBjaGFyYWN0ZXIgdmFyeWlu ZygyNTUpIE5PVCBOVUxMLAo= --=_3a2650e5-0f37-4517-8bfb-2025d36037dc--