I'm trying to convert my local db file into sql and found a few issues with what's posted on the wiki.
These are the values that I had to use to match properly
Code:
INSERT INTO `episode_watched` VALUES \((\d+),(\d+),(\d+),(\d+),(\d+),(\d+)\)
INSERT IGNORE INTO `episode_watched` VALUES \((\1),(\2),(\3),(\4),FROM_UNIXTIME\((\5)\),FROM_UNIXTIME\((\6)\)\)
INSERT INTO `movie_watched` VALUES \((\d+),(\d+),(\d+),(\d+),
INSERT IGNORE INTO `movie_watched` VALUES \((\1),(\2),FROM_UNIXTIME\((\3)\),FROM_UNIXTIME\((\4)\),
The difference being the addition of the "`" on either side of episode_watched & movie_watched and a space after the word "VALUES ".
Is that normal or has something changes in the way that sqlbrowser exports the files?
A sample of the output looks like the following:
Code:
INSERT IGNORE INTO `movie_watched` VALUES (32138,1,FROM_UNIXTIME(1485035489),FROM_UNIXTIME(1449111876),'The Wizard of Oz (1939)');
INSERT IGNORE INTO `episode_watched` VALUES (254203,0,3,1,FROM_UNIXTIME(1485035489),FROM_UNIXTIME(1410498000));
Are those correct?