HGTravelStore.migrations 482 B

123456789101112131415161718
  1. :VERSION 1 # --------------------------
  2. BEGIN;
  3. CREATE TABLE `hg_traveling_data` (
  4. `SessionID` VARCHAR(36) NOT NULL,
  5. `UserID` VARCHAR(36) NOT NULL,
  6. `GridExternalName` VARCHAR(255) NOT NULL DEFAULT '',
  7. `ServiceToken` VARCHAR(255) NOT NULL DEFAULT '',
  8. `ClientIPAddress` VARCHAR(16) NOT NULL DEFAULT '',
  9. `MyIPAddress` VARCHAR(16) NOT NULL DEFAULT '',
  10. `TMStamp` timestamp NOT NULL,
  11. PRIMARY KEY (`SessionID`),
  12. KEY (`UserID`)
  13. ) ENGINE=InnoDB;
  14. COMMIT;