[pLog-svn] r3404 - plog/trunk/install

[oscar at devel.lifetype.net]

Author: oscar
Date: 2006-05-13 15:54:41 +0000 (Sat, 13 May 2006)
New Revision: 3404

Modified:
   plog/trunk/install/dbschemas.properties.php
Log:
this index will make it faster to check which blogs have been created in the last 7 days


Modified: plog/trunk/install/dbschemas.properties.php
===================================================================
--- plog/trunk/install/dbschemas.properties.php	2006-05-13 15:53:53 UTC (rev 3403)
+++ plog/trunk/install/dbschemas.properties.php	2006-05-13 15:54:41 UTC (rev 3404)
@@ -103,7 +103,8 @@
   INDEX owner_id (owner_id),
   INDEX mangled_blog (mangled_blog),
   INDEX blog_category_id(blog_category_id),
-  INDEX custom_domain(custom_domain)
+  INDEX custom_domain(custom_domain),
+  INDEX create_date(create_date)
 ";
 $Tables["blogs"]["options"] = "TYPE=MyISAM";
 
@@ -360,4 +361,4 @@
 ";
 $Tables["global_articles_categories"]["options"] = "TYPE=MyISAM";
 
-?>
\ No newline at end of file
+?>