https://bugs.winehq.org/show_bug.cgi?id=31784
--- Comment #4 from François Gouget fgouget@codeweavers.com --- Created attachment 52529 --> https://bugs.winehq.org/attachment.cgi?id=52529 Modified database schema to handle snapshots and more
The attached schema would make it possible to have multiple configurations (snapshots) per VM. * The VMs table entries would only describe the generic properties of a VM. * The VMConfigs table would describe the specific properties of a given VM configuration. * A given VM could have multiple VMConfig entries. For instance the win7u VM could have both ja and ko VMConfigs corresponding to Japanese and Korean locales for instance. * When submitting a job, instead of picking VMs the user would pick VMConfigs which he may see as win7u+ja, win7u+ko, etc. * The VMInstances table is for dealing with failover and load balancing. * In this context what counts is that all instances of a given VM must have the same set of VM configurations, i.e. the same set of snapshots. * When a VM instance is in use, its VMSnapshot field would be set to point to its current configuration (i.e. reference the corresponding VMConfig entry).