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 get_column_type(self):
return sqlalchemy.BigInteger()
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')
)
