Author: cyb
Date: Wed May 9 11:08:52 2007
New Revision: 423
URL: http://svn.gna.org/viewcvs/phplinker?rev=423&view=rev
Log:
#177: added FULLTEXT index on url.description
Modified:
trunk/doc/phplinker.sql
Modified: trunk/doc/phplinker.sql
URL:
http://svn.gna.org/viewcvs/phplinker/trunk/doc/phplinker.sql?rev=423&r1=422&r2=423&view=diff
==============================================================================
--- trunk/doc/phplinker.sql (original)
+++ trunk/doc/phplinker.sql Wed May 9 11:08:52 2007
@@ -114,7 +114,8 @@
KEY `state` (`state`),
KEY `hit` (`hit`),
KEY `last_update` (`last_update`),
- UNIQUE KEY `url+state` (`url`,`state`)
+ UNIQUE KEY `url+state` (`url`,`state`),
+ FULLTEXT KEY `description` (`description`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-- --------------------------------------------------------
_______________________________________________
PHPLinker-commits mailing list
[email protected]
https://mail.gna.org/listinfo/phplinker-commits
