def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.create_table('polygonpoint', sa.Column('pgp_id', mysql.INTEGER(display_width=11), autoincrement=True, nullable=False), sa.Column('latitude', mysql.FLOAT(), nullable=True), sa.Column('longitude', mysql.FLOAT(), nullable=True), sa.Column('polygon_id', mysql.INTEGER(display_width=11), autoincrement=False, nullable=True), sa.ForeignKeyConstraint(['polygon_id'], ['polygon.poly_id'], name='polygonpoint_ibfk_1'), sa.PrimaryKeyConstraint('pgp_id'), mysql_default_charset='utf8mb4', mysql_engine='InnoDB') op.create_table('polygon', sa.Column('poly_id', mysql.INTEGER(display_width=11), autoincrement=True, nullable=False), sa.Column('fill_color', mysql.VARCHAR(length=10), nullable=True), sa.Column('gtw_id', mysql.VARCHAR(length=80), nullable=True), sa.ForeignKeyConstraint(['gtw_id'], ['gateway.gtw_id'], name='polygon_ibfk_1'), sa.PrimaryKeyConstraint('poly_id'), mysql_default_charset='utf8mb4', mysql_engine='InnoDB')
def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.create_table('user', sa.Column('id', mysql.INTEGER(display_width=11), autoincrement=True, nullable=False), sa.Column('name', mysql.VARCHAR(length=50), nullable=True), sa.Column('admin', mysql.TINYINT(display_width=1), autoincrement=False, nullable=True), sa.Column('email', mysql.VARCHAR(length=50), nullable=False), sa.Column('email_verified', mysql.TINYINT(display_width=1), autoincrement=False, nullable=True), sa.Column('account_status', mysql.VARCHAR(length=20), nullable=True), sa.Column('password_hash', mysql.VARCHAR(length=255), nullable=True), sa.Column('password', mysql.VARCHAR(length=50), nullable=False), sa.Column('register_source', mysql.VARCHAR(length=50), nullable=True), sa.Column('register_datetime', mysql.FLOAT(), nullable=True), sa.Column('service_starttime', mysql.FLOAT(), nullable=True), sa.Column('service_endtime', mysql.FLOAT(), nullable=True), sa.Column('token', mysql.VARCHAR(length=255), nullable=True), sa.Column('usergroup_id', mysql.INTEGER(display_width=11), autoincrement=False, nullable=True), sa.Column('thunderservice_id', mysql.INTEGER(display_width=11), autoincrement=False, nullable=True), sa.Column('last_login_datetime', mysql.FLOAT(), nullable=True), sa.Column('last_login_ipaddress', mysql.VARCHAR(length=50), nullable=True), sa.Column('mentor', mysql.INTEGER(display_width=11), autoincrement=False, nullable=True), sa.Column('individual_coupon', mysql.VARCHAR(length=50), nullable=True), sa.Column('affiliate', mysql.TINYINT(display_width=1), autoincrement=False, nullable=True), sa.PrimaryKeyConstraint('id'), mysql_default_charset='utf8', mysql_engine='InnoDB' ) op.create_index('email', 'user', ['email'], unique=True) op.drop_table('users')
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.create_table('services', sa.Column('id', mysql.INTEGER(display_width=11, unsigned=True), autoincrement=True, nullable=False), sa.Column('created_at', mysql.TIMESTAMP(), server_default=sa.text('CURRENT_TIMESTAMP'), nullable=False), sa.Column('updated_at', mysql.TIMESTAMP(), server_default=sa.text('CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP'), nullable=False), sa.Column('name', mysql.VARCHAR(length=255), nullable=False), sa.PrimaryKeyConstraint('id'), mysql_charset='utf8mb4', mysql_collate='utf8mb4_unicode_ci', mysql_engine='InnoDB' ) op.create_table('users', sa.Column('id', mysql.INTEGER(display_width=11, unsigned=True), autoincrement=True, nullable=False), sa.Column('created_at', mysql.TIMESTAMP(), server_default=sa.text('CURRENT_TIMESTAMP'), nullable=False), sa.Column('updated_at', mysql.TIMESTAMP(), server_default=sa.text('CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP'), nullable=False), sa.Column('user_name', mysql.VARCHAR(length=255), nullable=False), sa.Column('password', mysql.VARCHAR(length=255), nullable=False), sa.Column('first_name', mysql.VARCHAR(length=255), nullable=True), sa.Column('last_name', mysql.VARCHAR(length=255), nullable=True), sa.Column('birthday', mysql.VARCHAR(length=255), nullable=True), sa.Column('phone', mysql.VARCHAR(length=255), nullable=False), sa.Column('address', mysql.VARCHAR(length=255), nullable=False), sa.Column('longitude', mysql.FLOAT(), nullable=True), sa.Column('latitude', mysql.FLOAT(), nullable=True), sa.Column('language', mysql.VARCHAR(length=255), nullable=False), sa.Column('is_guide', sa.BOOLEAN(), nullable=False), sa.PrimaryKeyConstraint('id'), mysql_charset='utf8mb4', mysql_collate='utf8mb4_unicode_ci', mysql_engine='InnoDB' )
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.create_table('blacklist_tokens', sa.Column('id', sa.Integer(), autoincrement=True, nullable=False), sa.Column('token', sa.String(length=500), nullable=False), sa.Column('blacklisted_on', sa.DateTime(), nullable=True), sa.PrimaryKeyConstraint('id') ) op.create_index(op.f('ix_blacklist_tokens_token'), 'blacklist_tokens', ['token'], unique=True) op.create_table('movies', sa.Column('id', models.GUID(length=32), nullable=False), sa.Column('name', sa.String(length=80), nullable=False), sa.Column('director', sa.String(length=80), nullable=False), sa.Column('popularity', mysql.FLOAT(precision=10, scale=1), nullable=True), sa.Column('genre', sa.Text(), nullable=False), sa.Column('imdb_score', mysql.FLOAT(precision=10, scale=1), nullable=True), sa.Column('views', sa.Integer(), nullable=True), sa.Column('created_by', models.GUID(length=32), nullable=True), sa.Column('updated_by', models.GUID(length=32), nullable=True), sa.Column('created_at', sa.DateTime(), nullable=True), sa.Column('updated_at', sa.DateTime(), nullable=True), sa.ForeignKeyConstraint(['created_by'], ['admin_users.id'], ), sa.ForeignKeyConstraint(['updated_by'], ['admin_users.id'], ), sa.PrimaryKeyConstraint('id') ) op.create_index(op.f('ix_movies_director'), 'movies', ['director'], unique=False) op.create_index(op.f('ix_movies_name'), 'movies', ['name'], unique=False)
def upgrade(): op.create_table('etablissements', sa.Column('siret', mysql.VARCHAR(collation='utf8mb4_unicode_ci', length=191), nullable=False), sa.Column('raisonsociale', mysql.VARCHAR(collation='utf8mb4_unicode_ci', length=191), nullable=True), sa.Column('enseigne', mysql.VARCHAR(collation='utf8mb4_unicode_ci', length=191), nullable=True), sa.Column('codenaf', mysql.VARCHAR(collation='utf8mb4_unicode_ci', length=191), nullable=True), sa.Column('trancheeffectif', mysql.VARCHAR(collation='utf8mb4_unicode_ci', length=191), nullable=True), sa.Column('numerorue', mysql.VARCHAR(collation='utf8mb4_unicode_ci', length=191), nullable=True), sa.Column('libellerue', mysql.VARCHAR(collation='utf8mb4_unicode_ci', length=191), nullable=True), sa.Column('codepostal', mysql.VARCHAR(collation='utf8mb4_unicode_ci', length=11), nullable=True), sa.Column('tel', mysql.VARCHAR(collation='utf8mb4_unicode_ci', length=191), nullable=True), sa.Column('email', mysql.VARCHAR(collation='utf8mb4_unicode_ci', length=191), nullable=True), sa.Column('website', mysql.VARCHAR(collation='utf8mb4_unicode_ci', length=191), nullable=True), sa.Column('flag_alternance', mysql.TINYINT(display_width=1), autoincrement=False, nullable=False), sa.Column('flag_junior', mysql.TINYINT(display_width=1), autoincrement=False, nullable=False), sa.Column('flag_senior', mysql.TINYINT(display_width=1), autoincrement=False, nullable=False), sa.Column('flag_handicap', mysql.TINYINT(display_width=1), autoincrement=False, nullable=False), sa.Column('has_multi_geolocations', mysql.TINYINT(display_width=1), autoincrement=False, nullable=False), sa.Column('codecommune', mysql.VARCHAR(collation='utf8mb4_unicode_ci', length=191), nullable=True), sa.Column('coordinates_x', mysql.FLOAT(), nullable=True), sa.Column('coordinates_y', mysql.FLOAT(), nullable=True), sa.Column('departement', mysql.VARCHAR(collation='utf8mb4_unicode_ci', length=11), nullable=True), sa.Column('score', mysql.INTEGER(display_width=11), autoincrement=False, nullable=True), sa.PrimaryKeyConstraint('siret'), mysql_collate='utf8mb4_unicode_ci', mysql_default_charset='utf8mb4', mysql_engine='InnoDB' )
def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.add_column( 'restaurant_info', sa.Column('lat', mysql.FLOAT(precision=16, scale=16), nullable=True)) op.add_column( 'restaurant_info', sa.Column('lon', mysql.FLOAT(precision=16, scale=16), nullable=True))
def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.alter_column('Supplizer', 'SUname', existing_type=mysql.VARCHAR(length=16), nullable=False) op.create_table('magic_box_join', sa.Column('isdelete', mysql.TINYINT(display_width=1), autoincrement=False, nullable=True), sa.Column('createtime', mysql.DATETIME(), nullable=True), sa.Column('updatetime', mysql.DATETIME(), nullable=True), sa.Column('MBJid', mysql.VARCHAR(length=64), nullable=False), sa.Column('USid', mysql.VARCHAR(length=64), nullable=False), sa.Column('MABid', mysql.VARCHAR(length=64), nullable=False), sa.Column('MBJprice', mysql.FLOAT(), nullable=False), sa.PrimaryKeyConstraint('MBJid'), mysql_default_charset='utf8', mysql_engine='InnoDB') op.create_table('magix_box_open', sa.Column('isdelete', mysql.TINYINT(display_width=1), autoincrement=False, nullable=True), sa.Column('createtime', mysql.DATETIME(), nullable=True), sa.Column('updatetime', mysql.DATETIME(), nullable=True), sa.Column('MBOid', mysql.VARCHAR(length=64), nullable=False), sa.Column('USid', mysql.VARCHAR(length=64), nullable=False), sa.Column('MBJid', mysql.VARCHAR(length=64), nullable=False), sa.Column('MBOgear', mysql.INTEGER(display_width=11), autoincrement=False, nullable=False), sa.Column('MBOresult', mysql.FLOAT(), nullable=False), sa.Column('MBOprice', mysql.FLOAT(), nullable=False), sa.Column('MBOhasShare', mysql.TINYINT(display_width=1), autoincrement=False, nullable=True), sa.PrimaryKeyConstraint('MBOid'), mysql_default_charset='utf8', mysql_engine='InnoDB') op.drop_table('UserSalesvolume') op.drop_table('UserInvitation') op.drop_table('MagixBoxOpen') op.drop_table('MagicBoxJoin') op.drop_table('FreshManFirst')
def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.create_index('user_id_UNIQUE', 'vote', ['user_id'], unique=True) op.create_index('event_id_UNIQUE', 'vote', ['event_id'], unique=True) op.add_column('event', sa.Column('longitude', mysql.FLOAT(), nullable=True)) op.add_column('event', sa.Column('latitude', mysql.FLOAT(), nullable=True)) op.drop_column('event', 'long') op.drop_column('event', 'lat')
def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.add_column( 'business', sa.Column('current_process_used_time', mysql.FLOAT(), nullable=True)) op.add_column('business', sa.Column('used_time', mysql.FLOAT(), nullable=True)) op.drop_column('business', 'takan_used_time') op.drop_column('business', 'current_process_start_time')
def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.add_column('DiskReadProfile', sa.Column('format', mysql.VARCHAR(length=20), nullable=True)) op.add_column('DiskReadProfile', sa.Column('seq_read_ms', mysql.FLOAT(), nullable=True)) op.add_column('DiskReadProfile', sa.Column('rand_read_ms', mysql.FLOAT(), nullable=True)) op.drop_column('DiskReadProfile', 'disk')
def upgrade(): op.create_table( 'perf_importer_cycle_infos', sa.Column('id', mysql.BIGINT(display_width=20), autoincrement=True, nullable=False), sa.Column('execution_date', mysql.DATETIME(), nullable=True), sa.Column('prediction_start_date', mysql.DATETIME(), nullable=True), sa.Column('prediction_end_date', mysql.DATETIME(), nullable=True), sa.Column('file_name', mysql.TEXT(collation='utf8mb4_unicode_ci'), nullable=True), sa.Column('computed', mysql.TINYINT(display_width=1), autoincrement=False, nullable=True), sa.Column('on_google_sheets', mysql.TINYINT(display_width=1), autoincrement=False, nullable=True), sa.PrimaryKeyConstraint('id'), mysql_collate='utf8mb4_unicode_ci', mysql_default_charset='utf8mb4', mysql_engine='InnoDB' ) op.create_table( 'perf_division_per_rome', sa.Column('id', mysql.BIGINT(display_width=20), autoincrement=True, nullable=False), sa.Column('importer_cycle_infos_id', mysql.BIGINT(display_width=20), autoincrement=False, nullable=True), sa.Column('codenaf', mysql.VARCHAR(collation='utf8mb4_unicode_ci', length=8), nullable=False), sa.Column('coderome', mysql.VARCHAR(collation='utf8mb4_unicode_ci', length=8), nullable=False), sa.Column('threshold_lbb', mysql.FLOAT(), nullable=True), sa.Column('threshold_lba', mysql.FLOAT(), nullable=True), sa.Column('nb_bonne_boites_lbb', mysql.INTEGER(display_width=11), autoincrement=False, nullable=True), sa.Column('nb_bonne_boites_lba', mysql.INTEGER(display_width=11), autoincrement=False, nullable=True), sa.ForeignKeyConstraint(['importer_cycle_infos_id'], ['perf_importer_cycle_infos.id'], name='perf_division_per_rome_ibfk_1', ondelete='SET NULL'), sa.PrimaryKeyConstraint('id'), mysql_collate='utf8mb4_unicode_ci', mysql_default_charset='utf8mb4', mysql_engine='InnoDB' ) op.create_table( 'perf_prediction_and_effective_hirings', sa.Column('id', mysql.BIGINT(display_width=20), autoincrement=True, nullable=False), sa.Column('importer_cycle_infos_id', mysql.BIGINT(display_width=20), autoincrement=False, nullable=True), sa.Column('siret', mysql.VARCHAR(collation='utf8mb4_unicode_ci', length=191), nullable=True), sa.Column('codenaf', mysql.VARCHAR(collation='utf8mb4_unicode_ci', length=8), nullable=True), sa.Column('codecommune', mysql.VARCHAR(collation='utf8mb4_unicode_ci', length=191), nullable=True), sa.Column('codepostal', mysql.VARCHAR(collation='utf8mb4_unicode_ci', length=8), nullable=True), sa.Column('departement', mysql.VARCHAR(collation='utf8mb4_unicode_ci', length=8), nullable=True), sa.Column('raisonsociale', mysql.VARCHAR(collation='utf8mb4_unicode_ci', length=191), nullable=True), sa.Column('enseigne', mysql.VARCHAR(collation='utf8mb4_unicode_ci', length=191), nullable=True), sa.Column('lbb_nb_predicted_hirings', mysql.INTEGER(display_width=11), autoincrement=False, nullable=True), sa.Column('lba_nb_predicted_hirings', mysql.INTEGER(display_width=11), autoincrement=False, nullable=True), sa.Column('lbb_nb_predicted_hirings_score', mysql.INTEGER(display_width=11), autoincrement=False, nullable=True), sa.Column('lba_nb_predicted_hirings_score', mysql.INTEGER(display_width=11), autoincrement=False, nullable=True), sa.Column('lbb_nb_effective_hirings', mysql.INTEGER(display_width=11), autoincrement=False, nullable=True), sa.Column('lba_nb_effective_hirings', mysql.INTEGER(display_width=11), autoincrement=False, nullable=True), sa.Column('is_a_bonne_boite', mysql.TINYINT(display_width=1), autoincrement=False, nullable=True), sa.Column('is_a_bonne_alternance', mysql.TINYINT(display_width=1), autoincrement=False, nullable=True), sa.ForeignKeyConstraint(['importer_cycle_infos_id'], ['perf_importer_cycle_infos.id'], name='perf_prediction_and_effective_hirings_ibfk_1', ondelete='SET NULL'), sa.PrimaryKeyConstraint('id'), mysql_collate='utf8mb4_unicode_ci', mysql_default_charset='utf8mb4', mysql_engine='InnoDB' )
def downgrade(): ### commands auto generated by Alembic - please adjust! ### op.alter_column('roundup_donation', 'total_amount', existing_type=sa.Integer(), type_=mysql.FLOAT(), existing_nullable=False) op.alter_column('roundup_donation', 'base_donation_amt', existing_type=sa.Integer(), type_=mysql.FLOAT(), existing_nullable=False)
def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.add_column('users', sa.Column('sticky_lon', mysql.FLOAT(), nullable=True)) op.add_column('users', sa.Column('sticky_lat', mysql.FLOAT(), nullable=True)) op.drop_column('survey_responses', 'lon') op.drop_column('survey_responses', 'lat')
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.alter_column('event', 'lat', existing_type=mysql.FLOAT(), type_=sa.Numeric(precision=11, scale=8), existing_nullable=True) op.alter_column('event', 'long', existing_type=mysql.FLOAT(), type_=sa.Numeric(precision=11, scale=8), existing_nullable=True)
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.alter_column('question', 'points_correct', existing_type=mysql.FLOAT(display_width=11), nullable=False, default=0) op.alter_column('question', 'points_wrong', existing_type=mysql.FLOAT(display_width=11), nullable=False, default=0)
def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.alter_column('message', 'longitude', existing_type=sa.String(length=64), type_=mysql.FLOAT(), existing_nullable=True) op.alter_column('message', 'latitude', existing_type=sa.String(length=64), type_=mysql.FLOAT(), existing_nullable=True)
def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.add_column( u'onchain_task', sa.Column('method_name', mysql.VARCHAR(length=255), nullable=True)) op.drop_column(u'onchain_task', 'contract_method') op.add_column( u'match', sa.Column('source', mysql.VARCHAR(length=256), nullable=True)) op.drop_constraint(None, 'match', type_='foreignkey') op.drop_constraint(None, 'match', type_='foreignkey') op.drop_column(u'match', 'source_id') op.drop_column(u'match', 'category_id') op.create_table('history', sa.Column('id', mysql.INTEGER(display_width=11), nullable=False), sa.Column('date_created', mysql.DATETIME(), nullable=True), sa.Column('date_modified', mysql.DATETIME(), nullable=True), sa.Column('deleted', mysql.INTEGER(display_width=11), autoincrement=False, nullable=True), sa.Column('shaker_id', mysql.INTEGER(display_width=11), autoincrement=False, nullable=True), sa.Column('handshake_id', mysql.INTEGER(display_width=11), autoincrement=False, nullable=True), sa.Column('maker_amount', mysql.FLOAT(), nullable=True), sa.Column('maker_odds', mysql.FLOAT(), nullable=True), sa.Column('shaker_amount', mysql.FLOAT(), nullable=True), sa.Column('shaker_odds', mysql.FLOAT(), nullable=True), sa.Column('modified_user_id', mysql.INTEGER(display_width=11), autoincrement=False, nullable=True), sa.Column('created_user_id', mysql.INTEGER(display_width=11), autoincrement=False, nullable=True), sa.ForeignKeyConstraint(['created_user_id'], [u'user.id'], name=u'history_ibfk_1'), sa.ForeignKeyConstraint(['modified_user_id'], [u'user.id'], name=u'history_ibfk_2'), sa.PrimaryKeyConstraint('id'), mysql_default_charset=u'utf8', mysql_engine=u'InnoDB') op.drop_table('source') op.drop_table('category')