forked from bcgov/sbc-auth
-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy path5cf63f567a62_adding_version.py
More file actions
375 lines (365 loc) · 27.6 KB
/
5cf63f567a62_adding_version.py
File metadata and controls
375 lines (365 loc) · 27.6 KB
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
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
"""adding_version
Revision ID: 5cf63f567a62
Revises: 2e58cc00009b
Create Date: 2020-08-26 17:16:57.006971
"""
import sqlalchemy as sa
import sqlalchemy_utils
from alembic import op
from sqlalchemy.dialects import postgresql
# revision identifiers, used by Alembic.
revision = '5cf63f567a62'
down_revision = '2e58cc00009b'
branch_labels = None
depends_on = None
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('account_login_options_version',
sa.Column('id', sa.Integer(), autoincrement=False, nullable=False),
sa.Column('login_source', sa.String(length=20), autoincrement=False, nullable=True),
sa.Column('org_id', sa.Integer(), autoincrement=False, nullable=True),
sa.Column('is_active', sa.Boolean(), autoincrement=False, nullable=True),
sa.Column('created_by_id', sa.Integer(), autoincrement=False, nullable=True),
sa.Column('transaction_id', sa.BigInteger(), autoincrement=False, nullable=False),
sa.Column('end_transaction_id', sa.BigInteger(), nullable=True),
sa.Column('operation_type', sa.SmallInteger(), nullable=False),
sa.PrimaryKeyConstraint('id', 'transaction_id')
)
op.create_index(op.f('ix_account_login_options_version_end_transaction_id'), 'account_login_options_version',
['end_transaction_id'], unique=False)
op.create_index(op.f('ix_account_login_options_version_operation_type'), 'account_login_options_version',
['operation_type'], unique=False)
op.create_index(op.f('ix_account_login_options_version_transaction_id'), 'account_login_options_version',
['transaction_id'], unique=False)
op.create_table('account_payment_settings_version',
sa.Column('id', sa.Integer(), autoincrement=False, nullable=False),
sa.Column('preferred_payment_code', sa.String(length=15), autoincrement=False, nullable=True),
sa.Column('bcol_user_id', sa.String(length=20), autoincrement=False, nullable=True),
sa.Column('bcol_account_id', sa.String(length=20), autoincrement=False, nullable=True),
sa.Column('org_id', sa.Integer(), autoincrement=False, nullable=True),
sa.Column('is_active', sa.Boolean(), autoincrement=False, nullable=True),
sa.Column('created_by_id', sa.Integer(), autoincrement=False, nullable=True),
sa.Column('transaction_id', sa.BigInteger(), autoincrement=False, nullable=False),
sa.Column('end_transaction_id', sa.BigInteger(), nullable=True),
sa.Column('operation_type', sa.SmallInteger(), nullable=False),
sa.PrimaryKeyConstraint('id', 'transaction_id')
)
op.create_index(op.f('ix_account_payment_settings_version_end_transaction_id'), 'account_payment_settings_version',
['end_transaction_id'], unique=False)
op.create_index(op.f('ix_account_payment_settings_version_operation_type'), 'account_payment_settings_version',
['operation_type'], unique=False)
op.create_index(op.f('ix_account_payment_settings_version_transaction_id'), 'account_payment_settings_version',
['transaction_id'], unique=False)
op.create_table('activity',
sa.Column('id', sa.BigInteger(), autoincrement=True, nullable=False),
sa.Column('verb', sa.Unicode(length=255), nullable=True),
sa.Column('transaction_id', sa.BigInteger(), nullable=False),
sa.Column('data', sqlalchemy_utils.types.json.JSONType(), nullable=True),
sa.Column('object_type', sa.String(length=255), nullable=True),
sa.Column('object_id', sa.BigInteger(), nullable=True),
sa.Column('object_tx_id', sa.BigInteger(), nullable=True),
sa.Column('target_type', sa.String(length=255), nullable=True),
sa.Column('target_id', sa.BigInteger(), nullable=True),
sa.Column('target_tx_id', sa.BigInteger(), nullable=True),
sa.PrimaryKeyConstraint('id')
)
op.create_index(op.f('ix_activity_transaction_id'), 'activity', ['transaction_id'], unique=False)
op.create_table('affidavit_version',
sa.Column('id', sa.Integer(), autoincrement=False, nullable=False),
sa.Column('document_id', sa.String(length=60), autoincrement=False, nullable=True),
sa.Column('issuer', sa.String(length=250), autoincrement=False, nullable=True),
sa.Column('status_code', sa.String(length=15), autoincrement=False, nullable=True),
sa.Column('decision_made_by', sa.String(length=250), autoincrement=False, nullable=True),
sa.Column('decision_made_on', sa.DateTime(), autoincrement=False, nullable=True),
sa.Column('user_id', sa.Integer(), autoincrement=False, nullable=True),
sa.Column('created_by_id', sa.Integer(), autoincrement=False, nullable=True),
sa.Column('transaction_id', sa.BigInteger(), autoincrement=False, nullable=False),
sa.Column('end_transaction_id', sa.BigInteger(), nullable=True),
sa.Column('operation_type', sa.SmallInteger(), nullable=False),
sa.PrimaryKeyConstraint('id', 'transaction_id')
)
op.create_index(op.f('ix_affidavit_version_document_id'), 'affidavit_version', ['document_id'], unique=False)
op.create_index(op.f('ix_affidavit_version_end_transaction_id'), 'affidavit_version', ['end_transaction_id'],
unique=False)
op.create_index(op.f('ix_affidavit_version_operation_type'), 'affidavit_version', ['operation_type'], unique=False)
op.create_index(op.f('ix_affidavit_version_transaction_id'), 'affidavit_version', ['transaction_id'], unique=False)
op.create_table('affiliation_version',
sa.Column('id', sa.Integer(), autoincrement=False, nullable=False),
sa.Column('entity_id', sa.Integer(), autoincrement=False, nullable=True),
sa.Column('org_id', sa.Integer(), autoincrement=False, nullable=True),
sa.Column('created_by_id', sa.Integer(), autoincrement=False, nullable=True),
sa.Column('transaction_id', sa.BigInteger(), autoincrement=False, nullable=False),
sa.Column('end_transaction_id', sa.BigInteger(), nullable=True),
sa.Column('operation_type', sa.SmallInteger(), nullable=False),
sa.PrimaryKeyConstraint('id', 'transaction_id')
)
op.create_index(op.f('ix_affiliation_version_end_transaction_id'), 'affiliation_version', ['end_transaction_id'],
unique=False)
op.create_index(op.f('ix_affiliation_version_operation_type'), 'affiliation_version', ['operation_type'],
unique=False)
op.create_index(op.f('ix_affiliation_version_transaction_id'), 'affiliation_version', ['transaction_id'],
unique=False)
op.create_table('contact_link_version',
sa.Column('id', sa.Integer(), autoincrement=False, nullable=False),
sa.Column('contact_id', sa.Integer(), autoincrement=False, nullable=True),
sa.Column('entity_id', sa.Integer(), autoincrement=False, nullable=True),
sa.Column('user_id', sa.Integer(), autoincrement=False, nullable=True),
sa.Column('org_id', sa.Integer(), autoincrement=False, nullable=True),
sa.Column('affidavit_id', sa.Integer(), autoincrement=False, nullable=True),
sa.Column('created_by_id', sa.Integer(), autoincrement=False, nullable=True),
sa.Column('transaction_id', sa.BigInteger(), autoincrement=False, nullable=False),
sa.Column('end_transaction_id', sa.BigInteger(), nullable=True),
sa.Column('operation_type', sa.SmallInteger(), nullable=False),
sa.PrimaryKeyConstraint('id', 'transaction_id')
)
op.create_index(op.f('ix_contact_link_version_end_transaction_id'), 'contact_link_version', ['end_transaction_id'],
unique=False)
op.create_index(op.f('ix_contact_link_version_operation_type'), 'contact_link_version', ['operation_type'],
unique=False)
op.create_index(op.f('ix_contact_link_version_transaction_id'), 'contact_link_version', ['transaction_id'],
unique=False)
op.create_table('contact_version',
sa.Column('id', sa.Integer(), autoincrement=False, nullable=False),
sa.Column('street', sa.String(length=250), autoincrement=False, nullable=True),
sa.Column('street_additional', sa.String(length=250), autoincrement=False, nullable=True),
sa.Column('city', sa.String(length=100), autoincrement=False, nullable=True),
sa.Column('region', sa.String(length=100), autoincrement=False, nullable=True),
sa.Column('country', sa.String(length=20), autoincrement=False, nullable=True),
sa.Column('postal_code', sa.String(length=10), autoincrement=False, nullable=True),
sa.Column('delivery_instructions', sa.String(length=4096), autoincrement=False, nullable=True),
sa.Column('phone', sa.String(length=20), autoincrement=False, nullable=True),
sa.Column('phone_extension', sa.String(length=10), autoincrement=False, nullable=True),
sa.Column('email', sa.String(length=100), autoincrement=False, nullable=True),
sa.Column('entity_id', sa.Integer(), autoincrement=False, nullable=True),
sa.Column('created_by_id', sa.Integer(), autoincrement=False, nullable=True),
sa.Column('transaction_id', sa.BigInteger(), autoincrement=False, nullable=False),
sa.Column('end_transaction_id', sa.BigInteger(), nullable=True),
sa.Column('operation_type', sa.SmallInteger(), nullable=False),
sa.PrimaryKeyConstraint('id', 'transaction_id')
)
op.create_index(op.f('ix_contact_version_end_transaction_id'), 'contact_version', ['end_transaction_id'],
unique=False)
op.create_index(op.f('ix_contact_version_operation_type'), 'contact_version', ['operation_type'], unique=False)
op.create_index(op.f('ix_contact_version_street'), 'contact_version', ['street'], unique=False)
op.create_index(op.f('ix_contact_version_transaction_id'), 'contact_version', ['transaction_id'], unique=False)
op.create_table('membership_version',
sa.Column('id', sa.Integer(), autoincrement=False, nullable=False),
sa.Column('user_id', sa.Integer(), autoincrement=False, nullable=True),
sa.Column('org_id', sa.Integer(), autoincrement=False, nullable=True),
sa.Column('membership_type_code', sa.String(length=15), autoincrement=False, nullable=True),
sa.Column('status', sa.Integer(), autoincrement=False, nullable=True),
sa.Column('created_by_id', sa.Integer(), autoincrement=False, nullable=True),
sa.Column('transaction_id', sa.BigInteger(), autoincrement=False, nullable=False),
sa.Column('end_transaction_id', sa.BigInteger(), nullable=True),
sa.Column('operation_type', sa.SmallInteger(), nullable=False),
sa.PrimaryKeyConstraint('id', 'transaction_id')
)
op.create_index(op.f('ix_membership_version_end_transaction_id'), 'membership_version', ['end_transaction_id'],
unique=False)
op.create_index(op.f('ix_membership_version_operation_type'), 'membership_version', ['operation_type'],
unique=False)
op.create_index(op.f('ix_membership_version_transaction_id'), 'membership_version', ['transaction_id'],
unique=False)
op.create_table('org_settings_version',
sa.Column('id', sa.Integer(), autoincrement=False, nullable=False),
sa.Column('org_id', sa.Integer(), autoincrement=False, nullable=True),
sa.Column('setting', sa.String(length=100), autoincrement=False, nullable=True),
sa.Column('enabled', sa.Boolean(), autoincrement=False, nullable=True),
sa.Column('created_by_id', sa.Integer(), autoincrement=False, nullable=True),
sa.Column('transaction_id', sa.BigInteger(), autoincrement=False, nullable=False),
sa.Column('end_transaction_id', sa.BigInteger(), nullable=True),
sa.Column('operation_type', sa.SmallInteger(), nullable=False),
sa.PrimaryKeyConstraint('id', 'transaction_id')
)
op.create_index(op.f('ix_org_settings_version_end_transaction_id'), 'org_settings_version', ['end_transaction_id'],
unique=False)
op.create_index(op.f('ix_org_settings_version_operation_type'), 'org_settings_version', ['operation_type'],
unique=False)
op.create_index(op.f('ix_org_settings_version_transaction_id'), 'org_settings_version', ['transaction_id'],
unique=False)
op.create_table('org_version',
sa.Column('id', sa.Integer(), autoincrement=False, nullable=False),
sa.Column('type_code', sa.String(length=15), autoincrement=False, nullable=True),
sa.Column('status_code', sa.String(length=30), autoincrement=False, nullable=True),
sa.Column('name', sa.String(length=250), autoincrement=False, nullable=True),
sa.Column('access_type', sa.String(length=250), autoincrement=False, nullable=True),
sa.Column('billable', sa.Boolean(), autoincrement=False, nullable=True),
sa.Column('decision_made_by', sa.String(length=250), autoincrement=False, nullable=True),
sa.Column('decision_made_on', sa.DateTime(), autoincrement=False, nullable=True),
sa.Column('created_by_id', sa.Integer(), autoincrement=False, nullable=True),
sa.Column('transaction_id', sa.BigInteger(), autoincrement=False, nullable=False),
sa.Column('end_transaction_id', sa.BigInteger(), nullable=True),
sa.Column('operation_type', sa.SmallInteger(), nullable=False),
sa.PrimaryKeyConstraint('id', 'transaction_id')
)
op.create_index(op.f('ix_org_version_access_type'), 'org_version', ['access_type'], unique=False)
op.create_index(op.f('ix_org_version_end_transaction_id'), 'org_version', ['end_transaction_id'], unique=False)
op.create_index(op.f('ix_org_version_name'), 'org_version', ['name'], unique=False)
op.create_index(op.f('ix_org_version_operation_type'), 'org_version', ['operation_type'], unique=False)
op.create_index(op.f('ix_org_version_transaction_id'), 'org_version', ['transaction_id'], unique=False)
op.create_table('product_subscription_role_version',
sa.Column('id', sa.Integer(), autoincrement=False, nullable=False),
sa.Column('product_subscription_id', sa.Integer(), autoincrement=False, nullable=True),
sa.Column('product_role_id', sa.Integer(), autoincrement=False, nullable=True),
sa.Column('created_by_id', sa.Integer(), autoincrement=False, nullable=True),
sa.Column('transaction_id', sa.BigInteger(), autoincrement=False, nullable=False),
sa.Column('end_transaction_id', sa.BigInteger(), nullable=True),
sa.Column('operation_type', sa.SmallInteger(), nullable=False),
sa.PrimaryKeyConstraint('id', 'transaction_id')
)
op.create_index(op.f('ix_product_subscription_role_version_end_transaction_id'),
'product_subscription_role_version', ['end_transaction_id'], unique=False)
op.create_index(op.f('ix_product_subscription_role_version_operation_type'), 'product_subscription_role_version',
['operation_type'], unique=False)
op.create_index(op.f('ix_product_subscription_role_version_transaction_id'), 'product_subscription_role_version',
['transaction_id'], unique=False)
op.create_table('product_subscription_version',
sa.Column('id', sa.Integer(), autoincrement=False, nullable=False),
sa.Column('org_id', sa.Integer(), autoincrement=False, nullable=True),
sa.Column('product_code', sa.String(length=15), autoincrement=False, nullable=True),
sa.Column('created_by_id', sa.Integer(), autoincrement=False, nullable=True),
sa.Column('transaction_id', sa.BigInteger(), autoincrement=False, nullable=False),
sa.Column('end_transaction_id', sa.BigInteger(), nullable=True),
sa.Column('operation_type', sa.SmallInteger(), nullable=False),
sa.PrimaryKeyConstraint('id', 'transaction_id')
)
op.create_index(op.f('ix_product_subscription_version_end_transaction_id'), 'product_subscription_version',
['end_transaction_id'], unique=False)
op.create_index(op.f('ix_product_subscription_version_operation_type'), 'product_subscription_version',
['operation_type'], unique=False)
op.create_index(op.f('ix_product_subscription_version_transaction_id'), 'product_subscription_version',
['transaction_id'], unique=False)
op.create_table('transaction',
sa.Column('issued_at', sa.DateTime(), nullable=True),
sa.Column('id', sa.BigInteger(), autoincrement=True, nullable=False),
sa.Column('remote_addr', sa.String(length=50), nullable=True),
sa.PrimaryKeyConstraint('id')
)
op.create_table('user_version',
sa.Column('id', sa.Integer(), autoincrement=False, nullable=False),
sa.Column('username', sa.String(length=100), autoincrement=False, nullable=True),
sa.Column('first_name', sa.String(length=200), autoincrement=False, nullable=True),
sa.Column('last_name', sa.String(length=200), autoincrement=False, nullable=True),
sa.Column('email', sa.String(length=200), autoincrement=False, nullable=True),
sa.Column('keycloak_guid', postgresql.UUID(as_uuid=True), autoincrement=False, nullable=True),
sa.Column('roles', sa.String(length=1000), autoincrement=False, nullable=True),
sa.Column('is_terms_of_use_accepted', sa.Boolean(), autoincrement=False, nullable=True),
sa.Column('terms_of_use_accepted_version', sa.String(length=10), autoincrement=False,
nullable=True),
sa.Column('type', sa.String(length=200), autoincrement=False, nullable=True),
sa.Column('status', sa.Integer(), autoincrement=False, nullable=True),
sa.Column('idp_userid', sa.String(length=256), autoincrement=False, nullable=True),
sa.Column('login_source', sa.String(length=200), autoincrement=False, nullable=True),
sa.Column('login_time', sa.DateTime(), autoincrement=False, nullable=True),
sa.Column('created_by_id', sa.Integer(), autoincrement=False, nullable=True),
sa.Column('transaction_id', sa.BigInteger(), autoincrement=False, nullable=False),
sa.Column('end_transaction_id', sa.BigInteger(), nullable=True),
sa.Column('operation_type', sa.SmallInteger(), nullable=False),
sa.PrimaryKeyConstraint('id', 'transaction_id')
)
op.create_index(op.f('ix_user_version_email'), 'user_version', ['email'], unique=False)
op.create_index(op.f('ix_user_version_end_transaction_id'), 'user_version', ['end_transaction_id'], unique=False)
op.create_index(op.f('ix_user_version_first_name'), 'user_version', ['first_name'], unique=False)
op.create_index(op.f('ix_user_version_idp_userid'), 'user_version', ['idp_userid'], unique=False)
op.create_index(op.f('ix_user_version_last_name'), 'user_version', ['last_name'], unique=False)
op.create_index(op.f('ix_user_version_operation_type'), 'user_version', ['operation_type'], unique=False)
op.create_index(op.f('ix_user_version_transaction_id'), 'user_version', ['transaction_id'], unique=False)
op.create_index(op.f('ix_user_version_username'), 'user_version', ['username'], unique=False)
op.execute('update documents set content_type=\'text/html\' where type=\'termsofuse\'')
op.alter_column('documents', 'content_type',
existing_type=sa.VARCHAR(length=50),
type_=sa.String(length=20),
nullable=False)
op.alter_column('membership_type', 'display_name',
existing_type=sa.VARCHAR(length=50),
type_=sa.String(length=100),
existing_nullable=True)
op.add_column('user', sa.Column('login_time', sa.DateTime(), nullable=True))
op.alter_column('user', 'login_source',
existing_type=sa.VARCHAR(length=20),
type_=sa.String(length=200),
existing_nullable=True)
# ### end Alembic commands ###
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.alter_column('user', 'login_source',
existing_type=sa.String(length=200),
type_=sa.VARCHAR(length=20),
existing_nullable=True)
op.drop_column('user', 'login_time')
op.alter_column('membership_type', 'display_name',
existing_type=sa.String(length=100),
type_=sa.VARCHAR(length=50),
existing_nullable=True)
op.alter_column('documents', 'content_type',
existing_type=sa.String(length=20),
type_=sa.VARCHAR(length=50),
nullable=True)
op.drop_index(op.f('ix_user_version_username'), table_name='user_version')
op.drop_index(op.f('ix_user_version_transaction_id'), table_name='user_version')
op.drop_index(op.f('ix_user_version_operation_type'), table_name='user_version')
op.drop_index(op.f('ix_user_version_last_name'), table_name='user_version')
op.drop_index(op.f('ix_user_version_idp_userid'), table_name='user_version')
op.drop_index(op.f('ix_user_version_first_name'), table_name='user_version')
op.drop_index(op.f('ix_user_version_end_transaction_id'), table_name='user_version')
op.drop_index(op.f('ix_user_version_email'), table_name='user_version')
op.drop_table('user_version')
op.drop_table('transaction')
op.drop_index(op.f('ix_product_subscription_version_transaction_id'), table_name='product_subscription_version')
op.drop_index(op.f('ix_product_subscription_version_operation_type'), table_name='product_subscription_version')
op.drop_index(op.f('ix_product_subscription_version_end_transaction_id'), table_name='product_subscription_version')
op.drop_table('product_subscription_version')
op.drop_index(op.f('ix_product_subscription_role_version_transaction_id'),
table_name='product_subscription_role_version')
op.drop_index(op.f('ix_product_subscription_role_version_operation_type'),
table_name='product_subscription_role_version')
op.drop_index(op.f('ix_product_subscription_role_version_end_transaction_id'),
table_name='product_subscription_role_version')
op.drop_table('product_subscription_role_version')
op.drop_index(op.f('ix_org_version_transaction_id'), table_name='org_version')
op.drop_index(op.f('ix_org_version_operation_type'), table_name='org_version')
op.drop_index(op.f('ix_org_version_name'), table_name='org_version')
op.drop_index(op.f('ix_org_version_end_transaction_id'), table_name='org_version')
op.drop_index(op.f('ix_org_version_access_type'), table_name='org_version')
op.drop_table('org_version')
op.drop_index(op.f('ix_org_settings_version_transaction_id'), table_name='org_settings_version')
op.drop_index(op.f('ix_org_settings_version_operation_type'), table_name='org_settings_version')
op.drop_index(op.f('ix_org_settings_version_end_transaction_id'), table_name='org_settings_version')
op.drop_table('org_settings_version')
op.drop_index(op.f('ix_membership_version_transaction_id'), table_name='membership_version')
op.drop_index(op.f('ix_membership_version_operation_type'), table_name='membership_version')
op.drop_index(op.f('ix_membership_version_end_transaction_id'), table_name='membership_version')
op.drop_table('membership_version')
op.drop_index(op.f('ix_contact_version_transaction_id'), table_name='contact_version')
op.drop_index(op.f('ix_contact_version_street'), table_name='contact_version')
op.drop_index(op.f('ix_contact_version_operation_type'), table_name='contact_version')
op.drop_index(op.f('ix_contact_version_end_transaction_id'), table_name='contact_version')
op.drop_table('contact_version')
op.drop_index(op.f('ix_contact_link_version_transaction_id'), table_name='contact_link_version')
op.drop_index(op.f('ix_contact_link_version_operation_type'), table_name='contact_link_version')
op.drop_index(op.f('ix_contact_link_version_end_transaction_id'), table_name='contact_link_version')
op.drop_table('contact_link_version')
op.drop_index(op.f('ix_affiliation_version_transaction_id'), table_name='affiliation_version')
op.drop_index(op.f('ix_affiliation_version_operation_type'), table_name='affiliation_version')
op.drop_index(op.f('ix_affiliation_version_end_transaction_id'), table_name='affiliation_version')
op.drop_table('affiliation_version')
op.drop_index(op.f('ix_affidavit_version_transaction_id'), table_name='affidavit_version')
op.drop_index(op.f('ix_affidavit_version_operation_type'), table_name='affidavit_version')
op.drop_index(op.f('ix_affidavit_version_end_transaction_id'), table_name='affidavit_version')
op.drop_index(op.f('ix_affidavit_version_document_id'), table_name='affidavit_version')
op.drop_table('affidavit_version')
op.drop_index(op.f('ix_activity_transaction_id'), table_name='activity')
op.drop_table('activity')
op.drop_index(op.f('ix_account_payment_settings_version_transaction_id'),
table_name='account_payment_settings_version')
op.drop_index(op.f('ix_account_payment_settings_version_operation_type'),
table_name='account_payment_settings_version')
op.drop_index(op.f('ix_account_payment_settings_version_end_transaction_id'),
table_name='account_payment_settings_version')
op.drop_table('account_payment_settings_version')
op.drop_index(op.f('ix_account_login_options_version_transaction_id'), table_name='account_login_options_version')
op.drop_index(op.f('ix_account_login_options_version_operation_type'), table_name='account_login_options_version')
op.drop_index(op.f('ix_account_login_options_version_end_transaction_id'),
table_name='account_login_options_version')
op.drop_table('account_login_options_version')
# ### end Alembic commands ###