4 lines
384 B
SQL
4 lines
384 B
SQL
ALTER TABLE lesson_sessions ADD COLUMN user_id VARCHAR(64) REFERENCES users(id);
|
|
UPDATE lesson_sessions SET user_id = (select user_id from music_sessions where lesson_sessions.id = music_sessions.lesson_session_id) where user_id is NULL;
|
|
ALTER TABLE lesson_sessions ALTER COLUMN user_id SET NOT NULL;
|
|
CREATE INDEX msuh_client_id ON music_sessions_user_history USING btree (client_id); |