diff options
-rw-r--r-- | OpenSim/Framework/Data.MySQL/Resources/AvatarAppearance.sql (renamed from share/sql/mysql-AvatarAppearance.sql) | 84 |
1 files changed, 42 insertions, 42 deletions
diff --git a/share/sql/mysql-AvatarAppearance.sql b/OpenSim/Framework/Data.MySQL/Resources/AvatarAppearance.sql index b638ee2..d9d3de0 100644 --- a/share/sql/mysql-AvatarAppearance.sql +++ b/OpenSim/Framework/Data.MySQL/Resources/AvatarAppearance.sql | |||
@@ -1,42 +1,42 @@ | |||
1 | -- | 1 | -- |
2 | -- Create schema avatar_appearance | 2 | -- Create schema avatar_appearance |
3 | -- | 3 | -- |
4 | 4 | ||
5 | CREATE DATABASE IF NOT EXISTS avatar_appearance; | 5 | CREATE DATABASE IF NOT EXISTS avatar_appearance; |
6 | USE avatar_appearance; | 6 | USE avatar_appearance; |
7 | 7 | ||
8 | DROP TABLE IF EXISTS `avatarappearance`; | 8 | DROP TABLE IF EXISTS `avatarappearance`; |
9 | CREATE TABLE `avatarappearance` ( | 9 | CREATE TABLE `avatarappearance` ( |
10 | `UUID` char(36) NOT NULL, | 10 | `UUID` char(36) NOT NULL, |
11 | `Serial` int(10) unsigned NOT NULL, | 11 | `Serial` int(10) unsigned NOT NULL, |
12 | `WearableItem0` char(36) NOT NULL, | 12 | `WearableItem0` char(36) NOT NULL, |
13 | `WearableAsset0` char(36) NOT NULL, | 13 | `WearableAsset0` char(36) NOT NULL, |
14 | `WearableItem1` char(36) NOT NULL, | 14 | `WearableItem1` char(36) NOT NULL, |
15 | `WearableAsset1` char(36) NOT NULL, | 15 | `WearableAsset1` char(36) NOT NULL, |
16 | `WearableItem2` char(36) NOT NULL, | 16 | `WearableItem2` char(36) NOT NULL, |
17 | `WearableAsset2` char(36) NOT NULL, | 17 | `WearableAsset2` char(36) NOT NULL, |
18 | `WearableItem3` char(36) NOT NULL, | 18 | `WearableItem3` char(36) NOT NULL, |
19 | `WearableAsset3` char(36) NOT NULL, | 19 | `WearableAsset3` char(36) NOT NULL, |
20 | `WearableItem4` char(36) NOT NULL, | 20 | `WearableItem4` char(36) NOT NULL, |
21 | `WearableAsset4` char(36) NOT NULL, | 21 | `WearableAsset4` char(36) NOT NULL, |
22 | `WearableItem5` char(36) NOT NULL, | 22 | `WearableItem5` char(36) NOT NULL, |
23 | `WearableAsset5` char(36) NOT NULL, | 23 | `WearableAsset5` char(36) NOT NULL, |
24 | `WearableItem6` char(36) NOT NULL, | 24 | `WearableItem6` char(36) NOT NULL, |
25 | `WearableAsset6` char(36) NOT NULL, | 25 | `WearableAsset6` char(36) NOT NULL, |
26 | `WearableItem7` char(36) NOT NULL, | 26 | `WearableItem7` char(36) NOT NULL, |
27 | `WearableAsset7` char(36) NOT NULL, | 27 | `WearableAsset7` char(36) NOT NULL, |
28 | `WearableItem8` char(36) NOT NULL, | 28 | `WearableItem8` char(36) NOT NULL, |
29 | `WearableAsset8` char(36) NOT NULL, | 29 | `WearableAsset8` char(36) NOT NULL, |
30 | `WearableItem9` char(36) NOT NULL, | 30 | `WearableItem9` char(36) NOT NULL, |
31 | `WearableAsset9` char(36) NOT NULL, | 31 | `WearableAsset9` char(36) NOT NULL, |
32 | `WearableItem10` char(36) NOT NULL, | 32 | `WearableItem10` char(36) NOT NULL, |
33 | `WearableAsset10` char(36) NOT NULL, | 33 | `WearableAsset10` char(36) NOT NULL, |
34 | `WearableItem11` char(36) NOT NULL, | 34 | `WearableItem11` char(36) NOT NULL, |
35 | `WearableAsset11` char(36) NOT NULL, | 35 | `WearableAsset11` char(36) NOT NULL, |
36 | `WearableItem12` char(36) NOT NULL, | 36 | `WearableItem12` char(36) NOT NULL, |
37 | `WearableAsset12` char(36) NOT NULL, | 37 | `WearableAsset12` char(36) NOT NULL, |
38 | 38 | ||
39 | 39 | ||
40 | PRIMARY KEY (`UUID`) | 40 | PRIMARY KEY (`UUID`) |
41 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; | 41 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
42 | 42 | ||