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

[mark at devel.lifetype.net]

Author: mark
Date: 2007-07-02 15:19:57 -0400 (Mon, 02 Jul 2007)
New Revision: 5605

Modified:
   plog/trunk/install/dbschemas.properties.php
Log:
Add two new fields num_messages and num_unread_messages to user table.

Modified: plog/trunk/install/dbschemas.properties.php
===================================================================
--- plog/trunk/install/dbschemas.properties.php	2007-07-02 11:18:00 UTC (rev 5604)
+++ plog/trunk/install/dbschemas.properties.php	2007-07-02 19:19:57 UTC (rev 5605)
@@ -170,6 +170,8 @@
   resource_picture_id I(10) NOTNULL DEFAULT 0,
   site_admin I(10) NOTNULL DEFAULT '0',
   last_login T(14),
+  num_unread_messages I(10) NOTNULL DEFAULT '0',
+  num_messages I(10) NOTNULL DEFAULT '0',
   UNIQUE user (user)
 ";
 $Tables["users"]["options"]["mysql"] = "TYPE=MyISAM";
@@ -425,7 +427,7 @@
 ";
 $Tables["friends"]["options"]["mysql"] = "TYPE=MyISAM";
 
-$Tables["messages"]["schema"] = "
+$Tables["private_messages"]["schema"] = "
   id I(10) NOTNULL PRIMARY AUTOINCREMENT,
   sender_id I(10) NOTNULL,
   receiver_id I(10) NOTNULL,
@@ -442,5 +444,5 @@
   FULLTEXT normalized_subject (normalized_subject),
   FULLTEXT normalized_fields (normalized_message, normalized_subject)
 ";
-$Tables["messages"]["options"]["mysql"] = "TYPE=MyISAM";
+$Tables["private_messages"]["options"]["mysql"] = "TYPE=MyISAM";
 ?>
\ No newline at end of file