aboutsummaryrefslogtreecommitdiffstats
path: root/install/piwigo_structure-mysql.sql (follow)
Commit message (Collapse)AuthorAgeFilesLines
* feature 3103: enlarge users.id (and foreign keys user_id, added_by or ↵plegall2014-07-241-14/+14
| | | | | | author_id) from smallint (max 30k) to mediumint unsigned (max 16M) git-svn-id: http://piwigo.org/svn/trunk@29072 68402e56-0260-453c-a942-63ccdbb3a9ee
* feature 3077 : improve cache invalidationmistic1002014-05-241-5/+15
| | | | | | | - add "lastmodified" automatic field for categories, groups, users, tags and images tables - provide a "server key" to the client cache manager git-svn-id: http://piwigo.org/svn/trunk@28532 68402e56-0260-453c-a942-63ccdbb3a9ee
* bug 3070 make tag names case insesitive in the dbrvelices2014-04-091-1/+1
| | | | git-svn-id: http://piwigo.org/svn/trunk@28143 68402e56-0260-453c-a942-63ccdbb3a9ee
* feature 3009: Add 'latitude' and 'longitude' fields in images table mistic1002013-12-061-2/+5
| | | | git-svn-id: http://piwigo.org/svn/trunk@25801 68402e56-0260-453c-a942-63ccdbb3a9ee
* bug 2097: wrong number of sub-albumsrvelices2013-05-261-0/+1
| | | | | | bug 2098: make number of direct sub-albums available for each user git-svn-id: http://piwigo.org/svn/trunk@22879 68402e56-0260-453c-a942-63ccdbb3a9ee
* fix typo which crash the install processflop252013-04-111-1/+1
| | | | git-svn-id: http://piwigo.org/svn/trunk@22134 68402e56-0260-453c-a942-63ccdbb3a9ee
* db changes for feature 2836 display # of comments/tags in menubar and ↵rvelices2013-03-231-1/+4
| | | | | | feature 2557 recent photos should never be empty git-svn-id: http://piwigo.org/svn/trunk@21801 68402e56-0260-453c-a942-63ccdbb3a9ee
* bug 2794: Virtual albums are displayed in physical albums list in ↵rvelices2012-12-241-1/+1
| | | | | | synchronization tool git-svn-id: http://piwigo.org/svn/trunk@19548 68402e56-0260-453c-a942-63ccdbb3a9ee
* feature 2727: improve password security with the use of PasswordHash class.plegall2012-11-021-1/+1
| | | | | | | | | | This class performs salt and multiple iterations. Already used in Wordpress, Drupal, phpBB and many other web applications. $conf['pass_convert'] is replaced by $conf['password_hash'] + $conf['password_verify'] git-svn-id: http://piwigo.org/svn/trunk@18889 68402e56-0260-453c-a942-63ccdbb3a9ee
* feature 2754: Add "Email" field for user comments + mandatory "Author" mistic1002012-09-231-0/+1
| | | | git-svn-id: http://piwigo.org/svn/trunk@18164 68402e56-0260-453c-a942-63ccdbb3a9ee
* feature 2380: add URL for user comment mistic1002012-08-031-0/+1
| | | | git-svn-id: http://piwigo.org/svn/trunk@17351 68402e56-0260-453c-a942-63ccdbb3a9ee
* bug 2660: check guest IP on insert_user_comment (same system as rate_picture)mistic1002012-06-241-0/+1
| | | | git-svn-id: http://piwigo.org/svn/trunk@15983 68402e56-0260-453c-a942-63ccdbb3a9ee
* feature 2632: remove useless columns and config settings at gallery installationplegall2012-06-121-7/+0
| | | | git-svn-id: http://piwigo.org/svn/trunk@15652 68402e56-0260-453c-a942-63ccdbb3a9ee
* feature 2604: add images.rotation at database creation (not only during upgrade)plegall2012-04-021-1/+2
| | | | git-svn-id: http://piwigo.org/svn/trunk@13849 68402e56-0260-453c-a942-63ccdbb3a9ee
* feature 2587: set theme "elegant" as default themeplegall2012-03-021-1/+1
| | | | git-svn-id: http://piwigo.org/svn/trunk@13467 68402e56-0260-453c-a942-63ccdbb3a9ee
* multisize - added the coi (still to affine the admin ui + language)rvelices2012-02-061-0/+1
| | | | | | multisize - derivatives can be revuild from a larger derviative instead of the original git-svn-id: http://piwigo.org/svn/trunk@13038 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 change nb_image_page into smallint(3)mistic1002011-04-121-1/+1
| | | | git-svn-id: http://piwigo.org/svn/trunk@10341 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 2155 fixed: for MySQL, use the "ENGINE=MyISAM" syntax instead of theplegall2011-02-031-30/+30
| | | | | | | | deprecated "TYPE=MyISAM", so that SQL creation table statements complies with MySQL 5.5 git-svn-id: http://piwigo.org/svn/trunk@9086 68402e56-0260-453c-a942-63ccdbb3a9ee
* bug 270 fixed: (yes "270", submitted in 2006), time (hour:minute:second) addedplegall2011-02-031-1/+1
| | | | | | | in the date_creation field and in the synchronization from EXIF metadata. git-svn-id: http://piwigo.org/svn/trunk@9073 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/+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-19/+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
* Feature 1535: Add languages table.patdenice2010-03-251-0/+12
| | | | | | Ready for theme manager! git-svn-id: http://piwigo.org/svn/trunk@5341 68402e56-0260-453c-a942-63ccdbb3a9ee
* feature 1514: new screen to manage installed themes; activate, deactivate,plegall2010-03-171-0/+12
| | | | | | | | | | | | delete, set as default. plugins.class.php was merged back to a state it doesn't manage themes at all. themes.class.php was created instead, from a duplication of plugins.class.php and strongly modified then. feature 1507: the display of available themes is now much more "graphic". git-svn-id: http://piwigo.org/svn/trunk@5153 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 1255 :nikrou2009-12-021-0/+442
- 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