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

BEGIN;

CREATE TABLE hg_traveling_data (
    "SessionID" VARCHAR(36) NOT NULL Primary Key,
    "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 now()
);


COMMIT;