Author: akara
Date: Tue Jan 27 01:21:33 2009
New Revision: 737960
URL: http://svn.apache.org/viewvc?rev=737960&view=rev
Log:
Fix for issue OLIO-47: Add index to search tags table by tag name. Currently
only on tag id which is not used for searches.
Modified:
incubator/olio/webapp/php/trunk/etc/schema.sql
Modified: incubator/olio/webapp/php/trunk/etc/schema.sql
URL:
http://svn.apache.org/viewvc/incubator/olio/webapp/php/trunk/etc/schema.sql?rev=737960&r1=737959&r2=737960&view=diff
==============================================================================
--- incubator/olio/webapp/php/trunk/etc/schema.sql (original)
+++ incubator/olio/webapp/php/trunk/etc/schema.sql Tue Jan 27 01:21:33 2009
@@ -84,6 +84,8 @@
unique(tag)
)ENGINE=InnoDB;
+CREATE INDEX SOCIALEVENTTAG_TAG on SOCIALEVENTTAG (tag);
+
create table SOCIALEVENTTAG_SOCIALEVENT(
socialeventtagid INTEGER NOT NULL,
socialeventid INTEGER NOT NULL,
