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') )