diff options
| author | plegall <plg@piwigo.org> | 2011-01-20 13:32:34 +0000 |
|---|---|---|
| committer | plegall <plg@piwigo.org> | 2011-01-20 13:32:34 +0000 |
| commit | dfb0b9d1faa0603393ddbcb2831da52ba76ea3e9 (patch) | |
| tree | f19283fe3294804165ae99681f94ffa85d2e7e71 /install/piwigo_structure-sqlite.sql | |
| parent | d59827398d74626dc7525b337ade43e8a31d4e23 (diff) | |
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 $conf['allow_random_representative'] = true;
git-svn-id: http://piwigo.org/svn/trunk@8802 68402e56-0260-453c-a942-63ccdbb3a9ee
Diffstat (limited to 'install/piwigo_structure-sqlite.sql')
| -rw-r--r-- | install/piwigo_structure-sqlite.sql | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/install/piwigo_structure-sqlite.sql b/install/piwigo_structure-sqlite.sql index 54e2f0d12..a46c5929d 100644 --- a/install/piwigo_structure-sqlite.sql +++ b/install/piwigo_structure-sqlite.sql @@ -425,6 +425,7 @@ CREATE TABLE piwigo_user_cache_categories "nb_images" INTEGER default 0 NOT NULL, "count_images" INTEGER default 0, "count_categories" INTEGER default 0, + "user_representative_picture_id" INTEGER, PRIMARY KEY ("user_id","cat_id") ); @@ -535,3 +536,4 @@ CREATE TABLE piwigo_comments CREATE INDEX "comments_i2" ON "piwigo_comments" ("validation_date"); CREATE INDEX "comments_i1" ON "piwigo_comments" ("image_id"); + |