diff options
author | Star Rauchenberger <fefferburbia@gmail.com> | 2022-12-08 15:03:51 -0500 |
---|---|---|
committer | Star Rauchenberger <fefferburbia@gmail.com> | 2022-12-08 15:03:51 -0500 |
commit | 7ea3569e3894f19fbae6cfdb3406f2240570e3c1 (patch) | |
tree | e04caa4058baa9f0a9ff46771eef903be49ce3cb /generator/schema.sql | |
parent | 6816abc1e89fd955524d7c772477d6483d12cbf9 (diff) | |
download | verbly-7ea3569e3894f19fbae6cfdb3406f2240570e3c1.tar.gz verbly-7ea3569e3894f19fbae6cfdb3406f2240570e3c1.tar.bz2 verbly-7ea3569e3894f19fbae6cfdb3406f2240570e3c1.zip |
Added a bunch of stuff for making LINGO puzzles
Diffstat (limited to 'generator/schema.sql')
-rw-r--r-- | generator/schema.sql | 24 |
1 files changed, 22 insertions, 2 deletions
diff --git a/generator/schema.sql b/generator/schema.sql index 6a7d223..8c910f4 100644 --- a/generator/schema.sql +++ b/generator/schema.sql | |||
@@ -160,7 +160,9 @@ CREATE TABLE `forms` ( | |||
160 | `form` VARCHAR(32) NOT NULL, | 160 | `form` VARCHAR(32) NOT NULL, |
161 | `complexity` SMALLINT NOT NULL, | 161 | `complexity` SMALLINT NOT NULL, |
162 | `proper` SMALLINT NOT NULL, | 162 | `proper` SMALLINT NOT NULL, |
163 | `length` SMALLINT NOT NULL | 163 | `length` SMALLINT NOT NULL, |
164 | `anagram_set_id` INTEGER NOT NULL, | ||
165 | `reverse_form_id` INTEGER NOT NULL | ||
164 | ); | 166 | ); |
165 | 167 | ||
166 | CREATE UNIQUE INDEX `form_by_string` ON `forms`(`form`); | 168 | CREATE UNIQUE INDEX `form_by_string` ON `forms`(`form`); |
@@ -174,13 +176,23 @@ CREATE TABLE `lemmas_forms` ( | |||
174 | 176 | ||
175 | CREATE INDEX `forms_lemmas` ON `lemmas_forms`(`form_id`,`category`,`lemma_id`); | 177 | CREATE INDEX `forms_lemmas` ON `lemmas_forms`(`form_id`,`category`,`lemma_id`); |
176 | 178 | ||
179 | CREATE TABLE `merography` ( | ||
180 | `merograph_id` INTEGER NOT NULL, | ||
181 | `holograph_id` INTEGER NOT NULL, | ||
182 | PRIMARY KEY(`merograph_id`,`holograph_id`) | ||
183 | ) WITHOUT ROWID; | ||
184 | |||
185 | CREATE INDEX `reverse_merography` ON `merography`(`holograph_id`,`merograph_id`); | ||
186 | |||
177 | CREATE TABLE `pronunciations` ( | 187 | CREATE TABLE `pronunciations` ( |
178 | `pronunciation_id` INTEGER PRIMARY KEY, | 188 | `pronunciation_id` INTEGER PRIMARY KEY, |
179 | `phonemes` VARCHAR(64) NOT NULL, | 189 | `phonemes` VARCHAR(64) NOT NULL, |
180 | `prerhyme` VARCHAR(8), | 190 | `prerhyme` VARCHAR(8), |
181 | `rhyme` VARCHAR(64), | 191 | `rhyme` VARCHAR(64), |
182 | `syllables` INTEGER NOT NULL, | 192 | `syllables` INTEGER NOT NULL, |
183 | `stress` VARCHAR(64) NOT NULL | 193 | `stress` VARCHAR(64) NOT NULL, |
194 | `anaphone_set_id` INTEGER NOT NULL, | ||
195 | `reverse_pronunciation_id` INTEGER NOT NULL | ||
184 | ); | 196 | ); |
185 | 197 | ||
186 | CREATE INDEX `rhymes_with` ON `pronunciations`(`rhyme`,`prerhyme`); | 198 | CREATE INDEX `rhymes_with` ON `pronunciations`(`rhyme`,`prerhyme`); |
@@ -193,6 +205,14 @@ CREATE TABLE `forms_pronunciations` ( | |||
193 | 205 | ||
194 | CREATE INDEX `pronunciations_forms` ON `forms_pronunciations`(`pronunciation_id`,`form_id`); | 206 | CREATE INDEX `pronunciations_forms` ON `forms_pronunciations`(`pronunciation_id`,`form_id`); |
195 | 207 | ||
208 | CREATE TABLE `merophony` ( | ||
209 | `merophone_id` INTEGER NOT NULL, | ||
210 | `holophone_id` INTEGER NOT NULL, | ||
211 | PRIMARY KEY(`merophone_id`,`holophone_id`) | ||
212 | ) WITHOUT ROWID; | ||
213 | |||
214 | CREATE INDEX `reverse_merophony` ON `merophony`(`holophone_id`,`merophone_id`); | ||
215 | |||
196 | CREATE TABLE `frames` ( | 216 | CREATE TABLE `frames` ( |
197 | `frame_id` INTEGER NOT NULL, | 217 | `frame_id` INTEGER NOT NULL, |
198 | `group_id` INTEGER NOT NULL, | 218 | `group_id` INTEGER NOT NULL, |