Changeset 614 for trunk/install

Timestamp:

Nov 23, 2004, 11:31:24 PM (20 years ago)

Author:

plg

Message:

• global categories' options : instead of N horizontal tabs on a single 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

Location:

trunk/install

Files:

• dbscheme.txt (modified) (1 diff)
• phpwebgallery_structure.sql (modified) (1 diff)

trunk/install/dbscheme.txt

@@ -32 +32 @@
 column:uppercats                 table:categories     type:varchar                  nullable:N length:255 binary:N
 column:commentable               table:categories     type:enum('true','false')     nullable:N
+column:global_rank               table:categories     type:varchar                  nullable:Y length:255 binary: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

trunk/install/phpwebgallery_structure.sql

@@ -26 +26 @@
   uppercats varchar(255) NOT NULL default '',
   commentable enum('true','false') NOT NULL default 'true',
+  global_rank varchar(255) default NULL,
   PRIMARY KEY  (id),
   KEY categories_i2 (id_uppercat)