From 6c2aca03c89b37e136ab4c7ea58b485dadc85bcd Mon Sep 17 00:00:00 2001
From: Kelly Rauchenberger <fefferburbia@gmail.com>
Date: Mon, 30 May 2016 11:31:20 -0400
Subject: Added pronunciation syllable count and stress structure

Also updated CMakeLists.txt such that including projects don't have to include sqlite3.
---
 generator/schema.sql | 8 ++++++++
 1 file changed, 8 insertions(+)

(limited to 'generator/schema.sql')

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` (
   `pronunciation` VARCHAR(64) NOT NULL,
   `prerhyme` VARCHAR(8),
   `rhyme` VARCHAR(64),
+  `syllables` INT NOT NULL,
+  `stress` VARCHAR(64) NOT NULL,
   FOREIGN KEY (`noun_id`) REFERENCES `nouns`(`noun_id`)
 );
 
@@ -195,6 +197,8 @@ CREATE TABLE `verb_pronunciations` (
   `pronunciation` VARCHAR(64) NOT NULL,
   `prerhyme` VARCHAR(8),
   `rhyme` VARCHAR(64),
+  `syllables` INT NOT NULL,
+  `stress` VARCHAR(64) NOT NULL,
   FOREIGN KEY (`verb_id`) REFERENCES `verbs`(`verb_id`)
 );
 
@@ -204,6 +208,8 @@ CREATE TABLE `adjective_pronunciations` (
   `pronunciation` VARCHAR(64) NOT NULL,
   `prerhyme` VARCHAR(8),
   `rhyme` VARCHAR(64),
+  `syllables` INT NOT NULL,
+  `stress` VARCHAR(64) NOT NULL,
   FOREIGN KEY (`adjective_id`) REFERENCES `adjectives`(`adjective_id`)
 );
 
@@ -213,6 +219,8 @@ CREATE TABLE `adverb_pronunciations` (
   `pronunciation` VARCHAR(64) NOT NULL,
   `prerhyme` VARCHAR(8),
   `rhyme` VARCHAR(64),
+  `syllables` INT NOT NULL,
+  `stress` VARCHAR(64) NOT NULL,
   FOREIGN KEY (`adverb_id`) REFERENCES `adverbs`(`adverb_id`)
 );
 
-- 
cgit 1.4.1

