aboutsummaryrefslogtreecommitdiffstats
path: root/install/piwigo_structure-mysql.sql (unfollow)
Commit message (Collapse)AuthorFilesLines
2016-01-18bug #404 fixed, database changes for auth keysplegall1-0/+15
... applied during install: table user_auth_keys and column history.auth_key_id
2015-12-07feature #379 multiple format, step 2: download formatsplegall1-0/+1
* 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/+12
* 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-09-20bug 3141 fixed: forget to change piwigo_structure-mysql.sql in r29111 for ↵plegall1-1/+2
feature 3050 git-svn-id: http://piwigo.org/svn/trunk@29666 68402e56-0260-453c-a942-63ccdbb3a9ee
2014-07-24feature 3103: enlarge users.id (and foreign keys user_id, added_by or ↵plegall1-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
2014-05-24feature 3077 : improve cache invalidationmistic1001-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
2014-04-09bug 3070 make tag names case insesitive in the dbrvelices1-1/+1
git-svn-id: http://piwigo.org/svn/trunk@28143 68402e56-0260-453c-a942-63ccdbb3a9ee
2013-12-06feature 3009: Add 'latitude' and 'longitude' fields in images table mistic1001-2/+5
git-svn-id: http://piwigo.org/svn/trunk@25801 68402e56-0260-453c-a942-63ccdbb3a9ee
2013-05-26bug 2097: wrong number of sub-albumsrvelices1-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
2013-04-11fix typo which crash the install processflop251-1/+1
git-svn-id: http://piwigo.org/svn/trunk@22134 68402e56-0260-453c-a942-63ccdbb3a9ee
2013-03-23db changes for feature 2836 display # of comments/tags in menubar and ↵rvelices1-1/+4
feature 2557 recent photos should never be empty git-svn-id: http://piwigo.org/svn/trunk@21801 68402e56-0260-453c-a942-63ccdbb3a9ee
2012-12-24bug 2794: Virtual albums are displayed in physical albums list in ↵rvelices1-1/+1
synchronization tool git-svn-id: http://piwigo.org/svn/trunk@19548 68402e56-0260-453c-a942-63ccdbb3a9ee
2012-11-02feature 2727: improve password security with the use of PasswordHash class.plegall1-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
2012-09-23feature 2754: Add "Email" field for user comments + mandatory "Author" mistic1001-0/+1
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/+1
git-svn-id: http://piwigo.org/svn/trunk@17351 68402e56-0260-453c-a942-63ccdbb3a9ee
2012-06-24bug 2660: check guest IP on insert_user_comment (same system as rate_picture)mistic1001-0/+1
git-svn-id: http://piwigo.org/svn/trunk@15983 68402e56-0260-453c-a942-63ccdbb3a9ee
2012-06-12feature 2632: remove useless columns and config settings at gallery installationplegall1-7/+0
git-svn-id: http://piwigo.org/svn/trunk@15652 68402e56-0260-453c-a942-63ccdbb3a9ee
2012-04-02feature 2604: add images.rotation at database creation (not only during upgrade)plegall1-1/+2
git-svn-id: http://piwigo.org/svn/trunk@13849 68402e56-0260-453c-a942-63ccdbb3a9ee
2012-03-02feature 2587: set theme "elegant" as default themeplegall1-1/+1
git-svn-id: http://piwigo.org/svn/trunk@13467 68402e56-0260-453c-a942-63ccdbb3a9ee
2012-02-06multisize - added the coi (still to affine the admin ui + language)rvelices1-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
2011-08-24feature 2027 implemented: the "lost password" feature was rewritten.plegall1-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
2011-08-02rename #images.average_rate to rating_scorervelices1-2/+2
git-svn-id: http://piwigo.org/svn/trunk@11893 68402e56-0260-453c-a942-63ccdbb3a9ee
2011-04-12bug:2224 change nb_image_page into smallint(3)mistic1001-1/+1
git-svn-id: http://piwigo.org/svn/trunk@10341 68402e56-0260-453c-a942-63ccdbb3a9ee
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-02-03bug 2155 fixed: for MySQL, use the "ENGINE=MyISAM" syntax instead of theplegall1-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
2011-02-03bug 270 fixed: (yes "270", submitted in 2006), time (hour:minute:second) addedplegall1-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
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-19/+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-03-25Feature 1535: Add languages table.patdenice1-0/+12
Ready for theme manager! git-svn-id: http://piwigo.org/svn/trunk@5341 68402e56-0260-453c-a942-63ccdbb3a9ee
2010-03-17feature 1514: new screen to manage installed themes; activate, deactivate,plegall1-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
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
2009-12-02Feature 1255 :nikrou1-0/+0
- 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
2009-10-06Feature 1026 : update database structure (adding author_id)nikrou1-0/+1
git-svn-id: http://piwigo.org/svn/trunk@3979 68402e56-0260-453c-a942-63ccdbb3a9ee
2008-09-27new: set yoga/Sylvia as default theme.plegall1-1/+1
git-svn-id: http://piwigo.org/svn/trunk@2615 68402e56-0260-453c-a942-63ccdbb3a9ee
2008-09-25feature 868 added: pwg.images.add checks if the same file has not alreadplegall1-0/+1
been uploaded. git-svn-id: http://piwigo.org/svn/trunk@2592 68402e56-0260-453c-a942-63ccdbb3a9ee
2008-09-12- images.file categories.permalink old_permalinks.permalink - become binaryrvelices1-3/+3
- session security improvement: now the sessions are valid only for originating ip addr (with mask 255.255.0.0 to allow users behind load balancing proxies) -> stealing the session cookie is almost a non issue (with the exception of the 65536 machines in range) - metadata sync from the sync button does not overwrite valid data with empty metadata - other small fixes/enhancements: - added event get_category_image_orders - fix display issue with redirect.tpl (h1/h2 within h1) - fix known_script smarty function registration - query search form not submitted if q is empty - better admin css rules - some other minor changes (ws_core, rest_handler, functions_search...) git-svn-id: http://piwigo.org/svn/trunk@2521 68402e56-0260-453c-a942-63ccdbb3a9ee
2008-09-11bug fixed: following r2516, remove ws_access table from database scriptplegall1-19/+0
creation. git-svn-id: http://piwigo.org/svn/trunk@2518 68402e56-0260-453c-a942-63ccdbb3a9ee
2008-09-11feature 169 added: ability to manually sort images inside a category. Aplegall1-0/+1
dedicated screen let the administrator sort the images (pur HTML, no JavaScript yet). The "rank" sort order is available only for a category without flat mode. New database column image_category.rank. git-svn-id: http://piwigo.org/svn/trunk@2517 68402e56-0260-453c-a942-63ccdbb3a9ee
2008-07-22- add #user_cache.cache_update_time - useful for plugins or the filter when ↵rvelices1-0/+1
it is not possible/desirable to cache/calculate data specific to the user when pwg core does it; note that this opens the possibility to implement a data cache (file/shared mem/ etc...) for every user (for very large databases) git-svn-id: http://piwigo.org/svn/trunk@2448 68402e56-0260-453c-a942-63ccdbb3a9ee
2008-05-14Change some PhpWebGallery to Piwigo.rub1-90/+90
Not all PhpWebGallery has been translated! git-svn-id: http://piwigo.org/svn/trunk@2339 68402e56-0260-453c-a942-63ccdbb3a9ee
2008-05-06- remove some unnecessary db columns (#history_summary.id, #history.year, ↵rvelices1-6/+1
month, day and hour) git-svn-id: http://piwigo.org/svn/trunk@2333 68402e56-0260-453c-a942-63ccdbb3a9ee
2008-05-01- move #categories.date_last and nb_images to #user_cache_categoriesrvelices1-2/+2
git-svn-id: http://piwigo.org/svn/trunk@2324 68402e56-0260-453c-a942-63ccdbb3a9ee
2008-04-30- transform some db fields from text to mediumtext (for large dbs); - ↵rvelices1-3/+3
#sessions.data, #user_cache.forbidden_categories and #user_cache.image_access_list git-svn-id: http://piwigo.org/svn/trunk@2323 68402e56-0260-453c-a942-63ccdbb3a9ee
2007-10-09- PWG_CHARSET, DB_CHARSET and DB_COLLATE... utf-8 readyrvelices1-1/+1
git-svn-id: http://piwigo.org/svn/trunk@2127 68402e56-0260-453c-a942-63ccdbb3a9ee
2007-09-11feature 731: permissions at image level rvelices1-0/+4
- this is the first version - I wait for feedback before changing help files git-svn-id: http://piwigo.org/svn/trunk@2084 68402e56-0260-453c-a942-63ccdbb3a9ee
2007-04-19git-svn-id: http://piwigo.org/svn/trunk@1963 ↵rub1-1/+2
68402e56-0260-453c-a942-63ccdbb3a9ee
2007-03-27Complement to trunk r1924: modification on index names reported in SQLplegall1-3/+3
database structure installation file. Modification: somes indexes were renamed to comply with PWG indexes naming rules, ie <table_name>_[u for unique]i<index number in table>. git-svn-id: http://piwigo.org/svn/trunk@1925 68402e56-0260-453c-a942-63ccdbb3a9ee