diff options
| author | Kelly Rauchenberger <fefferburbia@gmail.com> | 2018-03-28 20:45:38 -0400 |
|---|---|---|
| committer | Kelly Rauchenberger <fefferburbia@gmail.com> | 2018-03-28 20:45:38 -0400 |
| commit | 6499b28df7b90025b5045cb343a110a1bdb6dfbe (patch) | |
| tree | 9e3868514753e054d4ef1643c8491a469e063b3e | |
| parent | 1a4650bdbd5d1d37d12da02b1533feee3598c491 (diff) | |
| download | lunatic-6499b28df7b90025b5045cb343a110a1bdb6dfbe.tar.gz lunatic-6499b28df7b90025b5045cb343a110a1bdb6dfbe.tar.bz2 lunatic-6499b28df7b90025b5045cb343a110a1bdb6dfbe.zip | |
Optimized dids table
| -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, |