diff options
Diffstat (limited to 'generator/schema.sql')
-rw-r--r-- | generator/schema.sql | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/generator/schema.sql b/generator/schema.sql index 1836c62..410b536 100644 --- a/generator/schema.sql +++ b/generator/schema.sql | |||
@@ -186,6 +186,8 @@ CREATE TABLE `noun_pronunciations` ( | |||
186 | `pronunciation` VARCHAR(64) NOT NULL, | 186 | `pronunciation` VARCHAR(64) NOT NULL, |
187 | `prerhyme` VARCHAR(8), | 187 | `prerhyme` VARCHAR(8), |
188 | `rhyme` VARCHAR(64), | 188 | `rhyme` VARCHAR(64), |
189 | `syllables` INT NOT NULL, | ||
190 | `stress` VARCHAR(64) NOT NULL, | ||
189 | FOREIGN KEY (`noun_id`) REFERENCES `nouns`(`noun_id`) | 191 | FOREIGN KEY (`noun_id`) REFERENCES `nouns`(`noun_id`) |
190 | ); | 192 | ); |
191 | 193 | ||
@@ -195,6 +197,8 @@ CREATE TABLE `verb_pronunciations` ( | |||
195 | `pronunciation` VARCHAR(64) NOT NULL, | 197 | `pronunciation` VARCHAR(64) NOT NULL, |
196 | `prerhyme` VARCHAR(8), | 198 | `prerhyme` VARCHAR(8), |
197 | `rhyme` VARCHAR(64), | 199 | `rhyme` VARCHAR(64), |
200 | `syllables` INT NOT NULL, | ||
201 | `stress` VARCHAR(64) NOT NULL, | ||
198 | FOREIGN KEY (`verb_id`) REFERENCES `verbs`(`verb_id`) | 202 | FOREIGN KEY (`verb_id`) REFERENCES `verbs`(`verb_id`) |
199 | ); | 203 | ); |
200 | 204 | ||
@@ -204,6 +208,8 @@ CREATE TABLE `adjective_pronunciations` ( | |||
204 | `pronunciation` VARCHAR(64) NOT NULL, | 208 | `pronunciation` VARCHAR(64) NOT NULL, |
205 | `prerhyme` VARCHAR(8), | 209 | `prerhyme` VARCHAR(8), |
206 | `rhyme` VARCHAR(64), | 210 | `rhyme` VARCHAR(64), |
211 | `syllables` INT NOT NULL, | ||
212 | `stress` VARCHAR(64) NOT NULL, | ||
207 | FOREIGN KEY (`adjective_id`) REFERENCES `adjectives`(`adjective_id`) | 213 | FOREIGN KEY (`adjective_id`) REFERENCES `adjectives`(`adjective_id`) |
208 | ); | 214 | ); |
209 | 215 | ||
@@ -213,6 +219,8 @@ CREATE TABLE `adverb_pronunciations` ( | |||
213 | `pronunciation` VARCHAR(64) NOT NULL, | 219 | `pronunciation` VARCHAR(64) NOT NULL, |
214 | `prerhyme` VARCHAR(8), | 220 | `prerhyme` VARCHAR(8), |
215 | `rhyme` VARCHAR(64), | 221 | `rhyme` VARCHAR(64), |
222 | `syllables` INT NOT NULL, | ||
223 | `stress` VARCHAR(64) NOT NULL, | ||
216 | FOREIGN KEY (`adverb_id`) REFERENCES `adverbs`(`adverb_id`) | 224 | FOREIGN KEY (`adverb_id`) REFERENCES `adverbs`(`adverb_id`) |
217 | ); | 225 | ); |
218 | 226 | ||