-
Notifications
You must be signed in to change notification settings - Fork 9
/
1b8856078bd3_integrating_embed_tables.py
75 lines (67 loc) · 3.74 KB
/
1b8856078bd3_integrating_embed_tables.py
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
"""Integrating embed tables
Revision ID: 1b8856078bd3
Revises: f2b0984f780
Create Date: 2016-10-28 10:58:42.229165
"""
# revision identifiers, used by Alembic.
revision = '1b8856078bd3'
down_revision = 'f2b0984f780'
from alembic import op
import sqlalchemy as sa
def upgrade():
### commands auto generated by Alembic - please adjust! ###
op.create_table('SiWaySAMLUsers',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('email', sa.Unicode(length=255), nullable=False),
sa.Column('uid', sa.Integer(), nullable=False),
sa.Column('employee_type', sa.Unicode(length=255), nullable=False),
sa.Column('full_name', sa.Unicode(length=255), nullable=False),
sa.Column('short_name', sa.Unicode(length=255), nullable=False),
sa.Column('school_name', sa.Unicode(length=255), nullable=False),
sa.Column('group', sa.Unicode(length=255), nullable=False),
sa.PrimaryKeyConstraint('id')
)
op.create_index(u'ix_SiWaySAMLUsers_email', 'SiWaySAMLUsers', ['email'], unique=True)
op.create_table('EmbedApplications',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('url', sa.Unicode(length=255), nullable=False),
sa.Column('name', sa.Unicode(length=100), nullable=False),
sa.Column('owner_id', sa.Integer(), nullable=True),
sa.Column('height', sa.Integer(), nullable=True),
sa.Column('scale', sa.Integer(), nullable=True),
sa.Column('identifier', sa.Unicode(length=36), nullable=False),
sa.Column('creation', sa.DateTime(), nullable=False),
sa.Column('last_update', sa.DateTime(), nullable=False),
sa.ForeignKeyConstraint(['owner_id'], ['lt_users.id'], ),
sa.PrimaryKeyConstraint('id')
)
op.create_index(u'ix_EmbedApplications_creation', 'EmbedApplications', ['creation'], unique=False)
op.create_index(u'ix_EmbedApplications_identifier', 'EmbedApplications', ['identifier'], unique=True)
op.create_index(u'ix_EmbedApplications_last_update', 'EmbedApplications', ['last_update'], unique=False)
op.create_index(u'ix_EmbedApplications_name', 'EmbedApplications', ['name'], unique=False)
op.create_index(u'ix_EmbedApplications_url', 'EmbedApplications', ['url'], unique=False)
op.create_table('EmbedApplicationTranslation',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('embed_application_id', sa.Integer(), nullable=True),
sa.Column('url', sa.Unicode(length=255), nullable=False),
sa.Column('language', sa.Unicode(length=10), nullable=False),
sa.ForeignKeyConstraint(['embed_application_id'], ['EmbedApplications.id'], ),
sa.PrimaryKeyConstraint('id')
)
op.create_index(u'ix_EmbedApplicationTranslation_language', 'EmbedApplicationTranslation', ['language'], unique=False)
op.create_index(u'ix_EmbedApplicationTranslation_url', 'EmbedApplicationTranslation', ['url'], unique=False)
### end Alembic commands ###
def downgrade():
### commands auto generated by Alembic - please adjust! ###
op.drop_index(u'ix_EmbedApplicationTranslation_url', table_name='EmbedApplicationTranslation')
op.drop_index(u'ix_EmbedApplicationTranslation_language', table_name='EmbedApplicationTranslation')
op.drop_table('EmbedApplicationTranslation')
op.drop_index(u'ix_EmbedApplications_url', table_name='EmbedApplications')
op.drop_index(u'ix_EmbedApplications_name', table_name='EmbedApplications')
op.drop_index(u'ix_EmbedApplications_last_update', table_name='EmbedApplications')
op.drop_index(u'ix_EmbedApplications_identifier', table_name='EmbedApplications')
op.drop_index(u'ix_EmbedApplications_creation', table_name='EmbedApplications')
op.drop_table('EmbedApplications')
op.drop_index(u'ix_SiWaySAMLUsers_email', table_name='SiWaySAMLUsers')
op.drop_table('SiWaySAMLUsers')
### end Alembic commands ###