summaryrefslogtreecommitdiff
path: root/ChangeLog
diff options
context:
space:
mode:
Diffstat (limited to 'ChangeLog')
-rw-r--r--ChangeLog8
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+';