| 37 |
|
path_to_video TEXT, |
| 38 |
|
user_notes TEXT, |
| 39 |
|
container_md5_hash TEXT, |
| 40 |
< |
version TEXT |
| 40 |
> |
version TEXT, |
| 41 |
> |
favorite_game INTEGER, |
| 42 |
> |
release_date TEXT, |
| 43 |
> |
release_date_scraped TEXT, |
| 44 |
> |
game_genre TEXT, |
| 45 |
> |
game_genre_scraped TEXT, |
| 46 |
> |
cooperative TEXT, |
| 47 |
> |
cooperative_scraped TEXT, |
| 48 |
> |
max_players TEXT, |
| 49 |
> |
max_players_scraped TEXT |
| 50 |
|
) |
| 51 |
|
""", |
| 52 |
|
"no_intro_system": """ |
| 143 |
|
"description_scraped", "system_console", "system_console_scraped", |
| 144 |
|
"path_to_screenshot_box", "path_to_screenshot_title", |
| 145 |
|
"path_to_screenshot_ingame", "path_to_video", "user_notes", |
| 146 |
< |
"container_md5_hash", "version", |
| 146 |
> |
"container_md5_hash", "version", "favorite_game", "release_date", |
| 147 |
> |
"release_date_scraped", "game_genre", "game_genre_scraped", |
| 148 |
> |
"cooperative", "cooperative_scraped", "max_players", "max_players_scraped", |
| 149 |
|
], |
| 150 |
|
) |
| 151 |
|
self._ensure_columns(cursor, "main_app_system", ["name", "short_name", "relative_file_path"]) |