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

[jondaley at devel.lifetype.net]

Author: jondaley
Date: 2006-05-03 23:53:17 +0000 (Wed, 03 May 2006)
New Revision: 3329

Modified:
   plog/trunk/install/dbschemas.properties.php
Log:
my own changes, based on Christoph's method of removing indexes that have a duplicate as the first column of a multi-column index

Modified: plog/trunk/install/dbschemas.properties.php
===================================================================
--- plog/trunk/install/dbschemas.properties.php	2006-05-03 23:50:40 UTC (rev 3328)
+++ plog/trunk/install/dbschemas.properties.php	2006-05-03 23:53:17 UTC (rev 3329)
@@ -203,7 +203,6 @@
    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 block_type (block_type),
    INDEX blog_id_block_type(blog_id, block_type)
 ";
@@ -304,7 +303,6 @@
    blog_id I(10) DEFAULT NULL,
    article_id I(10) DEFAULT NULL,
    FULLTEXT normalized_value (normalized_value),
-   INDEX blog_id (blog_id),
    INDEX article_id (article_id),
    INDEX field_id (field_id),
    INDEX blog_id_article_id (blog_id, article_id)