1 files changed, 8 insertions, 2 deletions
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,
+  `artist` VARCHAR(255) NOT NULL
-  `category` VARCHAR(255) NOT NULL
 );
+CREATE TABLE `moods` (
+  `song_id` INTEGER,
+  `mood` VARCHAR(255),
+  PRIMARY KEY (`song_id`, `mood`)
+) WITHOUT ROWID;

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 @@
1	CREATE TABLE `songs` (	1	CREATE TABLE `songs` (
		2	`song_id` INTEGER PRIMARY KEY,
2	`title` VARCHAR(255) NOT NULL,	3	`title` VARCHAR(255) NOT NULL,
3	`artist` VARCHAR(255) NOT NULL,	4	`artist` VARCHAR(255) NOT NULL
4	`category` VARCHAR(255) NOT NULL
5	);	5	);
		6
		7	CREATE TABLE `moods` (
		8	`song_id` INTEGER,
		9	`mood` VARCHAR(255),
		10	PRIMARY KEY (`song_id`, `mood`)
		11	) WITHOUT ROWID;