From c00c855cc5decf73d598af5d74a2ef57c547efd3 Mon Sep 17 00:00:00 2001
From: Charles Krinke
Date: Mon, 12 Jan 2009 20:14:39 +0000
Subject: Thank you kindly, Tlaukkan (Tommil) for a patch that: Cleaned up
 schema creation scripts of MySQL to compliant form and created SQLite scripts
 from them. In future it would be optimal if scripts from different databases
 could be generated from MySQL scripts to ensure optimal consistency between
 schemas of different databases. Did not yet review column names. ID columns
 seem to have variety in naming which can be confusing.

---
 .../Resources/MySQLDialect/001_AssetStore.sql      | 25 +++++++++-------------
 1 file changed, 10 insertions(+), 15 deletions(-)

(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
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';
-- 
cgit v1.1