mirror of
https://github.com/jorgev259/soc_site-astro.git
synced 2025-06-29 07:57:41 +00:00
24 lines
No EOL
882 B
SQL
24 lines
No EOL
882 B
SQL
-- CreateTable
|
|
CREATE TABLE `account` (
|
|
`id` VARCHAR(191) NOT NULL,
|
|
`userId` VARCHAR(191) NOT NULL,
|
|
`accountId` VARCHAR(191) NOT NULL,
|
|
`providerId` VARCHAR(191) NOT NULL,
|
|
`accessToken` VARCHAR(191) NULL,
|
|
`refreshToken` VARCHAR(191) NULL,
|
|
`accessTokenExpiresAt` DATETIME(3) NULL,
|
|
`refreshTokenExpiresAt` DATETIME(3) NULL,
|
|
`scope` VARCHAR(191) NULL,
|
|
`idToken` VARCHAR(191) NULL,
|
|
`password` VARCHAR(191) NULL,
|
|
`createdAt` DATETIME(3) NOT NULL,
|
|
`updatedAt` DATETIME(3) NOT NULL,
|
|
|
|
PRIMARY KEY (`id`)
|
|
);
|
|
|
|
-- AddForeignKey
|
|
ALTER TABLE `account` ADD CONSTRAINT `account_userId_fkey` FOREIGN KEY (`userId`) REFERENCES `users`(`username`) ON DELETE RESTRICT ON UPDATE CASCADE;
|
|
|
|
INSERT INTO `account` (id,userId,accountId, providerId,createdAt, updatedAt)
|
|
SELECT username,username,username,"credential",createdAt,updatedAt FROM `users`; |