006_UserStore.sql 510 B

1234567891011121314151617181920
  1. BEGIN TRANSACTION;
  2. -- usersagents table
  3. CREATE TABLE IF NOT EXISTS useragents(
  4. UUID varchar(255) primary key,
  5. agentIP varchar(255),
  6. agentPort integer,
  7. agentOnline boolean,
  8. sessionID varchar(255),
  9. secureSessionID varchar(255),
  10. regionID varchar(255),
  11. loginTime integer,
  12. logoutTime integer,
  13. currentRegion varchar(255),
  14. currentHandle varchar(255),
  15. currentPosX float,
  16. currentPosY float,
  17. currentPosZ float);
  18. COMMIT;