Query

avatarai.db — AvatarTools

SQL

CREATE TABLE AvatarTools  (
  Id TEXT NOT NULL PRIMARY KEY,
  AvatarId TEXT NOT NULL,
  ToolType TEXT NOT NULL,
  ClientId TEXT,
  ClientSecret TEXT,
  RefreshToken TEXT,
  ExternalAccountId TEXT,
  ExtraConfig TEXT,
  IsEnabled INTEGER NOT NULL,
  CreatedAt TEXT NOT NULL,
  UpdatedAt 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
ToolType TEXT Rename | Drop
ClientId TEXT ✓ Rename | Drop
ClientSecret TEXT ✓ Rename | Drop
RefreshToken TEXT ✓ Rename | Drop
ExternalAccountId TEXT ✓ Rename | Drop
ExtraConfig TEXT ✓ Rename | Drop
IsEnabled INTEGER Rename | Drop
CreatedAt TEXT Rename | Drop
UpdatedAt TEXT ✓ Rename | Drop

Foreign Keys

Column Destination
AvatarId Avatars.Id

+ Add index

Indexes

Name Columns Unique SQL Drop?
IX_AvatarTools_AvatarId AvatarId SQL 
CREATE INDEX IX_AvatarTools_AvatarId
ON AvatarTools(AvatarId)
Drop
sqlite_autoindex_AvatarTools_1 Id ✓ SQL
-- no sql found --
 Drop