idiom_game.db — Idioms

SQL

CREATE TABLE "Idioms"  (
  "Id" INTEGER NOT NULL CONSTRAINT "PK_Idioms" PRIMARY KEY AUTOINCREMENT,
  "IdiomName" TEXT NOT NULL,
  "FirstChar" TEXT NOT NULL,
  "PinYin" TEXT NOT NULL,
  "JieShi" TEXT NOT NULL,
  "ChuChu" TEXT NOT NULL,
  "JianPin" TEXT NOT NULL,
  "ChengDu" TEXT NOT NULL,
  "SeCai" TEXT NOT NULL,
  "JinYiCi" TEXT NOT NULL,
  "FanYiCi" TEXT NOT NULL,
  "HtmlLink" TEXT NOT NULL,
  "PinYin_Without_Tone" TEXT NOT NULL DEFAULT ''
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
Id INTEGER Rename | Drop
IdiomName TEXT Rename | Drop
FirstChar TEXT Rename | Drop
PinYin TEXT Rename | Drop
JieShi TEXT Rename | Drop
ChuChu TEXT Rename | Drop
JianPin TEXT Rename | Drop
ChengDu TEXT Rename | Drop
SeCai TEXT Rename | Drop
JinYiCi TEXT Rename | Drop
FanYiCi TEXT Rename | Drop
HtmlLink TEXT Rename | Drop
PinYin_Without_Tone TEXT Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
IDX_Idioms_PinYin_Without_Tone PinYin_Without_Tone SQL 
CREATE INDEX "IDX_Idioms_PinYin_Without_Tone"
ON "Idioms" ("PinYin_Without_Tone")
Drop