def upgrade():
### commands auto generated by Alembic - please adjust! ###
op.create_table('task',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('created_at', sa.DateTime(), nullable=True),
sa.Column('updated_at', sa.DateTime(), nullable=True),
sa.Column('name', sa.String(length=1024), nullable=True),
sa.Column('description', sa.Text(), nullable=True),
sa.PrimaryKeyConstraint('id'),
mysql_engine='InnoDB')
op.create_table('user',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('created_at', sa.DateTime(), nullable=True),
sa.Column('updated_at', sa.DateTime(), nullable=True),
sa.Column('src_ip', sa.String(length=15), nullable=True),
sa.Column('date', sa.Date(), nullable=True),
sa.PrimaryKeyConstraint('id'),
mysql_engine='InnoDB')
op.create_table('web',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('created_at', sa.DateTime(), nullable=True),
sa.Column('updated_at', sa.DateTime(), nullable=True),
sa.Column('task_id', sa.Integer(), nullable=True),
sa.Column('url', sa.Text(), nullable=True),
sa.Column('hashed_url',
sa.String(length=32),
nullable=True),
sa.Column('http_status', sa.Integer(), nullable=True),
sa.Column('title', sa.Text(), nullable=True),
sa.Column('host', sa.String(length=512), nullable=True),
sa.ForeignKeyConstraint(
['task_id'],
['task.id'],
),
sa.PrimaryKeyConstraint('id'),
mysql_engine='InnoDB')
op.create_index(op.f('ix_web_hashed_url'),
'web', ['hashed_url'],
unique=False)
op.create_table('file',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('created_at', sa.DateTime(), nullable=True),
sa.Column('updated_at', sa.DateTime(), nullable=True),
sa.Column('web_id', sa.Integer(), nullable=True),
sa.Column('task_id', sa.Integer(), nullable=True),
sa.Column('name', sa.String(length=1024), nullable=True),
sa.Column('uri', sa.Text(), nullable=True),
sa.Column('kind', sa.String(length=128), nullable=True),
sa.ForeignKeyConstraint(
['task_id'],
['task.id'],
),
sa.ForeignKeyConstraint(
['web_id'],
['web.id'],
),
sa.PrimaryKeyConstraint('id'),
mysql_engine='InnoDB')
op.create_index(op.f('ix_file_kind'), 'file', ['kind'], unique=False)
op.create_table('visit',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('created_at', sa.DateTime(), nullable=True),
sa.Column('updated_at', sa.DateTime(), nullable=True),
sa.Column('user_id', sa.Integer(), nullable=True),
sa.Column('web_id', sa.Integer(), nullable=True),
sa.Column('stay', sa.Float(), nullable=True),
sa.Column('timestamp', sa.DateTime(), nullable=True),
sa.ForeignKeyConstraint(
['user_id'],
['user.id'],
),
sa.ForeignKeyConstraint(
['web_id'],
['web.id'],
),
sa.PrimaryKeyConstraint('id'),
mysql_engine='InnoDB')
op.create_index('user_web_idx',
'visit', ['web_id', 'user_id'],
unique=True)
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('dict_bank',
sa.Column('id', sa.Integer(), autoincrement=True, nullable=False),
sa.Column('name', sa.String(length=200), nullable=True),
sa.Column('description', sa.String(), nullable=True),
sa.Column('web_url', sa.String(length=255), nullable=True),
sa.PrimaryKeyConstraint('id'),
comment='Справочник банков'
)
op.create_table('dict_currency',
sa.Column('id', sa.Integer(), autoincrement=True, nullable=False),
sa.Column('name', sa.String(length=200), nullable=True),
sa.Column('description', sa.String(), nullable=True),
sa.PrimaryKeyConstraint('id'),
comment='Справочник валют'
)
op.create_table('dict_payment_category',
sa.Column('id', sa.Integer(), autoincrement=True, nullable=False),
sa.Column('name', sa.String(length=100), nullable=True),
sa.Column('description', sa.String(), nullable=True),
sa.Column('web_url', sa.String(), nullable=True),
sa.PrimaryKeyConstraint('id'),
comment='Справочник категории платежа'
)
op.create_table('dict_user',
sa.Column('id', sa.Integer(), autoincrement=True, nullable=False),
sa.Column('name', sa.String(length=100), nullable=True),
sa.Column('password', sa.String(length=255), nullable=True),
sa.Column('email', sa.String(length=255), nullable=True),
sa.PrimaryKeyConstraint('id'),
comment='Справочник пользователей'
)
op.create_table('loan',
sa.Column('id', sa.Integer(), autoincrement=True, nullable=False),
sa.Column('name', sa.String(length=200), nullable=True),
sa.Column('currency_id', sa.Integer(), nullable=False),
sa.Column('bank_id', sa.Integer(), nullable=False),
sa.Column('description', sa.String(), nullable=True),
sa.Column('startDebt', sa.Integer(), nullable=True),
sa.Column('leftDebt', sa.Integer(), nullable=True),
sa.Column('paid', sa.Integer(), nullable=True),
sa.Column('paidDebt', sa.Integer(), nullable=True),
sa.Column('openDate', sa.Date(), nullable=True),
sa.Column('closeDate', sa.Date(), nullable=True),
sa.Column('pay', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(['bank_id'], ['dict_bank.id'], ),
sa.ForeignKeyConstraint(['currency_id'], ['dict_currency.id'], ),
sa.PrimaryKeyConstraint('id'),
comment='Информация по кредиту'
)
op.create_table('payment',
sa.Column('id', sa.Integer(), autoincrement=True, nullable=False),
sa.Column('name', sa.String(length=200), nullable=True),
sa.Column('description', sa.String(), nullable=True),
sa.Column('payment_category_id', sa.Integer(), nullable=False),
sa.Column('loan_id', sa.Integer(), nullable=True),
sa.Column('date', sa.Date(), nullable=True),
sa.Column('summ', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(['loan_id'], ['loan.id'], ),
sa.ForeignKeyConstraint(['payment_category_id'], ['dict_payment_category.id'], ),
sa.PrimaryKeyConstraint('id'),
comment='Платежи'
)
op.drop_table('user_model')
def upgrade():
### commands auto generated by Alembic - please adjust! ###
op.create_table(
'feedback', sa.Column('f_id', sa.Integer(), nullable=False),
sa.Column('f_name', sa.String(length=50), nullable=False),
sa.Column('f_type', sa.Integer(), nullable=False),
sa.Column('f_voted', sa.Integer(), nullable=False),
sa.Column('f_subject', sa.String(length=100), nullable=False),
sa.Column('f_message', sa.Text(), nullable=True),
sa.PrimaryKeyConstraint('f_id', name=op.f('pk_feedback')))
op.create_table(
'language', sa.Column('la_id', sa.Integer(), nullable=False),
sa.Column('la_label', sa.String(length=30), nullable=False),
sa.Column('la_code2', sa.String(length=2), nullable=False),
sa.Column('la_code3', sa.String(length=3), nullable=False),
sa.Column('la_country_code2', sa.String(length=2), nullable=False),
sa.Column('la_country_code3', sa.String(length=3), nullable=False),
sa.PrimaryKeyConstraint('la_id', name=op.f('pk_language')))
op.create_table(
'language_translates', sa.Column('lt_id', sa.Integer(),
nullable=False),
sa.Column('lt_label', sa.String(length=256), nullable=False),
sa.PrimaryKeyConstraint('lt_id', name=op.f('pk_language_translates')))
op.create_table(
'locking', sa.Column('l_id', sa.Integer(), nullable=False),
sa.Column('l_user',
webapp2.extensions.database.LONGTEXT(),
nullable=False),
sa.Column('l_table',
webapp2.extensions.database.LONGTEXT(),
nullable=False),
sa.Column('l_record_id', sa.Integer(), nullable=False),
sa.Column('l_start_date', sa.DateTime(), nullable=False),
sa.PrimaryKeyConstraint('l_id', name=op.f('pk_locking')))
op.create_table(
'mod_access', sa.Column('ma_id', sa.Integer(), nullable=False),
sa.Column('ma_module', sa.String(length=50), nullable=False),
sa.Column('ma_description', sa.String(length=50), nullable=False),
sa.PrimaryKeyConstraint('ma_id', name=op.f('pk_mod_access')))
op.create_table(
'news', sa.Column('n_id', sa.Integer(), nullable=False),
sa.Column('n_message', sa.String(length=255), nullable=False),
sa.Column('n_active', sa.Boolean(), nullable=True),
sa.Column('n_alert', sa.Boolean(), nullable=True),
sa.Column('n_keep', sa.Boolean(), nullable=True),
sa.Column('n_start_date', sa.Date(), nullable=False),
sa.Column('n_end_date', sa.Date(), nullable=True),
sa.Column('n_remark',
webapp2.extensions.database.LONGTEXT(),
nullable=True),
sa.PrimaryKeyConstraint('n_id', name=op.f('pk_news')))
op.create_table(
'role', sa.Column('r_id', sa.Integer(), nullable=False),
sa.Column('r_role', sa.String(length=255), nullable=False),
sa.Column('r_remark',
webapp2.extensions.database.LONGTEXT(),
nullable=True),
sa.PrimaryKeyConstraint('r_id', name=op.f('pk_role')))
op.create_table(
'tracking', sa.Column('t_id', sa.Integer(), nullable=False),
sa.Column('t_user',
webapp2.extensions.database.LONGTEXT(),
nullable=False),
sa.Column('t_table',
webapp2.extensions.database.LONGTEXT(),
nullable=False),
sa.Column('t_action', sa.Integer(), nullable=False),
sa.Column('t_record_id', sa.Integer(), nullable=False),
sa.Column('t_change_date_time', sa.DateTime(), nullable=False),
sa.Column('t_contents',
webapp2.extensions.database.LONGTEXT(),
nullable=True),
sa.PrimaryKeyConstraint('t_id', name=op.f('pk_tracking')))
op.create_table(
'language_reference', sa.Column('lr_id', sa.Integer(), nullable=False),
sa.Column('lr_la_id', sa.Integer(), nullable=False),
sa.Column('tr_text',
webapp2.extensions.database.LONGTEXT(),
nullable=False),
sa.Column('lr_lt_id', sa.Integer(), nullable=False),
sa.ForeignKeyConstraint(
['lr_la_id'], ['language.la_id'],
name=op.f('fk_language_reference_lr_la_id_language')),
sa.ForeignKeyConstraint(
['lr_lt_id'], ['language_translates.lt_id'],
name=op.f('fk_language_reference_lr_lt_id_language_translates')),
sa.PrimaryKeyConstraint('lr_id', name=op.f('pk_language_reference')))
op.create_table(
'role_access', sa.Column('ra_id', sa.Integer(), nullable=False),
sa.Column('ra_r_id', sa.Integer(), nullable=False),
sa.Column('ra_module', sa.String(length=50), nullable=False),
sa.Column('ra_create', sa.Boolean(), nullable=True),
sa.Column('ra_read', sa.Boolean(), nullable=True),
sa.Column('ra_update', sa.Boolean(), nullable=True),
sa.Column('ra_delete', sa.Boolean(), nullable=True),
sa.Column('r_remark',
webapp2.extensions.database.LONGTEXT(),
nullable=True),
sa.ForeignKeyConstraint(
['ra_module'], ['mod_access.ma_module'],
name=op.f('fk_role_access_ra_module_mod_access')),
sa.ForeignKeyConstraint(['ra_r_id'], ['role.r_id'],
name=op.f('fk_role_access_ra_r_id_role')),
sa.PrimaryKeyConstraint('ra_id', name=op.f('pk_role_access')))
op.create_table(
'user', sa.Column('u_id', sa.Integer(), nullable=False),
sa.Column('u_active', sa.Boolean(), nullable=True),
sa.Column('u_name', sa.String(length=30), nullable=False),
sa.Column('u_role', sa.Integer(), nullable=True),
sa.Column('u_hash_password', sa.String(length=255), nullable=False),
sa.Column('u_must_change', sa.Boolean(), nullable=True),
sa.Column('u_first_name', sa.String(length=50), nullable=False),
sa.Column('u_middle_name', sa.String(length=50), nullable=True),
sa.Column('u_last_name', sa.String(length=50), nullable=False),
sa.Column('u_email', sa.String(length=100), nullable=False),
sa.Column('u_remark',
webapp2.extensions.database.LONGTEXT(),
nullable=True),
sa.Column('u_locale', sa.Integer(), nullable=True),
sa.Column('u_listitems', sa.Integer(), nullable=True),
sa.Column('u_profile',
webapp2.extensions.database.LONGTEXT(),
nullable=True),
sa.ForeignKeyConstraint(['u_role'], ['role.r_id'],
name=op.f('fk_user_u_role_role')),
sa.PrimaryKeyConstraint('u_id', name=op.f('pk_user')))
### end Alembic commands ###
try:
module = importlib.import_module('runonce.{}'.format(revision))
if hasattr(module, 'upgrade'):
module.upgrade()
else:
logging.warning(
"Revision '{}' has no upgrade() function".format(revision))
except ModuleNotFoundError:
logging.warning("Revision '{}' has no runonce script".format(revision))
except Exception:
raise
return
def upgrade():
### commands auto generated by Alembic - please adjust! ###
op.create_table('cabinet',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('name', sa.String(length=50), nullable=False),
sa.Column('idc_id', sa.String(length=10), nullable=False),
sa.Column('power', sa.Integer(), nullable=True),
sa.PrimaryKeyConstraint('id'),
sa.UniqueConstraint('name')
)
op.create_index(op.f('ix_cabinet_idc_id'), 'cabinet', ['idc_id'], unique=False)
op.create_table('management_card',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('m_type', sa.String(length=50), nullable=True),
sa.PrimaryKeyConstraint('id'),
sa.UniqueConstraint('m_type')
)
op.create_table('manufacturers',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('name', sa.String(length=50), nullable=False),
sa.PrimaryKeyConstraint('id'),
sa.UniqueConstraint('name')
)
op.create_table('power',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('server_power', sa.String(length=50), nullable=True),
sa.PrimaryKeyConstraint('id'),
sa.UniqueConstraint('server_power')
)
op.create_table('product',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('service_name', sa.String(length=50), nullable=False),
sa.Column('pid', sa.Integer(), nullable=False),
sa.Column('module_letter', sa.String(length=15), nullable=False),
sa.Column('dev_interface', sa.String(length=100), nullable=False),
sa.Column('op_interface', sa.String(length=100), nullable=False),
sa.PrimaryKeyConstraint('id')
)
op.create_index(op.f('ix_product_pid'), 'product', ['pid'], unique=False)
op.create_table('raid',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('name', sa.String(length=50), nullable=True),
sa.PrimaryKeyConstraint('id'),
sa.UniqueConstraint('name')
)
op.create_table('raidtype',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('name', sa.String(length=50), nullable=True),
sa.PrimaryKeyConstraint('id'),
sa.UniqueConstraint('name')
)
op.create_table('server',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('supplier', sa.String(length=400), nullable=True),
sa.Column('manufacturers', sa.String(length=100), nullable=True),
sa.Column('manufacture_date', sa.Date(), nullable=True),
sa.Column('server_type', sa.String(length=50), nullable=True),
sa.Column('st', sa.String(length=50), nullable=True),
sa.Column('assets_no', sa.String(length=50), nullable=True),
sa.Column('idc_id', sa.String(length=32), nullable=True),
sa.Column('cabinet_id', sa.Integer(), nullable=True),
sa.Column('uuid', sa.String(length=50), nullable=True),
sa.Column('cabinet_pos', sa.String(length=15), nullable=True),
sa.Column('expire', sa.Date(), nullable=True),
sa.Column('ups', sa.Integer(), nullable=True),
sa.Column('parter', sa.String(length=50), nullable=True),
sa.Column('parter_type', sa.String(length=50), nullable=True),
sa.Column('server_up_time', sa.Date(), nullable=True),
sa.Column('os', sa.String(length=50), nullable=True),
sa.Column('hostname', sa.String(length=30), nullable=True),
sa.Column('inner_ip', sa.String(length=50), nullable=True),
sa.Column('mac_address', sa.String(length=50), nullable=True),
sa.Column('ipinfo', sa.String(length=50), nullable=True),
sa.Column('server_cpu', sa.String(length=50), nullable=True),
sa.Column('server_disk', sa.String(length=50), nullable=True),
sa.Column('server_mem', sa.String(length=50), nullable=True),
sa.Column('raid', sa.String(length=50), nullable=True),
sa.Column('raid_card_type', sa.String(length=50), nullable=True),
sa.Column('remote_card', sa.String(length=50), nullable=True),
sa.Column('remote_cardip', sa.String(length=50), nullable=True),
sa.Column('status', sa.Integer(), nullable=True),
sa.Column('remark', sa.Text(), nullable=True),
sa.Column('last_op_time', sa.DateTime(), nullable=True),
sa.Column('last_op_people', sa.Integer(), nullable=True),
sa.Column('monitor_mail_group', sa.String(length=50), nullable=True),
sa.Column('service_id', sa.Integer(), nullable=True),
sa.Column('server_purpose', sa.Integer(), nullable=True),
sa.Column('trouble_resolve', sa.Integer(), nullable=True),
sa.Column('op_interface_other', sa.Integer(), nullable=True),
sa.Column('dev_interface', sa.Integer(), nullable=True),
sa.Column('check_update_time', sa.DateTime(), nullable=True),
sa.Column('vm_status', sa.Integer(), nullable=True),
sa.Column('power', sa.String(length=30), nullable=True),
sa.Column('host', sa.Integer(), nullable=True),
sa.PrimaryKeyConstraint('id')
)
op.create_index(op.f('ix_server_cabinet_id'), 'server', ['cabinet_id'], unique=False)
op.create_index(op.f('ix_server_hostname'), 'server', ['hostname'], unique=False)
op.create_index(op.f('ix_server_idc_id'), 'server', ['idc_id'], unique=False)
op.create_index(op.f('ix_server_inner_ip'), 'server', ['inner_ip'], unique=False)
op.create_index(op.f('ix_server_os'), 'server', ['os'], unique=False)
op.create_index(op.f('ix_server_uuid'), 'server', ['uuid'], unique=False)
op.create_index(op.f('ix_server_vm_status'), 'server', ['vm_status'], unique=False)
op.create_table('server_type',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('type', sa.String(length=50), nullable=False),
sa.Column('manufacturers_id', sa.Integer(), nullable=True),
sa.PrimaryKeyConstraint('id')
)
op.create_index(op.f('ix_server_type_manufacturers_id'), 'server_type', ['manufacturers_id'], unique=False)
op.create_table('status',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('name', sa.String(length=50), nullable=False),
sa.PrimaryKeyConstraint('id'),
sa.UniqueConstraint('name')
)
op.create_table('supplier',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('name', sa.String(length=50), nullable=True),
sa.PrimaryKeyConstraint('id'),
sa.UniqueConstraint('name')
)
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('games',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('game', sa.String(length=100), nullable=False),
sa.Column('image_path', sa.String(length=500), nullable=False),
sa.PrimaryKeyConstraint('id')
)
op.create_table('tags',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('name', sa.String(length=60), nullable=False),
sa.PrimaryKeyConstraint('id')
)
op.create_table('users',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('username', sa.String(length=40), nullable=False),
sa.Column('email', sa.String(length=255), nullable=False),
sa.Column('hashed_password', sa.String(length=255), nullable=False),
sa.PrimaryKeyConstraint('id'),
sa.UniqueConstraint('email'),
sa.UniqueConstraint('username')
)
op.create_table('channels',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('name', sa.String(length=60), nullable=False),
sa.Column('user_id', sa.Integer(), nullable=False),
sa.Column('created_at', sa.Date(), nullable=False),
sa.ForeignKeyConstraint(['user_id'], ['users.id'], ondelete='CASCADE'),
sa.PrimaryKeyConstraint('id')
)
op.create_table('games_tags',
sa.Column('game_id', sa.Integer(), nullable=True),
sa.Column('tag_id', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(['game_id'], ['games.id'], ondelete='CASCADE'),
sa.ForeignKeyConstraint(['tag_id'], ['tags.id'], ondelete='CASCADE')
)
op.create_table('subscriptions',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('user_id', sa.Integer(), nullable=False),
sa.Column('channel_id', sa.Integer(), nullable=False),
sa.ForeignKeyConstraint(['channel_id'], ['channels.id'], ondelete='CASCADE'),
sa.ForeignKeyConstraint(['user_id'], ['users.id'], ondelete='CASCADE'),
sa.PrimaryKeyConstraint('id')
)
op.create_table('videos',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('title', sa.String(length=100), nullable=False),
sa.Column('image_path', sa.String(length=100), nullable=False),
sa.Column('channel_id', sa.Integer(), nullable=False),
sa.Column('game_id', sa.Integer(), nullable=False),
sa.Column('views', sa.Integer(), nullable=True),
sa.Column('created_at', sa.Date(), nullable=True),
sa.Column('video_path', sa.String(length=300), nullable=False),
sa.Column('description', sa.Text(), nullable=True),
sa.Column('yt_video_id', sa.String(length=30), nullable=True),
sa.ForeignKeyConstraint(['channel_id'], ['channels.id'], ondelete='CASCADE'),
sa.ForeignKeyConstraint(['game_id'], ['games.id'], ondelete='CASCADE'),
sa.PrimaryKeyConstraint('id')
)
op.create_table('comments',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('video_id', sa.Integer(), nullable=False),
sa.Column('user_id', sa.Integer(), nullable=False),
sa.Column('body', sa.String(length=255), nullable=False),
sa.Column('created_at', sa.Date(), nullable=False),
sa.ForeignKeyConstraint(['user_id'], ['users.id'], ondelete='CASCADE'),
sa.ForeignKeyConstraint(['video_id'], ['videos.id'], ondelete='CASCADE'),
sa.PrimaryKeyConstraint('id')
)
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
revenue_account = op.create_table(
'RevenueAccounts',
sa.Column('revenue_account_id',
sa.Integer(),
autoincrement=True,
nullable=False),
sa.Column('client', sa.String(length=3), nullable=True),
sa.Column('responsibility_centre', sa.String(length=5), nullable=True),
sa.Column('service_line', sa.String(length=5), nullable=True),
sa.Column('stob', sa.String(length=4), nullable=True),
sa.Column('project_code', sa.String(length=7), nullable=True),
sa.PrimaryKeyConstraint('revenue_account_id'))
fee_code = op.create_table(
'FeeCodes',
sa.Column('fee_code_id',
sa.Integer(),
autoincrement=True,
nullable=False),
sa.Column('code', sa.String(length=10), nullable=False),
sa.Column('description', sa.String(length=100), nullable=True),
sa.Column('start_date', sa.Date(), nullable=False),
sa.Column('end_date', sa.Date(), nullable=True),
sa.Column('fee', sa.Float(), nullable=False),
sa.Column('revenue_account_id', sa.Integer(), nullable=False),
sa.ForeignKeyConstraint(
['revenue_account_id'],
['RevenueAccounts.revenue_account_id'],
), sa.PrimaryKeyConstraint('fee_code_id'))
op.create_table(
'Payments',
sa.Column('payment_id',
sa.Integer(),
autoincrement=True,
nullable=False),
sa.Column('fee_code_id', sa.Integer(), nullable=False),
sa.Column('quantity', sa.Integer(), nullable=False),
sa.Column('total', sa.Float(), nullable=False),
sa.Column('status', sa.String(length=10), nullable=False),
sa.Column('request_id', sa.Integer(), nullable=False),
sa.Column('created_on', sa.DateTime(), nullable=False),
sa.Column('completed_on', sa.DateTime(), nullable=True),
sa.Column('paybc_url', sa.String(), nullable=True),
sa.Column('response_url', sa.String(), nullable=True),
sa.Column('order_id', sa.String(length=50), nullable=True),
sa.Column('transaction_number', sa.String(length=50), nullable=True),
sa.ForeignKeyConstraint(
['fee_code_id'],
['FeeCodes.fee_code_id'],
), sa.PrimaryKeyConstraint('payment_id'))
# Insert master fee records.
op.bulk_insert(revenue_account, [{
'revenue_account_id': 1,
'client': '000',
'responsibility_centre': '00000',
'service_line': '00000',
'stob': '0000',
'project_code': '0000000'
}])
op.bulk_insert(fee_code, [{
'code': 'FOI0001',
'description': 'Freedom of Information Fee',
'start_date': date.today(),
'end_date': None,
'fee': 10.00,
'revenue_account_id': 1
}])
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.add_column('user', sa.Column('birthdate', sa.Date(), nullable=True))
def upgrade():
### commands auto generated by Alembic - please adjust! ###
op.create_table('cycle', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('name', sa.String(length=128), nullable=False),
sa.PrimaryKeyConstraint('id'))
op.create_table('pack', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('name', sa.String(length=128), nullable=False),
sa.PrimaryKeyConstraint('id'))
op.create_table('side', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('name', sa.String(length=64), nullable=False),
sa.PrimaryKeyConstraint('id'))
op.create_table('user', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('created', sa.Boolean(), nullable=True),
sa.PrimaryKeyConstraint('id'))
op.create_table('faction', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('side_id', sa.Integer(), nullable=True),
sa.Column('name', sa.String(length=64), nullable=False),
sa.ForeignKeyConstraint(
['side_id'],
['side.id'],
), sa.PrimaryKeyConstraint('id'))
op.create_table(
'name', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('user_id', sa.Integer(), nullable=True),
sa.Column('first_name', sa.String(length=512), nullable=True),
sa.Column('last_name', sa.String(length=512), nullable=True),
sa.Column('nickname', sa.String(length=512), nullable=True),
sa.ForeignKeyConstraint(
['user_id'],
['user.id'],
), sa.PrimaryKeyConstraint('id'))
op.create_table(
'tournament', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('upload_user_id', sa.Integer(), nullable=True),
sa.Column('date', sa.Date(), nullable=True),
sa.Column('type', sa.Enum('sc', 'regi', 'nati'), nullable=True),
sa.Column('location', sa.String(length=1024), nullable=True),
sa.Column('mwl', sa.Boolean(), nullable=True),
sa.ForeignKeyConstraint(
['upload_user_id'],
['user.id'],
), sa.PrimaryKeyConstraint('id'))
op.create_table('identity', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('faction_id', sa.Integer(), nullable=True),
sa.Column('name', sa.String(length=256), nullable=False),
sa.ForeignKeyConstraint(
['faction_id'],
['faction.id'],
), sa.PrimaryKeyConstraint('id'))
op.create_table(
'participant', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('user_id', sa.Integer(), nullable=True),
sa.Column('tournament_id', sa.Integer(), nullable=True),
sa.Column('runner_ident_id', sa.Integer(), nullable=True),
sa.Column('corp_ident_id', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(
['corp_ident_id'],
['identity.id'],
), sa.ForeignKeyConstraint(
['runner_ident_id'],
['identity.id'],
), sa.ForeignKeyConstraint(
['tournament_id'],
['tournament.id'],
), sa.ForeignKeyConstraint(
['user_id'],
['user.id'],
), sa.PrimaryKeyConstraint('id'))
op.create_table(
'result', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('participant_id', sa.Integer(), nullable=True),
sa.Column('position', sa.Integer(), nullable=True),
sa.Column('points', sa.Integer(), nullable=True),
sa.Column('strength_of_schedule', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(
['participant_id'],
['participant.id'],
), sa.PrimaryKeyConstraint('id'))
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.add_column('seasons',
sa.Column('start_playoffs', sa.Date(), nullable=True))
op.drop_column('seasons', 'end_regular_season')
def upgrade():
op.create_table(
"real_time_update",
sa.Column("created_at", sa.DateTime(), nullable=False),
sa.Column("updated_at", sa.DateTime(), nullable=True),
sa.Column("id", postgresql.UUID(), nullable=False),
sa.Column("received_at", sa.DateTime(), nullable=False),
sa.Column("contributor", sa.Text(), nullable=True),
sa.Column("connector",
sa.Enum("ire", "gtfs-rt", name="connector_type"),
nullable=False),
sa.Column("status",
sa.Enum("OK", "KO", "pending", name="rt_status"),
nullable=True),
sa.Column("error", sa.Text(), nullable=True),
sa.Column("raw_data", sa.Text(), nullable=True),
sa.PrimaryKeyConstraint("id"),
)
op.create_table(
"vehicle_journey",
sa.Column("id", postgresql.UUID(), nullable=False),
sa.Column("navitia_id", sa.Text(), nullable=False),
sa.Column("circulation_date", sa.Date(), nullable=False),
sa.PrimaryKeyConstraint("id"),
sa.UniqueConstraint(
"navitia_id",
"circulation_date",
name="vehicle_journey_navitia_id_circulation_date_idx"),
)
op.create_table(
"trip_update",
sa.Column("created_at", sa.DateTime(), nullable=False),
sa.Column("updated_at", sa.DateTime(), nullable=True),
sa.Column("vj_id", postgresql.UUID(), nullable=False),
sa.Column("status",
sa.Enum("add",
"delete",
"update",
"none",
name="modification_type"),
nullable=False),
sa.ForeignKeyConstraint(["vj_id"], ["vehicle_journey.id"]),
sa.PrimaryKeyConstraint("vj_id"),
)
op.create_table(
"associate_realtimeupdate_tripupdate",
sa.Column("real_time_update_id", postgresql.UUID(), nullable=False),
sa.Column("trip_update_id", postgresql.UUID(), nullable=False),
sa.ForeignKeyConstraint(["real_time_update_id"],
["real_time_update.id"]),
sa.ForeignKeyConstraint(["trip_update_id"], ["trip_update.vj_id"]),
sa.PrimaryKeyConstraint(
"real_time_update_id",
"trip_update_id",
name="associate_realtimeupdate_tripupdate_pkey"),
)
op.create_table(
"stop_time_update",
sa.Column("created_at", sa.DateTime(), nullable=False),
sa.Column("updated_at", sa.DateTime(), nullable=True),
sa.Column("id", postgresql.UUID(), nullable=False),
sa.Column("trip_update_id", postgresql.UUID(), nullable=False),
sa.Column("stop_id", sa.Text(), nullable=False),
sa.Column("departure", sa.DateTime(), nullable=True),
sa.Column(
"departure_status",
sa.Enum("add",
"delete",
"update",
"none",
name="modification_type"),
nullable=False,
),
sa.Column("arrival", sa.DateTime(), nullable=True),
sa.Column(
"arrival_status",
sa.Enum("add",
"delete",
"update",
"none",
name="modification_type"),
nullable=False,
),
sa.ForeignKeyConstraint(["trip_update_id"], ["trip_update.vj_id"]),
sa.PrimaryKeyConstraint("id"),
)
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('codelist',
sa.Column('code', sa.UnicodeText(), nullable=False),
sa.Column('name', sa.UnicodeText(), nullable=True),
sa.PrimaryKeyConstraint('code'),
sa.UniqueConstraint('code'))
op.create_table('country',
sa.Column('code', sa.UnicodeText(), nullable=False),
sa.Column('name', sa.UnicodeText(), nullable=True),
sa.PrimaryKeyConstraint('code'))
op.create_table(
'milestone', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('milestone_order', sa.Integer(), nullable=True),
sa.Column('name', sa.UnicodeText(), nullable=True),
sa.Column('domestic_external', sa.UnicodeText(), nullable=True),
sa.PrimaryKeyConstraint('id'))
op.create_table('organisation',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('code', sa.UnicodeText(), nullable=True),
sa.Column('budget_code', sa.UnicodeText(), nullable=True),
sa.Column('name', sa.UnicodeText(), nullable=True),
sa.Column('acronym', sa.UnicodeText(), nullable=True),
sa.Column('_type', sa.UnicodeText(), nullable=True),
sa.PrimaryKeyConstraint('id'))
op.create_table(
'codelistcode', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('code', sa.UnicodeText(), nullable=True),
sa.Column('name', sa.UnicodeText(), nullable=True),
sa.Column('codelist_code', sa.Integer(), nullable=False),
sa.ForeignKeyConstraint(
['codelist_code'],
['codelist.code'],
), sa.PrimaryKeyConstraint('id'),
sa.UniqueConstraint('code', 'codelist_code'))
op.create_table(
'location', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('geonames_id', sa.Integer(), nullable=True),
sa.Column('country_code', sa.UnicodeText(), nullable=False),
sa.Column('name', sa.UnicodeText(), nullable=True),
sa.Column('latitude', sa.UnicodeText(), nullable=True),
sa.Column('longitude', sa.UnicodeText(), nullable=True),
sa.Column('feature_code', sa.UnicodeText(), nullable=True),
sa.Column('admin1_code', sa.UnicodeText(), nullable=True),
sa.Column('admin2_code', sa.UnicodeText(), nullable=True),
sa.Column('admin3_code', sa.UnicodeText(), nullable=True),
sa.ForeignKeyConstraint(['country_code'], ['country.code'],
ondelete='CASCADE'),
sa.PrimaryKeyConstraint('id'))
op.create_index(op.f('ix_location_country_code'),
'location', ['country_code'],
unique=False)
op.create_table(
'maediuser', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('username', sa.UnicodeText(), nullable=False),
sa.Column('name', sa.UnicodeText(), nullable=True),
sa.Column('email_address', sa.UnicodeText(), nullable=True),
sa.Column('reset_password_key', sa.UnicodeText(), nullable=True),
sa.Column('pw_hash', sa.String(length=255), nullable=True),
sa.Column('organisation', sa.UnicodeText(), nullable=True),
sa.Column('administrator', sa.Boolean(), nullable=True),
sa.Column('recipient_country_code', sa.UnicodeText(), nullable=False),
sa.ForeignKeyConstraint(['recipient_country_code'], ['country.code'],
ondelete='CASCADE'),
sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('username'))
op.create_index(op.f('ix_maediuser_recipient_country_code'),
'maediuser', ['recipient_country_code'],
unique=False)
op.create_table(
'activity', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('user_id', sa.Integer(), nullable=False),
sa.Column('code', sa.UnicodeText(), nullable=True),
sa.Column('title', sa.UnicodeText(), nullable=True),
sa.Column('description', sa.UnicodeText(), nullable=True),
sa.Column('start_date', sa.Date(), nullable=True),
sa.Column('end_date', sa.Date(), nullable=True),
sa.Column('reporting_org_id', sa.Integer(), nullable=False),
sa.Column('implementing_org', sa.UnicodeText(), nullable=True),
sa.Column('recipient_country_code', sa.UnicodeText(), nullable=False),
sa.Column('dac_sector', sa.UnicodeText(), nullable=True),
sa.Column('collaboration_type', sa.UnicodeText(), nullable=True),
sa.Column('finance_type', sa.UnicodeText(), nullable=True),
sa.Column('tied_status', sa.UnicodeText(), nullable=True),
sa.Column('flow_type', sa.UnicodeText(), nullable=True),
sa.Column('aid_type', sa.UnicodeText(), nullable=True),
sa.Column('activity_status', sa.UnicodeText(), nullable=True),
sa.Column('created_date', sa.DateTime(), nullable=True),
sa.Column('updated_date', sa.DateTime(), nullable=True),
sa.Column('domestic_external', sa.UnicodeText(), nullable=True),
sa.ForeignKeyConstraint(['recipient_country_code'], ['country.code'],
ondelete='CASCADE'),
sa.ForeignKeyConstraint(['reporting_org_id'], ['organisation.id'],
ondelete='CASCADE'),
sa.ForeignKeyConstraint(['user_id'], ['maediuser.id'],
ondelete='CASCADE'),
sa.PrimaryKeyConstraint('id'))
op.create_index(op.f('ix_activity_recipient_country_code'),
'activity', ['recipient_country_code'],
unique=False)
op.create_index(op.f('ix_activity_reporting_org_id'),
'activity', ['reporting_org_id'],
unique=False)
op.create_index(op.f('ix_activity_user_id'),
'activity', ['user_id'],
unique=False)
op.create_table(
'userorganisation', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('user_id', sa.Integer(), nullable=True),
sa.Column('permission_name', sa.UnicodeText(), nullable=True),
sa.Column('permission_value', sa.UnicodeText(), nullable=True),
sa.Column('organisation_id', sa.Integer(), nullable=False),
sa.ForeignKeyConstraint(
['organisation_id'],
['organisation.id'],
),
sa.ForeignKeyConstraint(['user_id'], ['maediuser.id'],
ondelete='CASCADE'),
sa.PrimaryKeyConstraint('id'))
op.create_table(
'userpermission', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('user_id', sa.Integer(), nullable=True),
sa.Column('permission_name', sa.UnicodeText(), nullable=True),
sa.Column('permission_value', sa.UnicodeText(), nullable=True),
sa.ForeignKeyConstraint(['user_id'], ['maediuser.id'],
ondelete='CASCADE'),
sa.PrimaryKeyConstraint('id'))
op.create_table(
'activitycodelistcode', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('activity_id', sa.Integer(), nullable=False),
sa.Column('codelist_code_id', sa.Integer(), nullable=False),
sa.Column('percentage', sa.Float(), nullable=True),
sa.ForeignKeyConstraint(
['activity_id'],
['activity.id'],
), sa.ForeignKeyConstraint(
['codelist_code_id'],
['codelistcode.id'],
), sa.PrimaryKeyConstraint('id'),
sa.UniqueConstraint('activity_id', 'codelist_code_id'))
op.create_table(
'activityfinances', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('activity_id', sa.Integer(), nullable=False),
sa.Column('currency', sa.UnicodeText(), nullable=True),
sa.Column('transaction_date', sa.Date(), nullable=True),
sa.Column('transaction_type', sa.UnicodeText(), nullable=True),
sa.Column('transaction_description', sa.UnicodeText(), nullable=True),
sa.Column('transaction_value', sa.Float(precision=2), nullable=True),
sa.Column('finance_type', sa.UnicodeText(), nullable=True),
sa.Column('aid_type', sa.UnicodeText(), nullable=True),
sa.Column('provider_org_id', sa.Integer(), nullable=False),
sa.Column('receiver_org_id', sa.Integer(), nullable=False),
sa.ForeignKeyConstraint(
['activity_id'],
['activity.id'],
), sa.ForeignKeyConstraint(
['provider_org_id'],
['organisation.id'],
), sa.ForeignKeyConstraint(
['receiver_org_id'],
['organisation.id'],
), sa.PrimaryKeyConstraint('id'))
op.create_index(op.f('ix_activityfinances_activity_id'),
'activityfinances', ['activity_id'],
unique=False)
op.create_index(op.f('ix_activityfinances_transaction_type'),
'activityfinances', ['transaction_type'],
unique=False)
op.create_table(
'activitylocation', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('activity_id', sa.Integer(), nullable=False),
sa.Column('location_id', sa.Integer(), nullable=False),
sa.ForeignKeyConstraint(
['activity_id'],
['activity.id'],
), sa.ForeignKeyConstraint(
['location_id'],
['location.id'],
), sa.PrimaryKeyConstraint('id'))
op.create_table(
'activitymilestone', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('activity_id', sa.Integer(), nullable=False),
sa.Column('milestone_id', sa.Integer(), nullable=False),
sa.Column('achieved', sa.Boolean(), nullable=True),
sa.Column('notes', sa.UnicodeText(), nullable=True),
sa.ForeignKeyConstraint(['activity_id'], ['activity.id'],
ondelete='CASCADE'),
sa.ForeignKeyConstraint(['milestone_id'], ['milestone.id'],
ondelete='CASCADE'),
sa.PrimaryKeyConstraint('id'),
sa.UniqueConstraint('activity_id', 'milestone_id'))
op.create_index(op.f('ix_activitymilestone_activity_id'),
'activitymilestone', ['activity_id'],
unique=False)
op.create_index(op.f('ix_activitymilestone_milestone_id'),
'activitymilestone', ['milestone_id'],
unique=False)
op.create_table(
'activityorganisation', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('activity_id', sa.Integer(), nullable=False),
sa.Column('organisation_id', sa.Integer(), nullable=False),
sa.Column('role', sa.Integer(), nullable=False),
sa.Column('percentage', sa.Float(), nullable=True),
sa.ForeignKeyConstraint(
['activity_id'],
['activity.id'],
), sa.ForeignKeyConstraint(
['organisation_id'],
['organisation.id'],
), sa.PrimaryKeyConstraint('id'),
sa.UniqueConstraint('activity_id', 'organisation_id', 'role'))
op.create_table(
'activityresult', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('activity_id', sa.Integer(), nullable=False),
sa.Column('result_title', sa.UnicodeText(), nullable=True),
sa.Column('result_description', sa.UnicodeText(), nullable=True),
sa.Column('result_type', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(['activity_id'], ['activity.id'],
ondelete='CASCADE'),
sa.PrimaryKeyConstraint('id'))
op.create_index(op.f('ix_activityresult_activity_id'),
'activityresult', ['activity_id'],
unique=False)
op.create_table(
'forwardspend', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('activity_id', sa.Integer(), nullable=False),
sa.Column('value', sa.Float(precision=2), nullable=True),
sa.Column('value_date', sa.Date(), nullable=True),
sa.Column('value_currency', sa.UnicodeText(), nullable=True),
sa.Column('period_start_date', sa.Date(), nullable=True),
sa.Column('period_end_date', sa.Date(), nullable=True),
sa.ForeignKeyConstraint(['activity_id'], ['activity.id'],
ondelete='CASCADE'),
sa.PrimaryKeyConstraint('id'))
op.create_table(
'activityfinancescodelistcode',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('activityfinance_id', sa.Integer(), nullable=False),
sa.Column('codelist_id', sa.Integer(), nullable=False),
sa.Column('codelist_code_id', sa.Integer(), nullable=False),
sa.ForeignKeyConstraint(
['activityfinance_id'],
['activityfinances.id'],
), sa.ForeignKeyConstraint(
['codelist_code_id'],
['codelistcode.id'],
), sa.ForeignKeyConstraint(
['codelist_id'],
['codelist.code'],
), sa.PrimaryKeyConstraint('id'),
sa.UniqueConstraint('activityfinance_id', 'codelist_id'))
op.create_table(
'activityresultindicator', sa.Column('id',
sa.Integer(),
nullable=False),
sa.Column('result_id', sa.Integer(), nullable=False),
sa.Column('indicator_title', sa.UnicodeText(), nullable=True),
sa.Column('indicator_description', sa.UnicodeText(), nullable=True),
sa.Column('baseline_year', sa.Date(), nullable=True),
sa.Column('baseline_value', sa.UnicodeText(), nullable=True),
sa.Column('baseline_comment', sa.UnicodeText(), nullable=True),
sa.ForeignKeyConstraint(['result_id'], ['activityresult.id'],
ondelete='CASCADE'),
sa.PrimaryKeyConstraint('id'))
op.create_index(op.f('ix_activityresultindicator_result_id'),
'activityresultindicator', ['result_id'],
unique=False)
op.create_table(
'activityresultindicatorperiod',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('indicator_id', sa.Integer(), nullable=False),
sa.Column('period_start', sa.Date(), nullable=True),
sa.Column('period_end', sa.Date(), nullable=True),
sa.Column('target_value', sa.UnicodeText(), nullable=True),
sa.Column('target_comment', sa.UnicodeText(), nullable=True),
sa.Column('actual_value', sa.UnicodeText(), nullable=True),
sa.Column('actual_comment', sa.UnicodeText(), nullable=True),
sa.ForeignKeyConstraint(['indicator_id'],
['activityresultindicator.id'],
ondelete='CASCADE'),
sa.PrimaryKeyConstraint('id'))
op.create_index(op.f('ix_activityresultindicatorperiod_indicator_id'),
'activityresultindicatorperiod', ['indicator_id'],
unique=False)
def upgrade():
op.add_column('risks', sa.Column('start_date', sa.Date(), nullable=True))
op.add_column('risks', sa.Column('end_date', sa.Date(), nullable=True))
op.add_column('risks', sa.Column('status', sa.String(length=250), nullable=True))
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.add_column('Show', sa.Column('start_time', sa.Date(), nullable=True))
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('Movies',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('moviename', sa.String(), nullable=True),
sa.Column('releasedate', sa.Date(), nullable=True),
sa.Column('budget', sa.Float(), nullable=True),
sa.Column('collection', sa.Float(), nullable=True),
sa.Column('description', sa.Text(), nullable=True),
sa.PrimaryKeyConstraint('id')
)
op.create_table('Profiles',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('firstname', sa.String(), nullable=True),
sa.Column('lastname', sa.String(), nullable=True),
sa.Column('dob', sa.Date(), nullable=True),
sa.Column('address', sa.String(), nullable=True),
sa.PrimaryKeyConstraint('id')
)
op.create_table('Actors',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('profileid', sa.Integer(), nullable=True),
sa.Column('note', sa.Text(), nullable=True),
sa.ForeignKeyConstraint(['profileid'], ['Profiles.id'], ondelete='CASCADE'),
sa.PrimaryKeyConstraint('id')
)
op.create_table('Directors',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('profileid', sa.Integer(), nullable=True),
sa.Column('note', sa.Text(), nullable=True),
sa.ForeignKeyConstraint(['profileid'], ['Profiles.id'], ondelete='CASCADE'),
sa.PrimaryKeyConstraint('id')
)
op.create_table('Producers',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('profileid', sa.Integer(), nullable=True),
sa.Column('note', sa.Text(), nullable=True),
sa.ForeignKeyConstraint(['profileid'], ['Profiles.id'], ondelete='CASCADE'),
sa.PrimaryKeyConstraint('id')
)
op.create_table('MovieActors',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('actorid', sa.Integer(), nullable=True),
sa.Column('movieid', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(['actorid'], ['Actors.id'], ondelete='CASCADE'),
sa.ForeignKeyConstraint(['movieid'], ['Movies.id'], ondelete='CASCADE'),
sa.PrimaryKeyConstraint('id')
)
op.create_table('MovieDirectors',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('directorid', sa.Integer(), nullable=True),
sa.Column('movieid', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(['directorid'], ['Directors.id'], ondelete='CASCADE'),
sa.ForeignKeyConstraint(['movieid'], ['Movies.id'], ondelete='CASCADE'),
sa.PrimaryKeyConstraint('id')
)
op.create_table('MovieProducers',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('producerid', sa.Integer(), nullable=True),
sa.Column('movieid', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(['movieid'], ['Movies.id'], ondelete='CASCADE'),
sa.ForeignKeyConstraint(['producerid'], ['Producers.id'], ondelete='CASCADE'),
sa.PrimaryKeyConstraint('id')
)
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('point', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('area', sa.String(length=10), nullable=True),
sa.Column('number', sa.String(length=10), nullable=False),
sa.Column('type', sa.String(length=10), nullable=False),
sa.Column('installdate', sa.Date(), nullable=True),
sa.Column('startdate', sa.Date(), nullable=True),
sa.Column('enddate', sa.Date(), nullable=True),
sa.Column('locate', sa.String(length=20), nullable=True),
sa.Column('active', sa.Integer(), nullable=True),
sa.Column('cst01', sa.Float(), nullable=True),
sa.Column('cst02', sa.Float(), nullable=True),
sa.Column('cst03', sa.Float(), nullable=True),
sa.Column('cst04', sa.Float(), nullable=True),
sa.Column('cst05', sa.Float(), nullable=True),
sa.Column('cst06', sa.Float(), nullable=True),
sa.Column('cst07', sa.Float(), nullable=True),
sa.Column('cst08', sa.Float(), nullable=True),
sa.Column('cst09', sa.Float(), nullable=True),
sa.Column('cst10', sa.Float(), nullable=True),
sa.Column('cst11', sa.Float(), nullable=True),
sa.Column('cst12', sa.Float(), nullable=True),
sa.Column('cst13', sa.Float(), nullable=True),
sa.Column('cst14', sa.Float(), nullable=True),
sa.Column('cst15', sa.Float(), nullable=True),
sa.PrimaryKeyConstraint('id'))
op.create_table(
'site', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('type', sa.String(length=30), nullable=False),
sa.Column('fullname', sa.String(length=30), nullable=False),
sa.Column('nickname', sa.String(length=10), nullable=False),
sa.Column('service', sa.String(length=30), nullable=False),
sa.Column('order', sa.String(length=10), nullable=True),
sa.Column('supervisor', sa.String(length=10), nullable=True),
sa.Column('constructor', sa.String(length=10), nullable=True),
sa.Column('cost', sa.BigInteger(), nullable=True),
sa.Column('start_date', sa.Date(), nullable=True),
sa.Column('end_date', sa.Date(), nullable=True),
sa.Column('memo', sa.Text(), nullable=True),
sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('fullname'),
sa.UniqueConstraint('nickname'))
op.create_table(
'user', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('username', sa.String(length=20), nullable=False),
sa.Column('password', sa.String(length=200), nullable=False),
sa.Column('truename', sa.String(length=20), nullable=False),
sa.Column('company', sa.String(length=20), nullable=False),
sa.Column('phone', sa.String(length=20), nullable=False),
sa.Column('email', sa.String(length=20), nullable=False),
sa.Column('power', sa.String(length=20), nullable=False),
sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('username'))
op.create_table(
'data', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('point_id', sa.Integer(), nullable=True),
sa.Column('measuringdate', sa.DateTime(), nullable=True),
sa.Column('data01', sa.Float(), nullable=True),
sa.Column('data02', sa.Float(), nullable=True),
sa.Column('data03', sa.Float(), nullable=True),
sa.Column('data04', sa.Float(), nullable=True),
sa.Column('data05', sa.Float(), nullable=True),
sa.Column('data06', sa.Float(), nullable=True),
sa.Column('data07', sa.Float(), nullable=True),
sa.Column('data08', sa.Float(), nullable=True),
sa.ForeignKeyConstraint(['point_id'], ['point.id'],
ondelete='CASCADE'),
sa.PrimaryKeyConstraint('id'))
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('auth', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('name', sa.String(length=100), nullable=True),
sa.Column('url', sa.String(length=255), nullable=True),
sa.Column('addtime', sa.DateTime(), nullable=True),
sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('name'))
op.create_index(op.f('ix_auth_addtime'), 'auth', ['addtime'], unique=False)
op.create_table('preview', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('title', sa.String(length=255), nullable=True),
sa.Column('logo', sa.String(length=255), nullable=True),
sa.Column('addtime', sa.DateTime(), nullable=True),
sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('logo'),
sa.UniqueConstraint('title'))
op.create_index(op.f('ix_preview_addtime'),
'preview', ['addtime'],
unique=False)
op.create_table('role', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('name', sa.String(length=100), nullable=True),
sa.Column('auths', sa.String(length=600), nullable=True),
sa.Column('addtime', sa.DateTime(), nullable=True),
sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('name'))
op.create_index(op.f('ix_role_addtime'), 'role', ['addtime'], unique=False)
op.create_table('tag', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('name', sa.String(length=100), nullable=True),
sa.Column('addtime', sa.DateTime(), nullable=True),
sa.PrimaryKeyConstraint('id'))
op.create_index(op.f('ix_tag_addtime'), 'tag', ['addtime'], unique=False)
op.create_table('user', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('name', sa.String(length=100), nullable=True),
sa.Column('pwd', sa.String(length=100), nullable=True),
sa.Column('email', sa.String(length=100), nullable=True),
sa.Column('phone', sa.String(length=11), nullable=True),
sa.Column('info', sa.Text(), nullable=True),
sa.Column('face', sa.String(length=255), nullable=True),
sa.Column('addtime', sa.DateTime(), nullable=True),
sa.Column('uuid', sa.String(length=255), nullable=True),
sa.PrimaryKeyConstraint('id'),
sa.UniqueConstraint('email'), sa.UniqueConstraint('face'),
sa.UniqueConstraint('name'), sa.UniqueConstraint('phone'),
sa.UniqueConstraint('uuid'))
op.create_index(op.f('ix_user_addtime'), 'user', ['addtime'], unique=False)
op.create_table('admin', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('name', sa.String(length=100), nullable=True),
sa.Column('pwd', sa.String(length=100), nullable=True),
sa.Column('is_super', sa.SmallInteger(), nullable=True),
sa.Column('role_id', sa.Integer(), nullable=True),
sa.Column('addtime', sa.DateTime(), nullable=True),
sa.ForeignKeyConstraint(
['role_id'],
['role.id'],
), sa.PrimaryKeyConstraint('id'),
sa.UniqueConstraint('name'))
op.create_index(op.f('ix_admin_addtime'),
'admin', ['addtime'],
unique=False)
op.create_table('movie', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('title', sa.String(length=255), nullable=True),
sa.Column('url', sa.String(length=255), nullable=True),
sa.Column('info', sa.Text(), nullable=True),
sa.Column('logo', sa.String(length=255), nullable=True),
sa.Column('star', sa.SmallInteger(), nullable=True),
sa.Column('playnum', sa.BigInteger(), nullable=True),
sa.Column('commentnum', sa.BigInteger(), nullable=True),
sa.Column('tag_id', sa.Integer(), nullable=True),
sa.Column('area', sa.String(length=255), nullable=True),
sa.Column('release_time', sa.Date(), nullable=True),
sa.Column('length', sa.String(length=100), nullable=True),
sa.Column('addtime', sa.DateTime(), nullable=True),
sa.ForeignKeyConstraint(
['tag_id'],
['tag.id'],
), sa.PrimaryKeyConstraint('id'),
sa.UniqueConstraint('logo'), sa.UniqueConstraint('title'),
sa.UniqueConstraint('url'))
op.create_index(op.f('ix_movie_addtime'),
'movie', ['addtime'],
unique=False)
op.create_table('userlog', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('user_id', sa.Integer(), nullable=True),
sa.Column('ip', sa.String(length=100), nullable=True),
sa.Column('addtime', sa.DateTime(), nullable=True),
sa.ForeignKeyConstraint(
['user_id'],
['user.id'],
), sa.PrimaryKeyConstraint('id'))
op.create_index(op.f('ix_userlog_addtime'),
'userlog', ['addtime'],
unique=False)
op.create_table('adminlog', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('admin_id', sa.Integer(), nullable=True),
sa.Column('ip', sa.String(length=100), nullable=True),
sa.Column('addtime', sa.DateTime(), nullable=True),
sa.ForeignKeyConstraint(
['admin_id'],
['admin.id'],
), sa.PrimaryKeyConstraint('id'))
op.create_index(op.f('ix_adminlog_addtime'),
'adminlog', ['addtime'],
unique=False)
op.create_table('comment', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('content', sa.Text(), nullable=True),
sa.Column('movie_id', sa.Integer(), nullable=True),
sa.Column('user_id', sa.Integer(), nullable=True),
sa.Column('addtime', sa.DateTime(), nullable=True),
sa.ForeignKeyConstraint(
['movie_id'],
['movie.id'],
), sa.ForeignKeyConstraint(
['user_id'],
['user.id'],
), sa.PrimaryKeyConstraint('id'))
op.create_index(op.f('ix_comment_addtime'),
'comment', ['addtime'],
unique=False)
op.create_table('movicecols', sa.Column('id', sa.Integer(),
nullable=False),
sa.Column('movie_id', sa.Integer(), nullable=True),
sa.Column('user_id', sa.Integer(), nullable=True),
sa.Column('addtime', sa.DateTime(), nullable=True),
sa.ForeignKeyConstraint(
['movie_id'],
['movie.id'],
), sa.ForeignKeyConstraint(
['user_id'],
['user.id'],
), sa.PrimaryKeyConstraint('id'))
op.create_index(op.f('ix_movicecols_addtime'),
'movicecols', ['addtime'],
unique=False)
op.create_table('oplog', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('user_id', sa.Integer(), nullable=True),
sa.Column('ip', sa.String(length=100), nullable=True),
sa.Column('reason', sa.String(length=600), nullable=True),
sa.Column('addtime', sa.DateTime(), nullable=True),
sa.ForeignKeyConstraint(
['user_id'],
['admin.id'],
), sa.PrimaryKeyConstraint('id'))
op.create_index(op.f('ix_oplog_addtime'),
'oplog', ['addtime'],
unique=False)
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table(
'adSense',
sa.Column('id', sa.Integer(), autoincrement=True, nullable=False),
sa.Column('image', sa.String(length=100), nullable=True),
sa.Column('description', sa.String(length=64), nullable=True),
sa.Column('dateInsert', sa.DateTime(), nullable=True),
sa.Column('adSenseStats', sa.CHAR(length=1), nullable=True),
sa.PrimaryKeyConstraint('id'))
op.create_table(
'category',
sa.Column('id', sa.Integer(), autoincrement=True, nullable=False),
sa.Column('name', sa.String(length=64), nullable=True),
sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('name'))
op.create_table('role', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('name', sa.String(length=64), nullable=True),
sa.Column('default', sa.Boolean(), nullable=True),
sa.Column('permissions', sa.Integer(), nullable=True),
sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('name'))
op.create_index(op.f('ix_role_default'), 'role', ['default'], unique=False)
op.create_table(
'user',
sa.Column('id', sa.Integer(), autoincrement=True, nullable=False),
sa.Column('name', sa.String(length=64), nullable=True),
sa.Column('email', sa.String(length=64), nullable=True),
sa.Column('password_hash', sa.String(length=128), nullable=True),
sa.Column('userStats', sa.CHAR(length=1), nullable=True),
sa.Column('userRole', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(
['userRole'],
['role.id'],
), sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('email'))
op.create_index(op.f('ix_user_name'), 'user', ['name'], unique=True)
op.create_table(
'article',
sa.Column('id', sa.Integer(), autoincrement=True, nullable=False),
sa.Column('title', sa.String(length=64), nullable=True),
sa.Column('date', sa.Date(), nullable=True),
sa.Column('image', sa.String(length=100), nullable=True),
sa.Column('lide', sa.String(length=240), nullable=True),
sa.Column('text', sa.Text(), nullable=True),
sa.Column('author', sa.Integer(), nullable=True),
sa.Column('category', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(
['author'],
['user.id'],
), sa.ForeignKeyConstraint(
['category'],
['category.id'],
), sa.PrimaryKeyConstraint('id'))
op.create_table('follows',
sa.Column('follower_id', sa.Integer(), nullable=False),
sa.Column('followed_id', sa.Integer(), nullable=False),
sa.Column('timestamp', sa.DateTime(), nullable=True),
sa.ForeignKeyConstraint(
['followed_id'],
['user.id'],
), sa.ForeignKeyConstraint(
['follower_id'],
['user.id'],
), sa.PrimaryKeyConstraint('follower_id', 'followed_id'))
op.create_table(
'log', sa.Column('id',
sa.Integer(),
autoincrement=True,
nullable=False),
sa.Column('dateIn', sa.DateTime(), nullable=True),
sa.Column('dateOut', sa.DateTime(), nullable=True),
sa.Column('user', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(
['user'],
['user.id'],
), sa.PrimaryKeyConstraint('id'))
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('department',
sa.Column('id', sa.Integer(), autoincrement=True, nullable=False),
sa.Column('name', sa.String(length=32), nullable=True),
sa.Column('description', sa.String(length=128), nullable=True),
sa.PrimaryKeyConstraint('id')
)
op.create_table('news',
sa.Column('id', sa.Integer(), autoincrement=True, nullable=False),
sa.Column('title', sa.String(length=32), nullable=True),
sa.Column('author', sa.String(length=32), nullable=True),
sa.Column('content', sa.Text(), nullable=True),
sa.Column('public_time', sa.Date(), nullable=True),
sa.Column('picture', sa.String(length=128), nullable=True),
sa.PrimaryKeyConstraint('id')
)
op.create_table('permission',
sa.Column('id', sa.Integer(), autoincrement=True, nullable=False),
sa.Column('name', sa.String(length=32), nullable=True),
sa.Column('desc', sa.String(length=128), nullable=True),
sa.PrimaryKeyConstraint('id')
)
op.create_table('position',
sa.Column('id', sa.Integer(), autoincrement=True, nullable=False),
sa.Column('name', sa.String(length=32), nullable=True),
sa.Column('level', sa.Integer(), nullable=True),
sa.Column('department_id', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(['department_id'], ['department.id'], ),
sa.PrimaryKeyConstraint('id'),
sa.UniqueConstraint('name')
)
op.create_table('permission_position',
sa.Column('position.id', sa.Integer(), nullable=True),
sa.Column('permission.id', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(['permission.id'], ['permission.id'], ),
sa.ForeignKeyConstraint(['position.id'], ['position.id'], )
)
op.create_table('person',
sa.Column('id', sa.Integer(), autoincrement=True, nullable=False),
sa.Column('name', sa.String(length=32), nullable=False),
sa.Column('password', sa.String(length=128), nullable=False),
sa.Column('nickname', sa.String(length=32), nullable=True),
sa.Column('gender', sa.String(length=32), nullable=True),
sa.Column('age', sa.Integer(), nullable=True),
sa.Column('jobnum', sa.String(length=32), nullable=False),
sa.Column('phone', sa.String(length=32), nullable=True),
sa.Column('email', sa.String(length=32), nullable=True),
sa.Column('photo', sa.String(length=64), nullable=True),
sa.Column('address', sa.String(length=128), nullable=True),
sa.Column('score', sa.Float(), nullable=True),
sa.Column('position_id', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(['position_id'], ['position.id'], ),
sa.PrimaryKeyConstraint('id'),
sa.UniqueConstraint('jobnum')
)
op.create_table('attendance',
sa.Column('id', sa.Integer(), autoincrement=True, nullable=False),
sa.Column('reason', sa.Text(), nullable=True),
sa.Column('atype', sa.String(length=32), nullable=True),
sa.Column('adate', sa.Float(), nullable=True),
sa.Column('start_time', sa.Date(), nullable=True),
sa.Column('end_time', sa.Date(), nullable=True),
sa.Column('examine', sa.String(length=32), nullable=True),
sa.Column('astatue', sa.String(length=32), nullable=True),
sa.Column('person_id', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(['person_id'], ['person.id'], ),
sa.PrimaryKeyConstraint('id')
)
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.add_column('User', sa.Column('last_visit', sa.Date(), nullable=True))
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('website',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('PI_username', sa.String(length=8), nullable=False),
sa.Column('site_name', sa.String(length=100), nullable=False),
sa.Column('url', sa.String(length=100), nullable=False),
sa.Column('is_soge_hosted', sa.Enum('Y', 'N'), nullable=True),
sa.PrimaryKeyConstraint('id')
)
op.create_table('shared_space',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('PI_username', sa.String(length=8), nullable=False),
sa.Column('folder_name', sa.String(length=30), nullable=False),
sa.Column('storage_type', sa.Enum('linux', 'windows'), nullable=True),
sa.Column('is_acl_correct', sa.Boolean(), nullable=True),
sa.PrimaryKeyConstraint('id')
)
op.create_table('information_asset_inventory',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('username', sa.String(length=8), nullable=False),
sa.Column('date', sa.Date(), nullable=True),
sa.Column('year', sa.Integer(), nullable=False),
sa.Column('alt_email', sa.String(length=100), nullable=False),
sa.Column('has_assets', sa.Boolean(), nullable=True),
sa.Column('asset_type', sa.Enum('Application / System', 'Information / data sets (digital)', 'Information / data sets (physical)', 'Technology (Mobile device - University issued)', 'Technology (Mobile device - Personal)', 'Technology (Desktop)', 'Technology (Server)', 'Technology (Network)', 'Technology (Telephony)', 'Physical (HVAC - Heating, ventilation or air conditioning)', 'Physical (Entry system)', 'Service provider (Cloud)', 'Service provider (IT service)'), nullable=True),
sa.Column('asset_name', sa.String(length=100), nullable=True),
sa.Column('asset_owner', sa.String(length=100), nullable=True),
sa.Column('other_details', sa.Text(), nullable=True),
sa.Column('data_classification', sa.Enum('Private', 'Public', 'Internal'), nullable=True),
sa.Column('data_integrity', sa.Enum('Low', 'Medium', 'High'), nullable=True),
sa.Column('data_availability', sa.Enum('Low', 'Medium', 'High'), nullable=True),
sa.Column('recovery_time_objective', sa.Enum('within 2 hours', 'within 6 hours', 'within 24 hours', 'within 72 hours'), nullable=True),
sa.Column('recovery_point_objective', sa.Enum('within 2 hours', 'within 6 hours', 'within 24 hours', 'within 72 hours'), nullable=True),
sa.Column('supply_media', sa.String(length=200), nullable=True),
sa.Column('file_size_estimate', sa.String(length=20), nullable=True),
sa.Column('file_size_final', sa.String(length=20), nullable=True),
sa.Column('path', sa.Text(), nullable=True),
sa.Column('data_type', sa.Enum('Administrative', 'Research'), nullable=True),
sa.Column('linux_or_windows', sa.Enum('linux', 'windows'), nullable=True),
sa.Column('shared_or_personal', sa.Enum('home', 'shared'), nullable=True),
sa.Column('is_data_personal', sa.Boolean(), nullable=False),
sa.Column('curec_accepted', sa.Boolean(), nullable=False),
sa.Column('curec_date', sa.Date(), nullable=True),
sa.Column('data_source', sa.Enum('me', 'other'), nullable=False),
sa.Column('license_or_data_source', sa.Text(), nullable=True),
sa.PrimaryKeyConstraint('id')
)
op.create_table('third_party_register',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('username', sa.String(length=8), nullable=False),
sa.Column('date', sa.Date(), nullable=True),
sa.Column('year', sa.Integer(), nullable=False),
sa.Column('alt_email', sa.String(length=100), nullable=False),
sa.Column('uses_third_parties', sa.Enum('Y', 'N'), nullable=True),
sa.Column('service_user', sa.String(length=100), nullable=True),
sa.Column('Supplier', sa.Text(), nullable=False),
sa.Column('description', sa.String(length=200), nullable=False),
sa.Column('information_type', sa.Text(), nullable=True),
sa.Column('division', sa.Enum('social_sci', 'humanities'), nullable=True),
sa.Column('data_classification', sa.Enum('Private', 'Public', 'Internal'), nullable=True),
sa.Column('data_volume_records', sa.Enum('<1000', '1000-4999', '5000-10k', '>10k'), nullable=True),
sa.Column('data_compliance', sa.Enum('Unspecific', 'Specific'), nullable=True),
sa.PrimaryKeyConstraint('id')
)
op.create_table('known_third_party_supplier',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('name', sa.String(length=60), nullable=True),
sa.Column('description', sa.String(length=100), nullable=False),
sa.Column('service_type', sa.Enum('infrastructure', 'platform', 'software', 'cots', 'custom_software', 'outsourced_service_provider', 'other'), nullable=True),
sa.Column('service_owner_email', sa.String(length=100), nullable=True),
sa.Column('data_location', sa.Enum('UK', 'EEA', 'non-EEA'), nullable=True),
sa.PrimaryKeyConstraint('id')
)
op.create_table('shared_survey',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('username', sa.String(length=8), nullable=False),
sa.Column('date', sa.Date(), nullable=True),
sa.Column('year', sa.Integer(), nullable=False),
sa.Column('alt_email', sa.String(length=100), nullable=False),
sa.Column('has_data', sa.Enum('Y', 'N'), nullable=True),
sa.Column('group', sa.Enum('15_20deg_water_resources', 'arve', 'beta-diversity', 'carina', 'clarify', 'ComputationalScience', 'do4models', 'EcosystemsLab_TLS', 'enso_flavours', 'fennec', 'gem', 'ghm', 'gwava', 'hiasa', 'impala', 'leaf-gpu', 'leap', 'marius', 'mistral', 'mooredrought', 'okvbasin_sdm', 'pollcurb', 'reach', 'river-routing', 'seviri_dust', 'sfp-datascience', 'soge_routines', 'titan', 'tnc', 'umfula', 'weather_attribution', 'Other'), nullable=False),
sa.Column('other_group', sa.String(length=20), nullable=True),
sa.Column('shared_space_id', sa.Integer(), nullable=True),
sa.Column('supply_media', sa.String(length=200), nullable=True),
sa.Column('file_size_estimate', sa.String(length=20), nullable=True),
sa.Column('file_size_final', sa.String(length=20), nullable=True),
sa.Column('format_name', sa.String(length=100), nullable=True),
sa.Column('use_constraints', sa.Text(), nullable=True),
sa.Column('public_access_constraints', sa.Text(), nullable=True),
sa.Column('process_status', sa.Enum('1', '2', '3', '4', '5'), nullable=True),
sa.Column('process_steps_description', sa.Text(), nullable=True),
sa.Column('lineage', sa.Text(), nullable=True),
sa.Column('experimental_design', sa.Text(), nullable=True),
sa.Column('collection_generation_transformation_methods', sa.Text(), nullable=True),
sa.Column('fieldwork_lab_instrumentation', sa.Text(), nullable=True),
sa.Column('analytical_methods', sa.Text(), nullable=True),
sa.Column('comments', sa.Text(), nullable=True),
sa.ForeignKeyConstraint(['shared_space_id'], ['shared_space.id'], ),
sa.PrimaryKeyConstraint('id')
)
op.create_table('webhosting_survey',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('username', sa.String(length=8), nullable=False),
sa.Column('date', sa.Date(), nullable=True),
sa.Column('year', sa.Integer(), nullable=False),
sa.Column('alt_email', sa.String(length=100), nullable=False),
sa.Column('hosted_by_soge', sa.Enum('I', 'E'), nullable=True),
sa.Column('has_site', sa.Enum('Y', 'N'), nullable=True),
sa.Column('site', sa.Enum('first site', 'Other'), nullable=True),
sa.Column('other_site', sa.String(length=20), nullable=True),
sa.Column('website_id', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(['website_id'], ['website.id'], ),
sa.PrimaryKeyConstraint('id')
)
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table(
"building_detail",
sa.Column("building_id", sa.Integer(), nullable=False),
sa.Column("total_household", sa.Integer(), nullable=False),
sa.Column("lowest_floor", sa.Integer(), nullable=False),
sa.Column("highest_floor", sa.Integer(), nullable=False),
sa.Column("approval_date", sa.Date(), nullable=False),
sa.Column("total_dong", sa.Integer(), nullable=False),
sa.Column("number_address", sa.String(length=100), nullable=False),
sa.Column("road_address", sa.String(length=100), nullable=False),
sa.Column("total_deal", sa.Integer(), nullable=False),
sa.Column("total_jeonse", sa.Integer(), nullable=False),
sa.Column("total_wolse", sa.Integer(), nullable=False),
sa.PrimaryKeyConstraint("building_id"),
)
op.create_table(
"issue",
sa.Column("issue_id", sa.Integer(), autoincrement=True,
nullable=False),
sa.Column("title", sa.String(length=100), nullable=False),
sa.Column("contents", sa.Text(), nullable=False),
sa.Column("email", sa.String(length=100), nullable=False),
sa.Column("issue_pw", sa.String(length=20), nullable=False),
sa.Column("writer", sa.String(length=100), nullable=False),
sa.Column(
"created_at",
sa.DateTime(timezone=True),
server_default=sa.text("now()"),
nullable=True,
),
sa.PrimaryKeyConstraint("issue_id"),
)
op.create_table(
"region",
sa.Column("region_code", sa.String(length=50), nullable=False),
sa.Column("city", sa.String(length=10), nullable=False),
sa.Column("gu", sa.String(length=10), nullable=True),
sa.Column("dong", sa.String(length=10), nullable=True),
sa.Column("parent_region_code", sa.String(length=50), nullable=True),
sa.PrimaryKeyConstraint("region_code"),
)
op.create_table(
"building_basic",
sa.Column("building_id", sa.Integer(), nullable=False),
sa.Column("building_name", sa.String(length=50), nullable=False),
sa.Column(
"building_type",
sa.Enum("A1", "B1", "B2", name="building_code_enum"),
nullable=False,
),
sa.Column("region_code", sa.String(length=50), nullable=True),
sa.ForeignKeyConstraint(["region_code"], ["region.region_code"],
ondelete="CASCADE"),
sa.PrimaryKeyConstraint("building_id"),
)
op.create_table(
"household",
sa.Column("household_id",
sa.Integer(),
autoincrement=True,
nullable=False),
sa.Column("dong", sa.Integer(), nullable=False),
sa.Column("floor", sa.Integer(), nullable=False),
sa.Column("direction", sa.String(length=10), nullable=False),
sa.Column("area", sa.Float(), nullable=False),
sa.Column("link", sa.String(length=200), nullable=False),
sa.Column(
"created_at",
sa.DateTime(timezone=True),
server_default=sa.text("now()"),
nullable=True,
),
sa.Column("updated_at", sa.DateTime(timezone=True), nullable=True),
sa.Column("building_id", sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(["building_id"],
["building_basic.building_id"],
ondelete="CASCADE"),
sa.PrimaryKeyConstraint("household_id"),
)
op.create_table(
"price",
sa.Column("price_id", sa.Integer(), autoincrement=True,
nullable=False),
sa.Column(
"sale_type",
sa.Enum("Deal", "Jeonse", "Wolse", name="sale_type_enum"),
nullable=False,
),
sa.Column("default_price", sa.Integer(), nullable=False),
sa.Column("highest_price", sa.Integer(), nullable=True),
sa.Column("wolse_price", sa.Integer(), nullable=True),
sa.Column("house_id", sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(["house_id"], ["household.household_id"],
ondelete="CASCADE"),
sa.PrimaryKeyConstraint("price_id"),
)
def upgrade():
### commands auto generated by Alembic - please adjust! ###
op.create_table('periods', sa.Column('period', sa.Date(), nullable=False),
sa.Column('year', sa.Integer(), nullable=False),
sa.Column('quarter', sa.String(length=7), nullable=False),
sa.PrimaryKeyConstraint('period'))
op.create_index(op.f('ix_periods_period'),
'periods', ['period'],
unique=False)
op.create_table(
'products', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('name', sa.String(length=900), nullable=True),
sa.Column('category', sa.String(length=900), nullable=False),
sa.Column('sub_category', sa.String(length=900), nullable=False),
sa.PrimaryKeyConstraint('id'))
op.create_index(op.f('ix_products_name'),
'products', ['name'],
unique=True)
op.create_table(
'customers', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('name', sa.String(length=900), nullable=False),
sa.Column('record_type', sa.String(length=20), nullable=False),
sa.Column('country_code', sa.String(length=2), nullable=True),
sa.Column('state', sa.String(length=100), nullable=True),
sa.Column('city', sa.String(length=100), nullable=True),
sa.Column('tier', sa.String(length=6), 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_customers_name'),
'customers', ['name'],
unique=False)
op.create_table(
'promotions', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('name', sa.String(length=1000), nullable=False),
sa.Column('credit_name', sa.String(length=600), nullable=False),
sa.Column('credit_value',
sa.Numeric(precision=30, scale=6),
nullable=False),
sa.Column('credit_remaining_value',
sa.Numeric(precision=30, scale=6),
nullable=False),
sa.Column('redeemed_date', sa.Date(), nullable=True),
sa.Column('expiration_date', sa.Date(), nullable=False),
sa.Column('customer_id', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(
['customer_id'],
['customers.id'],
), sa.PrimaryKeyConstraint('id'))
op.create_table(
'spend', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('period', sa.Date(), nullable=True),
sa.Column('promotion_id', sa.Integer(), nullable=True),
sa.Column('product_id', sa.Integer(), nullable=True),
sa.Column('customer_id', sa.Integer(), nullable=True),
sa.Column('spend', sa.Numeric(precision=30, scale=6), nullable=True),
sa.ForeignKeyConstraint(
['customer_id'],
['customers.id'],
), sa.ForeignKeyConstraint(
['period'],
['periods.period'],
), sa.ForeignKeyConstraint(
['product_id'],
['products.id'],
), sa.ForeignKeyConstraint(
['promotion_id'],
['promotions.id'],
), sa.PrimaryKeyConstraint('id'))
op.add_column(u'users',
sa.Column('email', sa.String(length=64), nullable=True))
op.add_column(
u'users',
sa.Column('password_hash', sa.String(length=128), nullable=True))
op.create_index(op.f('ix_users_email'), 'users', ['email'], unique=True)
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table(
'balance_sheet_statements',
sa.Column('isin', sa.String(), nullable=False),
sa.Column('report_date', sa.Date(), nullable=False),
sa.Column('cash', sa.Float(), nullable=True),
sa.Column('short_term_investments', sa.Float(), nullable=True),
sa.Column('net_receivables', sa.Float(), nullable=True),
sa.Column('total_current_assets', sa.Float(), nullable=True),
sa.Column('property_plant_equipment', sa.Float(), nullable=True),
sa.Column('intangible_assets', sa.Float(), nullable=True),
sa.Column('other_assets', sa.Float(), nullable=True),
sa.Column('deferred_long_term_asset_charges',
sa.Float(),
nullable=True),
sa.Column('total_assets', sa.Float(), nullable=True),
sa.Column('accounts_payable', sa.Float(), nullable=True),
sa.Column('short_long_term_debt', sa.Float(), nullable=True),
sa.Column('other_current_liab', sa.Float(), nullable=True),
sa.Column('long_term_debt', sa.Float(), nullable=True),
sa.Column('other_liab', sa.Float(), nullable=True),
sa.Column('deferred_long_term_liab', sa.Float(), nullable=True),
sa.Column('total_current_liabilities', sa.Float(), nullable=True),
sa.Column('total_liab', sa.Float(), nullable=True),
sa.Column('common_stock', sa.Float(), nullable=True),
sa.Column('retained_earnings', sa.Float(), nullable=True),
sa.Column('treasury_stock', sa.Float(), nullable=True),
sa.Column('other_stockholder_equity', sa.Float(), nullable=True),
sa.Column('total_stockholder_equity', sa.Float(), nullable=True),
sa.Column('net_tangible_assets', sa.Float(), nullable=True),
sa.Column('dw_created', sa.DateTime(), nullable=True),
sa.Column('dw_modified', sa.DateTime(), nullable=True),
sa.PrimaryKeyConstraint('isin', 'report_date'))
op.create_table(
'cash_flow_statements', sa.Column('isin', sa.String(), nullable=False),
sa.Column('report_date', sa.Date(), nullable=False),
sa.Column('net_income', sa.Float(), nullable=True),
sa.Column('change_to_netincome', sa.Float(), nullable=True),
sa.Column('change_to_account_receivables', sa.Float(), nullable=True),
sa.Column('change_to_liabilities', sa.Float(), nullable=True),
sa.Column('total_cash_from_operating_activities',
sa.Float(),
nullable=True),
sa.Column('capital_expenditures', sa.Float(), nullable=True),
sa.Column('other_cashflows_from_investing_activities',
sa.Float(),
nullable=True),
sa.Column('total_cashflows_from_investing_activities',
sa.Float(),
nullable=True),
sa.Column('dividends_paid', sa.Float(), nullable=True),
sa.Column('net_borrowings', sa.Float(), nullable=True),
sa.Column('other_cashflows_from_financing_activities',
sa.Float(),
nullable=True),
sa.Column('total_cash_from_financing_activities',
sa.Float(),
nullable=True),
sa.Column('effect_of_exchange_rate', sa.Float(), nullable=True),
sa.Column('change_in_cash', sa.Float(), nullable=True),
sa.Column('repurchase_of_stock', sa.Float(), nullable=True),
sa.Column('issuance_of_stock', sa.Float(), nullable=True),
sa.Column('dw_created', sa.DateTime(), nullable=True),
sa.Column('dw_modified', sa.DateTime(), nullable=True),
sa.PrimaryKeyConstraint('isin', 'report_date'))
op.create_table(
'income_statements', sa.Column('isin', sa.String(), nullable=False),
sa.Column('report_date', sa.Date(), nullable=False),
sa.Column('total_revenue', sa.Float(), nullable=True),
sa.Column('cost_of_revenue', sa.Float(), nullable=True),
sa.Column('gross_profit', sa.Float(), nullable=True),
sa.Column('research_development', sa.Float(), nullable=True),
sa.Column('selling_general_administrative', sa.Float(), nullable=True),
sa.Column('non_recurring', sa.Float(), nullable=True),
sa.Column('other_operating_expenses', sa.Float(), nullable=True),
sa.Column('total_operating_expenses', sa.Float(), nullable=True),
sa.Column('operating_income', sa.Float(), nullable=True),
sa.Column('total_other_income_expense_net', sa.Float(), nullable=True),
sa.Column('ebit', sa.Float(), nullable=True),
sa.Column('interest_expense', sa.Float(), nullable=True),
sa.Column('income_before_tax', sa.Float(), nullable=True),
sa.Column('income_tax_expense', sa.Float(), nullable=True),
sa.Column('minority_interest', sa.Float(), nullable=True),
sa.Column('net_income_from_continuing_ops', sa.Float(), nullable=True),
sa.Column('discontinued_operations', sa.Float(), nullable=True),
sa.Column('extraordinary_items', sa.Float(), nullable=True),
sa.Column('effect_of_accounting_charges', sa.Float(), nullable=True),
sa.Column('other_items', sa.Float(), nullable=True),
sa.Column('net_income', sa.Float(), nullable=True),
sa.Column('net_income_applicable_to_common_shares',
sa.Float(),
nullable=True),
sa.Column('dw_created', sa.DateTime(), nullable=True),
sa.Column('dw_modified', sa.DateTime(), nullable=True),
sa.PrimaryKeyConstraint('isin', 'report_date'))
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table(
'state_program_assignment',
sa.Column('external_id', sa.String(length=255), nullable=True),
sa.Column('state_code', sa.String(length=255), nullable=False),
sa.Column('program_id', sa.String(length=255), nullable=True),
sa.Column('program_location_id', sa.String(length=255), nullable=True),
sa.Column('participation_status',
sa.Enum(
'EXTERNAL_UNKNOWN',
'PRESENT_WITHOUT_INFO',
'DISCHARGED',
'IN_PROGRESS',
'PENDING',
name='state_program_assignment_participation_status'),
nullable=True),
sa.Column('participation_status_raw_text',
sa.String(length=255),
nullable=True),
sa.Column('discharge_reason',
sa.Enum('EXTERNAL_UNKNOWN',
'ABSCONDED',
'ADVERSE_TERMINATION',
'COMPLETED',
'MOVED',
'OPTED_OUT',
'PROGRAM_TRANSFER',
'REINCARCERATED',
name='state_program_assignment_discharge_reason'),
nullable=True),
sa.Column('discharge_reason_raw_text',
sa.String(length=255),
nullable=True),
sa.Column('referral_date', sa.Date(), nullable=True),
sa.Column('start_date', sa.Date(), nullable=True),
sa.Column('discharge_date', sa.Date(), nullable=True),
sa.Column('program_assignment_id', sa.Integer(), nullable=False),
sa.Column('referring_agent_id', sa.Integer(), nullable=True),
sa.Column('person_id', sa.Integer(), nullable=False),
sa.ForeignKeyConstraint(['person_id'], ['state_person.person_id'],
initially='DEFERRED',
deferrable=True),
sa.ForeignKeyConstraint(
['referring_agent_id'],
['state_agent.agent_id'],
), sa.PrimaryKeyConstraint('program_assignment_id'))
op.create_index(op.f('ix_state_program_assignment_external_id'),
'state_program_assignment', ['external_id'],
unique=False)
op.create_index(op.f('ix_state_program_assignment_state_code'),
'state_program_assignment', ['state_code'],
unique=False)
op.create_table(
'state_program_assignment_history',
sa.Column('valid_from', sa.DateTime(), nullable=False),
sa.Column('valid_to', sa.DateTime(), nullable=True),
sa.Column('external_id', sa.String(length=255), nullable=True),
sa.Column('state_code', sa.String(length=255), nullable=False),
sa.Column('program_id', sa.String(length=255), nullable=True),
sa.Column('program_location_id', sa.String(length=255), nullable=True),
sa.Column('participation_status',
sa.Enum(
'EXTERNAL_UNKNOWN',
'PRESENT_WITHOUT_INFO',
'DISCHARGED',
'IN_PROGRESS',
'PENDING',
name='state_program_assignment_participation_status'),
nullable=True),
sa.Column('participation_status_raw_text',
sa.String(length=255),
nullable=True),
sa.Column('discharge_reason',
sa.Enum('EXTERNAL_UNKNOWN',
'ABSCONDED',
'ADVERSE_TERMINATION',
'COMPLETED',
'MOVED',
'OPTED_OUT',
'PROGRAM_TRANSFER',
'REINCARCERATED',
name='state_program_assignment_discharge_reason'),
nullable=True),
sa.Column('discharge_reason_raw_text',
sa.String(length=255),
nullable=True),
sa.Column('referral_date', sa.Date(), nullable=True),
sa.Column('start_date', sa.Date(), nullable=True),
sa.Column('discharge_date', sa.Date(), nullable=True),
sa.Column('program_assignment_history_id',
sa.Integer(),
nullable=False),
sa.Column('program_assignment_id', sa.Integer(), nullable=False),
sa.Column('referring_agent_id', sa.Integer(), nullable=True),
sa.Column('person_id', sa.Integer(), nullable=False),
sa.ForeignKeyConstraint(['person_id'], ['state_person.person_id'],
initially='DEFERRED',
deferrable=True),
sa.ForeignKeyConstraint(
['program_assignment_id'],
['state_program_assignment.program_assignment_id'],
),
sa.ForeignKeyConstraint(
['referring_agent_id'],
['state_agent.agent_id'],
), sa.PrimaryKeyConstraint('program_assignment_history_id'))
op.create_index(op.f('ix_state_program_assignment_history_external_id'),
'state_program_assignment_history', ['external_id'],
unique=False)
op.create_index(
op.f('ix_state_program_assignment_history_program_assignment_id'),
'state_program_assignment_history', ['program_assignment_id'],
unique=False)
op.create_index(op.f('ix_state_program_assignment_history_state_code'),
'state_program_assignment_history', ['state_code'],
unique=False)
op.create_table(
'state_supervision_period_program_assignment_association',
sa.Column('supervision_period_id', sa.Integer(), nullable=True),
sa.Column('program_assignment_id', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(
['program_assignment_id'],
['state_program_assignment.program_assignment_id'],
),
sa.ForeignKeyConstraint(
['supervision_period_id'],
['state_supervision_period.supervision_period_id'],
))
op.create_table(
'state_incarceration_period_program_assignment_association',
sa.Column('incarceration_period_id', sa.Integer(), nullable=True),
sa.Column('program_assignment_id', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(
['incarceration_period_id'],
['state_incarceration_period.incarceration_period_id'],
),
sa.ForeignKeyConstraint(
['program_assignment_id'],
['state_program_assignment.program_assignment_id'],
))
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.add_column('carpool', sa.Column('date', sa.Date(), nullable=False))
op.add_column('carpool', sa.Column('time', sa.DateTime(), nullable=False))
op.drop_column('carpool', 'hour')
op.drop_column('carpool', 'when')
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table(
'enterprise', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('name', sa.String(length=64), nullable=False),
sa.Column('address', sa.String(length=256), nullable=False),
sa.Column('nip_number', sa.String(length=10), nullable=False),
sa.PrimaryKeyConstraint('id'))
op.create_table(
'user', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('username', sa.String(length=255), nullable=False),
sa.Column('email', sa.String(length=255), nullable=False),
sa.Column('hashed_password', sa.String(length=255), nullable=False),
sa.PrimaryKeyConstraint('id'))
op.create_index(op.f('ix_user_email'), 'user', ['email'], unique=True)
op.create_index(op.f('ix_user_username'),
'user', ['username'],
unique=False)
op.create_table(
'tradingpartner', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('nip_number', sa.String(length=10), nullable=False),
sa.Column('name', sa.String(length=255), nullable=False),
sa.Column('address', sa.Text(), nullable=False),
sa.Column('enterprise_id', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(
['enterprise_id'], ['enterprise.id'],
name='fk_tradingpartner_enterprise_id_enterprise_id'),
sa.PrimaryKeyConstraint('id'))
op.create_table(
'userenterprise', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('enterprise_id', sa.Integer(), nullable=True),
sa.Column('user_id', sa.Integer(), nullable=True),
sa.Column('role', sa.String(length=10), nullable=False),
sa.ForeignKeyConstraint(
['enterprise_id'], ['enterprise.id'],
name='fk_userenterprise_enterprise_id_enterprise_id'),
sa.ForeignKeyConstraint(['user_id'], ['user.id'],
name='fk_userenterprise_user_id_user_id'),
sa.PrimaryKeyConstraint('id'))
op.create_table(
'vatrate', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('vat_rate', sa.Float(), nullable=False),
sa.Column('comment', sa.String(length=255), nullable=False),
sa.Column('enterprise_id', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(['enterprise_id'], ['enterprise.id'],
name='fk_vatrate_enterprise_id_enterprise_id'),
sa.PrimaryKeyConstraint('id'))
op.create_table(
'invoice', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('invoice_business_id', sa.String(length=64), nullable=False),
sa.Column('invoice_date', sa.Date(), nullable=False),
sa.Column('invoice_type', sa.String(length=8), nullable=False),
sa.Column('trading_partner_id', sa.Integer(), nullable=True),
sa.Column('enterprise_id', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(['enterprise_id'], ['enterprise.id'],
name='fk_invoice_enterprise_id_enterprise_id'),
sa.ForeignKeyConstraint(
['trading_partner_id'], ['tradingpartner.id'],
name='fk_invoice_tradingpartner_id_trading_partner_id'),
sa.PrimaryKeyConstraint('id'))
op.create_table(
'invoiceposition', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('name', sa.String(length=50), nullable=False),
sa.Column('vat_rate_id', sa.Integer(), nullable=True),
sa.Column('num_items', sa.Float(), nullable=False),
sa.Column('price_net', sa.Float(), nullable=False),
sa.Column('invoice_id', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(
['invoice_id'], ['invoice.id'],
name='fk_invoiceposition_invoice_id_invoice_id'),
sa.ForeignKeyConstraint(
['vat_rate_id'], ['vatrate.id'],
name='fk_invoiceposition_vatrate_id_vat_rate_id'),
sa.PrimaryKeyConstraint('id'))
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('td_log',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('log_time', sa.DateTime(), nullable=True),
sa.Column('account', sa.String(length=128), nullable=True),
sa.Column('res_id', sa.String(length=128), nullable=True),
sa.Column('res_path', sa.String(length=128), nullable=True),
sa.Column('sys_res_id', sa.String(length=128), nullable=True),
sa.Column('sys_res_name', sa.String(length=128), nullable=True),
sa.Column('sys_res_path', sa.String(length=128), nullable=True),
sa.Column('page_res_id', sa.String(length=128), nullable=True),
sa.Column('page_res_name', sa.String(length=128), nullable=True),
sa.Column('page_res_path', sa.String(length=128), nullable=True),
sa.Column('func_res_id', sa.String(length=128), nullable=True),
sa.Column('func_res_name', sa.String(length=128), nullable=True),
sa.Column('func_res_path', sa.String(length=128), nullable=True),
sa.Column('params', sa.String(length=128), nullable=True),
sa.Column('log_date', sa.Date(), nullable=True),
sa.PrimaryKeyConstraint('id'),
schema='sys'
)
op.create_table('td_menu',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('menu_id', sa.String(length=128), nullable=True),
sa.Column('menu_name', sa.String(length=128), nullable=True),
sa.Column('menu_res_path', sa.String(length=128), nullable=True),
sa.Column('p_menu_id', sa.String(length=128), nullable=True),
sa.Column('sys_res_id', sa.String(length=128), nullable=True),
sa.Column('sys_res_name', sa.String(length=128), nullable=True),
sa.Column('sys_res_path', sa.String(length=128), nullable=True),
sa.Column('page_res_id', sa.String(length=128), nullable=True),
sa.Column('page_res_name', sa.String(length=128), nullable=True),
sa.Column('page_res_path', sa.String(length=128), nullable=True),
sa.Column('sort_id', sa.Integer(), nullable=True),
sa.Column('icon', sa.String(length=128), nullable=True),
sa.Column('deleted', sa.Integer(), nullable=True),
sa.PrimaryKeyConstraint('id'),
schema='sys'
)
op.create_table('td_res',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('res_id', sa.String(length=128), nullable=True),
sa.Column('res_name', sa.String(length=128), nullable=True),
sa.Column('func_name', sa.String(length=128), nullable=True),
sa.Column('res_flag', sa.String(length=128), nullable=True),
sa.Column('res_path', sa.String(length=128), nullable=True),
sa.Column('res_type_id', sa.Integer(), nullable=True),
sa.Column('res_type', sa.String(length=128), nullable=True),
sa.Column('p_res_id', sa.String(length=128), nullable=True),
sa.Column('p_res_name', sa.String(length=128), nullable=True),
sa.Column('api_url', sa.String(length=128), nullable=True),
sa.Column('sys_res_id', sa.String(length=128), nullable=True),
sa.Column('sys_res_name', sa.String(length=128), nullable=True),
sa.Column('sys_name', sa.String(length=128), nullable=True),
sa.Column('sys_flag', sa.String(length=128), nullable=True),
sa.Column('deleted', sa.Integer(), nullable=True),
sa.Column('update_time', sa.DateTime(), nullable=True),
sa.Column('updater', sa.String(length=128), nullable=True),
sa.Column('create_time', sa.DateTime(), nullable=True),
sa.Column('creater', sa.String(length=128), nullable=True),
sa.Column('data_access_level', sa.Integer(), nullable=True),
sa.PrimaryKeyConstraint('id'),
schema='sys'
)
op.create_table('td_res_type',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('res_type', sa.String(length=128), nullable=True),
sa.Column('deleted', sa.Integer(), nullable=True),
sa.PrimaryKeyConstraint('id'),
sa.UniqueConstraint('res_type'),
schema='sys'
)
op.create_table('td_role',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('role_id', sa.String(length=128), nullable=True),
sa.Column('role_name', sa.String(length=128), nullable=True),
sa.Column('data_scope', sa.Integer(), nullable=True),
sa.Column('deleted', sa.Integer(), nullable=True),
sa.Column('b_inside', sa.Integer(), nullable=True),
sa.Column('b_super', sa.Integer(), nullable=True),
sa.Column('update_time', sa.DateTime(), nullable=True),
sa.Column('updater', sa.String(length=128), nullable=True),
sa.Column('create_time', sa.DateTime(), nullable=True),
sa.Column('creater', sa.String(length=128), nullable=True),
sa.Column('data_role', sa.String(length=128), nullable=True),
sa.Column('data_access_level', sa.Integer(), nullable=True),
sa.Column('inside_default_open_id', sa.String(length=128), nullable=True),
sa.PrimaryKeyConstraint('id'),
schema='sys'
)
op.create_table('td_role_res',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('role_id', sa.String(length=128), nullable=True),
sa.Column('res_id', sa.String(length=128), nullable=True),
sa.Column('deleted', sa.Integer(), nullable=True),
sa.Column('update_time', sa.DateTime(), nullable=True),
sa.Column('updater', sa.String(length=128), nullable=True),
sa.Column('create_time', sa.DateTime(), nullable=True),
sa.Column('creater', sa.String(length=128), nullable=True),
sa.Column('data_role', sa.String(length=128), nullable=True),
sa.Column('data_access_level', sa.Integer(), nullable=True),
sa.PrimaryKeyConstraint('id'),
schema='sys'
)
op.create_table('td_role_user',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('role_id', sa.String(length=128), nullable=True),
sa.Column('open_id', sa.String(length=128), nullable=True),
sa.Column('deleted', sa.Integer(), nullable=True),
sa.Column('update_time', sa.DateTime(), nullable=True),
sa.Column('updater', sa.String(length=128), nullable=True),
sa.Column('create_time', sa.DateTime(), nullable=True),
sa.Column('creater', sa.String(length=128), nullable=True),
sa.Column('data_role', sa.String(length=128), nullable=True),
sa.Column('data_access_level', sa.Integer(), nullable=True),
sa.PrimaryKeyConstraint('id'),
schema='sys'
)
op.create_table('td_user',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('open_id', sa.String(length=128), nullable=False),
sa.Column('account', sa.String(length=128), nullable=False),
sa.Column('password', sa.String(length=128), nullable=False),
sa.Column('deleted', sa.Integer(), nullable=True),
sa.Column('b_inside', sa.Integer(), nullable=True),
sa.Column('update_time', sa.DateTime(), nullable=True),
sa.Column('updater', sa.String(length=128), nullable=True),
sa.Column('create_time', sa.DateTime(), nullable=True),
sa.Column('creater', sa.String(length=128), nullable=True),
sa.Column('data_role', sa.String(length=128), nullable=True),
sa.Column('data_access_level', sa.Integer(), nullable=True),
sa.Column('inside_default_role_id', sa.String(length=128), nullable=True),
sa.PrimaryKeyConstraint('id'),
schema='sys'
)
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('chat', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('name', sa.String(), nullable=True),
sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('id'))
op.create_table('traveler', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('name', sa.String(), nullable=True),
sa.Column('email', sa.String(), nullable=True),
sa.Column('_password', sa.String(), nullable=True),
sa.Column('language', sa.String(), nullable=True),
sa.Column('age', sa.Integer(), nullable=True),
sa.Column('localization', sa.String(), nullable=True),
sa.Column('bio', sa.Text(), nullable=True),
sa.Column('profile_picture', sa.String(), nullable=True),
sa.Column('is_active', sa.Boolean(), nullable=True),
sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('id'))
op.create_table(
'message', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('chat_id', sa.Integer(), nullable=True),
sa.Column('traveler_id', sa.Integer(), nullable=True),
sa.Column('message', sa.String(), nullable=True),
sa.ForeignKeyConstraint(
['chat_id'],
['chat.id'],
), sa.ForeignKeyConstraint(
['traveler_id'],
['traveler.id'],
), sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('id'))
op.create_table(
'post', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('traveler_id', sa.Integer(), nullable=True),
sa.Column('title', sa.String(), nullable=True),
sa.Column('media', sa.String(), nullable=True),
sa.Column('text', sa.String(), nullable=True),
sa.Column('is_active', sa.Boolean(), nullable=True),
sa.ForeignKeyConstraint(
['traveler_id'],
['traveler.id'],
), sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('id'))
op.create_table(
'trip', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('traveler_id', sa.Integer(), nullable=True),
sa.Column('country', sa.String(), nullable=True),
sa.Column('cities', sa.String(), nullable=True),
sa.Column('start_date', sa.Date(), nullable=False),
sa.Column('end_date', sa.Date(), nullable=False),
sa.Column('activities', sa.String(), nullable=True),
sa.Column('is_active', sa.Boolean(), nullable=True),
sa.ForeignKeyConstraint(
['traveler_id'],
['traveler.id'],
), sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('id'))
op.create_table(
'comments', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('text', sa.String(), nullable=True),
sa.Column('traveler_id', sa.Integer(), nullable=True),
sa.Column('post_id', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(
['post_id'],
['post.id'],
), sa.ForeignKeyConstraint(
['traveler_id'],
['traveler.id'],
), sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('id'))
op.create_table(
'shared_trip', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('trip_id', sa.Integer(), nullable=True),
sa.Column('traveler_id', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(
['traveler_id'],
['traveler.id'],
), sa.ForeignKeyConstraint(
['trip_id'],
['trip.id'],
), sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('id'))
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.alter_column('match',
'date',
existing_type=sa.DateTime(),
type_=sa.Date())
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('clients', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('first_name', sa.String(), nullable=True),
sa.Column('last_name', sa.String(), nullable=True),
sa.Column('address', sa.String(), nullable=True),
sa.Column('zip_code', sa.String(), nullable=True),
sa.Column('city', sa.String(), nullable=True),
sa.Column('email', sa.String(), nullable=False),
sa.Column('phone_number', sa.String(), nullable=True),
sa.Column('is_owner', sa.Boolean(), nullable=True),
sa.PrimaryKeyConstraint('id'),
sa.UniqueConstraint('email'),
sa.UniqueConstraint('first_name', 'last_name', 'email'),
sa.UniqueConstraint('phone_number'))
op.create_table(
'pricings_collective_occasional',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('type', sa.String(length=50), nullable=False),
sa.Column('duration_from', sa.Integer(), nullable=False),
sa.Column('duration_to', sa.Integer(), nullable=True),
sa.Column('valid_from', sa.Date(), nullable=False),
sa.Column('valid_to', sa.Date(), nullable=True),
sa.Column('hourly_price', sa.String(length=8), nullable=False),
sa.PrimaryKeyConstraint('id'))
op.create_table(
'pricings_collective_regular',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('type', sa.String(length=50), nullable=False),
sa.Column('duration_from', sa.Integer(), nullable=False),
sa.Column('duration_to', sa.Integer(), nullable=True),
sa.Column('valid_from', sa.Date(), nullable=False),
sa.Column('valid_to', sa.Date(), nullable=True),
sa.Column('hourly_price', sa.String(length=8), nullable=False),
sa.PrimaryKeyConstraint('id'))
op.create_table(
'pricings_flat_rate', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('type', sa.String(length=50), nullable=False),
sa.Column('valid_from', sa.Date(), nullable=False),
sa.Column('valid_to', sa.Date(), nullable=True),
sa.Column('flat_rate', sa.String(length=8), nullable=False),
sa.Column('prepaid_hours', sa.Integer(), nullable=False),
sa.PrimaryKeyConstraint('id'))
op.create_table(
'pricings_individual_modular',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('type', sa.String(length=50), nullable=False),
sa.Column('duration_from', sa.Integer(), nullable=False),
sa.Column('duration_to', sa.Integer(), nullable=True),
sa.Column('valid_from', sa.Date(), nullable=False),
sa.Column('valid_to', sa.Date(), nullable=True),
sa.Column('hourly_price', sa.String(length=8), nullable=False),
sa.PrimaryKeyConstraint('id'))
op.create_table(
'pricings_recurring', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('type', sa.String(length=50), nullable=False),
sa.Column('duration_from', sa.Integer(), nullable=False),
sa.Column('duration_to', sa.Integer(), nullable=True),
sa.Column('valid_from', sa.Date(), nullable=False),
sa.Column('valid_to', sa.Date(), nullable=True),
sa.Column('monthly_price', sa.String(length=8), nullable=False),
sa.PrimaryKeyConstraint('id'))
op.create_table('rooms', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('name', sa.String(), nullable=True),
sa.Column('individual', sa.Boolean(), nullable=True),
sa.Column('calendar_id', sa.String(), nullable=True),
sa.PrimaryKeyConstraint('id'),
sa.UniqueConstraint('calendar_id'),
sa.UniqueConstraint('name'))
op.create_table(
'contracts', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('type', sa.String(length=50), nullable=False),
sa.Column('client_id', sa.Integer(), nullable=True),
sa.Column('start_date', sa.Date(), nullable=True),
sa.Column('end_date', sa.Date(), nullable=True),
sa.Column('room_type',
sa.Enum('individual', 'collective', name='roomtypeenum'),
nullable=True),
sa.Column('pricing_id', sa.Integer(), nullable=True),
sa.Column('total_hours', sa.String(), nullable=True),
sa.Column('remaining_hours', sa.String(), nullable=True),
sa.ForeignKeyConstraint(
['client_id'],
['clients.id'],
), sa.ForeignKeyConstraint(
['pricing_id'],
['pricings_flat_rate.id'],
), sa.PrimaryKeyConstraint('id'),
sa.UniqueConstraint('client_id', 'start_date', 'room_type'))
op.create_table(
'invoices', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('contract_id', sa.Integer(), nullable=True),
sa.Column('period', sa.String(), nullable=True),
sa.Column('issued_at', sa.Date(), nullable=True),
sa.Column('currency', sa.String(), nullable=True),
sa.ForeignKeyConstraint(
['contract_id'],
['contracts.id'],
), sa.PrimaryKeyConstraint('id'),
sa.UniqueConstraint('contract_id', 'period'))
op.create_table('daily_bookings',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('client_id', sa.Integer(), nullable=True),
sa.Column('invoice_id', sa.Integer(), nullable=True),
sa.Column('date', sa.Date(), nullable=True),
sa.Column('duration_hours', sa.String(), nullable=True),
sa.Column('price', sa.String(), nullable=True),
sa.Column('individual', sa.Boolean(), nullable=True),
sa.Column('frozen', sa.Boolean(), nullable=True),
sa.ForeignKeyConstraint(
['client_id'],
['clients.id'],
),
sa.ForeignKeyConstraint(
['invoice_id'],
['invoices.id'],
), sa.PrimaryKeyConstraint('id'),
sa.UniqueConstraint('client_id', 'date', 'individual'))
