CREATE TABLE podcast_entry ( path varchar(132) NOT NULL default '', title varchar(132) NOT NULL default '', artist varchar(132) NOT NULL default '', album varchar(132) default NULL, description text, filesize int(10) unsigned NOT NULL default '0', format enum('mp3','wav','aiff') NOT NULL default 'mp3', medium enum('audio','video') NOT NULL default 'audio', id int(10) unsigned NOT NULL auto_increment, filename varchar(64) NOT NULL default '', create_time datetime NOT NULL, update_time datetime NOT NULL, release datetime NOT NULL, PRIMARY KEY (id), KEY title (title,artist,album) ) TYPE=MyISAM COMMENT='table for yeproc podcast; extensible for video casting.';