GridUserStore.migrations 790 B

123456789101112131415161718192021222324
  1. :VERSION 1 # --------------------------
  2. BEGIN;
  3. CREATE TABLE `GridUser` (
  4. `UserID` VARCHAR(255) NOT NULL,
  5. `HomeRegionID` CHAR(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000',
  6. `HomePosition` CHAR(64) NOT NULL DEFAULT '<0,0,0>',
  7. `HomeLookAt` CHAR(64) NOT NULL DEFAULT '<0,0,0>',
  8. `LastRegionID` CHAR(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000',
  9. `LastPosition` CHAR(64) NOT NULL DEFAULT '<0,0,0>',
  10. `LastLookAt` CHAR(64) NOT NULL DEFAULT '<0,0,0>',
  11. `Online` CHAR(5) NOT NULL DEFAULT 'false',
  12. `Login` CHAR(16) NOT NULL DEFAULT '0',
  13. `Logout` CHAR(16) NOT NULL DEFAULT '0',
  14. PRIMARY KEY (`UserID`)
  15. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  16. COMMIT;
  17. :VERSION 2 # --------------------------
  18. BEGIN;
  19. COMMIT;