How to convert database from 1.0 to 1.1 manually

Idea by Guillaume Bour

So I have directly done it in SQL (mysql). Here is the procedure (could be useful for other people):

• first renaming old tables ttrss_entries and ttrss_feeds in ttrss_entries_old and ttrss_feeds_old BEFORE migrating

    sql> rename table `ttrss_entries` to `ttrss_entries_old`;
    sql> rename table `ttrss_feeds` to `ttrss_feeds_old`;

• exporting rss feeds in OPML format *
• importing new version tables structure & new ttrss version *
• reloading rss feeds in OPML format *

• transfering feeds entries

      sql> insert into `ttrss_entries` (title, guid, link, updated,
      content, content_hash, no_orig_date, date_entered, num_comments,
      comments) select title, guid, link, updated, content, content_hash,
      no_orig_date, date_entered, 0, comments from `ttrss_entries_old`;
  
      sql> insert into `ttrss_user_entries` (ref_id, feed_id, owner_uid,
      marked, last_read, unread) select e.id, f.id, 1, oe.marked,
      oe.last_read, oe.unread from `ttrss_entries_old` as oe,
      `ttrss_feeds_old` as of, `ttrss_feeds` as f, `ttrss_entries` as e
      where oe.feed_id = of.id and of.feed_url = f.feed_url and oe.guid =
      e.guidtt;