9 lines
384 B
MySQL
9 lines
384 B
MySQL
|
-- offset is milliseconds
|
||
|
|
CREATE TABLE jam_track_tap_ins (
|
||
|
|
id VARCHAR(64) PRIMARY KEY DEFAULT uuid_generate_v4(),
|
||
|
|
offset_time INTEGER NOT NULL,
|
||
|
|
jam_track_id BIGINT NOT NULL REFERENCES jam_tracks(id) ON DELETE CASCADE
|
||
|
|
);
|
||
|
|
|
||
|
|
ALTER TABLE jam_tracks ADD COLUMN tap_in_count INTEGER NOT NULL DEFAULT 0;
|
||
|
|
ALTER TABLE jam_tracks ADD COLUMN initial_play_silence DECIMAL NOT NULL DEFAULT 5;
|