diff options
| author | Kelly Rauchenberger <fefferburbia@gmail.com> | 2018-03-28 15:49:50 -0400 |
|---|---|---|
| committer | Kelly Rauchenberger <fefferburbia@gmail.com> | 2018-03-28 15:49:50 -0400 |
| commit | 251248adfab36b061eb8fdd08aa54b318462da65 (patch) | |
| tree | 4ff1eb792a1e1b442ec2fa6a99e01b28518c5cf4 /generator/schema.sql | |
| parent | af49d3435302118d036c512aef1def848fb88089 (diff) | |
| download | cadence-251248adfab36b061eb8fdd08aa54b318462da65.tar.gz cadence-251248adfab36b061eb8fdd08aa54b318462da65.tar.bz2 cadence-251248adfab36b061eb8fdd08aa54b318462da65.zip | |
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
Diffstat (limited to 'generator/schema.sql')
| -rw-r--r-- | generator/schema.sql | 10 |
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 @@ | |||
| 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; | ||