From dd0cece91f3b5b083ea910650d7b40d44d887921 Mon Sep 17 00:00:00 2001 From: Matthias Andreas Benkard Date: Sun, 27 May 2018 08:46:29 +0200 Subject: Add support for explicit journal keeping in the database. --- ChangeLog | 8 ++++++++ 1 file changed, 8 insertions(+) create mode 100644 ChangeLog (limited to 'ChangeLog') 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 + + * 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+'; -- cgit v1.2.3