83 lines
4.9 KiB
SQL
83 lines
4.9 KiB
SQL
ALTER TABLE `two_factor` ADD `failed_verification_count` integer DEFAULT 0;--> statement-breakpoint
|
|
ALTER TABLE `two_factor` ADD `locked_until` integer;--> statement-breakpoint
|
|
PRAGMA foreign_keys=OFF;--> statement-breakpoint
|
|
CREATE TABLE `__new_account` (
|
|
`access_token` text,
|
|
`access_token_expires_at` integer,
|
|
`account_id` text NOT NULL,
|
|
`created_at` integer DEFAULT (cast(unixepoch('subsecond') * 1000 as integer)) NOT NULL,
|
|
`id` text PRIMARY KEY,
|
|
`id_token` text,
|
|
`issuer` text NOT NULL,
|
|
`password` text,
|
|
`provider_id` text NOT NULL,
|
|
`refresh_token` text,
|
|
`refresh_token_expires_at` integer,
|
|
`scope` text,
|
|
`updated_at` integer NOT NULL,
|
|
`user_id` text NOT NULL,
|
|
CONSTRAINT `fk_account_user_id_user_id_fk` FOREIGN KEY (`user_id`) REFERENCES `user`(`id`) ON DELETE CASCADE
|
|
);
|
|
--> statement-breakpoint
|
|
INSERT INTO `__new_account`(`access_token`, `access_token_expires_at`, `account_id`, `created_at`, `id`, `id_token`, `issuer`, `password`, `provider_id`, `refresh_token`, `refresh_token_expires_at`, `scope`, `updated_at`, `user_id`) SELECT `access_token`, `access_token_expires_at`, `account_id`, `created_at`, `id`, `id_token`, CASE `provider_id` WHEN 'credential' THEN 'local:credential' WHEN 'google' THEN 'https://accounts.google.com' WHEN 'facebook' THEN 'https://www.facebook.com' WHEN 'apple' THEN 'https://appleid.apple.com' ELSE 'local:oauth:' || `provider_id` END, `password`, `provider_id`, `refresh_token`, `refresh_token_expires_at`, `scope`, `updated_at`, `user_id` FROM `account`;--> statement-breakpoint
|
|
DROP TABLE `account`;--> statement-breakpoint
|
|
ALTER TABLE `__new_account` RENAME TO `account`;--> statement-breakpoint
|
|
PRAGMA foreign_keys=ON;--> statement-breakpoint
|
|
PRAGMA foreign_keys=OFF;--> statement-breakpoint
|
|
CREATE TABLE `__new_session` (
|
|
`created_at` integer DEFAULT (cast(unixepoch('subsecond') * 1000 as integer)) NOT NULL,
|
|
`expires_at` integer NOT NULL,
|
|
`id` text PRIMARY KEY,
|
|
`impersonated_by` text,
|
|
`ip_address` text,
|
|
`token` text NOT NULL UNIQUE,
|
|
`updated_at` integer NOT NULL,
|
|
`user_agent` text,
|
|
`user_id` text NOT NULL,
|
|
CONSTRAINT `fk_session_user_id_user_id_fk` FOREIGN KEY (`user_id`) REFERENCES `user`(`id`) ON DELETE CASCADE
|
|
);
|
|
--> statement-breakpoint
|
|
INSERT INTO `__new_session`(`created_at`, `expires_at`, `id`, `impersonated_by`, `ip_address`, `token`, `updated_at`, `user_agent`, `user_id`) SELECT `created_at`, `expires_at`, `id`, `impersonated_by`, `ip_address`, `token`, `updated_at`, `user_agent`, `user_id` FROM `session`;--> statement-breakpoint
|
|
DROP TABLE `session`;--> statement-breakpoint
|
|
ALTER TABLE `__new_session` RENAME TO `session`;--> statement-breakpoint
|
|
PRAGMA foreign_keys=ON;--> statement-breakpoint
|
|
PRAGMA foreign_keys=OFF;--> statement-breakpoint
|
|
CREATE TABLE `__new_user` (
|
|
`ban_expires` integer,
|
|
`banned` integer DEFAULT false,
|
|
`ban_reason` text,
|
|
`created_at` integer DEFAULT (cast(unixepoch('subsecond') * 1000 as integer)) NOT NULL,
|
|
`display_username` text,
|
|
`email` text NOT NULL UNIQUE,
|
|
`email_verified` integer DEFAULT false NOT NULL,
|
|
`id` text PRIMARY KEY,
|
|
`image` text,
|
|
`name` text NOT NULL,
|
|
`role` text,
|
|
`two_factor_enabled` integer DEFAULT false,
|
|
`updated_at` integer DEFAULT (cast(unixepoch('subsecond') * 1000 as integer)) NOT NULL,
|
|
`username` text UNIQUE
|
|
);
|
|
--> statement-breakpoint
|
|
INSERT INTO `__new_user`(`ban_expires`, `banned`, `ban_reason`, `created_at`, `display_username`, `email`, `email_verified`, `id`, `image`, `name`, `role`, `two_factor_enabled`, `updated_at`, `username`) SELECT `ban_expires`, `banned`, `ban_reason`, `created_at`, `display_username`, `email`, `email_verified`, `id`, `image`, `name`, `role`, `two_factor_enabled`, `updated_at`, `username` FROM `user`;--> statement-breakpoint
|
|
DROP TABLE `user`;--> statement-breakpoint
|
|
ALTER TABLE `__new_user` RENAME TO `user`;--> statement-breakpoint
|
|
PRAGMA foreign_keys=ON;--> statement-breakpoint
|
|
PRAGMA foreign_keys=OFF;--> statement-breakpoint
|
|
CREATE TABLE `__new_verification` (
|
|
`created_at` integer DEFAULT (cast(unixepoch('subsecond') * 1000 as integer)) NOT NULL,
|
|
`expires_at` integer NOT NULL,
|
|
`id` text PRIMARY KEY,
|
|
`identifier` text NOT NULL,
|
|
`updated_at` integer DEFAULT (cast(unixepoch('subsecond') * 1000 as integer)) NOT NULL,
|
|
`value` text NOT NULL
|
|
);
|
|
--> statement-breakpoint
|
|
INSERT INTO `__new_verification`(`created_at`, `expires_at`, `id`, `identifier`, `updated_at`, `value`) SELECT `created_at`, `expires_at`, `id`, `identifier`, `updated_at`, `value` FROM `verification`;--> statement-breakpoint
|
|
DROP TABLE `verification`;--> statement-breakpoint
|
|
ALTER TABLE `__new_verification` RENAME TO `verification`;--> statement-breakpoint
|
|
PRAGMA foreign_keys=ON;--> statement-breakpoint
|
|
CREATE UNIQUE INDEX `account_issuer_accountId_uidx` ON `account` (`issuer`,`account_id`);--> statement-breakpoint
|
|
CREATE INDEX `account_userId_idx` ON `account` (`user_id`);--> statement-breakpoint
|
|
CREATE INDEX `session_userId_idx` ON `session` (`user_id`);--> statement-breakpoint
|
|
CREATE INDEX `verification_identifier_idx` ON `verification` (`identifier`); |