mysql> desc ppp.ppp_data ; +-----------------+--------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-----------------+--------------+------+-----+---------+----------------+ | id | int(11) | NO | PRI | NULL | auto_increment | | medien | varchar(12) | NO | | NULL | | | format | char(4) | NO | | NULL | | | link | varchar(255) | NO | | NULL | | | autor | varchar(35) | NO | | NULL | | | ort | varchar(25) | NO | | NULL | | | zeit | date | NO | | NULL | | | xtras | varchar(255) | NO | | NULL | | | objekttyp | varchar(25) | NO | | NULL | | | seitenzahl | int(11) | NO | | NULL | | | spieldauer | int(11) | NO | UNI | NULL | | | aufloesung | varchar(12) | NO | | NULL | | | originalgroesse | varchar(255) | NO | | NULL | | +-----------------+--------------+------+-----+---------+----------------+ 13 rows in set (0.00 sec)