UserProfiles.migrations 2.9 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798
  1. :VERSION 1 # -------------------------------
  2. begin;
  3. CREATE TABLE IF NOT EXISTS `classifieds` (
  4. `classifieduuid` char(36) NOT NULL,
  5. `creatoruuid` char(36) NOT NULL,
  6. `creationdate` int(20) NOT NULL,
  7. `expirationdate` int(20) NOT NULL,
  8. `category` varchar(20) NOT NULL,
  9. `name` varchar(255) NOT NULL,
  10. `description` text NOT NULL,
  11. `parceluuid` char(36) NOT NULL,
  12. `parentestate` int(11) NOT NULL,
  13. `snapshotuuid` char(36) NOT NULL,
  14. `simname` varchar(255) NOT NULL,
  15. `posglobal` varchar(255) NOT NULL,
  16. `parcelname` varchar(255) NOT NULL,
  17. `classifiedflags` int(8) NOT NULL,
  18. `priceforlisting` int(5) NOT NULL,
  19. PRIMARY KEY (`classifieduuid`)
  20. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  21. CREATE TABLE IF NOT EXISTS `usernotes` (
  22. `useruuid` varchar(36) NOT NULL,
  23. `targetuuid` varchar(36) NOT NULL,
  24. `notes` text NOT NULL,
  25. UNIQUE KEY `useruuid` (`useruuid`,`targetuuid`)
  26. ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  27. CREATE TABLE IF NOT EXISTS `userpicks` (
  28. `pickuuid` varchar(36) NOT NULL,
  29. `creatoruuid` varchar(36) NOT NULL,
  30. `toppick` enum('true','false') NOT NULL,
  31. `parceluuid` varchar(36) NOT NULL,
  32. `name` varchar(255) NOT NULL,
  33. `description` text NOT NULL,
  34. `snapshotuuid` varchar(36) NOT NULL,
  35. `user` varchar(255) NOT NULL,
  36. `originalname` varchar(255) NOT NULL,
  37. `simname` varchar(255) NOT NULL,
  38. `posglobal` varchar(255) NOT NULL,
  39. `sortorder` int(2) NOT NULL,
  40. `enabled` enum('true','false') NOT NULL,
  41. PRIMARY KEY (`pickuuid`)
  42. ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  43. CREATE TABLE IF NOT EXISTS `userprofile` (
  44. `useruuid` varchar(36) NOT NULL,
  45. `profilePartner` varchar(36) NOT NULL,
  46. `profileAllowPublish` binary(1) NOT NULL,
  47. `profileMaturePublish` binary(1) NOT NULL,
  48. `profileURL` varchar(255) NOT NULL,
  49. `profileWantToMask` int(3) NOT NULL,
  50. `profileWantToText` text NOT NULL,
  51. `profileSkillsMask` int(3) NOT NULL,
  52. `profileSkillsText` text NOT NULL,
  53. `profileLanguages` text NOT NULL,
  54. `profileImage` varchar(36) NOT NULL,
  55. `profileAboutText` text NOT NULL,
  56. `profileFirstImage` varchar(36) NOT NULL,
  57. `profileFirstText` text NOT NULL,
  58. PRIMARY KEY (`useruuid`)
  59. ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  60. commit;
  61. :VERSION 2 # -------------------------------
  62. begin;
  63. CREATE TABLE IF NOT EXISTS `userdata` (
  64. `UserId` char(36) NOT NULL,
  65. `TagId` varchar(64) NOT NULL,
  66. `DataKey` varchar(255),
  67. `DataVal` varchar(255),
  68. PRIMARY KEY (`UserId`,`TagId`)
  69. ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  70. commit;
  71. :VERSION 3 # -------------------------------
  72. begin;
  73. CREATE TABLE IF NOT EXISTS `usersettings` (
  74. `useruuid` varchar(36) NOT NULL,
  75. `imviaemail` enum('true','false') NOT NULL,
  76. `visible` enum('true','false') NOT NULL,
  77. `email` varchar(254) NOT NULL,
  78. PRIMARY KEY (`useruuid`)
  79. ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  80. commit;
  81. :VERSION 4 # -------------------------------
  82. begin;
  83. ALTER TABLE userpicks ADD COLUMN gatekeeper varchar(255);
  84. commit;