aboutsummaryrefslogtreecommitdiffstats
path: root/install/piwigo_structure-mysql.sql (unfollow)
Commit message (Collapse)AuthorFilesLines
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
2007-03-13Fix bad default value for language on table user_inforub1-1/+1
Improve mail send (Undisclosed-recipients, switch language, ...) Improve send an email to group members (Use Bcc, template, multi-language, ...) (But need more improvements) git-svn-id: http://piwigo.org/svn/trunk@1904 68402e56-0260-453c-a942-63ccdbb3a9ee
2007-03-09New: #images.high_filesize was added so that we can sum the filesizes in theplegall1-7/+8
filtered history. #images.high_filesize is filled during metadata synchronization. Bug fixed: in getAttribute XML function, when asking "filesize", it was returning high_filesize. The regex was too simple. git-svn-id: http://piwigo.org/svn/trunk@1883 68402e56-0260-453c-a942-63ccdbb3a9ee
2007-02-28feature 657: permalinks for categoriesrvelices1-1/+17
git-svn-id: http://piwigo.org/svn/trunk@1866 68402e56-0260-453c-a942-63ccdbb3a9ee
2007-02-20New: non picture files are now logged in history when downloaded. Theplegall1-1/+1
history filter was redesigned: #history.is_high replaced by #history.image_type = high. The filter is simpler. git-svn-id: http://piwigo.org/svn/trunk@1844 68402e56-0260-453c-a942-63ccdbb3a9ee
2007-02-14New: history logs high quality access via action.php. A new columnplegall1-0/+1
#history.is_high was added. Filter was added on administration history detail view. Modification: function get_sql_condition_FandF was slightly refactored for presentation improvement. git-svn-id: http://piwigo.org/svn/trunk@1817 68402e56-0260-453c-a942-63ccdbb3a9ee
2007-02-08Web Service: vdigital1-2/+0
- Delete high and normal in #ws_access table - start date is kept. w0p0 template: Minor change git-svn-id: http://piwigo.org/svn/trunk@1791 68402e56-0260-453c-a942-63ccdbb3a9ee
2007-01-28Web Service: Remove ws_status from #config (remove missing in config.sql)vdigital1-0/+1
(Next steps: - Restrict Method need to be more generic maybe - Delete functions_webserv.inc.php - Activate $partner in ws.php - Include checked access in tools - ...) Issue 0000614: Display hits under thumbnails like comments counter - Add show_nb_hits to #user_infos (add in phpwebgallery_structure.sql) git-svn-id: http://piwigo.org/svn/trunk@1762 68402e56-0260-453c-a942-63ccdbb3a9ee
2007-01-22More rename indexvdigital1-1/+1
git-svn-id: http://piwigo.org/svn/trunk@1742 68402e56-0260-453c-a942-63ccdbb3a9ee
2007-01-21Inefficient and non required index is removed on #_image_category.vdigital1-1/+0
git-svn-id: http://piwigo.org/svn/trunk@1739 68402e56-0260-453c-a942-63ccdbb3a9ee
2007-01-16Modification: new data model for history, more compact, more efficient. Aplegall1-25/+49
summary table is used as cache for history stats display. New: a Perl script fill_history.pl was added to simulate a high load on history table (making the efficiency of the new data model obvious). Modification: function prepend_append_array_items moved from include/functions_search.inc.php to include/functions_search.inc.php since this function is used in new file admin/history.php Modification: admin/images/*_stats.img.php replaced by a simpler and more generic admin/images/stats.img.php unique file. New: a history detail search page was added. Currently, only start and end dates can be modified, it's just a beginning. git-svn-id: http://piwigo.org/svn/trunk@1727 68402e56-0260-453c-a942-63ccdbb3a9ee
2006-12-16Table structure for Web servicevdigital1-0/+20
git-svn-id: http://piwigo.org/svn/trunk@1662 68402e56-0260-453c-a942-63ccdbb3a9ee
2006-12-07- remove #user_cache_categories.is_child_date_lastrvelices1-1/+0
- optimize code in get_icon - correct css font-wigth:italic to font-style:italic - aditionnal check on $conf['authorize_remembering'] before allowing auto_login git-svn-id: http://piwigo.org/svn/trunk@1641 68402e56-0260-453c-a942-63ccdbb3a9ee
2006-12-01Resolved Issue ID 0000299:rub1-0/+15
o Add (new) icon of parent category with children categories including new images o Improved display text for images count o Improved (a little) mass_* functions More explications on the forum. You must call directly upgrade_feep.php (http://127.0.0.1/BSF/upgrade_feed.php for example) git-svn-id: http://piwigo.org/svn/trunk@1624 68402e56-0260-453c-a942-63ccdbb3a9ee
2006-12-01get rid of #users.auto_login_keyrvelices1-1/+0
git-svn-id: http://piwigo.org/svn/trunk@1622 68402e56-0260-453c-a942-63ccdbb3a9ee
2006-10-31plugins go now in the #plugins tablervelices1-0/+12
git-svn-id: http://piwigo.org/svn/trunk@1584 68402e56-0260-453c-a942-63ccdbb3a9ee
2006-10-30Resolved Issue ID 0000526:rub1-0/+1
o Add default group to new user Allow to have n default groups. Property are save on table #_group and can be modified on administration group screen. git-svn-id: http://piwigo.org/svn/trunk@1583 68402e56-0260-453c-a942-63ccdbb3a9ee
2006-07-26feature 169: each category can have its own image orderrvelices1-0/+1
git-svn-id: http://piwigo.org/svn/trunk@1500 68402e56-0260-453c-a942-63ccdbb3a9ee
2006-07-25fix bug 486: field username too smallnikrou1-1/+1
git-svn-id: http://piwigo.org/svn/trunk@1495 68402e56-0260-453c-a942-63ccdbb3a9ee
2006-07-23bug 451 fixed: problem with auto loginnikrou1-1/+2
- add an auto_login_key in users_table - $conf['session_length'] is no more useful and sessions length will be 0 (until browser closed) - add $conf['remember_me_name'] for cookie remember name git-svn-id: http://piwigo.org/svn/trunk@1493 68402e56-0260-453c-a942-63ccdbb3a9ee
2006-05-15merge -r1310:1311 from branch 1.6 to trunk (bug 365 fixed)plegall1-1/+1
git-svn-id: http://piwigo.org/svn/trunk@1312 68402e56-0260-453c-a942-63ccdbb3a9ee
2006-04-13merge -r1157:1158 from branch-1_6 into trunk (images_i1 comes back)plegall1-1/+2
git-svn-id: http://piwigo.org/svn/trunk@1159 68402e56-0260-453c-a942-63ccdbb3a9ee
2006-04-06improvement: urls for tags can contain now only the tag or the id and tagrvelices1-2/+4
improvement: urls for category can be now id and category names (instead of only id) improvement: added 2 indexes (#image_tag.tag_id and #tags.url_name) improvement: identification, register, search pages automatically set focus on first form input improvement: focus, nofocus css class now valid for all forms fix: category comment is tag stripped in category_subcats.inc.php (otherwise issues with html/scripts inside category comment) git-svn-id: http://piwigo.org/svn/trunk@1131 68402e56-0260-453c-a942-63ccdbb3a9ee
generated by cgit v1.2.3 (git 2.25.1) at 2024-06-29 04:50:49 +0000