aboutsummaryrefslogtreecommitdiffstats
path: root/install/piwigo_structure.sql (unfollow)
Commit message (Collapse)AuthorFilesLines
2009-12-02Feature 1255 :nikrou1-442/+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
2006-04-04feature deleted: code for categories link was too complicated for such aplegall1-12/+1
simple fature. Replaced by static association. Links are not persistent anymore. modification removed: #image_category.is_storage replaced by #images.storage_category_id as in branche 1.5.. git-svn-id: http://piwigo.org/svn/trunk@1121 68402e56-0260-453c-a942-63ccdbb3a9ee
2006-04-02improvement: tags replace keywords. Better data model, lessplegall1-6/+25
limitations. Each image can be associated to as many tag as needed. Tags can contain non ASCII characters. Oriented navigation with tags by association. git-svn-id: http://piwigo.org/svn/trunk@1119 68402e56-0260-453c-a942-63ccdbb3a9ee
2006-04-01[NBM] Step 7: Add functionalities subscribe/unsubscribe:rub1-1/+1
o reduce length of check_key o fix bugs o send mail on subscribe/unsubscribe o add and used $conf parameters o review keyword of languages o improve selection/check o can subscribe/unsubscribe with a link include on mail o fix bug mass_update collate git-svn-id: http://piwigo.org/svn/trunk@1116 68402e56-0260-453c-a942-63ccdbb3a9ee
2006-03-23URL rewrite: 3 options in the config file define behaviour (question mark rvelices1-1/+1
removal, file name for picture and .php extension removal) fix: added unsigned for column in install sql - for the sake of uniformization change: add_url_param is now add_url_params and takes an array as parameter instead of a string git-svn-id: http://piwigo.org/svn/trunk@1094 68402e56-0260-453c-a942-63ccdbb3a9ee
2006-03-16Step 7 improvement issue 0000301:rub1-0/+1
o can attribute status <= current user o define mode adviser => buttons disabled (gray on IE, not on FF) => truncated actions => display info mode adviser git-svn-id: http://piwigo.org/svn/trunk@1085 68402e56-0260-453c-a942-63ccdbb3a9ee
2006-03-15feature 262: new user cached information nb_total_picturesrvelices1-0/+1
git-svn-id: http://piwigo.org/svn/trunk@1081 68402e56-0260-453c-a942-63ccdbb3a9ee
2006-03-13Step 1 improvement issue 0000127:rub1-0/+1
o Add field enabled_high of table #_user_infos o Add $conf['newuser_default_enabled_high'] o Used field on picture.php git-svn-id: http://piwigo.org/svn/trunk@1078 68402e56-0260-453c-a942-63ccdbb3a9ee
2006-03-09bug 255: parameter values in #config limited to 255 chars (value becomes text)rvelices1-1/+1
feature 303: page banner moved from combination of gallery_title, gallery_description and template to database (simplifies user customization) git-svn-id: http://piwigo.org/svn/trunk@1071 68402e56-0260-453c-a942-63ccdbb3a9ee
2006-03-08Step 1 improvement issue 0000301:rub1-1/+2
o Change status of table #_user_infos o Don't send password to webmaster, guest, generic Next Step: o Functions Check of status o Restricted Access for user generic git-svn-id: http://piwigo.org/svn/trunk@1070 68402e56-0260-453c-a942-63ccdbb3a9ee
2006-03-04new feature: source/destination links between categories. Will we keep thisplegall1-17/+29
feature? Code is complicated and very few people will understand how it works... modification: #images.storage_category_id replaced by #image_category.is_storage improvement: many code refactoring to improve readibility improvement: virtual category creation code was moved to a dedicated function in order to be called from admin/cat_list.php and admin/cat_modify.php (create a new destination category) git-svn-id: http://piwigo.org/svn/trunk@1064 68402e56-0260-453c-a942-63ccdbb3a9ee
2006-02-14feature 251: Rating For Anonymous usersrvelices1-1/+3
fix: page['items'] for favorites category and remove old use of $has_next, $has_prev in picture.php (slideshow and favorites section) optimization: one less sql query in picture.php when there are no comments display of the refresh url in redirect.tpl (useful when debugging with browser meta redirects disabled) git-svn-id: http://piwigo.org/svn/trunk@1041 68402e56-0260-453c-a942-63ccdbb3a9ee
2006-02-06[NBM] Step 2: Add new table user_mail_notification (update, install, ↵rub1-0/+14
constants, delete user + Correction delete user (table user_feed missing, table sessions must be removed) git-svn-id: http://piwigo.org/svn/trunk@1028 68402e56-0260-453c-a942-63ccdbb3a9ee