From 86ae4d8b3ae8d1a4b3f78567dd8f67aa48ef43a8 Mon Sep 17 00:00:00 2001 From: rvelices Date: Tue, 2 Aug 2011 19:20:50 +0000 Subject: rename #images.average_rate to rating_score git-svn-id: http://piwigo.org/svn/trunk@11893 68402e56-0260-453c-a942-63ccdbb3a9ee --- install/piwigo_structure-pgsql.sql | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'install/piwigo_structure-pgsql.sql') diff --git a/install/piwigo_structure-pgsql.sql b/install/piwigo_structure-pgsql.sql index cf55dea0c..7fb3da355 100644 --- a/install/piwigo_structure-pgsql.sql +++ b/install/piwigo_structure-pgsql.sql @@ -227,7 +227,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, @@ -246,7 +246,7 @@ COMMENT ON TABLE "piwigo_images" IS ''; SET search_path TO public; 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"); -- cgit v1.2.3