aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/share/sql/mysql-AvatarAppearance.sql
diff options
context:
space:
mode:
Diffstat (limited to 'share/sql/mysql-AvatarAppearance.sql')
-rw-r--r--share/sql/mysql-AvatarAppearance.sql84
1 files changed, 42 insertions, 42 deletions
diff --git a/share/sql/mysql-AvatarAppearance.sql b/share/sql/mysql-AvatarAppearance.sql
index d9d3de0..b638ee2 100644
--- a/share/sql/mysql-AvatarAppearance.sql
+++ b/share/sql/mysql-AvatarAppearance.sql
@@ -1,42 +1,42 @@
1-- 1--
2-- Create schema avatar_appearance 2-- Create schema avatar_appearance
3-- 3--
4 4
5CREATE DATABASE IF NOT EXISTS avatar_appearance; 5CREATE DATABASE IF NOT EXISTS avatar_appearance;
6USE avatar_appearance; 6USE avatar_appearance;
7 7
8DROP TABLE IF EXISTS `avatarappearance`; 8DROP TABLE IF EXISTS `avatarappearance`;
9CREATE TABLE `avatarappearance` ( 9CREATE 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