CREATE TABLE `pending_jobs` (
	`id` int AUTO_INCREMENT NOT NULL,
	`userId` int NOT NULL,
	`sourceUrl` varchar(2048) NOT NULL,
	`sourceType` enum('wayback','live') NOT NULL DEFAULT 'wayback',
	`tier` enum('free','tier_5','tier_7_50','tier_10','tier_15','tier_pwyw') NOT NULL DEFAULT 'free',
	`targetDate` varchar(14),
	`rewriteUrl` varchar(2048),
	`contactReplacements` text NOT NULL,
	`stripeSessionId` varchar(255),
	`status` enum('awaiting_payment','paid','expired') NOT NULL DEFAULT 'awaiting_payment',
	`createdAt` timestamp NOT NULL DEFAULT (now()),
	`updatedAt` timestamp NOT NULL DEFAULT (now()) ON UPDATE CURRENT_TIMESTAMP,
	CONSTRAINT `pending_jobs_id` PRIMARY KEY(`id`)
);
