diff options
| author | Kelly Rauchenberger <fefferburbia@gmail.com> | 2018-03-28 21:12:27 -0400 |
|---|---|---|
| committer | Kelly Rauchenberger <fefferburbia@gmail.com> | 2018-03-28 21:12:27 -0400 |
| commit | 00579b0f77a05530a4ac705f5050944f9962eabb (patch) | |
| tree | 1e4a7becc8c04544ce27eab99468c915e234f687 | |
| parent | 54c8a082aa513cb10860e16a74b7f2e7ae638b2b (diff) | |
| download | lunatic-00579b0f77a05530a4ac705f5050944f9962eabb.tar.gz lunatic-00579b0f77a05530a4ac705f5050944f9962eabb.tar.bz2 lunatic-00579b0f77a05530a4ac705f5050944f9962eabb.zip | |
Added db index for images table
| -rw-r--r-- | schema.sql | 2 |
1 files changed, 2 insertions, 0 deletions
| diff --git a/schema.sql b/schema.sql index c4724f8..373bd55 100644 --- a/schema.sql +++ b/schema.sql | |||
| @@ -31,3 +31,5 @@ CREATE TABLE `images` ( | |||
| 31 | `game_id` INTEGER NOT NULL, | 31 | `game_id` INTEGER NOT NULL, |
| 32 | `filename` VARCHAR(255) NOT NULL | 32 | `filename` VARCHAR(255) NOT NULL |
| 33 | ); | 33 | ); |
| 34 | |||
| 35 | CREATE INDEX `game_images` ON `images`(`game_id`,`image_id`); | ||