'Add path to result cache'

def upgrade_version_3(self):

    self.conn.executescript('\n                                DROP    VIEW    meta;\n                                CREATE    VIEW    meta    AS\n                                SELECT    id,    title,\n                                                            (SELECT    concat(name)    FROM    authors    WHERE    authors.id    IN    (SELECT    author    from    books_authors_link    WHERE    book=books.id))    authors,\n                                                            (SELECT    name    FROM    publishers    WHERE    publishers.id    IN    (SELECT    publisher    from    books_publishers_link    WHERE    book=books.id))    publisher,\n                                                            (SELECT    rating    FROM    ratings    WHERE    ratings.id    IN    (SELECT    rating    from    books_ratings_link    WHERE    book=books.id))    rating,\n                                                            timestamp,\n                                                            (SELECT    MAX(uncompressed_size)    FROM    data    WHERE    book=books.id)    size,\n                                                            (SELECT    concat(name)    FROM    tags    WHERE    tags.id    IN    (SELECT    tag    from    books_tags_link    WHERE    book=books.id))    tags,\n                                                            (SELECT    text    FROM    comments    WHERE    book=books.id)    comments,\n                                                            (SELECT    name    FROM    series    WHERE    series.id    IN    (SELECT    series    FROM    books_series_link    WHERE    book=books.id))    series,\n                                                            series_index,\n                                                            sort,\n                                                            author_sort,\n                                                            (SELECT    concat(format)    FROM    data    WHERE    data.book=books.id)    formats,\n                                                            isbn,\n                                                            path\n                                FROM    books;\n                                ')
