Changeset 11893 for trunk/install/piwigo_structure-pgsql.sql

Timestamp:

Aug 2, 2011, 9:20:50 PM (13 years ago)

Author:

rvelices

Message:

rename #images.average_rate to rating_score

File:

• trunk/install/piwigo_structure-pgsql.sql (modified) (2 diffs)

trunk/install/piwigo_structure-pgsql.sql

@@ -228 +228 @@
   "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,
@@ -247 +247 @@
 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");