aboutsummaryrefslogtreecommitdiffstats
path: root/install/piwigo_structure-pdo-sqlite.sql (follow)
Commit message (Collapse)AuthorAgeFilesLines
* bug 937 fixed: makes sure a user won't see the thumbnail of a photo that has aplegall2011-01-201-0/+1
| | | | | | | | | | | | 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
* feature 2108 added: user upload removed from core. It will come back as aplegall2011-01-131-20/+0
| | | | | | | "new generation" user upload in the Community plugin. git-svn-id: http://piwigo.org/svn/trunk@8651 68402e56-0260-453c-a942-63ccdbb3a9ee
* feature 2095 added: new column images.added_by (foreign key on users.id)plegall2011-01-041-0/+1
| | | | git-svn-id: http://piwigo.org/svn/trunk@8464 68402e56-0260-453c-a942-63ccdbb3a9ee
* feature 2060: Remove adviser from db structure.patdenice2010-12-141-1/+0
| | | | | | Remove adviser from user_list page and some db queries. git-svn-id: http://piwigo.org/svn/trunk@8131 68402e56-0260-453c-a942-63ccdbb3a9ee
* SQLite cannot drop tables on cascadenikrou2010-05-121-1/+1
| | | | git-svn-id: http://piwigo.org/svn/trunk@6166 68402e56-0260-453c-a942-63ccdbb3a9ee
* Fix some issues with database engines :nikrou2010-03-291-0/+13
| | | | | | | | - insert into syntax not correct for posgresql or sqlite - add languages table - incorrect function for row count (sqlite) git-svn-id: http://piwigo.org/svn/trunk@5452 68402e56-0260-453c-a942-63ccdbb3a9ee
* Fix some sql issues :nikrou2010-03-191-0/+13
| | | | | | | - permalink that use if() syntax - add tables themes for other database engines that mysql git-svn-id: http://piwigo.org/svn/trunk@5192 68402e56-0260-453c-a942-63ccdbb3a9ee
* feature 1502: based on Dotclear model, P@t has reorganized the way Piwigoplegall2010-03-131-1/+1
| | | | | | | manages template/theme in a simpler "theme only level" architecture. It supports multiple level inheritance. git-svn-id: http://piwigo.org/svn/trunk@5123 68402e56-0260-453c-a942-63ccdbb3a9ee
* Feature 1459 : add support for SQLite3 via PDOnikrou2010-02-261-0/+532
git-svn-id: http://piwigo.org/svn/trunk@4967 68402e56-0260-453c-a942-63ccdbb3a9ee