Column('id', Integer, primary_key=True),
Column('username', String(255), nullable=False, index=True, unique=True),
)
Issues = Table('issues', metadata,
Column('id', Integer, primary_key=True),
Column('title', UnicodeText, nullable=False),
Column('upstream_branch', String(255), nullable=False),
Column('upstream_url', String(255), nullable=False),
Column('upstream_latesthash', String(255), nullable=False),
Column('topic_branch', String(255), nullable=False),
Column('topic_url', String(255), nullable=False),
Column('topic_latesthash', String(255), nullable=False),
Column('status', Integer, nullable=False, index=True),
)
Issues.STATUS_OPEN = 0
Issues.STATUS_SUBMITTED = 1
Issues.STATUS_ABANDONED = 2
Versions = Table('versions', metadata,
Column('issue_id', Integer, ForeignKey('issues.id'), index=True, primary_key=True, autoincrement=False),
Column('version_num', Integer, nullable=False, primary_key=True, autoincrement=False),
Column('base_hash', String(255), nullable=False),
Column('topic_hash', String(255), nullable=False),
)
Messages = Table('messages', metadata,
Column('id', Integer, nullable=False, primary_key=True),
Column('issue_id', Integer, ForeignKey('issues.id'), nullable=False, index=True),
Column('author_id', Integer, ForeignKey('users.id'), nullable=False),
Column('timestamp', Integer, nullable=False, index=True),
)
Issues = Table(
'issues',
metadata,
Column('id', Integer, primary_key=True),
Column('title', UnicodeText, nullable=False),
Column('upstream_branch', String(255), nullable=False),
Column('upstream_url', String(255), nullable=False),
Column('upstream_latesthash', String(255), nullable=False),
Column('topic_branch', String(255), nullable=False),
Column('topic_url', String(255), nullable=False),
Column('topic_latesthash', String(255), nullable=False),
Column('status', Integer, nullable=False, index=True),
)
Issues.STATUS_OPEN = 0
Issues.STATUS_SUBMITTED = 1
Issues.STATUS_ABANDONED = 2
Versions = Table(
'versions',
metadata,
Column('issue_id',
Integer,
ForeignKey('issues.id'),
index=True,
primary_key=True,
autoincrement=False),
Column('version_num',
Integer,
nullable=False,
