CREATE TABLE `clickEvents` (
	`id` int AUTO_INCREMENT NOT NULL,
	`linkId` int NOT NULL,
	`clickedAt` timestamp NOT NULL DEFAULT (now()),
	`referrer` varchar(255),
	`country` varchar(80),
	`device` varchar(80),
	`browser` varchar(80),
	CONSTRAINT `clickEvents_id` PRIMARY KEY(`id`)
);
--> statement-breakpoint
CREATE TABLE `links` (
	`id` int AUTO_INCREMENT NOT NULL,
	`userId` int NOT NULL,
	`slug` varchar(64) NOT NULL,
	`title` varchar(180) NOT NULL,
	`targetUrl` text NOT NULL,
	`status` enum('active','paused') NOT NULL DEFAULT 'active',
	`clicks` int NOT NULL DEFAULT 0,
	`expiresAt` bigint,
	`createdAt` timestamp NOT NULL DEFAULT (now()),
	`updatedAt` timestamp NOT NULL DEFAULT (now()) ON UPDATE CURRENT_TIMESTAMP,
	CONSTRAINT `links_id` PRIMARY KEY(`id`),
	CONSTRAINT `links_slug_unique` UNIQUE(`slug`)
);