jam-cloud/db/up/track_download_counts.sql

5 lines
310 B
SQL

ALTER TABLE recorded_tracks ADD COLUMN download_count INTEGER NOT NULL DEFAULT 0;
ALTER TABLE recorded_tracks ADD COLUMN last_downloaded_at TIMESTAMP;
ALTER TABLE mixes ADD COLUMN download_count INTEGER NOT NULL DEFAULT 0;
ALTER TABLE mixes ADD COLUMN last_downloaded_at TIMESTAMP;