/ db / migrations / 085-conversations-site-timestamps.sql
085-conversations-site-timestamps.sql
1  -- Add site_id, created_at, updated_at to conversations table
2  -- Required for report-delivery.js to log report delivery events
3  
4  ALTER TABLE conversations ADD COLUMN site_id INTEGER REFERENCES sites(id);
5  ALTER TABLE conversations ADD COLUMN created_at DATETIME;
6  ALTER TABLE conversations ADD COLUMN updated_at DATETIME;