aboutsummaryrefslogtreecommitdiffstats
path: root/install/piwigo_structure-pdo-sqlite.sql (unfollow)
Commit message (Collapse)AuthorFilesLines
2011-04-09bug:2224 one parameter for change thumnails number (needs some translations)mistic1001-2/+1
git-svn-id: http://piwigo.org/svn/trunk@10198 68402e56-0260-453c-a942-63ccdbb3a9ee
2011-04-08bug:1791 display hd dimensions instead of websize dimensionsmistic1001-0/+2
git-svn-id: http://piwigo.org/svn/trunk@10157 68402e56-0260-453c-a942-63ccdbb3a9ee
2011-01-20bug 937 fixed: makes sure a user won't see the thumbnail of a photo that has aplegall1-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
2011-01-13feature 2108 added: user upload removed from core. It will come back as aplegall1-20/+0
"new generation" user upload in the Community plugin. git-svn-id: http://piwigo.org/svn/trunk@8651 68402e56-0260-453c-a942-63ccdbb3a9ee
2011-01-04feature 2095 added: new column images.added_by (foreign key on users.id)plegall1-0/+1
git-svn-id: http://piwigo.org/svn/trunk@8464 68402e56-0260-453c-a942-63ccdbb3a9ee
2010-12-14feature 2060: Remove adviser from db structure.patdenice1-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
2010-05-12SQLite cannot drop tables on cascadenikrou1-1/+1
git-svn-id: http://piwigo.org/svn/trunk@6166 68402e56-0260-453c-a942-63ccdbb3a9ee
2010-03-29Fix some issues with database engines :nikrou1-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
2010-03-19Fix some sql issues :nikrou1-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
2010-03-13feature 1502: based on Dotclear model, P@t has reorganized the way Piwigoplegall1-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
2010-02-26Feature 1459 : add support for SQLite3 via PDOnikrou1-0/+0
git-svn-id: http://piwigo.org/svn/trunk@4967 68402e56-0260-453c-a942-63ccdbb3a9ee
2010-01-28Feature 511 : add support for sqlite database enginenikrou1-191/+74
Using session_write_close function when session handler use database because write is called after object destruction. git-svn-id: http://piwigo.org/svn/trunk@4781 68402e56-0260-453c-a942-63ccdbb3a9ee
2009-12-02Feature 1255 :nikrou1-0/+649
- add postgres database engine - change installation process to allow postgres or mysql database git-svn-id: http://piwigo.org/svn/trunk@4410 68402e56-0260-453c-a942-63ccdbb3a9ee