[php-blog-cvs] serendipity/sql db_update_0.5.1_0.6_mysql.sql,NONE,1.1 db_update_0.5.1_0.6_pgsql.sql,NONE,1.1 db.sql,1.2,1.3

[Garvin H. <gar...@us...>]

Update of /cvsroot/php-blog/serendipity/sql
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv11423/sql

Modified Files:
	db.sql 
Added Files:
	db_update_0.5.1_0.6_mysql.sql db_update_0.5.1_0.6_pgsql.sql 
Log Message:
Optimized indizes (thanks, zem!)


--- NEW FILE: db_update_0.5.1_0.6_mysql.sql ---
CREATE INDEX date_idx ON {PREFIX}entries (timestamp);

CREATE INDEX mod_idx ON {PREFIX}entries (last_modified);
--- NEW FILE: db_update_0.5.1_0.6_pgsql.sql ---
CREATE INDEX date_idx ON {PREFIX}entries (timestamp);

CREATE INDEX mod_idx ON {PREFIX}entries (last_modified);
Index: db.sql
===================================================================
RCS file: /cvsroot/php-blog/serendipity/sql/db.sql,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -d -r1.2 -r1.3
--- db.sql	3 Mar 2004 13:55:34 -0000	1.2
+++ db.sql	16 Mar 2004 09:25:37 -0000	1.3
@@ -53,6 +53,8 @@
 );
 
 CREATE {FULLTEXT} INDEX entry on {PREFIX}entries (title,body,extended);
+CREATE INDEX date_idx ON {PREFIX}entries (timestamp);
+CREATE INDEX mod_idx ON {PREFIX}entries (last_modified);
 
 #
 # table structure for table '{PREFIX}references'