diff options
| -rw-r--r-- | schema.sql | 7 |
1 files changed, 4 insertions, 3 deletions
| diff --git a/schema.sql b/schema.sql index ade7522..c4724f8 100644 --- a/schema.sql +++ b/schema.sql | |||
| @@ -20,10 +20,11 @@ CREATE TABLE `achievements` ( | |||
| 20 | ); | 20 | ); |
| 21 | 21 | ||
| 22 | CREATE TABLE `dids` ( | 22 | CREATE TABLE `dids` ( |
| 23 | `profile_id` INTEGER NOT NULL, | ||
| 24 | `achievement_id` INTEGER NOT NULL, | 23 | `achievement_id` INTEGER NOT NULL, |
| 25 | `achieved_at` DATETIME NOT NULL | 24 | `profile_id` INTEGER NOT NULL, |
| 26 | ); | 25 | `achieved_at` DATETIME NOT NULL, |
| 26 | PRIMARY KEY (`achievement_id`, `profile_id`) | ||
| 27 | ) WITHOUT ROWID; | ||
| 27 | 28 | ||
| 28 | CREATE TABLE `images` ( | 29 | CREATE TABLE `images` ( |
| 29 | `image_id` INTEGER PRIMARY KEY, | 30 | `image_id` INTEGER PRIMARY KEY, |