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