From eef5de613c75661e5d94baa086f6f2ddc26c7ed0 Mon Sep 17 00:00:00 2001 From: Kelly Rauchenberger Date: Thu, 24 Mar 2016 23:16:07 -0400 Subject: 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. --- generator/schema.sql | 16 ++++++++++++++-- 1 file changed, 14 insertions(+), 2 deletions(-) (limited to 'generator/schema.sql') 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` ( DROP TABLE IF EXISTS `groups`; CREATE TABLE `groups` ( `group_id` INTEGER PRIMARY KEY, - `parent_id` INTEGER, - FOREIGN KEY (`parent_id`) REFERENCES `groups`(`group_id`) + `data` BLOB NOT NULL ); DROP TABLE IF EXISTS `frames`; @@ -251,3 +250,16 @@ CREATE TABLE `adverb_adverb_derivation` ( FOREIGN KEY (`adverb_1_id`) REFERENCES `adverbs`(`adverb_id`), FOREIGN KEY (`adverb_2_id`) REFERENCES `adverbs`(`adverb_id`) ); + +DROP TABLE IF EXISTS `prepositions`; +CREATE TABLE `prepositions` ( + `preposition_id` INTEGER PRIMARY KEY, + `form` VARCHAR(32) NOT NULL +); + +DROP TABLE IF EXISTS `preposition_groups`; +CREATE TABLE `preposition_groups` ( + `preposition_id` INTEGER NOT NULL, + `groupname` VARCHAR(32) NOT NULL, + FOREIGN KEY (`preposition_id`) REFERENCES `prepositions`(`preposition_id`) +); -- cgit 1.4.1