cms icon indicating copy to clipboard operation
cms copied to clipboard

Add a "opaque_id" column to submissions.

Open veluca93 opened this issue 8 months ago • 0 comments

This gives a stable ID that can be used to refer to a specific submission.

Quick SQL snippet to update an existing database:

begin;
alter table submissions add column opaque_id BIGINT UNIQUE;
update submissions set opaque_id = id where opaque_id IS NULL;
alter table submissions alter column opaque_id SET NOT NULL;
commit;

veluca93 avatar Jun 18 '25 23:06 veluca93