def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.create_table( 'events', sa.Column('id', sa.Integer(), nullable=False), sa.Column('name', sa.String(length=64), nullable=True), sa.Column('startdate', sa.Date(), nullable=True), sa.Column('starttime', sa.Time(), nullable=True), sa.Column('location', sa.String(length=64), nullable=True), sa.Column('eventType', sa.Integer(), nullable=True), sa.Column('enddate', sa.Date(), nullable=True), sa.Column('endtime', sa.Time(), nullable=True), sa.Column('description', sa.String(length=64), nullable=True), sa.PrimaryKeyConstraint('id')) op.create_table( 'users', sa.Column('id', sa.Integer(), nullable=False), sa.Column('username', sa.String(length=64), nullable=True), sa.Column('email', sa.String(length=128), nullable=True), sa.Column('password_hash', sa.String(length=128), nullable=True), sa.Column('is_instructor', sa.Boolean(), nullable=True), sa.PrimaryKeyConstraint('id')) op.create_index(op.f('ix_users_email'), 'users', ['email'], unique=True) op.create_index(op.f('ix_users_username'), 'users', ['username'], unique=False) op.create_table('participation', sa.Column('event_id', sa.Integer(), nullable=False), sa.Column('user_id', sa.Integer(), nullable=False), sa.ForeignKeyConstraint( ['event_id'], ['events.id'], ), sa.ForeignKeyConstraint( ['user_id'], ['users.id'], ), sa.PrimaryKeyConstraint('event_id', 'user_id'))
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.add_column('booking', sa.Column('time_from', sa.Time(), nullable=True)) op.add_column('booking', sa.Column('time_to', sa.Time(), nullable=True)) op.drop_column('booking', 'time') op.drop_column('booking', 'period') op.drop_column('tables', 'number')
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.create_table('timeslots', sa.Column('id', sa.Integer(), nullable=False), sa.Column('time_start', sa.Time(), nullable=False), sa.Column('time_end', sa.Time(), nullable=False), sa.Column('capacity', sa.Integer(), nullable=False), sa.PrimaryKeyConstraint('id'))
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.create_table( 'fare', sa.Column('id', sa.Integer(), autoincrement=True, nullable=False), sa.Column('standing_charge', sa.Float(precision=2), nullable=False), sa.Column('call_minute_charge', sa.Float(precision=2), nullable=False), sa.Column('start_reduce_time', sa.Time(), nullable=False), sa.Column('end_reduce_time', sa.Time(), nullable=False), sa.Column('reduced_standing_charge', sa.Float(precision=2), nullable=False), sa.Column('reduced_call_minute_charge', sa.Float(precision=2), nullable=False), sa.Column('starts_at', sa.DateTime(), nullable=False), sa.PrimaryKeyConstraint('id')) op.create_table( 'call', sa.Column('id', sa.Integer(), autoincrement=True, nullable=False), sa.Column('call_id', sa.Integer(), nullable=False), sa.Column('start_timestamp', sa.DateTime(), nullable=True), sa.Column('origin_phone', sa.String(length=11), nullable=True), sa.Column('destination_phone', sa.String(length=11), nullable=True), sa.Column('end_timestamp', sa.DateTime(), nullable=True), sa.Column('fare_id', sa.Integer(), nullable=False), sa.ForeignKeyConstraint( ['fare_id'], ['fare.id'], ), sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('call_id'))
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.create_table( 'scheduler_vehicle_avails', sa.Column('id', sa.Integer(), nullable=False), sa.Column('availability', sa.String(length=32), nullable=True), sa.PrimaryKeyConstraint('id')) op.create_table('scheduler_vehicle_types', sa.Column('id', sa.Integer(), nullable=False), sa.Column('type', sa.String(length=32), nullable=True), sa.PrimaryKeyConstraint('id')) op.create_table( 'scheduler_vehicle_resources', sa.Column('id', sa.Integer(), nullable=False), sa.Column('license', sa.String(length=8), nullable=False), sa.Column('maker', sa.String(length=16), nullable=False), sa.Column('model', sa.String(length=16), nullable=True), sa.Column('year', sa.String(length=4), nullable=True), sa.Column('occupancy', sa.Integer(), nullable=False), sa.Column('desc', sa.Text(), nullable=True), sa.Column('business_hour_start', sa.Time(), nullable=True), sa.Column('business_hour_end', sa.Time(), nullable=True), sa.Column('availability_id', sa.Integer(), nullable=True), sa.Column('type_id', sa.Integer(), nullable=True), sa.ForeignKeyConstraint( ['availability_id'], ['scheduler_vehicle_avails.id'], ), sa.ForeignKeyConstraint( ['type_id'], ['scheduler_vehicle_types.id'], ), sa.PrimaryKeyConstraint('id'))
def upgrade(): ### commands auto generated by Alembic - please adjust! ### op.create_table('week', sa.Column('id', sa.Integer(), nullable=False), sa.Column('name', sa.String(length=120), nullable=True), sa.Column('school_id', sa.Integer(), nullable=True), sa.ForeignKeyConstraint(['school_id'], ['school.id'], ), sa.PrimaryKeyConstraint('id') ) op.create_table('period', sa.Column('id', sa.Integer(), nullable=False), sa.Column('week_id', sa.Integer(), nullable=True), sa.Column('day', sa.Integer(), nullable=True), sa.Column('start_time', sa.Time(), nullable=True), sa.Column('end_time', sa.Time(), nullable=True), sa.Column('name', sa.String(length=120), nullable=True), sa.ForeignKeyConstraint(['week_id'], ['week.id'], ), sa.PrimaryKeyConstraint('id') ) op.create_table('timetabled_lesson', sa.Column('id', sa.Integer(), nullable=False), sa.Column('period_id', sa.Integer(), nullable=True), sa.Column('lesson_id', sa.Integer(), nullable=True), sa.ForeignKeyConstraint(['lesson_id'], ['lesson.id'], ), sa.ForeignKeyConstraint(['period_id'], ['period.id'], ), sa.PrimaryKeyConstraint('id') )
def upgrade(): op.create_table( 'travels', sa.Column('id', sa.Integer, autoincrement=True, primary_key=True), sa.Column('traveller_name', sa.String(500), nullable=True), sa.Column('employee_id', sa.String(500), nullable=True), sa.Column('employing_entity', sa.String(500), nullable=True), sa.Column('employee_country', sa.String(3), nullable=True), sa.Column('au', sa.String(500), nullable=True), sa.Column('booking_date', sa.Date(), nullable=True), sa.Column('record_locator', sa.String(500), nullable=True), sa.Column('ticket_no', sa.String(500), nullable=True), sa.Column('ticket_type', sa.String(500), nullable=True), sa.Column('segment_no', sa.String(500), nullable=True), sa.Column('calculated_seg_no', sa.String(500), nullable=True), sa.Column('origin_country_name', sa.String(3), nullable=True), sa.Column('origin_airport_code', sa.String(500), nullable=True), sa.Column('destination_country_name', sa.String(3), nullable=True), sa.Column('destination_airport_code', sa.String(500), nullable=True), sa.Column('routing_airports', sa.String(1000), nullable=True), sa.Column('departure_date', sa.Date(), nullable=True), sa.Column('departure_time', sa.Time(), nullable=True), sa.Column('arrival_date', sa.Date(), nullable=True), sa.Column('arrival_time', sa.Time(), nullable=True), )
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.create_table( 'admin_event', sa.Column('id', sa.Integer(), nullable=False), sa.Column('hostname', sa.String(length=256), nullable=True), sa.Column('username', sa.String(length=256), nullable=True), sa.Column('pid', sa.Integer(), nullable=True), sa.Column('processhandler', sa.String(length=1024), nullable=True), sa.Column('processname', sa.String(length=1024), nullable=True), sa.Column('event_type', sa.String(length=256), nullable=True), sa.Column('event_time', sa.DateTime(), nullable=True), sa.Column('process_start_time', sa.DateTime(), nullable=True), sa.PrimaryKeyConstraint('id')) op.create_table( 'process_info', sa.Column('id', sa.Integer(), nullable=False), sa.Column('key', sa.String(length=256), nullable=True), sa.Column('hostname', sa.String(length=256), nullable=True), sa.Column('username', sa.String(length=256), nullable=True), sa.Column('pid', sa.Integer(), nullable=True), sa.Column('processhandler', sa.String(length=1024), nullable=True), sa.Column('processname', sa.String(length=1024), nullable=True), sa.Column('start_time', sa.DateTime(), nullable=True), sa.Column('end_time', sa.DateTime(), nullable=True), sa.PrimaryKeyConstraint('id')) op.create_table( 'rule_override', sa.Column('id', sa.Integer(), nullable=False), sa.Column('key', sa.String(length=256), nullable=True), sa.Column('username', sa.String(length=256), nullable=True), sa.Column('reference_date', sa.Date(), nullable=True), sa.Column('max_time_per_day', sa.Integer(), nullable=True), sa.Column('min_time_of_day', sa.Time(), nullable=True), sa.Column('max_time_of_day', sa.Time(), nullable=True), sa.Column('min_break', sa.Integer(), nullable=True), sa.Column('free_play', sa.Boolean(), nullable=True), sa.PrimaryKeyConstraint('id'))
def upgrade(): ### commands auto generated by Alembic - please adjust! ### op.create_table( 'pattern', 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('start_date', sa.DateTime(), nullable=True), sa.Column('end_date', sa.DateTime(), nullable=True), sa.Column('weekly_pattern', postgresql.BIT(7), nullable=False), sa.Column('impact_id', postgresql.UUID(), nullable=True), sa.ForeignKeyConstraint( ['impact_id'], [u'impact.id'], ), sa.PrimaryKeyConstraint('id')) op.create_index('ix_pattern_impact_id', 'pattern', ['impact_id'], unique=False) op.create_table('time_slot', 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('begin', sa.Time(), nullable=True), sa.Column('end', sa.Time(), nullable=True), sa.Column('pattern_id', postgresql.UUID(), nullable=True), sa.ForeignKeyConstraint( ['pattern_id'], [u'pattern.id'], ), sa.PrimaryKeyConstraint('id')) op.create_index('ix_time_slot_pattern_id', 'time_slot', ['pattern_id'], unique=False)
class Market(Base): __tablename__ = 'market' code = db.Column(db.String, primary_key=True) name = db.Column(db.String) api_code = db.Column(db.String) timezone = db.Column(TimezoneType(backend='pytz')) open = db.Column(db.Time(timezone=True)) close = db.Column(db.Time(timezone=True)) base_url = db.Column(db.String) # Foreign key relationships stocks = relationship('Stock', order_by='Stock.ticker', back_populates='market') def __init__(self, code, **kwargs): self.code = code self.name = kwargs.pop('name', None) self.api_code = kwargs.pop('api_code', None) self.timezone = kwargs.pop('timezone', None) self.open = kwargs.pop('open', None) self.close = kwargs.pop('close', None) self.base_url = kwargs.pop('base_url', None) def get_all_stocks(self): pass
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### conn = op.get_bind() inspector = Inspector.from_engine(conn) tables = inspector.get_table_names() if 'schedule_data' not in tables: op.create_table('schedule_data', sa.Column('id', sa.Integer(), nullable=False), sa.Column('device_id', sa.Integer(), nullable=True), sa.Column('start_schedule', sa.Time(), nullable=True), sa.Column('end_schedule', sa.Time(), nullable=True), sa.Column('last_state', sa.Integer(), nullable=True), sa.Column('manual_schedule', sa.Integer(), nullable=True), sa.Column('enable_schedule', sa.Integer(), nullable=True), sa.PrimaryKeyConstraint('id') ) if 'sensor_data' not in tables: op.create_table('sensor_data', sa.Column('id', sa.Integer(), nullable=False), sa.Column('air_temp', sa.Integer(), nullable=True), sa.Column('humidity', sa.Numeric(), nullable=True), sa.Column('moister', sa.Numeric(), nullable=True), sa.Column('created_date', sa.DateTime(timezone=True), server_default=sa.text('now()'), nullable=True), sa.PrimaryKeyConstraint('id') )
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.create_table( 'device', sa.Column('id', sa.Integer(), nullable=False), sa.Column('device_name', sa.String(length=256), nullable=False), sa.Column('hostname', sa.String(length=256), nullable=True), sa.Column('min_activity_duration', sa.Integer(), nullable=True), sa.Column('max_active_ping_delay', sa.Integer(), nullable=True), sa.Column('sample_size', sa.Integer(), nullable=True), sa.PrimaryKeyConstraint('id')) op.create_table( 'user', sa.Column('id', sa.Integer(), nullable=False), sa.Column('process_name_pattern', sa.String(length=256), nullable=True), sa.Column('username', sa.String(length=256), nullable=True), sa.Column('first_name', sa.String(length=256), nullable=True), sa.Column('last_name', sa.String(length=256), nullable=True), sa.Column('locale', sa.String(length=5), nullable=True), sa.Column('active', sa.Boolean(), nullable=True), sa.PrimaryKeyConstraint('id')) op.create_table( 'ruleset', sa.Column('id', sa.Integer(), nullable=False), sa.Column('context_label', sa.String(length=256), nullable=True), sa.Column('context', sa.String(length=256), nullable=True), sa.Column('context_details', sa.String(length=256), nullable=True), sa.Column('priority', sa.Integer(), nullable=False), sa.Column('user_id', sa.Integer(), nullable=False), sa.Column('min_time_of_day', sa.Time(), nullable=True), sa.Column('max_time_of_day', sa.Time(), nullable=True), sa.Column('max_time_per_day', sa.Integer(), nullable=True), sa.Column('max_activity_duration', sa.Integer(), nullable=True), sa.Column('min_break', sa.Integer(), nullable=True), sa.Column('free_play', sa.Boolean(), nullable=True), sa.ForeignKeyConstraint( ['user_id'], ['user.id'], ), sa.PrimaryKeyConstraint('id')) op.create_table('user2device', sa.Column('id', sa.Integer(), nullable=False), sa.Column('active', sa.Boolean(), nullable=True), sa.Column('percent', sa.Integer(), nullable=True), sa.Column('user_id', sa.Integer(), nullable=False), sa.Column('device_id', sa.Integer(), nullable=False), sa.ForeignKeyConstraint( ['device_id'], ['device.id'], ), sa.ForeignKeyConstraint( ['user_id'], ['user.id'], ), sa.PrimaryKeyConstraint('id')) # op.alter_column('admin_event', 'downtime', # existing_type=mysql.INTEGER(display_width=11), # nullable=True, # existing_server_default=sa.text("'0'")) op.add_column( 'process_info', sa.Column('percent', sa.Integer(), server_default='100', nullable=True))
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.add_column('artist_available_times', sa.Column('time_from', sa.Time(), nullable=False)) op.add_column('artist_available_times', sa.Column('time_to', sa.Time(), nullable=False)) op.drop_column('artist_available_times', 'available_time_from') op.drop_column('artist_available_times', 'available_time_to')
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.create_table('class_info', sa.Column('id', sa.Integer(), nullable=False), sa.Column('name', sa.Text(), nullable=True), sa.Column('units', sa.Integer(), nullable=True), sa.PrimaryKeyConstraint('id')) op.create_table('instructor', sa.Column('id', sa.Integer(), nullable=False), sa.Column('name', sa.Text(), nullable=True), sa.PrimaryKeyConstraint('id')) op.create_table('schedule', sa.Column('id', sa.Integer(), nullable=False), sa.PrimaryKeyConstraint('id')) op.create_table('time_slot', sa.Column('id', sa.Integer(), nullable=False), sa.Column('start_time', sa.Time(), nullable=True), sa.Column('end_time', sa.Time(), nullable=True), sa.Column('day_of_week', sa.Integer(), nullable=True), sa.PrimaryKeyConstraint('id')) op.create_table( 'class_schedule', sa.Column('id', sa.Integer(), nullable=False), sa.Column('code', sa.Integer(), nullable=True), sa.Column('class_info_id', sa.Integer(), nullable=True), sa.Column('schedule_id', sa.Integer(), nullable=True), sa.Column('available_slots', sa.Integer(), nullable=True), sa.Column('total_slots', sa.Integer(), nullable=True), sa.Column('demand', sa.Integer(), nullable=True), sa.Column('restrictions', sa.Text(), nullable=True), sa.Column('remarks', sa.Text(), nullable=True), sa.Column('last_updated', sa.Time(), nullable=True), sa.ForeignKeyConstraint( ['class_info_id'], ['class_info.id'], ), sa.ForeignKeyConstraint( ['schedule_id'], ['schedule.id'], ), sa.PrimaryKeyConstraint('id')) op.create_table( 'schedule_timeslot_association', sa.Column('time_slot_id', sa.Integer(), nullable=True), sa.Column('schedule_id', sa.Integer(), nullable=True), sa.ForeignKeyConstraint( ['schedule_id'], ['schedule.id'], ), sa.ForeignKeyConstraint( ['time_slot_id'], ['time_slot.id'], )) op.create_table( 'instructor_class_schedule_association', sa.Column('instructor_id', sa.Integer(), nullable=True), sa.Column('class_schedule_id', sa.Integer(), nullable=True), sa.ForeignKeyConstraint( ['class_schedule_id'], ['class_schedule.id'], ), sa.ForeignKeyConstraint( ['instructor_id'], ['instructor.id'], ))
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.add_column('Course', sa.Column('course_day', sa.String(length=60), nullable=True)) op.add_column('Course', sa.Column('course_end_time', sa.Time(), nullable=True)) op.add_column('Course', sa.Column('course_start_time', sa.Time(), nullable=True)) op.execute('ALTER TABLE Tuition MODIFY tuition_degree VARCHAR(60) NOT NULL') # op.drop_constraint('Tuition_ibfk_1', 'Tuition', type_='foreignkey') op.execute('ALTER TABLE Tuition DROP PRIMARY KEY, \ ADD PRIMARY KEY (tuition_semester, tuition_year, faculty_id, tuition_degree)')
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.add_column('channels', sa.Column('count_of_publications', sa.Integer(), nullable=True)) op.add_column('channels', sa.Column('end_time_publications', sa.Time(), nullable=True)) op.add_column('channels', sa.Column('start_time_publications', sa.Time(), nullable=True)) op.add_column('donors', sa.Column('channel_id', sa.Integer(), nullable=True)) op.create_foreign_key(None, 'donors', 'channels', ['channel_id'], ['id']) op.add_column('posts', sa.Column('video', sa.ARRAY(sa.String()), nullable=True)) op.drop_column('posts', 'Video')
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.create_table('timetable', sa.Column('timetable_id', sa.BigInteger(), nullable=False), sa.Column('week_day', sa.Enum('ПН', 'ВТ', 'СР', 'ЧТ', 'ПТ', name='enum'), nullable=True), sa.Column('time_from', sa.Time(), nullable=True), sa.Column('time_to', sa.Time(), nullable=True), sa.PrimaryKeyConstraint('timetable_id') )
def upgrade(): ### commands auto generated by Alembic - please adjust! ### op.create_unique_constraint(None, 'agencies', ['abbreviation']) op.create_unique_constraint(None, 'agencies', ['name']) op.add_column('messages', sa.Column('date', sa.Date(), nullable=True)) op.add_column('messages', sa.Column('time', sa.Time(), nullable=True)) op.create_unique_constraint(None, 'modules', ['abbreviation']) op.create_unique_constraint(None, 'modules', ['name']) op.add_column('results', sa.Column('time', sa.Time(), nullable=True))
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.create_table('order_sheet', sa.Column('id', sa.Integer(), nullable=False), sa.Column('upload_date', sa.DateTime(), server_default=sa.text('(CURRENT_TIMESTAMP)'), nullable=True), sa.PrimaryKeyConstraint('id') ) op.create_table('truck_sheet', sa.Column('id', sa.Integer(), nullable=False), sa.Column('upload_date', sa.DateTime(), server_default=sa.text('(CURRENT_TIMESTAMP)'), nullable=True), sa.PrimaryKeyConstraint('id') ) op.create_table('truck', sa.Column('s_number', sa.Integer(), nullable=False), sa.Column('sheet_id', sa.Integer(), nullable=True), sa.Column('truck_id', sa.String(), nullable=False), sa.Column('availability', sa.Boolean(), nullable=False), sa.Column('truck_type', sa.String(), nullable=False), sa.Column('business_type', sa.String(), nullable=False), sa.Column('terminal', sa.String(), nullable=False), sa.Column('hierarchy', sa.Float(), nullable=False), sa.Column('use_cost', sa.Float(), nullable=False), sa.Column('date', sa.Date(), nullable=False), sa.Column('starting_time', sa.Time(), nullable=False), sa.ForeignKeyConstraint(['sheet_id'], ['truck_sheet.id'], ondelete='CASCADE'), sa.PrimaryKeyConstraint('s_number') ) op.create_table('order', sa.Column('order_number', sa.Integer(), nullable=False), sa.Column('sheet_id', sa.Integer(), nullable=True), sa.Column('inl_terminal', sa.String(), nullable=False), sa.Column('truck_type', sa.String(), nullable=False), sa.Column('hierarchy', sa.Float(), nullable=False), sa.Column('delivery_deadline', sa.Time(), nullable=False), sa.Column('driving_time', sa.Integer(), nullable=False), sa.Column('process_time', sa.Integer(), nullable=False), sa.Column('departure_time', sa.Time(), nullable=True), sa.Column('truck_s_number', sa.Integer(), nullable=True), sa.ForeignKeyConstraint(['truck_s_number'], ['truck.s_number']), sa.ForeignKeyConstraint(['sheet_id'], ['order_sheet.id'], ondelete='CASCADE'), sa.PrimaryKeyConstraint('order_number') )
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.create_table( 'listings', sa.Column('id', sa.Integer(), nullable=False), sa.Column('title', sa.String(length=255), nullable=True), sa.Column('location', sa.String(length=255), nullable=True), sa.Column('description', sa.String(length=255), nullable=True), sa.Column('category', sa.String(length=255), nullable=True), sa.Column('bedrooms', sa.String(length=255), nullable=True), sa.Column('pricing', sa.Integer(), nullable=True), sa.Column('lister_id', sa.Integer(), nullable=False), sa.ForeignKeyConstraint( ['lister_id'], ['users.id'], ), sa.PrimaryKeyConstraint('id')) op.create_table('images', sa.Column('id', sa.Integer(), nullable=False), sa.Column('title', sa.String(length=255), nullable=True), sa.Column('image_path', sa.String(), nullable=True), sa.Column('listing_id', sa.Integer(), nullable=True), sa.ForeignKeyConstraint( ['listing_id'], ['listings.id'], ), sa.PrimaryKeyConstraint('id')) op.create_table('timeslots', sa.Column('id', sa.Integer(), nullable=False), sa.Column('date', sa.Date(), nullable=True), sa.Column('start_time', sa.Time(), nullable=True), sa.Column('end_time', sa.Time(), nullable=True), sa.Column('listing_id', sa.Integer(), nullable=True), sa.ForeignKeyConstraint( ['listing_id'], ['listings.id'], ), sa.PrimaryKeyConstraint('id')) op.create_table( 'booking', sa.Column('id', sa.Integer(), nullable=False), sa.Column('name', sa.String(length=255), nullable=True), sa.Column('email', sa.String(length=255), nullable=True), sa.Column('contact', sa.Integer(), nullable=True), sa.Column('listing_id', sa.Integer(), nullable=True), sa.Column('lister_id', sa.Integer(), nullable=True), sa.Column('timeslot_id', sa.Integer(), nullable=False), sa.ForeignKeyConstraint( ['lister_id'], ['users.id'], ), sa.ForeignKeyConstraint( ['listing_id'], ['listings.id'], ), sa.ForeignKeyConstraint( ['timeslot_id'], ['timeslots.id'], ), sa.PrimaryKeyConstraint('id')) op.add_column('users', sa.Column('bio', sa.String(length=255), nullable=True)) op.add_column('users', sa.Column('contact', sa.String(length=255), nullable=True)) op.add_column('users', sa.Column('profile_pic_path', sa.String(), nullable=True))
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.create_table('timetable', sa.Column('timetable_id', sa.BigInteger(), nullable=False), sa.Column('week_day', sa.Enum('пн', 'вт', 'ср', 'чт', 'пт', 'сб', 'вс', name='enum'), nullable=False), sa.Column('time_from', sa.Time(), nullable=True), sa.Column('time_to', sa.Time(), nullable=True), sa.PrimaryKeyConstraint('timetable_id'), sa.UniqueConstraint('week_day') )
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.create_table( 'mbuses', sa.Column('id', sa.Integer(), nullable=False), sa.Column('name', sa.String(length=64), nullable=True), sa.Column('cz_name', sa.String(length=64), nullable=True), sa.Column('cz_phone', sa.String(length=30), nullable=True), sa.Column('sj_name', sa.String(length=64), nullable=True), sa.Column('sj_phone', sa.String(length=64), nullable=True), sa.Column('seat_num', sa.Integer(), nullable=True), sa.Column('equip_id', sa.Integer(), nullable=True), sa.Column('lat', sa.Float(precision='11,8'), nullable=True), sa.Column('lon', sa.Float(precision='11,8'), nullable=True), sa.Column('recordtime', sa.Time(), nullable=True), sa.PrimaryKeyConstraint('id')) op.create_index(op.f('ix_mbuses_name'), 'mbuses', ['name'], unique=False) op.create_table('musers', sa.Column('id', sa.Integer(), nullable=False), sa.Column('mailaddr', sa.String(length=64), nullable=True), sa.PrimaryKeyConstraint('id')) op.create_table( 'mstations', sa.Column('id', sa.Integer(), nullable=False), sa.Column('name', sa.String(length=64), nullable=True), sa.Column('description', sa.Text(), nullable=True), sa.Column('time', sa.Time(), nullable=True), sa.Column('dirtocompany', sa.Boolean(), nullable=True), sa.Column('lat', sa.Float(precision='11,8'), nullable=True), sa.Column('lon', sa.Float(precision='11,8'), nullable=True), sa.Column('bus_id', sa.Integer(), nullable=True), sa.ForeignKeyConstraint( ['bus_id'], ['mbuses.id'], ), sa.PrimaryKeyConstraint('id')) op.create_index(op.f('ix_mstations_name'), 'mstations', ['name'], unique=False) op.create_table( 'diagrams', sa.Column('id', sa.Integer(), nullable=False), sa.Column('mdate', sa.Time(), nullable=True), sa.Column('arrive_time', sa.Time(), nullable=True), sa.Column('current_num', sa.Integer(), nullable=True), sa.Column('station_id', sa.Integer(), nullable=True), sa.ForeignKeyConstraint( ['station_id'], ['mstations.id'], ), sa.PrimaryKeyConstraint('id')) op.create_table( 'registration', sa.Column('user_id', sa.Integer(), nullable=True), sa.Column('station_id', sa.Integer(), nullable=True), sa.ForeignKeyConstraint( ['station_id'], ['mstations.id'], ), sa.ForeignKeyConstraint( ['user_id'], ['mbuses.id'], ))
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.create_table( 'chats', sa.Column('cid', sa.Integer(), nullable=False), sa.Column('chatname', sa.String(length=256), nullable=True), sa.Column('timestamp', sa.DateTime(), nullable=True), sa.PrimaryKeyConstraint('cid')) op.create_index(op.f('ix_chats_timestamp'), 'chats', ['timestamp'], unique=False) op.create_table( 'users', sa.Column('uid', sa.Integer(), nullable=False), sa.Column('username', sa.String(length=64), nullable=True), sa.Column('timestamp', sa.Time(), nullable=True), sa.Column('email', sa.String(length=128), nullable=True), sa.Column('password_hash', sa.String(length=128), nullable=True), sa.PrimaryKeyConstraint('uid')) op.create_index(op.f('ix_users_email'), 'users', ['email'], unique=True) op.create_index(op.f('ix_users_timestamp'), 'users', ['timestamp'], unique=False) op.create_index(op.f('ix_users_username'), 'users', ['username'], unique=True) op.create_table('messages', sa.Column('mid', sa.Integer(), nullable=False), sa.Column('timestamp', sa.DateTime(), nullable=True), sa.Column('text', sa.String(length=256), nullable=True), sa.Column('userfrom', sa.Integer(), nullable=True), sa.Column('cid', sa.Integer(), nullable=True), sa.ForeignKeyConstraint( ['cid'], ['chats.cid'], ), sa.ForeignKeyConstraint( ['userfrom'], ['users.uid'], ), sa.PrimaryKeyConstraint('mid')) op.create_index(op.f('ix_messages_timestamp'), 'messages', ['timestamp'], unique=False) op.create_table('userschat', sa.Column('ucid', sa.Integer(), nullable=False), sa.Column('timestamp', sa.Time(), nullable=True), sa.Column('users_uid', sa.Integer(), nullable=True), sa.Column('chats_cid', sa.Integer(), nullable=True), sa.ForeignKeyConstraint( ['chats_cid'], ['chats.cid'], ), sa.ForeignKeyConstraint( ['users_uid'], ['users.uid'], ), sa.PrimaryKeyConstraint('ucid')) op.create_index(op.f('ix_userschat_timestamp'), 'userschat', ['timestamp'], unique=False)
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.create_table( 'dealer', sa.Column('id', sa.Integer(), autoincrement=True, nullable=False), sa.Column('public_id', sa.String(length=128), nullable=True), sa.Column('internal_id', sa.String(length=100), nullable=False), sa.Column('brand', sa.String(length=50), nullable=False), sa.Column('name', sa.String(length=128), nullable=False), sa.Column('street_address', sa.String(length=250), nullable=True), sa.Column('city', sa.String(length=50), nullable=True), sa.Column('state', sa.String(length=50), nullable=True), sa.Column('postal_code', sa.Integer(), nullable=True), sa.Column('country', sa.String(length=50), nullable=True), sa.Column('latitude', sa.Float(), nullable=True), sa.Column('longitude', sa.Float(), nullable=True), sa.Column('phone', sa.String(length=25), nullable=True), sa.Column('email', sa.String(length=50), nullable=True), sa.Column('website', sa.String(length=50), nullable=True), sa.Column('created_datetime', sa.DateTime(), nullable=True), sa.Column('modified_datetime', sa.DateTime(), nullable=True), sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('public_id')) op.create_table( 'service', sa.Column('id', sa.Integer(), autoincrement=True, nullable=False), sa.Column('public_id', sa.String(length=128), nullable=True), sa.Column('service_name', sa.String(length=250), nullable=False), sa.Column('created_datetime', sa.DateTime(), nullable=True), sa.Column('modified_datetime', sa.DateTime(), nullable=True), sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('public_id')) op.create_table( 'dealer_hours', sa.Column('id', sa.Integer(), autoincrement=True, nullable=False), sa.Column('public_id', sa.String(length=128), nullable=True), sa.Column('dealer_id', sa.Integer(), nullable=False), sa.Column('day_of_week', sa.String(length=25), nullable=False), sa.Column('open_time', sa.Time(), nullable=True), sa.Column('close_time', sa.Time(), nullable=True), sa.Column('schedule_type', sa.String(length=25), nullable=False), sa.Column('created_datetime', sa.DateTime(), nullable=True), sa.Column('modified_datetime', sa.DateTime(), nullable=True), sa.ForeignKeyConstraint(['dealer_id'], ['dealer.id'], ondelete='CASCADE'), sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('public_id')) op.create_table( 'dealer_service', sa.Column('dealer_id', sa.Integer(), nullable=False), sa.Column('service_id', sa.Integer(), nullable=False), sa.Column('created_datetime', sa.DateTime(), nullable=True), sa.Column('modified_datetime', sa.DateTime(), nullable=True), sa.ForeignKeyConstraint(['dealer_id'], ['dealer.id'], ondelete='CASCADE'), sa.ForeignKeyConstraint(['service_id'], ['service.id'], ondelete='CASCADE'), sa.PrimaryKeyConstraint('dealer_id', 'service_id'))
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.create_table( 'availabilities', sa.Column('id', sa.Integer(), nullable=False), sa.Column('artist_id', sa.Integer(), nullable=False), sa.Column('start_time', sa.Time(timezone=True), nullable=True), sa.Column('end_time', sa.Time(timezone=True), nullable=True), sa.ForeignKeyConstraint( ['artist_id'], ['artists.id'], ), sa.PrimaryKeyConstraint('id'))
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.create_table( 'establishments', sa.Column('id', sa.Integer(), nullable=False), sa.Column('name', sa.String(length=255), nullable=True), sa.Column('location', sa.String(length=255), nullable=True), sa.Column('description', sa.Text(), nullable=True), sa.Column('open_time', sa.Time(), nullable=True), sa.Column('end_time', sa.Time(), nullable=True), sa.Column('img_url', sa.String(length=255), nullable=True), sa.PrimaryKeyConstraint('id'))
def upgrade(): op.create_table( "scheduled_service_addition", sa.Column("pk", sa.Integer(), nullable=False), sa.Column("service_pk", sa.Integer(), nullable=True), sa.Column("date", sa.Date(), nullable=False), sa.ForeignKeyConstraint( ["service_pk"], ["scheduled_service.pk"], ), sa.PrimaryKeyConstraint("pk"), ) op.create_index( op.f("ix_scheduled_service_addition_service_pk"), "scheduled_service_addition", ["service_pk"], unique=False, ) op.create_table( "scheduled_service_removal", sa.Column("pk", sa.Integer(), nullable=False), sa.Column("service_pk", sa.Integer(), nullable=True), sa.Column("date", sa.Date(), nullable=False), sa.ForeignKeyConstraint( ["service_pk"], ["scheduled_service.pk"], ), sa.PrimaryKeyConstraint("pk"), ) op.create_index( op.f("ix_scheduled_service_removal_service_pk"), "scheduled_service_removal", ["service_pk"], unique=False, ) op.add_column("scheduled_service", sa.Column("end_date", sa.Date(), nullable=True)) op.add_column("scheduled_service", sa.Column("start_date", sa.Date(), nullable=True)) op.create_table( "scheduled_trip_frequency", sa.Column("pk", sa.Integer(), nullable=False), sa.Column("trip_pk", sa.Integer(), nullable=False), sa.Column("start_time", sa.Time(timezone=True), nullable=False), sa.Column("end_time", sa.Time(timezone=True), nullable=False), sa.Column("headway", sa.Integer(), nullable=False), sa.Column("frequency_based", sa.Boolean(), nullable=False), sa.ForeignKeyConstraint( ["trip_pk"], ["scheduled_trip.pk"], ), sa.PrimaryKeyConstraint("pk"), )
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.create_table('artist_available_times', sa.Column('id', sa.Integer(), nullable=False), sa.Column('artist_id', sa.Integer(), nullable=False), sa.Column('date', sa.Date(), nullable=False), sa.Column('available_time_from', sa.Time(), nullable=False), sa.Column('available_time_to', sa.Time(), nullable=False), sa.ForeignKeyConstraint(['artist_id'], ['artists.id'], ), sa.PrimaryKeyConstraint('id') )
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.create_table( 'rooms', sa.Column('id', sa.BigInteger(), autoincrement=True, nullable=False), sa.Column('room', sa.String(length=250), nullable=False), sa.Column('location', sa.String(length=250), nullable=False), sa.Column('capacity', sa.String(length=250), nullable=False), sa.Column('created_at', sa.DateTime(), nullable=True), sa.Column('updated_at', sa.DateTime(), nullable=True), sa.PrimaryKeyConstraint('id')) op.create_index(op.f('ix_rooms_created_at'), 'rooms', ['created_at'], unique=False) op.create_index(op.f('ix_rooms_updated_at'), 'rooms', ['updated_at'], unique=False) op.create_table( 'users', sa.Column('id', sa.BigInteger(), autoincrement=True, nullable=False), sa.Column('name', sa.String(length=230), nullable=False), sa.Column('role', sa.String(length=230), nullable=False), sa.Column('department', sa.String(length=250), nullable=False), sa.Column('email', sa.String(length=120), nullable=False), sa.Column('password', sa.String(length=128), nullable=False), sa.Column('created_at', sa.DateTime(), nullable=True), sa.Column('updated_at', sa.DateTime(), nullable=True), sa.PrimaryKeyConstraint('id')) op.create_index(op.f('ix_users_email'), 'users', ['email'], unique=True) op.create_table( 'bookings', sa.Column('id', sa.BigInteger(), autoincrement=True, nullable=False), sa.Column('room_id', sa.BigInteger(), nullable=True), sa.Column('user_id', sa.BigInteger(), nullable=True), sa.Column('booking_date', sa.Date(), nullable=False), sa.Column('booking_time_start', sa.Time(), nullable=False), sa.Column('booking_time_end', sa.Time(), nullable=False), sa.Column('extra_information', sa.Time(), nullable=False), sa.Column('status', sa.String(length=250), nullable=False), sa.Column('created_at', sa.DateTime(), nullable=True), sa.Column('updated_at', sa.DateTime(), nullable=True), sa.ForeignKeyConstraint( ['room_id'], ['rooms.id'], ), sa.ForeignKeyConstraint( ['user_id'], ['users.id'], ), sa.PrimaryKeyConstraint('id')) op.create_index(op.f('ix_bookings_created_at'), 'bookings', ['created_at'], unique=False) op.create_index(op.f('ix_bookings_updated_at'), 'bookings', ['updated_at'], unique=False)
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.create_table( 'Restaurant', sa.Column('id', sa.Integer(), autoincrement=True, nullable=False), sa.Column('name', sa.String(length=100), nullable=True), sa.Column('address', sa.String(length=100), nullable=True), sa.Column('city', sa.String(length=100), nullable=True), sa.Column('lat', sa.Float(), nullable=True), sa.Column('lon', sa.Float(), nullable=True), sa.Column('phone', sa.String(length=25), nullable=True), sa.Column('menu_type', sa.String(length=100), nullable=True), sa.Column('measures', sa.Unicode(), nullable=True), sa.Column('is_open', sa.Boolean(), nullable=True), sa.Column('owner_id', sa.Integer(), nullable=True), sa.Column('avg_stay', sa.Integer(), nullable=True), sa.PrimaryKeyConstraint('id')) op.create_table( 'Like', sa.Column('liker_id', sa.Integer(), nullable=False), sa.Column('restaurant_id', sa.Integer(), nullable=False), sa.Column('timestamp', sa.DateTime(), nullable=True), sa.ForeignKeyConstraint(['restaurant_id'], ['Restaurant.id'], ondelete='CASCADE'), sa.PrimaryKeyConstraint('liker_id', 'restaurant_id')) op.create_table( 'RestaurantAvailability', sa.Column('id', sa.Integer(), autoincrement=True, nullable=False), sa.Column('start_time', sa.Time(), nullable=True), sa.Column('end_time', sa.Time(), nullable=True), sa.Column('day', sa.String(length=10), nullable=True), sa.Column('restaurant_id', sa.Integer(), nullable=True), sa.ForeignKeyConstraint(['restaurant_id'], ['Restaurant.id'], ondelete='CASCADE'), sa.PrimaryKeyConstraint('id')) op.create_table( 'RestaurantRating', sa.Column('customer_id', sa.Integer(), nullable=False), sa.Column('customer_name', sa.String(length=200), nullable=True), sa.Column('restaurant_id', sa.Integer(), nullable=False), sa.Column('value', sa.Integer(), nullable=False), sa.Column('review', sa.String(length=200), nullable=True), sa.Column('timestamp', sa.DateTime(), nullable=True), sa.ForeignKeyConstraint( ['restaurant_id'], ['Restaurant.id'], ), sa.PrimaryKeyConstraint('customer_id', 'restaurant_id')) op.create_table( 'Table', sa.Column('id', sa.Integer(), autoincrement=True, nullable=False), sa.Column('restaurant_id', sa.Integer(), nullable=True), sa.Column('capacity', sa.Integer(), nullable=True), sa.ForeignKeyConstraint(['restaurant_id'], ['Restaurant.id'], ondelete='CASCADE'), sa.PrimaryKeyConstraint('id'))