[Phpbb-checkins] CVS: phpBB2/db/schemas mysql_schema.sql,1.13,1.14 postgres_schema.sql,1.15,1.16

[Bart v. B. <ba...@us...>]

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);