You are viewing a plain text version of this content. The canonical link for it is here.

Posted to olio-commits@incubator.apache.org by ak...@apache.org on 2009/01/27 01:21:34 UTC

svn commit: r737960 - /incubator/olio/webapp/php/trunk/etc/schema.sql

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,