aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MySQL/Resources/HGTravelStore.migrations
blob: 06ca29dc5814456216cd0c83d8e1393ee12457c5 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
:VERSION 1         # -------------------------- 

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 NOT NULL,
    PRIMARY KEY  (`SessionID`),
	KEY (`UserID`)
) ENGINE=MyISAM;

COMMIT;