diff options
| author | rvelices <rv-github@modusoptimus.com> | 2011-08-02 19:20:50 +0000 |
|---|---|---|
| committer | rvelices <rv-github@modusoptimus.com> | 2011-08-02 19:20:50 +0000 |
| commit | 86ae4d8b3ae8d1a4b3f78567dd8f67aa48ef43a8 (patch) | |
| tree | cf4067b3b6298d2f700b6b5f59187ffe8e4efc55 /install/piwigo_structure-pgsql.sql | |
| parent | a61fea92834dcadc8c1a648ca1fdb2c56d2079cd (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.sql | 4 |
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"); |