Changeset 11893 for trunk/install

Timestamp:

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

Author:

rvelices

Message:

rename #images.average_rate to rating_score

Location:

trunk/install

Files:

• config.sql (modified) (1 diff)
• db/109-database.php (added)
• piwigo_structure-mysql.sql (modified) (2 diffs)
• piwigo_structure-pdo-sqlite.sql (modified) (2 diffs)
• piwigo_structure-pgsql.sql (modified) (2 diffs)
• piwigo_structure-sqlite.sql (modified) (2 diffs)

trunk/install/config.sql

@@ -48 +48 @@
   VALUES (
     'picture_informations',
-    'a:11:{s:6:"author";b:1;s:10:"created_on";b:1;s:9:"posted_on";b:1;s:10:"dimensions";b:1;s:4:"file";b:1;s:8:"filesize";b:1;s:4:"tags";b:1;s:10:"categories";b:1;s:6:"visits";b:1;s:12:"average_rate";b:1;s:13:"privacy_level";b:1;}',
+    'a:11:{s:6:"author";b:1;s:10:"created_on";b:1;s:9:"posted_on";b:1;s:10:"dimensions";b:1;s:4:"file";b:1;s:8:"filesize";b:1;s:4:"tags";b:1;s:10:"categories";b:1;s:6:"visits";b:1;s:12:"rating_score";b:1;s:13:"privacy_level";b:1;}',
     'Information displayed on picture page'
   );

trunk/install/piwigo_structure-mysql.sql

@@ -188 +188 @@
   `representative_ext` varchar(4) default NULL,
   `date_metadata_update` date default NULL,
-  `average_rate` float(5,2) unsigned default NULL,
+  `rating_score` float(5,2) unsigned default NULL,
   `has_high` enum('true') default NULL,
   `path` varchar(255) NOT NULL default '',
@@ -200 +200 @@
   PRIMARY KEY  (`id`),
   KEY `images_i2` (`date_available`),
-  KEY `images_i3` (`average_rate`),
+  KEY `images_i3` (`rating_score`),
   KEY `images_i4` (`hit`),
   KEY `images_i5` (`date_creation`),

trunk/install/piwigo_structure-pdo-sqlite.sql

@@ -184 +184 @@
   "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,
@@ -200 +200 @@
 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");

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");

trunk/install/piwigo_structure-sqlite.sql

@@ -184 +184 @@
   "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,
@@ -200 +200 @@
 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");