InboxIQ/migrations_v4.sql at main · sridhar-3009/InboxIQ · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
-- ============================================================
-- InboxIQ v4 Migrations — Run in Supabase SQL Editor
-- ============================================================

-- HubSpot integration
ALTER TABLE user_profiles ADD COLUMN IF NOT EXISTS hubspot_connected BOOLEAN DEFAULT FALSE;
ALTER TABLE user_profiles ADD COLUMN IF NOT EXISTS hubspot_api_key TEXT;

-- Salesforce integration
ALTER TABLE user_profiles ADD COLUMN IF NOT EXISTS sf_connected BOOLEAN DEFAULT FALSE;
ALTER TABLE user_profiles ADD COLUMN IF NOT EXISTS sf_consumer_key TEXT;
ALTER TABLE user_profiles ADD COLUMN IF NOT EXISTS sf_consumer_secret TEXT;
ALTER TABLE user_profiles ADD COLUMN IF NOT EXISTS sf_username TEXT;
ALTER TABLE user_profiles ADD COLUMN IF NOT EXISTS sf_password TEXT;
ALTER TABLE user_profiles ADD COLUMN IF NOT EXISTS sf_security_token TEXT;