aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Framework/Data.MySQL/Resources
diff options
context:
space:
mode:
authorTedd Hansen2008-02-11 18:24:00 +0000
committerTedd Hansen2008-02-11 18:24:00 +0000
commit7156d7ae51e3edde1c25ab9c99771560c9ac149f (patch)
tree42f533dc63a55162a48d4d99d7442b1b8afe1ff7 /OpenSim/Framework/Data.MySQL/Resources
parent* Renamed and moved avatar appearance config keys. Everyone who has appearanc... (diff)
downloadopensim-SC_OLD-7156d7ae51e3edde1c25ab9c99771560c9ac149f.zip
opensim-SC_OLD-7156d7ae51e3edde1c25ab9c99771560c9ac149f.tar.gz
opensim-SC_OLD-7156d7ae51e3edde1c25ab9c99771560c9ac149f.tar.bz2
opensim-SC_OLD-7156d7ae51e3edde1c25ab9c99771560c9ac149f.tar.xz
Moved share/sql/mysql-AvatarAppearance.sql to OpenSim/Framework/Data.MySQL/Resources/AvatarAppearance.sql as described in share/sql/mysql_README.txt
Thanks dmiles_afk
Diffstat (limited to 'OpenSim/Framework/Data.MySQL/Resources')
-rw-r--r--OpenSim/Framework/Data.MySQL/Resources/AvatarAppearance.sql42
1 files changed, 42 insertions, 0 deletions
diff --git a/OpenSim/Framework/Data.MySQL/Resources/AvatarAppearance.sql b/OpenSim/Framework/Data.MySQL/Resources/AvatarAppearance.sql
new file mode 100644
index 0000000..d9d3de0
--- /dev/null
+++ b/OpenSim/Framework/Data.MySQL/Resources/AvatarAppearance.sql
@@ -0,0 +1,42 @@
1--
2-- Create schema avatar_appearance
3--
4
5CREATE DATABASE IF NOT EXISTS avatar_appearance;
6USE avatar_appearance;
7
8DROP TABLE IF EXISTS `avatarappearance`;
9CREATE 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