diff options
author | Kelly Rauchenberger <fefferburbia@gmail.com> | 2016-03-16 11:27:16 -0400 |
---|---|---|
committer | Kelly Rauchenberger <fefferburbia@gmail.com> | 2016-03-16 11:27:16 -0400 |
commit | 3aceae8ab1eb5992110ea57a9479bbc3177feb21 (patch) | |
tree | 13167a266805344efb7bb1d900486f782c23285e /schema.sql | |
parent | e1be2716746e75cf6ed37e86461a7f580a964564 (diff) | |
download | furries-3aceae8ab1eb5992110ea57a9479bbc3177feb21.tar.gz furries-3aceae8ab1eb5992110ea57a9479bbc3177feb21.tar.bz2 furries-3aceae8ab1eb5992110ea57a9479bbc3177feb21.zip |
Added more inflections, word relationships, and pronunciations
Nouns, adjectives, and adverbs now have inflected forms. A large number of WordNet word relationships (all noun-noun relationships, plus synonymy and antonymy for all word types except verbs) have been added. Additionally, CMUDICT is now being used to store word pronunciations for rhyming purposes. Verbly is now also a compiled library rather than being header-only due to the complexity of the query interface.
Diffstat (limited to 'schema.sql')
-rw-r--r-- | schema.sql | 59 |
1 files changed, 54 insertions, 5 deletions
diff --git a/schema.sql b/schema.sql index 62dd780..fd55734 100644 --- a/schema.sql +++ b/schema.sql | |||
@@ -34,20 +34,25 @@ CREATE TABLE `verb_groups` ( | |||
34 | DROP TABLE IF EXISTS `adjectives`; | 34 | DROP TABLE IF EXISTS `adjectives`; |
35 | CREATE TABLE `adjectives` ( | 35 | CREATE TABLE `adjectives` ( |
36 | `adjective_id` INTEGER PRIMARY KEY, | 36 | `adjective_id` INTEGER PRIMARY KEY, |
37 | `form` VARCHAR(32) NOT NULL, | 37 | `base_form` VARCHAR(32) NOT NULL, |
38 | `comparative` VARCHAR(32), | ||
39 | `superlative` VARCHAR(32), | ||
38 | `position` CHAR(1) | 40 | `position` CHAR(1) |
39 | ); | 41 | ); |
40 | 42 | ||
41 | DROP TABLE IF EXISTS `adverbs`; | 43 | DROP TABLE IF EXISTS `adverbs`; |
42 | CREATE TABLE `adverbs` ( | 44 | CREATE TABLE `adverbs` ( |
43 | `adverb_id` INTEGER PRIMARY KEY, | 45 | `adverb_id` INTEGER PRIMARY KEY, |
44 | `form` VARCHAR(32) NOT NULL | 46 | `base_form` VARCHAR(32) NOT NULL, |
47 | `comparative` VARCHAR(32), | ||
48 | `superlative` VARCHAR(32) | ||
45 | ); | 49 | ); |
46 | 50 | ||
47 | DROP TABLE IF EXISTS `nouns`; | 51 | DROP TABLE IF EXISTS `nouns`; |
48 | CREATE TABLE `nouns` ( | 52 | CREATE TABLE `nouns` ( |
49 | `noun_id` INTEGER PRIMARY KEY, | 53 | `noun_id` INTEGER PRIMARY KEY, |
50 | `form` VARCHAR(32) NOT NULL | 54 | `singular` VARCHAR(32) NOT NULL, |
55 | `plural` VARCHAR(32) | ||
51 | ); | 56 | ); |
52 | 57 | ||
53 | DROP TABLE IF EXISTS `hypernymy`; | 58 | DROP TABLE IF EXISTS `hypernymy`; |
@@ -146,10 +151,54 @@ CREATE TABLE `mannernymy` ( | |||
146 | FOREIGN KEY (`mannernym_id`) REFERENCES `adverbs`(`adverb_id`) | 151 | FOREIGN KEY (`mannernym_id`) REFERENCES `adverbs`(`adverb_id`) |
147 | ); | 152 | ); |
148 | 153 | ||
149 | DROP TABLE IF EXISTS `synonymy`; | 154 | DROP TABLE IF EXISTS `noun_synonymy`; |
150 | CREATE TABLE `synonymy` ( | 155 | CREATE TABLE `noun_synonymy` ( |
156 | `noun_1_id` INTEGER NOT NULL, | ||
157 | `noun_2_id` INTEGER NOT NULL, | ||
158 | FOREIGN KEY (`noun_1_id`) REFERENCES `nouns`(`nouns_id`), | ||
159 | FOREIGN KEY (`noun_2_id`) REFERENCES `nouns`(`nouns_id`) | ||
160 | ); | ||
161 | |||
162 | DROP TABLE IF EXISTS `adjective_synonymy`; | ||
163 | CREATE TABLE `adjective_synonymy` ( | ||
151 | `adjective_1_id` INTEGER NOT NULL, | 164 | `adjective_1_id` INTEGER NOT NULL, |
152 | `adjective_2_id` INTEGER NOT NULL, | 165 | `adjective_2_id` INTEGER NOT NULL, |
153 | FOREIGN KEY (`adjective_1_id`) REFERENCES `adjectives`(`adjective_id`), | 166 | FOREIGN KEY (`adjective_1_id`) REFERENCES `adjectives`(`adjective_id`), |
154 | FOREIGN KEY (`adjective_2_id`) REFERENCES `adjectives`(`adjective_id`) | 167 | FOREIGN KEY (`adjective_2_id`) REFERENCES `adjectives`(`adjective_id`) |
155 | ); | 168 | ); |
169 | |||
170 | DROP TABLE IF EXISTS `adverb_synonymy`; | ||
171 | CREATE TABLE `adverb_synonymy` ( | ||
172 | `adverb_1_id` INTEGER NOT NULL, | ||
173 | `adverb_2_id` INTEGER NOT NULL, | ||
174 | FOREIGN KEY (`adverb_1_id`) REFERENCES `adverbs`(`adverb_id`), | ||
175 | FOREIGN KEY (`adverb_2_id`) REFERENCES `adverbs`(`adverb_id`) | ||
176 | ); | ||
177 | |||
178 | DROP TABLE IF EXISTS `noun_pronunciations`; | ||
179 | CREATE TABLE `noun_pronunciations` ( | ||
180 | `noun_id` INTEGER NOT NULL, | ||
181 | `pronunciation` VARCHAR(64) NOT NULL, | ||
182 | FOREIGN KEY (`noun_id`) REFERENCES `nouns`(`noun_id`) | ||
183 | ); | ||
184 | |||
185 | DROP TABLE IF EXISTS `verb_pronunciations`; | ||
186 | CREATE TABLE `verb_pronunciations` ( | ||
187 | `verb_id` INTEGER NOT NULL, | ||
188 | `pronunciation` VARCHAR(64) NOT NULL, | ||
189 | FOREIGN KEY (`verb_id`) REFERENCES `verbs`(`verb_id`) | ||
190 | ); | ||
191 | |||
192 | DROP TABLE IF EXISTS `adjective_pronunciations`; | ||
193 | CREATE TABLE `adjective_pronunciations` ( | ||
194 | `adjective_id` INTEGER NOT NULL, | ||
195 | `pronunciation` VARCHAR(64) NOT NULL, | ||
196 | FOREIGN KEY (`adjective_id`) REFERENCES `adjectives`(`adjective_id`) | ||
197 | ); | ||
198 | |||
199 | DROP TABLE IF EXISTS `adverb_pronunciations`; | ||
200 | CREATE TABLE `adverb_pronunciations` ( | ||
201 | `adverb_id` INTEGER NOT NULL, | ||
202 | `pronunciation` VARCHAR(64) NOT NULL, | ||
203 | FOREIGN KEY (`adverb_id`) REFERENCES `adverbs`(`adverb_id`) | ||
204 | ); | ||