Changeset 1131 for trunk/install

Timestamp:

Apr 6, 2006, 4:23:54 AM (18 years ago)

Author:

rvelices

Message:

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)

Location:

trunk/install

Files:

• db/22-database.php (added)
• phpwebgallery_structure.sql (modified) (2 diffs)

trunk/install/phpwebgallery_structure.sql

@@ -141 +141 @@
   `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;
 
@@ -234 +235 @@
   `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;