|
From: Bart v. B. <ba...@us...> - 2002-01-11 13:15:52
|
Update of /cvsroot/phpbb/phpBB2/db/schemas
In directory usw-pr-cvs1:/tmp/cvs-serv28700
Modified Files:
mysql_schema.sql postgres_schema.sql
Log Message:
Added index on topic_type (topics table)
Index: mysql_schema.sql
===================================================================
RCS file: /cvsroot/phpbb/phpBB2/db/schemas/mysql_schema.sql,v
retrieving revision 1.13
retrieving revision 1.14
diff -C2 -r1.13 -r1.14
*** mysql_schema.sql 2002/01/10 02:15:52 1.13
--- mysql_schema.sql 2002/01/11 13:15:49 1.14
***************
*** 429,433 ****
KEY forum_id (forum_id),
KEY topic_moved_id (topic_moved_id),
! KEY topic_status (topic_status)
);
--- 429,434 ----
KEY forum_id (forum_id),
KEY topic_moved_id (topic_moved_id),
! KEY topic_status (topic_status),
! KEY topic_type (topic_type)
);
Index: postgres_schema.sql
===================================================================
RCS file: /cvsroot/phpbb/phpBB2/db/schemas/postgres_schema.sql,v
retrieving revision 1.15
retrieving revision 1.16
diff -C2 -r1.15 -r1.16
*** postgres_schema.sql 2002/01/10 02:15:52 1.15
--- postgres_schema.sql 2002/01/11 13:15:49 1.16
***************
*** 409,412 ****
--- 409,413 ----
CREATE INDEX topic_last_post_id_phpbb_topics_index ON phpbb_topics (topic_last_post_id);
CREATE INDEX topic_status_phpbb_topics_index ON phpbb_topics (topic_status);
+ CREATE INDEX topic_type_phpbb_topics_index ON phpbb_topics (topic_type);
|