1 files changed, 2 insertions, 0 deletions
diff --git a/generator/schema.sql b/generator/schema.sql
index 2ac658c..c07bf57 100644
--- a/generator/schema.sql
+++ b/generator/schema.sql

@@ -178,6 +178,8 @@ CREATE TABLE `pronunciations` (
  `stress` VARCHAR(64) NOT NULL
 );
+CREATE INDEX `rhymes_with` ON `pronunciations`(`rhyme`);
 CREATE TABLE `forms_pronunciations` (
  `form_id` INTEGER NOT NULL,
  `pronunciation_id` INTEGER NOT NULL

diff --git a/generator/schema.sql b/generator/schema.sql index 2ac658c..c07bf57 100644 --- a/generator/schema.sql +++ b/generator/schema.sql
@@ -178,6 +178,8 @@ 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`);
		182
181	CREATE TABLE `forms_pronunciations` (	183	CREATE TABLE `forms_pronunciations` (
182	`form_id` INTEGER NOT NULL,	184	`form_id` INTEGER NOT NULL,
183	`pronunciation_id` INTEGER NOT NULL	185	`pronunciation_id` INTEGER NOT NULL