Query

database.sqlite — chat_hub_tools

SQL

CREATE TABLE "chat_hub_tools"  (
  "id" varchar PRIMARY KEY NOT NULL,
  "name" varchar(255) NOT NULL,
  "type" varchar(255) NOT NULL,
  "typeVersion" real NOT NULL,
  "ownerId" varchar NOT NULL,
  "definition" text NOT NULL,
  "enabled" boolean NOT NULL DEFAULT (true),
  "createdAt" datetime(3) NOT NULL DEFAULT (STRFTIME('%Y-%m-%d %H:%M:%f', 'NOW')),
  "updatedAt" datetime(3) NOT NULL DEFAULT (STRFTIME('%Y-%m-%d %H:%M:%f', 'NOW')),
  CONSTRAINT "FK_b8030b47af9213f1fd15450fb7f" FOREIGN KEY ("ownerId") REFERENCES "user" ("id") ON DELETE CASCADE
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id varchar ✓ Rename | Drop
name varchar(255) Rename | Drop
type varchar(255) Rename | Drop
typeVersion REAL Rename | Drop
ownerId varchar Rename | Drop
definition TEXT Rename | Drop
enabled boolean Rename | Drop
createdAt datetime(3) Rename | Drop
updatedAt datetime(3) Rename | Drop

Foreign Keys

Column Destination
ownerId user.id

+ Add index

Indexes

Name Columns Unique SQL Drop?
IDX_4c72ebdb265d1775bf61147af0
  • ownerId
  • name
 ✓ SQL 
CREATE UNIQUE INDEX "IDX_4c72ebdb265d1775bf61147af0"
ON "chat_hub_tools" ("ownerId", "name")
Drop
sqlite_autoindex_chat_hub_tools_1 id ✓ SQL
-- no sql found --
 Drop