1 files changed, 10 insertions, 15 deletions

diff --git a/OpenSim/Data/NHibernate/Resources/MySQLDialect/001_AssetStore.sql b/OpenSim/Data/NHibernate/Resources/MySQLDialect/001_AssetStore.sql
index 3484b64..9573781 100644
--- a/OpenSim/Data/NHibernate/Resources/MySQLDialect/001_AssetStore.sql
+++ b/OpenSim/Data/NHibernate/Resources/MySQLDialect/001_AssetStore.sql
@@ -1,15 +1,10 @@
-START TRANSACTION;
-
-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
+CREATE TABLE Assets (
+  ID VARCHAR(36) NOT NULL,
+  Type TINYINT DEFAULT NULL,
+  Name VARCHAR(64) DEFAULT NULL,
+  Description VARCHAR(64) DEFAULT NULL,
+  Local BIT DEFAULT NULL,
+  Temporary BIT DEFAULT NULL,
+  Data LONGBLOB,
+  PRIMARY KEY (ID)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Rev. 1';