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;