001_GridUserStore.sql 599 B

12345678910111213141516
  1. BEGIN TRANSACTION;
  2. CREATE TABLE GridUser (
  3. UserID VARCHAR(255) primary key,
  4. HomeRegionID CHAR(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000',
  5. HomePosition CHAR(64) NOT NULL DEFAULT '<0,0,0>',
  6. HomeLookAt CHAR(64) NOT NULL DEFAULT '<0,0,0>',
  7. LastRegionID CHAR(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000',
  8. LastPosition CHAR(64) NOT NULL DEFAULT '<0,0,0>',
  9. LastLookAt CHAR(64) NOT NULL DEFAULT '<0,0,0>',
  10. Online CHAR(5) NOT NULL DEFAULT 'false',
  11. Login CHAR(16) NOT NULL DEFAULT '0',
  12. Logout CHAR(16) NOT NULL DEFAULT '0'
  13. ) ;
  14. COMMIT;