aboutsummaryrefslogtreecommitdiffstats
path: root/install/piwigo_structure-sqlite.sql (follow)
Commit message (Collapse)AuthorAgeFilesLines
* remove files related to database engines other than MySQLplegall2012-03-021-541/+0
| | | | git-svn-id: http://piwigo.org/svn/trunk@13465 68402e56-0260-453c-a942-63ccdbb3a9ee
* feature 2027 implemented: the "lost password" feature was rewritten.plegall2011-08-241-0/+1
| | | | | | | | | | | | | | | The algorithm is highly inspired from WordPress : 1) in a single field, you give a username or an email 2) Piwigo sends an email with the activation key 3) the user clicks on the link in the email (with the activation key) and is able to set a new password The "lost password" feature is no longer limited to "classic" users: administrators and webmasters can use it too (no need to tell webmasters that they can only change their password in the database) git-svn-id: http://piwigo.org/svn/trunk@11992 68402e56-0260-453c-a942-63ccdbb3a9ee
* rename #images.average_rate to rating_scorervelices2011-08-021-2/+2
| | | | git-svn-id: http://piwigo.org/svn/trunk@11893 68402e56-0260-453c-a942-63ccdbb3a9ee
* bug:2224 one parameter for change thumnails number (needs some translations)mistic1002011-04-091-2/+1
| | | | git-svn-id: http://piwigo.org/svn/trunk@10198 68402e56-0260-453c-a942-63ccdbb3a9ee
* bug:1791 display hd dimensions instead of websize dimensionsmistic1002011-04-081-0/+2
| | | | git-svn-id: http://piwigo.org/svn/trunk@10157 68402e56-0260-453c-a942-63ccdbb3a9ee
* bug 937 fixed: makes sure a user won't see the thumbnail of a photo that has aplegall2011-01-201-0/+2
| | | | | | | | | | | | 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-21/+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 511 : add support for sqlite database enginenikrou2010-01-281-0/+532
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