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