Query

cool-keeper.db — user

SQL

CREATE TABLE "user"  (
  `id` text PRIMARY KEY NOT NULL,
  `name` text NOT NULL,
  `email` text NOT NULL,
  `emailVerified` integer DEFAULT false NOT NULL,
  `image` text,
  `createdAt` integer NOT NULL,
  `updatedAt` integer
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id TEXT ✓ Rename | Drop
name TEXT Rename | Drop
email TEXT Rename | Drop
emailVerified INTEGER Rename | Drop
image TEXT ✓ Rename | Drop
createdAt INTEGER Rename | Drop
updatedAt INTEGER ✓ Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
sqlite_autoindex_user_1 id ✓ SQL
-- no sql found --
 Drop
user_email_unique email ✓ SQL 
CREATE UNIQUE INDEX `user_email_unique`
ON `user` (`email`)
Drop