diff options
| author | plegall <plg@piwigo.org> | 2008-09-11 21:40:00 +0000 |
|---|---|---|
| committer | plegall <plg@piwigo.org> | 2008-09-11 21:40:00 +0000 |
| commit | d39db9aaaf43eaedd634a7a5b7d06bcb69d41152 (patch) | |
| tree | 645010e01f3d84ecbc131c883ca941c50386489b /install/piwigo_structure.sql | |
| parent | fdffe42bdc703a9f2391c77ae0256c33a3eac935 (diff) | |
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.
git-svn-id: http://piwigo.org/svn/trunk@2517 68402e56-0260-453c-a942-63ccdbb3a9ee
Diffstat (limited to '')
| -rw-r--r-- | install/piwigo_structure.sql | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/install/piwigo_structure.sql b/install/piwigo_structure.sql index 5cae5b353..996c881da 100644 --- a/install/piwigo_structure.sql +++ b/install/piwigo_structure.sql @@ -150,6 +150,7 @@ DROP TABLE IF EXISTS `piwigo_image_category`; CREATE TABLE `piwigo_image_category` ( `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`) ) TYPE=MyISAM; |