From 251248adfab36b061eb8fdd08aa54b318462da65 Mon Sep 17 00:00:00 2001
From: Kelly Rauchenberger <fefferburbia@gmail.com>
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

