diff options
| author | plegall <plg@piwigo.org> | 2004-12-18 22:05:30 +0000 |
|---|---|---|
| committer | plegall <plg@piwigo.org> | 2004-12-18 22:05:30 +0000 |
| commit | f0e9cd804af6512529982e66f73a27fa7658c46c (patch) | |
| tree | d7a2be782e859b9b4e9bdc06069122cc38c95729 /install/dbscheme.txt | |
| parent | 775e9ee74cf910f858f08b24d4b4820ea42bac85 (diff) | |
- bug fixed : in admin/cat_list, next_rank cant' be calculted and query to
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
Diffstat (limited to 'install/dbscheme.txt')
| -rw-r--r-- | install/dbscheme.txt | 5 |
1 files changed, 2 insertions, 3 deletions
diff --git a/install/dbscheme.txt b/install/dbscheme.txt index 9aae6234c..8caeb48e6 100644 --- a/install/dbscheme.txt +++ b/install/dbscheme.txt @@ -78,8 +78,7 @@ column:element_id table:rate type:mediumint column:rate table:rate type:tinyint nullable:N length:2 signed:N column:id table:sessions type:varchar nullable:N length:255 binary:Y column:user_id table:sessions type:smallint nullable:N length:5 signed:N -column:expiration table:sessions type:int nullable:N length:10 signed:N -column:ip table:sessions type:varchar nullable:N length:255 binary:N +column:expiration table:sessions type:datetime nullable:N column:id table:sites type:tinyint nullable:N length:4 signed:Y column:galleries_url table:sites type:varchar nullable:N length:255 binary:N column:user_id table:user_access type:smallint nullable:N length:5 signed:N @@ -119,7 +118,6 @@ 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,6 +133,7 @@ PK:users_pk table:users column:id PK:waiting_pk table:waiting column:id index:categories_i2 table:categories column:id_uppercat +index:history_i1 table:history column:date 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 |