CREATE TABLE `leads` (
	`id` integer PRIMARY KEY AUTOINCREMENT NOT NULL,
	`locale` text NOT NULL,
	`service_category` text NOT NULL,
	`profession` text NOT NULL,
	`nationality` text NOT NULL,
	`religion` text NOT NULL,
	`religion_other` text,
	`experience` text NOT NULL,
	`name` text NOT NULL,
	`email` text,
	`phone` text NOT NULL,
	`message` text,
	`status` text DEFAULT 'new' NOT NULL,
	`email_sent` integer DEFAULT false NOT NULL,
	`email_error` text,
	`created_at` integer NOT NULL,
	`updated_at` integer NOT NULL
);
--> statement-breakpoint
CREATE TABLE `admin_emails` (
	`id` integer PRIMARY KEY AUTOINCREMENT NOT NULL,
	`email` text NOT NULL,
	`created_at` integer NOT NULL
);
--> statement-breakpoint
CREATE UNIQUE INDEX `admin_emails_email_unique` ON `admin_emails` (`email`);--> statement-breakpoint
CREATE TABLE `settings` (
	`key` text PRIMARY KEY NOT NULL,
	`value` text NOT NULL,
	`updated_at` integer NOT NULL
);
--> statement-breakpoint
INSERT INTO `settings` (`key`, `value`, `updated_at`) VALUES ('lead_to_emails', 'info@adairarecruitmentcompany-sa.com', unixepoch());