aboutsummaryrefslogtreecommitdiffstats
path: root/install/piwigo_structure-pgsql.sql
diff options
context:
space:
mode:
authorrvelices <rv-github@modusoptimus.com>2011-08-02 19:20:50 +0000
committerrvelices <rv-github@modusoptimus.com>2011-08-02 19:20:50 +0000
commit86ae4d8b3ae8d1a4b3f78567dd8f67aa48ef43a8 (patch)
treecf4067b3b6298d2f700b6b5f59187ffe8e4efc55 /install/piwigo_structure-pgsql.sql
parenta61fea92834dcadc8c1a648ca1fdb2c56d2079cd (diff)
rename #images.average_rate to rating_score
git-svn-id: http://piwigo.org/svn/trunk@11893 68402e56-0260-453c-a942-63ccdbb3a9ee
Diffstat (limited to 'install/piwigo_structure-pgsql.sql')
-rw-r--r--install/piwigo_structure-pgsql.sql4
1 files changed, 2 insertions, 2 deletions
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");