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

Mark Wu markplace at gmail.com
Thu May 24 02:53:36 EDT 2007


Yes, I am integrated the code now ... :)


2007/5/24, Oscar Renalias <oscar at renalias.net>:
>
> 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
> >
> _______________________________________________
> pLog-svn mailing list
> pLog-svn at devel.lifetype.net
> http://limedaley.com/mailman/listinfo/plog-svn
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://limedaley.com/pipermail/plog-svn/attachments/20070524/09e856e9/attachment.htm 


More information about the pLog-svn mailing list