## File autogenerated by genmodel.py
from sqlalchemy import Binary, Boolean, Column, DateTime, Integer, MetaData, String, Table, Text

meta = MetaData()


collectionlogstatuscode = Table('collectionlogstatuscode', meta,
  Column('statuscodeid', Integer(),  primary_key=True, nullable=False),
)

rpmobsoletes = Table('rpmobsoletes', meta,
  Column('id', Integer(),  primary_key=True, nullable=False),
  Column('name', Text(length=None, convert_unicode=False, assert_unicode=None),  nullable=False),
  Column('flags', Text(length=None, convert_unicode=False, assert_unicode=None)),
  Column('epoch', Text(length=None, convert_unicode=False, assert_unicode=None)),
  Column('version', Text(length=None, convert_unicode=False, assert_unicode=None)),
  Column('release', Text(length=None, convert_unicode=False, assert_unicode=None)),
  Column('packagebuildid', Integer(),  nullable=False),
)

grouppackagelistingacl = Table('grouppackagelistingacl', meta,
  Column('id', Integer(),  primary_key=True, nullable=False),
  Column('grouppackagelistingid', Integer(),  nullable=False),
  Column('acl', Text(length=None, convert_unicode=False, assert_unicode=None),  nullable=False),
  Column('statuscode', Integer(),  nullable=False),
)

personpackagelistingacl = Table('personpackagelistingacl', meta,
  Column('id', Integer(),  primary_key=True, nullable=False),
  Column('personpackagelistingid', Integer(),  nullable=False),
  Column('acl', Text(length=None, convert_unicode=False, assert_unicode=None),  nullable=False),
  Column('statuscode', Integer(),  nullable=False),
)

collectionlog = Table('collectionlog', meta,
  Column('logid', Integer(),  primary_key=True, nullable=False),
  Column('collectionid', Integer(),  nullable=False),
  Column('action', Integer(),  nullable=False),
)

repos = Table('repos', meta,
  Column('id', Integer(),  primary_key=True, nullable=False),
  Column('shortname', Text(length=None, convert_unicode=False, assert_unicode=None),  nullable=False),
  Column('name', Text(length=None, convert_unicode=False, assert_unicode=None),  nullable=False),
  Column('url', Text(length=None, convert_unicode=False, assert_unicode=None),  nullable=False),
  Column('mirror', Text(length=None, convert_unicode=False, assert_unicode=None),  nullable=False),
  Column('active', Boolean(),  nullable=False),
  Column('collectionid', Integer()),
)

packagelog = Table('packagelog', meta,
  Column('logid', Integer(),  primary_key=True, nullable=False),
  Column('packageid', Integer(),  nullable=False),
  Column('action', Integer(),  nullable=False),
)

themes = Table('themes', meta,
  Column('id', Integer(),  primary_key=True, nullable=False),
  Column('name', Text(length=None, convert_unicode=False, assert_unicode=None),  nullable=False),
)

apptypes = Table('apptypes', meta,
  Column('apptype', String(length=None, convert_unicode=False, assert_unicode=None),  primary_key=True, nullable=False),
)

packagebuilddepends = Table('packagebuilddepends', meta,
  Column('packagebuildid', Integer(),  primary_key=True, nullable=False),
  Column('packagebuildname', Text(length=None, convert_unicode=False, assert_unicode=None),  primary_key=True, nullable=False),
)

packagebuild = Table('packagebuild', meta,
  Column('id', Integer(),  primary_key=True, nullable=False),
  Column('packageid', Integer(),  nullable=False),
  Column('epoch', Text(length=None, convert_unicode=False, assert_unicode=None)),
  Column('version', Text(length=None, convert_unicode=False, assert_unicode=None),  nullable=False),
  Column('release', Text(length=None, convert_unicode=False, assert_unicode=None),  nullable=False),
  Column('name', Text(length=None, convert_unicode=False, assert_unicode=None),  nullable=False),
  Column('license', Text(length=None, convert_unicode=False, assert_unicode=None),  nullable=False),
  Column('architecture', Text(length=None, convert_unicode=False, assert_unicode=None),  nullable=False),
  Column('size', Integer(),  nullable=False),
  Column('changelog', Text(length=None, convert_unicode=False, assert_unicode=None),  nullable=False),
  Column('committime', DateTime(timezone=False),  nullable=False),
  Column('committer', Text(length=None, convert_unicode=False, assert_unicode=None),  nullable=False),
  Column('repoid', Integer(),  nullable=False),
)

collectionstatuscode = Table('collectionstatuscode', meta,
  Column('statuscodeid', Integer(),  primary_key=True, nullable=False),
)

packagelisting = Table('packagelisting', meta,
  Column('id', Integer(),  primary_key=True, nullable=False),
  Column('packageid', Integer(),  nullable=False),
  Column('collectionid', Integer(),  nullable=False),
  Column('owner', Text(length=None, convert_unicode=False, assert_unicode=None),  nullable=False),
  Column('qacontact', Text(length=None, convert_unicode=False, assert_unicode=None)),
  Column('statuscode', Integer(),  nullable=False),
  Column('statuschange', DateTime(timezone=False),  nullable=False),
  Column('specfile', Text(length=None, convert_unicode=False, assert_unicode=None)),
)

statuscode = Table('statuscode', meta,
  Column('id', Integer(),  primary_key=True, nullable=False),
)

log = Table('log', meta,
  Column('id', Integer(),  primary_key=True, nullable=False),
  Column('username', Text(length=None, convert_unicode=False, assert_unicode=None),  nullable=False),
  Column('changetime', DateTime(timezone=False),  nullable=False),
  Column('description', Text(length=None, convert_unicode=False, assert_unicode=None)),
)

icons = Table('icons', meta,
  Column('id', Integer(),  primary_key=True, nullable=False),
  Column('nameid', Integer(),  nullable=False),
  Column('collectionid', Integer(),  nullable=False),
  Column('themeid', Integer(),  nullable=False),
  Column('icon', Binary(length=None),  nullable=False),
)

applicationstags = Table('applicationstags', meta,
  Column('applicationid', Integer(),  nullable=False),
  Column('tagid', Integer(),  nullable=False),
  Column('score', Integer(),  nullable=False),
)

personpackagelistingacllog = Table('personpackagelistingacllog', meta,
  Column('logid', Integer(),  primary_key=True, nullable=False),
  Column('personpackagelistingaclid', Integer(),  nullable=False),
  Column('action', Integer(),  nullable=False),
)

comments = Table('comments', meta,
  Column('id', Integer(),  primary_key=True, nullable=False),
  Column('author', Text(length=None, convert_unicode=False, assert_unicode=None),  nullable=False),
  Column('body', Text(length=None, convert_unicode=False, assert_unicode=None),  nullable=False),
  Column('published', Boolean(),  nullable=False),
  Column('language', Text(length=None, convert_unicode=False, assert_unicode=None),  nullable=False),
  Column('time', DateTime(timezone=False),  nullable=False),
  Column('applicationid', Integer(),  nullable=False),
)

languages = Table('languages', meta,
  Column('name', Text(length=None, convert_unicode=False, assert_unicode=None),  nullable=False),
  Column('shortname', Text(length=None, convert_unicode=False, assert_unicode=None),  primary_key=True, nullable=False),
)

collectionset = Table('collectionset', meta,
  Column('overlay', Integer(),  primary_key=True, nullable=False),
  Column('base', Integer(),  primary_key=True, nullable=False),
  Column('priority', Integer()),
)

packagebuildstatuscode = Table('packagebuildstatuscode', meta,
  Column('statuscodeid', Integer(),  primary_key=True, nullable=False),
)

packageaclstatuscode = Table('packageaclstatuscode', meta,
  Column('statuscodeid', Integer(),  primary_key=True, nullable=False),
)

branch = Table('branch', meta,
  Column('collectionid', Integer(),  primary_key=True, nullable=False),
  Column('branchname', String(length=None, convert_unicode=False, assert_unicode=None),  nullable=False),
  Column('disttag', String(length=None, convert_unicode=False, assert_unicode=None),  nullable=False),
  Column('parentid', Integer()),
)

rpmprovides = Table('rpmprovides', meta,
  Column('id', Integer(),  primary_key=True, nullable=False),
  Column('name', Text(length=None, convert_unicode=False, assert_unicode=None),  nullable=False),
  Column('flags', Text(length=None, convert_unicode=False, assert_unicode=None)),
  Column('epoch', Text(length=None, convert_unicode=False, assert_unicode=None)),
  Column('version', Text(length=None, convert_unicode=False, assert_unicode=None)),
  Column('release', Text(length=None, convert_unicode=False, assert_unicode=None)),
  Column('packagebuildid', Integer()),
)

rpmrequires = Table('rpmrequires', meta,
  Column('id', Integer(),  primary_key=True, nullable=False),
  Column('name', Text(length=None, convert_unicode=False, assert_unicode=None),  nullable=False),
  Column('flags', Text(length=None, convert_unicode=False, assert_unicode=None)),
  Column('epoch', Text(length=None, convert_unicode=False, assert_unicode=None)),
  Column('version', Text(length=None, convert_unicode=False, assert_unicode=None)),
  Column('release', Text(length=None, convert_unicode=False, assert_unicode=None)),
  Column('packagebuildid', Integer(),  nullable=False),
  Column('prereq', Boolean(),  nullable=False),
)

packagebuildapplications = Table('packagebuildapplications', meta,
  Column('applicationid', Integer(),  nullable=False),
  Column('packagebuildid', Integer(),  nullable=False),
)

grouppackagelisting = Table('grouppackagelisting', meta,
  Column('id', Integer(),  primary_key=True, nullable=False),
  Column('groupname', Text(length=None, convert_unicode=False, assert_unicode=None),  nullable=False),
  Column('packagelistingid', Integer(),  nullable=False),
)

packagelistinglog = Table('packagelistinglog', meta,
  Column('logid', Integer(),  primary_key=True, nullable=False),
  Column('packagelistingid', Integer(),  nullable=False),
  Column('action', Integer(),  nullable=False),
)

packagelistinglogstatuscode = Table('packagelistinglogstatuscode', meta,
  Column('statuscodeid', Integer(),  primary_key=True, nullable=False),
)

packagebuildlogstatuscode = Table('packagebuildlogstatuscode', meta,
  Column('statuscodeid', Integer(),  primary_key=True, nullable=False),
)

packagelogstatuscode = Table('packagelogstatuscode', meta,
  Column('statuscodeid', Integer(),  primary_key=True, nullable=False),
)

collection = Table('collection', meta,
  Column('id', Integer(),  primary_key=True, nullable=False),
  Column('name', Text(length=None, convert_unicode=False, assert_unicode=None),  nullable=False),
  Column('version', Text(length=None, convert_unicode=False, assert_unicode=None),  nullable=False),
  Column('statuscode', Integer(),  nullable=False),
  Column('owner', Text(length=None, convert_unicode=False, assert_unicode=None),  nullable=False),
  Column('publishurltemplate', Text(length=None, convert_unicode=False, assert_unicode=None)),
  Column('pendingurltemplate', Text(length=None, convert_unicode=False, assert_unicode=None)),
  Column('summary', Text(length=None, convert_unicode=False, assert_unicode=None)),
  Column('description', Text(length=None, convert_unicode=False, assert_unicode=None)),
  Column('koji_name', Text(length=None, convert_unicode=False, assert_unicode=None)),
)

iconnames = Table('iconnames', meta,
  Column('id', Integer(),  primary_key=True, nullable=False),
  Column('name', Text(length=None, convert_unicode=False, assert_unicode=None),  nullable=False),
)

applications = Table('applications', meta,
  Column('id', Integer(),  primary_key=True, nullable=False),
  Column('name', Text(length=None, convert_unicode=False, assert_unicode=None),  nullable=False),
  Column('description', Text(length=None, convert_unicode=False, assert_unicode=None),  nullable=False),
  Column('url', Text(length=None, convert_unicode=False, assert_unicode=None)),
  Column('apptype', String(length=None, convert_unicode=False, assert_unicode=None),  nullable=False),
  Column('desktoptype', Text(length=None, convert_unicode=False, assert_unicode=None)),
  Column('iconnameid', Integer()),
  Column('iconid', Integer()),
  Column('summary', Text(length=None, convert_unicode=False, assert_unicode=None)),
)

personpackagelisting = Table('personpackagelisting', meta,
  Column('id', Integer(),  primary_key=True, nullable=False),
  Column('username', Text(length=None, convert_unicode=False, assert_unicode=None),  nullable=False),
  Column('packagelistingid', Integer(),  nullable=False),
)

grouppackagelistingacllog = Table('grouppackagelistingacllog', meta,
  Column('logid', Integer(),  primary_key=True, nullable=False),
  Column('grouppackagelistingaclid', Integer(),  nullable=False),
  Column('action', Integer(),  nullable=False),
)

rpmconflicts = Table('rpmconflicts', meta,
  Column('id', Integer(),  primary_key=True, nullable=False),
  Column('name', Text(length=None, convert_unicode=False, assert_unicode=None),  nullable=False),
  Column('flags', Text(length=None, convert_unicode=False, assert_unicode=None)),
  Column('epoch', Text(length=None, convert_unicode=False, assert_unicode=None)),
  Column('version', Text(length=None, convert_unicode=False, assert_unicode=None)),
  Column('release', Text(length=None, convert_unicode=False, assert_unicode=None)),
  Column('packagebuildid', Integer(),  nullable=False),
)

packagebuildlog = Table('packagebuildlog', meta,
  Column('logid', Integer(),  primary_key=True, nullable=False),
  Column('packagebuildid', Integer(),  nullable=False),
  Column('action', Integer(),  nullable=False),
)

packagelistingstatuscode = Table('packagelistingstatuscode', meta,
  Column('statuscodeid', Integer(),  primary_key=True, nullable=False),
)

tags = Table('tags', meta,
  Column('id', Integer(),  primary_key=True, nullable=False),
  Column('name', Text(length=None, convert_unicode=False, assert_unicode=None),  nullable=False),
  Column('language', Text(length=None, convert_unicode=False, assert_unicode=None),  nullable=False),
)

rpmfiles = Table('rpmfiles', meta,
  Column('name', Text(length=None, convert_unicode=False, assert_unicode=None),  primary_key=True, nullable=False),
  Column('packagebuildid', Integer(),  primary_key=True, nullable=False),
)

packagestatuscode = Table('packagestatuscode', meta,
  Column('statuscodeid', Integer(),  primary_key=True, nullable=False),
)

package = Table('package', meta,
  Column('id', Integer(),  primary_key=True, nullable=False),
  Column('name', Text(length=None, convert_unicode=False, assert_unicode=None),  nullable=False),
  Column('summary', Text(length=None, convert_unicode=False, assert_unicode=None),  nullable=False),
  Column('description', Text(length=None, convert_unicode=False, assert_unicode=None)),
  Column('reviewurl', Text(length=None, convert_unicode=False, assert_unicode=None)),
  Column('statuscode', Integer(),  nullable=False),
  Column('shouldopen', Boolean(),  nullable=False),
  Column('upstreamurl', Text(length=None, convert_unicode=False, assert_unicode=None)),
)

packageacllogstatuscode = Table('packageacllogstatuscode', meta,
  Column('statuscodeid', Integer(),  primary_key=True, nullable=False),
)

packagebuildlisting = Table('packagebuildlisting', meta,
  Column('packagebuildid', Integer(),  primary_key=True, nullable=False),
  Column('packagelistingid', Integer(),  primary_key=True, nullable=False),
)

statuscodetranslation = Table('statuscodetranslation', meta,
  Column('statuscodeid', Integer(),  primary_key=True, nullable=False),
  Column('language', String(length=None, convert_unicode=False, assert_unicode=None),  primary_key=True, nullable=False),
  Column('statusname', Text(length=None, convert_unicode=False, assert_unicode=None),  nullable=False),
  Column('description', Text(length=None, convert_unicode=False, assert_unicode=None)),
)