Query

cool-keeper.db — account

SQL

CREATE TABLE "account"  (
  `id` text PRIMARY KEY NOT NULL,
  `accountId` text NOT NULL,
  `providerId` text NOT NULL,
  `userId` text NOT NULL,
  `accessToken` text,
  `refreshToken` text,
  `idToken` text,
  `accessTokenExpiresAt` integer,
  `refreshTokenExpiresAt` integer,
  `scope` text,
  `password` text,
  `createdAt` integer NOT NULL,
  `updatedAt` integer,
  FOREIGN KEY (`userId`) REFERENCES `user`(`id`) ON UPDATE no action ON DELETE cascade
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id TEXT ✓ Rename | Drop
accountId TEXT Rename | Drop
providerId TEXT Rename | Drop
userId TEXT Rename | Drop
accessToken TEXT ✓ Rename | Drop
refreshToken TEXT ✓ Rename | Drop
idToken TEXT ✓ Rename | Drop
accessTokenExpiresAt INTEGER ✓ Rename | Drop
refreshTokenExpiresAt INTEGER ✓ Rename | Drop
scope TEXT ✓ Rename | Drop
password TEXT ✓ Rename | Drop
createdAt INTEGER Rename | Drop
updatedAt INTEGER ✓ Rename | Drop

Foreign Keys

Column Destination
userId user.id

+ Add index

Indexes

Name Columns Unique SQL Drop?
sqlite_autoindex_account_1 id ✓ SQL
-- no sql found --
 Drop