PLAT-6369 - Added database changes required to add snapshot type

Addressed review comments