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

[mark at devel.lifetype.net]

Author: mark
Date: 2007-05-23 23:53:18 -0400 (Wed, 23 May 2007)
New Revision: 5440

Modified:
   plog/trunk/install/dbschemas.properties.php
Log:
Add friend list database schema.

Modified: plog/trunk/install/dbschemas.properties.php
===================================================================
--- plog/trunk/install/dbschemas.properties.php	2007-05-24 00:55:01 UTC (rev 5439)
+++ plog/trunk/install/dbschemas.properties.php	2007-05-24 03:53:18 UTC (rev 5440)
@@ -392,4 +392,36 @@
    INDEX blog_id(blog_id)
 ";
 $Tables["locations"]["options"]["mysql"] = "TYPE=MyISAM";
+
+$Tables["friend_groups"]["schema"] = "
+  id I(10) unsigned NOTNULL AUTOINCREMENT PRIMARY,
+  user_id I(10) NOTNULL DEFAULT '0',
+  name C(255) NOTNULL DEFAULT '',
+  mangled_name C(255) NOTNULL DEFAULT '',
+  description C(255) DEFAULT NULL,
+  properties TEXT NOTNULL DEFAULT '',
+  num_friends I(10) NOTNULL DEFAULT '0',
+  num_authorized_friends I(10) NOTNULL DEFAULT '0',
+  num_waiting_friends I(10) NOTNULL DEFAULT '0',
+  num_pending_friends I(10) NOTNULL DEFAULT '0',
+  INDEX mangled_name (mangled_name)
+";
+$Tables["friend_groups"]["options"] = "TYPE=MyISAM";
+
+$Tables["friends"]["schema"] = "
+  id I(10) UNSIGNED NOTNULL AUTOINCREMENT PRIMARY,
+  user_id I(10) UNSIGNED NOTNULL DEFAULT '0',
+  friend_id I(10) UNSIGNED NOTNULL DEFAULT '0',
+  group_id I(10) UNSIGNED NOTNULL DEFAULT '0',
+  description C(255) NOTNULL DEFAULT '',
+  article_subscribed I(10) NOTNULL DEFAULT '0',
+  resource_subscribed I(10) NOTNULL DEFAULT '0',
+  user_authorized I(10) NOTNULL DEFAULT '0',
+  friend_authorized I(10) NOTNULL DEFAULT '0',
+  INDEX user_id (user_id),
+  INDEX friend_id (friend_id),
+  INDEX user_id_friend_id (user_id,friend_id),
+  INDEX user_id_group_id (user_id,group_id)
+";
+$Tables["friends"]["options"] = "TYPE=MyISAM";
 ?>