Query

database.sqlite — variables

SQL

CREATE TABLE "variables"  (
  "id" varchar(36) PRIMARY KEY NOT NULL,
  "key" text NOT NULL,
  "type" text NOT NULL DEFAULT ('string'),
  "value" text,
  "projectId" varchar(36),
  CONSTRAINT "FK_a0f13eaa709a21b77a3a9721319" FOREIGN KEY ("projectId") REFERENCES "project" ("id") ON DELETE CASCADE
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id varchar(36) ✓ Rename | Drop
key TEXT Rename | Drop
type TEXT Rename | Drop
value TEXT ✓ Rename | Drop
projectId varchar(36) ✓ Rename | Drop

Foreign Keys

Column Destination
projectId project.id

+ Add index

Indexes

Name Columns Unique SQL Drop?
sqlite_autoindex_variables_1 id ✓ SQL
-- no sql found --
 Drop
variables_global_key_unique key ✓ SQL 
CREATE UNIQUE INDEX "variables_global_key_unique"
ON "variables" ("key")
			 WHERE projectId IS NULL
Drop
variables_project_key_unique
  • projectId
  • key
 ✓ SQL 
CREATE UNIQUE INDEX "variables_project_key_unique"
ON "variables" ("projectId", "key")
Drop