diff options
| author | Matthias Andreas Benkard <code@mail.matthias.benkard.de> | 2018-05-27 08:46:29 +0200 |
|---|---|---|
| committer | Matthias Andreas Benkard <code@mail.matthias.benkard.de> | 2018-05-27 09:20:24 +0200 |
| commit | dd0cece91f3b5b083ea910650d7b40d44d887921 (patch) | |
| tree | 5173058c62aa2dc4658636fdac6eebb726468708 /ChangeLog | |
| parent | 567f3ebbe6f60a872a57489516855b113315e341 (diff) | |
Add support for explicit journal keeping in the database.
Diffstat (limited to 'ChangeLog')
| -rw-r--r-- | ChangeLog | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/ChangeLog b/ChangeLog new file mode 100644 index 0000000..cf96ced --- /dev/null +++ b/ChangeLog @@ -0,0 +1,8 @@ +2018-05-27 Matthias Benkard <usenet@mail.matthias.benkard.de> + + * Journal entries are now kept in a separate table. To move + existing journal entries over to the new schema, use the following + queries: + + INSERT INTO journals VALUES (0, 'journal'); + INSERT INTO journal_entries(journal, index, article) SELECT 0, trim(LEADING 'journal/%' FROM alias)::integer, article FROM article_aliases WHERE alias ~ 'journal/\d+'; |