incubator-olio-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From ak...@apache.org
Subject svn commit: r737960 - /incubator/olio/webapp/php/trunk/etc/schema.sql
Date Tue, 27 Jan 2009 01:21:34 GMT
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,



Mime
View raw message