Changeset 647 for trunk/install/dbscheme.txt

Timestamp:

Dec 18, 2004, 11:05:30 PM (20 years ago)

Author:

plg

Message:

• 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

• $langcat_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

File:

• trunk/install/dbscheme.txt (modified) (3 diffs)

trunk/install/dbscheme.txt

@@ -79 +79 @@
 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
@@ -120 +119 @@
 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
@@ -136 +134 @@
 
 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