Changeset 8802 for trunk/install

Timestamp:

Jan 20, 2011, 2:32:34 PM (13 years ago)

Author:

plg

Message:

bug 937 fixed: makes sure a user won't see the thumbnail of a photo that has a
higher privacy level than user privacy level.

For an acceptable solution at performance level, I have implemented a cache:
for a given user, each album has a representative_picture_id. This cache also
avoids to perform numerous "order by rand()" SQL queries which is the case
when $confallow_random_representative = true;

Location:

trunk/install

Files:

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

trunk/install/piwigo_structure-mysql.sql

@@ -369 +369 @@
   `count_images` mediumint(8) unsigned default '0',
   `count_categories` mediumint(8) unsigned default '0',
+  `user_representative_picture_id` mediumint(8) unsigned default NULL,
   PRIMARY KEY  (`user_id`,`cat_id`)
 ) TYPE=MyISAM;

trunk/install/piwigo_structure-pdo-sqlite.sql

@@ -426 +426 @@
   "count_images" INTEGER default 0,
   "count_categories" INTEGER default 0,
+  "user_representative_picture_id" INTEGER,
   PRIMARY KEY ("user_id","cat_id")
 );

trunk/install/piwigo_structure-pgsql.sql

@@ -515 +515 @@
   "count_images" INTEGER default 0,
   "count_categories" INTEGER default 0,
+  "user_representative_picture_id" INTEGER,
   PRIMARY KEY ("user_id","cat_id")
 );

trunk/install/piwigo_structure-sqlite.sql

@@ -426 +426 @@
   "count_images" INTEGER default 0,
   "count_categories" INTEGER default 0,
+  "user_representative_picture_id" INTEGER,
   PRIMARY KEY ("user_id","cat_id")
 );
@@ -536 +537 @@
 CREATE INDEX "comments_i2" ON "piwigo_comments" ("validation_date");
 CREATE INDEX "comments_i1" ON "piwigo_comments" ("image_id");
+