Query

branch.sqlite — local_audit_log

SQL

CREATE TABLE "local_audit_log"  (
  "Id" TEXT NOT NULL CONSTRAINT "PK_local_audit_log" PRIMARY KEY,
  "Action" TEXT NOT NULL,
  "ActorUserId" TEXT NULL,
  "CreatedAt" TEXT NOT NULL,
  "DeletedAt" TEXT NULL,
  "EntityId" TEXT NULL,
  "EntityType" TEXT NOT NULL,
  "IsDeleted" INTEGER NOT NULL,
  "OccurredAt" TEXT NOT NULL,
  "PayloadJson" TEXT NULL,
  "UpdatedAt" TEXT NOT NULL
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
Id TEXT ✓ Rename | Drop
Action TEXT Rename | Drop
ActorUserId TEXT ✓ Rename | Drop
CreatedAt TEXT Rename | Drop
DeletedAt TEXT ✓ Rename | Drop
EntityId TEXT ✓ Rename | Drop
EntityType TEXT Rename | Drop
IsDeleted INTEGER Rename | Drop
OccurredAt TEXT Rename | Drop
PayloadJson TEXT ✓ Rename | Drop
UpdatedAt TEXT Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
IX_local_audit_log_OccurredAt OccurredAt SQL 
CREATE INDEX "IX_local_audit_log_OccurredAt"
ON "local_audit_log" ("OccurredAt")
Drop
sqlite_autoindex_local_audit_log_1 Id ✓ SQL
-- no sql found --
 Drop