From caa6b8467d9e15b0b9f49c70e45526b846f0d185 Mon Sep 17 00:00:00 2001
From: Sean Dague
Date: Mon, 16 Jun 2008 18:53:55 +0000
Subject: futzing around on the NHibernate side again trying to connect
 migrations into it.

---
 OpenSim/Data/NHibernate/Resources/AssetBase.hbm.xml        |  2 +-
 .../NHibernate/Resources/SQLiteDialect/001_AssetStore.sql  | 14 ++++++++++++++
 2 files changed, 15 insertions(+), 1 deletion(-)
 create mode 100644 OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_AssetStore.sql

(limited to 'OpenSim/Data/NHibernate/Resources')

diff --git a/OpenSim/Data/NHibernate/Resources/AssetBase.hbm.xml b/OpenSim/Data/NHibernate/Resources/AssetBase.hbm.xml
index 3c94d92..12ab981 100644
--- a/OpenSim/Data/NHibernate/Resources/AssetBase.hbm.xml
+++ b/OpenSim/Data/NHibernate/Resources/AssetBase.hbm.xml
@@ -1,7 +1,7 @@
 <?xml version="1.0" encoding="utf-8" ?>
 <hibernate-mapping xmlns="urn:nhibernate-mapping-2.2">
     <class name="OpenSim.Framework.AssetBase, OpenSim.Framework" table="Assets" lazy="false">
-        <id name="FullID" column="UUID" type="OpenSim.Data.NHibernate.LLUUIDUserType, OpenSim.Data.NHibernate"> 
+        <id name="FullID" column="ID" type="OpenSim.Data.NHibernate.LLUUIDUserType, OpenSim.Data.NHibernate"> 
             <generator class="assigned" /> 
         </id> 
         <property name="Type" type="SByte" />
diff --git a/OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_AssetStore.sql b/OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_AssetStore.sql
new file mode 100644
index 0000000..e553cff
--- /dev/null
+++ b/OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_AssetStore.sql
@@ -0,0 +1,14 @@
+BEGIN 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,
+);
+
+END;
\ No newline at end of file
-- 
cgit v1.1