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

[mark at devel.lifetype.net]

Author: mark
Date: 2007-07-02 06:05:19 -0400 (Mon, 02 Jul 2007)
New Revision: 5603

Modified:
   plog/trunk/install/dbschemas.properties.php
Log:
Commit the private message table schema. 

Modified: plog/trunk/install/dbschemas.properties.php
===================================================================
--- plog/trunk/install/dbschemas.properties.php	2007-07-02 08:45:51 UTC (rev 5602)
+++ plog/trunk/install/dbschemas.properties.php	2007-07-02 10:05:19 UTC (rev 5603)
@@ -424,4 +424,23 @@
   INDEX user_id_group_id (user_id,group_id)
 ";
 $Tables["friends"]["options"]["mysql"] = "TYPE=MyISAM";
+
+$Tables["messages"]["schema"] = "
+  id I(10) NOTNULL PRIMARY AUTOINCREMENT,
+  sender_id I(10) NOTNULL,
+  receiver_id I(10) NOTNULL,
+  subject TEXT NOTNULL,
+  message TEXT NOTNULL,
+  normalized_subject TEXT NOTNULL DEFAULT '',
+  normalized_message TEXT NOTNULL DEFAULT '',
+  already_read I(1) NOTNULL DEFAULT 0,
+  date DATETIME NOTNULL,
+  status I(1) NOTNULL DEFAULT 1,
+  INDEX sender_id (sender_id),
+  INDEX receiver_id (receiver_id),
+  FULLTEXT normalized_message (normalized_message),
+  FULLTEXT normalized_subject (normalized_subject),
+  FULLTEXT normalized_fields (normalized_message, normalized_subject)
+";
+$Tables["messages"]["options"]["mysql"] = "TYPE=MyISAM";
 ?>
\ No newline at end of file