Update of /cvsroot/php-blog/serendipity/sql
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv29328
Modified Files:
db.sql
Log Message:
revert change for mysql postgresql users will have to modify this index according to db_update_0.6.9_0.7.0_postgresql.sql
Index: db.sql
===================================================================
RCS file: /cvsroot/php-blog/serendipity/sql/db.sql,v
retrieving revision 1.20
retrieving revision 1.21
diff -u -d -r1.20 -r1.21
--- db.sql 30 Oct 2004 22:45:12 -0000 1.20
+++ db.sql 1 Nov 2004 14:11:27 -0000 1.21
@@ -66,7 +66,7 @@
);
#Creating an index on the body and extended body is a bad idea
-CREATE {FULLTEXT} INDEX entry_idx on {PREFIX}entries (title);
+CREATE {FULLTEXT} INDEX entry_idx on {PREFIX}entries (title,body,extended);
CREATE INDEX date_idx ON {PREFIX}entries (timestamp);
CREATE INDEX mod_idx ON {PREFIX}entries (last_modified);
|
