diff options
Diffstat (limited to 'install/piwigo_structure-sqlite.sql')
| -rw-r--r-- | install/piwigo_structure-sqlite.sql | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/install/piwigo_structure-sqlite.sql b/install/piwigo_structure-sqlite.sql index a0b502fc8..46132f7be 100644 --- a/install/piwigo_structure-sqlite.sql +++ b/install/piwigo_structure-sqlite.sql @@ -183,7 +183,7 @@ CREATE TABLE piwigo_images "height" INTEGER, "representative_ext" VARCHAR(4), "date_metadata_update" DATE, - "average_rate" FLOAT, + "rating_score" FLOAT, "has_high" BOOLEAN default false, "path" VARCHAR(255) default '' NOT NULL, "storage_category_id" INTEGER, @@ -199,7 +199,7 @@ CREATE TABLE piwigo_images CREATE INDEX "images_i2" ON "piwigo_images" ("date_available"); -CREATE INDEX "images_i3" ON "piwigo_images" ("average_rate"); +CREATE INDEX "images_i3" ON "piwigo_images" ("rating_score"); CREATE INDEX "images_i4" ON "piwigo_images" ("hit"); |