[mythtv-users] deleted some tables... help!
Jason Lee
mythtv at theleehouse.net
Tue Apr 13 14:39:47 EDT 2004
Volker Wieban wrote:
> hi!
>
> i'm using mythtv 0.14 on a gentoo linux system. two days ago i accidently deleted the "musicmetadata" and "videometadata" tables in the mythconverg-database. i tried reemerging (installing) mythvideo and mythmusic but the tables are still gone. now mythvideo doesn't find any videos in the video manager. what can i do to get the tables back?
>
> i could add them manually but i don't know the field names and types.
> any help is appreciated....
> thanks in advance!
You should be able to build the DDL from these:
mysql> desc videometadata;
+-------------+------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra
+-------------+------------------+------+-----+---------+----------------+
| intid | int(10) unsigned | | PRI | NULL | auto_increment
| title | varchar(128) | | MUL | |
| director | varchar(128) | | MUL | |
| plot | text | YES | | NULL |
| rating | varchar(128) | | | |
| inetref | varchar(32) | | | |
| year | int(10) unsigned | | | 0 |
| userrating | float | | | 0 |
| length | int(10) unsigned | | | 0 |
| showlevel | int(10) unsigned | | | 0 |
| filename | text | | |
| | coverfile | text | | |
| | childid | int(11) | | | -1
| | browse | tinyint(1) | | | 1
| | playcommand | varchar(255) | YES | |
NULL | | category | int(10) unsigned | | |
0 |
+-------------+------------------+------+-----+---------+----------------+
mysql> desc musicmetadata;
+-----------+------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-----------+------------------+------+-----+---------+----------------+
| intid | int(10) unsigned | | PRI | NULL | auto_increment |
| artist | varchar(128) | | MUL | | |
| album | varchar(128) | | MUL | | |
| title | varchar(128) | | MUL | | |
| genre | varchar(128) | | MUL | | |
| year | int(10) unsigned | | | 0 | |
| tracknum | int(10) unsigned | | | 0 | |
| length | int(10) unsigned | | | 0 | |
| filename | text | | | | |
| rating | int(10) unsigned | | | 5 | |
| lastplay | timestamp(14) | YES | | NULL | |
| playcount | int(10) unsigned | | | 0 | |
+-----------+------------------+------+-----+---------+----------------+
--
jason lee
Steeplesoft -- http://www.steeplesoft.com
README.txt -- http://jason.theleehouse.net
Bosco -- http://bosco.sourceforge.net
More information about the mythtv-users
mailing list