Query

branch.sqlite — local_pos_shifts

SQL

CREATE TABLE "local_pos_shifts"  (
  "Id" TEXT NOT NULL CONSTRAINT "PK_local_pos_shifts" PRIMARY KEY,
  "OpenedByUserId" TEXT NOT NULL,
  "ClosedByUserId" TEXT NULL,
  "ShiftStart" TEXT NOT NULL,
  "ShiftEnd" TEXT NULL,
  "Status" TEXT NOT NULL,
  "OpeningNotes" TEXT NULL,
  "CreatedAt" TEXT NOT NULL,
  "UpdatedAt" TEXT NOT NULL,
  "IsDeleted" INTEGER NOT NULL,
  "DeletedAt" TEXT NULL,
  "ClosingNotes" TEXT NULL,
  "OpeningCashAmount" INTEGER NULL
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
Id TEXT ✓ Rename | Drop
OpenedByUserId TEXT Rename | Drop
ClosedByUserId TEXT ✓ Rename | Drop
ShiftStart TEXT Rename | Drop
ShiftEnd TEXT ✓ Rename | Drop
Status TEXT Rename | Drop
OpeningNotes TEXT ✓ Rename | Drop
CreatedAt TEXT Rename | Drop
UpdatedAt TEXT Rename | Drop
IsDeleted INTEGER Rename | Drop
DeletedAt TEXT ✓ Rename | Drop
ClosingNotes TEXT ✓ Rename | Drop
OpeningCashAmount INTEGER ✓ Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
IX_local_pos_shifts_ShiftStart ShiftStart SQL 
CREATE INDEX "IX_local_pos_shifts_ShiftStart"
ON "local_pos_shifts" ("ShiftStart")
Drop
IX_local_pos_shifts_Status Status SQL 
CREATE INDEX "IX_local_pos_shifts_Status"
ON "local_pos_shifts" ("Status")
Drop
sqlite_autoindex_local_pos_shifts_1 Id ✓ SQL
-- no sql found --
 Drop