1 files changed, 11 insertions, 10 deletions

diff --git a/OpenSim/Data/NHibernate/Resources/MySQLDialect/001_AssetStore.sql b/OpenSim/Data/NHibernate/Resources/MySQLDialect/001_AssetStore.sql
index 6e0b61a..3484b64 100644
--- a/OpenSim/Data/NHibernate/Resources/MySQLDialect/001_AssetStore.sql
+++ b/OpenSim/Data/NHibernate/Resources/MySQLDialect/001_AssetStore.sql
@@ -1,14 +1,15 @@
 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
-);
+CREATE TABLE `Assets` (
+  `ID` char(36) NOT NULL,
+  `Type` smallint(6) default NULL,
+  `InvType` smallint(6) default NULL,
+  `Name` varchar(64) default NULL,
+  `Description` varchar(64) default NULL,
+  `Local` tinyint(1) default NULL,
+  `Temporary` tinyint(1) default NULL,
+  `Data` longblob,
+  PRIMARY KEY  (`ID`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 
 COMMIT;
\ No newline at end of file