CREATE TABLE `analytics_events` (
	`id` integer PRIMARY KEY AUTOINCREMENT NOT NULL,
	`owner_id` text NOT NULL,
	`username` text NOT NULL,
	`visitor_id` text NOT NULL,
	`event` text NOT NULL,
	`target` text DEFAULT '' NOT NULL,
	`country` text DEFAULT 'Unknown' NOT NULL,
	`device` text DEFAULT 'Unknown' NOT NULL,
	`browser` text DEFAULT 'Unknown' NOT NULL,
	`source` text DEFAULT 'Direct' NOT NULL,
	`created_at` text NOT NULL
);
--> statement-breakpoint
CREATE INDEX `idx_analytics_owner_event_date` ON `analytics_events` (`owner_id`,`event`,`created_at`);--> statement-breakpoint
CREATE INDEX `idx_analytics_owner_visitor_date` ON `analytics_events` (`owner_id`,`visitor_id`,`created_at`);