idiom_game.db — GameRecords

SQL

CREATE TABLE "GameRecords"  (
  "Id" INTEGER NOT NULL CONSTRAINT "PK_GameRecords" PRIMARY KEY AUTOINCREMENT,
  "UserOpenId" TEXT NOT NULL,
  "Score" INTEGER NOT NULL,
  "Duration" INTEGER NOT NULL,
  "CreateTime" TEXT NOT NULL,
  CONSTRAINT "FK_GameRecords_Users_UserOpenId" FOREIGN KEY ("UserOpenId") REFERENCES "Users" ("OpenId") ON DELETE CASCADE
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
Id INTEGER Rename | Drop
UserOpenId TEXT Rename | Drop
Score INTEGER Rename | Drop
Duration INTEGER Rename | Drop
CreateTime TEXT Rename | Drop

Foreign Keys

Column Destination
UserOpenId Users.OpenId

+ Add index

Indexes

Name Columns Unique SQL Drop?
IX_GameRecords_UserOpenId UserOpenId SQL 
CREATE INDEX "IX_GameRecords_UserOpenId"
ON "GameRecords" ("UserOpenId")
Drop