Changeset 2517 for trunk/install

Timestamp:

Sep 11, 2008, 11:40:00 PM (16 years ago)

Author:

plg

Message:

feature 169 added: ability to manually sort images inside a category. A
dedicated screen let the administrator sort the images (pur HTML, no
JavaScript yet). The "rank" sort order is available only for a category
without flat mode. New database column image_category.rank.

Location:

trunk/install

Files:

• db/76-database.php (added)
• piwigo_structure.sql (modified) (1 diff)

trunk/install/piwigo_structure.sql

@@ -151 +151 @@
   `image_id` mediumint(8) unsigned NOT NULL default '0',
   `category_id` smallint(5) unsigned NOT NULL default '0',
+  `rank` mediumint(8) unsigned default NULL,
   PRIMARY KEY  (`image_id`,`category_id`),
   KEY `image_category_i1` (`category_id`)