CreateAvatarAppearance.sql 1.2 KB

123456789101112131415161718192021222324252627282930313233343536373839404142
  1. --
  2. -- Create schema avatar_appearance
  3. --
  4. DROP TABLE IF EXISTS `avatarappearance`;
  5. CREATE TABLE `avatarappearance` (
  6. Owner char(36) NOT NULL,
  7. Serial int(10) unsigned NOT NULL,
  8. Visual_Params blob NOT NULL,
  9. Texture blob NOT NULL,
  10. Avatar_Height float NOT NULL,
  11. Body_Item char(36) NOT NULL,
  12. Body_Asset char(36) NOT NULL,
  13. Skin_Item char(36) NOT NULL,
  14. Skin_Asset char(36) NOT NULL,
  15. Hair_Item char(36) NOT NULL,
  16. Hair_Asset char(36) NOT NULL,
  17. Eyes_Item char(36) NOT NULL,
  18. Eyes_Asset char(36) NOT NULL,
  19. Shirt_Item char(36) NOT NULL,
  20. Shirt_Asset char(36) NOT NULL,
  21. Pants_Item char(36) NOT NULL,
  22. Pants_Asset char(36) NOT NULL,
  23. Shoes_Item char(36) NOT NULL,
  24. Shoes_Asset char(36) NOT NULL,
  25. Socks_Item char(36) NOT NULL,
  26. Socks_Asset char(36) NOT NULL,
  27. Jacket_Item char(36) NOT NULL,
  28. Jacket_Asset char(36) NOT NULL,
  29. Gloves_Item char(36) NOT NULL,
  30. Gloves_Asset char(36) NOT NULL,
  31. Undershirt_Item char(36) NOT NULL,
  32. Undershirt_Asset char(36) NOT NULL,
  33. Underpants_Item char(36) NOT NULL,
  34. Underpants_Asset char(36) NOT NULL,
  35. Skirt_Item char(36) NOT NULL,
  36. Skirt_Asset char(36) NOT NULL,
  37. PRIMARY KEY (`Owner`)
  38. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Rev.2';