aboutsummaryrefslogtreecommitdiffstats
path: root/install/db (unfollow)
Commit message (Collapse)AuthorFilesLines
2016-05-31fixes #478, add new column user_infos.last_visitplegall1-0/+40
This will speed up user edit popin opening, by avoiding to search in history for the last user visit. The column user_infos.last_visit_from_history true/false says if the last_visit has already been search in history (to avoid making it twice). I could have implemented the search of last_visit for all users in the migration task 149 but in case of many users and long history, it would have taken years to execute...
2016-01-14happy new year 2016, all headers updatedplegall89-89/+89
2016-01-04feature #392, authentication keys, history logplegall1-0/+39
When a user successfully performs an authentication with an auth_key, Piwigo registers it in the history table. For now, it is not shown/searchable in the history screen, but we can add it in the future and we can provide a plugin with specific details about authentication keys usage.
2015-12-31feature #392, authentication key, new tableplegall1-0/+46
2015-12-07feature #379 multiple format, step 2: download formatsplegall1-0/+39
* if formats are available, replace the download link on picture.php by a switchBox with all formats * register format in the history table for future statistics
2015-12-03feature #379 multiple format, step 1: add formatsplegall1-0/+44
* new table piwigo_image_format (each photo can have 0 to many formats) * only compatible with synchronization for now. Formats must be in sub-directory pwg_format * formats are visible on edition page only for now
2014-07-28bug 3050: increase security on reset password algorithm.plegall1-0/+43
* reset key has a 1-hour life * reset key is automatically deleted once used * reset key is stored as a hash Thank you effigies for code suggestions git-svn-id: http://piwigo.org/svn/trunk@29111 68402e56-0260-453c-a942-63ccdbb3a9ee
2014-07-24feature 3103: enlarge users.id (and foreign keys user_id, added_by or ↵plegall1-0/+60
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
2014-06-22feature 3095: add "comments_enable_website" param + GUImistic1001-0/+35
git-svn-id: http://piwigo.org/svn/trunk@28764 68402e56-0260-453c-a942-63ccdbb3a9ee
2014-05-24feature 3077 : improve cache invalidationmistic1001-0/+45
- 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
2014-04-09bug 3070 make tag names case insesitive in the dbrvelices1-0/+37
git-svn-id: http://piwigo.org/svn/trunk@28143 68402e56-0260-453c-a942-63ccdbb3a9ee
2014-01-05Update headers to 2014. Happy new year!!mistic10080-80/+80
git-svn-id: http://piwigo.org/svn/trunk@26461 68402e56-0260-453c-a942-63ccdbb3a9ee
2013-12-07feature 3009: "!= NULL" is invalid, use "IS NOT NULL" insteadmistic1001-2/+2
git-svn-id: http://piwigo.org/svn/trunk@25816 68402e56-0260-453c-a942-63ccdbb3a9ee
2013-12-06feature 3009: Don't delete 'lat' and 'lon' fields in case users try to ↵mistic1001-8/+0
delete an old plugin using them (SQL crash) git-svn-id: http://piwigo.org/svn/trunk@25802 68402e56-0260-453c-a942-63ccdbb3a9ee
2013-12-06feature 3009: Add 'latitude' and 'longitude' fields in images table mistic1001-0/+72
git-svn-id: http://piwigo.org/svn/trunk@25801 68402e56-0260-453c-a942-63ccdbb3a9ee
2013-11-07feature 2995 missing migration task in r25372mistic1001-0/+35
git-svn-id: http://piwigo.org/svn/trunk@25373 68402e56-0260-453c-a942-63ccdbb3a9ee
2013-07-06bug 2931: revert r23675 & r23721, make element_set_ranks.php uses ASC ↵mistic1001-0/+62
keyword (+ migration task) git-svn-id: http://piwigo.org/svn/trunk@23813 68402e56-0260-453c-a942-63ccdbb3a9ee
2013-05-26bug 2097: wrong number of sub-albumsrvelices1-0/+37
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
2013-03-23db changes for feature 2836 display # of comments/tags in menubar and ↵rvelices1-0/+47
feature 2557 recent photos should never be empty git-svn-id: http://piwigo.org/svn/trunk@21801 68402e56-0260-453c-a942-63ccdbb3a9ee
2013-01-30feature:65 Add support for PHP mysqli extension, activated by default, ↵mistic1001-0/+43
remove returns of link_identifier git-svn-id: http://piwigo.org/svn/trunk@20462 68402e56-0260-453c-a942-63ccdbb3a9ee
2013-01-01 update Piwigo headers to 2013 (the end of the world didn't occur as ↵plegall74-74/+74
expected on r12922) git-svn-id: http://piwigo.org/svn/trunk@19703 68402e56-0260-453c-a942-63ccdbb3a9ee
2012-12-24bug 2794: Virtual albums are displayed in physical albums list in ↵rvelices1-0/+35
synchronization tool git-svn-id: http://piwigo.org/svn/trunk@19548 68402e56-0260-453c-a942-63ccdbb3a9ee
2012-12-04feature 2614: on a upgraded gallery, nb_categories_page is set to 50 insteadplegall1-2/+2
of the default value 12 for a new installation. git-svn-id: http://piwigo.org/svn/trunk@19281 68402e56-0260-453c-a942-63ccdbb3a9ee
2012-11-02feature 2727: improve password security with the use of PasswordHash class.plegall1-0/+36
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
2012-09-23feature 2614: pagination on albums mistic1001-0/+35
git-svn-id: http://piwigo.org/svn/trunk@18165 68402e56-0260-453c-a942-63ccdbb3a9ee
2012-09-23feature 2754: Add "Email" field for user comments + mandatory "Author" mistic1001-0/+41
git-svn-id: http://piwigo.org/svn/trunk@18164 68402e56-0260-453c-a942-63ccdbb3a9ee
2012-08-03feature 2380: add URL for user comment mistic1001-0/+38
git-svn-id: http://piwigo.org/svn/trunk@17351 68402e56-0260-453c-a942-63ccdbb3a9ee
2012-07-02bug 2669: cancel migration task 121mistic1001-72/+1
git-svn-id: http://piwigo.org/svn/trunk@16275 68402e56-0260-453c-a942-63ccdbb3a9ee
2012-06-24bug 2660: check guest IP on insert_user_comment (same system as rate_picture)mistic1001-0/+38
git-svn-id: http://piwigo.org/svn/trunk@15983 68402e56-0260-453c-a942-63ccdbb3a9ee
2012-06-19feature 2656: rename language no_NO into nb_NOplegall1-0/+48
git-svn-id: http://piwigo.org/svn/trunk@15841 68402e56-0260-453c-a942-63ccdbb3a9ee
2012-06-08feature 2650: rename language sl_SL into sl_SI according to ISO 3166-1 codesplegall1-0/+48
git-svn-id: http://piwigo.org/svn/trunk@15609 68402e56-0260-453c-a942-63ccdbb3a9ee
2012-06-08feature 2632: derivatives: search and replace hotlinks inside Piwigoplegall1-0/+197
(page_banner, covers also plugins Additional Pages and PWG Stuffs) git-svn-id: http://piwigo.org/svn/trunk@15608 68402e56-0260-453c-a942-63ccdbb3a9ee
2012-05-31feature 2632: derivatives: clean the database. Remove useless configurationplegall1-0/+60
settings and useless columns in "images" table. git-svn-id: http://piwigo.org/svn/trunk@15450 68402e56-0260-453c-a942-63ccdbb3a9ee
2012-05-31feature 2632: convert 2.3 thumbnails/websize/hd settings into 2.4 ↵plegall1-0/+218
derivatives settings git-svn-id: http://piwigo.org/svn/trunk@15449 68402e56-0260-453c-a942-63ccdbb3a9ee
2012-05-24feature 2632: multiple size, upgrade task for new organization of "upload"plegall1-0/+83
and "galleries" directories git-svn-id: http://piwigo.org/svn/trunk@15288 68402e56-0260-453c-a942-63ccdbb3a9ee
2012-05-21multisize hotlinks and upgrade, add <IfModule mod_rewrite.c> to htaccess contentmistic1001-1/+5
git-svn-id: http://piwigo.org/svn/trunk@15178 68402e56-0260-453c-a942-63ccdbb3a9ee
2012-05-19prefix_thumbnail and dir_thumbnail are planned for removal, must redefine a ↵mistic1001-0/+10
default value for htaccess git-svn-id: http://piwigo.org/svn/trunk@15128 68402e56-0260-453c-a942-63ccdbb3a9ee
2012-05-19confusion in previous commitmistic1001-1/+3
git-svn-id: http://piwigo.org/svn/trunk@15127 68402e56-0260-453c-a942-63ccdbb3a9ee
2012-05-19remove Warning when called from upgrade_feed.php, no consequence for upgrade.phpmistic1001-0/+2
git-svn-id: http://piwigo.org/svn/trunk@15126 68402e56-0260-453c-a942-63ccdbb3a9ee
2012-05-19add migration task for create/modify htaccess containing rewrite rules on ↵mistic1001-0/+92
photos hotlinks git-svn-id: http://piwigo.org/svn/trunk@15124 68402e56-0260-453c-a942-63ccdbb3a9ee
2012-04-02feature 2604: add images.rotation at database creation (not only during upgrade)plegall1-1/+1
git-svn-id: http://piwigo.org/svn/trunk@13849 68402e56-0260-453c-a942-63ccdbb3a9ee
2012-04-01feature 2604: support rotation on derivativesplegall1-0/+39
git-svn-id: http://piwigo.org/svn/trunk@13843 68402e56-0260-453c-a942-63ccdbb3a9ee
2012-03-24feature 2598: force reset on derivative (multiple size) configuration due to ↵plegall1-0/+48
new sizes XXS and XS git-svn-id: http://piwigo.org/svn/trunk@13698 68402e56-0260-453c-a942-63ccdbb3a9ee
2012-03-02feature 2577: bug fixed in install/db/118, remove it from piwigo_upgrade tableplegall1-1/+4
and run it once again. git-svn-id: http://piwigo.org/svn/trunk@13459 68402e56-0260-453c-a942-63ccdbb3a9ee
2012-02-18feature:2577patdenice1-0/+38
Automaticaly install smartpocket during install or upgrade. hide mobile theme from themes list on user side. git-svn-id: http://piwigo.org/svn/trunk@13242 68402e56-0260-453c-a942-63ccdbb3a9ee
2012-02-10feature 2567: in IMAGES_TABLE the field "name" is prefilled with the filename mistic1001-0/+65
git-svn-id: http://piwigo.org/svn/trunk@13082 68402e56-0260-453c-a942-63ccdbb3a9ee
2012-02-06multisize - added the coi (still to affine the admin ui + language)rvelices1-0/+48
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
2012-01-17update Piwigo headers to 2012, last change before the expected (or not) ↵mistic10056-56/+56
apocalypse git-svn-id: http://piwigo.org/svn/trunk@12922 68402e56-0260-453c-a942-63ccdbb3a9ee
2012-01-16feature:2549 update query not working well (sic)mistic1001-5/+1
git-svn-id: http://piwigo.org/svn/trunk@12905 68402e56-0260-453c-a942-63ccdbb3a9ee
2012-01-15feaure:2379 option to display user comments sorted new>old instead of old>new mistic1001-0/+38
git-svn-id: http://piwigo.org/svn/trunk@12894 68402e56-0260-453c-a942-63ccdbb3a9ee
generated by cgit v1.2.3 (git 2.25.1) at 2024-06-08 14:11:21 +0000