idiom_game.db — Users

SQL

CREATE TABLE "Users"  (
  "OpenId" TEXT NOT NULL CONSTRAINT "PK_Users" PRIMARY KEY,
  "NickName" TEXT NOT NULL,
  "AvatarUrl" TEXT NOT NULL,
  "Score" INTEGER NOT NULL,
  "CreateTime" TEXT NOT NULL
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
OpenId TEXT Rename | Drop
NickName TEXT Rename | Drop
AvatarUrl TEXT Rename | Drop
Score INTEGER Rename | Drop
CreateTime TEXT Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
sqlite_autoindex_Users_1 OpenId SQL
-- no sql found --
 Drop