aboutsummaryrefslogtreecommitdiffstats
path: root/install/phpwebgallery_structure.sql (unfollow)
Commit message (Collapse)AuthorFilesLines
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
2004-11-16- images.path column added to reduce database accessplegall1-0/+1
- function mass_inserts moved from admin/remote_sites.php to admin/include/function.php - function mass_inserts used in admin/update.php git-svn-id: http://piwigo.org/svn/trunk@606 68402e56-0260-453c-a942-63ccdbb3a9ee
2004-11-13- admin/cat_options page added : manage options for the whole categoriesplegall1-3/+6
tree (uploadable, commentable). status and visible will be soon added - admin.php : $conf_link var to avoid lines longer than 79 characters - config.upload_available configuration parameter disappear : it's simpler to manage with cat_options - config.show_comments idem : new column categories.commentable, each categories can be commentable or not - categories.site_id becomes a nullable column : a virtual category does belong to no site - function display_select_categories has a new argument : $CSS_classes array to optionnaly assign a CSS class to each category in the select field - added informations in include/config.inc.php for setting default value of : - categories.visible - categories.status - categories.uploadable - categories.commentable - 2 new indexes images_i3(average_rate) and images_i4(hit) : optimizes best rated and most visited categories git-svn-id: http://piwigo.org/svn/trunk@602 68402e56-0260-453c-a942-63ccdbb3a9ee
2004-09-26-First draft of history displaygweltas1-2/+3
git-svn-id: http://piwigo.org/svn/trunk@537 68402e56-0260-453c-a942-63ccdbb3a9ee
2004-08-30add rating featurez0rglub1-0/+13
git-svn-id: http://piwigo.org/svn/trunk@507 68402e56-0260-453c-a942-63ccdbb3a9ee
2004-08-21- add files metadata support : use info for database fieldsz0rglub1-0/+1
- distinction between directories synchronization and metadata synchronization git-svn-id: http://piwigo.org/svn/trunk@486 68402e56-0260-453c-a942-63ccdbb3a9ee
2004-08-05- non picture files management (adds column images.representative_ext)z0rglub1-3/+3
- short_period + long_period replaced by a single recent_period git-svn-id: http://piwigo.org/svn/trunk@474 68402e56-0260-453c-a942-63ccdbb3a9ee
2004-06-25- moved index images.storage_category_id to images_i1z0rglub1-1/+2
- new index images_i2 on images.date_available git-svn-id: http://piwigo.org/svn/trunk@444 68402e56-0260-453c-a942-63ccdbb3a9ee
2004-05-28table user_category droppedz0rglub1-13/+0
git-svn-id: http://piwigo.org/svn/trunk@423 68402e56-0260-453c-a942-63ccdbb3a9ee
2004-05-20field comments.date becomes a datetime MySQL field type (instead of int)z0rglub1-1/+1
git-svn-id: http://piwigo.org/svn/trunk@420 68402e56-0260-453c-a942-63ccdbb3a9ee
2004-03-31bug 15 : useless index in categories droppedz0rglub1-1/+0
git-svn-id: http://piwigo.org/svn/trunk@407 68402e56-0260-453c-a942-63ccdbb3a9ee
2004-03-04new version of config tablez0rglub1-22/+5
git-svn-id: http://piwigo.org/svn/trunk@385 68402e56-0260-453c-a942-63ccdbb3a9ee
2004-03-04move admin/phpwebgallery_structure.sql to install/phpwebgallery_structure.sqlz0rglub1-0/+0
git-svn-id: http://piwigo.org/svn/trunk@381 68402e56-0260-453c-a942-63ccdbb3a9ee
2004-02-10adding all new features of branch 1.3, using new index naming conventionz0rglub1-6/+25
git-svn-id: http://piwigo.org/svn/trunk@356 68402e56-0260-453c-a942-63ccdbb3a9ee
2004-02-032004.02.03_01h00 : auto commitz0rglub1-22/+3
git-svn-id: http://piwigo.org/svn/trunk@347 68402e56-0260-453c-a942-63ccdbb3a9ee
2004-02-02Merge of the 1.3.1 releasegweltas1-3/+22
Creation of an unique include file (common.php) Creation of an unique define file (include/constants.php) Modification of the installation procedure git-svn-id: http://piwigo.org/svn/trunk@345 68402e56-0260-453c-a942-63ccdbb3a9ee
2004-01-072004.01.07_01h00 : auto commitz0rglub1-0/+244
git-svn-id: http://piwigo.org/svn/trunk@266 68402e56-0260-453c-a942-63ccdbb3a9ee
2004-01-062004.01.06_01h00 : auto commitz0rglub1-244/+0
git-svn-id: http://piwigo.org/svn/trunk@265 68402e56-0260-453c-a942-63ccdbb3a9ee
2003-09-202003.09.21_01h00 : auto commitz0rglub1-2/+3
git-svn-id: http://piwigo.org/svn/trunk@149 68402e56-0260-453c-a942-63ccdbb3a9ee
2003-09-192003.09.20_01h00 : auto commitz0rglub1-0/+1
git-svn-id: http://piwigo.org/svn/trunk@137 68402e56-0260-453c-a942-63ccdbb3a9ee
2003-09-142003.09.15_01h00 : auto commitz0rglub1-1/+1
git-svn-id: http://piwigo.org/svn/trunk@112 68402e56-0260-453c-a942-63ccdbb3a9ee
2003-09-102003.09.11_01h00 : auto commitz0rglub1-1/+2
git-svn-id: http://piwigo.org/svn/trunk@86 68402e56-0260-453c-a942-63ccdbb3a9ee
2003-09-07`/bin/date +"%Y.%m.%d_%Hh%M"`z0rglub1-1/+1
git-svn-id: http://piwigo.org/svn/trunk@80 68402e56-0260-453c-a942-63ccdbb3a9ee
2003-09-05`/bin/date +"%Y.%m.%d_%Hh%M"`z0rglub1-1/+1
git-svn-id: http://piwigo.org/svn/trunk@65 68402e56-0260-453c-a942-63ccdbb3a9ee
2003-08-30`/bin/date +"%Y.%m.%d_%Hh%M"`z0rglub1-1/+1
git-svn-id: http://piwigo.org/svn/trunk@62 68402e56-0260-453c-a942-63ccdbb3a9ee
2003-08-29`/bin/date +"%Y.%m.%d_%Hh%M"`z0rglub1-1/+1
git-svn-id: http://piwigo.org/svn/trunk@59 68402e56-0260-453c-a942-63ccdbb3a9ee
2003-08-24`/bin/date +"%Y.%m.%d_%Hh%M"`z0rglub1-5/+15
git-svn-id: http://piwigo.org/svn/trunk@58 68402e56-0260-453c-a942-63ccdbb3a9ee
2003-07-26`/bin/date +"%Y.%m.%d_%Hh%M"`z0rglub1-1/+3
git-svn-id: http://piwigo.org/svn/trunk@43 68402e56-0260-453c-a942-63ccdbb3a9ee
2003-07-24Adding support of independant uploadable categoriesz0rglub1-0/+1
git-svn-id: http://piwigo.org/svn/trunk@35 68402e56-0260-453c-a942-63ccdbb3a9ee
2003-07-23First commitz0rglub1-0/+228
git-svn-id: http://piwigo.org/svn/trunk@34 68402e56-0260-453c-a942-63ccdbb3a9ee
generated by cgit v1.2.3 (git 2.25.1) at 2024-11-17 06:19:27 +0000