CREATE TABLE mp3 (
    mtime,
    
    FILENAME,
    
    TITLE,
    ARTIST,
    ALBUM,
    YEAR,
    COMMENT,
    GENRE,
    TRACKNUM,
    
    VERSION,         -- MPEG audio version (1, 2, 2.5)
    LAYER,           -- MPEG layer description (1, 2, 3)
    STEREO,          -- boolean for audio is in stereo

    VBR,             -- boolean for variable bitrate
    BITRATE,         -- bitrate in kbps (average for VBR files)
    FREQUENCY,       -- frequency in kHz
    SIZE,            -- bytes in audio stream
    OFFSET,          -- bytes offset that stream begins

    SECS,            -- total seconds
    MM,              -- minutes
    SS,              -- leftover seconds
    MS,              -- leftover milliseconds
    TIME,            -- time in MM:SS

    COPYRIGHT,       -- boolean for audio is copyrighted
    PADDING,         -- boolean for MP3 frames are padded
    MODE,            -- channel mode (0 = stereo, 1 = joint stereo,
                     -- 2 = dual channel, 3 = single channel)
    FRAMES,          -- approximate number of frames
    FRAME_LENGTH,    -- approximate length of a frame
    VBR_SCALE        -- VBR scale from VBR header
);