24 lines
828 B
MySQL
24 lines
828 B
MySQL
|
ALTER TABLE jam_sessions DROP COLUMN public;
|
||
|
|
|
||
|
|
-- rename 'name' to 'description' to match product specification terminology
|
||
|
|
ALTER TABLE jam_sessions RENAME name TO description;
|
||
|
|
|
||
|
|
-- rename jam_sessions to more generic 'music_sessions'
|
||
|
|
ALTER TABLE jam_sessions RENAME TO music_sessions;
|
||
|
|
|
||
|
|
-- get rid of early version of member table
|
||
|
|
DROP TABLE jam_session_members;
|
||
|
|
|
||
|
|
-- one row is created per connected client
|
||
|
|
CREATE TABLE music_session_clients (
|
||
|
|
id VARCHAR(64) PRIMARY KEY DEFAULT uuid_generate_v4(),
|
||
|
|
user_id VARCHAR(64) REFERENCES users(id) ON DELETE CASCADE,
|
||
|
|
music_session_id VARCHAR(64) REFERENCES music_sessions(id) ON DELETE CASCADE,
|
||
|
|
ip_address VARCHAR(64) NOT NULL,
|
||
|
|
created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
||
|
|
updated_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP
|
||
|
|
);
|
||
|
|
|
||
|
|
|
||
|
|
|