blob: cf96ced29a251c85315af0ca01686afa78363df9 (
plain)
1
2
3
4
5
6
7
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+';
|