[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