Postgresql tables

I use postgresql and spent some time manually creating the tables for this module tonight. Here are the tables I came up with. They'll need to be drupalized.

CREATE TABLE audio (
    vid integer NOT NULL default '0'
        CHECK (vid >= 0),
    nid integer NOT NULL default '0'
        CHECK (nid >= 0),
    title_format varchar(128) default '',
    play_count integer NOT NULL default '0'
        CHECK (play_count >= 0),
    download_count integer NOT NULL default '0'
        CHECK (download_count >= 0),
    downloadable smallint NOT NULL default '1',
    fileformat varchar(10) NOT NULL default '',
    sample_rate integer NOT NULL default '0'
        CHECK (sample_rate >= 0),
    channel_mode varchar(10) NOT NULL default '',
    bitrate float NOT NULL default '0'
        CHECK (bitrate >= 0),
    bitrate_mode varchar(4) NOT NULL default '',
    playtime varchar(10) NOT NULL default '',
    PRIMARY KEY  (vid)
);

CREATE TABLE  audio_file (
    vid integer NOT NULL default '0'
        CHECK (vid >= 0),
    origname varchar(255) NOT NULL default '',
    filename varchar(255) NOT NULL default '',
    filepath varchar(255) NOT NULL default '',
    filemime varchar(255) NOT NULL default '',
    filesize integer NOT NULL default '0'
        CHECK (filesize >= 0),
    PRIMARY KEY  (vid)
);

CREATE TABLE  audio_metadata (
    vid integer NOT NULL default '0'
        CHECK (vid >= 0),
    tag varchar(45) NOT NULL default '',
    value varchar(255) NOT NULL default '',
    clean varchar(255) NOT NULL default '',
    PRIMARY KEY  (vid, tag, value),
    CONSTRAINT audio_metadata_tags UNIQUE (clean)
);