diff options
author | Charles Krinke | 2009-01-12 20:14:39 +0000 |
---|---|---|
committer | Charles Krinke | 2009-01-12 20:14:39 +0000 |
commit | c00c855cc5decf73d598af5d74a2ef57c547efd3 (patch) | |
tree | 03a6e3622db531537c2cfb47a99acd5edf4fe6b7 /OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_UserStore.sql | |
parent | * Separate starting a client thread into a separate Start() method (which mat... (diff) | |
download | opensim-SC_OLD-c00c855cc5decf73d598af5d74a2ef57c547efd3.zip opensim-SC_OLD-c00c855cc5decf73d598af5d74a2ef57c547efd3.tar.gz opensim-SC_OLD-c00c855cc5decf73d598af5d74a2ef57c547efd3.tar.bz2 opensim-SC_OLD-c00c855cc5decf73d598af5d74a2ef57c547efd3.tar.xz |
Thank you kindly, Tlaukkan (Tommil) for a patch that:
Cleaned up schema creation scripts of MySQL to compliant form and created
SQLite scripts from them. In future it would be optimal if scripts from
different databases could be generated from MySQL scripts to ensure optimal
consistency between schemas of different databases. Did not yet review
column names. ID columns seem to have variety in naming which can be confusing.
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; | ||