[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