aboutsummaryrefslogtreecommitdiffstats
path: root/install/phpwebgallery_structure.sql (unfollow)
Commit message (Collapse)AuthorFilesLines
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
2006-02-01feature 280: Allow visitors/users to choose image ordering inside a categoryrvelices1-3/+4
improvement 82: Viewing pictures from remote galleries does not check anymore for the high pictures (existence flag added to create_listing_file and db) correction: link element in picture is in the head instead of body (w3c spec) correction: in profile.php the current template was not selected by default git-svn-id: http://piwigo.org/svn/trunk@1020 68402e56-0260-453c-a942-63ccdbb3a9ee
2006-01-20Search engine redesign, first part :plegall1-0/+12
- new table #search to store search rules associated to a search id. - search rules are not passed through GET anymore, the search array build in search.php is serialized in #search table, so no need to rebuild it in function include/functions_category.inc.php::category_initialize - search array build code is improved (efficiency and layout) in search.php - SQL related to search is build in a dedicated function include/functions::get_sql_search_clause - direct search author:<...>, date_avalaible:<...>, date_creation:<...>, keywords:<...> from picture.php are not available anymore. They will come back later, with improvement (new design). Same for date_*:<> in calendar calendar category. git-svn-id: http://piwigo.org/svn/trunk@1008 68402e56-0260-453c-a942-63ccdbb3a9ee
2006-01-15Improve security of sessions: nikrou1-1/+1
- use only cookies to store session id on client side - use default php session system with database handler to store sessions on server side git-svn-id: http://piwigo.org/svn/trunk@1004 68402e56-0260-453c-a942-63ccdbb3a9ee
2005-12-03Database modification on users template preference with the new templateplegall1-1/+1
directory tree. git-svn-id: http://piwigo.org/svn/trunk@965 68402e56-0260-453c-a942-63ccdbb3a9ee
2005-11-24- new: system to notify and upgrade database among developersplegall1-0/+12
git-svn-id: http://piwigo.org/svn/trunk@953 68402e56-0260-453c-a942-63ccdbb3a9ee
2005-09-03(not in ChangeLog)plegall1-1/+1
- yoga template used for installation and by default in user_infos table - adaptation of yoga template to itself (no use of icons from template default) git-svn-id: http://piwigo.org/svn/trunk@860 68402e56-0260-453c-a942-63ccdbb3a9ee
2005-09-03- modification : less configuration parameters in administrationplegall1-9/+9
screen. These parameters are move to include/config_default.inc.php. - new : ability to add a single picture to caddie from picture.php - new : contextual help, only a few pages are available. - new : ability to delete users from admin/user_list - modification : reorganization of configuration file - new : configuration parameter use_exif_mapping - improvement : MOD hidemail added to standard git-svn-id: http://piwigo.org/svn/trunk@858 68402e56-0260-453c-a942-63ccdbb3a9ee
2005-08-19- modification : RSS feed work only with a given feed identifier. Thus weplegall1-2/+12
can avoid fixed frequency notification to concentrate on variable frequency notification, which is much more interesting. To do this, feeds have moved to a dedicated table allowing each user (including guest user) to have more than on feed. git-svn-id: http://piwigo.org/svn/trunk@833 68402e56-0260-453c-a942-63ccdbb3a9ee
2005-08-08- new : external authentication in another users table. Previous users tableplegall1-10/+20
is divided between users (common properties with any web application) and user_infos (phpwebgallery specific informations). External table and fields can be configured. - modification : profile.php is not reachable through administration anymore (not useful). - modification : in profile.php, current password is mandatory only if user tries to change his password. Username can't be changed. - deletion : of obsolete functions get_user_restrictions, update_user_restrictions, get_user_all_restrictions, is_user_allowed, update_user - modification : $user['forbidden_categories'] equals at least "-1" so that category_id NOT IN ($user['forbidden_categories']) can always be used. - modification : user_forbidden table becomes user_cache so that not only restriction informations can be stored in this table. git-svn-id: http://piwigo.org/svn/trunk@808 68402e56-0260-453c-a942-63ccdbb3a9ee
2005-07-16- new feature : RSS notification feed. Feed generator is an external toolplegall1-188/+194
(FeedCreator class v1.7.2). New file feed.php - new database field : comments.validation_date (datetime). This field is required for notification feed. - new database field : users.feed_id (varchar(50)). users.feed_id is an alias of users.id but is much more complicated to find (50 characters, figures or letters, case sensitive) : the purpose is to keep it secret (as far as possible). - new database field : users.last_feed_check (datetime) - new database field : users.registration_date (datetime) - bug fixed : no need to add the (unavailable) session id to install.php in the installation form. - modified database field : images.date_available become more precise (date to datetime). This precision is needed for notification feed. - new index : comments_i1 (validation_date). Might be useful for feed queries. - new index : comments_i2 (image_id). Useful each time you want to have informations about an element and its associated comments. - version 9.11 of mysqldump outputs database field names and table names with backquote "`" (didn't find how to take them off) git-svn-id: http://piwigo.org/svn/trunk@801 68402e56-0260-453c-a942-63ccdbb3a9ee
2005-03-25- new feature : caddie (new table was forgotten in previous commit)plegall1-0/+11
git-svn-id: http://piwigo.org/svn/trunk@757 68402e56-0260-453c-a942-63ccdbb3a9ee
2004-12-20- in picture.php, $user['maxwidth'] and $user['maxheight'] can be unset ifplegall1-1/+12
NULL in database - new table user_forbidden {user_id,need_update,forbidden_categories} and deletion of field users.forbidden_categories - new function calculate_permissions to update table user_forbidden when needed - simplification of include/user.inc.php - in footer of each page, use "-" instead of "::" to separate page information git-svn-id: http://piwigo.org/svn/trunk@648 68402e56-0260-453c-a942-63ccdbb3a9ee
2004-12-18- bug fixed : in admin/cat_list, next_rank cant' be calculted and query toplegall1-2/+1
count sub-categories per sub-categories became false if no sub-categories - virtual association come back in admin/infos_images (not only in admin/picture_modify) - check_favorites function in admin section becomes check_user_favorites in public section : favorites are checked when user tries to display his favorites. Function was optimized. - in function update_category, wrap of long queries due to many categories to update at the same time - typo fixed in description of paginate_pages_around configuration parameter - bug fixed in new navigation bar : no separation pipe was displayed between next and last when the page displayed was the last - sessions.expiration changed of type from int to datetime (a lot easier to read) - sessions.ip removed : IP address is no longer used to verify session - $lang['cat_options'] was missing in en_UK.iso-8859-1 - typo fixed in language/en_UK.iso-8859-1/admin.lang.php on editcat_lock_info language item git-svn-id: http://piwigo.org/svn/trunk@647 68402e56-0260-453c-a942-63ccdbb3a9ee
2004-11-24changing name of key from none to history_i1plegall1-1/+1
git-svn-id: http://piwigo.org/svn/trunk@616 68402e56-0260-453c-a942-63ccdbb3a9ee
2004-11-24Drop of PRIMARY Key on history table.gweltas1-1/+1
git-svn-id: http://piwigo.org/svn/trunk@615 68402e56-0260-453c-a942-63ccdbb3a9ee
2004-11-23- global categories' options : instead of N horizontal tabs on a singleplegall1-0/+1
page, N options in the left menu (but the same backend) - categories.global_rank : new calculated field. It gives a global rank of the category among all others (updated during ordering) - category.php page : menu is generated faster thanks to categories.global_rank, recursivity becomes useless :-) - new function to display select box with a set of categories : display_select_cat_wrapper - cat_options : instead of using 1 multiselect for true/false items, using 1 multiselect for true, and another one for false. The form provides buttons with arrows to switch categories from one multiselect to another - deletion of obsolete function display_categories (working with the old template system) - deletion of obsolete functions get_user_plain_structure, create_user_structure, get_user_subcat_ids, update_structure, count_images : useless thanks to global_rank git-svn-id: http://piwigo.org/svn/trunk@614 68402e56-0260-453c-a942-63ccdbb3a9ee
2004-11-21optimization : instead of reading each $conf['calendar_datefield'] forplegall1-1/+2
matching YEAR() and MONTH(), use of SQL statement BETWEEN ... AND ... on the date field + new index image_i5 on date_creation (default date field for calendar) git-svn-id: http://piwigo.org/svn/trunk@612 68402e56-0260-453c-a942-63ccdbb3a9ee
generated by cgit v1.2.3 (git 2.25.1) at 2024-11-16 13:30:39 +0000