def downgrade():
op.create_table(
'team',
sa.Column('id',
sa.INTEGER(),
server_default=sa.text(u"nextval('team_id_seq'::regclass)"),
nullable=False),
sa.Column('created_at',
postgresql.TIMESTAMP(),
autoincrement=False,
nullable=False),
sa.Column('updated_at',
postgresql.TIMESTAMP(),
autoincrement=False,
nullable=False),
sa.Column('title',
sa.VARCHAR(length=250),
autoincrement=False,
nullable=False),
sa.Column('userid',
sa.VARCHAR(length=22),
autoincrement=False,
nullable=False),
sa.Column('owners', sa.BOOLEAN(), autoincrement=False, nullable=False),
sa.Column('orgid',
sa.VARCHAR(length=22),
autoincrement=False,
nullable=False),
sa.Column('members', sa.BOOLEAN(), autoincrement=False,
nullable=False),
sa.PrimaryKeyConstraint('id', name=u'team_pkey'),
postgresql_ignore_search_path=False)
op.create_table(
'organization',
sa.Column('id',
sa.INTEGER(),
server_default=sa.text(
u"nextval('organization_id_seq'::regclass)"),
nullable=False),
sa.Column('created_at',
postgresql.TIMESTAMP(),
autoincrement=False,
nullable=False),
sa.Column('updated_at',
postgresql.TIMESTAMP(),
autoincrement=False,
nullable=False),
sa.Column('domain',
sa.VARCHAR(length=253),
autoincrement=False,
nullable=True),
sa.Column('logo_image',
sa.VARCHAR(length=250),
autoincrement=False,
nullable=True),
sa.Column('cover_image',
sa.VARCHAR(length=250),
autoincrement=False,
nullable=True),
sa.Column('description',
sa.TEXT(),
autoincrement=False,
nullable=False),
sa.Column('status', sa.INTEGER(), autoincrement=False, nullable=False),
sa.Column('userid',
sa.VARCHAR(length=22),
autoincrement=False,
nullable=False),
sa.Column('name',
sa.VARCHAR(length=250),
autoincrement=False,
nullable=False),
sa.Column('title',
sa.VARCHAR(length=250),
autoincrement=False,
nullable=False),
sa.Column('admin_team_id',
sa.INTEGER(),
autoincrement=False,
nullable=True),
sa.Column('hiring_team_id',
sa.INTEGER(),
autoincrement=False,
nullable=True),
sa.ForeignKeyConstraint(['admin_team_id'], [u'team.id'],
name=u'organization_admin_team_id_fkey',
ondelete=u'SET NULL'),
sa.ForeignKeyConstraint(['hiring_team_id'], [u'team.id'],
name=u'organization_hiring_team_id_fkey',
ondelete=u'SET NULL'),
sa.PrimaryKeyConstraint('id', name=u'organization_pkey'),
postgresql_ignore_search_path=False)
op.create_table(
'org_location', sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('created_at',
postgresql.TIMESTAMP(),
autoincrement=False,
nullable=False),
sa.Column('updated_at',
postgresql.TIMESTAMP(),
autoincrement=False,
nullable=False),
sa.Column('latitude', sa.NUMERIC(), autoincrement=False,
nullable=True),
sa.Column('longitude',
sa.NUMERIC(),
autoincrement=False,
nullable=True),
sa.Column('org_id', sa.INTEGER(), autoincrement=False, nullable=False),
sa.Column('title',
sa.VARCHAR(length=80),
autoincrement=False,
nullable=True),
sa.Column('address1',
sa.VARCHAR(length=80),
autoincrement=False,
nullable=True),
sa.Column('address2',
sa.VARCHAR(length=80),
autoincrement=False,
nullable=True),
sa.Column('city',
sa.VARCHAR(length=80),
autoincrement=False,
nullable=True),
sa.Column('state',
sa.VARCHAR(length=80),
autoincrement=False,
nullable=True),
sa.Column('postcode',
sa.VARCHAR(length=16),
autoincrement=False,
nullable=True),
sa.Column('country',
sa.VARCHAR(length=80),
autoincrement=False,
nullable=True),
sa.Column('geonameid',
sa.INTEGER(),
autoincrement=False,
nullable=True),
sa.Column('url_id', sa.INTEGER(), autoincrement=False, nullable=False),
sa.ForeignKeyConstraint(['org_id'], [u'organization.id'],
name=u'org_location_org_id_fkey'),
sa.PrimaryKeyConstraint('id', name=u'org_location_pkey'))
op.create_table(
'users_teams',
sa.Column('created_at',
postgresql.TIMESTAMP(),
autoincrement=False,
nullable=False),
sa.Column('updated_at',
postgresql.TIMESTAMP(),
autoincrement=False,
nullable=False),
sa.Column('user_id', sa.INTEGER(), autoincrement=False,
nullable=False),
sa.Column('team_id', sa.INTEGER(), autoincrement=False,
nullable=False),
sa.ForeignKeyConstraint(['team_id'], [u'team.id'],
name=u'users_teams_team_id_fkey'),
sa.ForeignKeyConstraint(['user_id'], [u'user.id'],
name=u'users_teams_user_id_fkey'),
sa.PrimaryKeyConstraint('user_id', 'team_id',
name=u'users_teams_pkey'))
op.add_column(
'jobpost',
sa.Column('org_id', sa.INTEGER(), autoincrement=False, nullable=True))
op.create_foreign_key(u'jobpost_org_id_fkey', 'jobpost', 'organization',
['org_id'], ['id'])
op.create_index('ix_jobpost_org_id', 'jobpost', ['org_id'], unique=False)
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table(
'users', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('username', sa.String(length=50), nullable=False),
sa.Column('firstName', sa.String(length=50), nullable=False),
sa.Column('lastName', sa.String(length=50), nullable=False),
sa.Column('email', sa.String(length=255), nullable=False),
sa.Column('profileImg', sa.String(length=1000), nullable=False),
sa.Column('hashed_password', sa.String(length=255), nullable=False),
sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('email'),
sa.UniqueConstraint('username'))
op.create_table(
'recipes', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('description', sa.String(length=1000), nullable=False),
sa.Column('title', sa.String(length=1000), nullable=False),
sa.Column('vegetarian', sa.Boolean(), nullable=False),
sa.Column('time', sa.Integer(), nullable=False),
sa.Column('cheap', sa.Boolean(), nullable=False),
sa.Column('glutenfree', sa.Boolean(), nullable=False),
sa.Column('pricePerServing', sa.Numeric(), nullable=False),
sa.Column('servings', sa.Integer(), nullable=False),
sa.Column('image', sa.String(length=1000), nullable=False),
sa.Column('userId', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(
['userId'],
['users.id'],
), sa.PrimaryKeyConstraint('id'))
op.create_table('favorites',
sa.Column('recipeId', sa.Integer(), nullable=True),
sa.Column('userId', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(
['recipeId'],
['recipes.id'],
), sa.ForeignKeyConstraint(
['userId'],
['users.id'],
))
op.create_table(
'ingredients', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('recipeId', sa.Integer(), nullable=False),
sa.Column('ingredientName', sa.String(length=250), nullable=False),
sa.Column('amount', sa.Numeric(), nullable=False),
sa.Column('unit', sa.String(length=50), nullable=False),
sa.ForeignKeyConstraint(
['recipeId'],
['recipes.id'],
), sa.PrimaryKeyConstraint('id'))
op.create_table(
'instructions', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('recipeId', sa.Integer(), nullable=False),
sa.Column('listOrder', sa.Integer(), nullable=False),
sa.Column('specification', sa.String(length=1000), nullable=False),
sa.ForeignKeyConstraint(
['recipeId'],
['recipes.id'],
), sa.PrimaryKeyConstraint('id'))
op.create_table(
'reviews', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('overall', sa.Integer(), nullable=False),
sa.Column('review', sa.String(length=2500), nullable=False),
sa.Column('recipeId', sa.Integer(), nullable=False),
sa.Column('userId', sa.Integer(), nullable=False),
sa.ForeignKeyConstraint(
['recipeId'],
['recipes.id'],
), sa.ForeignKeyConstraint(
['userId'],
['users.id'],
), sa.PrimaryKeyConstraint('id'))
def upgrade():
# ## commands auto generated by Alembic - please adjust! ###
op.create_table('Bundles', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('lang', sa.Unicode(length=15), nullable=True),
sa.Column('target', sa.Unicode(length=30), nullable=True),
sa.Column('app_id', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(
['app_id'],
['Apps.id'],
), sa.PrimaryKeyConstraint('id'))
op.create_table('Messages', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('key', sa.Unicode(length=250), index=True),
sa.Column('value', sa.Text(), nullable=True),
sa.Column('bundle_id', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(
['bundle_id'],
['Bundles.id'],
), sa.PrimaryKeyConstraint('id'))
### end Alembic commands ###
metadata = sa.MetaData()
messages_table = sa.Table(
'Messages',
metadata,
sa.Column('key', sa.Unicode(250)),
sa.Column('value', sa.Text()),
sa.Column('bundle_id', sa.Integer()),
)
# To migrate we need to extract the data from the bundles of translator apps and to
# create the Message and Bundle objects.
connection = op.get_bind()
approws = connection.execute(
"SELECT * FROM Apps WHERE composer='translate'")
for pos, approw in enumerate(approws):
if pos % 10 == 0 and pos > 0:
print " %s..." % pos
continue
try:
data = json.loads(approw["data"])
app_id = approw["id"]
bundles = data["bundles"]
for bundle in data["bundles"]:
l, terr, group = bundle.split("_")
messages = data["bundles"][bundle]["messages"]
# Create the new Bundle object.
lang = "%s_%s" % (l, terr)
result = connection.execute(text(
"INSERT INTO Bundles (lang, target, app_id) VALUES (:lang, :target, :app_id)"
),
lang=lang,
target=group,
app_id=app_id)
bundle_id = result.lastrowid
# For each message in the bundle, create a Message object and link it to the bundle we just created.
for key, value in messages.items():
insertion = messages_table.insert().values(
key=key, value=value, bundle_id=bundle_id)
op.execute(insertion)
# result = connection.execute(text(u"INSERT INTO Messages (`key`, `value`, bundle_id) VALUES (:key, :value, :bundle_id)"),
# key=key, value=value, bundle_id=bundle_id)
# Delete the bundles.
del data["bundles"]
# Save the changes.
datastr = json.dumps(data)
result = connection.execute(
text(u"UPDATE Apps SET `data` = :data WHERE id = :app_id"),
data=datastr,
app_id=app_id)
except:
traceback.print_exc()
print "Exception on an app: %r" % approw["id"]
raise
# TODO: Remove dependencies on data urls.
print "[done]"
def upgrade_base():
op.create_table(
'networks',
sa.Column('tenant_id', sa.String(length=255), nullable=True),
sa.Column('id', sa.String(length=36), nullable=False),
sa.Column('name', sa.String(length=255), nullable=True),
sa.Column('status', sa.String(length=16), nullable=True),
sa.Column('admin_state_up', sa.Boolean(), nullable=True),
sa.Column('shared', sa.Boolean(), nullable=True),
sa.PrimaryKeyConstraint('id')
)
op.create_table(
'subnets',
sa.Column('tenant_id', sa.String(length=255), nullable=True),
sa.Column('id', sa.String(length=36), nullable=False),
sa.Column('name', sa.String(length=255), nullable=True),
sa.Column('network_id', sa.String(length=36), nullable=True),
sa.Column('ip_version', sa.Integer(), nullable=False),
sa.Column('cidr', sa.String(length=64), nullable=False),
sa.Column('gateway_ip', sa.String(length=64), nullable=True),
sa.Column('enable_dhcp', sa.Boolean(), nullable=True),
sa.Column('shared', sa.Boolean(), nullable=True),
sa.ForeignKeyConstraint(['network_id'], ['networks.id'], ),
sa.PrimaryKeyConstraint('id')
)
op.create_table(
'ports',
sa.Column('tenant_id', sa.String(length=255), nullable=True),
sa.Column('id', sa.String(length=36), nullable=False),
sa.Column('name', sa.String(length=255), nullable=True),
sa.Column('network_id', sa.String(length=36), nullable=False),
sa.Column('mac_address', sa.String(length=32), nullable=False),
sa.Column('admin_state_up', sa.Boolean(), nullable=False),
sa.Column('status', sa.String(length=16), nullable=False),
sa.Column('device_id', sa.String(length=255), nullable=False),
sa.Column('device_owner', sa.String(length=255), nullable=False),
sa.ForeignKeyConstraint(['network_id'], ['networks.id'], ),
sa.PrimaryKeyConstraint('id')
)
op.create_table(
'dnsnameservers',
sa.Column('address', sa.String(length=128), nullable=False),
sa.Column('subnet_id', sa.String(length=36), nullable=False),
sa.ForeignKeyConstraint(['subnet_id'], ['subnets.id'],
ondelete='CASCADE'),
sa.PrimaryKeyConstraint('address', 'subnet_id')
)
op.create_table(
'ipallocations',
sa.Column('port_id', sa.String(length=36), nullable=True),
sa.Column('ip_address', sa.String(length=64), nullable=False),
sa.Column('subnet_id', sa.String(length=36), nullable=False),
sa.Column('network_id', sa.String(length=36), nullable=False),
sa.Column('expiration', sa.DateTime(), nullable=True),
sa.ForeignKeyConstraint(['network_id'], ['networks.id'],
ondelete='CASCADE'),
sa.ForeignKeyConstraint(['port_id'], ['ports.id'],
ondelete='CASCADE'),
sa.ForeignKeyConstraint(['subnet_id'], ['subnets.id'],
ondelete='CASCADE'),
sa.PrimaryKeyConstraint('ip_address', 'subnet_id', 'network_id')
)
op.create_table(
'routes',
sa.Column('destination', sa.String(length=64), nullable=False),
sa.Column('nexthop', sa.String(length=64), nullable=False),
sa.Column('subnet_id', sa.String(length=36), nullable=False),
sa.ForeignKeyConstraint(['subnet_id'], ['subnets.id'],
ondelete='CASCADE'),
sa.PrimaryKeyConstraint('destination', 'nexthop', 'subnet_id')
)
op.create_table(
'ipallocationpools',
sa.Column('id', sa.String(length=36), nullable=False),
sa.Column('subnet_id', sa.String(length=36), nullable=True),
sa.Column('first_ip', sa.String(length=64), nullable=False),
sa.Column('last_ip', sa.String(length=64), nullable=False),
sa.ForeignKeyConstraint(['subnet_id'], ['subnets.id'],
ondelete='CASCADE'),
sa.PrimaryKeyConstraint('id')
)
op.create_table(
'ipavailabilityranges',
sa.Column('allocation_pool_id', sa.String(length=36), nullable=False),
sa.Column('first_ip', sa.String(length=64), nullable=False),
sa.Column('last_ip', sa.String(length=64), nullable=False),
sa.ForeignKeyConstraint(['allocation_pool_id'],
['ipallocationpools.id'],
ondelete='CASCADE'),
sa.PrimaryKeyConstraint('allocation_pool_id', 'first_ip', 'last_ip')
)
def upgrade_cisco():
op.create_table(
'cisco_vlan_ids',
sa.Column('vlan_id', sa.Integer(), autoincrement=True),
sa.Column('vlan_used', sa.Boolean()),
sa.PrimaryKeyConstraint('vlan_id')
)
op.create_table(
'cisco_vlan_bindings',
sa.Column('vlan_id', sa.Integer(), autoincrement=True),
sa.Column('vlan_name', sa.String(255)),
sa.Column('network_id', sa.String(255), nullable=False),
sa.PrimaryKeyConstraint('vlan_id')
)
op.create_table(
'portprofiles',
sa.Column('uuid', sa.String(255), nullable=False),
sa.Column('name', sa.String(255)),
sa.Column('vlan_id', sa.Integer()),
sa.Column('qos', sa.String(255)),
sa.PrimaryKeyConstraint('uuid')
)
op.create_table(
'portprofile_bindings',
sa.Column('id', sa.Integer(), autoincrement=True),
sa.Column('tenant_id', sa.String(255)),
sa.Column('port_id', sa.String(255), nullable=False),
sa.Column('portprofile_id', sa.String(255), nullable=False),
sa.Column('default', sa.Boolean()),
sa.PrimaryKeyConstraint('id'),
sa.ForeignKeyConstraint(['port_id'], ['ports.id'], ),
sa.ForeignKeyConstraint(['portprofile_id'], ['portprofiles.uuid'], ),
)
op.create_table(
'qoss', # yes two S's
sa.Column('qos_id', sa.String(255)),
sa.Column('tenant_id', sa.String(255)),
sa.Column('qos_name', sa.String(255)),
sa.Column('qos_desc', sa.String(255)),
sa.PrimaryKeyConstraint('tenant_id', 'qos_name')
)
op.create_table(
'credentials',
sa.Column('credential_id', sa.String(255)),
sa.Column('tenant_id', sa.String(255)),
sa.Column('credential_name', sa.String(255)),
sa.Column('user_name', sa.String(255)),
sa.Column('password', sa.String(255)),
sa.PrimaryKeyConstraint('tenant_id', 'credential_name')
)
op.create_table(
'port_bindings',
sa.Column('id', sa.Integer(), autoincrement=True),
sa.Column('port_id', sa.String(255), nullable=False),
sa.Column('blade_intf_dn', sa.String(255), nullable=False),
sa.Column('portprofile_name', sa.String(255)),
sa.Column('vlan_name', sa.String(255)),
sa.Column('vlan_id', sa.Integer()),
sa.Column('qos', sa.String(255)),
sa.Column('tenant_id', sa.String(255)),
sa.Column('instance_id', sa.String(255)),
sa.Column('vif_id', sa.String(255)),
sa.PrimaryKeyConstraint('id')
)
op.create_table(
'nexusport_bindings',
sa.Column('id', sa.Integer(), primary_key=True, autoincrement=True),
sa.Column('port_id', sa.String(255)),
sa.Column('vlan_id', sa.Integer(255)),
sa.PrimaryKeyConstraint('id')
)
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table(
'user', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('username', sa.String(length=50), nullable=False),
sa.Column('password',
sa.String(length=255),
server_default='',
nullable=False),
sa.Column('reset_password_token',
sa.String(length=100),
server_default='',
nullable=False),
sa.Column('email', sa.String(length=75), nullable=False),
sa.Column('confirmed_at', sa.DateTime(), nullable=True),
sa.Column('is_active',
sa.Boolean(),
server_default='0',
nullable=False),
sa.Column('first_name',
sa.String(length=100),
server_default='',
nullable=False),
sa.Column('last_name',
sa.String(length=100),
server_default='',
nullable=False),
sa.Column('string_property_01', sa.String(length=80), nullable=True),
sa.Column('string_property_02', sa.String(length=80), nullable=True),
sa.Column('string_property_03', sa.String(length=80), nullable=True),
sa.Column('string_property_04', sa.String(length=80), nullable=True),
sa.Column('string_property_05', sa.String(length=80), nullable=True),
sa.Column('integer_property_01', sa.Integer(), nullable=True),
sa.Column('integer_property_02', sa.Integer(), nullable=True),
sa.Column('integer_property_03', sa.Integer(), nullable=True),
sa.Column('integer_property_04', sa.Integer(), nullable=True),
sa.Column('integer_property_05', sa.Integer(), nullable=True),
sa.Column('integer_property_06', sa.Integer(), nullable=True),
sa.Column('integer_property_07', sa.Integer(), nullable=True),
sa.Column('integer_property_08', sa.Integer(), nullable=True),
sa.Column('integer_property_09', sa.Integer(), nullable=True),
sa.Column('integer_property_10', sa.Integer(), nullable=True),
sa.Column('boolean_property_01', sa.Boolean(), nullable=True),
sa.Column('boolean_property_02', sa.Boolean(), nullable=True),
sa.Column('boolean_property_03', sa.Boolean(), nullable=True),
sa.Column('boolean_property_04', sa.Boolean(), nullable=True),
sa.Column('boolean_property_05', sa.Boolean(), nullable=True),
sa.Column('boolean_property_06', sa.Boolean(), nullable=True),
sa.Column('boolean_property_07', sa.Boolean(), nullable=True),
sa.Column('boolean_property_08', sa.Boolean(), nullable=True),
sa.Column('boolean_property_09', sa.Boolean(), nullable=True),
sa.Column('boolean_property_10', sa.Boolean(), nullable=True),
sa.Column('boolean_property_11', sa.Boolean(), nullable=True),
sa.Column('boolean_property_12', sa.Boolean(), nullable=True),
sa.Column('boolean_property_13', sa.Boolean(), nullable=True),
sa.Column('boolean_property_14', sa.Boolean(), nullable=True),
sa.Column('boolean_property_15', sa.Boolean(), nullable=True),
sa.Column('boolean_property_16', sa.Boolean(), nullable=True),
sa.Column('boolean_property_17', sa.Boolean(), nullable=True),
sa.Column('boolean_property_18', sa.Boolean(), nullable=True),
sa.Column('boolean_property_19', sa.Boolean(), nullable=True),
sa.Column('boolean_property_20', sa.Boolean(), nullable=True),
sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('email'),
sa.UniqueConstraint('username'))
op.create_table('project', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('name', sa.String(length=50), nullable=False),
sa.Column('owner_id', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(
['owner_id'],
['user.id'],
), sa.PrimaryKeyConstraint('id'),
sa.UniqueConstraint('name'))
op.create_table('branch', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('name', sa.String(length=50), nullable=False),
sa.Column('owner_id', sa.Integer(), nullable=True),
sa.Column('origin_id', sa.Integer(), nullable=True),
sa.Column('project_id', sa.Integer(), nullable=True),
sa.Column('expires', sa.Boolean(), nullable=False),
sa.Column('expiration', sa.DateTime(), nullable=True),
sa.ForeignKeyConstraint(
['origin_id'],
['branch.id'],
), sa.ForeignKeyConstraint(
['owner_id'],
['user.id'],
), sa.ForeignKeyConstraint(
['project_id'],
['project.id'],
), sa.PrimaryKeyConstraint('id'))
op.create_table('named_tag', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('name', sa.String(length=20), nullable=False),
sa.Column('project_id', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(
['project_id'],
['project.id'],
), sa.PrimaryKeyConstraint('id'))
op.create_table('thread', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('title', sa.Unicode(length=80), nullable=False),
sa.Column('owner_id', sa.Integer(), nullable=True),
sa.Column('project_id', sa.Integer(), nullable=True),
sa.Column('flag', sa.String(length=10), nullable=False),
sa.Column('posted_at', sa.DateTime(), nullable=False),
sa.ForeignKeyConstraint(
['owner_id'],
['user.id'],
), sa.ForeignKeyConstraint(
['project_id'],
['project.id'],
), sa.PrimaryKeyConstraint('id'))
op.create_table(
'comment', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('lineage', sa.String(length=200), nullable=True),
sa.Column('thread_id', sa.Integer(), nullable=True),
sa.Column('owner_id', sa.Integer(), nullable=True),
sa.Column('content', sa.Unicode(length=2000), nullable=False),
sa.Column('posted_at', sa.DateTime(), nullable=False),
sa.ForeignKeyConstraint(
['owner_id'],
['user.id'],
), sa.ForeignKeyConstraint(
['thread_id'],
['thread.id'],
), sa.PrimaryKeyConstraint('id'))
op.create_table(
'custom_tag', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('thread_id', sa.Integer(), nullable=True),
sa.Column('named_tag_id', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(
['named_tag_id'],
['named_tag.id'],
), sa.ForeignKeyConstraint(
['thread_id'],
['thread.id'],
), sa.PrimaryKeyConstraint('id'))
op.create_table(
'file_tag', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('thread_id', sa.Integer(), nullable=True),
sa.Column('filename', sa.String(length=50), nullable=False),
sa.ForeignKeyConstraint(
['thread_id'],
['thread.id'],
), sa.PrimaryKeyConstraint('id'))
op.create_table('free_tag', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('thread_id', sa.Integer(), nullable=True),
sa.Column('name', sa.String(length=20), nullable=False),
sa.ForeignKeyConstraint(
['thread_id'],
['thread.id'],
), sa.PrimaryKeyConstraint('id'))
op.create_table('user_tag', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('thread_id', sa.Integer(), nullable=True),
sa.Column('user_id', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(
['thread_id'],
['thread.id'],
), sa.ForeignKeyConstraint(
['user_id'],
['user.id'],
), sa.PrimaryKeyConstraint('id'))
op.create_table('likes', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('comment_id', sa.Integer(), nullable=True),
sa.Column('owner_id', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(
['comment_id'],
['comment.id'],
), sa.ForeignKeyConstraint(
['owner_id'],
['user.id'],
), sa.PrimaryKeyConstraint('id'))
def upgrade():
### commands auto generated by Alembic - please adjust! ###
op.rename_table('user', 'temp_user')
op.create_table('users',
sa.Column('id', sa.Integer(), nullable=False, autoincrement=True),
sa.Column('email', sa.String(length=120), nullable=True),
sa.Column('password', sa.String(length=128), nullable=True),
sa.Column('reset_password', sa.String(length=128), nullable=True),
sa.Column('salt', sa.String(length=128), nullable=True),
sa.Column('avatar', sa.String(), nullable=True),
sa.Column('tokens', sa.Text(), nullable=True),
sa.Column('is_super_admin', sa.Boolean(), nullable=True),
sa.Column('is_admin', sa.Boolean(), nullable=True),
sa.Column('is_verified', sa.Boolean(), nullable=True),
sa.Column('signup_at', sa.DateTime(), nullable=True),
sa.Column('last_accessed_at', sa.DateTime(), nullable=True),
sa.Column('created_at', sa.DateTime(), nullable=True),
sa.Column('deleted_at', sa.DateTime(), nullable=True),
sa.Column('firstname', sa.String(), nullable=True),
sa.Column('lastname', sa.String(), nullable=True),
sa.Column('details', sa.String(), nullable=True),
sa.Column('contact', sa.String(), nullable=True),
sa.Column('facebook', sa.String(), nullable=True),
sa.Column('twitter', sa.String(), nullable=True),
sa.Column('instagram', sa.String(), nullable=True),
sa.Column('google', sa.String(), nullable=True),
sa.Column('avatar_uploaded', sa.String(), nullable=True),
sa.Column('thumbnail', sa.String(), nullable=True),
sa.Column('small', sa.String(), nullable=True),
sa.Column('icon', sa.String(), nullable=True),
sa.PrimaryKeyConstraint('id'),
sa.UniqueConstraint('email')
)
#for missing migrations from the naming schema refactor
op.drop_constraint(u'session_microlocation_id_fkey', 'sessions', type_='foreignkey')
op.create_foreign_key(u'sessions_microlocation_id_fkey', 'sessions', 'microlocations', ['microlocation_id'], ['id'], ondelete='CASCADE')
op.drop_constraint(u'session_session_type_id_fkey','sessions', type_='foreignkey')
op.create_foreign_key(u'sessions_session_type_id_fkey', 'sessions', 'session_types', ['session_type_id'], ['id'], ondelete = 'CASCADE')
op.drop_constraint(u'ticket_event_id_fkey', 'tickets', type_='foreignkey')
op.create_foreign_key(u'tickets_event_id_fkey', 'tickets', 'events', ['event_id'], ['id'], ondelete='CASCADE')
op.drop_constraint(u'eventsusers_event_id_fkey', 'event_user', type_='foreignkey')
op.create_foreign_key(u'event_user_event_id_fkey', 'event_user', 'events', ['event_id'], ['id'], ondelete='CASCADE')
op.drop_constraint(u'social_link_event_id_fkey', 'social_links', type_='foreignkey')
op.create_foreign_key(u'social_links_event_id_fkey', 'social_links', 'events', ['event_id'], ['id'], ondelete='CASCADE')
op.drop_constraint(u'role_invite_event_id_fkey', 'role_invites', type_='foreignkey')
op.create_foreign_key(u'role_invites_event_id_fkey', 'role_invites', 'events', ['event_id'], ['id'], ondelete='CASCADE')
op.drop_constraint(u'email_notification_event_id_fkey', 'email_notifications', type_='foreignkey')
op.create_foreign_key(u'email_notifications_event_id_fkey', 'email_notifications', 'events', ['event_id'], ['id'], ondelete='CASCADE')
op.drop_constraint(u'session_event_id_fkey', 'sessions', type_='foreignkey')
op.create_foreign_key(u'sessions_event_id_fkey', 'sessions', 'events', ['event_id'], ['id'], ondelete='CASCADE')
op.drop_constraint(u'session_type_event_id_fkey', 'session_types', type_='foreignkey')
op.create_foreign_key(u'session_types_event_id_fkey', 'session_types', 'events', ['event_id'], ['id'], ondelete='CASCADE')
op.drop_constraint(u'microlocation_event_id_fkey', 'microlocations', type_='foreignkey')
op.create_foreign_key(u'microlocations_event_id_fkey', 'microlocations', 'events', ['event_id'], ['id'], ondelete='CASCADE')
op.drop_constraint(u'event_copyright_event_id_fkey', 'event_copyrights', type_='foreignkey')
op.create_foreign_key(u'event_copyrights_event_id_fkey', 'event_copyrights', 'events', ['event_id'], ['id'], ondelete='CASCADE')
op.drop_constraint(u'role_invite_role_id_fkey', 'role_invites', type_='foreignkey')
op.create_foreign_key(u'role_invites_role_id_fkey', 'role_invites', 'roles', ['role_id'], ['id'], ondelete = 'CASCADE')
op.execute(
"INSERT INTO users SELECT temp_user.* , user_detail.firstname, user_detail.lastname, user_detail.details, user_detail.contact, user_detail.facebook, user_detail.twitter, user_detail.instagram, user_detail.google, user_detail.avatar_uploaded, user_detail.thumbnail, user_detail.small, user_detail.icon FROM temp_user INNER JOIN user_detail ON temp_user.id = user_detail.user_id",
execution_options=None)
op.drop_constraint(u'user_detail_user_id_fkey', 'user_detail', type_='foreignkey')
op.drop_constraint(u'access_codes_marketer_id_fkey', 'access_codes', type_='foreignkey')
op.create_foreign_key(u'access_codes_marketer_id_fkey', 'access_codes', 'users', ['marketer_id'], ['id'], ondelete='CASCADE')
op.drop_constraint(u'booked_ticket_user_id_fkey', 'booked_ticket', type_='foreignkey')
op.create_foreign_key(u'booked_ticket_user_id_fkey', 'booked_ticket', 'users', ['user_id'], ['id'], ondelete='CASCADE')
op.drop_constraint(u'discount_codes_marketer_id_fkey', 'discount_codes', type_='foreignkey')
op.create_foreign_key(u'discount_codes_marketer_id_fkey', 'discount_codes', 'users', ['marketer_id'], ['id'], ondelete='CASCADE')
op.drop_constraint(u'email_notification_user_id_fkey', 'email_notifications', type_='foreignkey')
op.create_foreign_key(u'email_notifications_user_id_fkey', 'email_notifications', 'users', ['user_id'], ['id'], ondelete='CASCADE')
op.drop_constraint(u'event_invoices_user_id_fkey', 'event_invoices', type_='foreignkey')
op.create_foreign_key(u'event_invoices_user_id_fkey', 'event_invoices', 'users', ['user_id'], ['id'], ondelete='SET NULL')
op.drop_constraint(u'eventsusers_user_id_fkey', 'event_user', type_='foreignkey')
op.create_foreign_key(u'event_user_user_id_fkey', 'event_user', 'users', ['user_id'], ['id'], ondelete='CASCADE')
op.drop_constraint(u'import_jobs_user_id_fkey', 'import_jobs', type_='foreignkey')
op.create_foreign_key(u'import_jobs_user_id_fkey', 'import_jobs', 'users', ['user_id'], ['id'], ondelete='CASCADE')
op.drop_constraint(u'invites_user_id_fkey', 'invites', type_='foreignkey')
op.create_foreign_key(u'invites_user_id_fkey', 'invites', 'users', ['user_id'], ['id'], ondelete='CASCADE')
op.drop_constraint(u'notification_user_id_fkey', 'notification', type_='foreignkey')
op.create_foreign_key(u'notification_user_id_fkey', 'notification', 'users', ['user_id'], ['id'], ondelete='CASCADE')
op.drop_constraint(u'orders_user_id_fkey', 'orders', type_='foreignkey')
op.drop_constraint(u'orders_marketer_id_fkey', 'orders', type_='foreignkey')
op.create_foreign_key(u'orders_user_id_fkey', 'orders', 'users', ['user_id'], ['id'], ondelete='SET NULL')
op.create_foreign_key(u'orders_marketer_id_fkey', 'orders', 'users', ['marketer_id'], ['id'], ondelete='SET NULL')
op.drop_constraint(u'speaker_user_id_fkey', 'speaker', type_='foreignkey')
op.create_foreign_key(u'speaker_user_id_fkey', 'speaker', 'users', ['user_id'], ['id'], ondelete='SET NULL')
op.drop_constraint(u'transaction_user_id_fkey', 'transaction', type_='foreignkey')
op.create_foreign_key(u'transaction_user_id_fkey', 'transaction', 'users', ['user_id'], ['id'])
op.drop_constraint(u'user_system_role_user_id_fkey', 'user_system_role', type_='foreignkey')
op.create_foreign_key(u'user_system_role_user_id_fkey', 'user_system_role', 'users', ['user_id'], ['id'], ondelete='CASCADE')
op.drop_constraint(u'users_events_roles_user_id_fkey', 'users_events_roles', type_='foreignkey')
op.create_foreign_key(u'users_events_roles_user_id_fkey', 'users_events_roles', 'users', ['user_id'], ['id'], ondelete='CASCADE')
op.drop_table('temp_user')
op.drop_table('user_detail')
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('ih_area_info',
sa.Column('create_time', sa.DateTime(), nullable=True),
sa.Column('update_time', sa.DateTime(), nullable=True),
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('name', sa.String(length=32), nullable=False),
sa.PrimaryKeyConstraint('id')
)
op.create_table('ih_facility_info',
sa.Column('create_time', sa.DateTime(), nullable=True),
sa.Column('update_time', sa.DateTime(), nullable=True),
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('name', sa.String(length=32), nullable=False),
sa.PrimaryKeyConstraint('id')
)
op.create_table('ih_user_profile',
sa.Column('create_time', sa.DateTime(), nullable=True),
sa.Column('update_time', sa.DateTime(), nullable=True),
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('name', sa.String(length=32), nullable=False),
sa.Column('password_hash', sa.String(length=128), nullable=False),
sa.Column('mobile', sa.String(length=11), nullable=False),
sa.Column('real_name', sa.String(length=32), nullable=True),
sa.Column('id_card', sa.String(length=20), nullable=True),
sa.Column('avatar_url', sa.String(length=128), nullable=True),
sa.PrimaryKeyConstraint('id'),
sa.UniqueConstraint('mobile'),
sa.UniqueConstraint('name')
)
op.create_table('ih_house_info',
sa.Column('create_time', sa.DateTime(), nullable=True),
sa.Column('update_time', sa.DateTime(), nullable=True),
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('user_id', sa.Integer(), nullable=False),
sa.Column('area_id', sa.Integer(), nullable=False),
sa.Column('title', sa.String(length=64), nullable=False),
sa.Column('price', sa.Integer(), nullable=True),
sa.Column('address', sa.String(length=512), nullable=True),
sa.Column('room_count', sa.Integer(), nullable=True),
sa.Column('acreage', sa.Integer(), nullable=True),
sa.Column('unit', sa.String(length=32), nullable=True),
sa.Column('capacity', sa.Integer(), nullable=True),
sa.Column('beds', sa.String(length=64), nullable=True),
sa.Column('deposit', sa.Integer(), nullable=True),
sa.Column('min_days', sa.Integer(), nullable=True),
sa.Column('max_days', sa.Integer(), nullable=True),
sa.Column('order_count', sa.Integer(), nullable=True),
sa.Column('index_image_url', sa.String(length=256), nullable=True),
sa.ForeignKeyConstraint(['area_id'], ['ih_area_info.id'], ),
sa.ForeignKeyConstraint(['user_id'], ['ih_user_profile.id'], ),
sa.PrimaryKeyConstraint('id')
)
op.create_table('ih_house_facility',
sa.Column('house_id', sa.Integer(), nullable=False),
sa.Column('facility_id', sa.Integer(), nullable=False),
sa.ForeignKeyConstraint(['facility_id'], ['ih_facility_info.id'], ),
sa.ForeignKeyConstraint(['house_id'], ['ih_house_info.id'], ),
sa.PrimaryKeyConstraint('house_id', 'facility_id')
)
op.create_table('ih_house_image',
sa.Column('create_time', sa.DateTime(), nullable=True),
sa.Column('update_time', sa.DateTime(), nullable=True),
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('house_id', sa.Integer(), nullable=False),
sa.Column('url', sa.String(length=256), nullable=False),
sa.ForeignKeyConstraint(['house_id'], ['ih_house_info.id'], ),
sa.PrimaryKeyConstraint('id')
)
op.create_table('ih_order_info',
sa.Column('create_time', sa.DateTime(), nullable=True),
sa.Column('update_time', sa.DateTime(), nullable=True),
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('user_id', sa.Integer(), nullable=False),
sa.Column('house_id', sa.Integer(), nullable=False),
sa.Column('begin_date', sa.DateTime(), nullable=False),
sa.Column('end_date', sa.DateTime(), nullable=False),
sa.Column('days', sa.Integer(), nullable=False),
sa.Column('house_price', sa.Integer(), nullable=False),
sa.Column('amount', sa.Integer(), nullable=False),
sa.Column('status', sa.Enum('WAIT_ACCEPT', 'WAIT_PAYMENT', 'PAID', 'WAIT_COMMENT', 'COMPLETE', 'CANCELED', 'REJECTED'), nullable=True),
sa.Column('comment', sa.Text(), nullable=True),
sa.ForeignKeyConstraint(['house_id'], ['ih_house_info.id'], ),
sa.ForeignKeyConstraint(['user_id'], ['ih_user_profile.id'], ),
sa.PrimaryKeyConstraint('id')
)
op.create_index(op.f('ix_ih_order_info_status'), 'ih_order_info', ['status'], unique=False)
def upgrade():
### commands auto generated by Alembic - please adjust! ###
op.create_table('service',
sa.Column('created', sa.DateTime(), nullable=True),
sa.Column('last_modified', sa.DateTime(), nullable=True),
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('name', sa.String(length=64), nullable=True),
sa.Column('description', sa.Text(), nullable=True),
sa.Column('logo_url', sa.String(length=128), nullable=True),
sa.Column('website_url', sa.String(length=128), nullable=True),
sa.Column('main_contact_name', sa.String(length=64), nullable=True),
sa.Column('main_contact_phone', sa.String(length=32), nullable=True),
sa.Column('has_screening_yn', sa.String(length=1), nullable=True),
sa.Column('fpl_cutoff', sa.Integer(), nullable=True),
sa.Column('uninsured_only_yn', sa.String(length=1), nullable=True),
sa.Column('medicaid_ineligible_only_yn', sa.String(length=1), nullable=True),
sa.Column('residence_requirement_yn', sa.String(length=1), nullable=True),
sa.Column('time_in_area_requirement_yn', sa.String(length=1), nullable=True),
sa.Column('last_modified_by_id', sa.Integer(), nullable=True),
sa.Column('created_by_id', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(['created_by_id'], ['app_user.id'], name='fk_created_by_id', use_alter=True),
sa.ForeignKeyConstraint(['last_modified_by_id'], ['app_user.id'], name='fk_last_modified_by_id', use_alter=True),
sa.PrimaryKeyConstraint('id')
)
op.create_table('role',
sa.Column('created', sa.DateTime(), nullable=True),
sa.Column('last_modified', sa.DateTime(), nullable=True),
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('name', sa.String(length=64), nullable=True),
sa.Column('description', sa.String(length=255), nullable=True),
sa.Column('default', sa.Boolean(), nullable=True),
sa.Column('last_modified_by_id', sa.Integer(), nullable=True),
sa.Column('created_by_id', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(['created_by_id'], ['app_user.id'], name='fk_created_by_id', use_alter=True),
sa.ForeignKeyConstraint(['last_modified_by_id'], ['app_user.id'], name='fk_last_modified_by_id', use_alter=True),
sa.PrimaryKeyConstraint('id'),
sa.UniqueConstraint('name')
)
op.create_index(op.f('ix_role_default'), 'role', ['default'], unique=False)
op.create_table('patient',
sa.Column('created', sa.DateTime(), nullable=True),
sa.Column('last_modified', sa.DateTime(), nullable=True),
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('full_name', sa.String(length=128), nullable=True),
sa.Column('first_name', sa.String(length=64), nullable=True),
sa.Column('middle_name', sa.String(length=64), nullable=True),
sa.Column('last_name', sa.String(length=64), nullable=True),
sa.Column('dob', sa.Date(), nullable=True),
sa.Column('ssn', sa.String(length=11), nullable=True),
sa.Column('email', sa.String(length=64), nullable=True),
sa.Column('gender', sa.String(length=2), nullable=True),
sa.Column('transgender', sa.String(length=3), nullable=True),
sa.Column('race', sa.String(length=16), nullable=True),
sa.Column('race_other', sa.String(length=32), nullable=True),
sa.Column('ethnicity', sa.String(length=32), nullable=True),
sa.Column('languages', sa.String(length=64), nullable=True),
sa.Column('languages_other', sa.String(length=64), nullable=True),
sa.Column('has_interpreter_yn', sa.String(length=1), nullable=True),
sa.Column('education_level', sa.String(length=16), nullable=True),
sa.Column('marital_status', sa.String(length=16), nullable=True),
sa.Column('veteran_yn', sa.String(length=1), nullable=True),
sa.Column('housing_status', sa.String(length=16), nullable=True),
sa.Column('housing_status_other', sa.String(length=32), nullable=True),
sa.Column('time_in_area', sa.String(length=16), nullable=True),
sa.Column('city_or_county_of_residence', sa.String(length=64), nullable=True),
sa.Column('temp_visa_yn', sa.String(length=1), nullable=True),
sa.Column('has_transport_yn', sa.String(length=1), nullable=True),
sa.Column('student_status', sa.String(length=16), nullable=True),
sa.Column('employment_status', sa.String(length=16), nullable=True),
sa.Column('years_unemployed', sa.Integer(), nullable=True),
sa.Column('months_unemployed', sa.Integer(), nullable=True),
sa.Column('employment_changes', sa.String(length=32), nullable=True),
sa.Column('spouse_employment_status', sa.String(length=16), nullable=True),
sa.Column('spouse_years_unemployed', sa.Integer(), nullable=True),
sa.Column('spouse_months_unemployed', sa.Integer(), nullable=True),
sa.Column('spouse_employment_changes', sa.String(length=16), nullable=True),
sa.Column('years_at_current_employer', sa.String(length=32), nullable=True),
sa.Column('spouse_years_at_current_employer', sa.String(length=32), nullable=True),
sa.Column('last_healthcare', sa.String(length=128), nullable=True),
sa.Column('insurance_status', sa.String(length=32), nullable=True),
sa.Column('coverage_type', sa.String(length=32), nullable=True),
sa.Column('coverage_type_other', sa.String(length=32), nullable=True),
sa.Column('has_prescription_coverage_yn', sa.String(length=1), nullable=True),
sa.Column('has_vcc', sa.String(length=1), nullable=True),
sa.Column('has_pcp_yn', sa.String(length=1), nullable=True),
sa.Column('has_psychiatrist_yn', sa.String(length=1), nullable=True),
sa.Column('wants_psychiatrist_yn', sa.String(length=1), nullable=True),
sa.Column('eligible_insurance_types', sa.String(length=64), nullable=True),
sa.Column('applied_for_vets_benefits_yn', sa.String(length=1), nullable=True),
sa.Column('eligible_for_vets_benefits_yn', sa.String(length=1), nullable=True),
sa.Column('applied_for_medicaid_yn', sa.String(length=1), nullable=True),
sa.Column('denied_medicaid_yn', sa.String(length=1), nullable=True),
sa.Column('medicaid_date_effective', sa.Date(), nullable=True),
sa.Column('applied_for_ssd_yn', sa.String(length=1), nullable=True),
sa.Column('ssd_date_effective', sa.Date(), nullable=True),
sa.Column('care_due_to_accident_yn', sa.String(length=1), nullable=True),
sa.Column('accident_work_related_yn', sa.String(length=1), nullable=True),
sa.Column('recently_lost_insurance_yn', sa.String(length=1), nullable=True),
sa.Column('head_of_household_yn', sa.String(length=1), nullable=True),
sa.Column('filed_taxes_yn', sa.String(length=1), nullable=True),
sa.Column('claimed_as_dependent_yn', sa.String(length=1), nullable=True),
sa.Column('how_food_and_shelter', sa.String(length=128), nullable=True),
sa.Column('how_other_expenses', sa.String(length=128), nullable=True),
sa.Column('last_modified_by_id', sa.Integer(), nullable=True),
sa.Column('created_by_id', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(['created_by_id'], ['app_user.id'], name='fk_created_by_id', use_alter=True),
sa.ForeignKeyConstraint(['last_modified_by_id'], ['app_user.id'], name='fk_last_modified_by_id', use_alter=True),
sa.PrimaryKeyConstraint('id')
)
op.create_table('document_image',
sa.Column('created', sa.DateTime(), nullable=True),
sa.Column('last_modified', sa.DateTime(), nullable=True),
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('patient_id', sa.Integer(), nullable=True),
sa.Column('file_name', sa.String(length=64), nullable=True),
sa.Column('file_description', sa.String(length=64), nullable=True),
sa.Column('data_full', sa.LargeBinary(), nullable=True),
sa.Column('data_large', sa.LargeBinary(), nullable=True),
sa.Column('data_small', sa.LargeBinary(), nullable=True),
sa.Column('last_modified_by_id', sa.Integer(), nullable=True),
sa.Column('created_by_id', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(['created_by_id'], ['app_user.id'], name='fk_created_by_id', use_alter=True),
sa.ForeignKeyConstraint(['last_modified_by_id'], ['app_user.id'], name='fk_last_modified_by_id', use_alter=True),
sa.ForeignKeyConstraint(['patient_id'], ['patient.id'], ),
sa.PrimaryKeyConstraint('id')
)
op.create_table('employer',
sa.Column('created', sa.DateTime(), nullable=True),
sa.Column('last_modified', sa.DateTime(), nullable=True),
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('patient_id', sa.Integer(), nullable=True),
sa.Column('employer_name', sa.String(length=64), nullable=True),
sa.Column('phone_number', sa.String(length=32), nullable=True),
sa.Column('employee', sa.String(length=16), nullable=True),
sa.Column('start_date', sa.Date(), nullable=True),
sa.Column('last_modified_by_id', sa.Integer(), nullable=True),
sa.Column('created_by_id', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(['created_by_id'], ['app_user.id'], name='fk_created_by_id', use_alter=True),
sa.ForeignKeyConstraint(['last_modified_by_id'], ['app_user.id'], name='fk_last_modified_by_id', use_alter=True),
sa.ForeignKeyConstraint(['patient_id'], ['patient.id'], ),
sa.PrimaryKeyConstraint('id')
)
op.create_table('emergency_contact',
sa.Column('created', sa.DateTime(), nullable=True),
sa.Column('last_modified', sa.DateTime(), nullable=True),
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('patient_id', sa.Integer(), nullable=True),
sa.Column('full_name', sa.String(length=64), nullable=True),
sa.Column('relationship', sa.String(length=64), nullable=True),
sa.Column('phone_number', sa.String(length=32), nullable=True),
sa.Column('last_modified_by_id', sa.Integer(), nullable=True),
sa.Column('created_by_id', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(['created_by_id'], ['app_user.id'], name='fk_created_by_id', use_alter=True),
sa.ForeignKeyConstraint(['last_modified_by_id'], ['app_user.id'], name='fk_last_modified_by_id', use_alter=True),
sa.ForeignKeyConstraint(['patient_id'], ['patient.id'], ),
sa.PrimaryKeyConstraint('id')
)
op.create_table('referral_permission',
sa.Column('created', sa.DateTime(), nullable=True),
sa.Column('last_modified', sa.DateTime(), nullable=True),
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('from_service_id', sa.Integer(), nullable=True),
sa.Column('to_service_id', sa.Integer(), nullable=True),
sa.Column('last_modified_by_id', sa.Integer(), nullable=True),
sa.Column('created_by_id', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(['created_by_id'], ['app_user.id'], name='fk_created_by_id', use_alter=True),
sa.ForeignKeyConstraint(['from_service_id'], ['service.id'], ),
sa.ForeignKeyConstraint(['last_modified_by_id'], ['app_user.id'], name='fk_last_modified_by_id', use_alter=True),
sa.ForeignKeyConstraint(['to_service_id'], ['service.id'], ),
sa.PrimaryKeyConstraint('id')
)
op.create_table('address',
sa.Column('created', sa.DateTime(), nullable=True),
sa.Column('last_modified', sa.DateTime(), nullable=True),
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('patient_id', sa.Integer(), nullable=True),
sa.Column('address1', sa.String(length=64), nullable=True),
sa.Column('address2', sa.String(length=64), nullable=True),
sa.Column('city', sa.String(length=64), nullable=True),
sa.Column('state', sa.String(length=2), nullable=True),
sa.Column('zip_code', sa.String(length=10), nullable=True),
sa.Column('address_description', sa.String(length=64), nullable=True),
sa.Column('address_description_other', sa.String(length=64), nullable=True),
sa.Column('last_modified_by_id', sa.Integer(), nullable=True),
sa.Column('created_by_id', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(['created_by_id'], ['app_user.id'], name='fk_created_by_id', use_alter=True),
sa.ForeignKeyConstraint(['last_modified_by_id'], ['app_user.id'], name='fk_last_modified_by_id', use_alter=True),
sa.ForeignKeyConstraint(['patient_id'], ['patient.id'], ),
sa.PrimaryKeyConstraint('id')
)
op.create_table('service_referral_email',
sa.Column('created', sa.DateTime(), nullable=True),
sa.Column('last_modified', sa.DateTime(), nullable=True),
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('service_id', sa.Integer(), nullable=True),
sa.Column('email', sa.String(length=64), nullable=True),
sa.Column('last_modified_by_id', sa.Integer(), nullable=True),
sa.Column('created_by_id', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(['created_by_id'], ['app_user.id'], name='fk_created_by_id', use_alter=True),
sa.ForeignKeyConstraint(['last_modified_by_id'], ['app_user.id'], name='fk_last_modified_by_id', use_alter=True),
sa.ForeignKeyConstraint(['service_id'], ['service.id'], ondelete='CASCADE'),
sa.PrimaryKeyConstraint('id')
)
op.create_table('service_location',
sa.Column('created', sa.DateTime(), nullable=True),
sa.Column('last_modified', sa.DateTime(), nullable=True),
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('service_id', sa.Integer(), nullable=True),
sa.Column('name', sa.String(length=64), nullable=True),
sa.Column('contact_name', sa.String(length=64), nullable=True),
sa.Column('phone_number', sa.String(length=32), nullable=True),
sa.Column('address', sa.String(length=64), nullable=True),
sa.Column('latitude', sa.Float(), nullable=True),
sa.Column('longitude', sa.Float(), nullable=True),
sa.Column('last_modified_by_id', sa.Integer(), nullable=True),
sa.Column('created_by_id', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(['created_by_id'], ['app_user.id'], name='fk_created_by_id', use_alter=True),
sa.ForeignKeyConstraint(['last_modified_by_id'], ['app_user.id'], name='fk_last_modified_by_id', use_alter=True),
sa.ForeignKeyConstraint(['service_id'], ['service.id'], ondelete='CASCADE'),
sa.PrimaryKeyConstraint('id')
)
op.create_table('sliding_scale',
sa.Column('created', sa.DateTime(), nullable=True),
sa.Column('last_modified', sa.DateTime(), nullable=True),
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('service_id', sa.Integer(), nullable=True),
sa.Column('scale_name', sa.String(length=64), nullable=True),
sa.Column('fpl_low', sa.Float(), nullable=True),
sa.Column('fpl_high', sa.Float(), nullable=True),
sa.Column('last_modified_by_id', sa.Integer(), nullable=True),
sa.Column('created_by_id', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(['created_by_id'], ['app_user.id'], name='fk_created_by_id', use_alter=True),
sa.ForeignKeyConstraint(['last_modified_by_id'], ['app_user.id'], name='fk_last_modified_by_id', use_alter=True),
sa.ForeignKeyConstraint(['service_id'], ['service.id'], ondelete='CASCADE'),
sa.PrimaryKeyConstraint('id')
)
op.create_table('household_member',
sa.Column('created', sa.DateTime(), nullable=True),
sa.Column('last_modified', sa.DateTime(), nullable=True),
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('patient_id', sa.Integer(), nullable=True),
sa.Column('full_name', sa.String(length=64), nullable=True),
sa.Column('dob', sa.Date(), nullable=True),
sa.Column('ssn', sa.String(length=11), nullable=True),
sa.Column('relationship', sa.String(length=32), nullable=True),
sa.Column('last_modified_by_id', sa.Integer(), nullable=True),
sa.Column('created_by_id', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(['created_by_id'], ['app_user.id'], name='fk_created_by_id', use_alter=True),
sa.ForeignKeyConstraint(['last_modified_by_id'], ['app_user.id'], name='fk_last_modified_by_id', use_alter=True),
sa.ForeignKeyConstraint(['patient_id'], ['patient.id'], ),
sa.PrimaryKeyConstraint('id')
)
op.create_table('phone_number',
sa.Column('created', sa.DateTime(), nullable=True),
sa.Column('last_modified', sa.DateTime(), nullable=True),
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('patient_id', sa.Integer(), nullable=True),
sa.Column('phone_number', sa.String(length=32), nullable=True),
sa.Column('number_description', sa.String(length=64), nullable=True),
sa.Column('number_description_other', sa.String(length=64), nullable=True),
sa.Column('primary_yn', sa.String(length=1), nullable=True),
sa.Column('last_modified_by_id', sa.Integer(), nullable=True),
sa.Column('created_by_id', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(['created_by_id'], ['app_user.id'], name='fk_created_by_id', use_alter=True),
sa.ForeignKeyConstraint(['last_modified_by_id'], ['app_user.id'], name='fk_last_modified_by_id', use_alter=True),
sa.ForeignKeyConstraint(['patient_id'], ['patient.id'], ),
sa.PrimaryKeyConstraint('id')
)
op.create_table('app_user',
sa.Column('created', sa.DateTime(), nullable=True),
sa.Column('last_modified', sa.DateTime(), nullable=True),
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('email', sa.String(length=64), nullable=True),
sa.Column('password', sa.String(length=128), nullable=True),
sa.Column('authenticated', sa.Boolean(), nullable=True),
sa.Column('active', sa.Boolean(), nullable=True),
sa.Column('confirmed_at', sa.DateTime(), nullable=True),
sa.Column('last_login_at', sa.DateTime(), nullable=True),
sa.Column('current_login_at', sa.DateTime(), nullable=True),
sa.Column('last_login_ip', sa.String(length=16), nullable=True),
sa.Column('current_login_ip', sa.String(length=16), nullable=True),
sa.Column('login_count', sa.Integer(), nullable=True),
sa.Column('service_id', sa.Integer(), nullable=True),
sa.Column('full_name', sa.String(length=64), nullable=True),
sa.Column('phone_number', sa.String(length=32), nullable=True),
sa.Column('patient_id', sa.Integer(), nullable=True),
sa.Column('last_modified_by_id', sa.Integer(), nullable=True),
sa.Column('created_by_id', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(['created_by_id'], ['app_user.id'], name='fk_created_by_id', use_alter=True),
sa.ForeignKeyConstraint(['last_modified_by_id'], ['app_user.id'], name='fk_last_modified_by_id', use_alter=True),
sa.ForeignKeyConstraint(['patient_id'], ['patient.id'], ),
sa.ForeignKeyConstraint(['service_id'], ['service.id'], ondelete='CASCADE'),
sa.PrimaryKeyConstraint('id')
)
op.create_table('income_source',
sa.Column('created', sa.DateTime(), nullable=True),
sa.Column('last_modified', sa.DateTime(), nullable=True),
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('patient_id', sa.Integer(), nullable=True),
sa.Column('source', sa.String(length=64), nullable=True),
sa.Column('monthly_amount', sa.Integer(), nullable=True),
sa.Column('last_modified_by_id', sa.Integer(), nullable=True),
sa.Column('created_by_id', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(['created_by_id'], ['app_user.id'], name='fk_created_by_id', use_alter=True),
sa.ForeignKeyConstraint(['last_modified_by_id'], ['app_user.id'], name='fk_last_modified_by_id', use_alter=True),
sa.ForeignKeyConstraint(['patient_id'], ['patient.id'], ),
sa.PrimaryKeyConstraint('id')
)
op.create_table('service_translation',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('service_id', sa.Integer(), nullable=True),
sa.Column('language_code', sa.String(length=16), nullable=True),
sa.Column('description', sa.Text(), nullable=True),
sa.ForeignKeyConstraint(['service_id'], ['service.id'], ondelete='CASCADE'),
sa.PrimaryKeyConstraint('id')
)
op.create_table('patient_screening_result',
sa.Column('created', sa.DateTime(), nullable=True),
sa.Column('last_modified', sa.DateTime(), nullable=True),
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('patient_id', sa.Integer(), nullable=True),
sa.Column('service_id', sa.Integer(), nullable=True),
sa.Column('eligible_yn', sa.String(length=1), nullable=True),
sa.Column('sliding_scale_id', sa.Integer(), nullable=True),
sa.Column('notes', sa.Text(), nullable=True),
sa.Column('last_modified_by_id', sa.Integer(), nullable=True),
sa.Column('created_by_id', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(['created_by_id'], ['app_user.id'], name='fk_created_by_id', use_alter=True),
sa.ForeignKeyConstraint(['last_modified_by_id'], ['app_user.id'], name='fk_last_modified_by_id', use_alter=True),
sa.ForeignKeyConstraint(['patient_id'], ['patient.id'], ),
sa.ForeignKeyConstraint(['service_id'], ['service.id'], ),
sa.ForeignKeyConstraint(['sliding_scale_id'], ['sliding_scale.id'], ),
sa.PrimaryKeyConstraint('id')
)
op.create_table('roles_users',
sa.Column('created', sa.DateTime(), nullable=True),
sa.Column('last_modified', sa.DateTime(), nullable=True),
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('app_user_id', sa.Integer(), nullable=True),
sa.Column('role_id', sa.Integer(), nullable=True),
sa.Column('last_modified_by_id', sa.Integer(), nullable=True),
sa.Column('created_by_id', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(['app_user_id'], ['app_user.id'], ),
sa.ForeignKeyConstraint(['created_by_id'], ['app_user.id'], name='fk_created_by_id', use_alter=True),
sa.ForeignKeyConstraint(['last_modified_by_id'], ['app_user.id'], name='fk_last_modified_by_id', use_alter=True),
sa.ForeignKeyConstraint(['role_id'], ['role.id'], ),
sa.PrimaryKeyConstraint('id')
)
op.create_table('sliding_scale_fee',
sa.Column('created', sa.DateTime(), nullable=True),
sa.Column('last_modified', sa.DateTime(), nullable=True),
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('sliding_scale_id', sa.Integer(), nullable=True),
sa.Column('name', sa.String(length=128), nullable=True),
sa.Column('price_absolute', sa.Integer(), nullable=True),
sa.Column('price_percentage', sa.Integer(), nullable=True),
sa.Column('last_modified_by_id', sa.Integer(), nullable=True),
sa.Column('created_by_id', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(['created_by_id'], ['app_user.id'], name='fk_created_by_id', use_alter=True),
sa.ForeignKeyConstraint(['last_modified_by_id'], ['app_user.id'], name='fk_last_modified_by_id', use_alter=True),
sa.ForeignKeyConstraint(['sliding_scale_id'], ['sliding_scale.id'], ondelete='CASCADE'),
sa.PrimaryKeyConstraint('id')
)
op.create_table('patient_referral',
sa.Column('created', sa.DateTime(), nullable=True),
sa.Column('last_modified', sa.DateTime(), nullable=True),
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('patient_id', sa.Integer(), nullable=True),
sa.Column('from_app_user_id', sa.Integer(), nullable=True),
sa.Column('to_service_id', sa.Integer(), nullable=True),
sa.Column('status', sa.String(length=9), nullable=True),
sa.Column('notes', sa.Text(), nullable=True),
sa.Column('last_modified_by_id', sa.Integer(), nullable=True),
sa.Column('created_by_id', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(['created_by_id'], ['app_user.id'], name='fk_created_by_id', use_alter=True),
sa.ForeignKeyConstraint(['from_app_user_id'], ['app_user.id'], ),
sa.ForeignKeyConstraint(['last_modified_by_id'], ['app_user.id'], name='fk_last_modified_by_id', use_alter=True),
sa.ForeignKeyConstraint(['patient_id'], ['patient.id'], ),
sa.ForeignKeyConstraint(['to_service_id'], ['service.id'], ),
sa.PrimaryKeyConstraint('id')
)
op.create_table('action_log',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('transaction_id', sa.Integer(), nullable=True),
sa.Column('action_timestamp', sa.DateTime(), nullable=True),
sa.Column('table_name', sa.String(length=64), nullable=True),
sa.Column('row_id', sa.Integer(), nullable=True),
sa.Column('app_user_id', sa.Integer(), nullable=True),
sa.Column('action', sa.String(length=1), nullable=True),
sa.Column('row_data', postgresql.HSTORE(), nullable=True),
sa.Column('changed_fields', postgresql.HSTORE(), nullable=True),
sa.ForeignKeyConstraint(['app_user_id'], ['app_user.id'], ),
sa.PrimaryKeyConstraint('id')
)
op.create_table('unsaved_form',
sa.Column('created', sa.DateTime(), nullable=True),
sa.Column('last_modified', sa.DateTime(), nullable=True),
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('app_user_id', sa.Integer(), nullable=True),
sa.Column('patient_id', sa.Integer(), nullable=True),
sa.Column('page_name', sa.String(length=128), nullable=True),
sa.Column('form_json', postgresql.JSON(), nullable=True),
sa.Column('last_modified_by_id', sa.Integer(), nullable=True),
sa.Column('created_by_id', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(['app_user_id'], ['app_user.id'], ),
sa.ForeignKeyConstraint(['created_by_id'], ['app_user.id'], name='fk_created_by_id', use_alter=True),
sa.ForeignKeyConstraint(['last_modified_by_id'], ['app_user.id'], name='fk_last_modified_by_id', use_alter=True),
sa.ForeignKeyConstraint(['patient_id'], ['patient.id'], ),
sa.PrimaryKeyConstraint('id')
)
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table(
"set",
sa.Column(
"uuid",
postgresql.UUID(as_uuid=True),
server_default=sa.text("uuid_generate_v4()"),
nullable=False,
),
sa.Column("name", sa.String(), nullable=False),
sa.Column("bonuses", sa.PickleType(), nullable=True),
sa.PrimaryKeyConstraint("uuid"),
)
op.create_table(
"user",
sa.Column(
"uuid",
postgresql.UUID(as_uuid=True),
server_default=sa.text("uuid_generate_v4()"),
nullable=False,
),
sa.Column("username", sa.String(), nullable=False),
sa.Column("email", sa.String(), nullable=False),
sa.PrimaryKeyConstraint("uuid"),
)
op.create_table(
"custom_set",
sa.Column(
"uuid",
postgresql.UUID(as_uuid=True),
server_default=sa.text("uuid_generate_v4()"),
nullable=False,
),
sa.Column("name", sa.String(), nullable=True),
sa.Column("description", sa.String(), nullable=True),
sa.Column("owner_id", postgresql.UUID(), nullable=True),
sa.Column("creation_date", sa.DateTime(), nullable=True),
sa.Column("level", sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(["owner_id"], ["user.uuid"],),
sa.PrimaryKeyConstraint("uuid"),
)
op.create_table(
"custom_set_exos",
sa.Column(
"uuid",
postgresql.UUID(as_uuid=True),
server_default=sa.text("uuid_generate_v4()"),
nullable=False,
),
sa.Column("stat", sa.String(), nullable=True),
sa.Column("value", sa.Integer(), nullable=True),
sa.Column("custom_set_id", postgresql.UUID(), nullable=True),
sa.ForeignKeyConstraint(["custom_set_id"], ["custom_set.uuid"],),
sa.PrimaryKeyConstraint("uuid"),
)
op.create_table(
"custom_set_stats",
sa.Column(
"uuid",
postgresql.UUID(as_uuid=True),
server_default=sa.text("uuid_generate_v4()"),
nullable=False,
),
sa.Column("scrolledVitality", sa.Integer(), nullable=True),
sa.Column("scrolledWisdom", sa.Integer(), nullable=True),
sa.Column("scrolledStrength", sa.Integer(), nullable=True),
sa.Column("scrolledIntelligence", sa.Integer(), nullable=True),
sa.Column("scrolledChance", sa.Integer(), nullable=True),
sa.Column("scrolledAgility", sa.Integer(), nullable=True),
sa.Column("baseVitality", sa.Integer(), nullable=True),
sa.Column("baseWisdom", sa.Integer(), nullable=True),
sa.Column("baseStrength", sa.Integer(), nullable=True),
sa.Column("baseIntelligence", sa.Integer(), nullable=True),
sa.Column("baseChance", sa.Integer(), nullable=True),
sa.Column("baseAgility", sa.Integer(), nullable=True),
sa.Column("custom_set_id", postgresql.UUID(), nullable=True),
sa.ForeignKeyConstraint(["custom_set_id"], ["custom_set.uuid"],),
sa.PrimaryKeyConstraint("uuid"),
)
op.create_table(
"item",
sa.Column(
"uuid",
postgresql.UUID(as_uuid=True),
server_default=sa.text("uuid_generate_v4()"),
nullable=False,
),
sa.Column("name", sa.String(), nullable=False),
sa.Column("itemType", sa.String(), nullable=False),
sa.Column("set_id", postgresql.UUID(), nullable=True),
sa.Column("level", sa.Integer(), nullable=False),
sa.Column("imageUrl", sa.String(), nullable=True),
sa.Column("custom_set_id", postgresql.UUID(), nullable=True),
sa.ForeignKeyConstraint(["custom_set_id"], ["custom_set.uuid"],),
sa.ForeignKeyConstraint(["set_id"], ["set.uuid"],),
sa.PrimaryKeyConstraint("uuid"),
)
op.create_table(
"item_conditions",
sa.Column(
"uuid",
postgresql.UUID(as_uuid=True),
server_default=sa.text("uuid_generate_v4()"),
nullable=False,
),
sa.Column("item_id", postgresql.UUID(), nullable=True),
sa.Column("stat_type", sa.String(), nullable=True),
sa.Column("conditionType", sa.String(), nullable=True),
sa.Column("limit", sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(["item_id"], ["item.uuid"],),
sa.PrimaryKeyConstraint("uuid"),
)
op.create_table(
"item_stats",
sa.Column(
"uuid",
postgresql.UUID(as_uuid=True),
server_default=sa.text("uuid_generate_v4()"),
nullable=False,
),
sa.Column("item_id", postgresql.UUID(), nullable=True),
sa.Column("stat", sa.String(), nullable=True),
sa.Column("minValue", sa.Integer(), nullable=True),
sa.Column("maxValue", sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(["item_id"], ["item.uuid"],),
sa.PrimaryKeyConstraint("uuid"),
)
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table(
'modifiers', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('mod', sa.Integer(), nullable=False),
sa.Column('type', sa.String(length=50), nullable=True),
sa.Column('is_slot_activated', sa.Boolean(), nullable=True),
sa.PrimaryKeyConstraint('id'))
op.create_table(
'users', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('username', sa.String(length=50), nullable=False),
sa.Column('email', sa.String(length=250), nullable=False),
sa.Column('hashword', sa.String(length=250), nullable=False),
sa.Column('created_at', sa.DateTime(), nullable=False),
sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('email'),
sa.UniqueConstraint('username'))
op.create_table(
'assets', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('user_id', sa.Integer(), nullable=False),
sa.Column('category', sa.String(length=50), nullable=True),
sa.Column('title', sa.String(length=50), nullable=False),
sa.Column('description', sa.String(), nullable=False),
sa.Column('color', sa.String(length=50), nullable=True),
sa.Column('icon', sa.String(length=50), nullable=True),
sa.Column('image', sa.String(length=250), nullable=True),
sa.Column('created_at', sa.DateTime(), nullable=False),
sa.Column('value', sa.Integer(), nullable=True),
sa.Column('max', sa.Integer(), nullable=True),
sa.Column('is_allowed_multiple', sa.Boolean(), nullable=False),
sa.ForeignKeyConstraint(
['user_id'],
['users.id'],
), sa.PrimaryKeyConstraint('id'))
op.create_table('chronicles', sa.Column('id', sa.Integer(),
nullable=False),
sa.Column('user_id', sa.Integer(), nullable=False),
sa.Column('title', sa.String(length=50), nullable=False),
sa.Column('description', sa.String(), nullable=False),
sa.Column('color', sa.String(length=50), nullable=True),
sa.Column('icon', sa.String(length=50), nullable=True),
sa.Column('image', sa.String(length=250), nullable=True),
sa.Column('created_at', sa.DateTime(), nullable=False),
sa.ForeignKeyConstraint(
['user_id'],
['users.id'],
), sa.PrimaryKeyConstraint('id'))
op.create_table(
'entities', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('user_id', sa.Integer(), nullable=False),
sa.Column('type', sa.String(length=50), nullable=False),
sa.Column('category', sa.String(length=50), nullable=True),
sa.Column('title', sa.String(length=50), nullable=False),
sa.Column('description', sa.String(), nullable=False),
sa.Column('color', sa.String(length=50), nullable=True),
sa.Column('icon', sa.String(length=50), nullable=True),
sa.Column('image', sa.String(length=250), nullable=True),
sa.Column('created_at', sa.DateTime(), nullable=False),
sa.Column('location_id', sa.Integer(), nullable=True),
sa.Column('generated_id', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(
['location_id'],
['entities.id'],
), sa.ForeignKeyConstraint(
['user_id'],
['users.id'],
), sa.PrimaryKeyConstraint('id'))
op.create_table('meters', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('user_id', sa.Integer(), nullable=False),
sa.Column('category', sa.String(length=50), nullable=True),
sa.Column('title', sa.String(length=50), nullable=False),
sa.Column('description', sa.String(), nullable=False),
sa.Column('color', sa.String(length=50), nullable=True),
sa.Column('icon', sa.String(length=50), nullable=True),
sa.Column('image', sa.String(length=250), nullable=True),
sa.Column('created_at', sa.DateTime(), nullable=False),
sa.Column('min', sa.Integer(), nullable=False),
sa.Column('max', sa.Integer(), nullable=False),
sa.Column('algorithm', sa.String(), nullable=False),
sa.Column('base', sa.Integer(), nullable=False),
sa.Column('mod', sa.String(), nullable=False),
sa.ForeignKeyConstraint(
['user_id'],
['users.id'],
), sa.PrimaryKeyConstraint('id'))
op.create_table('statuses', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('user_id', sa.Integer(), nullable=False),
sa.Column('category', sa.String(length=50), nullable=True),
sa.Column('title', sa.String(length=50), nullable=False),
sa.Column('description', sa.String(), nullable=False),
sa.Column('color', sa.String(length=50), nullable=True),
sa.Column('icon', sa.String(length=50), nullable=True),
sa.Column('image', sa.String(length=250), nullable=True),
sa.Column('created_at', sa.DateTime(), nullable=False),
sa.Column('duration', sa.DateTime(), nullable=True),
sa.ForeignKeyConstraint(
['user_id'],
['users.id'],
), sa.PrimaryKeyConstraint('id'))
op.create_table(
'asset_modifiers', sa.Column('asset_id', sa.Integer(), nullable=False),
sa.Column('modifier_id', sa.Integer(), nullable=False),
sa.ForeignKeyConstraint(
['asset_id'],
['assets.id'],
), sa.ForeignKeyConstraint(
['modifier_id'],
['modifiers.id'],
), sa.PrimaryKeyConstraint('asset_id', 'modifier_id'))
op.create_table('entity_assets',
sa.Column('entity_id', sa.Integer(), nullable=False),
sa.Column('asset_id', sa.Integer(), nullable=False),
sa.Column('quantity', sa.Integer(), nullable=False),
sa.ForeignKeyConstraint(
['asset_id'],
['assets.id'],
), sa.ForeignKeyConstraint(
['entity_id'],
['entities.id'],
), sa.PrimaryKeyConstraint('entity_id', 'asset_id'))
op.create_table('entity_meters',
sa.Column('entity_id', sa.Integer(), nullable=False),
sa.Column('meter_id', sa.Integer(), nullable=False),
sa.Column('points', sa.Integer(), nullable=False),
sa.ForeignKeyConstraint(
['entity_id'],
['entities.id'],
), sa.ForeignKeyConstraint(
['meter_id'],
['meters.id'],
), sa.PrimaryKeyConstraint('entity_id', 'meter_id'))
op.create_table('entity_statuses',
sa.Column('entity_id', sa.Integer(), nullable=False),
sa.Column('status_id', sa.Integer(), nullable=False),
sa.Column('expiry', sa.DateTime(), nullable=True),
sa.ForeignKeyConstraint(
['entity_id'],
['entities.id'],
), sa.ForeignKeyConstraint(
['status_id'],
['statuses.id'],
), sa.PrimaryKeyConstraint('entity_id', 'status_id'))
op.create_table(
'player_characters',
sa.Column('player_id', sa.Integer(), nullable=False),
sa.Column('character_id', sa.Integer(), nullable=False),
sa.ForeignKeyConstraint(
['character_id'],
['entities.id'],
), sa.ForeignKeyConstraint(
['player_id'],
['users.id'],
), sa.PrimaryKeyConstraint('player_id', 'character_id'))
op.create_table(
'slots', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('chronicle_id', sa.Integer(), nullable=False),
sa.Column('category', sa.String(length=50), nullable=True),
sa.Column('created_at', sa.DateTime(), nullable=False),
sa.ForeignKeyConstraint(
['chronicle_id'],
['chronicles.id'],
), sa.PrimaryKeyConstraint('id'))
op.create_table(
'status_modifiers', sa.Column('status_id',
sa.Integer(),
nullable=False),
sa.Column('modifier_id', sa.Integer(), nullable=False),
sa.ForeignKeyConstraint(
['modifier_id'],
['modifiers.id'],
), sa.ForeignKeyConstraint(
['status_id'],
['statuses.id'],
), sa.PrimaryKeyConstraint('status_id', 'modifier_id'))
op.create_table(
'tales', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('title', sa.String(length=50), nullable=False),
sa.Column('description', sa.String(), nullable=False),
sa.Column('color', sa.String(length=50), nullable=True),
sa.Column('icon', sa.String(length=50), nullable=True),
sa.Column('image', sa.String(length=250), nullable=True),
sa.Column('created_at', sa.DateTime(), nullable=False),
sa.Column('chronicle_id', sa.Integer(), nullable=False),
sa.Column('first_thread_id', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(
['chronicle_id'],
['chronicles.id'],
), sa.PrimaryKeyConstraint('id'))
op.create_table('entity_slots',
sa.Column('entity_id', sa.Integer(), nullable=False),
sa.Column('slot_id', sa.Integer(), nullable=False),
sa.Column('filler_id', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(
['entity_id'],
['entities.id'],
), sa.ForeignKeyConstraint(
['filler_id'],
['entities.id'],
), sa.ForeignKeyConstraint(
['slot_id'],
['slots.id'],
), sa.PrimaryKeyConstraint('entity_id', 'slot_id'))
op.create_table(
'threads', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('title', sa.String(length=50), nullable=False),
sa.Column('description', sa.String(), nullable=False),
sa.Column('color', sa.String(length=50), nullable=True),
sa.Column('icon', sa.String(length=50), nullable=True),
sa.Column('image', sa.String(length=250), nullable=True),
sa.Column('created_at', sa.DateTime(), nullable=False),
sa.Column('tale_id', sa.Integer(), nullable=False),
sa.Column('is_sequitur', sa.Boolean(), nullable=False),
sa.Column('is_returnable', sa.Boolean(), nullable=False),
sa.Column('x', sa.Integer(), nullable=False),
sa.Column('y', sa.Integer(), nullable=False),
sa.ForeignKeyConstraint(['tale_id'], ['tales.id'], ondelete='cascade'),
sa.PrimaryKeyConstraint('id'))
op.create_table('asset_effects',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('type', sa.String(length=50), nullable=True),
sa.Column('category', sa.String(length=50), nullable=True),
sa.Column('thread_id', sa.Integer(), nullable=False),
sa.Column('created_at', sa.DateTime(), nullable=False),
sa.Column('asset_id', sa.Integer(), nullable=False),
sa.Column('quantity', sa.Integer(), nullable=False),
sa.ForeignKeyConstraint(
['asset_id'],
['assets.id'],
), sa.ForeignKeyConstraint(
['thread_id'],
['threads.id'],
), sa.PrimaryKeyConstraint('id'))
op.create_table(
'choices', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('title', sa.String(length=50), nullable=False),
sa.Column('description', sa.String(), nullable=False),
sa.Column('color', sa.String(length=50), nullable=True),
sa.Column('icon', sa.String(length=50), nullable=True),
sa.Column('image', sa.String(length=250), nullable=True),
sa.Column('created_at', sa.DateTime(), nullable=False),
sa.Column('prev_thread_id', sa.Integer(), nullable=False),
sa.Column('next_thread_id', sa.Integer(), nullable=False),
sa.ForeignKeyConstraint(['next_thread_id'], ['threads.id'],
ondelete='cascade'),
sa.ForeignKeyConstraint(['prev_thread_id'], ['threads.id'],
ondelete='cascade'),
sa.PrimaryKeyConstraint('id'))
op.create_table('asset_locks', sa.Column('id',
sa.Integer(),
nullable=False),
sa.Column('type', sa.String(length=50), nullable=True),
sa.Column('category', sa.String(length=50), nullable=True),
sa.Column('choice_id', sa.Integer(), nullable=False),
sa.Column('created_at', sa.DateTime(), nullable=False),
sa.Column('asset_id', sa.Integer(), nullable=False),
sa.Column('quantity', sa.Integer(), nullable=False),
sa.ForeignKeyConstraint(
['asset_id'],
['assets.id'],
), sa.ForeignKeyConstraint(
['choice_id'],
['choices.id'],
), sa.PrimaryKeyConstraint('id'))
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('goals',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('goal_slug', sa.String(), nullable=True),
sa.Column('goal_text', sa.String(), nullable=True),
sa.Column('created_at', sa.DateTime(), nullable=False),
sa.PrimaryKeyConstraint('id'),
sa.UniqueConstraint('goal_slug'),
sa.UniqueConstraint('goal_text')
)
op.create_table('other',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('data_reference_type', sa.String(), nullable=True),
sa.Column('data_key', sa.String(), nullable=True),
sa.Column('data_value', sa.String(), nullable=True),
sa.PrimaryKeyConstraint('id')
)
op.create_table('students',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('name', sa.String(), nullable=True),
sa.Column('email', sa.String(), nullable=True),
sa.Column('phone', sa.String(), nullable=True),
sa.Column('created_at', sa.DateTime(), nullable=False),
sa.PrimaryKeyConstraint('id'),
sa.UniqueConstraint('email'),
sa.UniqueConstraint('phone')
)
op.create_table('teachers',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('name', sa.String(), nullable=False),
sa.Column('email', sa.String(), nullable=False),
sa.Column('about', sa.Text(), nullable=True),
sa.Column('rating', sa.Float(), nullable=True),
sa.Column('picture', sa.String(), nullable=True),
sa.Column('price', sa.Float(), nullable=True),
sa.Column('created_at', sa.DateTime(), nullable=False),
sa.PrimaryKeyConstraint('id'),
sa.UniqueConstraint('email')
)
op.create_table('requests',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('student_id', sa.Integer(), nullable=True),
sa.Column('goal', sa.String(), nullable=True),
sa.Column('have_time', sa.String(), nullable=True),
sa.Column('created_at', sa.DateTime(), nullable=False),
sa.ForeignKeyConstraint(['student_id'], ['students.id'], ),
sa.PrimaryKeyConstraint('id')
)
op.create_table('teacher_goals',
sa.Column('teacher_id', sa.Integer(), nullable=True),
sa.Column('goal_id', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(['goal_id'], ['goals.id'], ),
sa.ForeignKeyConstraint(['teacher_id'], ['teachers.id'], )
)
op.create_table('timetables',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('teacher_id', sa.Integer(), nullable=True),
sa.Column('weekday', sa.String(), nullable=True),
sa.Column('time', sa.Time(), nullable=True),
sa.Column('created_at', sa.DateTime(), nullable=False),
sa.ForeignKeyConstraint(['teacher_id'], ['teachers.id'], ),
sa.PrimaryKeyConstraint('id')
)
op.create_table('bookings',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('student_id', sa.Integer(), nullable=True),
sa.Column('teacher_id', sa.Integer(), nullable=True),
sa.Column('timetable_id', sa.Integer(), nullable=True),
sa.Column('created_at', sa.DateTime(), nullable=False),
sa.ForeignKeyConstraint(['student_id'], ['students.id'], ),
sa.ForeignKeyConstraint(['teacher_id'], ['teachers.id'], ),
sa.ForeignKeyConstraint(['timetable_id'], ['timetables.id'], ),
sa.PrimaryKeyConstraint('id')
)
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table(
'feedback', sa.Column('feedback_id', sa.Integer(), nullable=False),
sa.Column('user_ID', sa.String(length=80), nullable=True),
sa.Column('prediction', sa.Integer(), nullable=True),
sa.Column('rating',
postgresql.JSON(astext_type=sa.Text()),
nullable=True),
sa.Column('feedback',
postgresql.JSON(astext_type=sa.Text()),
nullable=True), sa.PrimaryKeyConstraint('feedback_id'))
op.create_table(
'prediction', sa.Column('prediction_id', sa.Integer(), nullable=False),
sa.Column('analysis_model_name', sa.String(length=40), nullable=True),
sa.Column('score', sa.Float(), nullable=True),
sa.Column('model_id', sa.Integer(), nullable=True),
sa.PrimaryKeyConstraint('prediction_id'))
op.create_table(
'prepared_data',
sa.Column('prepared_id', sa.String(length=80), nullable=False),
sa.Column('project_ID', sa.Integer(), nullable=True),
sa.Column('preprared_data',
postgresql.JSON(astext_type=sa.Text()),
nullable=True),
sa.Column('sample_ID', sa.Integer(), nullable=True),
sa.PrimaryKeyConstraint('prepared_id'))
op.create_table(
'project', sa.Column('project_id',
sa.String(length=80),
nullable=False),
sa.Column('raw_data_id', sa.Integer(), nullable=True),
sa.Column('algo', sa.String(length=40), nullable=True),
sa.Column('user_id', sa.String(length=80), nullable=True),
sa.PrimaryKeyConstraint('project_id'))
op.create_table(
'raw_data', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('user_id', sa.String(length=80), nullable=True),
sa.Column('raw_data_set',
postgresql.JSON(astext_type=sa.Text()),
nullable=True), sa.PrimaryKeyConstraint('id'))
op.create_table(
'reviwer', sa.Column('project_id',
sa.String(length=80),
nullable=False),
sa.PrimaryKeyConstraint('project_id'))
op.create_table(
'sample_data', sa.Column('sample_ID', sa.Integer(), nullable=False),
sa.Column('sample_Data',
postgresql.JSON(astext_type=sa.Text()),
nullable=True),
sa.Column('trained_model', postgresql.BYTEA(), nullable=True),
sa.PrimaryKeyConstraint('sample_ID'))
op.create_table(
'trained_model_result',
sa.Column('model_id', sa.Integer(), nullable=False),
sa.Column('model', postgresql.BYTEA(), nullable=True),
sa.Column('project_id', sa.Integer(), nullable=True),
sa.Column('parameter',
postgresql.JSON(astext_type=sa.Text()),
nullable=True), sa.PrimaryKeyConstraint('model_id'))
op.create_table(
'user', sa.Column('user_id', sa.String(length=80), nullable=False),
sa.Column('prediction',
postgresql.JSON(astext_type=sa.Text()),
nullable=True),
sa.Column('project_id', sa.String(length=80), nullable=True),
sa.PrimaryKeyConstraint('user_id'))
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table(
'users', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('username', sa.String(length=64), nullable=True),
sa.Column('email', sa.String(length=64), nullable=True),
sa.Column('password_hash', sa.String(length=128), nullable=True),
sa.PrimaryKeyConstraint('id'))
op.create_index(op.f('ix_users_email'), 'users', ['email'], unique=True)
op.create_index(op.f('ix_users_username'),
'users', ['username'],
unique=True)
op.create_table(
'carts', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('user_id', sa.Integer(), nullable=True),
sa.Column('nf_calories',
sa.Numeric(decimal_return_scale=2),
nullable=True),
sa.Column('nf_total_fat',
sa.Numeric(decimal_return_scale=2),
nullable=True),
sa.Column('nf_saturated_fat',
sa.Numeric(decimal_return_scale=2),
nullable=True),
sa.Column('nf_cholesterol',
sa.Numeric(decimal_return_scale=2),
nullable=True),
sa.Column('nf_sodium',
sa.Numeric(decimal_return_scale=2),
nullable=True),
sa.Column('nf_total_carbohydrate',
sa.Numeric(decimal_return_scale=2),
nullable=True),
sa.Column('nf_dietary_fiber',
sa.Numeric(decimal_return_scale=2),
nullable=True),
sa.Column('nf_sugars',
sa.Numeric(decimal_return_scale=2),
nullable=True),
sa.Column('nf_protein',
sa.Numeric(decimal_return_scale=2),
nullable=True),
sa.ForeignKeyConstraint(
['user_id'],
['users.id'],
), sa.PrimaryKeyConstraint('id'))
op.create_table(
'food_items', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('name', sa.String(length=64), nullable=True),
sa.Column('nf_calories',
sa.Numeric(decimal_return_scale=2),
nullable=True),
sa.Column('nf_total_fat',
sa.Numeric(decimal_return_scale=2),
nullable=True),
sa.Column('nf_saturated_fat',
sa.Numeric(decimal_return_scale=2),
nullable=True),
sa.Column('nf_cholesterol',
sa.Numeric(decimal_return_scale=2),
nullable=True),
sa.Column('nf_sodium',
sa.Numeric(decimal_return_scale=2),
nullable=True),
sa.Column('nf_total_carbohydrate',
sa.Numeric(decimal_return_scale=2),
nullable=True),
sa.Column('nf_dietary_fiber',
sa.Numeric(decimal_return_scale=2),
nullable=True),
sa.Column('nf_sugars',
sa.Numeric(decimal_return_scale=2),
nullable=True),
sa.Column('nf_protein',
sa.Numeric(decimal_return_scale=2),
nullable=True),
sa.Column('serving_qty',
sa.Numeric(decimal_return_scale=2),
nullable=True),
sa.Column('serving_unit', sa.String(length=32), nullable=True),
sa.Column('cart_id', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(
['cart_id'],
['carts.id'],
), sa.PrimaryKeyConstraint('id'))
op.create_index(op.f('ix_food_items_name'),
'food_items', ['name'],
unique=False)
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('safety_questionnaire',
sa.Column('id', sa.Integer(), nullable=False),
sa.PrimaryKeyConstraint('id'))
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('category', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('name', sa.String(length=255), nullable=True),
sa.PrimaryKeyConstraint('id'))
op.create_table('line', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('line_image', sa.LargeBinary(), nullable=True),
sa.Column('image_width', sa.Integer(), nullable=True),
sa.Column('image_height', sa.Integer(), nullable=True),
sa.PrimaryKeyConstraint('id'))
op.create_table(
'person', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('personname', sa.String(length=255), nullable=True),
sa.Column('password_hash', sa.String(length=255), nullable=True),
sa.PrimaryKeyConstraint('id'))
op.create_table(
'questionnumber', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('question_number', sa.String(length=255), nullable=True),
sa.Column('question_image', sa.LargeBinary(), nullable=True),
sa.Column('image_width', sa.Integer(), nullable=True),
sa.Column('image_height', sa.Integer(), nullable=True),
sa.PrimaryKeyConstraint('id'))
op.create_table(
'team', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('teamname', sa.String(length=255), nullable=True),
sa.Column('score', sa.Integer(), nullable=True),
sa.PrimaryKeyConstraint('id'))
op.create_table('type', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('name', sa.String(length=255), nullable=True),
sa.PrimaryKeyConstraint('id'))
op.create_table(
'answersheet', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('team_id', sa.Integer(), nullable=True),
sa.Column('answersheet_image', sa.LargeBinary(), nullable=True),
sa.Column('image_width', sa.Integer(), nullable=True),
sa.Column('image_height', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(
['team_id'],
['team.id'],
), sa.PrimaryKeyConstraint('id'))
op.create_table(
'question', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('questionnumber', sa.Integer(), nullable=True),
sa.Column('person_id', sa.Integer(), nullable=True),
sa.Column('category_id', sa.Integer(), nullable=True),
sa.Column('type_id', sa.Integer(), nullable=True),
sa.Column('question', sa.String(length=255), nullable=True),
sa.Column('active', sa.Boolean(), nullable=True),
sa.ForeignKeyConstraint(
['category_id'],
['category.id'],
), sa.ForeignKeyConstraint(
['person_id'],
['person.id'],
), sa.ForeignKeyConstraint(
['type_id'],
['type.id'],
), sa.PrimaryKeyConstraint('id'))
op.create_table(
'word', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('line_id', sa.Integer(), nullable=True),
sa.Column('word_recognised', sa.String(length=255), nullable=True),
sa.Column('probability', sa.Float(), nullable=True),
sa.Column('word_image', sa.LargeBinary(), nullable=True),
sa.Column('image_width', sa.Integer(), nullable=True),
sa.Column('image_height', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(
['line_id'],
['line.id'],
), sa.PrimaryKeyConstraint('id'))
op.create_table(
'answergiven', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('question_id', sa.Integer(), nullable=False),
sa.Column('team_id', sa.Integer(), nullable=False),
sa.ForeignKeyConstraint(
['question_id'],
['question.id'],
), sa.ForeignKeyConstraint(
['team_id'],
['team.id'],
), sa.PrimaryKeyConstraint('id'))
op.create_table(
'answersheetquestion', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('answersheet_id', sa.Integer(), nullable=True),
sa.Column('question_id', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(
['answersheet_id'],
['answersheet.id'],
), sa.ForeignKeyConstraint(
['question_id'],
['question.id'],
), sa.PrimaryKeyConstraint('id'))
op.create_table(
'subanswer', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('question_id', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(
['question_id'],
['question.id'],
), sa.PrimaryKeyConstraint('id'))
op.create_table(
'subanswergiven', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('corr_answer_id', sa.Integer(), nullable=False),
sa.Column('read_answer', sa.String(length=255), nullable=True),
sa.Column('correct', sa.Boolean(), nullable=True),
sa.Column('confidence', sa.Float(), nullable=True),
sa.Column('probability_read_answer', sa.Float(), nullable=True),
sa.Column('person_id', sa.Integer(), nullable=False),
sa.Column('line_id', sa.Integer(), nullable=False),
sa.Column('answergiven_id', sa.Integer(), nullable=False),
sa.ForeignKeyConstraint(
['answergiven_id'],
['answergiven.id'],
), sa.ForeignKeyConstraint(
['corr_answer_id'],
['subanswer.id'],
), sa.ForeignKeyConstraint(
['line_id'],
['line.id'],
), sa.ForeignKeyConstraint(
['person_id'],
['person.id'],
), sa.PrimaryKeyConstraint('id'))
op.create_table(
'variant', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('subanswer_id', sa.Integer(), nullable=True),
sa.Column('answer', sa.String(length=255), nullable=True),
sa.Column('isNumber', sa.Boolean(), nullable=True),
sa.ForeignKeyConstraint(
['subanswer_id'],
['subanswer.id'],
), sa.PrimaryKeyConstraint('id'))
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('Equations',
sa.Column('Id', sa.Integer(), nullable=False),
sa.Column('Name', sa.String(length=45), nullable=False),
sa.Column('Description', sa.String(length=21845), nullable=True),
sa.PrimaryKeyConstraint('Id')
)
op.create_table('MeasurementTypes',
sa.Column('Id', sa.String(length=45), nullable=False),
sa.PrimaryKeyConstraint('Id')
)
op.create_table('Users',
sa.Column('IsDeleted', sa.Boolean(), nullable=False),
sa.Column('CreatedOn', sa.DateTime(), nullable=True),
sa.Column('ModifiedOn', sa.DateTime(), nullable=True),
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('username', sa.String(length=64), nullable=True),
sa.Column('email', sa.String(length=120), nullable=True),
sa.Column('password_hash', sa.String(length=128), nullable=True),
sa.Column('token', sa.String(length=32), nullable=True),
sa.Column('token_expiration', sa.DateTime(), nullable=True),
sa.Column('ModifiedById', sa.Integer(), nullable=True),
sa.Column('CreatedById', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(['CreatedById'], ['Users.id'], ),
sa.ForeignKeyConstraint(['ModifiedById'], ['Users.id'], ),
sa.PrimaryKeyConstraint('id')
)
op.create_index(op.f('ix_Users_email'), 'Users', ['email'], unique=True)
op.create_index(op.f('ix_Users_token'), 'Users', ['token'], unique=True)
op.create_index(op.f('ix_Users_username'), 'Users', ['username'], unique=True)
op.create_table('casedata',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('well', sa.String(length=64), nullable=True),
sa.Column('readdate', sa.String(length=15), nullable=True),
sa.Column('oilrate', sa.Float(), nullable=True),
sa.Column('waterrate', sa.Float(), nullable=True),
sa.Column('gasrate', sa.Float(), nullable=True),
sa.Column('user', sa.String(length=64), nullable=True),
sa.Column('datasetname', sa.String(length=64), nullable=True),
sa.PrimaryKeyConstraint('id')
)
op.create_index(op.f('ix_casedata_user'), 'casedata', ['user'], unique=False)
op.create_index(op.f('ix_casedata_well'), 'casedata', ['well'], unique=False)
op.create_table('UploadSets',
sa.Column('IsDeleted', sa.Boolean(), nullable=False),
sa.Column('CreatedOn', sa.DateTime(), nullable=True),
sa.Column('ModifiedOn', sa.DateTime(), nullable=True),
sa.Column('Id', sa.Integer(), nullable=False),
sa.Column('Name', sa.String(length=45), nullable=False),
sa.Column('CreatedDate', sa.DateTime(), nullable=False),
sa.Column('Description', sa.String(length=21845), nullable=True),
sa.Column('UserId', sa.Integer(), nullable=False),
sa.Column('FileName', sa.String(length=45), nullable=True),
sa.Column('StoredFileName', sa.String(length=45), nullable=True),
sa.Column('ModifiedById', sa.Integer(), nullable=True),
sa.Column('CreatedById', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(['CreatedById'], ['Users.id'], ),
sa.ForeignKeyConstraint(['ModifiedById'], ['Users.id'], ),
sa.ForeignKeyConstraint(['UserId'], ['Users.id'], ),
sa.PrimaryKeyConstraint('Id')
)
op.create_table('Wells',
sa.Column('IsDeleted', sa.Boolean(), nullable=False),
sa.Column('CreatedOn', sa.DateTime(), nullable=True),
sa.Column('ModifiedOn', sa.DateTime(), nullable=True),
sa.Column('Id', sa.Integer(), nullable=False),
sa.Column('Name', sa.String(length=45), nullable=False),
sa.Column('Latitude', sa.Numeric(precision=11, scale=8), nullable=True),
sa.Column('Longitude', sa.Numeric(precision=11, scale=8), nullable=True),
sa.Column('UserId', sa.Integer(), nullable=False),
sa.Column('UploadSetId', sa.Integer(), nullable=True),
sa.Column('PerforationTopDepth', sa.Float(), nullable=True),
sa.Column('PerforationBottomDepth', sa.Float(), nullable=True),
sa.Column('ModifiedById', sa.Integer(), nullable=True),
sa.Column('CreatedById', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(['CreatedById'], ['Users.id'], ),
sa.ForeignKeyConstraint(['ModifiedById'], ['Users.id'], ),
sa.ForeignKeyConstraint(['UploadSetId'], ['UploadSets.Id'], ),
sa.ForeignKeyConstraint(['UserId'], ['Users.id'], ),
sa.PrimaryKeyConstraint('Id')
)
op.create_table('IDCAnalysis',
sa.Column('IsDeleted', sa.Boolean(), nullable=False),
sa.Column('CreatedOn', sa.DateTime(), nullable=True),
sa.Column('ModifiedOn', sa.DateTime(), nullable=True),
sa.Column('Id', sa.Integer(), nullable=False),
sa.Column('WellId', sa.Integer(), nullable=False),
sa.Column('Date', sa.DateTime(), nullable=False),
sa.Column('TotalError', sa.Float(), nullable=True),
sa.Column('PredictedProduction', sa.Float(), nullable=True),
sa.Column('ActualProduction', sa.Float(), nullable=True),
sa.Column('Difference', sa.Float(), nullable=True),
sa.Column('ModifiedById', sa.Integer(), nullable=True),
sa.Column('CreatedById', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(['CreatedById'], ['Users.id'], ),
sa.ForeignKeyConstraint(['ModifiedById'], ['Users.id'], ),
sa.ForeignKeyConstraint(['WellId'], ['Wells.Id'], ),
sa.PrimaryKeyConstraint('Id')
)
op.create_table('MeasurementFormats',
sa.Column('IsDeleted', sa.Boolean(), nullable=False),
sa.Column('CreatedOn', sa.DateTime(), nullable=True),
sa.Column('ModifiedOn', sa.DateTime(), nullable=True),
sa.Column('WellId', sa.Integer(), nullable=False),
sa.Column('MeasurementTypeId', sa.String(length=45), nullable=False),
sa.Column('Format', sa.String(length=45), nullable=False),
sa.Column('ModifiedById', sa.Integer(), nullable=True),
sa.Column('CreatedById', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(['CreatedById'], ['Users.id'], ),
sa.ForeignKeyConstraint(['MeasurementTypeId'], ['MeasurementTypes.Id'], ),
sa.ForeignKeyConstraint(['ModifiedById'], ['Users.id'], ),
sa.ForeignKeyConstraint(['WellId'], ['Wells.Id'], ),
sa.PrimaryKeyConstraint('WellId', 'MeasurementTypeId')
)
op.create_table('WellOutputMeasurements',
sa.Column('IsDeleted', sa.Boolean(), nullable=False),
sa.Column('CreatedOn', sa.DateTime(), nullable=True),
sa.Column('ModifiedOn', sa.DateTime(), nullable=True),
sa.Column('Id', sa.Integer(), nullable=False),
sa.Column('Date', sa.DateTime(), nullable=False),
sa.Column('WellId', sa.Integer(), nullable=False),
sa.Column('MeasurementTypeId', sa.String(length=45), nullable=False),
sa.Column('Value', sa.Float(), nullable=True),
sa.Column('ModifiedById', sa.Integer(), nullable=True),
sa.Column('CreatedById', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(['CreatedById'], ['Users.id'], ),
sa.ForeignKeyConstraint(['MeasurementTypeId'], ['MeasurementTypes.Id'], ),
sa.ForeignKeyConstraint(['ModifiedById'], ['Users.id'], ),
sa.ForeignKeyConstraint(['WellId'], ['Wells.Id'], ),
sa.PrimaryKeyConstraint('Id')
)
op.create_table('IDCAResults',
sa.Column('IsDeleted', sa.Boolean(), nullable=False),
sa.Column('CreatedOn', sa.DateTime(), nullable=True),
sa.Column('ModifiedOn', sa.DateTime(), nullable=True),
sa.Column('Id', sa.Integer(), nullable=False),
sa.Column('IDCAnalysisId', sa.Integer(), nullable=False),
sa.Column('StartSegment', sa.Integer(), nullable=False),
sa.Column('EndSegment', sa.Integer(), nullable=False),
sa.Column('EquationId', sa.Integer(), nullable=False),
sa.Column('ParameterA', sa.Float(), nullable=False),
sa.Column('ParameterB', sa.Float(), nullable=False),
sa.Column('ModifiedById', sa.Integer(), nullable=True),
sa.Column('CreatedById', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(['CreatedById'], ['Users.id'], ),
sa.ForeignKeyConstraint(['EquationId'], ['Equations.Id'], ),
sa.ForeignKeyConstraint(['IDCAnalysisId'], ['IDCAnalysis.Id'], ),
sa.ForeignKeyConstraint(['ModifiedById'], ['Users.id'], ),
sa.PrimaryKeyConstraint('Id')
)
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('tb_free_category',
sa.Column('creat_time', sa.DateTime(), nullable=True),
sa.Column('update_time', sa.DateTime(), nullable=True),
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('name', sa.String(length=64), nullable=False),
sa.PrimaryKeyConstraint('id'))
op.create_table('tb_thinking_category',
sa.Column('creat_time', sa.DateTime(), nullable=True),
sa.Column('update_time', sa.DateTime(), nullable=True),
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('name', sa.String(length=64), nullable=False),
sa.PrimaryKeyConstraint('id'))
op.create_table(
'tb_user', sa.Column('creat_time', sa.DateTime(), nullable=True),
sa.Column('update_time', sa.DateTime(), nullable=True),
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('user_name', sa.String(length=32), nullable=False),
sa.Column('password_hash', sa.String(length=128), nullable=True),
sa.Column('signature', sa.String(length=512), nullable=True),
sa.Column('avatar_url', sa.String(length=256), nullable=True),
sa.Column('gender', sa.Enum('MAN', 'WOMAN'), nullable=True),
sa.Column('last_login', sa.DateTime(), nullable=True),
sa.Column('is_admin', sa.Boolean(), nullable=True),
sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('user_name'))
op.create_table('tb_work_category',
sa.Column('creat_time', sa.DateTime(), nullable=True),
sa.Column('update_time', sa.DateTime(), nullable=True),
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('name', sa.String(length=64), nullable=False),
sa.PrimaryKeyConstraint('id'))
op.create_table(
'tb_free_article', sa.Column('creat_time',
sa.DateTime(),
nullable=True),
sa.Column('update_time', sa.DateTime(), nullable=True),
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('title', sa.String(length=256), nullable=False),
sa.Column('source', sa.String(length=64), nullable=True),
sa.Column('digest', sa.String(length=512), nullable=False),
sa.Column('content', sa.Text(), nullable=False),
sa.Column('clicks', sa.Integer(), nullable=True),
sa.Column('image_url', sa.String(length=256), nullable=True),
sa.Column('status', sa.Integer(), nullable=True),
sa.Column('reason', sa.String(length=256), nullable=True),
sa.Column('free_category_id', sa.Integer(), nullable=True),
sa.Column('user_id', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(
['free_category_id'],
['tb_free_category.id'],
), sa.ForeignKeyConstraint(
['user_id'],
['tb_user.id'],
), sa.PrimaryKeyConstraint('id'))
op.create_table(
'tb_thinking_article',
sa.Column('creat_time', sa.DateTime(), nullable=True),
sa.Column('update_time', sa.DateTime(), nullable=True),
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('title', sa.String(length=256), nullable=False),
sa.Column('source', sa.String(length=64), nullable=True),
sa.Column('digest', sa.String(length=512), nullable=False),
sa.Column('content', sa.Text(), nullable=False),
sa.Column('clicks', sa.Integer(), nullable=True),
sa.Column('image_url', sa.String(length=256), nullable=True),
sa.Column('status', sa.Integer(), nullable=True),
sa.Column('reason', sa.String(length=256), nullable=True),
sa.Column('thinking_category_id', sa.Integer(), nullable=True),
sa.Column('user_id', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(
['thinking_category_id'],
['tb_thinking_category.id'],
), sa.ForeignKeyConstraint(
['user_id'],
['tb_user.id'],
), sa.PrimaryKeyConstraint('id'))
op.create_table(
'tb_work_article', sa.Column('creat_time',
sa.DateTime(),
nullable=True),
sa.Column('update_time', sa.DateTime(), nullable=True),
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('title', sa.String(length=256), nullable=False),
sa.Column('source', sa.String(length=64), nullable=True),
sa.Column('digest', sa.String(length=512), nullable=False),
sa.Column('content', sa.Text(), nullable=False),
sa.Column('clicks', sa.Integer(), nullable=True),
sa.Column('image_url', sa.String(length=256), nullable=True),
sa.Column('status', sa.Integer(), nullable=True),
sa.Column('reason', sa.String(length=256), nullable=True),
sa.Column('work_category_id', sa.Integer(), nullable=True),
sa.Column('user_id', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(
['user_id'],
['tb_user.id'],
),
sa.ForeignKeyConstraint(
['work_category_id'],
['tb_work_category.id'],
), sa.PrimaryKeyConstraint('id'))
op.create_table(
'tb_free_comment', sa.Column('creat_time',
sa.DateTime(),
nullable=True),
sa.Column('update_time', sa.DateTime(), nullable=True),
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('content', sa.Text(), nullable=False),
sa.Column('like_count', sa.Integer(), nullable=True),
sa.Column('free_article_id', sa.Integer(), nullable=False),
sa.Column('free_parent_id', sa.Integer(), nullable=True),
sa.Column('user_id', sa.Integer(), nullable=False),
sa.ForeignKeyConstraint(
['free_article_id'],
['tb_free_article.id'],
), sa.ForeignKeyConstraint(
['free_parent_id'],
['tb_free_comment.id'],
), sa.ForeignKeyConstraint(
['user_id'],
['tb_user.id'],
), sa.PrimaryKeyConstraint('id'))
op.create_table(
'tb_thinking_comment',
sa.Column('creat_time', sa.DateTime(), nullable=True),
sa.Column('update_time', sa.DateTime(), nullable=True),
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('content', sa.Text(), nullable=False),
sa.Column('like_count', sa.Integer(), nullable=True),
sa.Column('thinking_article_id', sa.Integer(), nullable=False),
sa.Column('thinking_parent_id', sa.Integer(), nullable=True),
sa.Column('user_id', sa.Integer(), nullable=False),
sa.ForeignKeyConstraint(
['thinking_article_id'],
['tb_thinking_article.id'],
),
sa.ForeignKeyConstraint(
['thinking_parent_id'],
['tb_thinking_comment.id'],
), sa.ForeignKeyConstraint(
['user_id'],
['tb_user.id'],
), sa.PrimaryKeyConstraint('id'))
op.create_table(
'tb_user_collection', sa.Column('user_id',
sa.Integer(),
nullable=False),
sa.Column('free_article_id', sa.Integer(), nullable=False),
sa.Column('work_article_id', sa.Integer(), nullable=False),
sa.Column('thinking_article_id', sa.Integer(), nullable=False),
sa.Column('create_time', sa.DateTime(), nullable=True),
sa.ForeignKeyConstraint(
['free_article_id'],
['tb_free_article.id'],
),
sa.ForeignKeyConstraint(
['thinking_article_id'],
['tb_thinking_article.id'],
), sa.ForeignKeyConstraint(
['user_id'],
['tb_user.id'],
),
sa.ForeignKeyConstraint(
['work_article_id'],
['tb_work_article.id'],
),
sa.PrimaryKeyConstraint('user_id', 'free_article_id',
'work_article_id', 'thinking_article_id'))
op.create_table(
'tb_work_comment', sa.Column('creat_time',
sa.DateTime(),
nullable=True),
sa.Column('update_time', sa.DateTime(), nullable=True),
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('content', sa.Text(), nullable=False),
sa.Column('like_count', sa.Integer(), nullable=True),
sa.Column('work_article_id', sa.Integer(), nullable=False),
sa.Column('work_parent_id', sa.Integer(), nullable=True),
sa.Column('user_id', sa.Integer(), nullable=False),
sa.ForeignKeyConstraint(
['user_id'],
['tb_user.id'],
),
sa.ForeignKeyConstraint(
['work_article_id'],
['tb_work_article.id'],
), sa.ForeignKeyConstraint(
['work_parent_id'],
['tb_work_comment.id'],
), sa.PrimaryKeyConstraint('id'))
op.create_table(
'tb_free_comment_like',
sa.Column('creat_time', sa.DateTime(), nullable=True),
sa.Column('update_time', sa.DateTime(), nullable=True),
sa.Column('free_comment_id', sa.Integer(), nullable=False),
sa.Column('user_id', sa.Integer(), nullable=False),
sa.ForeignKeyConstraint(
['free_comment_id'],
['tb_free_comment.id'],
), sa.ForeignKeyConstraint(
['user_id'],
['tb_user.id'],
), sa.PrimaryKeyConstraint('free_comment_id', 'user_id'))
op.create_table(
'thinking__comment_like',
sa.Column('creat_time', sa.DateTime(), nullable=True),
sa.Column('update_time', sa.DateTime(), nullable=True),
sa.Column('thinking_comment_id', sa.Integer(), nullable=False),
sa.Column('user_id', sa.Integer(), nullable=False),
sa.ForeignKeyConstraint(
['thinking_comment_id'],
['tb_thinking_comment.id'],
), sa.ForeignKeyConstraint(
['user_id'],
['tb_user.id'],
), sa.PrimaryKeyConstraint('thinking_comment_id', 'user_id'))
op.create_table(
'work__comment_like',
sa.Column('creat_time', sa.DateTime(), nullable=True),
sa.Column('update_time', sa.DateTime(), nullable=True),
sa.Column('work_comment_id', sa.Integer(), nullable=False),
sa.Column('user_id', sa.Integer(), nullable=False),
sa.ForeignKeyConstraint(
['user_id'],
['tb_user.id'],
),
sa.ForeignKeyConstraint(
['work_comment_id'],
['tb_work_comment.id'],
), sa.PrimaryKeyConstraint('work_comment_id', 'user_id'))
def downgrade():
### commands auto generated by Alembic - please adjust! ###
op.create_table('temp_user',
sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('email', sa.VARCHAR(length=120), autoincrement=False, nullable=True),
sa.Column('password', sa.VARCHAR(length=128), autoincrement=False, nullable=True),
sa.Column('reset_password', sa.VARCHAR(length=128), autoincrement=False, nullable=True),
sa.Column('salt', sa.VARCHAR(length=128), autoincrement=False, nullable=True),
sa.Column('avatar', sa.VARCHAR(), autoincrement=False, nullable=True),
sa.Column('tokens', sa.TEXT(), autoincrement=False, nullable=True),
sa.Column('is_super_admin', sa.BOOLEAN(), autoincrement=False, nullable=True),
sa.Column('is_admin', sa.BOOLEAN(), autoincrement=False, nullable=True),
sa.Column('is_verified', sa.BOOLEAN(), autoincrement=False, nullable=True),
sa.Column('signup_at', postgresql.TIMESTAMP(), autoincrement=False, nullable=True),
sa.Column('last_accessed_at', postgresql.TIMESTAMP(), autoincrement=False, nullable=True),
sa.Column('created_at', postgresql.TIMESTAMP(), autoincrement=False, nullable=True),
sa.Column('deleted_at', postgresql.TIMESTAMP(), autoincrement=False, nullable=True),
sa.PrimaryKeyConstraint('id', name=u'user_pkey'),
sa.UniqueConstraint('email', name=u'user_email_key'),
postgresql_ignore_search_path=False
)
op.create_table('user_detail',
sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('firstname', sa.VARCHAR(), autoincrement=False, nullable=True),
sa.Column('lastname', sa.VARCHAR(), autoincrement=False, nullable=True),
sa.Column('details', sa.VARCHAR(), autoincrement=False, nullable=True),
sa.Column('avatar', sa.VARCHAR(), autoincrement=False, nullable=True),
sa.Column('contact', sa.VARCHAR(), autoincrement=False, nullable=True),
sa.Column('facebook', sa.VARCHAR(), autoincrement=False, nullable=True),
sa.Column('twitter', sa.VARCHAR(), autoincrement=False, nullable=True),
sa.Column('instagram', sa.VARCHAR(), autoincrement=False, nullable=True),
sa.Column('google', sa.VARCHAR(), autoincrement=False, nullable=True),
sa.Column('avatar_uploaded', sa.VARCHAR(), autoincrement=False, nullable=True),
sa.Column('thumbnail', sa.VARCHAR(), autoincrement=False, nullable=True),
sa.Column('small', sa.VARCHAR(), autoincrement=False, nullable=True),
sa.Column('icon', sa.VARCHAR(), autoincrement=False, nullable=True),
sa.Column('user_id', sa.INTEGER(), autoincrement=False, nullable=True),
sa.PrimaryKeyConstraint('id', name=u'user_detail_pkey')
)
op.drop_constraint(u'users_events_roles_user_id_fkey', 'users_events_roles', type_='foreignkey')
op.create_foreign_key(u'users_events_roles_user_id_fkey', 'users_events_roles', 'temp_user', ['user_id'], ['id'],
ondelete=u'CASCADE')
op.drop_constraint(u'user_system_role_user_id_fkey', 'user_system_role', type_='foreignkey')
op.create_foreign_key(u'user_system_role_user_id_fkey', 'user_system_role', 'temp_user', ['user_id'], ['id'],
ondelete=u'CASCADE')
op.drop_constraint(u'transaction_user_id_fkey', 'transaction', type_='foreignkey')
op.create_foreign_key(u'transaction_user_id_fkey', 'transaction', 'temp_user', ['user_id'], ['id'])
op.drop_constraint(u'speaker_user_id_fkey', 'speaker', type_='foreignkey')
op.create_foreign_key(u'speaker_user_id_fkey', 'speaker', 'temp_user', ['user_id'], ['id'], ondelete=u'SET NULL')
op.drop_constraint(u'orders_marketer_id_fkey', 'orders', type_='foreignkey')
op.drop_constraint(u'orders_user_id_fkey', 'orders', type_='foreignkey')
op.create_foreign_key(u'orders_marketer_id_fkey', 'orders', 'temp_user', ['marketer_id'], ['id'],
ondelete=u'SET NULL')
op.create_foreign_key(u'orders_user_id_fkey', 'orders', 'temp_user', ['user_id'], ['id'], ondelete=u'SET NULL')
op.drop_constraint(u'notification_user_id_fkey', 'notification', type_='foreignkey')
op.create_foreign_key(u'notification_user_id_fkey', 'notification', 'temp_user', ['user_id'], ['id'],
ondelete=u'CASCADE')
op.drop_constraint(u'invites_user_id_fkey', 'invites', type_='foreignkey')
op.create_foreign_key(u'invites_user_id_fkey', 'invites', 'temp_user', ['user_id'], ['id'], ondelete=u'CASCADE')
op.drop_constraint(u'import_jobs_user_id_fkey', 'import_jobs', type_='foreignkey')
op.create_foreign_key(u'import_jobs_user_id_fkey', 'import_jobs', 'temp_user', ['user_id'], ['id'],
ondelete=u'CASCADE')
op.drop_constraint(u'event_user_user_id_fkey', 'event_user', type_='foreignkey')
op.create_foreign_key(u'event_user_user_id_fkey', 'event_user', 'temp_user', ['user_id'], ['id'],
ondelete=u'CASCADE')
op.drop_constraint(u'event_invoices_user_id_fkey', 'event_invoices', type_='foreignkey')
op.create_foreign_key(u'event_invoices_user_id_fkey', 'event_invoices', 'temp_user', ['user_id'], ['id'],
ondelete=u'SET NULL')
op.drop_constraint(u'email_notifications_user_id_fkey', 'email_notifications', type_='foreignkey')
op.create_foreign_key(u'email_notifications_user_id_fkey', 'email_notifications', 'temp_user', ['user_id'], ['id'],
ondelete=u'CASCADE')
op.drop_constraint(u'discount_codes_marketer_id_fkey', 'discount_codes', type_='foreignkey')
op.create_foreign_key(u'discount_codes_marketer_id_fkey', 'discount_codes', 'temp_user', ['marketer_id'], ['id'],
ondelete=u'CASCADE')
op.drop_constraint(u'booked_ticket_user_id_fkey', 'booked_ticket', type_='foreignkey')
op.create_foreign_key(u'booked_ticket_user_id_fkey', 'booked_ticket', 'temp_user', ['user_id'], ['id'],
ondelete=u'CASCADE')
op.drop_constraint(u'access_codes_marketer_id_fkey', 'access_codes', type_='foreignkey')
op.create_foreign_key(u'access_codes_marketer_id_fkey', 'access_codes', 'temp_user', ['marketer_id'], ['id'],
ondelete=u'CASCADE')
op.create_foreign_key(u'user_detail_user_id_fkey', 'user_detail', 'temp_user', ['user_id'], ['id'], ondelete='CASCADE')
op.execute("INSERT INTO temp_user SELECT id, email, password, reset_password, salt, avatar, tokens, is_super_admin, is_admin, is_verified, signup_at, last_accessed_at, created_at, deleted_at from users")
op.execute("INSERT INTO user_detail SELECT id, firstname, lastname, details, avatar, contact, facebook, twitter, instagram, google, avatar_uploaded, thumbnail, small, icon, id from users")
op.rename_table('temp_user', 'user')
op.drop_table('users')
def downgrade():
op.create_table(
"manifest_uploads",
sa.Column("_created",
postgresql.TIMESTAMP(),
autoincrement=False,
nullable=True),
sa.Column("_updated",
postgresql.TIMESTAMP(),
autoincrement=False,
nullable=True),
sa.Column("_etag",
sa.VARCHAR(length=40),
autoincrement=False,
nullable=True),
sa.Column("id", sa.INTEGER(), autoincrement=True, nullable=False),
sa.Column("gcs_xlsx_uri",
sa.VARCHAR(),
autoincrement=False,
nullable=False),
sa.Column("uploader_email",
sa.VARCHAR(),
autoincrement=False,
nullable=True),
sa.Column("trial_id",
sa.VARCHAR(),
autoincrement=False,
nullable=False),
sa.Column("manifest_type",
sa.VARCHAR(),
autoincrement=False,
nullable=False),
sa.Column(
"metadata_patch",
postgresql.JSONB(astext_type=sa.Text()),
autoincrement=False,
nullable=False,
),
sa.ForeignKeyConstraint(
["trial_id"],
["trial_metadata.trial_id"],
name="manifest_uploads_trial_id_fkey",
),
sa.ForeignKeyConstraint(
["uploader_email"],
["users.email"],
name="manifest_uploads_uploader_email_fkey",
onupdate="CASCADE",
),
sa.PrimaryKeyConstraint("id", name="manifest_uploads_pkey"),
)
op.create_index("ix_manifest_uploads_trial_id",
"manifest_uploads", ["trial_id"],
unique=False)
conn = op.get_bind()
# Transfer data from upload_jobs to manifest_uploads
conn.execute("""
INSERT INTO manifest_uploads(_created, _updated, _etag, gcs_xlsx_uri, metadata_patch, manifest_type, uploader_email, trial_id)
SELECT _created, _updated, _etag, gcs_xlsx_uri, metadata_patch, upload_type, uploader_email, trial_id from upload_jobs
""")
# Drop manifest records
conn.execute("DELETE FROM upload_jobs WHERE multifile = true")
conn.execute("ALTER TYPE upload_job_status RENAME TO assay_upload_status")
conn.execute("ALTER TABLE upload_jobs RENAME TO assay_uploads")
conn.execute(
"ALTER TABLE assay_uploads RENAME COLUMN upload_type TO assay_type")
conn.execute(
"ALTER TABLE assay_uploads RENAME COLUMN metadata_patch TO assay_patch"
)
conn.execute(
"ALTER TABLE assay_uploads ALTER COLUMN gcs_file_map SET NOT NULL")
conn.execute("ALTER TABLE assay_uploads DROP COLUMN multifile")
conn.execute(
"ALTER TABLE assay_uploads DROP CONSTRAINT check_gcs_file_map")
op.drop_index("ix_manifest_uploads_trial_id",
table_name="manifest_uploads")
op.drop_table("manifest_uploads")
conn.execute(
"ALTER INDEX upload_jobs_gcs_gcs_file_map_idx RENAME TO assay_uploads_gcs_gcs_file_map_idx"
)
conn.execute(
"ALTER INDEX ix_upload_jobs_trial_id RENAME TO ix_assay_uploads_trial_id"
)
conn.execute("ALTER TYPE upload_job_status RENAME TO assay_upload_status")
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table(
'admin', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('username', sa.String(length=64), nullable=False),
sa.Column('password', sa.String(length=64), nullable=False),
sa.Column('avatar', sa.String(length=256), nullable=False),
sa.Column('phone', sa.String(length=11), nullable=False),
sa.Column('power', sa.Enum('超级管理员', '普通管理员'), nullable=False),
sa.Column('status', sa.Boolean(), nullable=False),
sa.Column('create_time', sa.DateTime(), nullable=True),
sa.Column('update_time', sa.DateTime(), nullable=True),
sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('phone'),
sa.UniqueConstraint('username'))
op.create_index(op.f('ix_admin_create_time'),
'admin', ['create_time'],
unique=False)
op.create_table('tag', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('name', sa.String(length=16), nullable=False),
sa.Column('status', sa.Boolean(), nullable=False),
sa.Column('create_time', sa.DateTime(), nullable=True),
sa.PrimaryKeyConstraint('id'))
op.create_index(op.f('ix_tag_create_time'),
'tag', ['create_time'],
unique=False)
op.create_table(
'trace_main', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('file_real_name', sa.String(length=256), nullable=False),
sa.Column('file_format_name', sa.String(length=256), nullable=False),
sa.Column('file_path', sa.String(length=256), nullable=False),
sa.Column('send_file_time', sa.DateTime(), nullable=True),
sa.Column('receive_file_time', sa.DateTime(), nullable=True),
sa.Column('trace_moe_id', sa.Integer(), nullable=False),
sa.Column('search_type', sa.Enum('upload', 'link'), nullable=False),
sa.Column('status', sa.Enum('-1', '1', '2', '3', '0'), nullable=False),
sa.Column('return_result_time', sa.DateTime(), nullable=True),
sa.Column('result_format', sa.Text(), nullable=False),
sa.PrimaryKeyConstraint('id'))
op.create_index(op.f('ix_trace_main_send_file_time'),
'trace_main', ['send_file_time'],
unique=False)
op.create_table(
'trace_moe', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('start_time', sa.DateTime(), nullable=True),
sa.Column('get_response_time', sa.DateTime(), nullable=True),
sa.Column('result_json', sa.Text(), nullable=False),
sa.Column('chinese_name_list', sa.Text(), nullable=False),
sa.PrimaryKeyConstraint('id'))
op.create_index(op.f('ix_trace_moe_start_time'),
'trace_moe', ['start_time'],
unique=False)
op.create_table(
'user', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('username', sa.String(length=64), nullable=False),
sa.Column('password', sa.String(length=64), nullable=False),
sa.Column('avatar', sa.String(length=256), nullable=False),
sa.Column('phone', sa.String(length=11), nullable=False),
sa.Column('status', sa.Boolean(), nullable=False),
sa.Column('create_time', sa.DateTime(), nullable=True),
sa.Column('update_time', sa.DateTime(), nullable=True),
sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('phone'),
sa.UniqueConstraint('username'))
op.create_index(op.f('ix_user_create_time'),
'user', ['create_time'],
unique=False)
op.create_table('admin_login_log',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('admin_id', sa.Integer(), nullable=True),
sa.Column('ip', sa.String(length=64), nullable=False),
sa.Column('create_time', sa.DateTime(), nullable=True),
sa.ForeignKeyConstraint(
['admin_id'],
['admin.id'],
), sa.PrimaryKeyConstraint('id'))
op.create_index(op.f('ix_admin_login_log_create_time'),
'admin_login_log', ['create_time'],
unique=False)
op.create_table('admin_operate_log',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('admin_id', sa.Integer(), nullable=True),
sa.Column('ip', sa.String(length=64), nullable=False),
sa.Column('detail', sa.String(length=128), nullable=False),
sa.Column('create_time', sa.DateTime(), nullable=True),
sa.ForeignKeyConstraint(
['admin_id'],
['admin.id'],
), sa.PrimaryKeyConstraint('id'))
op.create_index(op.f('ix_admin_operate_log_create_time'),
'admin_operate_log', ['create_time'],
unique=False)
op.create_table(
'blog', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('title', sa.String(length=64), nullable=False),
sa.Column('summary', sa.String(length=64), nullable=False),
sa.Column('content', sa.Text(), nullable=False),
sa.Column('logo', sa.String(length=256), nullable=False),
sa.Column('status', sa.Enum('发布', '草稿', '删除'), nullable=False),
sa.Column('admin_id', sa.Integer(), nullable=True),
sa.Column('page_views', sa.Integer(), nullable=True),
sa.Column('like_numbers', sa.Integer(), nullable=True),
sa.Column('comment_numbers', sa.Integer(), nullable=True),
sa.Column('create_time', sa.DateTime(), nullable=True),
sa.ForeignKeyConstraint(
['admin_id'],
['admin.id'],
), sa.PrimaryKeyConstraint('id'))
op.create_index(op.f('ix_blog_create_time'),
'blog', ['create_time'],
unique=False)
op.create_table('board', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('title', sa.String(length=64), nullable=False),
sa.Column('content', sa.Text(), nullable=False),
sa.Column('status', sa.Boolean(), nullable=False),
sa.Column('create_time', sa.DateTime(), nullable=True),
sa.Column('admin_id', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(
['admin_id'],
['admin.id'],
), sa.PrimaryKeyConstraint('id'))
op.create_index(op.f('ix_board_create_time'),
'board', ['create_time'],
unique=False)
op.create_table('message', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('user_id', sa.Integer(), nullable=True),
sa.Column('admin_id', sa.Integer(), nullable=True),
sa.Column('content', sa.Text(), nullable=False),
sa.Column('status', sa.Boolean(), nullable=False),
sa.Column('create_time', sa.DateTime(), nullable=True),
sa.ForeignKeyConstraint(
['admin_id'],
['admin.id'],
), sa.ForeignKeyConstraint(
['user_id'],
['user.id'],
), sa.PrimaryKeyConstraint('id'))
op.create_index(op.f('ix_message_create_time'),
'message', ['create_time'],
unique=False)
op.create_table('search_history',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('user_id', sa.Integer(), nullable=True),
sa.Column('keyword', sa.String(length=64), nullable=False),
sa.Column('create_time', sa.DateTime(), nullable=True),
sa.ForeignKeyConstraint(
['user_id'],
['user.id'],
), sa.PrimaryKeyConstraint('id'))
op.create_index(op.f('ix_search_history_create_time'),
'search_history', ['create_time'],
unique=False)
op.create_table('blog_to_tag', sa.Column('id',
sa.Integer(),
nullable=False),
sa.Column('tag_id', sa.Integer(), nullable=False),
sa.Column('blog_id', sa.Integer(), nullable=False),
sa.ForeignKeyConstraint(
['blog_id'],
['blog.id'],
), sa.ForeignKeyConstraint(
['tag_id'],
['tag.id'],
), sa.PrimaryKeyConstraint('id'))
op.create_table('collect_blog',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('user_id', sa.Integer(), nullable=True),
sa.Column('blog_id', sa.Integer(), nullable=True),
sa.Column('status', sa.Boolean(), nullable=False),
sa.Column('create_time', sa.DateTime(), nullable=True),
sa.ForeignKeyConstraint(
['blog_id'],
['blog.id'],
), sa.ForeignKeyConstraint(
['user_id'],
['user.id'],
), sa.PrimaryKeyConstraint('id'))
op.create_index(op.f('ix_collect_blog_create_time'),
'collect_blog', ['create_time'],
unique=False)
op.create_table('comment', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('sender_id', sa.Integer(), nullable=True),
sa.Column('blog_id', sa.Integer(), nullable=True),
sa.Column('content', sa.Text(), nullable=False),
sa.Column('status', sa.Boolean(), nullable=False),
sa.Column('create_time', sa.DateTime(), nullable=True),
sa.ForeignKeyConstraint(
['blog_id'],
['blog.id'],
), sa.ForeignKeyConstraint(
['sender_id'],
['user.id'],
), sa.PrimaryKeyConstraint('id'))
op.create_index(op.f('ix_comment_create_time'),
'comment', ['create_time'],
unique=False)
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('corporation', sa.Column('id',
sa.Integer(),
nullable=False),
sa.Column('timestamp', sa.DateTime(), nullable=True),
sa.Column('creator_user_id', sa.Integer(), nullable=True),
sa.Column('slug', sa.String(length=128), nullable=True),
sa.Column('active', sa.Boolean(), nullable=True),
sa.Column('archived', sa.Boolean(), nullable=True),
sa.Column('name', sa.String(length=64), nullable=True),
sa.Column('about', sa.String(length=140), nullable=True),
sa.PrimaryKeyConstraint('id'))
with op.batch_alter_table('corporation', schema=None) as batch_op:
batch_op.create_index(batch_op.f('ix_corporation_slug'), ['slug'],
unique=True)
op.create_table('role', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('active', sa.Boolean(), nullable=True),
sa.Column('archived', sa.Boolean(), nullable=True),
sa.Column('code', sa.Integer(), nullable=False),
sa.Column('name', sa.String(length=120), nullable=False),
sa.Column('about', sa.String(length=120), nullable=True),
sa.PrimaryKeyConstraint('id'))
with op.batch_alter_table('role', schema=None) as batch_op:
batch_op.create_index(batch_op.f('ix_role_about'), ['about'],
unique=True)
batch_op.create_index(batch_op.f('ix_role_code'), ['code'],
unique=False)
batch_op.create_index(batch_op.f('ix_role_name'), ['name'],
unique=True)
op.create_table(
'user', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('timestamp', sa.DateTime(), nullable=True),
sa.Column('slug', sa.String(length=128), nullable=True),
sa.Column('active', sa.Boolean(), nullable=True),
sa.Column('archived', sa.Boolean(), nullable=True),
sa.Column('username', sa.String(length=64), nullable=True),
sa.Column('password_hash', sa.String(length=128), nullable=True),
sa.Column('email', sa.String(length=120), nullable=True),
sa.Column('about', sa.String(length=140), nullable=True),
sa.PrimaryKeyConstraint('id'))
with op.batch_alter_table('user', schema=None) as batch_op:
batch_op.create_index(batch_op.f('ix_user_email'), ['email'],
unique=True)
batch_op.create_index(batch_op.f('ix_user_slug'), ['slug'],
unique=True)
batch_op.create_index(batch_op.f('ix_user_username'), ['username'],
unique=True)
op.create_table(
'admin', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('timestamp', sa.DateTime(), nullable=True),
sa.Column('creator_user_id', sa.Integer(), nullable=True),
sa.Column('slug', sa.String(length=128), nullable=True),
sa.Column('active', sa.Boolean(), nullable=True),
sa.Column('archived', sa.Boolean(), nullable=True),
sa.Column('about', sa.String(length=140), nullable=True),
sa.Column('email', sa.String(length=120), nullable=True),
sa.Column('phone', sa.Integer(), nullable=True),
sa.Column('first_role_id', sa.Integer(), nullable=True),
sa.Column('user_id', sa.Integer(), nullable=True),
sa.Column('corporation_id', sa.Integer(), nullable=False),
sa.ForeignKeyConstraint(
['corporation_id'],
['corporation.id'],
), sa.ForeignKeyConstraint(
['first_role_id'],
['role.id'],
), sa.ForeignKeyConstraint(
['user_id'],
['user.id'],
), sa.PrimaryKeyConstraint('id'))
with op.batch_alter_table('admin', schema=None) as batch_op:
batch_op.create_index(batch_op.f('ix_admin_email'), ['email'],
unique=True)
batch_op.create_index(batch_op.f('ix_admin_phone'), ['phone'],
unique=True)
batch_op.create_index(batch_op.f('ix_admin_slug'), ['slug'],
unique=True)
op.create_table(
'client', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('timestamp', sa.DateTime(), nullable=True),
sa.Column('creator_user_id', sa.Integer(), nullable=True),
sa.Column('slug', sa.String(length=128), nullable=True),
sa.Column('active', sa.Boolean(), nullable=True),
sa.Column('archived', sa.Boolean(), nullable=True),
sa.Column('about', sa.String(length=140), nullable=True),
sa.Column('user_id', sa.Integer(), nullable=True),
sa.Column('corporation_id', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(
['corporation_id'],
['corporation.id'],
), sa.ForeignKeyConstraint(
['user_id'],
['user.id'],
), sa.PrimaryKeyConstraint('id'))
with op.batch_alter_table('client', schema=None) as batch_op:
batch_op.create_index(batch_op.f('ix_client_slug'), ['slug'],
unique=True)
op.create_table(
'company', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('timestamp', sa.DateTime(), nullable=True),
sa.Column('creator_user_id', sa.Integer(), nullable=True),
sa.Column('slug', sa.String(length=128), nullable=True),
sa.Column('active', sa.Boolean(), nullable=True),
sa.Column('archived', sa.Boolean(), nullable=True),
sa.Column('name', sa.String(length=64), nullable=True),
sa.Column('about', sa.String(length=140), nullable=True),
sa.Column('corporation_id', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(
['corporation_id'],
['corporation.id'],
), sa.PrimaryKeyConstraint('id'))
with op.batch_alter_table('company', schema=None) as batch_op:
batch_op.create_index(batch_op.f('ix_company_slug'), ['slug'],
unique=True)
op.create_table(
'employee', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('timestamp', sa.DateTime(), nullable=True),
sa.Column('creator_user_id', sa.Integer(), nullable=True),
sa.Column('slug', sa.String(length=128), nullable=True),
sa.Column('active', sa.Boolean(), nullable=True),
sa.Column('archived', sa.Boolean(), nullable=True),
sa.Column('first_name', sa.String(length=64), nullable=True),
sa.Column('last_name', sa.String(length=64), nullable=True),
sa.Column('about', sa.String(length=140), nullable=True),
sa.Column('email', sa.String(length=120), nullable=True),
sa.Column('phone', sa.Integer(), nullable=True),
sa.Column('first_role_id', sa.Integer(), nullable=True),
sa.Column('user_id', sa.Integer(), nullable=True),
sa.Column('corporation_id', sa.Integer(), nullable=True),
sa.Column('company_id', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(
['company_id'],
['company.id'],
), sa.ForeignKeyConstraint(
['corporation_id'],
['corporation.id'],
), sa.ForeignKeyConstraint(
['first_role_id'],
['role.id'],
), sa.ForeignKeyConstraint(
['user_id'],
['user.id'],
), sa.PrimaryKeyConstraint('id'))
with op.batch_alter_table('employee', schema=None) as batch_op:
batch_op.create_index(batch_op.f('ix_employee_email'), ['email'],
unique=True)
batch_op.create_index(batch_op.f('ix_employee_phone'), ['phone'],
unique=True)
batch_op.create_index(batch_op.f('ix_employee_slug'), ['slug'],
unique=True)
op.create_table(
'group_client_places', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('timestamp', sa.DateTime(), nullable=True),
sa.Column('creator_user_id', sa.Integer(), nullable=True),
sa.Column('slug', sa.String(length=128), nullable=True),
sa.Column('active', sa.Boolean(), nullable=True),
sa.Column('archived', sa.Boolean(), nullable=True),
sa.Column('slug_link', sa.String(length=128), nullable=True),
sa.Column('name', sa.String(length=64), nullable=True),
sa.Column('about', sa.String(length=140), nullable=True),
sa.Column('company_id', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(
['company_id'],
['company.id'],
), sa.PrimaryKeyConstraint('id'))
with op.batch_alter_table('group_client_places', schema=None) as batch_op:
batch_op.create_index(batch_op.f('ix_group_client_places_slug'),
['slug'],
unique=True)
batch_op.create_index(batch_op.f('ix_group_client_places_slug_link'),
['slug_link'],
unique=True)
op.create_table(
'client_place', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('timestamp', sa.DateTime(), nullable=True),
sa.Column('creator_user_id', sa.Integer(), nullable=True),
sa.Column('slug', sa.String(length=128), nullable=True),
sa.Column('active', sa.Boolean(), nullable=True),
sa.Column('archived', sa.Boolean(), nullable=True),
sa.Column('slug_link', sa.String(length=128), nullable=True),
sa.Column('name', sa.String(length=64), nullable=True),
sa.Column('company_id', sa.Integer(), nullable=True),
sa.Column('group_client_places_id', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(
['company_id'],
['company.id'],
),
sa.ForeignKeyConstraint(
['group_client_places_id'],
['group_client_places.id'],
), sa.PrimaryKeyConstraint('id'))
with op.batch_alter_table('client_place', schema=None) as batch_op:
batch_op.create_index(batch_op.f('ix_client_place_slug'), ['slug'],
unique=True)
batch_op.create_index(batch_op.f('ix_client_place_slug_link'),
['slug_link'],
unique=True)
op.create_table(
'employees_to_groups_client_places',
sa.Column('employee_id', sa.Integer(), nullable=True),
sa.Column('group_client_places_id', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(
['employee_id'],
['employee.id'],
),
sa.ForeignKeyConstraint(
['group_client_places_id'],
['group_client_places.id'],
))
op.create_table(
'employees_to_client_places',
sa.Column('employee_id', sa.Integer(), nullable=True),
sa.Column('client_place_id', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(
['client_place_id'],
['client_place.id'],
), sa.ForeignKeyConstraint(
['employee_id'],
['employee.id'],
))
def upgrade_nec():
op.create_table(
'ofctenants',
sa.Column('id', sa.String(length=36), nullable=False),
sa.Column('quantum_id', sa.String(length=36), nullable=False),
sa.PrimaryKeyConstraint('id')
)
op.create_table(
'ofcnetworks',
sa.Column('id', sa.String(length=36), nullable=False),
sa.Column('quantum_id', sa.String(length=36), nullable=False),
sa.PrimaryKeyConstraint('id')
)
op.create_table(
'ofcports',
sa.Column('id', sa.String(length=36), nullable=False),
sa.Column('quantum_id', sa.String(length=36), nullable=False),
sa.PrimaryKeyConstraint('id')
)
op.create_table(
'ofcfilters',
sa.Column('id', sa.String(length=36), nullable=False),
sa.Column('quantum_id', sa.String(length=36), nullable=False),
sa.PrimaryKeyConstraint('id')
)
op.create_table(
'portinfos',
sa.Column('id', sa.String(length=36), nullable=False),
sa.Column('datapath_id', sa.String(length=36), nullable=False),
sa.Column('port_no', sa.Integer(), nullable=False),
sa.Column('vlan_id', sa.Integer(), nullable=False),
sa.Column('mac', sa.String(length=32), nullable=False),
sa.PrimaryKeyConstraint('id')
)
op.create_table(
'packetfilters',
sa.Column('tenant_id', sa.String(length=255), nullable=True),
sa.Column('id', sa.String(length=36), nullable=False),
sa.Column('network_id', sa.String(length=36), nullable=False),
sa.Column('priority', sa.Integer(), nullable=False),
sa.Column('action', sa.String(16), nullable=False),
sa.Column('in_port', sa.String(36), nullable=False),
sa.Column('src_mac', sa.String(32), nullable=False),
sa.Column('dst_mac', sa.String(32), nullable=False),
sa.Column('eth_type', sa.Integer(), nullable=False),
sa.Column('src_cidr', sa.String(64), nullable=False),
sa.Column('dst_cidr', sa.String(64), nullable=False),
sa.Column('protocol', sa.String(16), nullable=False),
sa.Column('src_port', sa.Integer(), nullable=False),
sa.Column('dst_port', sa.Integer(), nullable=False),
sa.Column('admin_state_up', sa.Boolean(), nullable=False),
sa.Column('status', sa.String(16), nullable=False),
sa.ForeignKeyConstraint(['network_id'], ['networks.id'],
ondelete='CASCADE'),
sa.PrimaryKeyConstraint('id')
)
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('category',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('categoryname', sa.String(length=255), nullable=True),
sa.Column('description', sa.Text(length=500), nullable=True),
sa.PrimaryKeyConstraint('id')
)
op.create_index(op.f('ix_category_categoryname'), 'category', ['categoryname'], unique=True)
op.create_table('customer',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('customername', sa.String(length=255), nullable=True),
sa.Column('contactname', sa.String(length=255), nullable=True),
sa.Column('address', sa.String(length=255), nullable=True),
sa.Column('city', sa.String(length=255), nullable=True),
sa.Column('postalcode', sa.String(length=255), nullable=True),
sa.Column('country', sa.String(length=255), nullable=True),
sa.PrimaryKeyConstraint('id')
)
op.create_index(op.f('ix_customer_address'), 'customer', ['address'], unique=False)
op.create_index(op.f('ix_customer_city'), 'customer', ['city'], unique=False)
op.create_index(op.f('ix_customer_contactname'), 'customer', ['contactname'], unique=False)
op.create_index(op.f('ix_customer_country'), 'customer', ['country'], unique=False)
op.create_index(op.f('ix_customer_customername'), 'customer', ['customername'], unique=False)
op.create_index(op.f('ix_customer_postalcode'), 'customer', ['postalcode'], unique=False)
op.create_table('employee',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('lastname', sa.String(length=255), nullable=True),
sa.Column('firstname', sa.String(length=255), nullable=True),
sa.Column('birthdate', sa.Date(), nullable=True),
sa.Column('notes', sa.Text(length=1000), nullable=True),
sa.PrimaryKeyConstraint('id')
)
op.create_index(op.f('ix_employee_firstname'), 'employee', ['firstname'], unique=False)
op.create_index(op.f('ix_employee_lastname'), 'employee', ['lastname'], unique=False)
op.create_table('shipper',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('productname', sa.String(length=255), nullable=True),
sa.Column('phone', sa.String(length=25), nullable=True),
sa.PrimaryKeyConstraint('id')
)
op.create_index(op.f('ix_shipper_phone'), 'shipper', ['phone'], unique=False)
op.create_index(op.f('ix_shipper_productname'), 'shipper', ['productname'], unique=False)
op.create_table('supplier',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('suppliername', sa.String(length=255), nullable=True),
sa.Column('contactname', sa.String(length=255), nullable=True),
sa.Column('address', sa.String(length=255), nullable=True),
sa.Column('city', sa.String(length=255), nullable=True),
sa.Column('postalcode', sa.String(length=255), nullable=True),
sa.Column('country', sa.String(length=255), nullable=True),
sa.Column('phone', sa.String(length=25), nullable=True),
sa.PrimaryKeyConstraint('id')
)
op.create_index(op.f('ix_supplier_address'), 'supplier', ['address'], unique=False)
op.create_index(op.f('ix_supplier_city'), 'supplier', ['city'], unique=False)
op.create_index(op.f('ix_supplier_contactname'), 'supplier', ['contactname'], unique=False)
op.create_index(op.f('ix_supplier_country'), 'supplier', ['country'], unique=False)
op.create_index(op.f('ix_supplier_phone'), 'supplier', ['phone'], unique=False)
op.create_index(op.f('ix_supplier_postalcode'), 'supplier', ['postalcode'], unique=False)
op.create_index(op.f('ix_supplier_suppliername'), 'supplier', ['suppliername'], unique=False)
op.create_table('user',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('username', sa.String(length=64), nullable=True),
sa.Column('email', sa.String(length=120), nullable=True),
sa.Column('password_hash', sa.String(length=128), nullable=True),
sa.Column('about_me', sa.String(length=255), nullable=True),
sa.Column('last_seen', sa.DateTime(), nullable=True),
sa.PrimaryKeyConstraint('id')
)
op.create_index(op.f('ix_user_email'), 'user', ['email'], unique=True)
op.create_index(op.f('ix_user_username'), 'user', ['username'], unique=True)
op.create_table('followers',
sa.Column('follower_id', sa.Integer(), nullable=True),
sa.Column('followed_id', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(['followed_id'], ['user.id'], ),
sa.ForeignKeyConstraint(['follower_id'], ['user.id'], )
)
op.create_table('order',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('customer_id', sa.Integer(), nullable=True),
sa.Column('employee_id', sa.Integer(), nullable=True),
sa.Column('orderdate', sa.Date(), nullable=True),
sa.Column('shipper_id', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(['customer_id'], ['customer.id'], ),
sa.ForeignKeyConstraint(['employee_id'], ['employee.id'], ),
sa.ForeignKeyConstraint(['shipper_id'], ['shipper.id'], ),
sa.PrimaryKeyConstraint('id')
)
op.create_table('post',
sa.Column('body', sa.String(length=140), nullable=True),
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('timestamp', sa.DateTime(), nullable=True),
sa.Column('user_id', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(['user_id'], ['user.id'], ),
sa.PrimaryKeyConstraint('id')
)
op.create_index(op.f('ix_post_timestamp'), 'post', ['timestamp'], unique=False)
op.create_table('product',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('productname', sa.String(length=255), nullable=True),
sa.Column('supplier_id', sa.Integer(), nullable=True),
sa.Column('category_id', sa.Integer(), nullable=True),
sa.Column('unit', sa.Integer(), nullable=True),
sa.Column('price', sa.Numeric(), nullable=True),
sa.ForeignKeyConstraint(['category_id'], ['category.id'], ),
sa.ForeignKeyConstraint(['supplier_id'], ['supplier.id'], ),
sa.PrimaryKeyConstraint('id')
)
op.create_index(op.f('ix_product_productname'), 'product', ['productname'], unique=False)
op.create_table('order_detail',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('order_id', sa.Integer(), nullable=True),
sa.Column('product_id', sa.Integer(), nullable=True),
sa.Column('quantity', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(['order_id'], ['order.id'], ),
sa.ForeignKeyConstraint(['product_id'], ['product.id'], ),
sa.PrimaryKeyConstraint('id')
)
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table(
'examtype',
sa.Column('exam_type_id',
sa.Integer(),
autoincrement=True,
nullable=False),
sa.Column('exam_type_name', sa.String(length=25), nullable=False),
sa.Column('exam_color', sa.String(length=10), nullable=False),
sa.Column('number_of_hours', sa.Integer(), nullable=False),
sa.Column('method_type', sa.String(length=10), nullable=False),
sa.Column('ita_ind', sa.Integer(), nullable=False),
sa.PrimaryKeyConstraint('exam_type_id'))
op.create_table(
'invigilator',
sa.Column('invigilator_id',
sa.Integer(),
autoincrement=True,
nullable=False),
sa.Column('office_id', sa.Integer(), nullable=False),
sa.Column('invigilator_name', sa.String(length=50), nullable=False),
sa.Column('invigilator_notes', sa.String(length=400), nullable=True),
sa.Column('contact_phone', sa.String(length=15), nullable=True),
sa.Column('contact_email', sa.String(length=50), nullable=True),
sa.Column('contract_number', sa.String(length=50), nullable=False),
sa.Column('contract_expiry_date', sa.String(length=50),
nullable=False),
sa.ForeignKeyConstraint(
['office_id'],
['office.office_id'],
), sa.PrimaryKeyConstraint('invigilator_id'))
op.create_table(
'room',
sa.Column('room_id', sa.Integer(), autoincrement=True, nullable=False),
sa.Column('office_id', sa.Integer(), nullable=False),
sa.Column('room_name', sa.String(length=50), nullable=False),
sa.Column('capacity', sa.Integer(), nullable=False),
sa.Column('color', sa.String(length=25), nullable=False),
sa.ForeignKeyConstraint(
['office_id'],
['office.office_id'],
), sa.PrimaryKeyConstraint('room_id'))
op.create_table(
'booking',
sa.Column('booking_id',
sa.Integer(),
autoincrement=True,
nullable=False),
sa.Column('room_id', sa.Integer(), nullable=False),
sa.Column('start_time', sa.DateTime(), nullable=False),
sa.Column('end_time', sa.DateTime(), nullable=False),
sa.Column('fees', sa.String(length=5), nullable=True),
sa.Column('booking_name', sa.String(length=150), nullable=True),
sa.ForeignKeyConstraint(
['room_id'],
['room.room_id'],
), sa.PrimaryKeyConstraint('booking_id'))
op.create_table(
'exam',
sa.Column('exam_id', sa.Integer(), autoincrement=True, nullable=False),
sa.Column('booking_id', sa.Integer(), nullable=True),
sa.Column('exam_type_id', sa.Integer(), nullable=False),
sa.Column('invigilator_id', sa.Integer(), nullable=False),
sa.Column('office_id', sa.Integer(), nullable=False),
sa.Column('room_id', sa.Integer(), nullable=False),
sa.Column('event_id', sa.String(length=25), nullable=False),
sa.Column('exam_name', sa.String(length=50), nullable=False),
sa.Column('examinee_name', sa.String(length=50), nullable=False),
sa.Column('expiry_date', sa.DateTime(), nullable=False),
sa.Column('notes', sa.String(length=400), nullable=True),
sa.Column('exam_received', sa.Integer(), nullable=False),
sa.Column('session_number', sa.Integer(), nullable=False),
sa.Column('number_of_students', sa.Integer(), nullable=False),
sa.Column('exam_method', sa.String(length=15), nullable=False),
sa.Column('deleted_date', sa.String(length=50), nullable=True),
sa.ForeignKeyConstraint(
['booking_id'],
['booking.booking_id'],
),
sa.ForeignKeyConstraint(
['exam_type_id'],
['examtype.exam_type_id'],
),
sa.ForeignKeyConstraint(
['invigilator_id'],
['invigilator.invigilator_id'],
), sa.ForeignKeyConstraint(
['office_id'],
['office.office_id'],
), sa.ForeignKeyConstraint(
['room_id'],
['room.room_id'],
), sa.PrimaryKeyConstraint('exam_id'))
def downgrade():
### commands auto generated by Alembic - please adjust! ###
op.create_table('injured_position',
sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('injured_position_hebrew', sa.TEXT(), autoincrement=False, nullable=True),
sa.Column('provider_code', sa.INTEGER(), autoincrement=False, nullable=True),
sa.Column('year', sa.INTEGER(), autoincrement=False, nullable=True),
sa.PrimaryKeyConstraint('id', name='injured_position_pkey')
)
op.create_table('cross_location',
sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('cross_location_hebrew', sa.TEXT(), autoincrement=False, nullable=True),
sa.Column('provider_code', sa.INTEGER(), autoincrement=False, nullable=True),
sa.Column('year', sa.INTEGER(), autoincrement=False, nullable=True),
sa.PrimaryKeyConstraint('id', name='cross_location_pkey')
)
op.create_table('geo_area',
sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('geo_area_hebrew', sa.TEXT(), autoincrement=False, nullable=True),
sa.Column('provider_code', sa.INTEGER(), autoincrement=False, nullable=True),
sa.Column('year', sa.INTEGER(), autoincrement=False, nullable=True),
sa.PrimaryKeyConstraint('id', name='geo_area_pkey')
)
op.create_table('road_intactness',
sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('road_intactness_hebrew', sa.TEXT(), autoincrement=False, nullable=True),
sa.Column('provider_code', sa.INTEGER(), autoincrement=False, nullable=True),
sa.Column('year', sa.INTEGER(), autoincrement=False, nullable=True),
sa.PrimaryKeyConstraint('id', name='road_intactness_pkey')
)
op.create_table('road_surface',
sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('road_surface_hebrew', sa.TEXT(), autoincrement=False, nullable=True),
sa.Column('provider_code', sa.INTEGER(), autoincrement=False, nullable=True),
sa.Column('year', sa.INTEGER(), autoincrement=False, nullable=True),
sa.PrimaryKeyConstraint('id', name='road_surface_pkey')
)
op.create_table('day_night',
sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('day_night_hebrew', sa.TEXT(), autoincrement=False, nullable=True),
sa.Column('provider_code', sa.INTEGER(), autoincrement=False, nullable=True),
sa.Column('year', sa.INTEGER(), autoincrement=False, nullable=True),
sa.PrimaryKeyConstraint('id', name='day_night_pkey')
)
op.create_table('cross_direction',
sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('cross_direction_hebrew', sa.TEXT(), autoincrement=False, nullable=True),
sa.Column('provider_code', sa.INTEGER(), autoincrement=False, nullable=True),
sa.Column('year', sa.INTEGER(), autoincrement=False, nullable=True),
sa.PrimaryKeyConstraint('id', name='cross_direction_pkey')
)
op.create_table('population_type',
sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('population_type_hebrew', sa.TEXT(), autoincrement=False, nullable=True),
sa.Column('provider_code', sa.INTEGER(), autoincrement=False, nullable=True),
sa.Column('year', sa.INTEGER(), autoincrement=False, nullable=True),
sa.PrimaryKeyConstraint('id', name='population_type_pkey')
)
op.create_table('road_sign',
sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('road_sign_hebrew', sa.TEXT(), autoincrement=False, nullable=True),
sa.Column('provider_code', sa.INTEGER(), autoincrement=False, nullable=True),
sa.Column('year', sa.INTEGER(), autoincrement=False, nullable=True),
sa.PrimaryKeyConstraint('id', name='road_sign_pkey')
)
op.create_table('road_object',
sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('road_object_hebrew', sa.TEXT(), autoincrement=False, nullable=True),
sa.Column('provider_code', sa.INTEGER(), autoincrement=False, nullable=True),
sa.Column('year', sa.INTEGER(), autoincrement=False, nullable=True),
sa.PrimaryKeyConstraint('id', name='road_object_pkey')
)
op.create_table('age_group',
sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('age_group_hebrew', sa.TEXT(), autoincrement=False, nullable=True),
sa.Column('provider_code', sa.INTEGER(), autoincrement=False, nullable=True),
sa.Column('year', sa.INTEGER(), autoincrement=False, nullable=True),
sa.PrimaryKeyConstraint('id', name='age_group_pkey')
)
op.create_table('location_accuracy',
sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('location_accuracy_hebrew', sa.TEXT(), autoincrement=False, nullable=True),
sa.Column('provider_code', sa.INTEGER(), autoincrement=False, nullable=True),
sa.Column('year', sa.INTEGER(), autoincrement=False, nullable=True),
sa.PrimaryKeyConstraint('id', name='location_accuracy_pkey')
)
op.create_table('municipal_status',
sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('municipal_status_hebrew', sa.TEXT(), autoincrement=False, nullable=True),
sa.Column('provider_code', sa.INTEGER(), autoincrement=False, nullable=True),
sa.Column('year', sa.INTEGER(), autoincrement=False, nullable=True),
sa.PrimaryKeyConstraint('id', name='municipal_status_pkey')
)
op.create_table('didnt_cross',
sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('didnt_cross_hebrew', sa.TEXT(), autoincrement=False, nullable=True),
sa.Column('provider_code', sa.INTEGER(), autoincrement=False, nullable=True),
sa.Column('year', sa.INTEGER(), autoincrement=False, nullable=True),
sa.PrimaryKeyConstraint('id', name='didnt_cross_pkey')
)
op.create_table('road_control',
sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('road_control_hebrew', sa.TEXT(), autoincrement=False, nullable=True),
sa.Column('provider_code', sa.INTEGER(), autoincrement=False, nullable=True),
sa.Column('year', sa.INTEGER(), autoincrement=False, nullable=True),
sa.PrimaryKeyConstraint('id', name='road_control_pkey')
)
op.create_table('medical_type',
sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('medical_type_hebrew', sa.TEXT(), autoincrement=False, nullable=True),
sa.Column('provider_code', sa.INTEGER(), autoincrement=False, nullable=True),
sa.Column('year', sa.INTEGER(), autoincrement=False, nullable=True),
sa.PrimaryKeyConstraint('id', name='medical_type_pkey')
)
op.create_table('vehicle_attribution',
sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('vehicle_attribution_hebrew', sa.TEXT(), autoincrement=False, nullable=True),
sa.Column('provider_code', sa.INTEGER(), autoincrement=False, nullable=True),
sa.Column('year', sa.INTEGER(), autoincrement=False, nullable=True),
sa.PrimaryKeyConstraint('id', name='vehicle_attribution_pkey')
)
op.create_table('sex',
sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('sex_hebrew', sa.TEXT(), autoincrement=False, nullable=True),
sa.Column('provider_code', sa.INTEGER(), autoincrement=False, nullable=True),
sa.Column('year', sa.INTEGER(), autoincrement=False, nullable=True),
sa.PrimaryKeyConstraint('id', name='sex_pkey')
)
op.create_table('injury_severity',
sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('injury_severity_hebrew', sa.TEXT(), autoincrement=False, nullable=True),
sa.Column('provider_code', sa.INTEGER(), autoincrement=False, nullable=True),
sa.Column('year', sa.INTEGER(), autoincrement=False, nullable=True),
sa.PrimaryKeyConstraint('id', name='injury_severity_pkey')
)
op.create_table('object_distance',
sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('object_distance_hebrew', sa.TEXT(), autoincrement=False, nullable=True),
sa.Column('provider_code', sa.INTEGER(), autoincrement=False, nullable=True),
sa.Column('year', sa.INTEGER(), autoincrement=False, nullable=True),
sa.PrimaryKeyConstraint('id', name='object_distance_pkey')
)
op.create_table('vehicle_type',
sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('vehicle_type_hebrew', sa.TEXT(), autoincrement=False, nullable=True),
sa.Column('provider_code', sa.INTEGER(), autoincrement=False, nullable=True),
sa.Column('year', sa.INTEGER(), autoincrement=False, nullable=True),
sa.PrimaryKeyConstraint('id', name='vehicle_type_pkey')
)
op.create_table('driving_directions',
sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('driving_directions_hebrew', sa.TEXT(), autoincrement=False, nullable=True),
sa.Column('provider_code', sa.INTEGER(), autoincrement=False, nullable=True),
sa.Column('year', sa.INTEGER(), autoincrement=False, nullable=True),
sa.PrimaryKeyConstraint('id', name='driving_directions_pkey')
)
op.create_table('police_unit',
sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('police_unit_hebrew', sa.TEXT(), autoincrement=False, nullable=True),
sa.Column('provider_code', sa.INTEGER(), autoincrement=False, nullable=True),
sa.Column('year', sa.INTEGER(), autoincrement=False, nullable=True),
sa.PrimaryKeyConstraint('id', name='police_unit_pkey')
)
op.create_table('safety_measures_use',
sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('safety_measures_use_hebrew', sa.TEXT(), autoincrement=False, nullable=True),
sa.Column('provider_code', sa.INTEGER(), autoincrement=False, nullable=True),
sa.Column('year', sa.INTEGER(), autoincrement=False, nullable=True),
sa.PrimaryKeyConstraint('id', name='safety_measures_use_pkey')
)
op.create_table('vehicle_status',
sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('vehicle_status_hebrew', sa.TEXT(), autoincrement=False, nullable=True),
sa.Column('provider_code', sa.INTEGER(), autoincrement=False, nullable=True),
sa.Column('year', sa.INTEGER(), autoincrement=False, nullable=True),
sa.PrimaryKeyConstraint('id', name='vehicle_status_pkey')
)
op.create_table('total_weight',
sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('total_weight_hebrew', sa.TEXT(), autoincrement=False, nullable=True),
sa.Column('provider_code', sa.INTEGER(), autoincrement=False, nullable=True),
sa.Column('year', sa.INTEGER(), autoincrement=False, nullable=True),
sa.PrimaryKeyConstraint('id', name='total_weight_pkey')
)
op.create_table('yishuv_shape',
sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('yishuv_shape_hebrew', sa.TEXT(), autoincrement=False, nullable=True),
sa.Column('provider_code', sa.INTEGER(), autoincrement=False, nullable=True),
sa.Column('year', sa.INTEGER(), autoincrement=False, nullable=True),
sa.PrimaryKeyConstraint('id', name='yishuv_shape_pkey')
)
op.create_table('provider_code',
sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('provider_code_hebrew', sa.TEXT(), autoincrement=False, nullable=True),
sa.PrimaryKeyConstraint('id', name='provider_code_pkey')
)
op.create_table('natural_area',
sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('natural_area_hebrew', sa.TEXT(), autoincrement=False, nullable=True),
sa.Column('provider_code', sa.INTEGER(), autoincrement=False, nullable=True),
sa.Column('year', sa.INTEGER(), autoincrement=False, nullable=True),
sa.PrimaryKeyConstraint('id', name='natural_area_pkey')
)
op.create_table('accident_month',
sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('accident_month_hebrew', sa.TEXT(), autoincrement=False, nullable=True),
sa.Column('provider_code', sa.INTEGER(), autoincrement=False, nullable=True),
sa.Column('year', sa.INTEGER(), autoincrement=False, nullable=True),
sa.PrimaryKeyConstraint('id', name='accident_month_pkey')
)
op.create_table('day_in_week',
sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('day_in_week_hebrew', sa.TEXT(), autoincrement=False, nullable=True),
sa.Column('provider_code', sa.INTEGER(), autoincrement=False, nullable=True),
sa.Column('year', sa.INTEGER(), autoincrement=False, nullable=True),
sa.PrimaryKeyConstraint('id', name='day_in_week_pkey')
)
op.create_table('hospital_time',
sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('hospital_time_hebrew', sa.TEXT(), autoincrement=False, nullable=True),
sa.Column('provider_code', sa.INTEGER(), autoincrement=False, nullable=True),
sa.Column('year', sa.INTEGER(), autoincrement=False, nullable=True),
sa.PrimaryKeyConstraint('id', name='hospital_time_pkey')
)
op.create_table('district',
sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('district_hebrew', sa.TEXT(), autoincrement=False, nullable=True),
sa.Column('provider_code', sa.INTEGER(), autoincrement=False, nullable=True),
sa.Column('year', sa.INTEGER(), autoincrement=False, nullable=True),
sa.PrimaryKeyConstraint('id', name='district_pkey')
)
op.create_table('accident_type',
sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('accident_type_hebrew', sa.TEXT(), autoincrement=False, nullable=True),
sa.Column('provider_code', sa.INTEGER(), autoincrement=False, nullable=True),
sa.Column('year', sa.INTEGER(), autoincrement=False, nullable=True),
sa.PrimaryKeyConstraint('id', name='accident_type_pkey')
)
op.create_table('day_type',
sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('day_type_hebrew', sa.TEXT(), autoincrement=False, nullable=True),
sa.Column('provider_code', sa.INTEGER(), autoincrement=False, nullable=True),
sa.Column('year', sa.INTEGER(), autoincrement=False, nullable=True),
sa.PrimaryKeyConstraint('id', name='day_type_pkey')
)
op.create_table('injured_type',
sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('injured_type_hebrew', sa.TEXT(), autoincrement=False, nullable=True),
sa.Column('provider_code', sa.INTEGER(), autoincrement=False, nullable=True),
sa.Column('year', sa.INTEGER(), autoincrement=False, nullable=True),
sa.PrimaryKeyConstraint('id', name='injured_type_pkey')
)
op.create_table('late_deceased',
sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('late_deceased_hebrew', sa.TEXT(), autoincrement=False, nullable=True),
sa.Column('provider_code', sa.INTEGER(), autoincrement=False, nullable=True),
sa.Column('year', sa.INTEGER(), autoincrement=False, nullable=True),
sa.PrimaryKeyConstraint('id', name='late_deceased_pkey')
)
op.create_table('columns_description',
sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('column_description', sa.TEXT(), autoincrement=False, nullable=True),
sa.Column('provider_code', sa.INTEGER(), autoincrement=False, nullable=True),
sa.Column('year', sa.INTEGER(), autoincrement=False, nullable=True),
sa.PrimaryKeyConstraint('id', name='columns_description_pkey')
)
op.create_table('engine_volume',
sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('engine_volume_hebrew', sa.TEXT(), autoincrement=False, nullable=True),
sa.Column('provider_code', sa.INTEGER(), autoincrement=False, nullable=True),
sa.Column('year', sa.INTEGER(), autoincrement=False, nullable=True),
sa.PrimaryKeyConstraint('id', name='engine_volume_pkey')
)
op.create_table('road_width',
sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('road_width_hebrew', sa.TEXT(), autoincrement=False, nullable=True),
sa.Column('provider_code', sa.INTEGER(), autoincrement=False, nullable=True),
sa.Column('year', sa.INTEGER(), autoincrement=False, nullable=True),
sa.PrimaryKeyConstraint('id', name='road_width_pkey')
)
op.create_table('release_dest',
sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('release_dest_hebrew', sa.TEXT(), autoincrement=False, nullable=True),
sa.Column('provider_code', sa.INTEGER(), autoincrement=False, nullable=True),
sa.Column('year', sa.INTEGER(), autoincrement=False, nullable=True),
sa.PrimaryKeyConstraint('id', name='release_dest_pkey')
)
op.create_table('one_lane',
sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('one_lane_hebrew', sa.TEXT(), autoincrement=False, nullable=True),
sa.Column('provider_code', sa.INTEGER(), autoincrement=False, nullable=True),
sa.Column('year', sa.INTEGER(), autoincrement=False, nullable=True),
sa.PrimaryKeyConstraint('id', name='one_lane_pkey')
)
op.create_table('road_light',
sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('road_light_hebrew', sa.TEXT(), autoincrement=False, nullable=True),
sa.Column('provider_code', sa.INTEGER(), autoincrement=False, nullable=True),
sa.Column('year', sa.INTEGER(), autoincrement=False, nullable=True),
sa.PrimaryKeyConstraint('id', name='road_light_pkey')
)
op.create_table('region',
sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('region_hebrew', sa.TEXT(), autoincrement=False, nullable=True),
sa.Column('provider_code', sa.INTEGER(), autoincrement=False, nullable=True),
sa.Column('year', sa.INTEGER(), autoincrement=False, nullable=True),
sa.PrimaryKeyConstraint('id', name='region_pkey')
)
op.create_table('road_type',
sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('road_type_hebrew', sa.TEXT(), autoincrement=False, nullable=True),
sa.Column('provider_code', sa.INTEGER(), autoincrement=False, nullable=True),
sa.Column('year', sa.INTEGER(), autoincrement=False, nullable=True),
sa.PrimaryKeyConstraint('id', name='road_type_pkey')
)
op.create_table('accident_severity',
sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('accident_severity_hebrew', sa.TEXT(), autoincrement=False, nullable=True),
sa.Column('provider_code', sa.INTEGER(), autoincrement=False, nullable=True),
sa.Column('year', sa.INTEGER(), autoincrement=False, nullable=True),
sa.PrimaryKeyConstraint('id', name='accident_severity_pkey')
)
op.create_table('safety_measures',
sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('safety_measures_hebrew', sa.TEXT(), autoincrement=False, nullable=True),
sa.Column('provider_code', sa.INTEGER(), autoincrement=False, nullable=True),
sa.Column('year', sa.INTEGER(), autoincrement=False, nullable=True),
sa.PrimaryKeyConstraint('id', name='safety_measures_pkey')
)
op.create_table('traffic_light',
sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('traffic_light_hebrew', sa.TEXT(), autoincrement=False, nullable=True),
sa.Column('provider_code', sa.INTEGER(), autoincrement=False, nullable=True),
sa.Column('year', sa.INTEGER(), autoincrement=False, nullable=True),
sa.PrimaryKeyConstraint('id', name='traffic_light_pkey')
)
op.create_table('speed_limit',
sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('speed_limit_hebrew', sa.TEXT(), autoincrement=False, nullable=True),
sa.Column('provider_code', sa.INTEGER(), autoincrement=False, nullable=True),
sa.Column('year', sa.INTEGER(), autoincrement=False, nullable=True),
sa.PrimaryKeyConstraint('id', name='speed_limit_pkey')
)
op.create_table('accident_hour_raw',
sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('accident_hour_raw_hebrew', sa.TEXT(), autoincrement=False, nullable=True),
sa.Column('provider_code', sa.INTEGER(), autoincrement=False, nullable=True),
sa.Column('year', sa.INTEGER(), autoincrement=False, nullable=True),
sa.PrimaryKeyConstraint('id', name='accident_hour_raw_pkey')
)
op.create_table('involved_type',
sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('involved_type_hebrew', sa.TEXT(), autoincrement=False, nullable=True),
sa.Column('provider_code', sa.INTEGER(), autoincrement=False, nullable=True),
sa.Column('year', sa.INTEGER(), autoincrement=False, nullable=True),
sa.PrimaryKeyConstraint('id', name='involved_type_pkey')
)
op.create_table('cross_mode',
sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('cross_mode_hebrew', sa.TEXT(), autoincrement=False, nullable=True),
sa.Column('provider_code', sa.INTEGER(), autoincrement=False, nullable=True),
sa.Column('year', sa.INTEGER(), autoincrement=False, nullable=True),
sa.PrimaryKeyConstraint('id', name='cross_mode_pkey')
)
op.create_table('road_shape',
sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('road_shape_hebrew', sa.TEXT(), autoincrement=False, nullable=True),
sa.Column('provider_code', sa.INTEGER(), autoincrement=False, nullable=True),
sa.Column('year', sa.INTEGER(), autoincrement=False, nullable=True),
sa.PrimaryKeyConstraint('id', name='road_shape_pkey')
)
op.create_table('multi_lane',
sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('multi_lane_hebrew', sa.TEXT(), autoincrement=False, nullable=True),
sa.Column('provider_code', sa.INTEGER(), autoincrement=False, nullable=True),
sa.Column('year', sa.INTEGER(), autoincrement=False, nullable=True),
sa.PrimaryKeyConstraint('id', name='multi_lane_pkey')
)
op.create_table('weather',
sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('weather_hebrew', sa.TEXT(), autoincrement=False, nullable=True),
sa.Column('provider_code', sa.INTEGER(), autoincrement=False, nullable=True),
sa.Column('year', sa.INTEGER(), autoincrement=False, nullable=True),
sa.PrimaryKeyConstraint('id', name='weather_pkey')
)
def upgrade():
### commands auto generated by Alembic - please adjust! ###
op.create_table('tb_module',
sa.Column('id', sa.String(length=64), nullable=False),
sa.PrimaryKeyConstraint('id'))
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table(
'device', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('name', sa.String(length=256), nullable=True),
sa.Column('description', sa.String(length=2048), nullable=True),
sa.Column('location', sa.String(length=1024), nullable=True),
sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('description'),
sa.UniqueConstraint('name'))
op.create_table(
'issue', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('name', sa.String(length=256), nullable=False),
sa.Column('description', sa.String(length=1024), nullable=False),
sa.Column('type',
sa.Enum('MAINT_REQD', 'EQUIP_DAMAGED', name='issuetype'),
nullable=False),
sa.Column('device_id', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(
['device_id'],
['device.id'],
), sa.PrimaryKeyConstraint('id'))
op.create_table('security_config',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('name', sa.String(length=120), nullable=False),
sa.Column('device_id', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(
['device_id'],
['device.id'],
), sa.PrimaryKeyConstraint('id'),
sa.UniqueConstraint('name'))
op.create_table(
'sensor', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('name', sa.String(length=120), nullable=True),
sa.Column('identifier', sa.String(length=128), nullable=True),
sa.Column('description', sa.String(length=1024), nullable=True),
sa.Column('device_id', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(
['device_id'],
['device.id'],
), sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('identifier'),
sa.UniqueConstraint('name'))
op.create_table('server_config',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('name', sa.String(length=120), nullable=False),
sa.Column('device_id', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(
['device_id'],
['device.id'],
), sa.PrimaryKeyConstraint('id'),
sa.UniqueConstraint('name'))
op.create_table(
'config_item', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('name', sa.String(length=256), nullable=False),
sa.Column('description', sa.String(length=2048), nullable=False),
sa.Column('value', sa.String(length=1024), nullable=False),
sa.Column('sec_conf_id', sa.Integer(), nullable=True),
sa.Column('serv_conf_id', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(
['sec_conf_id'],
['security_config.id'],
), sa.ForeignKeyConstraint(
['serv_conf_id'],
['server_config.id'],
), sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('description'),
sa.UniqueConstraint('name'))
op.create_table(
'data_point', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('value', sa.Float(), nullable=False),
sa.Column('unit',
sa.Enum('HZ', 'J', 'DB', 'F', 'C', 'KWH', name='unit'),
nullable=False),
sa.Column('sensor_id', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(
['sensor_id'],
['sensor.id'],
), sa.PrimaryKeyConstraint('id'))
op.create_table(
'user', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('first_name', sa.String(length=75), nullable=False),
sa.Column('last_name', sa.String(length=75), nullable=False),
sa.Column('email', sa.String(length=120), nullable=False),
sa.Column('password_hash', sa.String(length=128), nullable=False),
sa.Column('token', sa.String(length=32), nullable=True),
sa.Column('role',
sa.Enum('USER',
'TECHNICIAN',
'MANAGER',
'ADMIN',
name='role'),
nullable=False),
sa.Column('sec_conf_id', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(
['sec_conf_id'],
['security_config.id'],
), sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('email'),
sa.UniqueConstraint('token'))
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('specialty',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('name', sa.String(length=140), nullable=True),
sa.PrimaryKeyConstraint('id')
)
with op.batch_alter_table('specialty', schema=None) as batch_op:
batch_op.create_index(batch_op.f('ix_specialty_name'), ['name'], unique=False)
op.create_table('user',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('username', sa.String(length=64), nullable=True),
sa.Column('email', sa.String(length=120), nullable=True),
sa.Column('password_hash', sa.String(length=128), nullable=True),
sa.Column('about_me', sa.String(length=140), nullable=True),
sa.Column('last_seen', sa.DateTime(), nullable=True),
sa.Column('admin', sa.Boolean(), nullable=True),
sa.Column('specialty_id', sa.Integer(), nullable=True),
sa.Column('last_message_read_time', sa.DateTime(), nullable=True),
sa.ForeignKeyConstraint(['specialty_id'], ['specialty.id'], ),
sa.PrimaryKeyConstraint('id')
)
with op.batch_alter_table('user', schema=None) as batch_op:
batch_op.create_index(batch_op.f('ix_user_email'), ['email'], unique=True)
batch_op.create_index(batch_op.f('ix_user_username'), ['username'], unique=True)
op.create_table('chat',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('user_id', sa.Integer(), nullable=True),
sa.Column('text', sa.Text(), nullable=True),
sa.Column('specialty_id', sa.Integer(), nullable=True),
sa.Column('timestamp', sa.DateTime(), nullable=True),
sa.ForeignKeyConstraint(['specialty_id'], ['specialty.id'], ),
sa.ForeignKeyConstraint(['user_id'], ['user.id'], ),
sa.PrimaryKeyConstraint('id')
)
with op.batch_alter_table('chat', schema=None) as batch_op:
batch_op.create_index(batch_op.f('ix_chat_timestamp'), ['timestamp'], unique=False)
op.create_table('followers',
sa.Column('follower_id', sa.Integer(), nullable=True),
sa.Column('followed_id', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(['followed_id'], ['user.id'], ),
sa.ForeignKeyConstraint(['follower_id'], ['user.id'], )
)
op.create_table('message',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('sender_id', sa.Integer(), nullable=True),
sa.Column('recipient_id', sa.Integer(), nullable=True),
sa.Column('body', sa.String(length=140), nullable=True),
sa.Column('timestamp', sa.DateTime(), nullable=True),
sa.ForeignKeyConstraint(['recipient_id'], ['user.id'], ),
sa.ForeignKeyConstraint(['sender_id'], ['user.id'], ),
sa.PrimaryKeyConstraint('id')
)
with op.batch_alter_table('message', schema=None) as batch_op:
batch_op.create_index(batch_op.f('ix_message_timestamp'), ['timestamp'], unique=False)
op.create_table('notification',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('name', sa.String(length=128), nullable=True),
sa.Column('user_id', sa.Integer(), nullable=True),
sa.Column('timestamp', sa.Float(), nullable=True),
sa.Column('payload_json', sa.Text(), nullable=True),
sa.ForeignKeyConstraint(['user_id'], ['user.id'], ),
sa.PrimaryKeyConstraint('id')
)
with op.batch_alter_table('notification', schema=None) as batch_op:
batch_op.create_index(batch_op.f('ix_notification_name'), ['name'], unique=False)
batch_op.create_index(batch_op.f('ix_notification_timestamp'), ['timestamp'], unique=False)
op.create_table('program',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('specialty_id', sa.Integer(), nullable=True),
sa.Column('name', sa.Text(), nullable=True),
sa.Column('body', sa.Text(), nullable=True),
sa.Column('city', sa.String(length=140), nullable=True),
sa.Column('state', sa.String(length=140), nullable=True),
sa.Column('accreditation_id', sa.String(length=140), nullable=True),
sa.Column('status', sa.String(length=140), nullable=True),
sa.Column('url', sa.String(length=140), nullable=True),
sa.Column('timestamp', sa.DateTime(), nullable=True),
sa.Column('user_id', sa.Integer(), nullable=True),
sa.Column('language', sa.String(length=5), nullable=True),
sa.Column('image', sa.String(length=140), nullable=True),
sa.ForeignKeyConstraint(['specialty_id'], ['specialty.id'], ),
sa.ForeignKeyConstraint(['user_id'], ['user.id'], ),
sa.PrimaryKeyConstraint('id')
)
with op.batch_alter_table('program', schema=None) as batch_op:
batch_op.create_index(batch_op.f('ix_program_timestamp'), ['timestamp'], unique=False)
op.create_table('test',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('testname', sa.String(length=140), nullable=True),
sa.Column('score', sa.String(length=140), nullable=True),
sa.Column('accuracy', sa.String(length=140), nullable=True),
sa.Column('reaction_time', sa.String(length=140), nullable=True),
sa.Column('timestamp', sa.DateTime(), nullable=True),
sa.Column('user_id', sa.Integer(), nullable=True),
sa.Column('language', sa.String(length=5), nullable=True),
sa.ForeignKeyConstraint(['user_id'], ['user.id'], ),
sa.PrimaryKeyConstraint('id')
)
with op.batch_alter_table('test', schema=None) as batch_op:
batch_op.create_index(batch_op.f('ix_test_timestamp'), ['timestamp'], unique=False)
op.create_table('thread',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('title', sa.Text(), nullable=True),
sa.Column('body', sa.Text(), nullable=True),
sa.Column('timestamp', sa.DateTime(), nullable=True),
sa.Column('user_id', sa.Integer(), nullable=True),
sa.Column('specialty_id', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(['specialty_id'], ['specialty.id'], ),
sa.ForeignKeyConstraint(['user_id'], ['user.id'], ),
sa.PrimaryKeyConstraint('id')
)
with op.batch_alter_table('thread', schema=None) as batch_op:
batch_op.create_index(batch_op.f('ix_thread_timestamp'), ['timestamp'], unique=False)
op.create_table('interview',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('user_id', sa.Integer(), nullable=True),
sa.Column('program_id', sa.Integer(), nullable=True),
sa.Column('date', sa.DateTime(), nullable=True),
sa.Column('supplemental_required', sa.Boolean(), nullable=True),
sa.Column('method', sa.String(length=128), nullable=True),
sa.Column('unavailable_dates', sa.String(length=256), nullable=True),
sa.ForeignKeyConstraint(['program_id'], ['program.id'], ),
sa.ForeignKeyConstraint(['user_id'], ['user.id'], ),
sa.PrimaryKeyConstraint('id')
)
with op.batch_alter_table('interview', schema=None) as batch_op:
batch_op.create_index(batch_op.f('ix_interview_date'), ['date'], unique=False)
batch_op.create_index(batch_op.f('ix_interview_method'), ['method'], unique=False)
batch_op.create_index(batch_op.f('ix_interview_unavailable_dates'), ['unavailable_dates'], unique=False)
op.create_table('interview__impression',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('body', sa.Text(), nullable=True),
sa.Column('timestamp', sa.DateTime(), nullable=True),
sa.Column('user_id', sa.Integer(), nullable=True),
sa.Column('program_id', sa.Integer(), nullable=True),
sa.Column('language', sa.String(length=5), nullable=True),
sa.Column('specialty_id', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(['program_id'], ['program.id'], ),
sa.ForeignKeyConstraint(['specialty_id'], ['specialty.id'], ),
sa.ForeignKeyConstraint(['user_id'], ['user.id'], ),
sa.PrimaryKeyConstraint('id')
)
with op.batch_alter_table('interview__impression', schema=None) as batch_op:
batch_op.create_index(batch_op.f('ix_interview__impression_timestamp'), ['timestamp'], unique=False)
op.create_table('link',
sa.Column('user', sa.Integer(), nullable=True),
sa.Column('program', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(['program'], ['program.id'], ),
sa.ForeignKeyConstraint(['user'], ['user.id'], )
)
op.create_table('post',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('body', sa.Text(), nullable=True),
sa.Column('timestamp', sa.DateTime(), nullable=True),
sa.Column('user_id', sa.Integer(), nullable=True),
sa.Column('language', sa.String(length=5), nullable=True),
sa.Column('specialty_id', sa.Integer(), nullable=True),
sa.Column('thread_id', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(['specialty_id'], ['specialty.id'], ),
sa.ForeignKeyConstraint(['thread_id'], ['thread.id'], ),
sa.ForeignKeyConstraint(['user_id'], ['user.id'], ),
sa.PrimaryKeyConstraint('id')
)
with op.batch_alter_table('post', schema=None) as batch_op:
batch_op.create_index(batch_op.f('ix_post_timestamp'), ['timestamp'], unique=False)
op.create_table('interview__date',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('user_id', sa.Integer(), nullable=True),
sa.Column('program_id', sa.Integer(), nullable=True),
sa.Column('interview_id', sa.Integer(), nullable=True),
sa.Column('date', sa.DateTime(), nullable=True),
sa.Column('full', sa.Boolean(), nullable=True),
sa.ForeignKeyConstraint(['interview_id'], ['interview.id'], ),
sa.ForeignKeyConstraint(['program_id'], ['program.id'], ),
sa.ForeignKeyConstraint(['user_id'], ['user.id'], ),
sa.PrimaryKeyConstraint('id')
)
with op.batch_alter_table('interview__date', schema=None) as batch_op:
batch_op.create_index(batch_op.f('ix_interview__date_date'), ['date'], unique=False)
batch_op.create_index(batch_op.f('ix_interview__date_full'), ['full'], unique=False)
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('environment',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('width', sa.Integer(), nullable=True),
sa.Column('height', sa.Integer(), nullable=True),
sa.PrimaryKeyConstraint('id')
)
op.create_table('message',
sa.Column('created', sa.DateTime(), nullable=True),
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('content', sa.String(length=256), nullable=True),
sa.Column('color', sa.String(length=24), nullable=True),
sa.Column('mods', sa.String(length=256), nullable=True),
sa.PrimaryKeyConstraint('id')
)
op.create_table('object_effect',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('health', sa.Integer(), nullable=True),
sa.Column('weight', sa.Integer(), nullable=True),
sa.PrimaryKeyConstraint('id')
)
op.create_table('thread',
sa.Column('created', sa.DateTime(), nullable=True),
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('thread_hash', sa.String(length=64), nullable=True),
sa.Column('name', sa.String(length=100), nullable=True),
sa.PrimaryKeyConstraint('id')
)
op.create_table('user',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('username', sa.String(length=16), nullable=True),
sa.Column('password_hash', sa.String(length=100), nullable=True),
sa.Column('password_salt', sa.String(length=10), nullable=True),
sa.Column('created', sa.DateTime(), nullable=False),
sa.PrimaryKeyConstraint('id')
)
op.create_table('email',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('email', sa.String(length=75), nullable=True),
sa.Column('verified', sa.Boolean(), nullable=True),
sa.Column('user_id', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(['user_id'], ['user.id'], ),
sa.PrimaryKeyConstraint('id')
)
op.create_table('game_object',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('width', sa.Integer(), nullable=True),
sa.Column('height', sa.Integer(), nullable=True),
sa.Column('posx', sa.Integer(), nullable=True),
sa.Column('posy', sa.Integer(), nullable=True),
sa.Column('acquirable', sa.Boolean(), nullable=True),
sa.Column('collidable', sa.Boolean(), nullable=True),
sa.Column('environment_id', sa.Integer(), nullable=True),
sa.Column('owner_id', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(['environment_id'], ['environment.id'], ),
sa.ForeignKeyConstraint(['owner_id'], ['user.id'], ),
sa.PrimaryKeyConstraint('id')
)
op.create_table('inventory_object',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('name', sa.String(length=64), nullable=True),
sa.Column('use_effect', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(['use_effect'], ['object_effect.id'], ),
sa.PrimaryKeyConstraint('id')
)
op.create_table('user_status',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('user_id', sa.Integer(), nullable=True),
sa.Column('health', sa.Integer(), nullable=True),
sa.Column('weight', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(['user_id'], ['user.id'], ),
sa.PrimaryKeyConstraint('id')
)
op.create_table('user_thread',
sa.Column('user_id', sa.Integer(), nullable=True),
sa.Column('thread_id', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(['thread_id'], ['thread.id'], ),
sa.ForeignKeyConstraint(['user_id'], ['user.id'], )
)
op.create_table('game_inventory',
sa.Column('game_object_id', sa.Integer(), nullable=True),
sa.Column('inventory_object_id', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(['game_object_id'], ['game_object.id'], ),
sa.ForeignKeyConstraint(['inventory_object_id'], ['inventory_object.id'], )
)
op.create_table('user_inventory',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('quantity', sa.Integer(), nullable=True),
sa.Column('user_id', sa.Integer(), nullable=True),
sa.Column('inventory_object_id', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(['inventory_object_id'], ['inventory_object.id'], ),
sa.ForeignKeyConstraint(['user_id'], ['user.id'], ),
sa.PrimaryKeyConstraint('id')
)
