|
It's difficult to replicate it for others, you don't know what changes they have made between databases. Basically the problem was that both tables, the one with the shelves and the one associating books with shelves where empty, so I just took the rows from shelves table from my backup, completed the information with the new columns and inserted them again in the actual database. Then I took the rows from the ShelvesContent table from my backup and inserted them in the table of the actual database, I don't delete books, so I didn't had to check anything more, and I work with databases in my day job, so it wasn't too difficult, I just had to Google how sqllite treats date and boolean columns 😊
|