Query

avatarai.db — CalendarBookings

SQL

CREATE TABLE CalendarBookings  (
  Id TEXT NOT NULL PRIMARY KEY,
  AvatarId TEXT NOT NULL,
  ClientId TEXT NOT NULL,
  SummaryId TEXT NOT NULL,
  EventId TEXT,
  Status TEXT NOT NULL,
  CreatedAt TEXT NOT NULL,
  EventLink TEXT,
  FOREIGN KEY (AvatarId) REFERENCES Avatars(Id) ON DELETE CASCADE
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
Id TEXT ✓ Rename | Drop
AvatarId TEXT Rename | Drop
ClientId TEXT Rename | Drop
SummaryId TEXT Rename | Drop
EventId TEXT ✓ Rename | Drop
Status TEXT Rename | Drop
CreatedAt TEXT Rename | Drop
EventLink TEXT ✓ Rename | Drop

Foreign Keys

Column Destination
AvatarId Avatars.Id

+ Add index

Indexes

Name Columns Unique SQL Drop?
IX_CalendarBookings_AvatarId AvatarId SQL 
CREATE INDEX IX_CalendarBookings_AvatarId
ON CalendarBookings(AvatarId)
Drop
sqlite_autoindex_CalendarBookings_1 Id ✓ SQL
-- no sql found --
 Drop