Query

cool-keeper.db — session

SQL

CREATE TABLE "session"  (
  `id` text PRIMARY KEY NOT NULL,
  `expiresAt` integer NOT NULL,
  `token` text NOT NULL,
  `createdAt` integer NOT NULL,
  `updatedAt` integer,
  `ipAddress` text,
  `userAgent` text,
  `userId` text NOT NULL,
  `activeOrganizationId` text,
  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
expiresAt INTEGER Rename | Drop
token TEXT Rename | Drop
createdAt INTEGER Rename | Drop
updatedAt INTEGER ✓ Rename | Drop
ipAddress TEXT ✓ Rename | Drop
userAgent TEXT ✓ Rename | Drop
userId TEXT Rename | Drop
activeOrganizationId TEXT ✓ Rename | Drop

Foreign Keys

Column Destination
userId user.id

+ Add index

Indexes

Name Columns Unique SQL Drop?
session_token_unique token ✓ SQL 
CREATE UNIQUE INDEX `session_token_unique`
ON `session` (`token`)
Drop
sqlite_autoindex_session_1 id ✓ SQL
-- no sql found --
 Drop