diff options
author | Kelly Rauchenberger <fefferburbia@gmail.com> | 2016-03-24 23:16:07 -0400 |
---|---|---|
committer | Kelly Rauchenberger <fefferburbia@gmail.com> | 2016-03-24 23:16:07 -0400 |
commit | eef5de613c75661e5d94baa086f6f2ddc26c7ed0 (patch) | |
tree | 180230f6a245c5bca94d894273f5d2b93ded3f04 /generator/schema.sql | |
parent | d5ee4e39e5b5b3b8daa85cd972802195ad35e965 (diff) | |
download | verbly-eef5de613c75661e5d94baa086f6f2ddc26c7ed0.tar.gz verbly-eef5de613c75661e5d94baa086f6f2ddc26c7ed0.tar.bz2 verbly-eef5de613c75661e5d94baa086f6f2ddc26c7ed0.zip |
Added verb frames
In addition: - Added prepositions. - Rewrote a lot of the query interface. It now, for a lot of relationships, supports nested AND, OR, and NOT logic. - Rewrote the token class. It is now a union-like class instead of being polymorphic, which means smart pointers are no longer necessary. - Querying with regards to word derivation has been temporarily removed. - Sentinel values are now supported for all word types. - The VerbNet data retrieved from http://verbs.colorado.edu/~mpalmer/projects/verbnet/downloads.html was found to not be perfectly satisfactory in some regards, especially regarding adjective phrases. A patch file is now included in the repository describing the changes made to the VerbNet v3.2 download for the canonical verbly datafile.
Diffstat (limited to 'generator/schema.sql')
-rw-r--r-- | generator/schema.sql | 16 |
1 files changed, 14 insertions, 2 deletions
diff --git a/generator/schema.sql b/generator/schema.sql index 8e1e822..2295444 100644 --- a/generator/schema.sql +++ b/generator/schema.sql | |||
@@ -11,8 +11,7 @@ CREATE TABLE `verbs` ( | |||
11 | DROP TABLE IF EXISTS `groups`; | 11 | DROP TABLE IF EXISTS `groups`; |
12 | CREATE TABLE `groups` ( | 12 | CREATE TABLE `groups` ( |
13 | `group_id` INTEGER PRIMARY KEY, | 13 | `group_id` INTEGER PRIMARY KEY, |
14 | `parent_id` INTEGER, | 14 | `data` BLOB NOT NULL |
15 | FOREIGN KEY (`parent_id`) REFERENCES `groups`(`group_id`) | ||
16 | ); | 15 | ); |
17 | 16 | ||
18 | DROP TABLE IF EXISTS `frames`; | 17 | DROP TABLE IF EXISTS `frames`; |
@@ -251,3 +250,16 @@ CREATE TABLE `adverb_adverb_derivation` ( | |||
251 | FOREIGN KEY (`adverb_1_id`) REFERENCES `adverbs`(`adverb_id`), | 250 | FOREIGN KEY (`adverb_1_id`) REFERENCES `adverbs`(`adverb_id`), |
252 | FOREIGN KEY (`adverb_2_id`) REFERENCES `adverbs`(`adverb_id`) | 251 | FOREIGN KEY (`adverb_2_id`) REFERENCES `adverbs`(`adverb_id`) |
253 | ); | 252 | ); |
253 | |||
254 | DROP TABLE IF EXISTS `prepositions`; | ||
255 | CREATE TABLE `prepositions` ( | ||
256 | `preposition_id` INTEGER PRIMARY KEY, | ||
257 | `form` VARCHAR(32) NOT NULL | ||
258 | ); | ||
259 | |||
260 | DROP TABLE IF EXISTS `preposition_groups`; | ||
261 | CREATE TABLE `preposition_groups` ( | ||
262 | `preposition_id` INTEGER NOT NULL, | ||
263 | `groupname` VARCHAR(32) NOT NULL, | ||
264 | FOREIGN KEY (`preposition_id`) REFERENCES `prepositions`(`preposition_id`) | ||
265 | ); | ||