From 251248adfab36b061eb8fdd08aa54b318462da65 Mon Sep 17 00:00:00 2001 From: Kelly Rauchenberger Date: Wed, 28 Mar 2018 15:49:50 -0400 Subject: Revamped bot with new algorithm The percentages currently used by the generator are trial-and-error and may be changed in the future. refs #1 --- generator/schema.sql | 10 ++++++++-- 1 file changed, 8 insertions(+), 2 deletions(-) (limited to 'generator/schema.sql') diff --git a/generator/schema.sql b/generator/schema.sql index 879ebb3..7d211ba 100644 --- a/generator/schema.sql +++ b/generator/schema.sql @@ -1,5 +1,11 @@ CREATE TABLE `songs` ( + `song_id` INTEGER PRIMARY KEY, `title` VARCHAR(255) NOT NULL, - `artist` VARCHAR(255) NOT NULL, - `category` VARCHAR(255) NOT NULL + `artist` VARCHAR(255) NOT NULL ); + +CREATE TABLE `moods` ( + `song_id` INTEGER, + `mood` VARCHAR(255), + PRIMARY KEY (`song_id`, `mood`) +) WITHOUT ROWID; -- cgit 1.4.1