One more thing about UUID's data type in Database,<br>MySQL:<br>UUID is "Binary(16)" in assets table, and "varchar(36)" in other tables.<br>MSSQL:<br>All UUIDs are "varchar(36)".<br><br>* I have been a long time confused with hyphenated, non-hyphenated UUIDs,<br>
now is much better, but still, I have some suggestions about UUID:<br><br>1. at least the data type of UUID in different tables should be unified. (MySQL)<br>2. binary(16) is more suitable than varchar(n)<br>3. varchar(32) is better than varchar(36)<br>
<br><br><div><span class="gmail_quote">2008/4/10, Kyle Hamilton <<a href="mailto:aerowolf@gmail.com">aerowolf@gmail.com</a>>:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Why not derive OSUUID from LLUUID, with the additional attribute<br> [serializable], provide an implicit conversion operator that provides<br> LLUUID, and provides a constructor from LLUUID? Is LLUUID sealed or<br> something?<br>
<br> (even if it is, at least should be able to provide an implicit<br> conversion and constructor to reduce the impact of LLUUID on the<br> codebase here.)<br> <br> -Kyle H<br> <br><br> <br> On Wed, Apr 9, 2008 at 11:14 AM, Sean Dague <<a href="mailto:sean@dague.net">sean@dague.net</a>> wrote:<br>
> One of the things that I ran into today is how many places LLUUID ends<br> > up in our code base from libsecondlife. While not always a problem it<br> > does lead to some oddness.<br> ><br> > * libsecondlife is a required link for lots of classes that just need a<br>
> UUID<br> > * LLUUID is not serializable, which causes us some pain<br> > * LLUUID has changed a couple of times in the past, causing us grief<br> ><br> > It seems like it would be a good idea to replace LLUUID as much as<br>
> possible with our own OSUUID (I put a sample in<br> > OpenSim/Framework/OSUUID.cs). It would look very similar to LLUUID<br> > (which is basically just a wrapper on System.Guid), but be<br> > [Serializable]. It would also mean that we could drop a lot of<br>
> libsecondlife references. I think that would be required for Stefan's<br> > OpenSim.Model idea.<br> ><br> > Thoughts?<br> ><br> > This will be a lot of work if we decide to do it, and a couple of days<br>
> of brutal instability to do a swap out like this, as we can't get rid of<br> > LLUUID entirely (we need it when we get to packet generation I think).<br> ><br> > Discussion on this one would be appreciated. Definitely wouldn't want<br>
> to make any changes like this without full agreement from everyone.<br> ><br> > -Sean<br> ><br> > --<br> > __________________________________________________________________<br> ><br> > Sean Dague Mid-Hudson Valley<br>
> sean at dague dot net Linux Users Group<br> > <a href="http://dague.net">http://dague.net</a> <a href="http://mhvlug.org">http://mhvlug.org</a><br> ><br>
> There is no silver bullet. Plus, werewolves make better neighbors<br> > than zombies, and they tend to keep the vampire population down.<br> > __________________________________________________________________<br>
><br> <br>> -----BEGIN PGP SIGNATURE-----<br> > Version: GnuPG v1.4.6 (GNU/Linux)<br> ><br> > iD8DBQFH/QeiSamXem9TdyYRAs+VAJ9Vds9RzmfxTiy2/swosyCwjY4rWACeLEMq<br> > MKoDpHQOEc+oJYGMU2arhQ4=<br> > =KysI<br>
> -----END PGP SIGNATURE-----<br> <br>><br> > _______________________________________________<br> > Opensim-dev mailing list<br> > <a href="mailto:Opensim-dev@lists.berlios.de">Opensim-dev@lists.berlios.de</a><br>
> <a href="https://lists.berlios.de/mailman/listinfo/opensim-dev">https://lists.berlios.de/mailman/listinfo/opensim-dev</a><br> ><br> ><br> _______________________________________________<br> Opensim-dev mailing list<br>
<a href="mailto:Opensim-dev@lists.berlios.de">Opensim-dev@lists.berlios.de</a><br> <a href="https://lists.berlios.de/mailman/listinfo/opensim-dev">https://lists.berlios.de/mailman/listinfo/opensim-dev</a><br> </blockquote>
</div><br><br clear="all"><br>-- <br>Liu Xiaolu