From 86ae4d8b3ae8d1a4b3f78567dd8f67aa48ef43a8 Mon Sep 17 00:00:00 2001
From: rvelices <rv-github@modusoptimus.com>
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-pdo-sqlite.sql | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

(limited to 'install/piwigo_structure-pdo-sqlite.sql')

diff --git a/install/piwigo_structure-pdo-sqlite.sql b/install/piwigo_structure-pdo-sqlite.sql
index a0b502fc8..46132f7be 100644
--- a/install/piwigo_structure-pdo-sqlite.sql
+++ b/install/piwigo_structure-pdo-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");
 
-- 
cgit v1.2.3

