< Notes...

"The work is mysterious and important."

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_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_here';
« Prev Next »