Script 3f4966a9cc0_add_group_table_py
[hide private]
[frames] | no frames]

Source Code for Script script-3f4966a9cc0_add_group_table_py

 1  """Add group table 
 2   
 3  Revision ID: 3f4966a9cc0 
 4  Revises: 3b4cfc666d14 
 5  Create Date: 2015-09-24 10:14:06.291886 
 6   
 7  """ 
 8   
 9  # revision identifiers, used by Alembic. 
10  revision = '3f4966a9cc0' 
11  down_revision = '3b4cfc666d14' 
12   
13  from alembic import op 
14  import sqlalchemy as sa 
15   
16   
17 -def upgrade():
18 op.create_table('group', 19 sa.Column('id', sa.Integer(), nullable=False), 20 sa.Column('name', sa.String(length=127), nullable=True), 21 sa.Column('fas_name', sa.String(length=127), nullable=True), 22 sa.PrimaryKeyConstraint('id') 23 ) 24 op.add_column('copr', 25 sa.Column('group_id', sa.Integer(), nullable=True) 26 )
27 28
29 -def downgrade():
30 op.drop_table('group') 31 op.drop_column('copr', 'group_id')
32