ALTER TABLE `demo_customer_requests` ADD `customer_email` text;
--> statement-breakpoint
ALTER TABLE `demo_customer_requests` ADD `customer_phone` text;
--> statement-breakpoint
CREATE TABLE IF NOT EXISTS `notification_deliveries` (
  `id` text PRIMARY KEY NOT NULL,
  `request_id` text NOT NULL,
  `event` text NOT NULL,
  `channel` text NOT NULL,
  `recipient` text NOT NULL,
  `status` text NOT NULL,
  `provider_message_id` text,
  `error` text,
  `created_at` integer NOT NULL,
  `updated_at` integer NOT NULL
);
--> statement-breakpoint
CREATE INDEX IF NOT EXISTS `idx_notification_deliveries_request`
  ON `notification_deliveries` (`request_id`, `event`);
