variphx's picture
fix: change table schemas to match submission requirements and migrate some module names
68fc6df
raw
history blame contribute delete
263 Bytes
CREATE TABLE keyframes (
id BIGINT GENERATED ALWAYS AS IDENTITY PRIMARY KEY,
name TEXT NOT NULL,
frame_index BIGINT NOT NULL,
frame_timestamp REAL NOT NULL,
video_id BIGINT NOT NULL REFERENCES videos (id),
UNIQUE (video_id, frame_index)
)