From be79b56cc314311fbc689db78c8aa2947b85e754 Mon Sep 17 00:00:00 2001
From: Sean Dague
Date: Mon, 16 Jun 2008 19:58:48 +0000
Subject: I really didn't expect that one to work out of the box, but just
 managed to get NHibernate + MySQL + Assets working.

---
 .../NHibernate/Resources/MySQLDialect/001_AssetStore.sql   | 14 ++++++++++++++
 1 file changed, 14 insertions(+)
 create mode 100644 OpenSim/Data/NHibernate/Resources/MySQLDialect/001_AssetStore.sql

(limited to 'OpenSim/Data/NHibernate/Resources/MySQLDialect/001_AssetStore.sql')

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 @@
+START TRANSACTION;
+
+create table Assets(
+       ID varchar(36) not null primary key,
+       Type int default 0,
+       InvType int default 0,
+       Name varchar(64),
+       Description varchar(64),
+       Local boolean,
+       Temporary boolean,
+       Data blob
+);
+
+COMMIT;
\ No newline at end of file
-- 
cgit v1.1

