Query

sqlite.db — account

SQL

CREATE TABLE `account`  (
  `id` text PRIMARY KEY,
  `account_id` text NOT NULL,
  `provider_id` text NOT NULL,
  `user_id` text NOT NULL,
  `access_token` text,
  `refresh_token` text,
  `id_token` text,
  `access_token_expires_at` integer,
  `refresh_token_expires_at` integer,
  `scope` text,
  `password` text,
  `created_at` integer NOT NULL,
  `updated_at` integer NOT NULL,
  CONSTRAINT `fk_account_user_id_user_id_fk` FOREIGN KEY (`user_id`) REFERENCES `user`(`id`) ON DELETE CASCADE
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id TEXT ✓ ✓ Rename | Drop
account_id TEXT Rename | Drop
provider_id TEXT Rename | Drop
user_id TEXT Rename | Drop
access_token TEXT ✓ Rename | Drop
refresh_token TEXT ✓ Rename | Drop
id_token TEXT ✓ Rename | Drop
access_token_expires_at INTEGER ✓ Rename | Drop
refresh_token_expires_at INTEGER ✓ Rename | Drop
scope TEXT ✓ Rename | Drop
password TEXT ✓ Rename | Drop
created_at INTEGER Rename | Drop
updated_at INTEGER Rename | Drop

Foreign Keys

Column Destination
user_id user.id

+ Add index

Indexes

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