aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/SQLite/Resources/HGTravelStore.migrations
blob: 2e73caa9d2396ed43ee2d1c71c57f18b7bf431d9 (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 DEFAULT CURRENT_TIMESTAMP,
    PRIMARY KEY  (`SessionID`),
	KEY (`UserID`)
) ENGINE=InnoDB;

COMMIT;