CREATE TABLE `sessions` (
`id` text PRIMARY KEY NOT NULL,
`user_id` text NOT NULL,
`expires_at` integer NOT NULL
);
--> statement-breakpoint
CREATE TABLE `users` (
`id` text PRIMARY KEY NOT NULL,
`provider` text DEFAULT 'email' NOT NULL,
`provider_id` text DEFAULT '' NOT NULL,
`email` text NOT NULL,
`first_name` text,
`last_name` text,
`role` text DEFAULT 'USER' NOT NULL,
`token` text,
`receive_email` integer DEFAULT true NOT NULL,
`created_at` integer DEFAULT CURRENT_TIMESTAMP NOT NULL,
`updated_at` integer DEFAULT CURRENT_TIMESTAMP NOT NULL
);
--> statement-breakpoint
CREATE UNIQUE INDEX `users_email_unique` ON `users` (`email`);
CREATE TABLE `sessions` (
`id` text PRIMARY KEY NOT NULL,
`user_id` text NOT NULL,
`expires_at` integer NOT NULL
);
--> statement-breakpoint
CREATE TABLE `users` (
`id` text PRIMARY KEY NOT NULL,
`provider` text DEFAULT 'email' NOT NULL,
`provider_id` text DEFAULT '' NOT NULL,
`email` text NOT NULL,
`first_name` text,
`last_name` text,
`role` text DEFAULT 'USER' NOT NULL,
`token` text,
`receive_email` integer DEFAULT true NOT NULL,
`created_at` integer DEFAULT CURRENT_TIMESTAMP NOT NULL,
`updated_at` integer DEFAULT CURRENT_TIMESTAMP NOT NULL
);
--> statement-breakpoint
CREATE UNIQUE INDEX `users_email_unique` ON `users` (`email`);