def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.create_table( 'timetable', sa.Column('timetable_id', sa.BIGINT(), autoincrement=True, nullable=False), sa.Column('week_day', postgresql.ENUM('Понедельник', 'Вторник', 'Среда', 'Четверг', 'Пятница', 'Суббота', 'Воскресенье', name='enum'), autoincrement=False, nullable=True), sa.Column('time_from', postgresql.TIME(), autoincrement=False, nullable=True), sa.Column('time_to', postgresql.TIME(), autoincrement=False, nullable=True), sa.PrimaryKeyConstraint('timetable_id', name='timetable_pkey'))
def upgrade(): ### commands auto generated by Alembic - please adjust! ### op.add_column('line', sa.Column('closing_time', postgresql.TIME(), nullable=True), schema='navitia') op.add_column('line', sa.Column('opening_time', postgresql.TIME(), nullable=True), schema='navitia')
def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.add_column( 'Artist', sa.Column('artist_date_begin', postgresql.TIME(), autoincrement=False, nullable=True)) op.add_column( 'Artist', sa.Column('artist_date_end', postgresql.TIME(), autoincrement=False, nullable=True))
def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.add_column( 'artist_available_times', sa.Column('available_time_to', postgresql.TIME(), autoincrement=False, nullable=False)) op.add_column( 'artist_available_times', sa.Column('available_time_from', postgresql.TIME(), autoincrement=False, nullable=False)) op.drop_column('artist_available_times', 'time_to') op.drop_column('artist_available_times', 'time_from')
def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.alter_column('users', 'reminder_time', existing_type=sa.String(), type_=postgresql.TIME(), existing_nullable=True)
def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.add_column( 'album', sa.Column('duration', postgresql.TIME(), autoincrement=False, nullable=False))
def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.drop_column('venue', 'seeking_talent') op.drop_column('venue', 'seeking_description') op.add_column('show', sa.Column('time', postgresql.TIME(), autoincrement=False, nullable=False)) op.drop_column('artist', 'website') op.drop_column('artist', 'seeking_venue') op.drop_column('artist', 'seeking_description')
def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.add_column( 'historico', sa.Column('hora', postgresql.TIME(), autoincrement=False, nullable=True)) op.drop_column('historico', 'data_pesquisa')
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.add_column('movie', sa.Column('close_date', sa.Date(), nullable=True)) op.drop_column('movie', 'availability') op.alter_column('seance', 'date', existing_type=sa.DATE(), nullable=False) op.alter_column('seance', 'time', existing_type=postgresql.TIME(), nullable=False)
def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.add_column( 'activity', sa.Column('time', postgresql.TIME(), autoincrement=False, nullable=False)) op.drop_column('activity', 'lapse')
def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.alter_column('labs', 'recvTime', existing_type=postgresql.TIME(), nullable=True) op.alter_column('labs', 'recvDate', existing_type=sa.DATE(), nullable=True) op.drop_column('labs', 'reportTime') op.drop_column('labs', 'reportDate')
def downgrade(): ### commands auto generated by Alembic - please adjust! ### op.add_column( 'results', sa.Column('time', postgresql.TIME(), autoincrement=False, nullable=True)) op.add_column( 'messages', sa.Column('time', postgresql.TIME(), autoincrement=False, nullable=True)) op.add_column( 'messages', sa.Column('date', sa.DATE(), autoincrement=False, nullable=True)) op.drop_column('messages', 'datetime')
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.alter_column('request', 'table_number', existing_type=sa.TEXT(), nullable=False) op.alter_column('request', 'time', existing_type=postgresql.TIME(), nullable=False) op.create_unique_constraint(None, 'request', ['table_number'])
def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.drop_constraint(None, 'request', type_='unique') op.alter_column('request', 'time', existing_type=postgresql.TIME(), nullable=True) op.alter_column('request', 'table_number', existing_type=sa.TEXT(), nullable=True)
def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.add_column('Show', sa.Column('time', postgresql.TIME(), autoincrement=False, nullable=False)) op.add_column('Show', sa.Column('date', sa.DATE(), autoincrement=False, nullable=False)) op.alter_column('Show', 'day', existing_type=sa.VARCHAR(length=10), nullable=False) op.alter_column('Show', 'am', existing_type=sa.BOOLEAN(), nullable=False) op.drop_column('Show', 'start_time')
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.add_column('labs', sa.Column('reportDate', sa.Date(), nullable=True)) op.add_column('labs', sa.Column('reportTime', sa.Time(), nullable=True)) op.alter_column('labs', 'recvDate', existing_type=sa.DATE(), nullable=False) op.alter_column('labs', 'recvTime', existing_type=postgresql.TIME(), nullable=False)
def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.alter_column('users', 'username', existing_type=sa.VARCHAR(length=250), nullable=True) op.alter_column('users', 'password', existing_type=sa.VARCHAR(length=250), nullable=True) op.alter_column('users', 'last_name', existing_type=sa.VARCHAR(length=250), nullable=True) op.alter_column('users', 'first_name', existing_type=sa.VARCHAR(length=150), nullable=True) op.alter_column('users', 'email', existing_type=sa.VARCHAR(length=100), nullable=True) op.alter_column('events', 'user_id', existing_type=sa.INTEGER(), nullable=True) op.alter_column('events', 'start_time', existing_type=postgresql.TIME(), nullable=True) op.alter_column('events', 'name', existing_type=sa.VARCHAR(length=255), nullable=True) op.alter_column('events', 'end_time', existing_type=postgresql.TIME(), nullable=True) op.alter_column('events', 'day', existing_type=sa.DATE(), nullable=True)
def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.add_column( 'tables', sa.Column('number', sa.INTEGER(), autoincrement=False, nullable=True)) op.add_column( 'booking', sa.Column('period', sa.INTEGER(), autoincrement=False, nullable=True)) op.add_column( 'booking', sa.Column('time', postgresql.TIME(), autoincrement=False, nullable=True)) op.drop_column('booking', 'time_to') op.drop_column('booking', 'time_from')
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.create_table( 'securities', sa.Column('securityid', sa.Integer(), nullable=False), sa.Column('securitytype', sa.String(length=30), nullable=True), sa.Column('securityname', sa.String(length=30), nullable=True), sa.Column('initialprice', sa.Float(), nullable=True), sa.Column('currentprice', sa.Float(), nullable=True), sa.PrimaryKeyConstraint('securityid')) op.alter_column('trades', 'brokername', existing_type=sa.VARCHAR(length=10), nullable=True) op.alter_column('trades', 'price', existing_type=sa.REAL(), nullable=True) op.alter_column('trades', 'quantity', existing_type=sa.INTEGER(), nullable=True) op.alter_column('trades', 'security', existing_type=sa.VARCHAR(length=15), nullable=True) op.alter_column('trades', 'securitytype', existing_type=sa.VARCHAR(length=15), nullable=True) op.alter_column('trades', 'tradeby', existing_type=sa.VARCHAR(length=10), nullable=True) op.alter_column('trades', 'tradedate', existing_type=sa.DATE(), nullable=True) op.alter_column('trades', 'tradetime', existing_type=postgresql.TIME(), nullable=True) op.alter_column('trades', 'tradetype', existing_type=sa.VARCHAR(length=5), nullable=True)
def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.add_column( 'pitch', sa.Column('owner_id', sa.INTEGER(), autoincrement=False, nullable=False)) op.drop_constraint(None, 'pitch', type_='foreignkey') op.create_foreign_key('pitch_owner_id_fkey', 'pitch', 'users', ['owner_id'], ['id']) op.drop_column('pitch', 'user_id') op.create_table( 'reviews', sa.Column('id', sa.INTEGER(), autoincrement=True, nullable=False), sa.Column('movie_id', sa.INTEGER(), autoincrement=False, nullable=True), sa.Column('movie_title', sa.VARCHAR(), autoincrement=False, nullable=True), sa.Column('image_path', sa.VARCHAR(), autoincrement=False, nullable=True), sa.Column('movie_review', sa.VARCHAR(), autoincrement=False, nullable=True), sa.Column('posted', postgresql.TIME(), autoincrement=False, nullable=True), sa.Column('user_id', sa.INTEGER(), autoincrement=False, nullable=True), sa.ForeignKeyConstraint(['user_id'], ['users.id'], name='reviews_user_id_fkey'), sa.PrimaryKeyConstraint('id', name='reviews_pkey'))
def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.create_table( 'ventas', sa.Column('idproducto', sa.INTEGER(), autoincrement=True, nullable=False), sa.Column('descripcion', sa.VARCHAR(length=100), autoincrement=False, nullable=True), sa.Column('precio', sa.REAL(), autoincrement=False, nullable=True), sa.Column('cantidad', sa.SMALLINT(), autoincrement=False, nullable=True), sa.Column('fechaventa', postgresql.TIME(precision=0), autoincrement=False, nullable=True)) op.create_table( 'inventario', sa.Column('idproducto', sa.INTEGER(), autoincrement=True, nullable=False), sa.Column('producto', sa.VARCHAR(length=50), autoincrement=False, nullable=True), sa.Column('precio', sa.REAL(), autoincrement=False, nullable=True), sa.Column('cantidad', sa.SMALLINT(), autoincrement=False, nullable=True)) op.drop_table('cars')
def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.alter_column('trades', 'tradetype', existing_type=sa.VARCHAR(length=5), nullable=False) op.alter_column('trades', 'tradetime', existing_type=postgresql.TIME(), nullable=False) op.alter_column('trades', 'tradedate', existing_type=sa.DATE(), nullable=False) op.alter_column('trades', 'tradeby', existing_type=sa.VARCHAR(length=10), nullable=False) op.alter_column('trades', 'securitytype', existing_type=sa.VARCHAR(length=15), nullable=False) op.alter_column('trades', 'security', existing_type=sa.VARCHAR(length=15), nullable=False) op.alter_column('trades', 'quantity', existing_type=sa.INTEGER(), nullable=False) op.alter_column('trades', 'price', existing_type=sa.REAL(), nullable=False) op.alter_column('trades', 'brokername', existing_type=sa.VARCHAR(length=10), nullable=False) op.drop_table('securities')
def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.create_table('related_persons', sa.Column('id', sa.INTEGER(), nullable=False), sa.Column('case_number', sa.VARCHAR(), autoincrement=False, nullable=True), sa.Column('name', sa.VARCHAR(), autoincrement=False, nullable=True), sa.Column('connection', sa.VARCHAR(), autoincrement=False, nullable=True), sa.Column('address_1', sa.VARCHAR(), autoincrement=False, nullable=True), sa.Column('address_2', sa.VARCHAR(), autoincrement=False, nullable=True), sa.Column('city', sa.VARCHAR(), autoincrement=False, nullable=True), sa.Column('state', sa.VARCHAR(), autoincrement=False, nullable=True), sa.Column('zip_code', sa.VARCHAR(), autoincrement=False, nullable=True), sa.Column('agency_code', sa.VARCHAR(), autoincrement=False, nullable=True), sa.Column('agency_sub_code', sa.VARCHAR(), autoincrement=False, nullable=True), sa.Column('officer_id', sa.VARCHAR(), autoincrement=False, nullable=True), sa.ForeignKeyConstraint(['case_number'], ['cases.case_number'], name='related_persons_case_number_fkey', ondelete='CASCADE'), sa.PrimaryKeyConstraint('id', name='related_persons_pkey') ) op.create_table('defendants', sa.Column('id', sa.INTEGER(), server_default=sa.text("nextval('defendants_id_seq'::regclass)"), nullable=False), sa.Column('case_number', sa.VARCHAR(), autoincrement=False, nullable=True), sa.Column('defendant_name', sa.VARCHAR(), autoincrement=False, nullable=True), sa.Column('race', sa.VARCHAR(), autoincrement=False, nullable=True), sa.Column('sex', sa.VARCHAR(), autoincrement=False, nullable=True), sa.Column('height', sa.INTEGER(), autoincrement=False, nullable=True), sa.Column('weight', sa.INTEGER(), autoincrement=False, nullable=True), sa.Column('DOB', sa.DATE(), autoincrement=False, nullable=True), sa.Column('DOB_str', sa.VARCHAR(), autoincrement=False, nullable=True), sa.Column('address_1', sa.VARCHAR(), autoincrement=False, nullable=True), sa.Column('address_2', sa.VARCHAR(), autoincrement=False, nullable=True), sa.Column('city', sa.VARCHAR(), autoincrement=False, nullable=True), sa.Column('state', sa.VARCHAR(), autoincrement=False, nullable=True), sa.Column('zip_code', sa.VARCHAR(), autoincrement=False, nullable=True), sa.ForeignKeyConstraint(['case_number'], ['cases.case_number'], name='defendants_case_number_fkey', ondelete='CASCADE'), sa.PrimaryKeyConstraint('id', name='defendants_pkey'), postgresql_ignore_search_path=False ) op.create_table('dscivil_trial', sa.Column('id', sa.INTEGER(), nullable=False), sa.Column('case_number', sa.VARCHAR(), autoincrement=False, nullable=True), sa.Column('date', sa.DATE(), autoincrement=False, nullable=True), sa.Column('date_str', sa.VARCHAR(), autoincrement=False, nullable=True), sa.Column('time', postgresql.TIME(), autoincrement=False, nullable=True), sa.Column('time_str', sa.VARCHAR(), autoincrement=False, nullable=True), sa.Column('room', sa.VARCHAR(), autoincrement=False, nullable=True), sa.Column('location', sa.VARCHAR(), autoincrement=False, nullable=True), sa.Column('duration', sa.INTEGER(), autoincrement=False, nullable=True), sa.ForeignKeyConstraint(['case_number'], ['cases.case_number'], name='dscivil_trial_case_number_fkey', ondelete='CASCADE'), sa.PrimaryKeyConstraint('id', name='dscivil_trial_pkey') ) op.create_table('dscr_court_schedule', sa.Column('id', sa.INTEGER(), nullable=False), sa.Column('case_number', sa.VARCHAR(), autoincrement=False, nullable=True), sa.Column('trial_date', sa.DATE(), autoincrement=False, nullable=True), sa.Column('trial_date_str', sa.VARCHAR(), autoincrement=False, nullable=True), sa.Column('trial_time', postgresql.TIME(), autoincrement=False, nullable=True), sa.Column('trial_time_str', sa.VARCHAR(), autoincrement=False, nullable=True), sa.Column('room', sa.VARCHAR(), autoincrement=False, nullable=True), sa.Column('trial_type', sa.VARCHAR(), autoincrement=False, nullable=True), sa.Column('trial_location', sa.VARCHAR(), autoincrement=False, nullable=True), sa.ForeignKeyConstraint(['case_number'], ['cases.case_number'], name='dscr_court_schedule_case_number_fkey', ondelete='CASCADE'), sa.PrimaryKeyConstraint('id', name='court_schedule_pkey') ) op.create_table('bail_and_bond', sa.Column('id', sa.INTEGER(), server_default=sa.text("nextval('bail_and_bond_id_seq'::regclass)"), nullable=False), sa.Column('case_number', sa.VARCHAR(), autoincrement=False, nullable=True), sa.Column('bail_amount', sa.INTEGER(), autoincrement=False, nullable=True), sa.Column('bail_number', sa.VARCHAR(), autoincrement=False, nullable=True), sa.Column('set_date', sa.DATE(), autoincrement=False, nullable=True), sa.Column('set_date_str', sa.VARCHAR(), autoincrement=False, nullable=True), sa.Column('bail_set_location', sa.VARCHAR(), autoincrement=False, nullable=True), sa.Column('bond_type', sa.VARCHAR(), autoincrement=False, nullable=True), sa.Column('bondsman_company_name', sa.VARCHAR(), autoincrement=False, nullable=True), sa.Column('release_date', sa.DATE(), autoincrement=False, nullable=True), sa.Column('release_date_str', sa.VARCHAR(), autoincrement=False, nullable=True), sa.Column('release_reason', sa.VARCHAR(), autoincrement=False, nullable=True), sa.Column('forfeit_date', sa.DATE(), autoincrement=False, nullable=True), sa.Column('forfeit_date_str', sa.VARCHAR(), autoincrement=False, nullable=True), sa.Column('forfeit_extended_date', sa.DATE(), autoincrement=False, nullable=True), sa.Column('forfeit_extended_date_str', sa.VARCHAR(), autoincrement=False, nullable=True), sa.Column('days_extended', sa.INTEGER(), autoincrement=False, nullable=True), sa.Column('ground_rent', sa.NUMERIC(), autoincrement=False, nullable=True), sa.Column('property_address', sa.VARCHAR(), autoincrement=False, nullable=True), sa.Column('property_value', sa.NUMERIC(), autoincrement=False, nullable=True), sa.Column('judgment_date', sa.DATE(), autoincrement=False, nullable=True), sa.Column('judgment_date_str', sa.VARCHAR(), autoincrement=False, nullable=True), sa.Column('mortgage', sa.NUMERIC(), autoincrement=False, nullable=True), sa.ForeignKeyConstraint(['case_number'], ['cases.case_number'], name='bail_and_bond_case_number_fkey', ondelete='CASCADE'), sa.PrimaryKeyConstraint('id', name='bail_and_bond_pkey'), postgresql_ignore_search_path=False ) op.create_table('dscivil_related_person', sa.Column('id', sa.INTEGER(), nullable=False), sa.Column('case_number', sa.VARCHAR(), autoincrement=False, nullable=True), sa.Column('complaint_id', sa.INTEGER(), autoincrement=False, nullable=True), sa.Column('name', sa.VARCHAR(), autoincrement=False, nullable=True), sa.Column('connection_to_complaint', sa.VARCHAR(), autoincrement=False, nullable=True), sa.Column('address_1', sa.VARCHAR(), autoincrement=False, nullable=True), sa.Column('address_2', sa.VARCHAR(), autoincrement=False, nullable=True), sa.Column('city', sa.VARCHAR(), autoincrement=False, nullable=True), sa.Column('state', sa.VARCHAR(), autoincrement=False, nullable=True), sa.Column('zip_code', sa.VARCHAR(), autoincrement=False, nullable=True), sa.Column('attorney_code', sa.INTEGER(), autoincrement=False, nullable=True), sa.Column('attorney_firm', sa.VARCHAR(), autoincrement=False, nullable=True), sa.ForeignKeyConstraint(['case_number'], ['cases.case_number'], name='dscivil_related_person_case_number_fkey', ondelete='CASCADE'), sa.ForeignKeyConstraint(['complaint_id'], ['complaints.id'], name='dscivil_related_person_complaint_id_fkey'), sa.PrimaryKeyConstraint('id', name='dscivil_related_person_pkey') ) op.create_table('bondsman', sa.Column('id', sa.INTEGER(), nullable=False), sa.Column('case_number', sa.VARCHAR(), autoincrement=False, nullable=True), sa.Column('bail_and_bond_id', sa.INTEGER(), autoincrement=False, nullable=True), sa.Column('name', sa.VARCHAR(), autoincrement=False, nullable=True), sa.Column('address_1', sa.VARCHAR(), autoincrement=False, nullable=True), sa.Column('city', sa.VARCHAR(), autoincrement=False, nullable=True), sa.Column('state', sa.VARCHAR(), autoincrement=False, nullable=True), sa.Column('zip_code', sa.VARCHAR(), autoincrement=False, nullable=True), sa.ForeignKeyConstraint(['bail_and_bond_id'], ['bail_and_bond.id'], name='bondsman_bail_and_bond_id_fkey'), sa.ForeignKeyConstraint(['case_number'], ['cases.case_number'], name='bondsman_case_number_fkey', ondelete='CASCADE'), sa.PrimaryKeyConstraint('id', name='bondsman_pkey') ) op.create_table('DSCR', sa.Column('id', sa.INTEGER(), server_default=sa.text('nextval(\'"DSCR_id_seq"\'::regclass)'), nullable=False), sa.Column('case_number', sa.VARCHAR(), autoincrement=False, nullable=True), sa.Column('court_system', sa.VARCHAR(), autoincrement=False, nullable=True), sa.Column('tracking_number', sa.BIGINT(), autoincrement=False, nullable=True), sa.Column('case_type', sa.VARCHAR(), autoincrement=False, nullable=True), sa.Column('district_code', sa.INTEGER(), autoincrement=False, nullable=True), sa.Column('location_code', sa.INTEGER(), autoincrement=False, nullable=True), sa.Column('document_type', sa.VARCHAR(), autoincrement=False, nullable=True), sa.Column('issued_date', sa.DATE(), autoincrement=False, nullable=True), sa.Column('issued_date_str', sa.VARCHAR(), autoincrement=False, nullable=True), sa.Column('case_status', sa.VARCHAR(), autoincrement=False, nullable=True), sa.Column('case_disposition', sa.VARCHAR(), autoincrement=False, nullable=True), sa.ForeignKeyConstraint(['case_number'], ['cases.case_number'], name='DSCR_case_number_fkey', ondelete='CASCADE'), sa.PrimaryKeyConstraint('id', name='DSCR_pkey') ) op.create_table('case_events', sa.Column('id', sa.INTEGER(), nullable=False), sa.Column('case_number', sa.VARCHAR(), autoincrement=False, nullable=True), sa.Column('event_name', sa.VARCHAR(), autoincrement=False, nullable=True), sa.Column('date', sa.DATE(), autoincrement=False, nullable=True), sa.Column('date_str', sa.VARCHAR(), autoincrement=False, nullable=True), sa.Column('comment', sa.VARCHAR(), autoincrement=False, nullable=True), sa.ForeignKeyConstraint(['case_number'], ['cases.case_number'], name='case_events_case_number_fkey', ondelete='CASCADE'), sa.PrimaryKeyConstraint('id', name='case_events_pkey') ) op.create_table('judgments', sa.Column('id', sa.INTEGER(), nullable=False), sa.Column('case_number', sa.VARCHAR(), autoincrement=False, nullable=True), sa.Column('complaint_id', sa.INTEGER(), autoincrement=False, nullable=True), sa.Column('judgment_type', sa.VARCHAR(), autoincrement=False, nullable=True), sa.Column('judgment_date', sa.DATE(), autoincrement=False, nullable=True), sa.Column('judgment_date_str', sa.VARCHAR(), autoincrement=False, nullable=True), sa.Column('judgment_amount', sa.NUMERIC(), autoincrement=False, nullable=True), sa.Column('judgment_interest', sa.NUMERIC(), autoincrement=False, nullable=True), sa.Column('costs', sa.NUMERIC(), autoincrement=False, nullable=True), sa.Column('other_amounts', sa.NUMERIC(), autoincrement=False, nullable=True), sa.Column('attorney_fees', sa.NUMERIC(), autoincrement=False, nullable=True), sa.Column('post_interest_legal_rate', sa.BOOLEAN(), autoincrement=False, nullable=True), sa.Column('post_interest_contractual_rate', sa.BOOLEAN(), autoincrement=False, nullable=True), sa.Column('jointly_and_severally', sa.INTEGER(), autoincrement=False, nullable=True), sa.Column('in_favor_of_defendant', sa.BOOLEAN(), autoincrement=False, nullable=True), sa.Column('possession_value', sa.NUMERIC(), autoincrement=False, nullable=True), sa.Column('possession_damages_value', sa.NUMERIC(), autoincrement=False, nullable=True), sa.Column('value_sued_for', sa.NUMERIC(), autoincrement=False, nullable=True), sa.Column('damages', sa.NUMERIC(), autoincrement=False, nullable=True), sa.Column('dismissed_with_prejudice', sa.BOOLEAN(), autoincrement=False, nullable=True), sa.Column('replevin_detinue', sa.NUMERIC(), autoincrement=False, nullable=True), sa.Column('recorded_lien_date_str', sa.VARCHAR(), autoincrement=False, nullable=True), sa.Column('recorded_lien_date', sa.DATE(), autoincrement=False, nullable=True), sa.Column('judgment_renewed_date_str', sa.VARCHAR(), autoincrement=False, nullable=True), sa.Column('renewed_lien_date', sa.DATE(), autoincrement=False, nullable=True), sa.Column('renewed_lien_date_str', sa.VARCHAR(), autoincrement=False, nullable=True), sa.Column('satisfaction_date', sa.DATE(), autoincrement=False, nullable=True), sa.Column('satisfaction_date_str', sa.VARCHAR(), autoincrement=False, nullable=True), sa.ForeignKeyConstraint(['case_number'], ['cases.case_number'], name='judgments_case_number_fkey', ondelete='CASCADE'), sa.ForeignKeyConstraint(['complaint_id'], ['complaints.id'], name='judgments_complaint_id_fkey'), sa.PrimaryKeyConstraint('id', name='judgments_pkey') ) op.create_table('complaints', sa.Column('id', sa.INTEGER(), server_default=sa.text("nextval('complaints_id_seq'::regclass)"), nullable=False), sa.Column('case_number', sa.VARCHAR(), autoincrement=False, nullable=True), sa.Column('complaint_number', sa.INTEGER(), autoincrement=False, nullable=True), sa.Column('plaintiff', sa.VARCHAR(), autoincrement=False, nullable=True), sa.Column('defendant', sa.VARCHAR(), autoincrement=False, nullable=True), sa.Column('complaint_type', sa.VARCHAR(), autoincrement=False, nullable=True), sa.Column('complaint_status', sa.VARCHAR(), autoincrement=False, nullable=True), sa.Column('status_date', sa.DATE(), autoincrement=False, nullable=True), sa.Column('status_date_str', sa.VARCHAR(), autoincrement=False, nullable=True), sa.Column('filing_date', sa.DATE(), autoincrement=False, nullable=True), sa.Column('filing_date_str', sa.VARCHAR(), autoincrement=False, nullable=True), sa.Column('amount', sa.NUMERIC(), autoincrement=False, nullable=True), sa.Column('last_activity_date', sa.DATE(), autoincrement=False, nullable=True), sa.Column('last_activity_date_str', sa.VARCHAR(), autoincrement=False, nullable=True), sa.ForeignKeyConstraint(['case_number'], ['cases.case_number'], name='complaints_case_number_fkey', ondelete='CASCADE'), sa.PrimaryKeyConstraint('id', name='complaints_pkey'), postgresql_ignore_search_path=False ) op.create_table('dscivil_case_history', sa.Column('id', sa.INTEGER(), nullable=False), sa.Column('case_number', sa.VARCHAR(), autoincrement=False, nullable=True), sa.Column('event_type', sa.VARCHAR(), autoincrement=False, nullable=True), sa.Column('complaint_number', sa.INTEGER(), autoincrement=False, nullable=True), sa.Column('date', sa.DATE(), autoincrement=False, nullable=True), sa.Column('date_str', sa.VARCHAR(), autoincrement=False, nullable=True), sa.Column('comment', sa.VARCHAR(), autoincrement=False, nullable=True), sa.ForeignKeyConstraint(['case_number'], ['cases.case_number'], name='dscivil_case_history_case_number_fkey', ondelete='CASCADE'), sa.PrimaryKeyConstraint('id', name='dscivil_case_history_pkey') ) op.create_table('DSCIVIL', sa.Column('id', sa.INTEGER(), server_default=sa.text('nextval(\'"DSCIVIL_id_seq"\'::regclass)'), nullable=False), sa.Column('case_number', sa.VARCHAR(), autoincrement=False, nullable=True), sa.Column('court_system', sa.VARCHAR(), autoincrement=False, nullable=True), sa.Column('claim_type', sa.VARCHAR(), autoincrement=False, nullable=True), sa.Column('district_code', sa.INTEGER(), autoincrement=False, nullable=True), sa.Column('location_code', sa.INTEGER(), autoincrement=False, nullable=True), sa.Column('filing_date', sa.DATE(), autoincrement=False, nullable=True), sa.Column('filing_date_str', sa.VARCHAR(), autoincrement=False, nullable=True), sa.Column('case_status', sa.VARCHAR(), autoincrement=False, nullable=True), sa.ForeignKeyConstraint(['case_number'], ['cases.case_number'], name='DSCIVIL_case_number_fkey', ondelete='CASCADE'), sa.PrimaryKeyConstraint('id', name='DSCIVIL_pkey') ) op.create_table('dsk8_court_schedule', sa.Column('id', sa.INTEGER(), nullable=False), sa.Column('case_number', sa.VARCHAR(), autoincrement=False, nullable=True), sa.Column('court_date', sa.DATE(), autoincrement=False, nullable=True), sa.Column('court_date_str', sa.VARCHAR(), autoincrement=False, nullable=True), sa.Column('court_time', postgresql.TIME(), autoincrement=False, nullable=True), sa.Column('court_time_str', sa.VARCHAR(), autoincrement=False, nullable=True), sa.Column('room', sa.VARCHAR(), autoincrement=False, nullable=True), sa.Column('court_location', sa.VARCHAR(), autoincrement=False, nullable=True), sa.Column('reason', sa.VARCHAR(), autoincrement=False, nullable=True), sa.ForeignKeyConstraint(['case_number'], ['cases.case_number'], name='dsk8_court_schedule_case_number_fkey', ondelete='CASCADE'), sa.PrimaryKeyConstraint('id', name='dsk8_court_schedule_pkey') ) op.create_table('hearings', sa.Column('id', sa.INTEGER(), nullable=False), sa.Column('case_number', sa.VARCHAR(), autoincrement=False, nullable=True), sa.Column('complaint_id', sa.INTEGER(), autoincrement=False, nullable=True), sa.Column('date', sa.DATE(), autoincrement=False, nullable=True), sa.Column('date_str', sa.VARCHAR(), autoincrement=False, nullable=True), sa.Column('time', postgresql.TIME(), autoincrement=False, nullable=True), sa.Column('time_str', sa.VARCHAR(), autoincrement=False, nullable=True), sa.Column('room', sa.VARCHAR(), autoincrement=False, nullable=True), sa.Column('location', sa.VARCHAR(), autoincrement=False, nullable=True), sa.Column('duration', sa.VARCHAR(), autoincrement=False, nullable=True), sa.Column('hearing_type', sa.VARCHAR(), autoincrement=False, nullable=True), sa.ForeignKeyConstraint(['case_number'], ['cases.case_number'], name='hearings_case_number_fkey', ondelete='CASCADE'), sa.ForeignKeyConstraint(['complaint_id'], ['complaints.id'], name='hearings_complaint_id_fkey'), sa.PrimaryKeyConstraint('id', name='hearings_pkey') ) op.create_table('defendant_alias', sa.Column('id', sa.INTEGER(), nullable=False), sa.Column('case_number', sa.VARCHAR(), autoincrement=False, nullable=True), sa.Column('defendant_id', sa.INTEGER(), autoincrement=False, nullable=True), sa.Column('alias_name', sa.VARCHAR(), autoincrement=False, nullable=True), sa.Column('address_1', sa.VARCHAR(), autoincrement=False, nullable=True), sa.Column('address_2', sa.VARCHAR(), autoincrement=False, nullable=True), sa.Column('city', sa.VARCHAR(), autoincrement=False, nullable=True), sa.Column('state', sa.VARCHAR(), autoincrement=False, nullable=True), sa.Column('zip_code', sa.VARCHAR(), autoincrement=False, nullable=True), sa.ForeignKeyConstraint(['case_number'], ['cases.case_number'], name='defendant_alias_case_number_fkey', ondelete='CASCADE'), sa.ForeignKeyConstraint(['defendant_id'], ['defendants.id'], name='defendant_alias_defendant_id_fkey'), sa.PrimaryKeyConstraint('id', name='defendant_alias_pkey') ) op.create_table('DSK8', sa.Column('id', sa.INTEGER(), server_default=sa.text('nextval(\'"DKS8_id_seq"\'::regclass)'), nullable=False), sa.Column('case_number', sa.VARCHAR(), autoincrement=False, nullable=True), sa.Column('court_system', sa.VARCHAR(), autoincrement=False, nullable=True), sa.Column('case_status', sa.VARCHAR(), autoincrement=False, nullable=True), sa.Column('status_date', sa.DATE(), autoincrement=False, nullable=True), sa.Column('status_date_str', sa.VARCHAR(), autoincrement=False, nullable=True), sa.Column('tracking_number', sa.BIGINT(), autoincrement=False, nullable=True), sa.Column('complaint_number', sa.VARCHAR(), autoincrement=False, nullable=True), sa.Column('district_case_number', sa.VARCHAR(), autoincrement=False, nullable=True), sa.Column('filing_date', sa.DATE(), autoincrement=False, nullable=True), sa.Column('filing_date_str', sa.VARCHAR(), autoincrement=False, nullable=True), sa.Column('incident_date', sa.DATE(), autoincrement=False, nullable=True), sa.Column('incident_date_str', sa.VARCHAR(), autoincrement=False, nullable=True), sa.ForeignKeyConstraint(['case_number'], ['cases.case_number'], name='DKS8_case_number_fkey', ondelete='CASCADE'), sa.PrimaryKeyConstraint('id', name='DKS8_pkey') ) op.drop_table('dsk8_bondsman') op.drop_table('dscivil_related_persons') op.drop_table('dscivil_judgments') op.drop_table('dscivil_hearings') op.drop_table('dsk8_trials') op.drop_table('dsk8_related_persons') op.drop_table('dsk8_events') op.drop_table('dsk8_defendants') op.drop_table('dsk8_defendant_aliases') op.drop_table('dsk8_charges') op.drop_table('dsk8_bail_and_bond') op.drop_table('dscr_trials') op.drop_table('dscr_related_persons') op.drop_table('dscr_events') op.drop_table('dscr_defendants') op.drop_table('dscr_defendant_aliases') op.drop_table('dscr_charges') op.drop_table('dscivil_trials') op.drop_table('dscivil_events') op.drop_table('dscivil_complaints') op.drop_table('dsk8') op.drop_table('dscr') op.drop_table('dscivil')
def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.create_table('diet', sa.Column('id_diet', sa.INTEGER(), autoincrement=False, nullable=False), sa.Column('diet_name', sa.VARCHAR(length=40), autoincrement=False, nullable=True), sa.PrimaryKeyConstraint('id_diet', name='diet_pkey'), postgresql_ignore_search_path=False) op.create_table('resident', sa.Column('id_resident', sa.INTEGER(), autoincrement=False, nullable=False), sa.Column('gender', sa.VARCHAR(length=8), autoincrement=False, nullable=True), sa.Column('surname', sa.VARCHAR(length=40), autoincrement=False, nullable=True), sa.Column('name', sa.VARCHAR(length=40), autoincrement=False, nullable=True), sa.Column('patronymic', sa.VARCHAR(length=40), autoincrement=False, nullable=True), sa.Column('room_number', sa.INTEGER(), autoincrement=False, nullable=True), sa.Column('birthday', sa.DATE(), autoincrement=False, nullable=True), sa.Column('place_number', sa.INTEGER(), autoincrement=False, nullable=True), sa.Column('start_day', sa.DATE(), autoincrement=False, nullable=True), sa.Column('final_day', sa.DATE(), autoincrement=False, nullable=True), sa.ForeignKeyConstraint(['place_number'], ['canteen_place.canteen_number'], name='place_number'), sa.ForeignKeyConstraint(['room_number'], ['living_room.room_number'], name='resident_room_number_fkey'), sa.PrimaryKeyConstraint('id_resident', name='resident_pkey'), postgresql_ignore_search_path=False) op.create_table( 'appointment', sa.Column('id_resident', sa.INTEGER(), autoincrement=False, nullable=True), sa.Column('id_procedure', sa.VARCHAR(length=40), autoincrement=False, nullable=True), sa.ForeignKeyConstraint(['id_procedure'], ['medical_procedure.id_procedure'], name='appointment_id_procedure_fkey'), sa.ForeignKeyConstraint(['id_resident'], ['resident.id_resident'], name='appointment_id_resident_fkey')) op.create_table('infrastructure', sa.Column('rent_number', sa.INTEGER(), autoincrement=False, nullable=False), sa.Column('description', sa.VARCHAR(), autoincrement=False, nullable=True), sa.PrimaryKeyConstraint('rent_number', name='infrastructure_pkey'), postgresql_ignore_search_path=False) op.create_table('item', sa.Column('id_item', sa.INTEGER(), autoincrement=False, nullable=False), sa.Column('item_name', sa.VARCHAR(length=40), autoincrement=False, nullable=True), sa.PrimaryKeyConstraint('id_item', name='item_pkey'), postgresql_ignore_search_path=False) op.create_table( 'income', sa.Column('operation_number', sa.INTEGER(), autoincrement=False, nullable=False), sa.Column('operation_time', sa.DATE(), autoincrement=False, nullable=True), sa.Column('sum', postgresql.MONEY(), autoincrement=False, nullable=True), sa.Column('id_resident', sa.INTEGER(), autoincrement=False, nullable=True), sa.ForeignKeyConstraint(['id_resident'], ['resident.id_resident'], name='id_resident'), sa.PrimaryKeyConstraint('operation_number', name='income_pkey')) op.create_table('living_room', sa.Column('room_number', sa.INTEGER(), autoincrement=False, nullable=False), sa.Column('floor', sa.INTEGER(), autoincrement=False, nullable=True), sa.Column('room_class', sa.VARCHAR(length=40), autoincrement=False, nullable=True), sa.PrimaryKeyConstraint('room_number', name='living_room_pkey'), postgresql_ignore_search_path=False) op.create_table( 'warehouse', sa.Column('id_warehouse', sa.INTEGER(), autoincrement=False, nullable=False), sa.Column('number', sa.INTEGER(), autoincrement=False, nullable=True), sa.Column('id_item', sa.INTEGER(), autoincrement=False, nullable=True), sa.ForeignKeyConstraint(['id_item'], ['item.id_item'], name='warehouse_id_item_fkey'), sa.PrimaryKeyConstraint('id_warehouse', name='warehouse_pkey')) op.create_table( 'consultation', sa.Column('id_consultation', sa.INTEGER(), autoincrement=False, nullable=False), sa.Column('consultation_name', sa.VARCHAR(length=40), autoincrement=False, nullable=True), sa.Column('id_resident', sa.INTEGER(), autoincrement=False, nullable=True), sa.ForeignKeyConstraint(['id_resident'], ['resident.id_resident'], name='consultation_id_resident_fkey'), sa.PrimaryKeyConstraint('id_consultation', name='consultation_pkey')) op.create_table('sport_group', sa.Column('id_group', sa.INTEGER(), autoincrement=False, nullable=False), sa.Column('group_name', sa.VARCHAR(length=40), autoincrement=False, nullable=True), sa.PrimaryKeyConstraint('id_group', name='sport_group_pkey'), postgresql_ignore_search_path=False) op.create_table('canteen_place', sa.Column('canteen_number', sa.INTEGER(), autoincrement=False, nullable=False), sa.Column('id_diet', sa.INTEGER(), autoincrement=False, nullable=True), sa.ForeignKeyConstraint(['id_diet'], ['diet.id_diet'], name='canteen_place_id_diet_fkey'), sa.PrimaryKeyConstraint('canteen_number', name='canteen_place_pkey'), postgresql_ignore_search_path=False) op.create_table( 'medical_procedure', sa.Column('id_procedure', sa.VARCHAR(length=40), autoincrement=False, nullable=False), sa.Column('procedure_name', sa.VARCHAR(length=40), autoincrement=False, nullable=True), sa.PrimaryKeyConstraint('id_procedure', name='medical_procedure_pkey')) op.create_table( 'timetable', sa.Column('week_day', sa.VARCHAR(), autoincrement=False, nullable=False), sa.Column('start_time', postgresql.TIME(), autoincrement=False, nullable=True), sa.Column('finish_time', postgresql.TIME(), autoincrement=False, nullable=True), sa.Column('staff_cadr', sa.INTEGER(), autoincrement=False, nullable=True), sa.ForeignKeyConstraint(['staff_cadr'], ['staff.staff_cadr'], name='staff_cadr'), sa.PrimaryKeyConstraint('week_day', name='timetable_pkey')) op.create_table( 'place_rent', sa.Column('id_resident', sa.INTEGER(), autoincrement=False, nullable=True), sa.Column('rent_number', sa.INTEGER(), autoincrement=False, nullable=True), sa.ForeignKeyConstraint(['id_resident'], ['resident.id_resident'], name='id_resident'), sa.ForeignKeyConstraint(['rent_number'], ['infrastructure.rent_number'], name='rent_number')) op.create_table( 'staff', sa.Column('staff_cadr', sa.INTEGER(), autoincrement=False, nullable=False), sa.Column('surname', sa.VARCHAR(length=40), autoincrement=False, nullable=True), sa.Column('name', sa.VARCHAR(length=40), autoincrement=False, nullable=True), sa.Column('patronymic', sa.VARCHAR(length=40), autoincrement=False, nullable=True), sa.Column('position', sa.VARCHAR(length=40), autoincrement=False, nullable=True), sa.Column('hours', sa.INTEGER(), autoincrement=False, nullable=True), sa.Column('salary', postgresql.MONEY(), autoincrement=False, nullable=True), sa.PrimaryKeyConstraint('staff_cadr', name='staff_pkey')) op.create_table( 'sport_membership', sa.Column('id_resident', sa.INTEGER(), autoincrement=False, nullable=True), sa.Column('id_group', sa.INTEGER(), autoincrement=False, nullable=True), sa.ForeignKeyConstraint(['id_group'], ['sport_group.id_group'], name='sport_membership_id_group_fkey'), sa.ForeignKeyConstraint(['id_resident'], ['resident.id_resident'], name='sport_membership_id_resident_fkey')) op.create_table( 'parking', sa.Column('id_place', sa.INTEGER(), autoincrement=False, nullable=False), sa.Column('car_number', sa.VARCHAR(length=40), autoincrement=False, nullable=True), sa.ForeignKeyConstraint(['car_number'], ['car.car_number'], name='parking_car_number_fkey'), sa.PrimaryKeyConstraint('id_place', name='parking_pkey')) op.create_table( 'expenses', sa.Column('operation_num', sa.INTEGER(), autoincrement=False, nullable=False), sa.Column('operation_data', sa.DATE(), autoincrement=False, nullable=True), sa.Column('operation_sum', postgresql.MONEY(), autoincrement=False, nullable=True), sa.Column('description', sa.VARCHAR(), autoincrement=False, nullable=True), sa.PrimaryKeyConstraint('operation_num', name='expenses_pkey')) op.create_table( 'car', sa.Column('car_number', sa.VARCHAR(length=40), autoincrement=False, nullable=False), sa.Column('id_resident', sa.INTEGER(), autoincrement=False, nullable=True), sa.Column('model', sa.VARCHAR(length=40), autoincrement=False, nullable=True), sa.Column('color', sa.VARCHAR(length=40), autoincrement=False, nullable=True), sa.ForeignKeyConstraint(['id_resident'], ['resident.id_resident'], name='car_id_resident_fkey'), sa.PrimaryKeyConstraint('car_number', name='car_pkey')) op.create_table( 'item_rent', sa.Column('id_resident', sa.INTEGER(), autoincrement=False, nullable=True), sa.Column('id_item', sa.INTEGER(), autoincrement=False, nullable=True), sa.ForeignKeyConstraint(['id_item'], ['item.id_item'], name='item_rent_id_item_fkey'), sa.ForeignKeyConstraint(['id_resident'], ['resident.id_resident'], name='item_rent_id_resident_fkey'))
def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.alter_column('Shows', 'date', existing_type=postgresql.TIME(), nullable=True)
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.create_table( 'admin_settings', sa.Column('semester', sa.VARCHAR(length=255), nullable=False), sa.PrimaryKeyConstraint('semester')) op.create_table( 'course', sa.Column('crn', sa.VARCHAR(length=255), nullable=False), sa.Column('section', sa.VARCHAR(length=255), nullable=True), sa.Column('semester', sa.VARCHAR(length=255), nullable=True), sa.Column('min_credits', sa.INTEGER(), nullable=True), sa.Column('max_credits', sa.INTEGER(), nullable=True), sa.Column('date_start', sa.DATE(), nullable=True), sa.Column('date_end', sa.DATE(), nullable=True), sa.Column('department', sa.VARCHAR(length=255), nullable=True), sa.Column('level', sa.INTEGER(), nullable=True), sa.Column('title', sa.VARCHAR(length=255), nullable=True), sa.Column('full_title', sa.TEXT(), nullable=True), sa.Column('description', sa.TEXT(), nullable=True), sa.Column('raw_precoreqs', sa.TEXT(), nullable=True), sa.Column('frequency', sa.VARCHAR(length=255), nullable=True), sa.Column('school', sa.VARCHAR(length=255), nullable=True), sa.Column('tsv', postgresql.TSVECTOR(), nullable=True), sa.PrimaryKeyConstraint('crn')) op.create_table( 'course_corequisite', sa.Column('department', sa.VARCHAR(length=255), nullable=False), sa.Column('level', sa.INTEGER(), nullable=False), sa.Column('corequisite', sa.VARCHAR(length=255), nullable=False), sa.PrimaryKeyConstraint('department', 'level', 'corequisite')) op.create_table( 'course_prerequisite', sa.Column('department', sa.VARCHAR(length=255), nullable=False), sa.Column('level', sa.INTEGER(), nullable=False), sa.Column('prerequisite', sa.VARCHAR(length=255), nullable=False), sa.PrimaryKeyConstraint('department', 'level', 'prerequisite')) op.create_table( 'course_session', sa.Column('crn', sa.VARCHAR(length=255), nullable=False), sa.Column('section', sa.VARCHAR(length=255), nullable=False), sa.Column('semester', sa.VARCHAR(length=255), nullable=False), sa.Column('time_start', postgresql.TIME(), nullable=True), sa.Column('time_end', postgresql.TIME(), nullable=True), sa.Column('day_of_week', sa.INTEGER(), nullable=False), sa.Column('location', sa.VARCHAR(length=255), nullable=True), sa.PrimaryKeyConstraint('crn', 'section', 'semester', 'day_of_week')) op.create_table( 'event', sa.Column('event_id', sa.INTEGER(), nullable=False), sa.Column('description', sa.VARCHAR(length=255), nullable=True), sa.PrimaryKeyConstraint('event_id')) op.create_table( 'semester_date_range', sa.Column('semester_part_name', sa.VARCHAR(length=255), nullable=True), sa.Column('date_start', sa.DATE(), nullable=False), sa.Column('date_end', sa.DATE(), nullable=False), sa.PrimaryKeyConstraint('date_start', 'date_end')) op.create_table( 'semester_info', sa.Column('semester', sa.VARCHAR(length=255), nullable=False), sa.Column('public', sa.BOOLEAN(), nullable=True), sa.PrimaryKeyConstraint('semester')) op.create_table('user_account', sa.Column('user_id', sa.INTEGER(), nullable=False), sa.Column('name', sa.TEXT(), nullable=True), sa.Column('email', sa.TEXT(), nullable=False), sa.Column('phone', sa.TEXT(), nullable=True), sa.Column('password', sa.TEXT(), nullable=True), sa.Column('major', sa.TEXT(), nullable=True), sa.Column('degree', sa.TEXT(), nullable=True), sa.Column('enable', sa.BOOLEAN(), nullable=True), sa.Column('admin', sa.BOOLEAN(), nullable=True), sa.Column('super_admin', sa.BOOLEAN(), nullable=True), sa.PrimaryKeyConstraint('user_id'), sa.UniqueConstraint('email')) op.create_table( 'user_event', sa.Column('event_id', sa.INTEGER(), nullable=False), sa.Column('user_id', postgresql.UUID(), nullable=False), sa.Column('content', sa.VARCHAR(length=255), nullable=True), sa.Column('created_at', sa.BIGINT(), nullable=True), sa.PrimaryKeyConstraint('event_id', 'user_id')) op.create_table( 'user_session', sa.Column('session_id', postgresql.UUID(), nullable=False), sa.Column('user_id', sa.INTEGER(), nullable=False), sa.Column('start_time', postgresql.TIMESTAMP(timezone=True), nullable=True), sa.Column('end_time', postgresql.TIMESTAMP(timezone=True), nullable=True), sa.PrimaryKeyConstraint('session_id')) op.create_table( 'student_course_selection', sa.Column('user_id', sa.INTEGER(), nullable=False), sa.Column('semester', sa.VARCHAR(length=255), nullable=False), sa.Column('course_name', sa.VARCHAR(length=255), nullable=False), sa.Column('crn', sa.VARCHAR(length=255), nullable=False), sa.ForeignKeyConstraint( ['user_id'], ['user_account.user_id'], ), sa.PrimaryKeyConstraint('user_id', 'semester', 'course_name', 'crn'))
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.create_table( 'date_details', sa.Column('id', sa.Integer(), nullable=False), sa.Column('date', sa.Date(), nullable=True), sa.Column('type', sa.Enum('required', 'not_required', 'not_important', name='date_type'), nullable=True), sa.PrimaryKeyConstraint('id')) op.create_index(op.f('ix_date_details_date'), 'date_details', ['date'], unique=True) op.create_table('madors', sa.Column('id', sa.Integer(), nullable=False), sa.Column('name', sa.String(), nullable=True), sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('name')) op.create_table('permissions', sa.Column('id', sa.Integer(), nullable=False), sa.Column('type', sa.String(), nullable=True), sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('id')) op.create_table('reasons', sa.Column('id', sa.Integer(), nullable=False), sa.Column('name', sa.String(), nullable=True), sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('id')) op.create_table( 'settings', sa.Column('id', sa.Integer(), nullable=False), sa.Column('key', sa.String(), nullable=True), sa.Column('value', sa.String(), nullable=True), sa.Column('type', sa.Enum('int', 'str', 'bool', 'time', 'date', name='types'), nullable=False), sa.PrimaryKeyConstraint('id')) op.create_table( 'mador_settings', sa.Column('id', sa.Integer(), nullable=False), sa.Column('mador_name', sa.String(), nullable=True), sa.Column('key', sa.String(), nullable=True), sa.Column('value', sa.String(), nullable=True), sa.Column('type', sa.Enum('int', 'str', 'bool', 'time', 'date', name='types'), nullable=False), sa.ForeignKeyConstraint(['mador_name'], ['madors.name'], ondelete='CASCADE'), sa.PrimaryKeyConstraint('id')) op.create_index(op.f('ix_mador_settings_mador_name'), 'mador_settings', ['mador_name'], unique=False) op.create_table( 'users', sa.Column('id', sa.Integer(), nullable=False), sa.Column('icon_path', sa.String(), nullable=True), sa.Column('commander_id', sa.Integer(), nullable=True), sa.Column('reminder_time', postgresql.TIME(), nullable=True), sa.Column('last_reminded_date', sa.Date(), nullable=True), sa.Column('english_name', sa.String(), nullable=True), sa.Column('type', sa.Enum('facebook', 'google', 'local', name='user_type'), nullable=True), sa.Column('username', sa.String(), nullable=True), sa.Column('password', sa.String(), nullable=True), sa.Column('mador_name', sa.String(), nullable=True), sa.Column('manages_mador_name', sa.String(), nullable=True), sa.ForeignKeyConstraint(['commander_id'], ['users.id'], ondelete='SET NULL'), sa.ForeignKeyConstraint(['mador_name'], ['madors.name'], ondelete='SET NULL'), sa.ForeignKeyConstraint(['manages_mador_name'], ['madors.name'], ondelete='SET NULL'), sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('id'), sa.UniqueConstraint('manages_mador_name')) op.create_index(op.f('ix_users_commander_id'), 'users', ['commander_id'], unique=False) op.create_index(op.f('ix_users_mador_name'), 'users', ['mador_name'], unique=False) op.create_index(op.f('ix_users_username'), 'users', ['username'], unique=True) op.create_table( 'date_datas', sa.Column('id', sa.Integer(), nullable=False), sa.Column('date', sa.Date(), nullable=True), sa.Column('user_id', sa.Integer(), nullable=True), sa.Column('state', sa.Enum('here', 'not_here', name='answer_state'), nullable=True), sa.Column('reason_id', sa.Integer(), nullable=True), sa.Column('reported_by_id', sa.Integer(), nullable=True), sa.ForeignKeyConstraint(['date'], ['date_details.date'], ondelete='CASCADE'), sa.ForeignKeyConstraint( ['reason_id'], ['reasons.id'], ), sa.ForeignKeyConstraint(['reported_by_id'], ['users.id'], ondelete='CASCADE'), sa.ForeignKeyConstraint(['user_id'], ['users.id'], ondelete='CASCADE'), sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('id')) op.create_index(op.f('ix_date_datas_date'), 'date_datas', ['date'], unique=False) op.create_index(op.f('ix_date_datas_reason_id'), 'date_datas', ['reason_id'], unique=False) op.create_index(op.f('ix_date_datas_reported_by_id'), 'date_datas', ['reported_by_id'], unique=False) op.create_index(op.f('ix_date_datas_user_id'), 'date_datas', ['user_id'], unique=False) op.create_table( 'operators_map', sa.Column('mador_id', sa.Integer(), nullable=True), sa.Column('user_id', sa.Integer(), nullable=True), sa.ForeignKeyConstraint(['mador_id'], ['madors.id'], ondelete='CASCADE'), sa.ForeignKeyConstraint(['user_id'], ['users.id'], ondelete='CASCADE')) op.create_index(op.f('ix_operators_map_mador_id'), 'operators_map', ['mador_id'], unique=False) op.create_index(op.f('ix_operators_map_user_id'), 'operators_map', ['user_id'], unique=False) op.create_table( 'permissions_map', sa.Column('permission_id', sa.Integer(), nullable=True), sa.Column('user_id', sa.Integer(), nullable=True), sa.ForeignKeyConstraint(['permission_id'], ['permissions.id'], ondelete='CASCADE'), sa.ForeignKeyConstraint(['user_id'], ['users.id'], ondelete='CASCADE')) op.create_index(op.f('ix_permissions_map_permission_id'), 'permissions_map', ['permission_id'], unique=False) op.create_index(op.f('ix_permissions_map_user_id'), 'permissions_map', ['user_id'], unique=False) op.create_table( 'repetative_datas', sa.Column('id', sa.Integer(), nullable=False), sa.Column('user_id', sa.Integer(), nullable=True), sa.Column('from_date_id', sa.Integer(), nullable=True), sa.Column('to_date_id', sa.Integer(), nullable=True), sa.Column('every', sa.Integer(), nullable=True), sa.Column('reason_id', sa.Integer(), nullable=True), sa.ForeignKeyConstraint(['from_date_id'], ['date_details.id'], ondelete='CASCADE'), sa.ForeignKeyConstraint( ['reason_id'], ['reasons.id'], ), sa.ForeignKeyConstraint(['to_date_id'], ['date_details.id'], ondelete='CASCADE'), sa.ForeignKeyConstraint(['user_id'], ['users.id'], ondelete='CASCADE'), sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('id')) op.create_index(op.f('ix_repetative_datas_from_date_id'), 'repetative_datas', ['from_date_id'], unique=False) op.create_index(op.f('ix_repetative_datas_reason_id'), 'repetative_datas', ['reason_id'], unique=False) op.create_index(op.f('ix_repetative_datas_to_date_id'), 'repetative_datas', ['to_date_id'], unique=False) op.create_index(op.f('ix_repetative_datas_user_id'), 'repetative_datas', ['user_id'], unique=False)
def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.add_column('booking', sa.Column('date_to', sa.DATE(), autoincrement=False, nullable=True)) op.add_column('booking', sa.Column('time_from', postgresql.TIME(), autoincrement=False, nullable=True)) op.add_column('booking', sa.Column('date', sa.DATE(), autoincrement=False, nullable=True)) op.add_column('booking', sa.Column('time_to', postgresql.TIME(), autoincrement=False, nullable=True))
def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.create_table( 'corequisite', sa.Column('main_subject', sa.VARCHAR(length=32), autoincrement=False, nullable=False), sa.Column('main_num', sa.INTEGER(), autoincrement=False, nullable=False), sa.Column('main_type', sa.VARCHAR(length=32), autoincrement=False, nullable=False), sa.Column('sup_subject', sa.VARCHAR(length=32), autoincrement=False, nullable=False), sa.Column('sup_num', sa.INTEGER(), autoincrement=False, nullable=False), sa.Column('sup_type', sa.VARCHAR(length=32), autoincrement=False, nullable=False), sa.ForeignKeyConstraint(['main_subject', 'main_num'], ['class.subject', 'class.num'], name='corequisite_main_subject_main_num_fkey'), sa.ForeignKeyConstraint(['sup_subject', 'sup_num'], ['class.subject', 'class.num'], name='corequisite_sup_subject_sup_num_fkey'), sa.PrimaryKeyConstraint('sup_subject', 'sup_num', 'sup_type', name='_sup_uc')) op.create_table( 'courseoff', sa.Column('subject', sa.VARCHAR(length=256), autoincrement=False, nullable=False), sa.Column('course_num', sa.INTEGER(), autoincrement=False, nullable=False), sa.Column('type', sa.VARCHAR(length=8), autoincrement=False, nullable=False), sa.Column('id', sa.INTEGER(), autoincrement=False, nullable=False), sa.Column('mon', sa.BOOLEAN(), autoincrement=False, nullable=False), sa.Column('tues', sa.BOOLEAN(), autoincrement=False, nullable=False), sa.Column('wed', sa.BOOLEAN(), autoincrement=False, nullable=False), sa.Column('thur', sa.BOOLEAN(), autoincrement=False, nullable=False), sa.Column('fri', sa.BOOLEAN(), autoincrement=False, nullable=False), sa.Column('start_time', postgresql.TIME(), autoincrement=False, nullable=False), sa.Column('end_time', postgresql.TIME(), autoincrement=False, nullable=False), sa.ForeignKeyConstraint(['subject', 'course_num'], ['class.subject', 'class.num'], name='courseoff_subject_course_num_fkey'), sa.PrimaryKeyConstraint('subject', 'course_num', 'type', 'id', name='courseoff_pkey'), postgresql_ignore_search_path=False) op.create_table('class', sa.Column('subject', sa.VARCHAR(length=32), autoincrement=False, nullable=False), sa.Column('num', sa.INTEGER(), autoincrement=False, nullable=False), sa.Column('unit', sa.REAL(), autoincrement=False, nullable=False), sa.Column('alp', sa.BOOLEAN(), autoincrement=False, nullable=False), sa.Column('cz', sa.BOOLEAN(), autoincrement=False, nullable=False), sa.Column('ns', sa.BOOLEAN(), autoincrement=False, nullable=False), sa.Column('qs', sa.BOOLEAN(), autoincrement=False, nullable=False), sa.Column('ss', sa.BOOLEAN(), autoincrement=False, nullable=False), sa.Column('cci', sa.BOOLEAN(), autoincrement=False, nullable=False), sa.Column('ei', sa.BOOLEAN(), autoincrement=False, nullable=False), sa.Column('sts', sa.BOOLEAN(), autoincrement=False, nullable=False), sa.Column('fl', sa.BOOLEAN(), autoincrement=False, nullable=False), sa.Column('r', sa.BOOLEAN(), autoincrement=False, nullable=False), sa.Column('w', sa.BOOLEAN(), autoincrement=False, nullable=False), sa.Column('rating', sa.REAL(), autoincrement=False, nullable=True), sa.Column('desc', sa.VARCHAR(length=256), autoincrement=False, nullable=True), sa.PrimaryKeyConstraint('subject', 'num', name='class_pkey'), postgresql_ignore_search_path=False) op.create_table( 'professordos', sa.Column('id', sa.INTEGER(), autoincrement=True, nullable=False), sa.Column('name', sa.VARCHAR(length=256), autoincrement=False, nullable=True), sa.PrimaryKeyConstraint('id', name='professordos_pkey')) op.create_table( 'courseprof', sa.Column('subject', sa.VARCHAR(length=256), autoincrement=False, nullable=False), sa.Column('course_num', sa.INTEGER(), autoincrement=False, nullable=False), sa.Column('type', sa.VARCHAR(length=8), autoincrement=False, nullable=False), sa.Column('id', sa.INTEGER(), autoincrement=False, nullable=False), sa.Column('prof_id', sa.INTEGER(), autoincrement=False, nullable=False), sa.Column('rating', sa.REAL(), autoincrement=False, nullable=True), sa.ForeignKeyConstraint(['prof_id'], ['professor.id'], name='courseprof_prof_id_fkey'), sa.ForeignKeyConstraint( ['subject', 'course_num', 'type', 'id'], [ 'courseoff.subject', 'courseoff.course_num', 'courseoff.type', 'courseoff.id' ], name='courseprof_subject_course_num_type_id_fkey'), sa.PrimaryKeyConstraint('subject', 'course_num', 'type', 'id', 'prof_id', name='courseprof_pkey')) op.create_table( 'professor', sa.Column('id', sa.INTEGER(), autoincrement=True, nullable=False), sa.Column('name', sa.VARCHAR(length=256), autoincrement=False, nullable=True), sa.PrimaryKeyConstraint('id', name='professor_pkey')) op.drop_table('courseprofdos') op.drop_table('courseoffdos') op.drop_table('corequisitedos') op.drop_table('classdos') op.drop_table('professortres') op.drop_table('departmentdos')
def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.add_column('visit', sa.Column('time_of_visit', postgresql.TIME(), autoincrement=False, nullable=False))