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

[jondaley at devel.lifetype.net]

Author: jondaley
Date: 2006-05-03 23:50:40 +0000 (Wed, 03 May 2006)
New Revision: 3328

Modified:
   plog/trunk/install/dbschemas.properties.php
Log:
implemented Christoph's changes (april 13th email)

Modified: plog/trunk/install/dbschemas.properties.php
===================================================================
--- plog/trunk/install/dbschemas.properties.php	2006-05-03 22:17:33 UTC (rev 3327)
+++ plog/trunk/install/dbschemas.properties.php	2006-05-03 23:50:40 UTC (rev 3328)
@@ -17,10 +17,9 @@
   global_category_id I(10) NOTNULL DEFAULT '0',
   in_summary_page I1(1) NOTNULL DEFAULT '1',
   INDEX num_reads (num_reads),
-  INDEX blog_id (blog_id),
   INDEX user_id (user_id),
   INDEX slug (slug),
-  INDEX blog_id_slug (blog_id,slug),
+  INDEX blog_id_status_date (blog_id, status, date),
   INDEX global_category_status (global_category_id, status)  
 ";
 $Tables["articles"]["options"] = "TYPE=MyISAM";
@@ -65,10 +64,8 @@
   normalized_topic TEXT NOTNULL DEFAULT '',
   type I(3) NOTNULL DEFAULT '1',  
   INDEX parent_id (parent_id),
-  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 article_id_type(article_id,type),  
   INDEX blog_id_type(blog_id,type),
   FULLTEXT normalized_fields (normalized_text,normalized_topic),
   FULLTEXT normalized_text (normalized_text),
@@ -151,7 +148,6 @@
   hits I(10) DEFAULT '1',
   last_date T(14),
   INDEX article_id (article_id),
-  INDEX blog_id (blog_id),
   INDEX blog_id_article_id (blog_id, article_id)
 ";
 $Tables["referers"]["options"] = "TYPE=MyISAM";
@@ -176,7 +172,6 @@
   user_id I(10) UNSIGNED NOTNULL DEFAULT '0',
   blog_id I(10) UNSIGNED NOTNULL DEFAULT '0',
   permission_id I(10) UNSIGNED NOTNULL DEFAULT '0',
-  INDEX user_id (user_id),
   INDEX blog_id (blog_id),
   INDEX user_id_permission_id (user_id,permission_id)
 ";
@@ -229,7 +224,6 @@
    thumbnail_format varchar(4) NOTNULL DEFAULT 'same',
    normalized_description TEXT NOTNULL DEFAULT '',
    properties TEXT NOTNULL DEFAULT '',
-   INDEX album_id (album_id),
    INDEX owner_id (owner_id),
    INDEX file_name (file_name),
    INDEX album_id_owner_id (album_id, owner_id),
@@ -254,7 +248,6 @@
    num_resources I(10) NOTNULL DEFAULT '0',
    num_children I(10) NOTNULL DEFAULT '0',
    INDEX parent_id (parent_id),
-   INDEX owner_id (owner_id),
    INDEX mangled_name (mangled_name),
    INDEX owner_id_mangled_name (owner_id, mangled_name),
    FULLTEXT normalized_name (normalized_name),