In opensim "in general" I don't know.<br>In the case of this example... it's just an example, you can change what you need, the DB configuration is "transparent" for nhibernate.<br><br><br><div>
<span class="gmail_quote">2008/2/7, 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;">
<div bgcolor="#FFFFFF"><div>Just out of curiosity... Is there a specific reason we're not using utf8 unicode encoding for the tables? Is there something that will break if utf8 is used?</div><div><br></div><div>-Kyle H<br>
<br>Sent from my iPhone</div><div><span class="e" id="q_117f35366c36ecf4_1"><div><br>On Feb 7, 2008, at 1:40, Impalah <<a href="mailto:impalah@gmail.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">impalah@gmail.com</a>> wrote:<br>
<br></div><div></div><blockquote type="cite"><div>Sorry I made a mistake in the sql file.<br><br>The good one is copied below.<br><br>I'm working now on the "persistence" layer, creating the basic utilities (i.e. factories) and testing selects, updates and deletes.<br>
<br>I hope in 2 or 3 days to have something "insertable" into the actual opensim.<br><br><br><br>CREATE DATABASE `opensimtest` /*!40100 DEFAULT CHARACTER SET latin1 */;<br><br>DROP TABLE IF EXISTS `opensimtest`.`osprimitive_type`;<br>
CREATE TABLE `opensimtest`.`osprimitive_type` (<br> `id` int(10) unsigned NOT NULL auto_increment,<br> `name` varchar(45) NOT NULL,<br> `params` varchar(45) NOT NULL,<br> PRIMARY KEY (`id`)<br>) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;<br>
<br><br>DROP TABLE IF EXISTS `opensimtest`.`ostexture`;<br>CREATE TABLE `opensimtest`.`ostexture` (<br> `id` int(10) unsigned NOT NULL auto_increment,<br> `uuid` varchar(45) NOT NULL,<br> `name` varchar(45) NOT NULL,<br>
`path` varchar(45) NOT NULL,<br> `data` blob NOT NULL,<br> PRIMARY KEY (`id`)<br>) ENGINE=InnoDB DEFAULT CHARSET=latin1;<br><br>DROP TABLE IF EXISTS `opensimtest`.`osuser`;<br>CREATE TABLE `opensimtest`.`osuser` (<br>
`id` int(10) unsigned NOT NULL auto_increment,<br> `uuid` varchar(45) NOT NULL,<br> `name` varchar(45) NOT NULL,<br> `surname` varchar(45) NOT NULL,<br> `last_position` varchar(45) NOT NULL,<br> PRIMARY KEY (`id`)<br>
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;<br><br><br><br>DROP TABLE IF EXISTS `opensimtest`.`osfaces`;<br>CREATE TABLE `opensimtest`.`osfaces` (<br> `id` int(10) unsigned NOT NULL auto_increment,<br> `face` varchar(45) NOT NULL,<br>
`id_texture` int(10) unsigned zerofill NOT NULL default '0000000000',<br> `params` varchar(45) NOT NULL,<br> PRIMARY KEY (`id`),<br> KEY `FK_ostexture_faces_texture` (`id_texture`),<br> CONSTRAINT `FK_ostexture_faces_texture` FOREIGN KEY (`id_texture`) REFERENCES `ostexture` (`id`)<br>
) ENGINE=InnoDB DEFAULT CHARSET=latin1;<br><br>DROP TABLE IF EXISTS `opensimtest`.`osprimitive`;<br>CREATE TABLE `opensimtest`.`osprimitive` (<br> `id` int(10) unsigned NOT NULL auto_increment,<br> `name` varchar(45) default NULL,<br>
`description` varchar(45) default NULL,<br> `uuid` varchar(45) NOT NULL,<br> `id_primitive_type` int(10) unsigned NOT NULL,<br> `id_creator` int(10) unsigned NOT NULL,<br> `id_owner` int(10) unsigned NOT NULL,<br> PRIMARY KEY (`id`),<br>
KEY `FK_osprimitive_type` (`id_primitive_type`),<br> KEY `FK_osprimitive_creator` (`id_creator`),<br> KEY `FK_osprimitive_owner` (`id_owner`),<br> CONSTRAINT `FK_osprimitive_type` FOREIGN KEY (`id_primitive_type`) REFERENCES `osprimitive_type` (`id`),<br>
CONSTRAINT `FK_osprimitive_creator` FOREIGN KEY (`id_creator`) REFERENCES `osuser` (`id`),<br> CONSTRAINT `FK_osprimitive_owner` FOREIGN KEY (`id_owner`) REFERENCES `osuser` (`id`)<br>) ENGINE=InnoDB DEFAULT CHARSET=latin1;<br>
<br><br><br><br><br><div><span class="gmail_quote">2008/2/7, Sean Dague <<a href="mailto:sean@dague.net" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"></a><a href="mailto:sean@dague.net" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">sean@dague.net</a>>:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
On Wed, Feb 06, 2008 at 11:06:14PM +0100, Impalah wrote:<br>> Hi everyone:<br>><br>> I've uploaded a file to my web page with a c# project testing NHibernate:<br>> <a href="http://ai-designstudio.net/index.php?option=com_docman&task=doc_details&gid=40&Itemid=88889037&lang=en" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"></a><a href="http://ai-designstudio.net/index.php?option=com_docman&task=doc_details&gid=40&Itemid=88889037&lang=en" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">http://ai-designstudio.net/index.php?option=com_docman&task=doc_details&gid=40&Itemid=88889037&lang=en</a><br>
><br>> Please, does not expect a miracle right now, it's just only a massive<br>> insertion test for checking if everything runs ok.<br><br>Thanks for all of this work. I just pulled the source and am going to<br>
poke it a bunch tomorrow. More comments as I get up to speed on this.<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" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"></a><a href="http://dague.net" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">http://dague.net</a> <a href="http://mhvlug.org" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"></a><a href="http://mhvlug.org" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">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>-----BEGIN PGP SIGNATURE-----<br>Version: GnuPG v1.4.6 (GNU/Linux)<br><br>iD8DBQFHqnZgSamXem9TdyYRApuZAJ9dzX9sZn5CYb5GYu4xQkTRI6XWLACfTHxf<br>
wditTaO4gROrub+bL0rPI2w=<br>=fqU2<br>-----END PGP SIGNATURE-----<br><br>_______________________________________________<br>Opensim-dev mailing list<br><a href="mailto:Opensim-dev@lists.berlios.de" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"></a><a href="mailto:Opensim-dev@lists.berlios.de" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">Opensim-dev@lists.berlios.de</a><br>
<a href="https://lists.berlios.de/mailman/listinfo/opensim-dev" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"></a><a href="https://lists.berlios.de/mailman/listinfo/opensim-dev" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">https://lists.berlios.de/mailman/listinfo/opensim-dev</a><br>
<br></blockquote></div><br>
</div></blockquote><blockquote type="cite"><div><span>_______________________________________________</span><br><span>Opensim-dev mailing list</span><br><span><a href="mailto:Opensim-dev@lists.berlios.de" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">Opensim-dev@lists.berlios.de</a></span><br>
<span><a href="https://lists.berlios.de/mailman/listinfo/opensim-dev" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">https://lists.berlios.de/mailman/listinfo/opensim-dev</a></span><br></div></blockquote>
</span></div></div><br>_______________________________________________<br>Opensim-dev mailing list<br><a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:Opensim-dev@lists.berlios.de">Opensim-dev@lists.berlios.de</a><br>
<a onclick="return top.js.OpenExtLink(window,event,this)" href="https://lists.berlios.de/mailman/listinfo/opensim-dev" target="_blank">https://lists.berlios.de/mailman/listinfo/opensim-dev</a><br><br></blockquote></div><br>