1
0

HGTravelStore.migrations 660 B

123456789101112131415161718192021222324
  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 DEFAULT CHARSET=latin1;
  14. COMMIT;
  15. :VERSION 2 # --------------------------
  16. ALTER TABLE `hg_traveling_data` MODIFY `TMStamp` timestamp NOT NULL default CURRENT_TIMESTAMP;
  17. COMMIT;