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

[Oscar Renalias]

Does this mean that you will integrate the rest of code any time now? :-)

Oscar

On 5/24/07, mark at devel.lifetype.net <mark at devel.lifetype.net> wrote:
> 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";
>  ?>
>
> _______________________________________________
> pLog-svn mailing list
> pLog-svn at devel.lifetype.net
> http://limedaley.com/mailman/listinfo/plog-svn
>