1
0

CreateAgentsTable.sql 785 B

123456789101112131415161718192021222324
  1. SET FOREIGN_KEY_CHECKS=0;
  2. -- ----------------------------
  3. -- Table structure for agents
  4. -- ----------------------------
  5. CREATE TABLE `agents` (
  6. `UUID` varchar(36) NOT NULL,
  7. `sessionID` varchar(36) NOT NULL,
  8. `secureSessionID` varchar(36) NOT NULL,
  9. `agentIP` varchar(16) NOT NULL,
  10. `agentPort` int(11) NOT NULL,
  11. `agentOnline` tinyint(4) NOT NULL,
  12. `loginTime` int(11) NOT NULL,
  13. `logoutTime` int(11) NOT NULL,
  14. `currentRegion` varchar(36) NOT NULL,
  15. `currentHandle` bigint(20) unsigned NOT NULL,
  16. `currentPos` varchar(64) NOT NULL,
  17. PRIMARY KEY (`UUID`),
  18. UNIQUE KEY `session` (`sessionID`),
  19. UNIQUE KEY `ssession` (`secureSessionID`)
  20. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Rev. 1';
  21. -- ----------------------------
  22. -- Records
  23. -- ----------------------------