000003_remove_users.up.sql

 1ALTER TABLE videos ADD COLUMN IF NOT EXISTS watch_timestamp timestamp with time zone DEFAULT NULL;
 2
 3UPDATE videos
 4  SET watch_timestamp = user_videos.watch_timestamp
 5  FROM user_videos
 6  WHERE videos.id = user_videos.video_id;
 7
 8DROP TABLE IF EXISTS user_subscriptions;
 9DROP TABLE IF EXISTS user_videos;
10DROP TABLE IF EXISTS users;