SQL-Kommando für Tabelle 'album'

CREATE TABLE `album` (

`cddbid` char(15) NOT NULL default '',

`artist` char(50) NOT NULL default '',

`title` char(50) NOT NULL default '',

`genre` char(100) default NULL,

`tracks` char(50) default NULL,

PRIMARY KEY (`cddbid`),

UNIQUE KEY `id` (`cddbid`)

) TYPE=MyISAM COMMENT='General Album Information';