Android icon indicating copy to clipboard operation
Android copied to clipboard

Migrate groups to proper unique id

Open Altonss opened this issue 1 year ago • 2 comments

The following points a required for a migration to unique ids for groups:

  • [x] Edit the LoyaltyCardDbGroups table to contain a new ID column that's an integer.
  • [x] Edit the LoyaltyCardDbIdsGroups table to refer to the group ID instead of group name.
  • [x] Migrate all current memberships to the new setup.

@TheLastProject thinks, the easiest way is to just create 2 temporary tables and then create the new stuff like it has been done at newVersion 10 in the DBHelper class.

Originally posted by @TheLastProject in https://github.com/CatimaLoyalty/Android/issues/669#issuecomment-1256443883

These steps are needed, because the current situation is blocking for a good implementation of #669 for example.

Altonss avatar Sep 23 '22 17:09 Altonss