generator/schema.sql


1
2
3
4
5
6
7
8
9
10
11

CREATE TABLE `songs` (
  `song_id` INTEGER PRIMARY KEY,
  `title` 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;