From 755ad9e3e0447b60299b08a18624064d1d64141b Mon Sep 17 00:00:00 2001
From: MW
Date: Mon, 4 Feb 2008 12:04:02 +0000
Subject: First part of avatar persistence, currently only really works in
 standalone mode (with accounts_authenticate set to true), it also only
 currently has a mysql database connector. (sqlite one will follow soon). It
 also uses the tribalmedia database system, so this needs checking to see if
 the old problems with mono have been fixed. To use, see the appearance
 section in opensim.ini.example, set "persist = true", then add the correct
 connection string for your database.(see mysql-AvatarAppearance.sql in share
 folder for a example of the table mysql table structure). This could possible
 be used in a very small grid, but would mean each region server would need to
 connect to the same mysql database. But the work to move the code to one of
 the grid servers shouldn't be too much.

---
 share/sql/mysql-AvatarAppearance.sql | 42 ++++++++++++++++++++++++++++++++++++
 1 file changed, 42 insertions(+)
 create mode 100644 share/sql/mysql-AvatarAppearance.sql

(limited to 'share/sql/mysql-AvatarAppearance.sql')

diff --git a/share/sql/mysql-AvatarAppearance.sql b/share/sql/mysql-AvatarAppearance.sql
new file mode 100644
index 0000000..d9d3de0
--- /dev/null
+++ b/share/sql/mysql-AvatarAppearance.sql
@@ -0,0 +1,42 @@
+--
+-- Create schema avatar_appearance
+--
+
+CREATE DATABASE IF NOT EXISTS avatar_appearance;
+USE avatar_appearance;
+
+DROP TABLE IF EXISTS `avatarappearance`;
+CREATE TABLE `avatarappearance` (
+  `UUID` char(36) NOT NULL,
+  `Serial` int(10) unsigned NOT NULL,
+  `WearableItem0` char(36) NOT NULL,
+  `WearableAsset0` char(36) NOT NULL,
+  `WearableItem1` char(36) NOT NULL,
+  `WearableAsset1` char(36) NOT NULL,
+  `WearableItem2` char(36) NOT NULL,
+  `WearableAsset2` char(36) NOT NULL,
+  `WearableItem3` char(36) NOT NULL,
+  `WearableAsset3` char(36) NOT NULL,
+  `WearableItem4` char(36) NOT NULL,
+  `WearableAsset4` char(36) NOT NULL,
+  `WearableItem5` char(36) NOT NULL,
+  `WearableAsset5` char(36) NOT NULL,
+  `WearableItem6` char(36) NOT NULL,
+  `WearableAsset6` char(36) NOT NULL,
+  `WearableItem7` char(36) NOT NULL,
+  `WearableAsset7` char(36) NOT NULL,
+  `WearableItem8` char(36) NOT NULL,
+  `WearableAsset8` char(36) NOT NULL,
+  `WearableItem9` char(36) NOT NULL,
+  `WearableAsset9` char(36) NOT NULL,
+  `WearableItem10` char(36) NOT NULL,
+  `WearableAsset10` char(36) NOT NULL,
+  `WearableItem11` char(36) NOT NULL,
+  `WearableAsset11` char(36) NOT NULL,
+  `WearableItem12` char(36) NOT NULL,
+  `WearableAsset12` char(36) NOT NULL,
+
+
+  PRIMARY KEY  (`UUID`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
-- 
cgit v1.1

