From 4c94e100e87a09284f0e0a5bc0df688672492a1e Mon Sep 17 00:00:00 2001 From: Kelly Rauchenberger Date: Sun, 27 Mar 2016 14:28:54 -0400 Subject: Added prefix/suffix search, and word complexity search for nouns, adjectives, and adverbs Word complexity refers to the number of words in a noun, adjective, or adverb. --- generator/schema.sql | 9 ++++++--- 1 file changed, 6 insertions(+), 3 deletions(-) (limited to 'generator/schema.sql') diff --git a/generator/schema.sql b/generator/schema.sql index 2295444..f2445f0 100644 --- a/generator/schema.sql +++ b/generator/schema.sql @@ -36,7 +36,8 @@ CREATE TABLE `adjectives` ( `base_form` VARCHAR(32) NOT NULL, `comparative` VARCHAR(32), `superlative` VARCHAR(32), - `position` CHAR(1) + `position` CHAR(1), + `complexity` INTEGER NOT NULL ); DROP TABLE IF EXISTS `adverbs`; @@ -44,7 +45,8 @@ CREATE TABLE `adverbs` ( `adverb_id` INTEGER PRIMARY KEY, `base_form` VARCHAR(32) NOT NULL, `comparative` VARCHAR(32), - `superlative` VARCHAR(32) + `superlative` VARCHAR(32), + `complexity` INTEGER NOT NULL ); DROP TABLE IF EXISTS `nouns`; @@ -52,7 +54,8 @@ CREATE TABLE `nouns` ( `noun_id` INTEGER PRIMARY KEY, `singular` VARCHAR(32) NOT NULL, `plural` VARCHAR(32), - `proper` INTEGER(1) NOT NULL + `proper` INTEGER(1) NOT NULL, + `complexity` INTEGER NOT NULL ); DROP TABLE IF EXISTS `hypernymy`; -- cgit 1.4.1