From f6aeff6cc3f6ebc58db702206d469718d19b7ba0 Mon Sep 17 00:00:00 2001
From: Tleiades Hax
Date: Sat, 13 Oct 2007 09:21:08 +0000
Subject: Added capbility to use MySQL as the database backend in stand alone
 mode for assets and inventory.

Added asset_plugin key to "StandAlone" section of OpenSim.ini

---
 OpenSim/Framework/Data.MySQL/Resources/CreateAssetsTable.sql | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

(limited to 'OpenSim/Framework/Data.MySQL/Resources')

diff --git a/OpenSim/Framework/Data.MySQL/Resources/CreateAssetsTable.sql b/OpenSim/Framework/Data.MySQL/Resources/CreateAssetsTable.sql
index 3b6fff2..049a3a2 100644
--- a/OpenSim/Framework/Data.MySQL/Resources/CreateAssetsTable.sql
+++ b/OpenSim/Framework/Data.MySQL/Resources/CreateAssetsTable.sql
@@ -2,8 +2,8 @@ CREATE TABLE `assets` (
   `id` binary(16) NOT NULL,
   `name` varchar(64) NOT NULL,
   `description` varchar(64) NOT NULL,
-  `assetType` TINYINT(4) NOT NULL,
-  `invType` TINYINT(4) NOT NULL,
+  `assetType` smallint(5) unsigned NOT NULL,
+  `invType` smallint(5) unsigned NOT NULL,
   `local` tinyint(1) NOT NULL,
   `temporary` tinyint(1) NOT NULL,
   `data` longblob NOT NULL,
-- 
cgit v1.1