Query

cool-keeper.db — verification

SQL

CREATE TABLE "verification"  (
  `id` text PRIMARY KEY NOT NULL,
  `identifier` text NOT NULL,
  `value` text NOT NULL,
  `expiresAt` integer NOT NULL,
  `createdAt` integer NOT NULL,
  `updatedAt` integer
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id TEXT ✓ Rename | Drop
identifier TEXT Rename | Drop
value TEXT Rename | Drop
expiresAt INTEGER Rename | Drop
createdAt INTEGER Rename | Drop
updatedAt INTEGER ✓ Rename | Drop

+ Add index

Indexes

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