15 lines
499 B
SQL
15 lines
499 B
SQL
CREATE TABLE "KANJIDIC_Character__lookup_romaji"(
|
|
"kanji" CHAR(1) NOT NULL REFERENCES "KANJIDIC_Character"("literal"),
|
|
"romaji" TEXT NOT NULL,
|
|
PRIMARY KEY("kanji", "romaji")
|
|
) WITHOUT ROWID;
|
|
|
|
CREATE TABLE "KANJIDIC_Character__lookup_hiragana"(
|
|
"kanji" CHAR(1) NOT NULL REFERENCES "KANJIDIC_Character"("literal"),
|
|
"hiragana" TEXT NOT NULL,
|
|
PRIMARY KEY("kanji", "hiragana")
|
|
) WITHOUT ROWID;
|
|
|
|
-- index kanji search by hiragana
|
|
-- index word search by romaji
|
|
-- index word search by hiragana |