ALTER TABLE `tickets` ADD `source` text DEFAULT 'guest' NOT NULL;
--> statement-breakpoint
ALTER TABLE `tickets` ADD `created_by` text;
--> statement-breakpoint
CREATE INDEX `idx_tickets_visit_source` ON `tickets` (`visit_id`,`source`);
--> statement-breakpoint
PRAGMA optimize;