Re: [ovirt-devel] [DB] Diffrent UUIDs for inserted data per installation
----- Original Message -----
Hi
I am trying to cleanup all the data insertion to the engine DB and make it
more general
The main drive to that is DB version squashing that was done manually and
therefor was error prone ...
I know that both storage_pool_id (a.k.a DC) and vds_group_id (a.k.a Cluster)
needs to get a different UUID per installation.
But I had found that UUIDs are generated per installation for also :
table | column/s
------------------------------------
[cpu_profiles] : id
[gluster_services] : id
[mac_pools] : id
[permissions] : id, object_id
They are generated for instance-types.
id doesn't have to be different per installation
object_id doesn't have to be different either since it points to id of default
instance-type that can be static
[vm_device]: device_id, vm_id
device_id - generated when adding virtio-serial
devices. It doesn't have to be different per installation
I didn't find where vm_id is generated..
[vm_static] : vm_guid
Generated when inserting default instance-types. It
doesn't have to be different per installation
[vnic_profiles] : id
Please let me know if any of the above should be generated using the
uuid_generate_v1() function on each installation or we can have static IDs
for those.
Thanks
Eli Mesika