Add workflow ForeignKey for ticket

Change-Id: I46c7329dc6fdfc4f022f660eb2bd2bcb7761cb1f
This commit is contained in:
lawrancejing 2015-12-14 09:45:16 +00:00
parent 879bfd07d3
commit aaefe57718
2 changed files with 4 additions and 0 deletions

View File

@ -26,6 +26,8 @@ def upgrade(migrate_engine):
sqlalchemy.Column('name', sqlalchemy.String(255)),
sqlalchemy.Column('type', sqlalchemy.String(255)),
sqlalchemy.Column('status', sqlalchemy.String(255)),
sqlalchemy.Column('workflow_id', sqlalchemy.String(36),
sqlalchemy.ForeignKey('workflow.id')),
sqlalchemy.Column('user', sqlalchemy.String(32)),
sqlalchemy.Column('project', sqlalchemy.String(32)),
sqlalchemy.Column('domain', sqlalchemy.String(32)),

View File

@ -48,6 +48,8 @@ class Ticket(BASE, EvoqueBase):
id = sqlalchemy.Column('id', sqlalchemy.String(36), primary_key=True,
default=lambda: str(uuid.uuid4()))
workflow_id = sqlalchemy.Column(sqlalchemy.String(36),
sqlalchemy.ForeignKey('workflow.id'))
name = sqlalchemy.Column('name', sqlalchemy.String(255))
type = sqlalchemy.Column(sqlalchemy.String(255))
status = sqlalchemy.Column(sqlalchemy.String(255))