CREATE TABLE "activity_logs" ( "id" serial PRIMARY KEY NOT NULL, "team_id" integer NOT NULL, "user_id" integer, "action" text NOT NULL, "timestamp" timestamp DEFAULT now() NOT NULL, "ip_address" varchar(45) ); --> statement-breakpoint CREATE TABLE "ai_configs" ( "id" serial PRIMARY KEY NOT NULL, "team_id" integer NOT NULL, "is_active" boolean DEFAULT false NOT NULL, "provider" varchar(50) NOT NULL, "model" varchar(100) NOT NULL, "api_key" text NOT NULL, "system_prompt" text, "attachments" jsonb DEFAULT '[]'::jsonb, "temperature" numeric(2, 1) DEFAULT '0.7', "max_output_tokens" integer DEFAULT 1000, "created_at" timestamp DEFAULT now(), "updated_at" timestamp DEFAULT now(), CONSTRAINT "team_ai_config_idx" UNIQUE("team_id") ); --> statement-breakpoint CREATE TABLE "ai_sessions" ( "id" serial PRIMARY KEY NOT NULL, "team_id" integer, "chat_id" integer NOT NULL, "status" varchar(20) DEFAULT 'active', "history" jsonb DEFAULT '[]'::jsonb, "created_at" timestamp DEFAULT now(), "updated_at" timestamp DEFAULT now() ); --> statement-breakpoint CREATE TABLE "ai_tools" ( "id" serial PRIMARY KEY NOT NULL, "team_id" integer NOT NULL, "name" varchar(50) NOT NULL, "description" text NOT NULL, "type" varchar(30) DEFAULT 'media' NOT NULL, "media_url" text, "media_type" varchar(20), "caption" text, "confirmation_message" text, "action_data" jsonb, "is_active" boolean DEFAULT true NOT NULL, "created_at" timestamp DEFAULT now(), "updated_at" timestamp DEFAULT now(), CONSTRAINT "team_tool_name_idx" UNIQUE("team_id","name") ); --> statement-breakpoint CREATE TABLE "api_keys" ( "id" serial PRIMARY KEY NOT NULL, "team_id" integer NOT NULL, "name" varchar(100) NOT NULL, "key" varchar(255) NOT NULL, "last_used_at" timestamp, "created_at" timestamp DEFAULT now() NOT NULL, CONSTRAINT "api_keys_key_unique" UNIQUE("key") ); --> statement-breakpoint CREATE TABLE "automation_sessions" ( "id" serial PRIMARY KEY NOT NULL, "team_id" integer NOT NULL, "automation_id" integer NOT NULL, "chat_id" integer NOT NULL, "contact_id" integer, "current_node_id" text, "variables" jsonb DEFAULT '{}'::jsonb, "status" varchar(20) DEFAULT 'active' NOT NULL, "created_at" timestamp DEFAULT now() NOT NULL, "updated_at" timestamp DEFAULT now() NOT NULL ); --> statement-breakpoint CREATE TABLE "automations" ( "id" serial PRIMARY KEY NOT NULL, "team_id" integer NOT NULL, "name" varchar(255) NOT NULL, "instance_id" integer, "trigger_keyword" varchar(100), "nodes" jsonb DEFAULT '[]'::jsonb NOT NULL, "edges" jsonb DEFAULT '[]'::jsonb NOT NULL, "is_active" boolean DEFAULT false NOT NULL, "created_at" timestamp DEFAULT now() NOT NULL, "updated_at" timestamp DEFAULT now() NOT NULL ); --> statement-breakpoint CREATE TABLE "branding" ( "id" serial PRIMARY KEY NOT NULL, "name" varchar(100) DEFAULT 'WhatsSaaS' NOT NULL, "logo_url" text, "favicon_url" text, "created_at" timestamp DEFAULT now() NOT NULL, "updated_at" timestamp DEFAULT now() NOT NULL ); --> statement-breakpoint CREATE TABLE "call_credit_transactions" ( "id" serial PRIMARY KEY NOT NULL, "team_id" integer NOT NULL, "type" varchar(20) NOT NULL, "amount" integer NOT NULL, "description" text, "call_log_id" integer, "stripe_payment_intent_id" text, "created_at" timestamp DEFAULT now() NOT NULL ); --> statement-breakpoint CREATE TABLE "call_credits" ( "id" serial PRIMARY KEY NOT NULL, "team_id" integer NOT NULL, "balance" integer DEFAULT 0 NOT NULL, "updated_at" timestamp DEFAULT now() NOT NULL, CONSTRAINT "call_credits_team_id_idx" UNIQUE("team_id") ); --> statement-breakpoint CREATE TABLE "call_logs" ( "id" serial PRIMARY KEY NOT NULL, "team_id" integer NOT NULL, "chat_id" integer, "user_id" integer, "twilio_call_sid" text, "direction" varchar(20) NOT NULL, "from_number" varchar(20) NOT NULL, "to_number" varchar(20) NOT NULL, "status" varchar(30) DEFAULT 'initiated' NOT NULL, "duration" integer, "recording_url" text, "recording_sid" text, "credits_used" integer DEFAULT 0 NOT NULL, "started_at" timestamp, "ended_at" timestamp, "created_at" timestamp DEFAULT now() NOT NULL, CONSTRAINT "call_logs_twilio_call_sid_unique" UNIQUE("twilio_call_sid") ); --> statement-breakpoint CREATE TABLE "campaign_leads" ( "id" serial PRIMARY KEY NOT NULL, "campaign_id" integer NOT NULL, "phone" varchar(50) NOT NULL, "variables" jsonb, "status" varchar(20) DEFAULT 'PENDING', "error" text ); --> statement-breakpoint CREATE TABLE "campaigns" ( "id" serial PRIMARY KEY NOT NULL, "team_id" integer NOT NULL, "instance_id" integer NOT NULL, "name" varchar(255) NOT NULL, "status" varchar(50) DEFAULT 'DRAFT' NOT NULL, "scheduled_at" timestamp, "template_id" integer, "total_leads" integer DEFAULT 0, "sent_count" integer DEFAULT 0, "failed_count" integer DEFAULT 0, "create_contacts" boolean DEFAULT false, "created_at" timestamp DEFAULT now() NOT NULL ); --> statement-breakpoint CREATE TABLE "channel_configs" ( "id" serial PRIMARY KEY NOT NULL, "channel" varchar(30) NOT NULL, "is_active" boolean DEFAULT false NOT NULL, "api_url" text, "api_key" text, "webhook_url" text, "webhook_token" text, "meta_app_id" text, "meta_app_secret" text, "meta_config_id" text, "meta_webhook_token" text, "created_at" timestamp DEFAULT now() NOT NULL, "updated_at" timestamp DEFAULT now() NOT NULL, CONSTRAINT "channel_configs_channel_unique" UNIQUE("channel") ); --> statement-breakpoint CREATE TABLE "chat_theme" ( "id" serial PRIMARY KEY NOT NULL, "background_type" varchar(20) DEFAULT 'solid' NOT NULL, "background_color" varchar(30) DEFAULT '#F4F4F5' NOT NULL, "background_image_url" text, "user_bubble_color" varchar(30) DEFAULT '#E2EDE4' NOT NULL, "contact_bubble_color" varchar(30) DEFAULT '#FFFFFF' NOT NULL, "dark_background_color" varchar(30) DEFAULT '#27272A' NOT NULL, "dark_user_bubble_color" varchar(30) DEFAULT '#2A352E' NOT NULL, "dark_contact_bubble_color" varchar(30) DEFAULT '#18181B' NOT NULL, "created_at" timestamp DEFAULT now() NOT NULL, "updated_at" timestamp DEFAULT now() NOT NULL ); --> statement-breakpoint CREATE TABLE "chats" ( "id" serial PRIMARY KEY NOT NULL, "team_id" integer NOT NULL, "instance_id" integer, "remote_jid" text NOT NULL, "name" text, "push_name" text, "profile_pic_url" text, "last_message_text" text, "last_message_timestamp" timestamp, "last_customer_interaction" timestamp, "unread_count" integer DEFAULT 0, "last_message_status" varchar(20), "last_message_from_me" boolean, CONSTRAINT "team_chat_instance_idx" UNIQUE("team_id","remote_jid","instance_id") ); --> statement-breakpoint CREATE TABLE "contact_tags" ( "id" serial PRIMARY KEY NOT NULL, "contact_id" integer NOT NULL, "tag_id" integer NOT NULL, "created_at" timestamp DEFAULT now() NOT NULL, CONSTRAINT "contact_tag_idx" UNIQUE("contact_id","tag_id") ); --> statement-breakpoint CREATE TABLE "contacts" ( "id" serial PRIMARY KEY NOT NULL, "team_id" integer NOT NULL, "chat_id" integer NOT NULL, "name" text NOT NULL, "assigned_user_id" integer, "assigned_department_id" integer, "funnel_stage_id" integer, "notes" text, "custom_data" jsonb DEFAULT '{}'::jsonb, "show_time_in_stage" boolean DEFAULT false, "created_at" timestamp DEFAULT now() NOT NULL, "updated_at" timestamp DEFAULT now() NOT NULL, CONSTRAINT "contacts_chat_id_unique" UNIQUE("chat_id") ); --> statement-breakpoint CREATE TABLE "custom_fields" ( "id" serial PRIMARY KEY NOT NULL, "team_id" integer NOT NULL, "name" varchar(100) NOT NULL, "key" varchar(100) NOT NULL, "type" varchar(20) DEFAULT 'text' NOT NULL, "created_at" timestamp DEFAULT now() NOT NULL, CONSTRAINT "team_field_key_idx" UNIQUE("team_id","key") ); --> statement-breakpoint CREATE TABLE "department_members" ( "id" serial PRIMARY KEY NOT NULL, "department_id" integer NOT NULL, "user_id" integer NOT NULL, "created_at" timestamp DEFAULT now() NOT NULL, CONSTRAINT "dept_user_idx" UNIQUE("department_id","user_id") ); --> statement-breakpoint CREATE TABLE "departments" ( "id" serial PRIMARY KEY NOT NULL, "team_id" integer NOT NULL, "name" varchar(100) NOT NULL, "description" text, "created_at" timestamp DEFAULT now() NOT NULL, CONSTRAINT "team_department_name_idx" UNIQUE("team_id","name") ); --> statement-breakpoint CREATE TABLE "evolution_instances" ( "id" serial PRIMARY KEY NOT NULL, "team_id" integer NOT NULL, "instance_name" text NOT NULL, "display_name" text, "instance_number" text, "evolution_instance_id" text, "meta_token" text, "access_token" text, "integration" varchar(50) DEFAULT 'WHATSAPP-BAILEYS' NOT NULL, "meta_business_id" text, "meta_phone_number_id" text, "meta_waba_id" text, "meta_app_id" text, "created_at" timestamp DEFAULT now() NOT NULL, "updated_at" timestamp DEFAULT now() NOT NULL, CONSTRAINT "evolution_instances_evolution_instance_id_unique" UNIQUE("evolution_instance_id"), CONSTRAINT "team_instance_name_idx" UNIQUE("team_id","instance_name"), CONSTRAINT "team_instance_id_idx" UNIQUE("team_id","evolution_instance_id") ); --> statement-breakpoint CREATE TABLE "execution_logs" ( "id" serial PRIMARY KEY NOT NULL, "team_id" integer NOT NULL, "chat_id" integer NOT NULL, "message_id" text, "source" varchar(20) NOT NULL, "event_type" varchar(50) NOT NULL, "automation_id" integer, "automation_session_id" integer, "node_id" text, "node_type" varchar(50), "input_data" jsonb, "output_data" jsonb, "metadata" jsonb, "duration_ms" integer, "status" varchar(20) DEFAULT 'success' NOT NULL, "error_message" text, "created_at" timestamp with time zone DEFAULT now() NOT NULL ); --> statement-breakpoint CREATE TABLE "funnel_stages" ( "id" serial PRIMARY KEY NOT NULL, "team_id" integer NOT NULL, "name" varchar(100) NOT NULL, "emoji" varchar(10) DEFAULT '📁', "order" integer DEFAULT 0 NOT NULL, "created_at" timestamp DEFAULT now() NOT NULL ); --> statement-breakpoint CREATE TABLE "invitations" ( "id" serial PRIMARY KEY NOT NULL, "team_id" integer NOT NULL, "email" varchar(255) NOT NULL, "role" varchar(50) NOT NULL, "invited_by" integer NOT NULL, "invited_at" timestamp DEFAULT now() NOT NULL, "status" varchar(20) DEFAULT 'pending' NOT NULL ); --> statement-breakpoint CREATE TABLE "message_reactions" ( "id" serial PRIMARY KEY NOT NULL, "message_id" text NOT NULL, "chat_id" integer NOT NULL, "emoji" text NOT NULL, "from_me" boolean DEFAULT false NOT NULL, "remote_jid" text, "participant_name" text, "timestamp" timestamp with time zone DEFAULT now() NOT NULL, CONSTRAINT "unique_reaction_per_user_idx" UNIQUE("message_id","remote_jid","from_me") ); --> statement-breakpoint CREATE TABLE "messages" ( "id" text PRIMARY KEY NOT NULL, "chat_id" integer NOT NULL, "from_me" boolean NOT NULL, "message_type" text, "text" text, "media_url" text, "media_mimetype" text, "media_caption" text, "media_file_length" text, "media_seconds" integer, "media_is_ptt" boolean, "contact_name" text, "contact_vcard" text, "location_latitude" numeric(10, 7), "location_longitude" numeric(10, 7), "location_name" text, "location_address" text, "status" varchar(20) DEFAULT 'sent', "is_ai" boolean DEFAULT false, "is_automation" boolean DEFAULT false, "quoted_message_id" varchar(255), "quoted_message_text" text, "is_internal" boolean DEFAULT false, "participant" text, "participant_name" text, "error_message" text, "timestamp" timestamp with time zone NOT NULL ); --> statement-breakpoint CREATE TABLE "offline_payment_requests" ( "id" serial PRIMARY KEY NOT NULL, "team_id" integer NOT NULL, "plan_id" integer NOT NULL, "amount" integer NOT NULL, "currency" varchar(3) DEFAULT 'usd' NOT NULL, "status" varchar(20) DEFAULT 'pending' NOT NULL, "notes" text, "created_at" timestamp DEFAULT now() NOT NULL, "updated_at" timestamp DEFAULT now() NOT NULL ); --> statement-breakpoint CREATE TABLE "password_reset_tokens" ( "id" serial PRIMARY KEY NOT NULL, "user_id" integer NOT NULL, "token" varchar(255) NOT NULL, "expires_at" timestamp NOT NULL, "used_at" timestamp, "created_at" timestamp DEFAULT now() NOT NULL, CONSTRAINT "password_reset_tokens_token_unique" UNIQUE("token") ); --> statement-breakpoint CREATE TABLE "payment_gateways" ( "id" serial PRIMARY KEY NOT NULL, "gateway" varchar(30) NOT NULL, "display_name" varchar(100) NOT NULL, "public_key" text NOT NULL, "secret_key" text NOT NULL, "webhook_secret" text, "is_active" boolean DEFAULT false NOT NULL, "created_at" timestamp DEFAULT now() NOT NULL, "updated_at" timestamp DEFAULT now() NOT NULL ); --> statement-breakpoint CREATE TABLE "plans" ( "id" serial PRIMARY KEY NOT NULL, "name" varchar(100) NOT NULL, "description" text, "gateway_id" integer, "gateway_product_id" text, "gateway_price_id" text, "stripe_product_id" text DEFAULT '' NOT NULL, "stripe_price_id" text DEFAULT '' NOT NULL, "amount" integer DEFAULT 0 NOT NULL, "currency" varchar(3) DEFAULT 'usd' NOT NULL, "interval" varchar(20) DEFAULT 'month' NOT NULL, "trial_days" integer DEFAULT 0 NOT NULL, "max_users" integer DEFAULT 1 NOT NULL, "max_contacts" integer DEFAULT 1000 NOT NULL, "max_instances" integer DEFAULT 1 NOT NULL, "is_ai_enabled" boolean DEFAULT false NOT NULL, "is_flow_builder_enabled" boolean DEFAULT false NOT NULL, "is_campaigns_enabled" boolean DEFAULT false NOT NULL, "is_templates_enabled" boolean DEFAULT false NOT NULL, "is_voice_calls_enabled" boolean DEFAULT false NOT NULL, "created_at" timestamp DEFAULT now() NOT NULL, "updated_at" timestamp DEFAULT now() NOT NULL ); --> statement-breakpoint CREATE TABLE "push_tokens" ( "id" serial PRIMARY KEY NOT NULL, "user_id" integer NOT NULL, "token" text NOT NULL, "device_id" text, "created_at" timestamp DEFAULT now() NOT NULL, "updated_at" timestamp DEFAULT now() NOT NULL, CONSTRAINT "user_push_token_idx" UNIQUE("user_id","token") ); --> statement-breakpoint CREATE TABLE "quick_replies" ( "id" serial PRIMARY KEY NOT NULL, "team_id" integer NOT NULL, "shortcut" varchar(50) NOT NULL, "content" text NOT NULL, "created_at" timestamp DEFAULT now() NOT NULL, CONSTRAINT "team_shortcut_idx" UNIQUE("team_id","shortcut") ); --> statement-breakpoint CREATE TABLE "tags" ( "id" serial PRIMARY KEY NOT NULL, "team_id" integer NOT NULL, "name" varchar(100) NOT NULL, "color" varchar(20) DEFAULT 'gray', "created_at" timestamp DEFAULT now() NOT NULL, CONSTRAINT "team_tag_name_idx" UNIQUE("team_id","name") ); --> statement-breakpoint CREATE TABLE "team_members" ( "id" serial PRIMARY KEY NOT NULL, "user_id" integer NOT NULL, "team_id" integer NOT NULL, "role" varchar(50) NOT NULL, "permissions" jsonb, "joined_at" timestamp DEFAULT now() NOT NULL ); --> statement-breakpoint CREATE TABLE "team_phone_numbers" ( "id" serial PRIMARY KEY NOT NULL, "team_id" integer NOT NULL, "phone_number" varchar(20) NOT NULL, "twilio_phone_sid" text, "friendly_name" varchar(100), "stripe_subscription_id" text, "is_active" boolean DEFAULT true NOT NULL, "created_at" timestamp DEFAULT now() NOT NULL ); --> statement-breakpoint CREATE TABLE "teams" ( "id" serial PRIMARY KEY NOT NULL, "name" varchar(100) NOT NULL, "plan_id" integer, "created_at" timestamp DEFAULT now() NOT NULL, "updated_at" timestamp DEFAULT now() NOT NULL, "stripe_customer_id" text, "stripe_subscription_id" text, "stripe_product_id" text, "gateway_type" varchar(30), "gateway_customer_id" text, "gateway_subscription_id" text, "plan_name" varchar(50), "subscription_status" varchar(20), "is_canceled" boolean DEFAULT false, "trial_ends_at" timestamp, CONSTRAINT "teams_stripe_customer_id_unique" UNIQUE("stripe_customer_id"), CONSTRAINT "teams_stripe_subscription_id_unique" UNIQUE("stripe_subscription_id") ); --> statement-breakpoint CREATE TABLE "twilio_configs" ( "id" serial PRIMARY KEY NOT NULL, "account_sid" text NOT NULL, "auth_token" text NOT NULL, "api_key_sid" text NOT NULL, "api_key_secret" text NOT NULL, "twiml_app_sid" text, "credit_price_per_pack" integer DEFAULT 1000 NOT NULL, "credits_per_pack" integer DEFAULT 50 NOT NULL, "price_per_number" integer DEFAULT 1000 NOT NULL, "payment_gateway_id" integer, "currency" varchar(3) DEFAULT 'usd', "is_active" boolean DEFAULT false NOT NULL, "created_at" timestamp DEFAULT now() NOT NULL, "updated_at" timestamp DEFAULT now() NOT NULL ); --> statement-breakpoint CREATE TABLE "users" ( "id" serial PRIMARY KEY NOT NULL, "name" varchar(100), "email" varchar(255) NOT NULL, "password_hash" text NOT NULL, "role" varchar(20) DEFAULT 'member' NOT NULL, "enable_signature" boolean DEFAULT false NOT NULL, "created_at" timestamp DEFAULT now() NOT NULL, "updated_at" timestamp DEFAULT now() NOT NULL, "deleted_at" timestamp, CONSTRAINT "users_email_unique" UNIQUE("email") ); --> statement-breakpoint CREATE TABLE "waba_templates" ( "id" serial PRIMARY KEY NOT NULL, "team_id" integer NOT NULL, "instance_id" integer NOT NULL, "meta_id" text, "name" varchar(255) NOT NULL, "language" varchar(10) NOT NULL, "category" varchar(50) NOT NULL, "status" varchar(50) DEFAULT 'PENDING' NOT NULL, "components" jsonb NOT NULL, "created_at" timestamp DEFAULT now() NOT NULL, "updated_at" timestamp DEFAULT now() NOT NULL, CONSTRAINT "waba_template_name_lang_idx" UNIQUE("instance_id","name","language") ); --> statement-breakpoint CREATE TABLE "webhook_events" ( "id" serial PRIMARY KEY NOT NULL, "team_id" integer NOT NULL, "instance_name" varchar(255) NOT NULL, "event" varchar(100) NOT NULL, "message_id" text, "remote_jid" text, "status" varchar(20) DEFAULT 'received' NOT NULL, "error" text, "processed_at" timestamp, "created_at" timestamp DEFAULT now() NOT NULL ); --> statement-breakpoint ALTER TABLE "activity_logs" ADD CONSTRAINT "activity_logs_team_id_teams_id_fk" FOREIGN KEY ("team_id") REFERENCES "public"."teams"("id") ON DELETE cascade ON UPDATE no action;--> statement-breakpoint ALTER TABLE "activity_logs" ADD CONSTRAINT "activity_logs_user_id_users_id_fk" FOREIGN KEY ("user_id") REFERENCES "public"."users"("id") ON DELETE cascade ON UPDATE no action;--> statement-breakpoint ALTER TABLE "ai_configs" ADD CONSTRAINT "ai_configs_team_id_teams_id_fk" FOREIGN KEY ("team_id") REFERENCES "public"."teams"("id") ON DELETE cascade ON UPDATE no action;--> statement-breakpoint ALTER TABLE "ai_sessions" ADD CONSTRAINT "ai_sessions_team_id_teams_id_fk" FOREIGN KEY ("team_id") REFERENCES "public"."teams"("id") ON DELETE cascade ON UPDATE no action;--> statement-breakpoint ALTER TABLE "ai_sessions" ADD CONSTRAINT "ai_sessions_chat_id_chats_id_fk" FOREIGN KEY ("chat_id") REFERENCES "public"."chats"("id") ON DELETE cascade ON UPDATE no action;--> statement-breakpoint ALTER TABLE "ai_tools" ADD CONSTRAINT "ai_tools_team_id_teams_id_fk" FOREIGN KEY ("team_id") REFERENCES "public"."teams"("id") ON DELETE cascade ON UPDATE no action;--> statement-breakpoint ALTER TABLE "api_keys" ADD CONSTRAINT "api_keys_team_id_teams_id_fk" FOREIGN KEY ("team_id") REFERENCES "public"."teams"("id") ON DELETE cascade ON UPDATE no action;--> statement-breakpoint ALTER TABLE "automation_sessions" ADD CONSTRAINT "automation_sessions_team_id_teams_id_fk" FOREIGN KEY ("team_id") REFERENCES "public"."teams"("id") ON DELETE cascade ON UPDATE no action;--> statement-breakpoint ALTER TABLE "automation_sessions" ADD CONSTRAINT "automation_sessions_automation_id_automations_id_fk" FOREIGN KEY ("automation_id") REFERENCES "public"."automations"("id") ON DELETE cascade ON UPDATE no action;--> statement-breakpoint ALTER TABLE "automation_sessions" ADD CONSTRAINT "automation_sessions_chat_id_chats_id_fk" FOREIGN KEY ("chat_id") REFERENCES "public"."chats"("id") ON DELETE cascade ON UPDATE no action;--> statement-breakpoint ALTER TABLE "automation_sessions" ADD CONSTRAINT "automation_sessions_contact_id_contacts_id_fk" FOREIGN KEY ("contact_id") REFERENCES "public"."contacts"("id") ON DELETE set null ON UPDATE no action;--> statement-breakpoint ALTER TABLE "automations" ADD CONSTRAINT "automations_team_id_teams_id_fk" FOREIGN KEY ("team_id") REFERENCES "public"."teams"("id") ON DELETE cascade ON UPDATE no action;--> statement-breakpoint ALTER TABLE "automations" ADD CONSTRAINT "automations_instance_id_evolution_instances_id_fk" FOREIGN KEY ("instance_id") REFERENCES "public"."evolution_instances"("id") ON DELETE set null ON UPDATE no action;--> statement-breakpoint ALTER TABLE "call_credit_transactions" ADD CONSTRAINT "call_credit_transactions_team_id_teams_id_fk" FOREIGN KEY ("team_id") REFERENCES "public"."teams"("id") ON DELETE cascade ON UPDATE no action;--> statement-breakpoint ALTER TABLE "call_credit_transactions" ADD CONSTRAINT "call_credit_transactions_call_log_id_call_logs_id_fk" FOREIGN KEY ("call_log_id") REFERENCES "public"."call_logs"("id") ON DELETE set null ON UPDATE no action;--> statement-breakpoint ALTER TABLE "call_credits" ADD CONSTRAINT "call_credits_team_id_teams_id_fk" FOREIGN KEY ("team_id") REFERENCES "public"."teams"("id") ON DELETE cascade ON UPDATE no action;--> statement-breakpoint ALTER TABLE "call_logs" ADD CONSTRAINT "call_logs_team_id_teams_id_fk" FOREIGN KEY ("team_id") REFERENCES "public"."teams"("id") ON DELETE cascade ON UPDATE no action;--> statement-breakpoint ALTER TABLE "call_logs" ADD CONSTRAINT "call_logs_chat_id_chats_id_fk" FOREIGN KEY ("chat_id") REFERENCES "public"."chats"("id") ON DELETE set null ON UPDATE no action;--> statement-breakpoint ALTER TABLE "call_logs" ADD CONSTRAINT "call_logs_user_id_users_id_fk" FOREIGN KEY ("user_id") REFERENCES "public"."users"("id") ON DELETE set null ON UPDATE no action;--> statement-breakpoint ALTER TABLE "campaign_leads" ADD CONSTRAINT "campaign_leads_campaign_id_campaigns_id_fk" FOREIGN KEY ("campaign_id") REFERENCES "public"."campaigns"("id") ON DELETE cascade ON UPDATE no action;--> statement-breakpoint ALTER TABLE "campaigns" ADD CONSTRAINT "campaigns_team_id_teams_id_fk" FOREIGN KEY ("team_id") REFERENCES "public"."teams"("id") ON DELETE cascade ON UPDATE no action;--> statement-breakpoint ALTER TABLE "campaigns" ADD CONSTRAINT "campaigns_instance_id_evolution_instances_id_fk" FOREIGN KEY ("instance_id") REFERENCES "public"."evolution_instances"("id") ON DELETE cascade ON UPDATE no action;--> statement-breakpoint ALTER TABLE "campaigns" ADD CONSTRAINT "campaigns_template_id_waba_templates_id_fk" FOREIGN KEY ("template_id") REFERENCES "public"."waba_templates"("id") ON DELETE no action ON UPDATE no action;--> statement-breakpoint ALTER TABLE "chats" ADD CONSTRAINT "chats_team_id_teams_id_fk" FOREIGN KEY ("team_id") REFERENCES "public"."teams"("id") ON DELETE cascade ON UPDATE no action;--> statement-breakpoint ALTER TABLE "chats" ADD CONSTRAINT "chats_instance_id_evolution_instances_id_fk" FOREIGN KEY ("instance_id") REFERENCES "public"."evolution_instances"("id") ON DELETE set null ON UPDATE no action;--> statement-breakpoint ALTER TABLE "contact_tags" ADD CONSTRAINT "contact_tags_contact_id_contacts_id_fk" FOREIGN KEY ("contact_id") REFERENCES "public"."contacts"("id") ON DELETE cascade ON UPDATE no action;--> statement-breakpoint ALTER TABLE "contact_tags" ADD CONSTRAINT "contact_tags_tag_id_tags_id_fk" FOREIGN KEY ("tag_id") REFERENCES "public"."tags"("id") ON DELETE cascade ON UPDATE no action;--> statement-breakpoint ALTER TABLE "contacts" ADD CONSTRAINT "contacts_team_id_teams_id_fk" FOREIGN KEY ("team_id") REFERENCES "public"."teams"("id") ON DELETE cascade ON UPDATE no action;--> statement-breakpoint ALTER TABLE "contacts" ADD CONSTRAINT "contacts_chat_id_chats_id_fk" FOREIGN KEY ("chat_id") REFERENCES "public"."chats"("id") ON DELETE cascade ON UPDATE no action;--> statement-breakpoint ALTER TABLE "contacts" ADD CONSTRAINT "contacts_assigned_user_id_users_id_fk" FOREIGN KEY ("assigned_user_id") REFERENCES "public"."users"("id") ON DELETE set null ON UPDATE no action;--> statement-breakpoint ALTER TABLE "contacts" ADD CONSTRAINT "contacts_assigned_department_id_departments_id_fk" FOREIGN KEY ("assigned_department_id") REFERENCES "public"."departments"("id") ON DELETE set null ON UPDATE no action;--> statement-breakpoint ALTER TABLE "contacts" ADD CONSTRAINT "contacts_funnel_stage_id_funnel_stages_id_fk" FOREIGN KEY ("funnel_stage_id") REFERENCES "public"."funnel_stages"("id") ON DELETE set null ON UPDATE no action;--> statement-breakpoint ALTER TABLE "custom_fields" ADD CONSTRAINT "custom_fields_team_id_teams_id_fk" FOREIGN KEY ("team_id") REFERENCES "public"."teams"("id") ON DELETE cascade ON UPDATE no action;--> statement-breakpoint ALTER TABLE "department_members" ADD CONSTRAINT "department_members_department_id_departments_id_fk" FOREIGN KEY ("department_id") REFERENCES "public"."departments"("id") ON DELETE cascade ON UPDATE no action;--> statement-breakpoint ALTER TABLE "department_members" ADD CONSTRAINT "department_members_user_id_users_id_fk" FOREIGN KEY ("user_id") REFERENCES "public"."users"("id") ON DELETE cascade ON UPDATE no action;--> statement-breakpoint ALTER TABLE "departments" ADD CONSTRAINT "departments_team_id_teams_id_fk" FOREIGN KEY ("team_id") REFERENCES "public"."teams"("id") ON DELETE cascade ON UPDATE no action;--> statement-breakpoint ALTER TABLE "evolution_instances" ADD CONSTRAINT "evolution_instances_team_id_teams_id_fk" FOREIGN KEY ("team_id") REFERENCES "public"."teams"("id") ON DELETE cascade ON UPDATE no action;--> statement-breakpoint ALTER TABLE "execution_logs" ADD CONSTRAINT "execution_logs_team_id_teams_id_fk" FOREIGN KEY ("team_id") REFERENCES "public"."teams"("id") ON DELETE cascade ON UPDATE no action;--> statement-breakpoint ALTER TABLE "execution_logs" ADD CONSTRAINT "execution_logs_chat_id_chats_id_fk" FOREIGN KEY ("chat_id") REFERENCES "public"."chats"("id") ON DELETE cascade ON UPDATE no action;--> statement-breakpoint ALTER TABLE "funnel_stages" ADD CONSTRAINT "funnel_stages_team_id_teams_id_fk" FOREIGN KEY ("team_id") REFERENCES "public"."teams"("id") ON DELETE cascade ON UPDATE no action;--> statement-breakpoint ALTER TABLE "invitations" ADD CONSTRAINT "invitations_team_id_teams_id_fk" FOREIGN KEY ("team_id") REFERENCES "public"."teams"("id") ON DELETE no action ON UPDATE no action;--> statement-breakpoint ALTER TABLE "invitations" ADD CONSTRAINT "invitations_invited_by_users_id_fk" FOREIGN KEY ("invited_by") REFERENCES "public"."users"("id") ON DELETE no action ON UPDATE no action;--> statement-breakpoint ALTER TABLE "message_reactions" ADD CONSTRAINT "message_reactions_message_id_messages_id_fk" FOREIGN KEY ("message_id") REFERENCES "public"."messages"("id") ON DELETE cascade ON UPDATE no action;--> statement-breakpoint ALTER TABLE "message_reactions" ADD CONSTRAINT "message_reactions_chat_id_chats_id_fk" FOREIGN KEY ("chat_id") REFERENCES "public"."chats"("id") ON DELETE cascade ON UPDATE no action;--> statement-breakpoint ALTER TABLE "messages" ADD CONSTRAINT "messages_chat_id_chats_id_fk" FOREIGN KEY ("chat_id") REFERENCES "public"."chats"("id") ON DELETE cascade ON UPDATE no action;--> statement-breakpoint ALTER TABLE "offline_payment_requests" ADD CONSTRAINT "offline_payment_requests_team_id_teams_id_fk" FOREIGN KEY ("team_id") REFERENCES "public"."teams"("id") ON DELETE cascade ON UPDATE no action;--> statement-breakpoint ALTER TABLE "password_reset_tokens" ADD CONSTRAINT "password_reset_tokens_user_id_users_id_fk" FOREIGN KEY ("user_id") REFERENCES "public"."users"("id") ON DELETE cascade ON UPDATE no action;--> statement-breakpoint ALTER TABLE "plans" ADD CONSTRAINT "plans_gateway_id_payment_gateways_id_fk" FOREIGN KEY ("gateway_id") REFERENCES "public"."payment_gateways"("id") ON DELETE set null ON UPDATE no action;--> statement-breakpoint ALTER TABLE "push_tokens" ADD CONSTRAINT "push_tokens_user_id_users_id_fk" FOREIGN KEY ("user_id") REFERENCES "public"."users"("id") ON DELETE cascade ON UPDATE no action;--> statement-breakpoint ALTER TABLE "quick_replies" ADD CONSTRAINT "quick_replies_team_id_teams_id_fk" FOREIGN KEY ("team_id") REFERENCES "public"."teams"("id") ON DELETE cascade ON UPDATE no action;--> statement-breakpoint ALTER TABLE "tags" ADD CONSTRAINT "tags_team_id_teams_id_fk" FOREIGN KEY ("team_id") REFERENCES "public"."teams"("id") ON DELETE cascade ON UPDATE no action;--> statement-breakpoint ALTER TABLE "team_members" ADD CONSTRAINT "team_members_user_id_users_id_fk" FOREIGN KEY ("user_id") REFERENCES "public"."users"("id") ON DELETE no action ON UPDATE no action;--> statement-breakpoint ALTER TABLE "team_members" ADD CONSTRAINT "team_members_team_id_teams_id_fk" FOREIGN KEY ("team_id") REFERENCES "public"."teams"("id") ON DELETE cascade ON UPDATE no action;--> statement-breakpoint ALTER TABLE "team_phone_numbers" ADD CONSTRAINT "team_phone_numbers_team_id_teams_id_fk" FOREIGN KEY ("team_id") REFERENCES "public"."teams"("id") ON DELETE cascade ON UPDATE no action;--> statement-breakpoint ALTER TABLE "teams" ADD CONSTRAINT "teams_plan_id_plans_id_fk" FOREIGN KEY ("plan_id") REFERENCES "public"."plans"("id") ON DELETE no action ON UPDATE no action;--> statement-breakpoint ALTER TABLE "twilio_configs" ADD CONSTRAINT "twilio_configs_payment_gateway_id_payment_gateways_id_fk" FOREIGN KEY ("payment_gateway_id") REFERENCES "public"."payment_gateways"("id") ON DELETE set null ON UPDATE no action;--> statement-breakpoint ALTER TABLE "waba_templates" ADD CONSTRAINT "waba_templates_team_id_teams_id_fk" FOREIGN KEY ("team_id") REFERENCES "public"."teams"("id") ON DELETE cascade ON UPDATE no action;--> statement-breakpoint ALTER TABLE "waba_templates" ADD CONSTRAINT "waba_templates_instance_id_evolution_instances_id_fk" FOREIGN KEY ("instance_id") REFERENCES "public"."evolution_instances"("id") ON DELETE cascade ON UPDATE no action;--> statement-breakpoint CREATE INDEX "api_key_team_id_idx" ON "api_keys" USING btree ("team_id");--> statement-breakpoint CREATE INDEX "api_key_value_idx" ON "api_keys" USING btree ("key");--> statement-breakpoint CREATE INDEX "call_credit_tx_team_id_idx" ON "call_credit_transactions" USING btree ("team_id");--> statement-breakpoint CREATE INDEX "call_logs_team_id_idx" ON "call_logs" USING btree ("team_id");--> statement-breakpoint CREATE INDEX "call_logs_chat_id_idx" ON "call_logs" USING btree ("chat_id");--> statement-breakpoint CREATE INDEX "call_logs_twilio_call_sid_idx" ON "call_logs" USING btree ("twilio_call_sid");--> statement-breakpoint CREATE INDEX "contact_team_id_idx" ON "contacts" USING btree ("team_id");--> statement-breakpoint CREATE INDEX "contact_chat_id_idx" ON "contacts" USING btree ("chat_id");--> statement-breakpoint CREATE INDEX "instance_team_id_idx" ON "evolution_instances" USING btree ("team_id");--> statement-breakpoint CREATE INDEX "idx_exec_logs_chat_created" ON "execution_logs" USING btree ("chat_id","created_at");--> statement-breakpoint CREATE INDEX "idx_exec_logs_message" ON "execution_logs" USING btree ("message_id");--> statement-breakpoint CREATE INDEX "idx_exec_logs_team_created" ON "execution_logs" USING btree ("team_id","created_at");--> statement-breakpoint CREATE INDEX "reaction_message_id_idx" ON "message_reactions" USING btree ("message_id");--> statement-breakpoint CREATE INDEX "push_token_value_idx" ON "push_tokens" USING btree ("token");--> statement-breakpoint CREATE INDEX "webhook_events_team_id_idx" ON "webhook_events" USING btree ("team_id");--> statement-breakpoint CREATE INDEX "webhook_events_status_idx" ON "webhook_events" USING btree ("status");--> statement-breakpoint CREATE INDEX "webhook_events_created_at_idx" ON "webhook_events" USING btree ("created_at");