diff options
| author | rvelices <rv-github@modusoptimus.com> | 2006-04-06 02:23:54 +0000 |
|---|---|---|
| committer | rvelices <rv-github@modusoptimus.com> | 2006-04-06 02:23:54 +0000 |
| commit | d700a5917233fb8049589a9e0aef3d94e87fb320 (patch) | |
| tree | 81f8c53ccf908e900638abd117f3dc8719ca67a1 /install/phpwebgallery_structure.sql | |
| parent | b9a37cd6f06a19fd48d4a8e546b10c8fb3ff5b33 (diff) | |
improvement: urls for tags can contain now only the tag or the id and tag
improvement: urls for category can be now id and category names (instead
of only id)
improvement: added 2 indexes (#image_tag.tag_id and #tags.url_name)
improvement: identification, register, search pages automatically set focus
on first form input
improvement: focus, nofocus css class now valid for all forms
fix: category comment is tag stripped in category_subcats.inc.php
(otherwise issues with html/scripts inside category comment)
git-svn-id: http://piwigo.org/svn/trunk@1131 68402e56-0260-453c-a942-63ccdbb3a9ee
Diffstat (limited to 'install/phpwebgallery_structure.sql')
| -rw-r--r-- | install/phpwebgallery_structure.sql | 6 |
1 files changed, 4 insertions, 2 deletions
diff --git a/install/phpwebgallery_structure.sql b/install/phpwebgallery_structure.sql index 253157e79..dbc7b2335 100644 --- a/install/phpwebgallery_structure.sql +++ b/install/phpwebgallery_structure.sql @@ -140,7 +140,8 @@ DROP TABLE IF EXISTS `phpwebgallery_image_tag`; CREATE TABLE `phpwebgallery_image_tag` ( `image_id` mediumint(8) unsigned NOT NULL default '0', `tag_id` smallint(5) unsigned NOT NULL default '0', - PRIMARY KEY (`image_id`,`tag_id`) + PRIMARY KEY (`image_id`,`tag_id`), + KEY `image_tag_i1` (`tag_id`) ) TYPE=MyISAM; -- @@ -233,7 +234,8 @@ CREATE TABLE `phpwebgallery_tags` ( `id` smallint(5) unsigned NOT NULL auto_increment, `name` varchar(255) binary NOT NULL default '', `url_name` varchar(255) binary NOT NULL default '', - PRIMARY KEY (`id`) + PRIMARY KEY (`id`), + KEY `tags_i1` (`url_name`) ) TYPE=MyISAM; -- |