- 0: modify procedure to check current status (pending, received, rejected, expired, invalidated)
- 0.1: modify procedure to check 30 days expiration date
- 1: add rowversion column to ew_consent
- 1.1: use rowversion column as Checksum! sys.fn_varbintohexstr()
- 2: add rowversion to ew_pending_consent
- 3: use procedure to a) create consent if needed b) create pending consent, using timestamp value from a)
- 4: create procedure to check ew_pending_consent for outdated (30 days) or invalid (rowversion) entries
- 5: create job for regular checks