aboutsummaryrefslogtreecommitdiffstats
path: root/install/dbscheme.txt (unfollow)
Commit message (Collapse)AuthorFilesLines
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-0/+1
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-2/+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-10-23there was a bug in the mysql structure script generator : when a column wasz0rglub1-91/+91
nullable the script said the opposite git-svn-id: http://piwigo.org/svn/trunk@573 68402e56-0260-453c-a942-63ccdbb3a9ee
2004-08-30add rating featurez0rglub1-0/+7
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@487 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 storage_category_id to images_i1z0rglub1-6/+7
- new index images_i2 on images.date_available git-svn-id: http://piwigo.org/svn/trunk@443 68402e56-0260-453c-a942-63ccdbb3a9ee
2004-05-28table user_category droppedz0rglub1-7/+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-133/+137
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-04initial revisionz0rglub1-0/+134
git-svn-id: http://piwigo.org/svn/trunk@384 68402e56-0260-453c-a942-63ccdbb3a9ee
generated by cgit v1.2.3 (git 2.25.1) at 2024-07-04 12:53:01 +0000