1 files changed, 3 insertions, 3 deletions
diff --git a/generator/schema.sql b/generator/schema.sql
index 5b42d52..a49a853 100644
--- a/generator/schema.sql
+++ b/generator/schema.sql

@@ -92,8 +92,8 @@ CREATE TABLE `words` (
  `group_id` INTEGER
 );
-CREATE INDEX `notion_words` ON `words`(`notion_id`);
+CREATE INDEX `notions_lemmas` ON `words`(`notion_id`,`lemma_id`);
-CREATE INDEX `lemma_words` ON `words`(`lemma_id`);
+CREATE INDEX `lemmas_notions` ON `words`(`lemma_id`,`notion_id`);
 CREATE INDEX `group_words` ON `words`(`group_id`);
 CREATE TABLE `antonymy` (
@@ -178,7 +178,7 @@ CREATE TABLE `pronunciations` (
  `stress` VARCHAR(64) NOT NULL
 );
-CREATE INDEX `rhymes_with` ON `pronunciations`(`rhyme`);
+CREATE INDEX `rhymes_with` ON `pronunciations`(`rhyme`,`prerhyme`);
 CREATE TABLE `forms_pronunciations` (
  `form_id` INTEGER NOT NULL,

diff --git a/generator/schema.sql b/generator/schema.sql index 5b42d52..a49a853 100644 --- a/generator/schema.sql +++ b/generator/schema.sql
@@ -92,8 +92,8 @@ CREATE TABLE `words` (
92	`group_id` INTEGER	92	`group_id` INTEGER
93	);	93	);
94		94
95	CREATE INDEX `notion_words` ON `words`(`notion_id`);	95	CREATE INDEX `notions_lemmas` ON `words`(`notion_id`,`lemma_id`);
96	CREATE INDEX `lemma_words` ON `words`(`lemma_id`);	96	CREATE INDEX `lemmas_notions` ON `words`(`lemma_id`,`notion_id`);
97	CREATE INDEX `group_words` ON `words`(`group_id`);	97	CREATE INDEX `group_words` ON `words`(`group_id`);
98		98
99	CREATE TABLE `antonymy` (	99	CREATE TABLE `antonymy` (
@@ -178,7 +178,7 @@ CREATE TABLE `pronunciations` (
178	`stress` VARCHAR(64) NOT NULL	178	`stress` VARCHAR(64) NOT NULL
179	);	179	);
180		180
181	CREATE INDEX `rhymes_with` ON `pronunciations`(`rhyme`);	181	CREATE INDEX `rhymes_with` ON `pronunciations`(`rhyme`,`prerhyme`);
182		182
183	CREATE TABLE `forms_pronunciations` (	183	CREATE TABLE `forms_pronunciations` (
184	`form_id` INTEGER NOT NULL,	184	`form_id` INTEGER NOT NULL,