diff options
Diffstat (limited to 'OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_UserStore.sql')
-rw-r--r-- | OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_UserStore.sql | 194 |
1 files changed, 95 insertions, 99 deletions
diff --git a/OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_UserStore.sql b/OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_UserStore.sql index c5e42d5..6084886 100644 --- a/OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_UserStore.sql +++ b/OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_UserStore.sql | |||
@@ -1,108 +1,104 @@ | |||
1 | BEGIN TRANSACTION; | 1 | CREATE TABLE UserAgents ( |
2 | 2 | ProfileID VARCHAR(36) NOT NULL, | |
3 | create table UserAgents ( | 3 | AgentIP VARCHAR(24) DEFAULT NULL, |
4 | ProfileID TEXT not null, | 4 | AgentPort INT DEFAULT NULL, |
5 | AgentIP TEXT, | 5 | AgentOnline BIT DEFAULT NULL, |
6 | AgentPort INTEGER, | 6 | SessionID VARCHAR(36) DEFAULT NULL, |
7 | AgentOnline INTEGER, | 7 | SecureSessionID VARCHAR(36) DEFAULT NULL, |
8 | SessionID TEXT, | 8 | InitialRegion VARCHAR(255) DEFAULT NULL, |
9 | SecureSessionID TEXT, | 9 | Region VARCHAR(255) DEFAULT NULL, |
10 | InitialRegion TEXT, | 10 | LoginTime INT DEFAULT NULL, |
11 | Region TEXT, | 11 | LogoutTime INT DEFAULT NULL, |
12 | LoginTime INTEGER, | 12 | Handle BIGINT DEFAULT NULL, |
13 | LogoutTime INTEGER, | 13 | PositionX DOUBLE DEFAULT NULL, |
14 | Handle INTEGER, | 14 | PositionY DOUBLE DEFAULT NULL, |
15 | PositionX NUMERIC, | 15 | PositionZ DOUBLE DEFAULT NULL, |
16 | PositionY NUMERIC, | 16 | LookAtX DOUBLE DEFAULT NULL, |
17 | PositionZ NUMERIC, | 17 | LookAtY DOUBLE DEFAULT NULL, |
18 | LookAtX NUMERIC, | 18 | LookAtZ DOUBLE DEFAULT NULL, |
19 | LookAtY NUMERIC, | 19 | PRIMARY KEY (ProfileID) |
20 | LookAtZ NUMERIC, | ||
21 | primary key (ProfileID) | ||
22 | ); | 20 | ); |
23 | 21 | ||
24 | create table UserProfiles ( | 22 | CREATE TABLE UserProfiles ( |
25 | ID TEXT not null, | 23 | ID VARCHAR(36) NOT NULL, |
26 | WebLoginKey TEXT, | 24 | WebLoginKey VARCHAR(36) DEFAULT NULL, |
27 | FirstName TEXT, | 25 | FirstName VARCHAR(32) DEFAULT NULL, |
28 | SurName TEXT, | 26 | SurName VARCHAR(32) DEFAULT NULL, |
29 | Email TEXT, | 27 | Email VARCHAR(250) DEFAULT NULL, |
30 | PasswordHash TEXT, | 28 | PasswordHash VARCHAR(32) DEFAULT NULL, |
31 | PasswordSalt TEXT, | 29 | PasswordSalt VARCHAR(32) DEFAULT NULL, |
32 | HomeRegionID TEXT, | 30 | HomeRegionID VARCHAR(36) DEFAULT NULL, |
33 | HomeRegionX INTEGER, | 31 | HomeRegionX INT DEFAULT NULL, |
34 | HomeRegionY INTEGER, | 32 | HomeRegionY INT DEFAULT NULL, |
35 | HomeLocationX NUMERIC, | 33 | HomeLocationX DOUBLE DEFAULT NULL, |
36 | HomeLocationY NUMERIC, | 34 | HomeLocationY DOUBLE DEFAULT NULL, |
37 | HomeLocationZ NUMERIC, | 35 | HomeLocationZ DOUBLE DEFAULT NULL, |
38 | HomeLookAtX NUMERIC, | 36 | HomeLookAtX DOUBLE DEFAULT NULL, |
39 | HomeLookAtY NUMERIC, | 37 | HomeLookAtY DOUBLE DEFAULT NULL, |
40 | HomeLookAtZ NUMERIC, | 38 | HomeLookAtZ DOUBLE DEFAULT NULL, |
41 | Created INTEGER, | 39 | Created INT DEFAULT NULL, |
42 | LastLogin INTEGER, | 40 | LastLogin INT DEFAULT NULL, |
43 | UserInventoryURI TEXT, | 41 | UserInventoryURI VARCHAR(255) DEFAULT NULL, |
44 | UserAssetURI TEXT, | 42 | UserAssetURI VARCHAR(255) DEFAULT NULL, |
45 | Image TEXT, | 43 | Image VARCHAR(36) DEFAULT NULL, |
46 | FirstLifeImage TEXT, | 44 | FirstLifeImage VARCHAR(36) DEFAULT NULL, |
47 | AboutText TEXT, | 45 | AboutText TEXT DEFAULT NULL, |
48 | FirstLifeAboutText TEXT, | 46 | FirstLifeAboutText TEXT DEFAULT NULL, |
49 | RootInventoryFolderID TEXT, | 47 | CanDoMask INT DEFAULT NULL, |
50 | `CanDoMask` INTEGER, | 48 | WantDoMask INT DEFAULT NULL, |
51 | `WantDoMask` INTEGER, | 49 | UserFlags INT DEFAULT NULL, |
52 | `UserFlags` INTEGER, | 50 | GodLevel INT DEFAULT NULL, |
53 | `GodLevel` INTEGER, | 51 | CustomType VARCHAR(32) DEFAULT NULL, |
54 | `CustomType` TEXT, | 52 | Partner VARCHAR(36) DEFAULT NULL, |
55 | `Partner` TEXT, | 53 | RootInventoryFolderID VARCHAR(36) DEFAULT NULL, |
56 | primary key (ID) | 54 | PRIMARY KEY (ID) |
57 | ); | 55 | ); |
58 | 56 | ||
59 | create table UserAppearances ( | 57 | CREATE INDEX UserSurnameIndex ON UserProfiles (SurName); |
60 | Owner TEXT not null, | 58 | CREATE INDEX UserFirstNameIndex ON UserProfiles (FirstName); |
61 | BodyItem TEXT, | 59 | CREATE UNIQUE INDEX UserFullNameIndex ON UserProfiles (SurName,FirstName); |
62 | BodyAsset TEXT, | ||
63 | SkinItem TEXT, | ||
64 | SkinAsset TEXT, | ||
65 | HairItem TEXT, | ||
66 | HairAsset TEXT, | ||
67 | EyesItem TEXT, | ||
68 | EyesAsset TEXT, | ||
69 | ShirtItem TEXT, | ||
70 | ShirtAsset TEXT, | ||
71 | PantsItem TEXT, | ||
72 | PantsAsset TEXT, | ||
73 | ShoesItem TEXT, | ||
74 | ShoesAsset TEXT, | ||
75 | SocksItem TEXT, | ||
76 | SocksAsset TEXT, | ||
77 | JacketItem TEXT, | ||
78 | JacketAsset TEXT, | ||
79 | GlovesItem TEXT, | ||
80 | GlovesAsset TEXT, | ||
81 | UnderShirtItem TEXT, | ||
82 | UnderShirtAsset TEXT, | ||
83 | UnderPantsItem TEXT, | ||
84 | UnderPantsAsset TEXT, | ||
85 | SkirtItem TEXT, | ||
86 | SkirtAsset TEXT, | ||
87 | Texture BLOB, | ||
88 | VisualParams BLOB, | ||
89 | Serial INTEGER, | ||
90 | AvatarHeight NUMERIC, | ||
91 | primary key (Owner) | ||
92 | ); | ||
93 | 60 | ||
61 | CREATE TABLE UserAppearances ( | ||
62 | Owner VARCHAR(36) NOT NULL, | ||
63 | BodyItem VARCHAR(36) DEFAULT NULL, | ||
64 | BodyAsset VARCHAR(36) DEFAULT NULL, | ||
65 | SkinItem VARCHAR(36) DEFAULT NULL, | ||
66 | SkinAsset VARCHAR(36) DEFAULT NULL, | ||
67 | HairItem VARCHAR(36) DEFAULT NULL, | ||
68 | HairAsset VARCHAR(36) DEFAULT NULL, | ||
69 | EyesItem VARCHAR(36) DEFAULT NULL, | ||
70 | EyesAsset VARCHAR(36) DEFAULT NULL, | ||
71 | ShirtItem VARCHAR(36) DEFAULT NULL, | ||
72 | ShirtAsset VARCHAR(36) DEFAULT NULL, | ||
73 | PantsItem VARCHAR(36) DEFAULT NULL, | ||
74 | PantsAsset VARCHAR(36) DEFAULT NULL, | ||
75 | ShoesItem VARCHAR(36) DEFAULT NULL, | ||
76 | ShoesAsset VARCHAR(36) DEFAULT NULL, | ||
77 | SocksItem VARCHAR(36) DEFAULT NULL, | ||
78 | SocksAsset VARCHAR(36) DEFAULT NULL, | ||
79 | JacketItem VARCHAR(36) DEFAULT NULL, | ||
80 | JacketAsset VARCHAR(36) DEFAULT NULL, | ||
81 | GlovesItem VARCHAR(36) DEFAULT NULL, | ||
82 | GlovesAsset VARCHAR(36) DEFAULT NULL, | ||
83 | UnderShirtItem VARCHAR(36) DEFAULT NULL, | ||
84 | UnderShirtAsset VARCHAR(36) DEFAULT NULL, | ||
85 | UnderPantsItem VARCHAR(36) DEFAULT NULL, | ||
86 | UnderPantsAsset VARCHAR(36) DEFAULT NULL, | ||
87 | SkirtItem VARCHAR(36) DEFAULT NULL, | ||
88 | SkirtAsset VARCHAR(36) DEFAULT NULL, | ||
89 | Texture BLOB, | ||
90 | VisualParams BLOB, | ||
91 | Serial INT DEFAULT NULL, | ||
92 | AvatarHeight FLOAT DEFAULT NULL, | ||
93 | PRIMARY KEY (Owner) | ||
94 | ); | ||
94 | 95 | ||
95 | CREATE TABLE UserFriends ( | 96 | CREATE TABLE UserFriends ( |
96 | UserFriendID TEXT, | 97 | UserFriendID VARCHAR(36) NOT NULL, |
97 | OwnerID TEXT, | 98 | OwnerID VARCHAR(36) DEFAULT NULL, |
98 | FriendID TEXT, | 99 | FriendID VARCHAR(36) DEFAULT NULL, |
99 | FriendPermissions INTEGER, | 100 | FriendPermissions INT DEFAULT NULL, |
100 | primary key (UserFriendID) | 101 | PRIMARY KEY (UserFriendID) |
101 | ); | 102 | ); |
102 | 103 | ||
103 | create index UserFirstNameIndex on UserProfiles (FirstName); | 104 | CREATE UNIQUE INDEX UserFriendsOwnerIdFriendIdIndex ON UserFriends (OwnerID,FriendID); |
104 | create index UserSurnameIndex on UserProfiles (SurName); | ||
105 | create unique index UserFullNameIndex on UserProfiles (FirstName,SurName); | ||
106 | create unique index UserFriendsOwnerFriendIndex on UserFriends (OwnerID,FriendID); | ||
107 | |||
108 | COMMIT; | ||