aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/SQLite/Resources/001_GridUserStore.sql
blob: 1a24613275084e5ef3695bc63454df1060cd866e (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
BEGIN TRANSACTION;

CREATE TABLE GridUser (
    UserID VARCHAR(255) primary key,
    HomeRegionID CHAR(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000',
    HomePosition CHAR(64) NOT NULL DEFAULT '<0,0,0>',
    HomeLookAt CHAR(64) NOT NULL DEFAULT '<0,0,0>',
    LastRegionID CHAR(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000',
    LastPosition CHAR(64) NOT NULL DEFAULT '<0,0,0>',
    LastLookAt CHAR(64) NOT NULL DEFAULT '<0,0,0>',
    Online CHAR(5) NOT NULL DEFAULT 'false',
    Login CHAR(16) NOT NULL DEFAULT '0',
    Logout CHAR(16) NOT NULL DEFAULT '0'
) ;

COMMIT;