def upgrade(): ### commands auto generated by Alembic - please adjust! ### op.add_column(u'UserUsedExperiment', sa.Column('start_date_date', sa.Date(), nullable=True)) op.add_column(u'UserUsedExperiment', sa.Column('start_date_weekday', sa.Integer(), nullable=True)) op.add_column(u'UserUsedExperiment', sa.Column('start_date_hour', sa.Integer(), nullable=True)) op.add_column( u'UserUsedExperiment', sa.Column('session_time_micro', sa.BigInteger(), nullable=True)) op.add_column( u'UserUsedExperiment', sa.Column('session_time_seconds', sa.Integer(), nullable=True)) ### end Alembic commands ### op.create_index(u'idx_UserUsedExperiment_start_date_date', u'UserUsedExperiment', [ 'start_date_date', ]) op.create_index(u'idx_UserUsedExperiment_start_date_weekday', u'UserUsedExperiment', [ 'start_date_weekday', ]) op.create_index(u'idx_UserUsedExperiment_session_time_micro', u'UserUsedExperiment', [ 'session_time_micro', ]) op.create_index(u'idx_UserUsedExperiment_start_date_hour', u'UserUsedExperiment', [ 'start_date_hour', ]) op.create_index(u'idx_UserUsedExperiment_timetable', u'UserUsedExperiment', ['start_date_weekday', 'start_date_hour']) op.create_index(u'idx_UserUsedExperiment_user_experiment', u'UserUsedExperiment', ['user_id', 'experiment_id']) op.create_index(u'idx_UserUsedExperiment_user_origin', u'UserUsedExperiment', ['user_id', 'origin']) op.create_index('idx_UserUsedExperiment_user_group_permission_id', u'UserUsedExperiment', ['user_id', 'group_permission_id']) op.create_index('idx_UserUsedExperiment_user_user_permission_id', u'UserUsedExperiment', ['user_id', 'user_permission_id']) op.create_index('idx_UserUsedExperiment_user_role_permission_id', u'UserUsedExperiment', ['user_id', 'role_permission_id']) op.create_index(u'idx_UserUsedExperiment_experiment_id_group_id', u'UserUsedExperiment', ['experiment_id', 'group_permission_id']) op.create_index(u'idx_UserUsedExperiment_experiment_id_user_id', u'UserUsedExperiment', ['experiment_id', 'user_permission_id']) op.create_index(u'idx_UserUsedExperiment_experiment_id_permission_id', u'UserUsedExperiment', ['experiment_id', 'role_permission_id']) s = sql.select([ uue.c.id, uue.c.start_date, uue.c.start_date_micro, uue.c.end_date, uue.c.end_date_micro ]).order_by(uue.c.id) for use in op.get_bind().execute(s): use_id = use[uue.c.id] start_date = use[uue.c.start_date].replace( microsecond=use[uue.c.start_date_micro]) end_date_col = use[uue.c.end_date] kwargs = dict( start_date_date=start_date.date(), start_date_hour=start_date.hour, start_date_weekday=start_date.weekday(), ) if end_date_col: end_date = end_date_col.replace( microsecond=use[uue.c.end_date_micro]) session_time_micro = (end_date - start_date).seconds * 1e6 + ( end_date - start_date).microseconds session_time_seconds = session_time_micro / 1000000 kwargs.update( dict(session_time_micro=session_time_micro, session_time_seconds=session_time_seconds)) update_stmt = uue.update().where(uue.c.id == use_id).values(**kwargs) op.execute(update_stmt)
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.add_column('admins', sa.Column('permissions', sa.BigInteger(), nullable=False))
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.create_table( 'customer', sa.Column('id', sa.String(length=64), nullable=False), sa.Column('stripe_customer_id', sa.String(length=255), nullable=True), sa.PrimaryKeyConstraint('id')) op.create_table('package', sa.Column('id', sa.BigInteger(), nullable=False), sa.Column('owner', sa.String(length=64), nullable=False), sa.Column('name', sa.String(length=64), nullable=False), sa.PrimaryKeyConstraint('id')) op.create_index('idx_owner_name', 'package', ['owner', 'name'], unique=True) op.create_table('s3_blob', sa.Column('id', sa.BigInteger(), nullable=False), sa.Column('owner', sa.String(length=64), nullable=False), sa.Column('hash', sa.String(length=64), nullable=False), sa.PrimaryKeyConstraint('id')) op.create_index('idx', 's3_blob', ['owner', 'hash'], unique=True) op.create_table('access', sa.Column('package_id', sa.BigInteger(), nullable=False), sa.Column('user', sa.String(length=64), nullable=False), sa.ForeignKeyConstraint( ['package_id'], ['package.id'], ), sa.PrimaryKeyConstraint('package_id', 'user')) op.create_table( 'instance', sa.Column('id', sa.BigInteger(), nullable=False), sa.Column('package_id', sa.BigInteger(), nullable=False), sa.Column('hash', sa.String(length=64), nullable=False), sa.Column('created_at', sa.DateTime(), server_default=sa.text('now()'), nullable=False), sa.Column('created_by', sa.String(length=64), nullable=False), sa.Column('updated_at', sa.DateTime(), server_default=sa.text('now()'), nullable=False), sa.Column('updated_by', sa.String(length=64), nullable=False), sa.Column('contents', postgresql.JSONB(astext_type=sa.Text()), nullable=False), sa.ForeignKeyConstraint( ['package_id'], ['package.id'], ), sa.PrimaryKeyConstraint('id')) op.create_index('idx_hash', 'instance', ['package_id', 'hash'], unique=True) op.create_table( 'invitation', sa.Column('id', sa.BigInteger(), nullable=False), sa.Column('package_id', sa.BigInteger(), nullable=True), sa.Column('email', sa.String(length=254), nullable=False), sa.Column('invited_at', sa.DateTime(), server_default=sa.text('now()'), nullable=False), sa.ForeignKeyConstraint( ['package_id'], ['package.id'], ), sa.PrimaryKeyConstraint('id')) op.create_table( 'instance_blob', sa.Column('instance_id', sa.BigInteger(), nullable=True), sa.Column('blob_id', sa.BigInteger(), nullable=True), sa.ForeignKeyConstraint( ['blob_id'], ['s3_blob.id'], ), sa.ForeignKeyConstraint( ['instance_id'], ['instance.id'], )) op.create_table( 'log', sa.Column('id', sa.BigInteger(), nullable=False), sa.Column('package_id', sa.BigInteger(), nullable=False), sa.Column('instance_id', sa.BigInteger(), nullable=True), sa.Column('created', sa.DateTime(), server_default=sa.text('now()'), nullable=False), sa.Column('author', sa.String(length=64), nullable=False), sa.ForeignKeyConstraint( ['instance_id'], ['instance.id'], ), sa.ForeignKeyConstraint( ['package_id'], ['package.id'], ), sa.PrimaryKeyConstraint('id')) op.create_index(op.f('ix_log_package_id'), 'log', ['package_id'], unique=False) op.create_table( 'tag', sa.Column('package_id', sa.BigInteger(), nullable=False), sa.Column('tag', sa.String(length=64), nullable=False), sa.Column('instance_id', sa.BigInteger(), nullable=True), sa.ForeignKeyConstraint( ['instance_id'], ['instance.id'], ), sa.ForeignKeyConstraint( ['package_id'], ['package.id'], ), sa.PrimaryKeyConstraint('package_id', 'tag')) op.create_table( 'version', sa.Column('package_id', sa.BigInteger(), nullable=False), sa.Column('version', sa.String(length=64), nullable=False), sa.Column('instance_id', sa.BigInteger(), nullable=True), sa.Column('user_version', sa.String(length=64), nullable=False), sa.ForeignKeyConstraint( ['instance_id'], ['instance.id'], ), sa.ForeignKeyConstraint( ['package_id'], ['package.id'], ), sa.PrimaryKeyConstraint('package_id', 'version'))
def upgrade(): op.add_column('document', sa.Column('parent_id', sa.BigInteger(), nullable=True)) op.drop_column('document', 'error_details') op.create_index(op.f('ix_entity_state'), 'entity', ['state'], unique=False) op.drop_index('role_reset_token', table_name='role')
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.add_column('transactions', sa.Column('post_transaction_balance', sa.BigInteger(), nullable=False))
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.create_table('dmarc_policies', sa.Column('id', sa.BigInteger(), nullable=False), sa.Column('policy_string', sa.String(), nullable=False), sa.Column('display_name', sa.String(), nullable=False), sa.Column('color', sa.String(), nullable=False), sa.PrimaryKeyConstraint('id') ) op.create_table('email_providers', sa.Column('id', sa.BigInteger(), nullable=False), sa.Column('display_name', sa.String(), nullable=False), sa.Column('search_regex', sa.String(), nullable=False), sa.Column('is_regex', sa.Boolean(), nullable=False), sa.PrimaryKeyConstraint('id') ) op.create_table('runs', sa.Column('id', sa.BigInteger(), nullable=False), sa.Column('start_time', sa.DateTime(), nullable=False), sa.Column('start_rank', sa.BigInteger(), nullable=False), sa.Column('end_rank', sa.BigInteger(), nullable=False), sa.PrimaryKeyConstraint('id') ) op.create_table('sites', sa.Column('id', sa.BigInteger(), nullable=False), sa.Column('domain', sa.String(), nullable=False), sa.Column('current_rank', sa.BigInteger(), nullable=False), sa.PrimaryKeyConstraint('id') ) op.create_table('spf_policies', sa.Column('id', sa.BigInteger(), nullable=False), sa.Column('qualifier', sa.String(), nullable=False), sa.Column('display_name', sa.String(), nullable=False), sa.Column('color', sa.String(), nullable=False), sa.PrimaryKeyConstraint('id') ) op.create_table('site_runs', sa.Column('id', sa.BigInteger(), nullable=False), sa.Column('site_id', sa.BigInteger(), nullable=False), sa.Column('run_id', sa.BigInteger(), nullable=False), sa.Column('run_rank', sa.BigInteger(), nullable=False), sa.Column('caa_record', sa.Text(), nullable=True), sa.Column('has_caa', sa.Boolean(), nullable=False), sa.Column('has_caa_reporting', sa.Boolean(), nullable=False), sa.Column('caa_issue_count', sa.BigInteger(), nullable=True), sa.Column('caa_wildcard_count', sa.BigInteger(), nullable=True), sa.Column('has_dmarc', sa.Boolean(), nullable=False), sa.Column('has_dmarc_aggregate_reporting', sa.Boolean(), nullable=False), sa.Column('has_dmarc_forensic_reporting', sa.Boolean(), nullable=False), sa.Column('dmarc_policy_id', sa.BigInteger(), nullable=True), sa.Column('dmarc_sub_policy_id', sa.BigInteger(), nullable=True), sa.Column('dmarc_record', sa.Text(), nullable=True), sa.Column('has_spf', sa.Boolean(), nullable=False), sa.Column('spf_policy_id', sa.BigInteger(), nullable=False), sa.Column('txt_records', sa.Text(), nullable=True), sa.Column('ds_records', sa.Text(), nullable=True), sa.Column('mx_records', sa.Text(), nullable=True), sa.Column('ns_records', sa.Text(), nullable=True), sa.Column('email_provider_id', sa.BigInteger(), nullable=True), sa.ForeignKeyConstraint(['dmarc_policy_id'], ['dmarc_policies.id'], ), sa.ForeignKeyConstraint(['dmarc_sub_policy_id'], ['dmarc_policies.id'], ), sa.ForeignKeyConstraint(['email_provider_id'], ['email_providers.id'], ), sa.ForeignKeyConstraint(['run_id'], ['runs.id'], ), sa.ForeignKeyConstraint(['site_id'], ['sites.id'], ), sa.ForeignKeyConstraint(['spf_policy_id'], ['spf_policies.id'], ), sa.PrimaryKeyConstraint('id') )
LOST = 1 RESTARTING = 2 TERMINATED = 3 agents = sa.Table( 'agents', metadata, sa.Column('id', sa.String(length=64), primary_key=True), sa.Column('status', EnumType(AgentStatus), nullable=False, index=True, default=AgentStatus.ALIVE), sa.Column('region', sa.String(length=64), index=True, nullable=False), sa.Column('mem_slots', sa.BigInteger(), nullable=False), # MiBytes sa.Column('cpu_slots', sa.Float(), nullable=False), # number of CPU cores sa.Column('gpu_slots', sa.Float(), nullable=False), # number of GPU devices sa.Column('used_mem_slots', sa.BigInteger(), nullable=False), sa.Column('used_cpu_slots', sa.Float(), nullable=False), sa.Column('used_gpu_slots', sa.Float(), nullable=False), sa.Column('addr', sa.String(length=128), nullable=False), sa.Column('first_contact', sa.DateTime(timezone=True), server_default=sa.func.now()), sa.Column('lost_at', sa.DateTime(timezone=True), nullable=True), ) class Agent(graphene.ObjectType):
def upgrade(): app = create_app() engine = sa.create_engine(app.config.get('SQLALCHEMY_DATABASE_URI')) # ### commands auto generated by Alembic - please adjust! ### if not engine.dialect.has_table(engine, 'challenges'): op.create_table( 'challenges', sa.Column('id', sa.Integer(), nullable=False), sa.Column('name', sa.String(length=80), nullable=True), sa.Column('description', sa.Text(), nullable=True), sa.Column('value', sa.Integer(), nullable=True), sa.Column('category', sa.String(length=80), nullable=True), sa.Column('flags', sa.Text(), nullable=True), sa.Column('hidden', sa.Boolean(), nullable=True), sa.PrimaryKeyConstraint('id')) if not engine.dialect.has_table(engine, 'config'): op.create_table('config', sa.Column('id', sa.Integer(), nullable=False), sa.Column('key', sa.Text(), nullable=True), sa.Column('value', sa.Text(), nullable=True), sa.PrimaryKeyConstraint('id')) if not engine.dialect.has_table(engine, 'containers'): op.create_table('containers', sa.Column('id', sa.Integer(), nullable=False), sa.Column('name', sa.String(length=80), nullable=True), sa.Column('buildfile', sa.Text(), nullable=True), sa.PrimaryKeyConstraint('id')) if not engine.dialect.has_table(engine, 'pages'): op.create_table( 'pages', sa.Column('id', sa.Integer(), nullable=False), sa.Column('route', sa.String(length=80), nullable=True), sa.Column('html', sa.Text(), nullable=True), sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('route')) if not engine.dialect.has_table(engine, 'teams'): op.create_table( 'teams', sa.Column('id', sa.Integer(), nullable=False), sa.Column('name', sa.String(length=128), nullable=True), sa.Column('email', sa.String(length=128), nullable=True), sa.Column('password', sa.String(length=128), nullable=True), sa.Column('website', sa.String(length=128), nullable=True), sa.Column('affiliation', sa.String(length=128), nullable=True), sa.Column('country', sa.String(length=32), nullable=True), sa.Column('bracket', sa.String(length=32), nullable=True), sa.Column('banned', sa.Boolean(), nullable=True), sa.Column('verified', sa.Boolean(), nullable=True), sa.Column('admin', sa.Boolean(), nullable=True), sa.Column('joined', sa.DateTime(), nullable=True), sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('email'), sa.UniqueConstraint('name')) if not engine.dialect.has_table(engine, 'awards'): op.create_table( 'awards', sa.Column('id', sa.Integer(), nullable=False), sa.Column('teamid', sa.Integer(), nullable=True), sa.Column('name', sa.String(length=80), nullable=True), sa.Column('description', sa.Text(), nullable=True), sa.Column('date', sa.DateTime(), nullable=True), sa.Column('value', sa.Integer(), nullable=True), sa.Column('category', sa.String(length=80), nullable=True), sa.Column('icon', sa.Text(), nullable=True), sa.ForeignKeyConstraint( ['teamid'], ['teams.id'], ), sa.PrimaryKeyConstraint('id')) if not engine.dialect.has_table(engine, 'files'): op.create_table('files', sa.Column('id', sa.Integer(), nullable=False), sa.Column('chal', sa.Integer(), nullable=True), sa.Column('location', sa.Text(), nullable=True), sa.ForeignKeyConstraint( ['chal'], ['challenges.id'], ), sa.PrimaryKeyConstraint('id')) if not engine.dialect.has_table(engine, 'keys'): op.create_table('keys', sa.Column('id', sa.Integer(), nullable=False), sa.Column('chal', sa.Integer(), nullable=True), sa.Column('key_type', sa.Integer(), nullable=True), sa.Column('flag', sa.Text(), nullable=True), sa.ForeignKeyConstraint( ['chal'], ['challenges.id'], ), sa.PrimaryKeyConstraint('id')) if not engine.dialect.has_table(engine, 'solves'): op.create_table( 'solves', sa.Column('id', sa.Integer(), nullable=False), sa.Column('chalid', sa.Integer(), nullable=True), sa.Column('teamid', sa.Integer(), nullable=True), sa.Column('ip', sa.Integer(), nullable=True), sa.Column('flag', sa.Text(), nullable=True), sa.Column('date', sa.DateTime(), nullable=True), sa.ForeignKeyConstraint( ['chalid'], ['challenges.id'], ), sa.ForeignKeyConstraint( ['teamid'], ['teams.id'], ), sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('chalid', 'teamid')) if not engine.dialect.has_table(engine, 'tags'): op.create_table('tags', sa.Column('id', sa.Integer(), nullable=False), sa.Column('chal', sa.Integer(), nullable=True), sa.Column('tag', sa.String(length=80), nullable=True), sa.ForeignKeyConstraint( ['chal'], ['challenges.id'], ), sa.PrimaryKeyConstraint('id')) if not engine.dialect.has_table(engine, 'tracking'): op.create_table('tracking', sa.Column('id', sa.Integer(), nullable=False), sa.Column('ip', sa.BigInteger(), nullable=True), sa.Column('team', sa.Integer(), nullable=True), sa.Column('date', sa.DateTime(), nullable=True), sa.ForeignKeyConstraint( ['team'], ['teams.id'], ), sa.PrimaryKeyConstraint('id')) if not engine.dialect.has_table(engine, 'wrong_keys'): op.create_table( 'wrong_keys', sa.Column('id', sa.Integer(), nullable=False), sa.Column('chalid', sa.Integer(), nullable=True), sa.Column('teamid', sa.Integer(), nullable=True), sa.Column('date', sa.DateTime(), nullable=True), sa.Column('flag', sa.Text(), nullable=True), sa.ForeignKeyConstraint( ['chalid'], ['challenges.id'], ), sa.ForeignKeyConstraint( ['teamid'], ['teams.id'], ), sa.PrimaryKeyConstraint('id'))
class AttributeMixin(object): """Mixin class for translating between resource and model.""" epoch = sa.Column(sa.BigInteger().with_variant(sa.Integer(), 'sqlite'), server_default='0', nullable=False) __mapper_args__ = { "version_id_col": epoch, "version_id_generator": False, "confirm_deleted_rows": False, } def bump_epoch(self): if self.epoch is None: # this is a brand new object uncommitted so we don't bump now self.epoch = 0 self.epoch += 1 def from_attr(self, session, resource_attr): """Populate model from resource attribute dictionary. Child classes should override this method to specify a custom mapping of resource attributes to model properties. """ for k, v in resource_attr.iteritems(): if k not in getattr(self, '_exclude_from', []): self.set_attr(session, k, v, **resource_attr) def to_attr(self, session): """Get resource attribute dictionary for a model object. Child classes should override this method to specify a custom mapping of model properties to resource attributes. """ return { k: self.get_attr(session, k) for k in dir(self) if (not k.startswith('_') and k not in getattr( self, '_exclude_to', []) and not callable(getattr(self, k))) } def set_attr(self, session, k, v, **kwargs): """Utility for setting DB attributes :param session: current DB session :param k: name of the attribute that needs to be set :param v: value of the attribute that needs to be set :param kwargs: all the other attributes for this object. Often useful for retrieving the object identifiers. :return: """ if getattr(self, 'set_' + k, None): # setter method exists getattr(self, 'set_' + k)(session, v, **kwargs) else: setattr(self, k, v) def get_attr(self, session, k): if getattr(self, 'get_' + k, None): # getter method exists return getattr(self, 'get_' + k)(session) else: return getattr(self, k)
def upgrade(): ### commands auto generated by Alembic - please adjust! ### op.create_table('role', sa.Column('id', sa.Integer(), nullable=False), sa.Column('name', sa.String(length=80), nullable=False), sa.Column('description', sa.Text(), nullable=True), sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('name')) op.create_table('ship', sa.Column('id', sa.Integer(), nullable=False), sa.Column('afterlv', sa.Integer(), nullable=True), sa.Column('aftershipid', sa.Integer(), nullable=True), sa.Column('remodel_cost', sa.String(), nullable=True), sa.Column('rarity', sa.Integer(), nullable=True), sa.Column('broken', sa.String(), nullable=True), sa.Column('ammo_max', sa.Integer(), nullable=True), sa.Column('fuel_max', sa.Integer(), nullable=True), sa.Column('name', sa.String(), nullable=True), sa.Column('number', sa.Integer(), nullable=True), sa.Column('stype', sa.Integer(), nullable=True), sa.Column('voicef', sa.Integer(), nullable=True), sa.Column('modern_use', sa.String(), nullable=True), sa.Column('luck_base', sa.Integer(), nullable=True), sa.Column('firepower_base', sa.Integer(), nullable=True), sa.Column('torpedo_base', sa.Integer(), nullable=True), sa.Column('armour_base', sa.Integer(), nullable=True), sa.Column('antiair_base', sa.Integer(), nullable=True), sa.Column('antisub_base', sa.Integer(), nullable=True), sa.Column('los_base', sa.Integer(), nullable=True), sa.Column('evasion_base', sa.Integer(), nullable=True), sa.Column('luck_max', sa.Integer(), nullable=True), sa.Column('firepower_max', sa.Integer(), nullable=True), sa.Column('torpedo_max', sa.Integer(), nullable=True), sa.Column('armour_max', sa.Integer(), nullable=True), sa.Column('antiair_max', sa.Integer(), nullable=True), sa.Column('antisub_max', sa.Integer(), nullable=True), sa.Column('maxslots', sa.Integer(), nullable=True), sa.Column('maxlos', sa.Integer(), nullable=True), sa.Column('evasion_max', sa.Integer(), nullable=True), sa.Column('maxhp', sa.Integer(), nullable=True), sa.Column('srange', sa.Integer(), nullable=True), sa.Column('getmsg', sa.String(length=255), nullable=True), sa.Column('buildtime', sa.Integer(), nullable=True), sa.Column('maxplanes', sa.String(), nullable=True), sa.PrimaryKeyConstraint('id')) op.create_table( 'user', sa.Column('id', sa.Integer(), nullable=False), sa.Column('active', sa.Boolean(), nullable=True), sa.Column('email', sa.String(length=255), nullable=False), sa.Column('password', sa.String(length=255), nullable=False), sa.Column('confirmed_at', sa.DateTime(), nullable=True), sa.Column('nickname', sa.String(length=255), nullable=False), sa.Column('api_token', sa.String(length=40), nullable=True), sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('api_token'), sa.UniqueConstraint('email'), sa.UniqueConstraint('nickname')) op.create_table( 'admiral', sa.Column('id', sa.Integer(), nullable=False), sa.Column('user_id', sa.Integer(), nullable=True), sa.Column('last_login', sa.DateTime(), nullable=True), sa.Column('level', sa.Integer(), nullable=True), sa.Column('rank', sa.Integer(), nullable=True), sa.Column('experience', sa.Integer(), nullable=True), sa.Column('tutorial_progress', sa.Integer(), nullable=True), sa.Column('furniture', sa.String(), nullable=True), sa.Column('furniture_coins', sa.Integer(), nullable=True), sa.Column('max_ships', sa.Integer(), nullable=True), sa.Column('max_equips', sa.Integer(), nullable=True), sa.Column('max_furniture', sa.Integer(), nullable=True), sa.Column('available_fleets', sa.Integer(), nullable=True), sa.Column('available_cdocks', sa.Integer(), nullable=True), sa.Column('available_rdocks', sa.Integer(), nullable=True), sa.Column('sortie_successes', sa.Integer(), nullable=True), sa.Column('sortie_total', sa.Integer(), nullable=True), sa.Column('expedition_successes', sa.Integer(), nullable=True), sa.Column('expedition_total', sa.Integer(), nullable=True), sa.Column('pvp_successes', sa.Integer(), nullable=True), sa.Column('pvp_total', sa.Integer(), nullable=True), sa.Column('resources', sa.String(), nullable=True), sa.Column('setup', sa.Boolean(), nullable=True), sa.ForeignKeyConstraint( ['user_id'], ['user.id'], ), sa.PrimaryKeyConstraint('id')) op.create_table('role__user', sa.Column('user_id', sa.Integer(), nullable=True), sa.Column('role_id', sa.Integer(), nullable=True), sa.ForeignKeyConstraint( ['role_id'], ['role.id'], ), sa.ForeignKeyConstraint( ['user_id'], ['user.id'], )) op.create_table( 'dock', sa.Column('id', sa.Integer(), nullable=False), sa.Column('state', sa.Integer(), nullable=True), sa.Column('ship', sa.Integer(), nullable=True), sa.Column('complete', sa.BigInteger(), nullable=True), sa.Column('fuel', sa.Integer(), nullable=True), sa.Column('ammo', sa.Integer(), nullable=True), sa.Column('steel', sa.Integer(), nullable=True), sa.Column('baux', sa.Integer(), nullable=True), sa.Column('cmats', sa.Integer(), nullable=True), sa.Column('ship_id', sa.Integer(), nullable=True), sa.Column('admiral_idea', sa.Integer(), nullable=True), sa.ForeignKeyConstraint( ['admiral_idea'], ['admiral.id'], ), sa.PrimaryKeyConstraint('id')) op.create_table('fleet', sa.Column('id', sa.Integer(), nullable=False), sa.Column('name', sa.String(), nullable=True), sa.Column('admiral_id', sa.Integer(), nullable=True), sa.ForeignKeyConstraint( ['admiral_id'], ['admiral.id'], ), sa.PrimaryKeyConstraint('id')) op.create_table('admiral_ship', sa.Column('id', sa.Integer(), nullable=False), sa.Column('admiralid', sa.Integer(), nullable=True), sa.Column('ship_id', sa.Integer(), nullable=True), sa.Column('fleet_id', sa.Integer(), nullable=True), sa.Column('ammo', sa.Integer(), nullable=True), sa.Column('fuel', sa.Integer(), nullable=True), sa.Column('fatigue', sa.Integer(), nullable=True), sa.Column('exp', sa.Integer(), nullable=True), sa.Column('level', sa.Integer(), nullable=True), sa.Column('repair_base', sa.String(), nullable=True), sa.Column('current_hp', sa.Integer(), nullable=True), sa.Column('luck', sa.Integer(), nullable=True), sa.Column('luck_eq', sa.Integer(), nullable=True), sa.Column('firepower', sa.Integer(), nullable=True), sa.Column('firepower_eq', sa.Integer(), nullable=True), sa.Column('armour', sa.Integer(), nullable=True), sa.Column('torpedo', sa.Integer(), nullable=True), sa.Column('torpedo_eq', sa.Integer(), nullable=True), sa.Column('antiair', sa.Integer(), nullable=True), sa.Column('antiair_eq', sa.Integer(), nullable=True), sa.Column('antisub', sa.Integer(), nullable=True), sa.Column('evasion', sa.Integer(), nullable=True), sa.Column('heartlocked', sa.Boolean(), nullable=True), sa.ForeignKeyConstraint( ['admiralid'], ['admiral.id'], ), sa.ForeignKeyConstraint( ['fleet_id'], ['fleet.id'], ), sa.ForeignKeyConstraint( ['ship_id'], ['ship.id'], ), sa.PrimaryKeyConstraint('id'))
def downgrade(): op.alter_column('user', 'quota', existing_type=sa.BigInteger(), server_default='0')
def upgrade(): ### commands auto generated by Alembic - please adjust! ### op.create_table( 'users', sa.Column('created_at', sa.DateTime(), nullable=False), sa.Column('updated_at', sa.DateTime(), nullable=False), sa.Column('id', sa.BigInteger(), nullable=False), sa.Column('password_hash', sa.Text(), nullable=True), sa.Column('email', sa.Text(), nullable=True), sa.Column('first_name', sa.Text(), nullable=True), sa.Column('last_name', sa.Text(), nullable=True), sa.Column('enabled', sa.Boolean(), nullable=True), sa.Column('roles', postgresql.ARRAY(sa.Text()), nullable=True), sa.Column('reset_token', sa.Text(), nullable=True), sa.Column('properties', postgresql.JSON(), nullable=True), sa.PrimaryKeyConstraint('id')) op.execute(CreateSequence(Sequence('user_id_seq'))) op.create_table('topic_judgments', sa.Column('created_at', sa.DateTime(), nullable=False), sa.Column('updated_at', sa.DateTime(), nullable=False), sa.Column('id', sa.BigInteger(), nullable=False), sa.Column('doc_id', sa.BigInteger(), nullable=True), sa.Column('user_id', sa.BigInteger(), nullable=True), sa.Column('status', sa.Text(), nullable=True), sa.Column('topic_table', sa.Text(), nullable=True), sa.Column('topic_id', sa.BigInteger(), nullable=True), sa.Column('topic_name', sa.Text(), nullable=True), sa.Column('judgment', sa.Boolean(), nullable=True), sa.ForeignKeyConstraint( ['user_id'], ['users.id'], ), sa.PrimaryKeyConstraint('id')) op.execute(CreateSequence(Sequence('topic_judgment_id_seq'))) op.create_table('user_agencies', sa.Column('created_at', sa.DateTime(), nullable=False), sa.Column('updated_at', sa.DateTime(), nullable=False), sa.Column('id', sa.BigInteger(), nullable=False), sa.Column('agency_id', sa.BigInteger(), nullable=True), sa.Column('user_id', sa.BigInteger(), nullable=True), sa.Column('following', sa.Boolean(), nullable=True), sa.ForeignKeyConstraint( ['user_id'], ['users.id'], ), sa.PrimaryKeyConstraint('id')) op.execute(CreateSequence(Sequence('user_agency_id_seq'))) op.create_index('user_id_following_index', 'user_agencies', ['user_id', 'following'], unique=False) op.create_table('user_documents', sa.Column('created_at', sa.DateTime(), nullable=False), sa.Column('updated_at', sa.DateTime(), nullable=False), sa.Column('id', sa.BigInteger(), nullable=False), sa.Column('doc_id', sa.BigInteger(), nullable=True), sa.Column('user_id', sa.BigInteger(), nullable=True), sa.Column('read', sa.Boolean(), nullable=True), sa.ForeignKeyConstraint( ['user_id'], ['users.id'], ), sa.PrimaryKeyConstraint('id')) op.execute(CreateSequence(Sequence('user_document_id_seq'))) op.create_index('user_id_doc_id_index', 'user_documents', ['user_id', 'doc_id'], unique=False) op.create_index('user_id_read_index', 'user_documents', ['user_id', 'read'], unique=False)
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.create_table('company', sa.Column('created_at', sa.DateTime(), nullable=True), sa.Column('updated_at', sa.DateTime(), nullable=True), sa.Column('email', sa.String(length=64), nullable=False), sa.Column('password', sa.String(length=128), nullable=False), sa.Column('is_enable', sa.Boolean(), nullable=True), sa.Column('id', sa.Integer(), nullable=False), sa.Column('name', sa.String(length=32), nullable=False), sa.Column('website', sa.String(length=256), nullable=True), sa.Column('address', sa.String(length=64), nullable=True), sa.Column('logo', sa.String(length=128), nullable=True), sa.Column('role', sa.SmallInteger(), nullable=True), sa.Column('finance_stage', sa.String(length=16), nullable=True), sa.Column('field', sa.String(length=16), nullable=True), sa.Column('description', sa.String(length=256), nullable=True), sa.Column('details', sa.Text(), nullable=True), sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('email'), sa.UniqueConstraint('name') ) op.create_index(op.f('ix_company_is_enable'), 'company', ['is_enable'], unique=False) op.create_table('user', sa.Column('created_at', sa.DateTime(), nullable=True), sa.Column('updated_at', sa.DateTime(), nullable=True), sa.Column('email', sa.String(length=64), nullable=False), sa.Column('password', sa.String(length=128), nullable=False), sa.Column('is_enable', sa.Boolean(), nullable=True), sa.Column('id', sa.BigInteger(), nullable=False), sa.Column('name', sa.String(length=8), nullable=False), sa.Column('resume', sa.String(length=128), nullable=True), sa.Column('role', sa.SmallInteger(), nullable=True), sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('email') ) op.create_index(op.f('ix_user_is_enable'), 'user', ['is_enable'], unique=False) op.create_table('job', sa.Column('created_at', sa.DateTime(), nullable=True), sa.Column('updated_at', sa.DateTime(), nullable=True), sa.Column('id', sa.Integer(), nullable=False), sa.Column('name', sa.String(length=64), nullable=False), sa.Column('salary_min', sa.SmallInteger(), nullable=False), sa.Column('salary_max', sa.SmallInteger(), nullable=False), sa.Column('company_id', sa.Integer(), nullable=True), sa.Column('description', sa.Text(), nullable=True), sa.Column('treatment', sa.Text(), nullable=True), sa.Column('exp', sa.String(length=16), nullable=True), sa.Column('education', sa.String(length=16), nullable=True), sa.Column('city', sa.String(length=8), nullable=True), sa.Column('tags', sa.String(length=64), nullable=True), sa.Column('is_enable', sa.Boolean(), nullable=True), sa.ForeignKeyConstraint(['company_id'], ['company.id'], ondelete='CASCADE'), sa.PrimaryKeyConstraint('id') ) op.create_index(op.f('ix_job_city'), 'job', ['city'], unique=False) op.create_index(op.f('ix_job_education'), 'job', ['education'], unique=False) op.create_index(op.f('ix_job_exp'), 'job', ['exp'], unique=False) op.create_index(op.f('ix_job_is_enable'), 'job', ['is_enable'], unique=False) op.create_index(op.f('ix_job_salary_max'), 'job', ['salary_max'], unique=False) op.create_index(op.f('ix_job_salary_min'), 'job', ['salary_min'], unique=False) op.create_table('delivery', sa.Column('created_at', sa.DateTime(), nullable=True), sa.Column('updated_at', sa.DateTime(), nullable=True), sa.Column('id', sa.Integer(), nullable=False), sa.Column('job_id', sa.Integer(), nullable=True), sa.Column('user_id', sa.BigInteger(), nullable=True), sa.Column('company_id', sa.Integer(), nullable=True), sa.Column('resume', sa.String(length=128), nullable=True), sa.Column('static', sa.SmallInteger(), nullable=True), sa.Column('company_response', sa.String(length=256), nullable=True), sa.ForeignKeyConstraint(['company_id'], ['company.id'], ondelete='SET NULL'), sa.ForeignKeyConstraint(['job_id'], ['job.id'], ondelete='SET NULL'), sa.ForeignKeyConstraint(['user_id'], ['user.id'], ondelete='SET NULL'), sa.PrimaryKeyConstraint('id') ) op.create_index(op.f('ix_delivery_status'), 'delivery', ['static'], unique=False)
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.create_table('players', sa.Column('pk', sa.Integer(), nullable=False), sa.Column('created_timestamp', sa.BigInteger(), nullable=True), sa.Column('updated_timestamp', sa.BigInteger(), nullable=True), sa.Column('player_id', sa.Integer(), nullable=False), sa.Column('first_name', sa.String(length=128), nullable=False), sa.Column('last_name', sa.String(length=128), nullable=False), sa.Column('date_of_birth', sa.Date(), nullable=True), sa.PrimaryKeyConstraint('pk'), sa.UniqueConstraint('player_id') ) op.create_table('teams', sa.Column('pk', sa.Integer(), nullable=False), sa.Column('created_timestamp', sa.BigInteger(), nullable=True), sa.Column('updated_timestamp', sa.BigInteger(), nullable=True), sa.Column('name', sa.String(length=128), nullable=False), sa.PrimaryKeyConstraint('pk'), sa.UniqueConstraint('name') ) op.create_table('drafts', sa.Column('pk', sa.Integer(), nullable=False), sa.Column('created_timestamp', sa.BigInteger(), nullable=True), sa.Column('updated_timestamp', sa.BigInteger(), nullable=True), sa.Column('player_pk', sa.Integer(), nullable=True), sa.Column('team_pk', sa.Integer(), nullable=True), sa.Column('season', sa.Integer(), nullable=True), sa.Column('type', sa.String(length=128), nullable=True), sa.Column('round', sa.Integer(), nullable=True), sa.Column('pick', sa.Integer(), nullable=True), sa.ForeignKeyConstraint(['player_pk'], ['players.pk'], ), sa.ForeignKeyConstraint(['team_pk'], ['teams.pk'], ), sa.PrimaryKeyConstraint('pk') ) op.create_table('games', sa.Column('pk', sa.Integer(), nullable=False), sa.Column('created_timestamp', sa.BigInteger(), nullable=True), sa.Column('updated_timestamp', sa.BigInteger(), nullable=True), sa.Column('week', sa.Integer(), nullable=False), sa.Column('home_team_pk', sa.Integer(), nullable=False), sa.Column('away_team_pk', sa.Integer(), nullable=False), sa.ForeignKeyConstraint(['away_team_pk'], ['teams.pk'], ), sa.ForeignKeyConstraint(['home_team_pk'], ['teams.pk'], ), sa.PrimaryKeyConstraint('pk') ) op.create_table('player_performances', sa.Column('pk', sa.Integer(), nullable=False), sa.Column('created_timestamp', sa.BigInteger(), nullable=True), sa.Column('updated_timestamp', sa.BigInteger(), nullable=True), sa.Column('player_pk', sa.Integer(), nullable=False), sa.Column('game_pk', sa.Integer(), nullable=False), sa.Column('is_home', sa.Boolean(), nullable=True), sa.Column('yards', sa.Integer(), nullable=True), sa.Column('completions', sa.Integer(), nullable=True), sa.Column('interceptions', sa.Integer(), nullable=True), sa.Column('touchdowns', sa.Integer(), nullable=True), sa.Column('attempts', sa.Integer(), nullable=True), sa.ForeignKeyConstraint(['game_pk'], ['games.pk'], ), sa.ForeignKeyConstraint(['player_pk'], ['players.pk'], ), sa.PrimaryKeyConstraint('pk') )
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.create_table('algorithm', sa.Column('ID', sa.Integer(), nullable=False), sa.Column('Name', sa.String(length=512), nullable=True), sa.Column('Descr', sa.String(length=512), nullable=True), sa.Column('Is_mapped', sa.Boolean(), nullable=True), sa.PrimaryKeyConstraint('ID') ) op.create_table('asset_type', sa.Column('ID', sa.Integer(), nullable=False), sa.Column('Name', sa.String(length=512), nullable=True), sa.PrimaryKeyConstraint('ID') ) op.create_table('issue_history_timestamp', sa.Column('ID', sa.Integer(), nullable=False), sa.Column('Timestamp', sa.DateTime(), nullable=True), sa.PrimaryKeyConstraint('ID') ) op.create_table('point_type', sa.Column('ID', sa.Integer(), nullable=False), sa.Column('Name', sa.String(length=512), nullable=True), sa.PrimaryKeyConstraint('ID') ) op.create_table('site', sa.Column('ID', sa.Integer(), nullable=False), sa.Column('Name', sa.String(length=512), nullable=True), sa.Column('DB_key', sa.String(length=512), nullable=True), sa.Column('DB_username', sa.String(length=512), nullable=True), sa.Column('DB_password', sa.String(length=512), nullable=True), sa.Column('DB_address', sa.String(length=512), nullable=True), sa.Column('DB_port', sa.String(length=512), nullable=True), sa.Column('DB_name', sa.String(length=512), nullable=True), sa.PrimaryKeyConstraint('ID') ) op.create_table('tbLogTimeValues', sa.Column('DateTimeStamp', sa.DateTime(), nullable=True), sa.Column('SeqNo', sa.BigInteger(), nullable=False), sa.Column('FloatVALUE', sa.Float(), nullable=True), sa.Column('ParentID', sa.Integer(), nullable=False), sa.Column('OdometerValue', sa.Float(), nullable=True), sa.PrimaryKeyConstraint('SeqNo', 'ParentID') ) op.create_table('tbLoggedEntities', sa.Column('ID', sa.Integer(), nullable=False), sa.Column('GUID', sa.String(length=50), nullable=True), sa.Column('Path', sa.String(length=1024), nullable=True), sa.Column('Descr', sa.String(length=512), nullable=True), sa.Column('Disabled', sa.Boolean(), nullable=True), sa.Column('LastMod', sa.DateTime(), nullable=True), sa.Column('Version', sa.Integer(), nullable=True), sa.Column('Type', sa.String(length=80), nullable=True), sa.Column('LogPoint', sa.String(length=1024), nullable=True), sa.Column('UNITPREFIX', sa.String(length=512), nullable=True), sa.Column('Unit', sa.String(length=512), nullable=True), sa.Column('BaseValue', sa.Float(), nullable=True), sa.Column('MeterStartPoint', sa.Float(), nullable=True), sa.Column('LastReadValue', sa.Float(), nullable=True), sa.PrimaryKeyConstraint('ID') ) op.create_table('weather', sa.Column('ID', sa.Integer(), nullable=False), sa.Column('Location', sa.String(length=512), nullable=True), sa.Column('Temperature', sa.Float(), nullable=True), sa.Column('Humidity', sa.Float(), nullable=True), sa.PrimaryKeyConstraint('ID') ) op.create_table('algo_point_mapping', sa.Column('Algorithm_id', sa.Integer(), nullable=False), sa.Column('Point_type_id', sa.Integer(), nullable=False), sa.ForeignKeyConstraint(['Algorithm_id'], ['algorithm.ID'], ), sa.ForeignKeyConstraint(['Point_type_id'], ['point_type.ID'], ), sa.PrimaryKeyConstraint('Algorithm_id', 'Point_type_id') ) op.create_table('asset', sa.Column('ID', sa.Integer(), nullable=False), sa.Column('Name', sa.String(length=512), nullable=True), sa.Column('Location', sa.String(length=512), nullable=True), sa.Column('Group', sa.String(length=512), nullable=True), sa.Column('Health', sa.Float(), nullable=True), sa.Column('Priority', sa.Integer(), nullable=True), sa.Column('Notes', sa.Text(), nullable=True), sa.Column('Site_id', sa.Integer(), nullable=True), sa.Column('Type_id', sa.Integer(), nullable=True), sa.ForeignKeyConstraint(['Site_id'], ['site.ID'], ), sa.ForeignKeyConstraint(['Type_id'], ['asset_type.ID'], ), sa.PrimaryKeyConstraint('ID') ) op.create_table('functional_descriptor', sa.Column('ID', sa.Integer(), nullable=False), sa.Column('Name', sa.String(length=512), nullable=True), sa.Column('Type_id', sa.Integer(), nullable=True), sa.ForeignKeyConstraint(['Type_id'], ['asset_type.ID'], ), sa.PrimaryKeyConstraint('ID') ) op.create_table('inbuildings_config', sa.Column('ID', sa.Integer(), nullable=False), sa.Column('Site_id', sa.Integer(), nullable=True), sa.Column('Enabled', sa.Boolean(), nullable=True), sa.Column('Connection_key', sa.String(length=512), nullable=True), sa.ForeignKeyConstraint(['Site_id'], ['site.ID'], ), sa.PrimaryKeyConstraint('ID') ) op.create_table('issue_history', sa.Column('ID', sa.Integer(), nullable=False), sa.Column('Issues', sa.Integer(), nullable=True), sa.Column('Timestamp_id', sa.Integer(), nullable=True), sa.Column('Site_id', sa.Integer(), nullable=True), sa.ForeignKeyConstraint(['Site_id'], ['site.ID'], ), sa.ForeignKeyConstraint(['Timestamp_id'], ['issue_history_timestamp.ID'], ), sa.PrimaryKeyConstraint('ID') ) op.create_table('algo_asset_mapping', sa.Column('Asset_id', sa.Integer(), nullable=False), sa.Column('Algorithm_id', sa.Integer(), nullable=False), sa.ForeignKeyConstraint(['Algorithm_id'], ['algorithm.ID'], ), sa.ForeignKeyConstraint(['Asset_id'], ['asset.ID'], ), sa.PrimaryKeyConstraint('Asset_id', 'Algorithm_id') ) op.create_table('algo_exclusions', sa.Column('Asset_id', sa.Integer(), nullable=False), sa.Column('Algorithm_id', sa.Integer(), nullable=False), sa.ForeignKeyConstraint(['Algorithm_id'], ['algorithm.ID'], ), sa.ForeignKeyConstraint(['Asset_id'], ['asset.ID'], ), sa.PrimaryKeyConstraint('Asset_id', 'Algorithm_id') ) op.create_table('algo_function_mapping', sa.Column('Algorithm_id', sa.Integer(), nullable=False), sa.Column('FunctionalDescriptor_id', sa.Integer(), nullable=False), sa.ForeignKeyConstraint(['Algorithm_id'], ['algorithm.ID'], ), sa.ForeignKeyConstraint(['FunctionalDescriptor_id'], ['functional_descriptor.ID'], ), sa.PrimaryKeyConstraint('Algorithm_id', 'FunctionalDescriptor_id') ) op.create_table('asset_function_mapping', sa.Column('Asset_id', sa.Integer(), nullable=False), sa.Column('FunctionalDescriptor_id', sa.Integer(), nullable=False), sa.ForeignKeyConstraint(['Asset_id'], ['asset.ID'], ), sa.ForeignKeyConstraint(['FunctionalDescriptor_id'], ['functional_descriptor.ID'], ), sa.PrimaryKeyConstraint('Asset_id', 'FunctionalDescriptor_id') ) op.create_table('asset_point', sa.Column('ID', sa.Integer(), nullable=False), sa.Column('Name', sa.String(length=512), nullable=True), sa.Column('Asset_id', sa.Integer(), nullable=True), sa.Column('PointType_id', sa.Integer(), nullable=True), sa.Column('LoggedEntity_id', sa.Integer(), nullable=True), sa.ForeignKeyConstraint(['Asset_id'], ['asset.ID'], ), sa.ForeignKeyConstraint(['PointType_id'], ['point_type.ID'], ), sa.PrimaryKeyConstraint('ID') ) op.create_table('inbuildings_asset', sa.Column('ID', sa.Integer(), nullable=False), sa.Column('Name', sa.String(length=512), nullable=True), sa.Column('Location', sa.String(length=512), nullable=True), sa.Column('Group', sa.String(length=512), nullable=True), sa.Column('Site_id', sa.Integer(), nullable=True), sa.Column('Asset_id', sa.Integer(), nullable=True), sa.ForeignKeyConstraint(['Asset_id'], ['asset.ID'], ), sa.ForeignKeyConstraint(['Site_id'], ['site.ID'], ), sa.PrimaryKeyConstraint('ID') ) op.create_table('result', sa.Column('ID', sa.Integer(), nullable=False), sa.Column('First_timestamp', sa.DateTime(), nullable=True), sa.Column('Recent_timestamp', sa.DateTime(), nullable=True), sa.Column('Asset_id', sa.Integer(), nullable=True), sa.Column('Algorithm_id', sa.Integer(), nullable=True), sa.Column('Result', sa.Float(), nullable=True), sa.Column('Passed', sa.Boolean(), nullable=True), sa.Column('Active', sa.Boolean(), nullable=True), sa.Column('Acknowledged', sa.Boolean(), nullable=True), sa.Column('Occurances', sa.Integer(), nullable=True), sa.Column('Notes', sa.Text(), nullable=True), sa.ForeignKeyConstraint(['Algorithm_id'], ['algorithm.ID'], ), sa.ForeignKeyConstraint(['Asset_id'], ['asset.ID'], ), sa.PrimaryKeyConstraint('ID') ) op.create_table('points_checked', sa.Column('Result_id', sa.Integer(), nullable=False), sa.Column('Point_id', sa.Integer(), nullable=False), sa.ForeignKeyConstraint(['Point_id'], ['asset_point.ID'], ), sa.ForeignKeyConstraint(['Result_id'], ['result.ID'], ), sa.PrimaryKeyConstraint('Result_id', 'Point_id') )
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.create_table( 'census_file_import_version', sa.Column('id', evalg.database.types.UuidType(), autoincrement=False, nullable=False), sa.Column('pollbook_id', evalg.database.types.UuidType(), autoincrement=False, nullable=True), sa.Column('census_file', sa.LargeBinary(), autoincrement=False, nullable=True), sa.Column('mime_type', sa.UnicodeText(), autoincrement=False, nullable=True), sa.Column('import_results', sa.UnicodeText(), autoincrement=False, nullable=True), sa.Column('initiated_at', evalg.database.types.UtcDateTime(), autoincrement=False, nullable=True), sa.Column('finished_at', evalg.database.types.UtcDateTime(), autoincrement=False, nullable=True), sa.Column('transaction_id', sa.BigInteger(), autoincrement=False, nullable=False), sa.Column('end_transaction_id', sa.BigInteger(), nullable=True), sa.Column('operation_type', sa.SmallInteger(), nullable=False), sa.Column('pollbook_id_mod', sa.Boolean(), server_default=sa.text('false'), nullable=False), sa.Column('census_file_mod', sa.Boolean(), server_default=sa.text('false'), nullable=False), sa.Column('mime_type_mod', sa.Boolean(), server_default=sa.text('false'), nullable=False), sa.Column('import_results_mod', sa.Boolean(), server_default=sa.text('false'), nullable=False), sa.Column('initiated_at_mod', sa.Boolean(), server_default=sa.text('false'), nullable=False), sa.Column('finished_at_mod', sa.Boolean(), server_default=sa.text('false'), nullable=False), sa.PrimaryKeyConstraint('id', 'transaction_id')) op.create_index(op.f('ix_census_file_import_version_end_transaction_id'), 'census_file_import_version', ['end_transaction_id'], unique=False) op.create_index(op.f('ix_census_file_import_version_operation_type'), 'census_file_import_version', ['operation_type'], unique=False) op.create_index(op.f('ix_census_file_import_version_transaction_id'), 'census_file_import_version', ['transaction_id'], unique=False) op.create_table( 'census_file_import', sa.Column('id', evalg.database.types.UuidType(), nullable=False), sa.Column('pollbook_id', evalg.database.types.UuidType(), nullable=False), sa.Column('census_file', sa.LargeBinary(), nullable=True), sa.Column('mime_type', sa.UnicodeText(), nullable=True), sa.Column('import_results', sa.UnicodeText(), nullable=True), sa.Column('initiated_at', evalg.database.types.UtcDateTime(), nullable=True), sa.Column('finished_at', evalg.database.types.UtcDateTime(), nullable=True), sa.ForeignKeyConstraint( ['pollbook_id'], ['pollbook_meta.id'], ), sa.PrimaryKeyConstraint('id'))
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.create_table('btnvalues', sa.Column('id', sa.Integer(), nullable=False), sa.Column('name', sa.String(length=20), nullable=True), sa.Column('value', sa.Integer(), nullable=True), sa.PrimaryKeyConstraint('id')) op.create_table('current_washing', sa.Column('id', sa.Integer(), nullable=False), sa.Column('machineId', sa.Integer(), nullable=True), sa.Column('locationNum', sa.Integer(), nullable=True), sa.Column('price', sa.Float(precision=5), nullable=True), sa.Column('cicle', sa.String(length=120), nullable=True), sa.Column('time', sa.Integer(), nullable=True), sa.Column('start', sa.BigInteger(), nullable=True), sa.Column('end', sa.BigInteger(), nullable=True), sa.PrimaryKeyConstraint('id')) op.create_table( 'dryers', sa.Column('id', sa.Integer(), nullable=False), sa.Column('type', sa.String(length=50), nullable=False), sa.Column('name', sa.String(length=220), nullable=True), sa.Column('number', sa.Integer(), nullable=True), sa.Column('postal', sa.Integer(), nullable=True), sa.Column('locationNum', sa.Integer(), nullable=True), sa.Column('available', sa.String(length=12), nullable=True), sa.Column('cicle', sa.String(length=120), nullable=True), sa.Column('time', sa.Integer(), nullable=True), sa.Column('price', sa.Float(precision=5), nullable=True), sa.PrimaryKeyConstraint('id')) op.create_table( 'users', sa.Column('id', sa.Integer(), nullable=False), sa.Column('email', sa.String(length=120), nullable=False), sa.Column('firstname', sa.String(length=120), nullable=False), sa.Column('lastname', sa.String(length=120), nullable=True), sa.Column('password', sa.String(length=80), nullable=False), sa.Column('avatar', sa.String(length=220), nullable=True), sa.Column('wallet', sa.Float(precision=5), nullable=True), sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('email')) op.create_table( 'wallet_transactions', sa.Column('id', sa.Integer(), nullable=False), sa.Column('trans_time', sa.String(length=220), nullable=True), sa.Column('trans_id', sa.String(length=220), nullable=True), sa.Column('trans_status', sa.String(length=220), nullable=True), sa.Column('paypal_payer_email', sa.String(length=220), nullable=True), sa.Column('paypal_payer_name', sa.String(length=220), nullable=True), sa.Column('paypal_payer_surname', sa.String(length=220), nullable=True), sa.Column('paypal_payer_id', sa.String(length=220), nullable=True), sa.Column('old_amount', sa.Float(precision=5), nullable=True), sa.Column('trans_amount', sa.Float(precision=5), nullable=True), sa.Column('new_amount', sa.Float(precision=5), nullable=True), sa.Column('user_id', sa.Integer(), nullable=True), sa.Column('user_email', sa.String(length=220), nullable=True), sa.PrimaryKeyConstraint('id')) op.create_table( 'washers', sa.Column('id', sa.Integer(), nullable=False), sa.Column('type', sa.String(length=50), nullable=False), sa.Column('name', sa.String(length=220), nullable=True), sa.Column('number', sa.Integer(), nullable=True), sa.Column('postal', sa.Integer(), nullable=True), sa.Column('locationNum', sa.Integer(), nullable=True), sa.Column('available', sa.String(length=12), nullable=True), sa.Column('cicle_1', sa.String(length=120), nullable=True), sa.Column('time_1', sa.Integer(), nullable=True), sa.Column('price_1', sa.Float(precision=5), nullable=True), sa.Column('cicle_2', sa.String(length=120), nullable=True), sa.Column('time_2', sa.Integer(), nullable=True), sa.Column('price_2', sa.Float(precision=5), nullable=True), sa.Column('cicle_3', sa.String(length=120), nullable=True), sa.Column('time_3', sa.Integer(), nullable=True), sa.Column('price_3', sa.Float(precision=5), nullable=True), sa.Column('cicle_4', sa.String(length=120), nullable=True), sa.Column('time_4', sa.Integer(), nullable=True), sa.Column('price_4', sa.Float(precision=5), nullable=True), sa.Column('cicle_5', sa.String(length=120), nullable=True), sa.Column('time_5', sa.Integer(), nullable=True), sa.Column('price_5', sa.Float(precision=5), nullable=True), sa.PrimaryKeyConstraint('id'))
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.create_table( 'requests', sa.Column('id', sa.Integer(), nullable=False), sa.Column('submit_time', sa.DateTime(), nullable=False), sa.Column('did', sa.String(length=512), nullable=False), sa.Column('columns', sa.String(length=1024), nullable=True), sa.Column('selection', sa.String(length=10485760), nullable=True), sa.Column('tree_name', sa.String(length=512), nullable=True), sa.Column('request_id', sa.String(length=48), nullable=False), sa.Column('image', sa.String(length=128), nullable=True), sa.Column('chunk_size', sa.Integer(), nullable=True), sa.Column('workers', sa.Integer(), nullable=True), sa.Column('result_destination', sa.String(length=32), nullable=False), sa.Column('result_format', sa.String(length=32), nullable=False), sa.Column('kafka_broker', sa.String(length=128), nullable=True), sa.Column('workflow_name', sa.String(length=40), nullable=False), sa.Column('files', sa.Integer(), nullable=True), sa.Column('files_skipped', sa.Integer(), nullable=True), sa.Column('total_events', sa.BigInteger(), nullable=True), sa.Column('total_bytes', sa.BigInteger(), nullable=True), sa.Column('did_lookup_time', sa.Integer(), nullable=True), sa.Column('generated_code_cm', sa.String(length=128), nullable=True), sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('request_id')) op.create_table( 'users', sa.Column('admin', sa.Boolean(), nullable=True), sa.Column('created_at', sa.DateTime(), nullable=True), sa.Column('id', sa.Integer(), nullable=False), sa.Column('email', sa.String(length=320), nullable=False), sa.Column('full_name', sa.String(length=120), nullable=False), sa.Column('institution', sa.String(length=120), nullable=True), sa.Column('key', sa.String(length=120), nullable=False), sa.Column('pending', sa.Boolean(), nullable=True), sa.Column('experiment', sa.String(length=120), nullable=True), sa.Column('updated_at', sa.DateTime(), nullable=True), sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('email')) op.create_table( 'file_status', sa.Column('id', sa.Integer(), nullable=False), sa.Column('file_id', sa.Integer(), nullable=False), sa.Column('request_id', sa.String(length=48), nullable=False), sa.Column('status', sa.String(length=128), nullable=False), sa.Column('timestamp', sa.DateTime(), nullable=False), sa.Column('pod_name', sa.String(length=128), nullable=True), sa.Column('info', sa.String(length=10485760), nullable=True), sa.ForeignKeyConstraint( ['request_id'], ['requests.request_id'], ), sa.PrimaryKeyConstraint('id')) op.create_table( 'files', sa.Column('id', sa.Integer(), nullable=False), sa.Column('request_id', sa.String(length=48), nullable=False), sa.Column('file_path', sa.String(length=512), nullable=False), sa.Column('adler32', sa.String(length=48), nullable=True), sa.Column('file_size', sa.BigInteger(), nullable=True), sa.Column('file_events', sa.BigInteger(), nullable=True), sa.ForeignKeyConstraint( ['request_id'], ['requests.request_id'], ), sa.PrimaryKeyConstraint('id')) op.create_table( 'transform_result', sa.Column('id', sa.Integer(), nullable=False), sa.Column('did', sa.String(length=512), nullable=False), sa.Column('file_id', sa.Integer(), nullable=True), sa.Column('file_path', sa.String(length=512), nullable=False), sa.Column('request_id', sa.String(length=48), nullable=False), sa.Column('transform_status', sa.String(length=120), nullable=False), sa.Column('transform_time', sa.Integer(), nullable=True), sa.Column('total_events', sa.BigInteger(), nullable=True), sa.Column('total_bytes', sa.BigInteger(), nullable=True), sa.Column('avg_rate', sa.Float(), nullable=True), sa.Column('messages', sa.Integer(), nullable=True), sa.ForeignKeyConstraint( ['file_id'], ['files.id'], ), sa.PrimaryKeyConstraint('id'))
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.create_table('participant', sa.Column('id', sa.Integer(), nullable=False), sa.Column('name', sa.String(), nullable=True), sa.PrimaryKeyConstraint('id')) op.create_index(op.f('ix_participant_id'), 'participant', ['id'], unique=False) op.create_table('sensor', sa.Column('id', sa.Integer(), nullable=False), sa.Column('name', sa.String(), nullable=True), sa.PrimaryKeyConstraint('id')) op.create_index(op.f('ix_sensor_id'), 'sensor', ['id'], unique=False) op.create_table( 'playlist', sa.Column('id', sa.Integer(), nullable=False), sa.Column('participant_id', sa.Integer(), nullable=True), sa.Column('type', sa.String(), nullable=True), sa.Column('link', sa.String(), nullable=True), sa.ForeignKeyConstraint(['participant_id'], ['participant.id'], ondelete='CASCADE'), sa.PrimaryKeyConstraint('id')) op.create_index(op.f('ix_playlist_id'), 'playlist', ['id'], unique=False) op.create_table( 'recording', sa.Column('id', sa.Integer(), nullable=False), sa.Column('participant_id', sa.Integer(), nullable=True), sa.Column('total_time', sa.BigInteger(), nullable=True), sa.ForeignKeyConstraint(['participant_id'], ['participant.id'], ondelete='CASCADE'), sa.PrimaryKeyConstraint('id')) op.create_index(op.f('ix_recording_id'), 'recording', ['id'], unique=False) op.create_table( 'run', sa.Column('id', sa.Integer(), nullable=False), sa.Column('recording_id', sa.Integer(), nullable=True), sa.Column('current_time', sa.BigInteger(), nullable=True), sa.Column('is_running', sa.Boolean(), nullable=True), sa.ForeignKeyConstraint(['recording_id'], ['recording.id'], ondelete='CASCADE'), sa.PrimaryKeyConstraint('id')) op.create_index(op.f('ix_run_id'), 'run', ['id'], unique=False) op.create_table( 'song', sa.Column('id', sa.Integer(), nullable=False), sa.Column('playlist_id', sa.Integer(), nullable=True), sa.Column('name', sa.String(), nullable=True), sa.Column('link', sa.String(), nullable=True), sa.ForeignKeyConstraint(['playlist_id'], ['playlist.id'], ondelete='CASCADE'), sa.PrimaryKeyConstraint('id')) op.create_index(op.f('ix_song_id'), 'song', ['id'], unique=False) op.create_table( 'file', sa.Column('id', sa.Integer(), nullable=False), sa.Column('recording_id', sa.Integer(), nullable=True), sa.Column('sensor_id', sa.Integer(), nullable=True), sa.Column('name', sa.String(), nullable=True), sa.ForeignKeyConstraint(['recording_id'], ['recording.id'], ondelete='CASCADE'), sa.ForeignKeyConstraint( ['sensor_id'], ['sensor.id'], ), sa.PrimaryKeyConstraint('id')) op.create_index(op.f('ix_file_id'), 'file', ['id'], unique=False) op.create_table( 'value', sa.Column('id', sa.Integer(), nullable=False), sa.Column('file_id', sa.Integer(), nullable=True), sa.Column('timestamp', sa.BigInteger(), nullable=True), sa.Column('value', sa.Float(), nullable=True), sa.ForeignKeyConstraint(['file_id'], ['file.id'], ondelete='CASCADE'), sa.PrimaryKeyConstraint('id')) op.create_index(op.f('ix_value_id'), 'value', ['id'], unique=False) op.create_table( 'result', sa.Column('id', sa.Integer(), nullable=False), sa.Column('run_id', sa.Integer(), nullable=True), sa.Column('timestamp', sa.BigInteger(), nullable=True), sa.Column('song_id', sa.Integer(), nullable=True), sa.Column('verdict', sa.Integer(), nullable=True), sa.ForeignKeyConstraint(['run_id'], ['run.id'], ondelete='CASCADE'), sa.ForeignKeyConstraint( ['song_id'], ['song.id'], ), sa.PrimaryKeyConstraint('id')) op.create_index(op.f('ix_result_id'), 'result', ['id'], unique=False) op.drop_index('ix_results_id', table_name='results') op.drop_table('results') op.drop_index('ix_values_id', table_name='values') op.drop_table('values') op.drop_index('ix_songs_id', table_name='songs') op.drop_table('songs') op.drop_index('ix_runs_id', table_name='runs') op.drop_table('runs') op.drop_index('ix_recordings_id', table_name='recordings') op.drop_table('recordings') op.drop_index('ix_participants_id', table_name='participants') op.drop_table('participants')
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.create_table( 'user', sa.Column('created_at', sa.DateTime(), nullable=False), sa.Column('created_at_ip', sa.String(), nullable=False), sa.Column('id', sa.BigInteger(), nullable=False), # change id field to BigInt for psql on heroku # psql doesn't suppoer unsigned sa.Column('handle', sa.String(length=20), nullable=False), sa.Column('name', sa.String(length=50), nullable=False), sa.Column('email', sa.String(length=120), nullable=False), sa.Column('phone', sa.String(length=20), nullable=True), sa.Column('birthdate', sa.Date(), nullable=False), sa.Column('password', sa.String(length=60), nullable=False), sa.Column('profile_image', sa.String(length=20), nullable=False), sa.Column('background_image', sa.String(length=20), nullable=False), sa.Column('bio', sa.String(length=160), nullable=False), sa.Column('location', sa.String(length=30), nullable=False), sa.Column('website', sa.String(length=100), nullable=False), sa.Column('last_read_message_at', sa.DateTime(), nullable=False), sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('email'), sa.UniqueConstraint('handle'), sa.UniqueConstraint('phone')) op.create_table('follower', sa.Column('follower_id', sa.BigInteger(), nullable=True), sa.Column('following_id', sa.BigInteger(), nullable=True), sa.ForeignKeyConstraint( ['follower_id'], ['user.id'], ), sa.ForeignKeyConstraint( ['following_id'], ['user.id'], )) op.create_table('message', sa.Column('created_at', sa.DateTime(), nullable=False), sa.Column('id', sa.BigInteger(), nullable=False), sa.Column('sender_id', sa.BigInteger(), nullable=False), sa.Column('recipient_id', sa.BigInteger(), nullable=False), sa.Column('body', sa.String(length=500), nullable=False), sa.Column('read_at', sa.DateTime(), nullable=True), sa.ForeignKeyConstraint( ['recipient_id'], ['user.id'], ), sa.ForeignKeyConstraint( ['sender_id'], ['user.id'], ), sa.PrimaryKeyConstraint('id')) op.create_table('post', sa.Column('created_at', sa.DateTime(), nullable=False), sa.Column('id', sa.BigInteger(), nullable=False), sa.Column('content', sa.Text(), nullable=False), sa.Column('user_id', sa.BigInteger(), nullable=False), sa.Column('op_id', sa.BigInteger(), nullable=True), sa.ForeignKeyConstraint( ['op_id'], ['post.id'], ), sa.ForeignKeyConstraint( ['user_id'], ['user.id'], ), sa.PrimaryKeyConstraint('id')) op.create_table('liker', sa.Column('user_id', sa.BigInteger(), nullable=True), sa.Column('post_id', sa.BigInteger(), nullable=True), sa.ForeignKeyConstraint( ['post_id'], ['post.id'], ), sa.ForeignKeyConstraint( ['user_id'], ['user.id'], ))
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.create_table('category', sa.Column('id', sa.Integer(), nullable=False), sa.Column('created', sa.DateTime(), nullable=False), sa.Column('modified', sa.DateTime(), nullable=False), sa.Column('slug', sa.String(length=255), nullable=True), sa.Column('name', sa.String(length=255), nullable=True), sa.Column('description', sa.Text(), nullable=True), sa.Column('logo', sa.Enum('jpg', 'png'), nullable=True), sa.Column('picture', sa.Enum('jpg', 'png'), nullable=True), sa.PrimaryKeyConstraint('id'), mysql_charset='utf8', mysql_collate='utf8_unicode_ci') op.create_table('object_history', sa.Column('id', sa.Integer(), nullable=False), sa.Column('created', sa.DateTime(), nullable=False), sa.Column('modified', sa.DateTime(), nullable=False), sa.Column('object_id', sa.Integer(), nullable=True), sa.Column('type', sa.String(length=255), nullable=True), sa.Column('data', sa.Text(), nullable=True), sa.PrimaryKeyConstraint('id'), mysql_charset='utf8', mysql_collate='utf8_unicode_ci') op.create_index(op.f('ix_object_history_type'), 'object_history', ['type'], unique=False) op.create_table('option', sa.Column('id', sa.Integer(), nullable=False), sa.Column('created', sa.DateTime(), nullable=False), sa.Column('modified', sa.DateTime(), nullable=False), sa.Column('key', sa.String(length=128), nullable=True), sa.Column('type', sa.Enum('string', 'date', 'datetime', 'integer', 'decimal', 'dict', 'list'), nullable=True), sa.Column('value', sa.Text(), nullable=True), sa.PrimaryKeyConstraint('id'), mysql_charset='utf8', mysql_collate='utf8_unicode_ci') op.create_index(op.f('ix_option_key'), 'option', ['key'], unique=False) op.create_table('region', sa.Column('id', sa.Integer(), nullable=False), sa.Column('created', sa.DateTime(), nullable=False), sa.Column('modified', sa.DateTime(), nullable=False), sa.Column('name', sa.String(length=255), nullable=True), sa.Column('description', sa.Text(), nullable=True), sa.Column('website', sa.String(length=255), nullable=True), sa.Column('area', sa.Text(), nullable=True), sa.Column('lat', sa.Numeric(precision=8, scale=6), nullable=True), sa.Column('lon', sa.Numeric(precision=9, scale=6), nullable=True), sa.Column('logo', sa.Enum('jpg', 'png'), nullable=True), sa.Column('picture', sa.Enum('jpg', 'png'), nullable=True), sa.PrimaryKeyConstraint('id'), mysql_charset='utf8', mysql_collate='utf8_unicode_ci') op.create_table('store', sa.Column('id', sa.Integer(), nullable=False), sa.Column('created', sa.DateTime(), nullable=False), sa.Column('modified', sa.DateTime(), nullable=False), sa.Column('region_id', sa.Integer(), nullable=True), sa.Column('osm_id', sa.BigInteger(), nullable=True), sa.Column('name', sa.String(length=255), nullable=True), sa.Column('firstname', sa.String(length=255), nullable=True), sa.Column('lastname', sa.String(length=255), nullable=True), sa.Column('company', sa.String(length=255), nullable=True), sa.Column('address', sa.String(length=255), nullable=True), sa.Column('postalcode', sa.String(length=255), nullable=True), sa.Column('locality', sa.String(length=255), nullable=True), sa.Column('country', sa.String(length=2), nullable=True), sa.Column('lat', sa.Numeric(precision=8, scale=6), nullable=True), sa.Column('lon', sa.Numeric(precision=9, scale=6), nullable=True), sa.Column('website', sa.String(length=255), nullable=True), sa.Column('website_crowdfunding', sa.String(length=255), nullable=True), sa.Column('website_coupon', sa.String(length=255), nullable=True), sa.Column('email', sa.String(length=255), nullable=True), sa.Column('phone', sa.String(length=255), nullable=True), sa.Column('mobile', sa.String(length=255), nullable=True), sa.Column('fax', sa.String(length=255), nullable=True), sa.Column('revisited_government', sa.DateTime(), nullable=True), sa.Column('revisited_store', sa.DateTime(), nullable=True), sa.Column('revisited_user', sa.DateTime(), nullable=True), sa.Column('delivery', sa.Boolean(), nullable=True), sa.Column('pickup', sa.Boolean(), nullable=True), sa.Column('licence', sa.String(length=255), nullable=True), sa.Column('description', sa.Text(), nullable=True), sa.Column('brand', sa.String(length=255), nullable=True), sa.Column('wheelchair', sa.String(length=255), nullable=True), sa.Column('logo', sa.Enum('jpg', 'png'), nullable=True), sa.Column('picture', sa.Enum('jpg', 'png'), nullable=True), sa.ForeignKeyConstraint( ['region_id'], ['region.id'], ), sa.PrimaryKeyConstraint('id'), mysql_charset='utf8', mysql_collate='utf8_unicode_ci') op.create_table('user', sa.Column('id', sa.Integer(), nullable=False), sa.Column('created', sa.DateTime(), nullable=False), sa.Column('modified', sa.DateTime(), nullable=False), sa.Column('region_id', sa.Integer(), nullable=True), sa.Column('email', sa.String(length=255), nullable=True), sa.Column('password', sa.String(length=255), nullable=False), sa.Column('login_datetime', sa.DateTime(), nullable=True), sa.Column('last_login_datetime', sa.DateTime(), nullable=True), sa.Column('login_ip', sa.String(length=64), nullable=True), sa.Column('last_login_ip', sa.String(length=64), nullable=True), sa.Column('failed_login_count', sa.Integer(), nullable=True), sa.Column('last_failed_login_count', sa.Integer(), nullable=True), sa.Column('firstname', sa.String(length=255), nullable=True), sa.Column('lastname', sa.String(length=255), nullable=True), sa.Column('company', sa.String(length=255), nullable=True), sa.Column('address', sa.String(length=255), nullable=True), sa.Column('postalcode', sa.String(length=255), nullable=True), sa.Column('locality', sa.String(length=255), nullable=True), sa.Column('country', sa.String(length=2), nullable=True), sa.Column('language', sa.Enum('de', 'en'), nullable=True), sa.Column('phone', sa.String(length=255), nullable=True), sa.Column('mobile', sa.String(length=255), nullable=True), sa.Column('capabilities', sa.Text(), nullable=True), sa.ForeignKeyConstraint( ['region_id'], ['region.id'], ), sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('email'), mysql_charset='utf8', mysql_collate='utf8_unicode_ci') op.create_table('opening_time', sa.Column('id', sa.Integer(), nullable=False), sa.Column('created', sa.DateTime(), nullable=False), sa.Column('modified', sa.DateTime(), nullable=False), sa.Column('store_id', sa.Integer(), nullable=True), sa.Column('type', sa.Enum('all', 'delivery', 'counter', 'pickup'), nullable=True), sa.Column('weekday', sa.Integer(), nullable=True), sa.Column('open', sa.Integer(), nullable=True), sa.Column('close', sa.Integer(), nullable=True), sa.ForeignKeyConstraint( ['store_id'], ['store.id'], ), sa.PrimaryKeyConstraint('id'), mysql_charset='utf8', mysql_collate='utf8_unicode_ci') op.create_table( 'store_category', sa.Column('store_id', sa.Integer(), nullable=True), sa.Column('category_id', sa.Integer(), nullable=True), sa.ForeignKeyConstraint( ['category_id'], ['category.id'], ), sa.ForeignKeyConstraint( ['store_id'], ['store.id'], )) op.create_table('tag', sa.Column('id', sa.Integer(), nullable=False), sa.Column('created', sa.DateTime(), nullable=False), sa.Column('modified', sa.DateTime(), nullable=False), sa.Column('store_id', sa.Integer(), nullable=True), sa.Column('type', sa.Enum('offer', 'help'), nullable=True), sa.Column('slug', sa.String(length=255), nullable=True), sa.Column('name', sa.String(length=255), nullable=True), sa.Column('description', sa.Text(), nullable=True), sa.ForeignKeyConstraint( ['store_id'], ['store.id'], ), sa.PrimaryKeyConstraint('id'), mysql_charset='utf8', mysql_collate='utf8_unicode_ci')
def upgrade(): ### commands auto generated by Alembic - please adjust! ### op.create_table('task_group', sa.Column('id', sa.BigInteger(), nullable=False), sa.Column('name', sa.String(), nullable=True), sa.Column('description', sa.Text(), nullable=True), sa.Column('date_added', sa.DateTime(timezone=True), server_default=sa.text('CURRENT_TIMESTAMP'), nullable=True), sa.Column('last_update', sa.DateTime(timezone=True), nullable=True), sa.PrimaryKeyConstraint('id') ) op.create_table('document_cloud_image', sa.Column('id', sa.BigInteger(), nullable=False), sa.Column('image_type', sa.String(), nullable=True), sa.Column('fetch_url', sa.String(), nullable=True), sa.Column('dc_project', sa.String(), nullable=True), sa.Column('dc_id', sa.String(), nullable=True), sa.Column('hierarchy', sa.String(), nullable=True), sa.Column('is_page_url', sa.Boolean(), nullable=True), sa.Column('is_current', sa.Boolean(), nullable=True), sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('dc_id') ) op.create_table('ndi_user', sa.Column('id', sa.BigInteger(), nullable=False), sa.Column('name', sa.String(), nullable=False), sa.Column('email', sa.String(), nullable=False), sa.Column('confirmed_at', sa.DateTime(), nullable=True), sa.Column('password', sa.String(), nullable=False), sa.Column('active', sa.Boolean(), nullable=True), sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('email'), sa.UniqueConstraint('name') ) op.create_table('ndi_role', sa.Column('id', sa.BigInteger(), nullable=False), sa.Column('name', sa.String(), nullable=True), sa.Column('description', sa.String(), nullable=True), sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('name') ) op.create_table('work_table', sa.Column('key', sa.String(), nullable=False), sa.Column('return_value', postgresql.JSONB(), nullable=True), sa.Column('work_value', sa.LargeBinary(), nullable=True), sa.Column('traceback', sa.Text(), nullable=True), sa.Column('task_name', sa.String(length=255), nullable=True), sa.Column('updated', sa.DateTime(timezone=True), nullable=True), sa.Column('claimed', sa.Boolean(), server_default=sa.text('FALSE'), nullable=True), sa.Column('cleared', sa.Boolean(), server_default=sa.text('TRUE'), nullable=True), sa.Column('completed', sa.Boolean(), server_default=sa.text('FALSE'), nullable=True), sa.PrimaryKeyConstraint('key') ) op.create_table('roles_users', sa.Column('user_id', sa.Integer(), nullable=True), sa.Column('role_id', sa.Integer(), nullable=True), sa.ForeignKeyConstraint(['role_id'], ['ndi_role.id'], ), sa.ForeignKeyConstraint(['user_id'], ['ndi_user.id'], ) ) op.create_table('form_meta', sa.Column('id', sa.BigInteger(), nullable=False), sa.Column('name', sa.String(), nullable=True), sa.Column('description', sa.Text(), nullable=True), sa.Column('slug', sa.String(), nullable=True), sa.Column('status', sa.String(), nullable=True), sa.Column('index', sa.Integer(), nullable=True), sa.Column('date_added', sa.DateTime(timezone=True), server_default=sa.text('CURRENT_TIMESTAMP'), nullable=True), sa.Column('last_update', sa.DateTime(timezone=True), nullable=True), sa.Column('sample_image', sa.String(), nullable=True), sa.Column('table_name', sa.String(), nullable=True), sa.Column('task_group_id', sa.Integer(), nullable=True), sa.Column('reviewer_count', sa.Integer(), nullable=True), sa.Column('deadline', sa.DateTime(timezone=True), nullable=True), sa.Column('dc_project', sa.String(), nullable=True), sa.Column('dc_filter', sa.Text(), nullable=True), sa.Column('split_image', sa.Boolean(), nullable=True), sa.ForeignKeyConstraint(['task_group_id'], ['task_group.id'], ), sa.PrimaryKeyConstraint('id') ) op.create_table('image_task_assignment', sa.Column('id', sa.BigInteger(), nullable=False), sa.Column('image_id', sa.String(), nullable=True), sa.Column('form_id', sa.Integer(), nullable=True), sa.Column('checkout_expire', sa.DateTime(timezone=True), nullable=True), sa.Column('view_count', sa.Integer(), server_default=sa.text('0'), nullable=True), sa.Column('is_complete', sa.Boolean(), nullable=True), sa.ForeignKeyConstraint(['form_id'], ['form_meta.id'], ), sa.ForeignKeyConstraint(['image_id'], ['document_cloud_image.dc_id'], ), sa.PrimaryKeyConstraint('id') ) op.create_table('form_section', sa.Column('id', sa.BigInteger(), nullable=False), sa.Column('name', sa.String(), nullable=True), sa.Column('slug', sa.String(), nullable=True), sa.Column('index', sa.Integer(), nullable=True), sa.Column('status', sa.String(), nullable=True), sa.Column('form_id', sa.Integer(), nullable=True), sa.ForeignKeyConstraint(['form_id'], ['form_meta.id'], ), sa.PrimaryKeyConstraint('id') ) op.create_table('form_field', sa.Column('id', sa.BigInteger(), nullable=False), sa.Column('name', sa.String(), nullable=True), sa.Column('slug', sa.String(), nullable=True), sa.Column('index', sa.Integer(), nullable=True), sa.Column('status', sa.String(), nullable=True), sa.Column('data_type', sa.String(), nullable=True), sa.Column('section_id', sa.Integer(), nullable=True), sa.Column('form_id', sa.Integer(), nullable=True), sa.ForeignKeyConstraint(['form_id'], ['form_meta.id'], ), sa.ForeignKeyConstraint(['section_id'], ['form_section.id'], ), sa.PrimaryKeyConstraint('id') )
def upgrade(): op.add_column('rooms', sa.Column('start_time', sa.BigInteger(), nullable=True))
def upgrade(): """ Run upgrade """ # ### commands auto generated by Alembic - please adjust! ### op.create_table( 'cbsd_states', sa.Column('id', sa.Integer(), autoincrement=True, nullable=False), sa.Column('name', sa.String(), nullable=False), sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('name'), ) op.create_table( 'domain_proxy_logs', sa.Column('id', sa.Integer(), autoincrement=True, nullable=False), sa.Column('log_from', sa.String(), nullable=True), sa.Column('log_to', sa.String(), nullable=True), sa.Column('log_name', sa.String(), nullable=True), sa.Column('log_message', sa.String(), nullable=True), sa.Column('cbsd_serial_number', sa.String(), nullable=True), sa.Column('network_id', sa.String(), nullable=True), sa.Column('fcc_id', sa.String(), nullable=True), sa.Column('response_code', sa.Integer(), nullable=True), sa.Column('created_date', sa.DateTime(timezone=True), server_default=sa.text('statement_timestamp()'), nullable=False), sa.PrimaryKeyConstraint('id'), ) op.create_table( 'grant_states', sa.Column('id', sa.Integer(), autoincrement=True, nullable=False), sa.Column('name', sa.String(), nullable=False), sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('name'), ) op.create_table( 'request_states', sa.Column('id', sa.Integer(), autoincrement=True, nullable=False), sa.Column('name', sa.String(), nullable=False), sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('name'), ) op.create_table( 'request_types', sa.Column('id', sa.Integer(), autoincrement=True, nullable=False), sa.Column('name', sa.String(), nullable=False), sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('name'), ) op.create_table( 'cbsds', sa.Column('id', sa.Integer(), autoincrement=True, nullable=False), sa.Column('state_id', sa.Integer(), nullable=False), sa.Column('cbsd_id', sa.String(), nullable=True), sa.Column('user_id', sa.String(), nullable=True), sa.Column('fcc_id', sa.String(), nullable=True), sa.Column('cbsd_serial_number', sa.String(), nullable=True), sa.Column('last_seen', sa.DateTime(timezone=True), nullable=True), sa.Column('min_power', sa.Float(), nullable=True), sa.Column('max_power', sa.Float(), nullable=True), sa.Column('antenna_gain', sa.Float(), nullable=True), sa.Column('number_of_ports', sa.Integer(), nullable=True), sa.Column('network_id', sa.String(), nullable=True), sa.Column('created_date', sa.DateTime(timezone=True), server_default=sa.text('statement_timestamp()'), nullable=False), sa.Column('updated_date', sa.DateTime(timezone=True), server_default=sa.text('statement_timestamp()'), nullable=True), sa.ForeignKeyConstraint(['state_id'], ['cbsd_states.id'], ondelete='CASCADE'), sa.PrimaryKeyConstraint('id'), ) op.create_table( 'active_mode_configs', sa.Column('id', sa.Integer(), autoincrement=True, nullable=False), sa.Column('cbsd_id', sa.Integer(), nullable=False), sa.Column('desired_state_id', sa.Integer(), nullable=False), sa.Column('created_date', sa.DateTime(timezone=True), server_default=sa.text('statement_timestamp()'), nullable=False), sa.Column('updated_date', sa.DateTime(timezone=True), server_default=sa.text('statement_timestamp()'), nullable=True), sa.ForeignKeyConstraint(['cbsd_id'], ['cbsds.id'], ondelete='CASCADE'), sa.ForeignKeyConstraint(['desired_state_id'], ['cbsd_states.id'], ondelete='CASCADE'), sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('cbsd_id'), ) op.create_table( 'channels', sa.Column('id', sa.Integer(), autoincrement=True, nullable=False), sa.Column('cbsd_id', sa.Integer(), nullable=True), sa.Column('low_frequency', sa.BigInteger(), nullable=False), sa.Column('high_frequency', sa.BigInteger(), nullable=False), sa.Column('channel_type', sa.String(), nullable=False), sa.Column('rule_applied', sa.String(), nullable=False), sa.Column('max_eirp', sa.Float(), nullable=True), sa.Column('last_used_max_eirp', sa.Float(), nullable=True), sa.Column('created_date', sa.DateTime(timezone=True), server_default=sa.text('statement_timestamp()'), nullable=False), sa.Column('updated_date', sa.DateTime(timezone=True), server_default=sa.text('statement_timestamp()'), nullable=True), sa.ForeignKeyConstraint(['cbsd_id'], ['cbsds.id'], ondelete='CASCADE'), sa.PrimaryKeyConstraint('id'), ) op.create_table( 'requests', sa.Column('id', sa.Integer(), autoincrement=True, nullable=False), sa.Column('type_id', sa.Integer(), nullable=True), sa.Column('state_id', sa.Integer(), nullable=True), sa.Column('cbsd_id', sa.Integer(), nullable=True), sa.Column('created_date', sa.DateTime(timezone=True), server_default=sa.text('statement_timestamp()'), nullable=False), sa.Column('updated_date', sa.DateTime(timezone=True), server_default=sa.text('statement_timestamp()'), nullable=True), sa.Column('payload', sa.JSON(), nullable=True), sa.ForeignKeyConstraint(['cbsd_id'], ['cbsds.id'], ondelete='CASCADE'), sa.ForeignKeyConstraint(['state_id'], ['request_states.id'], ondelete='CASCADE'), sa.ForeignKeyConstraint(['type_id'], ['request_types.id'], ondelete='CASCADE'), sa.PrimaryKeyConstraint('id'), ) op.create_table( 'grants', sa.Column('id', sa.Integer(), autoincrement=True, nullable=False), sa.Column('state_id', sa.Integer(), nullable=False), sa.Column('cbsd_id', sa.Integer(), nullable=True), sa.Column('channel_id', sa.Integer(), nullable=True), sa.Column('grant_id', sa.String(), nullable=False), sa.Column('grant_expire_time', sa.DateTime(timezone=True), nullable=True), sa.Column('transmit_expire_time', sa.DateTime(timezone=True), nullable=True), sa.Column('heartbeat_interval', sa.Integer(), nullable=True), sa.Column('last_heartbeat_request_time', sa.DateTime(timezone=True), nullable=True), sa.Column('channel_type', sa.String(), nullable=True), sa.Column('created_date', sa.DateTime(timezone=True), server_default=sa.text('statement_timestamp()'), nullable=False), sa.Column('updated_date', sa.DateTime(timezone=True), server_default=sa.text('statement_timestamp()'), nullable=True), sa.ForeignKeyConstraint(['cbsd_id'], ['cbsds.id'], ondelete='CASCADE'), sa.ForeignKeyConstraint(['channel_id'], ['channels.id'], ondelete='CASCADE'), sa.ForeignKeyConstraint(['state_id'], ['grant_states.id'], ondelete='CASCADE'), sa.PrimaryKeyConstraint('id'), ) op.create_table( 'responses', sa.Column('id', sa.Integer(), autoincrement=True, nullable=False), sa.Column('request_id', sa.Integer(), nullable=True), sa.Column('grant_id', sa.Integer(), nullable=True), sa.Column('response_code', sa.Integer(), nullable=False), sa.Column('created_date', sa.DateTime(timezone=True), server_default=sa.text('statement_timestamp()'), nullable=False), sa.Column('payload', sa.JSON(), nullable=True), sa.ForeignKeyConstraint(['grant_id'], ['grants.id'], ondelete='CASCADE'), sa.ForeignKeyConstraint(['request_id'], ['requests.id'], ondelete='CASCADE'), sa.PrimaryKeyConstraint('id'), )
def upgrade(): op.create_unique_constraint('uq_brief_responses_id_brief_id', 'brief_responses', ['id', 'brief_id']) op.create_unique_constraint( 'uq_direct_award_search_result_entries_archived_service_id_search_id', 'direct_award_search_result_entries', ['archived_service_id', 'search_id'], ) op.create_unique_constraint('uq_direct_award_searches_id_project_id', 'direct_award_searches', ['id', 'project_id']) op.create_table('outcomes', sa.Column('id', sa.Integer(), nullable=False), sa.Column('external_id', sa.BigInteger(), nullable=False), sa.Column('completed_at', sa.DateTime(), nullable=True), sa.Column('start_date', sa.Date(), nullable=True), sa.Column('end_date', sa.Date(), nullable=True), sa.Column('awarding_organisation_name', sa.String(), nullable=True), sa.Column('award_value', sa.Numeric(precision=11, scale=2), nullable=True), sa.Column('result', sa.String(), nullable=False), sa.Column('direct_award_project_id', sa.Integer(), nullable=True), sa.Column('direct_award_search_id', sa.Integer(), nullable=True), sa.Column('direct_award_archived_service_id', sa.Integer(), nullable=True), sa.Column('brief_id', sa.Integer(), nullable=True), sa.Column('brief_response_id', sa.Integer(), nullable=True), sa.CheckConstraint( "CASE WHEN (result = 'awarded') THEN CAST(brief_response_id IS NULL AS BOOLEAN) = CAST(brief_id IS NULL AS BOOLEAN) ELSE CAST(brief_response_id IS NULL AS BOOLEAN) END", name=op.f('ck_outcomes_brief_keys_nullable'), ), sa.CheckConstraint( "CASE WHEN (result = 'awarded') THEN CAST(direct_award_project_id IS NULL AS BOOLEAN) = " \ "CAST(direct_award_search_id IS NULL AS BOOLEAN) AND CAST(direct_award_project_id IS NULL AS BOOLEAN) = " \ "CAST(direct_award_archived_service_id IS NULL AS BOOLEAN) ELSE " \ "CAST(direct_award_search_id IS NULL AS BOOLEAN) " \ "AND CAST(direct_award_archived_service_id IS NULL AS BOOLEAN) END", name=op.f('ck_outcomes_direct_award_keys_nullable'), ), sa.CheckConstraint( 'CAST(direct_award_project_id IS NULL AS BOOLEAN) != CAST(brief_id IS NULL AS BOOLEAN)', name=op.f('ck_outcomes_either_brief_xor_direct_award'), ), sa.ForeignKeyConstraint(['brief_id'], ['briefs.id'], name=op.f('outcomes_brief_id_fkey')), sa.ForeignKeyConstraint( ['brief_response_id', 'brief_id'], ['brief_responses.id', 'brief_responses.brief_id'], name='fk_outcomes_brief_response_id_brief_id', initially='DEFERRED', deferrable=True, ), sa.ForeignKeyConstraint( ['brief_response_id'], ['brief_responses.id'], name=op.f('outcomes_brief_response_id_fkey'), ), sa.ForeignKeyConstraint( ['direct_award_archived_service_id', 'direct_award_search_id'], ['direct_award_search_result_entries.archived_service_id', 'direct_award_search_result_entries.search_id'], name='fk_outcomes_da_service_id_da_search_id', initially='DEFERRED', deferrable=True, ), sa.ForeignKeyConstraint( ['direct_award_archived_service_id'], ['archived_services.id'], name=op.f('outcomes_direct_award_archived_service_id_fkey'), ), sa.ForeignKeyConstraint( ['direct_award_project_id'], ['direct_award_projects.id'], name=op.f('outcomes_direct_award_project_id_fkey'), ), sa.ForeignKeyConstraint( ['direct_award_search_id', 'direct_award_project_id'], ['direct_award_searches.id', 'direct_award_searches.project_id'], name='fk_outcomes_da_search_id_da_project_id', initially='DEFERRED', deferrable=True, ), sa.ForeignKeyConstraint( ['direct_award_search_id'], ['direct_award_searches.id'], name=op.f('outcomes_direct_award_search_id_fkey'), ), sa.PrimaryKeyConstraint('id', name=op.f('outcomes_pkey')), sa.UniqueConstraint('external_id', name=op.f('uq_outcomes_external_id')), ) op.create_index( 'idx_outcomes_completed_brief_unique', 'outcomes', ['brief_id'], unique=True, postgresql_where=sa.text('completed_at IS NOT NULL'), ) op.create_index( 'idx_outcomes_completed_direct_award_project_unique', 'outcomes', ['direct_award_project_id'], unique=True, postgresql_where=sa.text('completed_at IS NOT NULL'), )
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.create_table('company', sa.Column('id', sa.Integer(), nullable=False), sa.Column('name', sa.String(), nullable=True), sa.Column('isin', sa.String(), nullable=True), sa.Column('number_of_shares', sa.BigInteger(), nullable=True), sa.Column('url', sa.String(), nullable=True), sa.Column('ticker', sa.String(), nullable=True), sa.Column('ipo_date', sa.DateTime(), nullable=True), sa.Column('stock_exchange', sa.String(), nullable=True), sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('isin'), sa.UniqueConstraint('name'), sa.UniqueConstraint('url') ) op.create_index(op.f('ix_company_id'), 'company', ['id'], unique=False) op.create_table('daily_ratio', sa.Column('id', sa.Integer(), nullable=False), sa.Column('period', sa.String(), nullable=True), sa.Column('end_date', sa.DateTime(), nullable=True), sa.Column('currency', sa.String(), nullable=True), sa.Column('market_cap', sa.BigInteger(), nullable=True), sa.Column('price_to_earnings_ratio_ttm', sa.Float(), nullable=True), sa.Column('price_to_book_ratio', sa.Float(), nullable=True), sa.Column('market_to_book_ratio', sa.Float(), nullable=True), sa.Column('price_to_tangible_book_value', sa.Float(), nullable=True), sa.Column('enterprise_value', sa.BigInteger(), nullable=True), sa.Column('ev_to_revenue', sa.Float(), nullable=True), sa.Column('ev_to_net_income', sa.Float(), nullable=True), sa.Column('ev_to_ebit', sa.Float(), nullable=True), sa.Column('ev_to_ebitda', sa.Float(), nullable=True), sa.Column('ev_to_assets', sa.Float(), nullable=True), sa.Column('company_id', sa.Integer(), nullable=True), sa.ForeignKeyConstraint(['company_id'], ['company.id'], ), sa.PrimaryKeyConstraint('id') ) op.create_index(op.f('ix_daily_ratio_id'), 'daily_ratio', ['id'], unique=False) op.create_table('dividend', sa.Column('id', sa.Integer(), nullable=False), sa.Column('currency', sa.String(), nullable=True), sa.Column('ex_dividend_date', sa.DateTime(), nullable=True), sa.Column('pay_date', sa.DateTime(), nullable=True), sa.Column('dividend_payout', sa.Float(), nullable=True), sa.Column('company_id', sa.Integer(), nullable=True), sa.ForeignKeyConstraint(['company_id'], ['company.id'], ), sa.PrimaryKeyConstraint('id') ) op.create_index(op.f('ix_dividend_id'), 'dividend', ['id'], unique=False) op.create_table('financial_statement', sa.Column('id', sa.Integer(), nullable=False), sa.Column('period', sa.String(), nullable=True), sa.Column('end_date', sa.DateTime(), nullable=True), sa.Column('publish_date', sa.DateTime(), nullable=True), sa.Column('url', sa.String(), nullable=True), sa.Column('audited', sa.Boolean(), nullable=True), sa.Column('currency', sa.String(), nullable=True), sa.Column('non_current_assets', sa.BigInteger(), nullable=True), sa.Column('cash_and_equivalents', sa.BigInteger(), nullable=True), sa.Column('current_assets', sa.BigInteger(), nullable=True), sa.Column('total_assets', sa.BigInteger(), nullable=True), sa.Column('short_term_debt', sa.BigInteger(), nullable=True), sa.Column('current_liabilities', sa.BigInteger(), nullable=True), sa.Column('long_term_debt', sa.BigInteger(), nullable=True), sa.Column('long_term_liabilities', sa.BigInteger(), nullable=True), sa.Column('total_debt', sa.BigInteger(), nullable=True), sa.Column('total_liabilities', sa.BigInteger(), nullable=True), sa.Column('total_equity', sa.BigInteger(), nullable=True), sa.Column('total_equities_and_liabilities', sa.BigInteger(), nullable=True), sa.Column('total_revenues', sa.BigInteger(), nullable=True), sa.Column('cost_of_revenue', sa.BigInteger(), nullable=True), sa.Column('costs_of_goods_sold', sa.BigInteger(), nullable=True), sa.Column('gross_profit', sa.BigInteger(), nullable=True), sa.Column('ebitda', sa.BigInteger(), nullable=True), sa.Column('ebit', sa.BigInteger(), nullable=True), sa.Column('operating_income', sa.BigInteger(), nullable=True), sa.Column('interest_expense', sa.BigInteger(), nullable=True), sa.Column('profit_before_tax', sa.BigInteger(), nullable=True), sa.Column('tax_expense', sa.BigInteger(), nullable=True), sa.Column('depreciation', sa.BigInteger(), nullable=True), sa.Column('amortization', sa.BigInteger(), nullable=True), sa.Column('net_income', sa.BigInteger(), nullable=True), sa.Column('earnings_per_share', sa.Float(), nullable=True), sa.Column('company_id', sa.Integer(), nullable=True), sa.ForeignKeyConstraint(['company_id'], ['company.id'], ), sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('url') ) op.create_index(op.f('ix_financial_statement_id'), 'financial_statement', ['id'], unique=False) op.create_table('value_metrics', sa.Column('id', sa.Integer(), nullable=False), sa.Column('period', sa.String(), nullable=True), sa.Column('end_date', sa.DateTime(), nullable=True), sa.Column('currency', sa.String(), nullable=True), sa.Column('book_value', sa.BigInteger(), nullable=True), sa.Column('tangible_book_value', sa.BigInteger(), nullable=True), sa.Column('tangible_book_value_per_share', sa.Float(), nullable=True), sa.Column('debt_to_equity', sa.Float(), nullable=True), sa.Column('equity_ratio', sa.Float(), nullable=True), sa.Column('debt_ratio', sa.Float(), nullable=True), sa.Column('cash_ratio', sa.Float(), nullable=True), sa.Column('gross_profit_margin', sa.Float(), nullable=True), sa.Column('net_profit_margin', sa.Float(), nullable=True), sa.Column('ebit_margin', sa.Float(), nullable=True), sa.Column('operating_margin', sa.Float(), nullable=True), sa.Column('ebitda_margin', sa.Float(), nullable=True), sa.Column('cash_return_on_capital_invested', sa.Float(), nullable=True), sa.Column('debt_to_ebitda', sa.Float(), nullable=True), sa.Column('return_on_equity', sa.Float(), nullable=True), sa.Column('return_on_assets', sa.Float(), nullable=True), sa.Column('current_ratio', sa.Float(), nullable=True), sa.Column('working_capital', sa.BigInteger(), nullable=True), sa.Column('company_id', sa.Integer(), nullable=True), sa.ForeignKeyConstraint(['company_id'], ['company.id'], ), sa.PrimaryKeyConstraint('id') ) op.create_index(op.f('ix_value_metrics_id'), 'value_metrics', ['id'], unique=False) op.drop_index('ix_item_description', table_name='item') op.drop_index('ix_item_id', table_name='item') op.drop_index('ix_item_title', table_name='item') op.drop_table('item') op.alter_column('user', 'email', existing_type=sa.VARCHAR(), nullable=False) op.alter_column('user', 'hashed_password', existing_type=sa.VARCHAR(), nullable=False)
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.create_table( 'projects_version', sa.Column('id', sa.Integer(), autoincrement=False, nullable=False), sa.Column('name', sa.String(length=80), autoincrement=False, nullable=False), sa.Column('summary', sa.String(length=140), autoincrement=False, nullable=True), sa.Column('hashtag', sa.String(length=40), autoincrement=False, nullable=True), sa.Column('image_url', sa.String(length=2048), autoincrement=False, nullable=True), sa.Column('source_url', sa.String(length=2048), autoincrement=False, nullable=True), sa.Column('webpage_url', sa.String(length=2048), autoincrement=False, nullable=True), sa.Column('contact_url', sa.String(length=2048), autoincrement=False, nullable=True), sa.Column('autotext_url', sa.String(length=2048), autoincrement=False, nullable=True), sa.Column('download_url', sa.String(length=2048), autoincrement=False, nullable=True), sa.Column('is_hidden', sa.Boolean(), autoincrement=False, nullable=True), sa.Column('is_webembed', sa.Boolean(), autoincrement=False, nullable=True), sa.Column('is_autoupdate', sa.Boolean(), autoincrement=False, nullable=True), sa.Column('autotext', sa.UnicodeText(), autoincrement=False, nullable=True), sa.Column('longtext', sa.UnicodeText(), autoincrement=False, nullable=False), sa.Column('logo_color', sa.String(length=7), autoincrement=False, nullable=True), sa.Column('logo_icon', sa.String(length=40), autoincrement=False, nullable=True), sa.Column('created_at', sa.DateTime(), autoincrement=False, nullable=False), sa.Column('updated_at', sa.DateTime(), autoincrement=False, nullable=False), sa.Column('user_id', sa.Integer(), autoincrement=False, nullable=True), sa.Column('event_id', sa.Integer(), autoincrement=False, nullable=True), sa.Column('category_id', sa.Integer(), autoincrement=False, nullable=True), sa.Column('progress', sa.Integer(), autoincrement=False, nullable=True), sa.Column('score', sa.Integer(), autoincrement=False, nullable=True), sa.Column('transaction_id', sa.BigInteger(), autoincrement=False, nullable=False), sa.Column('end_transaction_id', sa.BigInteger(), nullable=True), sa.Column('operation_type', sa.SmallInteger(), nullable=False), sa.PrimaryKeyConstraint('id', 'transaction_id')) op.create_index(op.f('ix_projects_version_end_transaction_id'), 'projects_version', ['end_transaction_id'], unique=False) op.create_index(op.f('ix_projects_version_operation_type'), 'projects_version', ['operation_type'], unique=False) op.create_index(op.f('ix_projects_version_transaction_id'), 'projects_version', ['transaction_id'], unique=False) op.create_table( 'transaction', sa.Column('issued_at', sa.DateTime(), nullable=True), sa.Column('id', sa.BigInteger(), autoincrement=True, nullable=False), sa.Column('remote_addr', sa.String(length=50), nullable=True), sa.Column('user_id', sa.Integer(), nullable=True), sa.ForeignKeyConstraint( ['user_id'], ['users.id'], ), sa.PrimaryKeyConstraint('id')) op.create_index(op.f('ix_transaction_user_id'), 'transaction', ['user_id'], unique=False) op.add_column('activities', sa.Column('project_version', sa.Integer(), nullable=True))
def upgrade(): op.create_table('challenges', sa.Column('id', sa.Integer(), nullable=False), sa.Column('name', sa.String(length=80), nullable=True), sa.Column('description', sa.Text(), nullable=True), sa.Column('value', sa.Integer(), nullable=True), sa.Column('category', sa.String(length=80), nullable=True), sa.Column('flags', sa.Text(), nullable=True), sa.Column('hidden', sa.Boolean(), nullable=True), sa.PrimaryKeyConstraint('id')) op.create_table('config', sa.Column('id', sa.Integer(), nullable=False), sa.Column('key', sa.Text(), nullable=True), sa.Column('value', sa.Text(), nullable=True), sa.PrimaryKeyConstraint('id')) op.create_table('containers', sa.Column('id', sa.Integer(), nullable=False), sa.Column('name', sa.String(length=80), nullable=True), sa.Column('buildfile', sa.Text(), nullable=True), sa.PrimaryKeyConstraint('id')) op.create_table('pages', sa.Column('id', sa.Integer(), nullable=False), sa.Column('route', sa.String(length=80), nullable=True), sa.Column('html', sa.Text(), nullable=True), sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('route')) op.create_table( 'teams', sa.Column('id', sa.Integer(), nullable=False), sa.Column('name', sa.String(length=128), nullable=True), sa.Column('email', sa.String(length=128), nullable=True), sa.Column('password', sa.String(length=128), nullable=True), sa.Column('website', sa.String(length=128), nullable=True), sa.Column('affiliation', sa.String(length=128), nullable=True), sa.Column('country', sa.String(length=32), nullable=True), sa.Column('bracket', sa.String(length=32), nullable=True), sa.Column('banned', sa.Boolean(), nullable=True), sa.Column('verified', sa.Boolean(), nullable=True), sa.Column('admin', sa.Boolean(), nullable=True), sa.Column('joined', sa.DateTime(), nullable=True), sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('email'), sa.UniqueConstraint('name')) op.create_table('awards', sa.Column('id', sa.Integer(), nullable=False), sa.Column('teamid', sa.Integer(), nullable=True), sa.Column('name', sa.String(length=80), nullable=True), sa.Column('description', sa.Text(), nullable=True), sa.Column('date', sa.DateTime(), nullable=True), sa.Column('value', sa.Integer(), nullable=True), sa.Column('category', sa.String(length=80), nullable=True), sa.Column('icon', sa.Text(), nullable=True), sa.ForeignKeyConstraint( ['teamid'], ['teams.id'], ), sa.PrimaryKeyConstraint('id')) op.create_table('files', sa.Column('id', sa.Integer(), nullable=False), sa.Column('chal', sa.Integer(), nullable=True), sa.Column('location', sa.Text(), nullable=True), sa.ForeignKeyConstraint( ['chal'], ['challenges.id'], ), sa.PrimaryKeyConstraint('id')) op.create_table('keys', sa.Column('id', sa.Integer(), nullable=False), sa.Column('chal', sa.Integer(), nullable=True), sa.Column('key_type', sa.Integer(), nullable=True), sa.Column('flag', sa.Text(), nullable=True), sa.ForeignKeyConstraint( ['chal'], ['challenges.id'], ), sa.PrimaryKeyConstraint('id')) op.create_table('solves', sa.Column('id', sa.Integer(), nullable=False), sa.Column('chalid', sa.Integer(), nullable=True), sa.Column('teamid', sa.Integer(), nullable=True), sa.Column('ip', sa.Integer(), nullable=True), sa.Column('flag', sa.Text(), nullable=True), sa.Column('date', sa.DateTime(), nullable=True), sa.ForeignKeyConstraint( ['chalid'], ['challenges.id'], ), sa.ForeignKeyConstraint( ['teamid'], ['teams.id'], ), sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('chalid', 'teamid')) op.create_table('tags', sa.Column('id', sa.Integer(), nullable=False), sa.Column('chal', sa.Integer(), nullable=True), sa.Column('tag', sa.String(length=80), nullable=True), sa.ForeignKeyConstraint( ['chal'], ['challenges.id'], ), sa.PrimaryKeyConstraint('id')) op.create_table('tracking', sa.Column('id', sa.Integer(), nullable=False), sa.Column('ip', sa.BigInteger(), nullable=True), sa.Column('team', sa.Integer(), nullable=True), sa.Column('date', sa.DateTime(), nullable=True), sa.ForeignKeyConstraint( ['team'], ['teams.id'], ), sa.PrimaryKeyConstraint('id')) op.create_table('wrong_keys', sa.Column('id', sa.Integer(), nullable=False), sa.Column('chalid', sa.Integer(), nullable=True), sa.Column('teamid', sa.Integer(), nullable=True), sa.Column('date', sa.DateTime(), nullable=True), sa.Column('flag', sa.Text(), nullable=True), sa.ForeignKeyConstraint( ['chalid'], ['challenges.id'], ), sa.ForeignKeyConstraint( ['teamid'], ['teams.id'], ), sa.PrimaryKeyConstraint('id'))
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.create_table('doctor', sa.Column('id', sa.Integer(), nullable=False), sa.Column('first_name', sa.String(length=100), nullable=True), sa.Column('last_name', sa.String(length=100), nullable=True), sa.PrimaryKeyConstraint('id') ) op.create_table('medication', sa.Column('id', sa.Integer(), nullable=False), sa.Column('name', sa.String(length=100), nullable=True), sa.Column('description', sa.Text(length=500), nullable=True), sa.PrimaryKeyConstraint('id') ) op.create_table('patient', sa.Column('id', sa.Integer(), nullable=False), sa.Column('first_name', sa.String(length=100), nullable=True), sa.Column('last_name', sa.String(length=100), nullable=True), sa.Column('birth_date', sa.Date(), nullable=False), sa.Column('doctor_id', sa.Integer(), nullable=False), sa.ForeignKeyConstraint(['doctor_id'], ['doctor.id'], ), sa.PrimaryKeyConstraint('id') ) op.create_table('activity_type', sa.Column('unix_timestamp', sa.BigInteger(), nullable=False), sa.Column('activity_type', sa.Integer(), nullable=False), sa.Column('patient_id', sa.Integer(), nullable=False), sa.ForeignKeyConstraint(['patient_id'], ['patient.id'], ), sa.PrimaryKeyConstraint('unix_timestamp', 'patient_id') ) op.create_table('heart_rate', sa.Column('unix_timestamp', sa.BigInteger(), nullable=False), sa.Column('heart_rate_measure', sa.Float(), nullable=False), sa.Column('patient_id', sa.Integer(), nullable=False), sa.ForeignKeyConstraint(['patient_id'], ['patient.id'], ), sa.PrimaryKeyConstraint('unix_timestamp', 'patient_id') ) op.create_table('message', sa.Column('id', sa.Integer(), nullable=False), sa.Column('patient_id', sa.Integer(), nullable=False), sa.Column('doctor_id', sa.Integer(), nullable=False), sa.Column('message_text', sa.Text(length=500), nullable=True), sa.Column('date_sent', sa.BigInteger(), nullable=True), sa.Column('from_patient', sa.Boolean(), nullable=True), sa.ForeignKeyConstraint(['doctor_id'], ['doctor.id'], ), sa.ForeignKeyConstraint(['patient_id'], ['patient.id'], ), sa.PrimaryKeyConstraint('id') ) op.create_table('patient_medication', sa.Column('patient_id', sa.Integer(), nullable=False), sa.Column('medication_id', sa.Integer(), nullable=False), sa.Column('prescription', sa.Text(length=500), nullable=True), sa.ForeignKeyConstraint(['medication_id'], ['medication.id'], ), sa.ForeignKeyConstraint(['patient_id'], ['patient.id'], ), sa.PrimaryKeyConstraint('patient_id', 'medication_id') ) op.create_table('steps', sa.Column('unix_timestamp', sa.BigInteger(), nullable=False), sa.Column('num_steps', sa.Integer(), nullable=False), sa.Column('patient_id', sa.Integer(), nullable=False), sa.ForeignKeyConstraint(['patient_id'], ['patient.id'], ), sa.PrimaryKeyConstraint('unix_timestamp', 'patient_id') )