aboutsummaryrefslogtreecommitdiffstatshomepage
diff options
context:
space:
mode:
authorSean Dague2008-06-16 19:58:48 +0000
committerSean Dague2008-06-16 19:58:48 +0000
commitbe79b56cc314311fbc689db78c8aa2947b85e754 (patch)
treea86c992182fd2daa1884645affd32d44cb289a0a
parentset CommandTimeout = 0 in the migration commands so that long (diff)
downloadopensim-SC_OLD-be79b56cc314311fbc689db78c8aa2947b85e754.zip
opensim-SC_OLD-be79b56cc314311fbc689db78c8aa2947b85e754.tar.gz
opensim-SC_OLD-be79b56cc314311fbc689db78c8aa2947b85e754.tar.bz2
opensim-SC_OLD-be79b56cc314311fbc689db78c8aa2947b85e754.tar.xz
I really didn't expect that one to work out of the box, but just managed
to get NHibernate + MySQL + Assets working.
-rw-r--r--OpenSim/Data/NHibernate/Resources/MySQLDialect/001_AssetStore.sql14
1 files changed, 14 insertions, 0 deletions
diff --git a/OpenSim/Data/NHibernate/Resources/MySQLDialect/001_AssetStore.sql b/OpenSim/Data/NHibernate/Resources/MySQLDialect/001_AssetStore.sql
new file mode 100644
index 0000000..6e0b61a
--- /dev/null
+++ b/OpenSim/Data/NHibernate/Resources/MySQLDialect/001_AssetStore.sql
@@ -0,0 +1,14 @@
1START TRANSACTION;
2
3create table Assets(
4 ID varchar(36) not null primary key,
5 Type int default 0,
6 InvType int default 0,
7 Name varchar(64),
8 Description varchar(64),
9 Local boolean,
10 Temporary boolean,
11 Data blob
12);
13
14COMMIT; \ No newline at end of file