max / makenotwork

469 B · 10 lines History Blame Raw

1	-- Video item support: direct-file video upload and playback.
2	-- Video items store their file in S3 (video_s3_key) and reuse the existing
3	-- cover_s3_key/cover_image_url fields for the poster image.
4
5	ALTER TABLE items ADD COLUMN video_s3_key TEXT;
6	ALTER TABLE items ADD COLUMN video_file_size_bytes BIGINT;
7	ALTER TABLE items ADD COLUMN video_duration_seconds INTEGER;
8	ALTER TABLE items ADD COLUMN video_width INTEGER;
9	ALTER TABLE items ADD COLUMN video_height INTEGER;
10