zumindest hier wurde das feld "scrsp" schon angelegt - ohne manuelles eingreifen.
die datenbank wurde mit aktuellem git neu aufgebaut
SQL
mysql> SHOW COLUMNS IN recordings IN epg2vdr;
+----------------------+------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------------------+------------------+------+-----+---------+-------+
| uuid | varchar(40) | NO | PRI | | |
| rec_path | varchar(200) | NO | PRI | | |
| rec_start | int(11) unsigned | NO | PRI | 0 | |
| event_id | int(11) unsigned | YES | | NULL | |
| channel_id | varchar(50) | YES | | NULL | |
| scrapinfo_movie_id | int(11) unsigned | YES | | NULL | |
| scrapinfo_series_id | int(11) unsigned | YES | | NULL | |
| scrapinfo_episode_id | int(11) unsigned | YES | | NULL | |
| scrap_new | int(11) unsigned | YES | MUL | NULL | |
| scrsp | int(11) | YES | | NULL | |
| rec_title | varchar(200) | YES | | NULL | |
| rec_subtitle | varchar(500) | YES | | NULL | |
| rec_duration | int(11) unsigned | YES | | NULL | |
| movie_id | int(11) unsigned | YES | | NULL | |
| series_id | int(11) unsigned | YES | | NULL | |
| episode_id | int(11) unsigned | YES | | NULL | |
+----------------------+------------------+------+-----+---------+-------+
16 rows in set (0.00 sec)
Alles anzeigen