diff options
| author | MW | 2008-02-04 12:04:02 +0000 |
|---|---|---|
| committer | MW | 2008-02-04 12:04:02 +0000 |
| commit | 755ad9e3e0447b60299b08a18624064d1d64141b (patch) | |
| tree | 89859180b5ba7ef47defbf6a1d6640177ecb1326 /share | |
| parent | * Whole buncha stuff. (diff) | |
| download | opensim-SC_OLD-755ad9e3e0447b60299b08a18624064d1d64141b.zip opensim-SC_OLD-755ad9e3e0447b60299b08a18624064d1d64141b.tar.gz opensim-SC_OLD-755ad9e3e0447b60299b08a18624064d1d64141b.tar.bz2 opensim-SC_OLD-755ad9e3e0447b60299b08a18624064d1d64141b.tar.xz | |
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.
Diffstat (limited to 'share')
| -rw-r--r-- | share/sql/mysql-AvatarAppearance.sql | 42 |
1 files changed, 42 insertions, 0 deletions
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 @@ | |||
| 1 | -- | ||
| 2 | -- Create schema avatar_appearance | ||
| 3 | -- | ||
| 4 | |||
| 5 | CREATE DATABASE IF NOT EXISTS avatar_appearance; | ||
| 6 | USE avatar_appearance; | ||
| 7 | |||
| 8 | DROP TABLE IF EXISTS `avatarappearance`; | ||
| 9 | CREATE TABLE `avatarappearance` ( | ||
| 10 | `UUID` char(36) NOT NULL, | ||
| 11 | `Serial` int(10) unsigned NOT NULL, | ||
| 12 | `WearableItem0` char(36) NOT NULL, | ||
| 13 | `WearableAsset0` char(36) NOT NULL, | ||
| 14 | `WearableItem1` char(36) NOT NULL, | ||
| 15 | `WearableAsset1` char(36) NOT NULL, | ||
| 16 | `WearableItem2` char(36) NOT NULL, | ||
| 17 | `WearableAsset2` char(36) NOT NULL, | ||
| 18 | `WearableItem3` char(36) NOT NULL, | ||
| 19 | `WearableAsset3` char(36) NOT NULL, | ||
| 20 | `WearableItem4` char(36) NOT NULL, | ||
| 21 | `WearableAsset4` char(36) NOT NULL, | ||
| 22 | `WearableItem5` char(36) NOT NULL, | ||
| 23 | `WearableAsset5` char(36) NOT NULL, | ||
| 24 | `WearableItem6` char(36) NOT NULL, | ||
| 25 | `WearableAsset6` char(36) NOT NULL, | ||
| 26 | `WearableItem7` char(36) NOT NULL, | ||
| 27 | `WearableAsset7` char(36) NOT NULL, | ||
| 28 | `WearableItem8` char(36) NOT NULL, | ||
| 29 | `WearableAsset8` char(36) NOT NULL, | ||
| 30 | `WearableItem9` char(36) NOT NULL, | ||
| 31 | `WearableAsset9` char(36) NOT NULL, | ||
| 32 | `WearableItem10` char(36) NOT NULL, | ||
| 33 | `WearableAsset10` char(36) NOT NULL, | ||
| 34 | `WearableItem11` char(36) NOT NULL, | ||
| 35 | `WearableAsset11` char(36) NOT NULL, | ||
| 36 | `WearableItem12` char(36) NOT NULL, | ||
| 37 | `WearableAsset12` char(36) NOT NULL, | ||
| 38 | |||
| 39 | |||
| 40 | PRIMARY KEY (`UUID`) | ||
| 41 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; | ||
| 42 | |||