< Notes...

expecting no expectators, these are my short thoughts.

So that I can remember to create a Gist with this later. Useful if you run GoToSocial, have moved to it from another service, and want to keep your initial Fediverse or ActivityPub “joined date”.

# Find the user ID.
select id, created_at from accounts where username = 'username_goes_here'

# Use newly found user ID to update the "created_at" field.
update accounts set created_at = '2016-10-04 21:27:33+00:00' where id = 'user_id_goes_here';