import sqlalchemy

metadata = sqlalchemy.MetaData()

package = sqlalchemy.Table("package", metadata,
        sqlalchemy.Column('id', sqlalchemy.Integer, primary_key=True),
        sqlalchemy.Column('name', sqlalchemy.Text, unique=True),
        sqlalchemy.Column('version', sqlalchemy.Text),
        sqlalchemy.Column('architecture', sqlalchemy.Text),
        sqlalchemy.Column('source', sqlalchemy.Text))

content = sqlalchemy.Table("content", metadata,
        sqlalchemy.Column("id", sqlalchemy.Integer, primary_key=True),
        sqlalchemy.Column("pid", None, sqlalchemy.ForeignKey("package.id")),
        sqlalchemy.Column("filename", sqlalchemy.Text),
        sqlalchemy.Column("size", sqlalchemy.Integer))