AudioFerret/v1/sql/Title

SQL

<mysql>CREATE TABLE `Title` (

 `id` int(11) NOT NULL auto_increment,
 `album_id` int(11) default NULL,
 `track` varchar(50) default NULL,
 `artist_id` varchar(50) default NULL,
 `name` varchar(255) default NULL,
 `id_file` int(11) default NULL,
 `isUnavail` bool default FALSE COMMENT "TRUE = don't show this title as needing a file assigned",
 `WhenAdded` DATETIME  DEFAULT NULL COMMENT 'when the track was added to the database',
 `WhenChanged` DATETIME  DEFAULT NULL COMMENT 'when the track record was last modified',
 PRIMARY KEY  (`id`),
 KEY `titles_index1` (`id`),
 KEY `titles_index2` (`id_file`)

) ENGINE=MyISAM;</mysql>