123456789101112131415161718 |
- :VERSION 2 # --------------------------
- BEGIN;
- CREATE TABLE hg_traveling_data(
- SessionID VARCHAR(36) NOT NULL,
- UserID VARCHAR(36) NOT NULL,
- GridExternalName VARCHAR(255) NOT NULL DEFAULT "",
- ServiceToken VARCHAR(255) NOT NULL DEFAULT "",
- ClientIPAddress VARCHAR(16) NOT NULL DEFAULT "",
- MyIPAddress VARCHAR(16) NOT NULL DEFAULT "",
- TMStamp TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
- PRIMARY KEY(SessionID),
- UNIQUE(UserID)
- );
- COMMIT;
|