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

[oscar at devel.lifetype.net]

Author: oscar
Date: 2006-05-01 19:57:51 +0000 (Mon, 01 May 2006)
New Revision: 3309

Modified:
   plog/trunk/install/dbschemas.properties.php
Log:
removed unnecessary field


Modified: plog/trunk/install/dbschemas.properties.php
===================================================================
--- plog/trunk/install/dbschemas.properties.php	2006-05-01 16:38:36 UTC (rev 3308)
+++ plog/trunk/install/dbschemas.properties.php	2006-05-01 19:57:51 UTC (rev 3309)
@@ -2,7 +2,6 @@
 
 $Tables["articles"]["schema"] = "
   id I(10) UNSIGNED NOTNULL AUTOINCREMENT PRIMARY,
-  category_id I(10) UNSIGNED NOTNULL DEFAULT '0',
   date T(14) NOTNULL,
   modification_date T(14) NOTNULL,
   user_id I(10) UNSIGNED NOTNULL DEFAULT '0',
@@ -71,6 +70,8 @@
   INDEX article_id (article_id),
   INDEX blog_id (blog_id),
   INDEX article_id_blog_id(article_id,blog_id),
+  INDEX article_id_status_type(article_id,status,type),  
+  INDEX blog_id_type(blog_id,type),
   FULLTEXT normalized_fields (normalized_text,normalized_topic),
   FULLTEXT normalized_text (normalized_text),
   FULLTEXT normalized_topic (normalized_topic)
@@ -209,7 +210,9 @@
    list_type I(1) DEFAULT '1',
    mask I(2) DEFAULT '0',
    host varchar(15) DEFAULT '0.0.0.0',
-   INDEX blog_id (blog_id)
+   INDEX blog_id (blog_id),
+   INDEX block_type (block_type),
+   INDEX blog_id_block_type(blog_id, block_type)
 ";
 $Tables["host_blocking_rules"]["options"] = "TYPE=MyISAM";