35 lines
2.5 KiB
MySQL
35 lines
2.5 KiB
MySQL
|
ALTER TABLE chat_messages DROP COLUMN lesson_booking_id;
|
||
|
|
ALTER TABLE chat_messages ADD COLUMN lesson_session_id VARCHAR(64) REFERENCES lesson_sessions(id);
|
||
|
|
ALTER TABLE lesson_sessions ADD COLUMN teacher_unread_messages BOOLEAN DEFAULT FALSE NOT NULL;
|
||
|
|
ALTER TABLE lesson_sessions ADD COLUMN student_unread_messages BOOLEAN DEFAULT FALSE NOT NULL;
|
||
|
|
ALTER TABLE chat_messages ADD COLUMN purpose VARCHAR(200);
|
||
|
|
ALTER TABLE lesson_sessions ADD COLUMN student_short_canceled BOOLEAN DEFAULT FALSE NOT NULL;
|
||
|
|
ALTER TABLE lesson_sessions ADD COLUMN teacher_short_canceled BOOLEAN DEFAULT FALSE NOT NULL;
|
||
|
|
ALTER TABLE lesson_sessions ADD COLUMN sent_starting_notice BOOLEAN DEFAULT FALSE NOT NULL;
|
||
|
|
|
||
|
|
ALTER TABLE lesson_bookings DROP CONSTRAINT lesson_bookings_counter_slot_id_fkey;
|
||
|
|
ALTER TABLE lesson_bookings ADD CONSTRAINT lesson_bookings_counter_slot_id_fkey FOREIGN KEY (counter_slot_id) REFERENCES lesson_booking_slots(id) ON DELETE CASCADE;
|
||
|
|
|
||
|
|
ALTER TABLE lesson_bookings DROP CONSTRAINT lesson_bookings_default_slot_id_fkey;
|
||
|
|
ALTER TABLE lesson_bookings ADD CONSTRAINT lesson_bookings_default_slot_id_fkey FOREIGN KEY (default_slot_id) REFERENCES lesson_booking_slots(id) ON DELETE CASCADE;
|
||
|
|
|
||
|
|
|
||
|
|
ALTER TABLE lesson_sessions DROP CONSTRAINT lesson_sessions_slot_id_fkey;
|
||
|
|
ALTER TABLE lesson_sessions ADD CONSTRAINT lesson_sessions_slot_id_fkey FOREIGN KEY (slot_id) REFERENCES lesson_booking_slots(id) ON DELETE CASCADE;
|
||
|
|
|
||
|
|
ALTER TABLE users DROP CONSTRAINT users_teacher_id_fkey;
|
||
|
|
ALTER TABLE users ADD CONSTRAINT users_teacher_id_fkey FOREIGN KEY (teacher_id) REFERENCES teachers(id) ON DELETE CASCADE;
|
||
|
|
|
||
|
|
ALTER TABLE music_sessions DROP CONSTRAINT music_sessions_lesson_session_id_fkey;
|
||
|
|
ALTER TABLE music_sessions ADD CONSTRAINT music_sessions_lesson_session_id_fkey FOREIGN KEY (lesson_session_id) REFERENCES lesson_sessions(id) ON DELETE SET NULL;
|
||
|
|
|
||
|
|
ALTER TABLE notifications DROP CONSTRAINT notifications_lesson_session_id_fkey;
|
||
|
|
ALTER TABLE notifications ADD CONSTRAINT notifications_lesson_session_id_fkey FOREIGN KEY (lesson_session_id) REFERENCES lesson_sessions(id) ON DELETE CASCADE;
|
||
|
|
|
||
|
|
ALTER TABLE chat_messages DROP CONSTRAINT chat_messages_lesson_session_id_fkey;
|
||
|
|
ALTER TABLE chat_messages ADD CONSTRAINT chat_messages_lesson_session_id_fkey FOREIGN KEY (lesson_session_id) REFERENCES lesson_sessions(id) ON DELETE CASCADE;
|
||
|
|
|
||
|
|
ALTER TABLE chat_messages DROP CONSTRAINT chat_messages_target_user_id_fkey;
|
||
|
|
ALTER TABLE chat_messages ADD CONSTRAINT chat_messages_target_user_id_fkey FOREIGN KEY (lesson_session_id) REFERENCES lesson_sessions(id) ON DELETE SET NULL;
|
||
|
|
|