Skip to content

Instantly share code, notes, and snippets.

@naz
naz / restore_script.sql
Created October 8, 2018 11:40
Ghost post restoration script (MySQL version)
-- show available versions for a post
SELECT `mr`.`id` 'version id', `p`.`id` 'post id', `p`.`title`, `mr`.`mobiledoc`
FROM `posts` `p`
JOIN `mobiledoc_revisions` `mr`
ON `p`.`id` = `mr`.`post_id`
WHERE `p`.`id` = '$POST_ID' \G
-- restore specific versions of the post
UPDATE `posts` `p`
JOIN `mobiledoc_revisions` `mr`
@naz
naz / changelog-2.1.2.md
Created September 11, 2018 14:04
Changelog 2.1.2
@naz
naz / changelog-2.1.1.md
Created September 6, 2018 11:46
Changelog 2.1.1
### Keybase proof
I hereby claim:
* I am gargol on github.
* I am gargol (https://keybase.io/gargol) on keybase.
* I have a public key whose fingerprint is A960 3CC4 7FA3 42A8 3B14 9664 E510 5675 04C1 465F
To claim this, I am signing this object: