from peewee import *

database = MySQLDatabase('MyMusic32', **{'passwd': 'xbmc', 'host': 'nas', 'user': 'xbmc'})

class UnknownFieldType(object):
    pass

class BaseModel(Model):
    class Meta:
        database = database

class Album(BaseModel):
    bcompilation = IntegerField(db_column='bCompilation')
    iyear = IntegerField(db_column='iYear', null=True)
    idalbum = PrimaryKeyField(db_column='idAlbum')
    idthumb = IntegerField(db_column='idThumb', null=True)
    stralbum = CharField(db_column='strAlbum', null=True, max_length=256)
    strartists = TextField(db_column='strArtists', null=True)
    strgenres = TextField(db_column='strGenres', null=True)

    class Meta:
        db_table = 'album'

class Album_Artist(BaseModel):
    boolfeatured = IntegerField(db_column='boolFeatured', null=True)
    iorder = IntegerField(db_column='iOrder', null=True)
    idalbum = IntegerField(db_column='idAlbum', null=True)
    idartist = IntegerField(db_column='idArtist', null=True)

    class Meta:
        db_table = 'album_artist'

class Album_Genre(BaseModel):
    iorder = IntegerField(db_column='iOrder', null=True)
    idalbum = IntegerField(db_column='idAlbum', null=True)
    idgenre = IntegerField(db_column='idGenre', null=True)

    class Meta:
        db_table = 'album_genre'

class Albuminfo(BaseModel):
    irating = IntegerField(db_column='iRating', null=True)
    iyear = IntegerField(db_column='iYear', null=True)
    idalbum = IntegerField(db_column='idAlbum', null=True)
    idalbuminfo = PrimaryKeyField(db_column='idAlbumInfo')
    strimage = TextField(db_column='strImage', null=True)
    strlabel = TextField(db_column='strLabel', null=True)
    strmoods = TextField(db_column='strMoods', null=True)
    strreview = TextField(db_column='strReview', null=True)
    strstyles = TextField(db_column='strStyles', null=True)
    strthemes = TextField(db_column='strThemes', null=True)
    strtype = TextField(db_column='strType', null=True)

    class Meta:
        db_table = 'albuminfo'

class Albuminfosong(BaseModel):
    iduration = IntegerField(db_column='iDuration', null=True)
    itrack = IntegerField(db_column='iTrack', null=True)
    idalbuminfo = IntegerField(db_column='idAlbumInfo', null=True)
    idalbuminfosong = PrimaryKeyField(db_column='idAlbumInfoSong')
    strtitle = TextField(db_column='strTitle', null=True)

    class Meta:
        db_table = 'albuminfosong'

class Albumview(BaseModel):
    bcompilation = IntegerField(db_column='bCompilation')
    irating = IntegerField(db_column='iRating', null=True)
    itimesplayed = IntegerField(db_column='iTimesPlayed', null=True)
    iyear = IntegerField(db_column='iYear', null=True)
    idalbum = IntegerField(db_column='idAlbum')
    idalbuminfo = IntegerField(db_column='idAlbumInfo', null=True)
    stralbum = CharField(db_column='strAlbum', null=True, max_length=256)
    strartists = TextField(db_column='strArtists', null=True)
    strgenres = TextField(db_column='strGenres', null=True)
    strimage = TextField(db_column='strImage', null=True)
    strlabel = TextField(db_column='strLabel', null=True)
    strmoods = TextField(db_column='strMoods', null=True)
    strreview = TextField(db_column='strReview', null=True)
    strstyles = TextField(db_column='strStyles', null=True)
    strthemes = TextField(db_column='strThemes', null=True)
    strtype = TextField(db_column='strType', null=True)

    class Meta:
        db_table = 'albumview'

class Art(BaseModel):
    art = PrimaryKeyField(db_column='art_id')
    media = IntegerField(db_column='media_id', null=True)
    media_type = TextField(null=True)
    type = TextField(null=True)
    url = TextField(null=True)

    class Meta:
        db_table = 'art'

class Artist(BaseModel):
    idartist = PrimaryKeyField(db_column='idArtist')
    strartist = CharField(db_column='strArtist', null=True, max_length=256)

    class Meta:
        db_table = 'artist'

class Artistinfo(BaseModel):
    idartist = IntegerField(db_column='idArtist', null=True)
    idartistinfo = PrimaryKeyField(db_column='idArtistInfo')
    strbiography = TextField(db_column='strBiography', null=True)
    strborn = TextField(db_column='strBorn', null=True)
    strdied = TextField(db_column='strDied', null=True)
    strdisbanded = TextField(db_column='strDisbanded', null=True)
    strfanart = TextField(db_column='strFanart', null=True)
    strformed = TextField(db_column='strFormed', null=True)
    strgenres = TextField(db_column='strGenres', null=True)
    strimage = TextField(db_column='strImage', null=True)
    strinstruments = TextField(db_column='strInstruments', null=True)
    strmoods = TextField(db_column='strMoods', null=True)
    strstyles = TextField(db_column='strStyles', null=True)
    stryearsactive = TextField(db_column='strYearsActive', null=True)

    class Meta:
        db_table = 'artistinfo'

class Artistview(BaseModel):
    idartist = IntegerField(db_column='idArtist')
    strartist = CharField(db_column='strArtist', null=True, max_length=256)
    strbiography = TextField(db_column='strBiography', null=True)
    strborn = TextField(db_column='strBorn', null=True)
    strdied = TextField(db_column='strDied', null=True)
    strdisbanded = TextField(db_column='strDisbanded', null=True)
    strfanart = TextField(db_column='strFanart', null=True)
    strformed = TextField(db_column='strFormed', null=True)
    strgenres = TextField(db_column='strGenres', null=True)
    strimage = TextField(db_column='strImage', null=True)
    strinstruments = TextField(db_column='strInstruments', null=True)
    strmoods = TextField(db_column='strMoods', null=True)
    strstyles = TextField(db_column='strStyles', null=True)
    stryearsactive = TextField(db_column='strYearsActive', null=True)

    class Meta:
        db_table = 'artistview'

class Content(BaseModel):
    strcontent = TextField(db_column='strContent', null=True)
    strpath = TextField(db_column='strPath', null=True)
    strscraperpath = TextField(db_column='strScraperPath', null=True)
    strsettings = TextField(db_column='strSettings', null=True)

    class Meta:
        db_table = 'content'

class Discography(BaseModel):
    idartist = IntegerField(db_column='idArtist', null=True)
    stralbum = TextField(db_column='strAlbum', null=True)
    stryear = TextField(db_column='strYear', null=True)

    class Meta:
        db_table = 'discography'

class Genre(BaseModel):
    idgenre = PrimaryKeyField(db_column='idGenre')
    strgenre = CharField(db_column='strGenre', null=True, max_length=256)

    class Meta:
        db_table = 'genre'

class Karaokedata(BaseModel):
    ikaradelay = IntegerField(db_column='iKaraDelay', null=True)
    ikaranumber = IntegerField(db_column='iKaraNumber', null=True)
    idsong = IntegerField(db_column='idSong', null=True)
    strkaraencoding = TextField(db_column='strKaraEncoding', null=True)
    strkaralyrfilecrc = TextField(db_column='strKaraLyrFileCRC', null=True)
    strkaralyrics = TextField(db_column='strKaralyrics', null=True)

    class Meta:
        db_table = 'karaokedata'

class Path(BaseModel):
    idpath = PrimaryKeyField(db_column='idPath')
    strhash = TextField(db_column='strHash', null=True)
    strpath = CharField(db_column='strPath', null=True, max_length=512)

    class Meta:
        db_table = 'path'

class Song(BaseModel):
    comment = TextField(null=True)
    dwfilenamecrc = TextField(db_column='dwFileNameCRC', null=True)
    iduration = IntegerField(db_column='iDuration', null=True)
    iendoffset = IntegerField(db_column='iEndOffset', null=True)
    istartoffset = IntegerField(db_column='iStartOffset', null=True)
    itimesplayed = IntegerField(db_column='iTimesPlayed', null=True)
    itrack = IntegerField(db_column='iTrack', null=True)
    iyear = IntegerField(db_column='iYear', null=True)
    idalbum = IntegerField(db_column='idAlbum', null=True)
    idpath = IntegerField(db_column='idPath', null=True)
    idsong = PrimaryKeyField(db_column='idSong')
    idthumb = IntegerField(db_column='idThumb', null=True)
    lastplayed = CharField(null=True, max_length=20)
    rating = CharField(null=True, max_length=1)
    strartists = TextField(db_column='strArtists', null=True)
    strfilename = TextField(db_column='strFileName', null=True)
    strgenres = TextField(db_column='strGenres', null=True)
    strmusicbrainzalbumartistid = TextField(db_column='strMusicBrainzAlbumArtistID', null=True)
    strmusicbrainzalbumid = TextField(db_column='strMusicBrainzAlbumID', null=True)
    strmusicbrainzartistid = TextField(db_column='strMusicBrainzArtistID', null=True)
    strmusicbrainztrmid = TextField(db_column='strMusicBrainzTRMID', null=True)
    strmusicbrainztrackid = TextField(db_column='strMusicBrainzTrackID', null=True)
    strtitle = CharField(db_column='strTitle', null=True, max_length=512)

    class Meta:
        db_table = 'song'

class Song_Artist(BaseModel):
    boolfeatured = IntegerField(db_column='boolFeatured', null=True)
    iorder = IntegerField(db_column='iOrder', null=True)
    idartist = IntegerField(db_column='idArtist', null=True)
    idsong = IntegerField(db_column='idSong', null=True)

    class Meta:
        db_table = 'song_artist'

class Song_Genre(BaseModel):
    iorder = IntegerField(db_column='iOrder', null=True)
    idgenre = IntegerField(db_column='idGenre', null=True)
    idsong = IntegerField(db_column='idSong', null=True)

    class Meta:
        db_table = 'song_genre'

class Songview(BaseModel):
    bcompilation = IntegerField(db_column='bCompilation')
    comment = TextField(null=True)
    dwfilenamecrc = TextField(db_column='dwFileNameCRC', null=True)
    iduration = IntegerField(db_column='iDuration', null=True)
    iendoffset = IntegerField(db_column='iEndOffset', null=True)
    ikaradelay = IntegerField(db_column='iKaraDelay', null=True)
    ikaranumber = IntegerField(db_column='iKaraNumber', null=True)
    istartoffset = IntegerField(db_column='iStartOffset', null=True)
    itimesplayed = IntegerField(db_column='iTimesPlayed', null=True)
    itrack = IntegerField(db_column='iTrack', null=True)
    iyear = IntegerField(db_column='iYear', null=True)
    idalbum = IntegerField(db_column='idAlbum', null=True)
    idsong = IntegerField(db_column='idSong')
    lastplayed = CharField(null=True, max_length=20)
    rating = CharField(null=True, max_length=1)
    stralbum = CharField(db_column='strAlbum', null=True, max_length=256)
    stralbumartists = TextField(db_column='strAlbumArtists', null=True)
    strartists = TextField(db_column='strArtists', null=True)
    strfilename = TextField(db_column='strFileName', null=True)
    strgenres = TextField(db_column='strGenres', null=True)
    strkaraencoding = TextField(db_column='strKaraEncoding', null=True)
    strmusicbrainzalbumartistid = TextField(db_column='strMusicBrainzAlbumArtistID', null=True)
    strmusicbrainzalbumid = TextField(db_column='strMusicBrainzAlbumID', null=True)
    strmusicbrainzartistid = TextField(db_column='strMusicBrainzArtistID', null=True)
    strmusicbrainztrmid = TextField(db_column='strMusicBrainzTRMID', null=True)
    strmusicbrainztrackid = TextField(db_column='strMusicBrainzTrackID', null=True)
    strpath = CharField(db_column='strPath', null=True, max_length=512)
    strtitle = CharField(db_column='strTitle', null=True, max_length=512)

    class Meta:
        db_table = 'songview'

class Version(BaseModel):
    icompresscount = IntegerField(db_column='iCompressCount', null=True)
    idversion = IntegerField(db_column='idVersion', null=True)

    class Meta:
        db_table = 'version'