r9905 - apps/gobi/trunk/db/relational

Author: hannes
Date: 2009-09-15 21:51:24 +0200 (Tue, 15 Sep 2009)
New Revision: 9905

Modified:
   apps/gobi/trunk/db/relational/gobi-mysql.sql
Log:
Add some indexes at last


Details at http://dev.helma.org/trac/helma/changeset/9905

Modified: apps/gobi/trunk/db/relational/gobi-mysql.sql
===================================================================
--- apps/gobi/trunk/db/relational/gobi-mysql.sql	2009-09-15 15:41:24 UTC (rev 9904)
+++ apps/gobi/trunk/db/relational/gobi-mysql.sql	2009-09-15 19:51:24 UTC (rev 9905)
@@ -24,6 +24,9 @@
     serial_id integer
 );
 
+create index page_parent_name_collection on page (parent_id, name, collection);
+create index page_parent_collection_createtime on page (parent_id, collection, createtime);
+
 insert into page (id, name, prototype, body, createtime, modifytime) values
  (0, "Gobi", "root", "Welcome to Gobi!", now(), now());
 
@@ -39,3 +42,6 @@
     info text,
     serial_id integer
 );
+
+create index link_source_type on link (source_id, type);
+create index link_target_type on link (target_id, type);