diff options
| author | plegall <plg@piwigo.org> | 2004-11-13 13:43:53 +0000 |
|---|---|---|
| committer | plegall <plg@piwigo.org> | 2004-11-13 13:43:53 +0000 |
| commit | 88e4e1e60adf660651f9276ab2b19bffcc72d9d3 (patch) | |
| tree | c5ee67d2ba4ee38b2864cf136787d187d12a2c07 /install/dbscheme.txt | |
| parent | 234b7463520902a62e0c3e4e35c00a9e27f14278 (diff) | |
- admin/cat_options page added : manage options for the whole categories
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
Diffstat (limited to 'install/dbscheme.txt')
| -rw-r--r-- | install/dbscheme.txt | 8 |
1 files changed, 6 insertions, 2 deletions
diff --git a/install/dbscheme.txt b/install/dbscheme.txt index de53364c0..b190134b5 100644 --- a/install/dbscheme.txt +++ b/install/dbscheme.txt @@ -25,11 +25,12 @@ column:comment table:categories type:text column:dir table:categories type:varchar nullable:Y length:255 binary:N column:rank table:categories type:tinyint nullable:Y length:3 signed:N column:status table:categories type:enum('public','private') nullable:N -column:site_id table:categories type:tinyint nullable:N length:4 signed:N +column:site_id table:categories type:tinyint nullable:Y length:4 signed:N column:visible table:categories type:enum('true','false') nullable:N column:uploadable table:categories type:enum('true','false') nullable:N column:representative_picture_id table:categories type:mediumint nullable:Y length:8 signed:N column:uppercats table:categories type:varchar nullable:N length:255 binary:N +column:commentable table:categories type:enum('true','false') nullable:N column:id table:comments type:int nullable:N length:11 signed:N column:image_id table:comments type:mediumint nullable:N length:8 signed:N column:date table:comments type:datetime nullable:N @@ -45,7 +46,7 @@ column:group_id table:group_access type:smallint column:cat_id table:group_access type:smallint nullable:N length:5 signed:N column:id table:groups type:smallint nullable:N length:5 signed:N column:name table:groups type:varchar nullable:N length:255 binary:N -column:date table:history type:int nullable:N length:11 signed:Y +column:date table:history type:datetime nullable:N column:login table:history type:varchar nullable:Y length:15 binary:N column:IP table:history type:varchar nullable:N length:50 binary:N column:category table:history type:varchar nullable:Y length:150 binary:N @@ -116,6 +117,7 @@ PK:favorites_pk table:favorites column:image_id PK:group_access_pk table:group_access column:group_id PK:group_access_pk table:group_access column:cat_id PK:groups_pk table:groups column:id +PK:history_pk table:history column:date PK:image_category_pk table:image_category column:image_id PK:image_category_pk table:image_category column:category_id PK:images_pk table:images column:id @@ -135,5 +137,7 @@ index:image_category_i1 table:image_category column:image_id index:image_category_i2 table:image_category column:category_id index:images_i2 table:images column:date_available index:images_i1 table:images column:storage_category_id +index:images_i3 table:images column:average_rate +index:images_i4 table:images column:hit index:sites_ui1 table:sites column:galleries_url index:users_ui1 table:users column:username |