diff options
author | Melanie | 2009-10-22 07:12:10 +0100 |
---|---|---|
committer | Melanie | 2009-10-22 07:12:10 +0100 |
commit | c4969d47d9bbc22b37054451cd31451ca8d8c78a (patch) | |
tree | 788e3b034254bcf068ca950ee97a78b6aa07b386 /OpenSim/Data/NHibernate/Resources/SQLiteDialect | |
parent | Merge branch 'master' into vehicles (diff) | |
parent | Remove the "mel_t" from version string (diff) | |
download | opensim-SC_OLD-c4969d47d9bbc22b37054451cd31451ca8d8c78a.zip opensim-SC_OLD-c4969d47d9bbc22b37054451cd31451ca8d8c78a.tar.gz opensim-SC_OLD-c4969d47d9bbc22b37054451cd31451ca8d8c78a.tar.bz2 opensim-SC_OLD-c4969d47d9bbc22b37054451cd31451ca8d8c78a.tar.xz |
Merge branch 'master' into vehicles
Diffstat (limited to 'OpenSim/Data/NHibernate/Resources/SQLiteDialect')
6 files changed, 0 insertions, 427 deletions
diff --git a/OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_AssetStore.sql b/OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_AssetStore.sql deleted file mode 100644 index aedf764..0000000 --- a/OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_AssetStore.sql +++ /dev/null | |||
@@ -1,10 +0,0 @@ | |||
1 | CREATE TABLE Assets ( | ||
2 | ID VARCHAR(36) NOT NULL, | ||
3 | Type SMALLINT DEFAULT NULL, | ||
4 | Name VARCHAR(64) DEFAULT NULL, | ||
5 | Description VARCHAR(64) DEFAULT NULL, | ||
6 | Local BIT DEFAULT NULL, | ||
7 | Temporary BIT DEFAULT NULL, | ||
8 | Data BLOB, | ||
9 | PRIMARY KEY (ID) | ||
10 | ); | ||
diff --git a/OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_EstateStore.sql b/OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_EstateStore.sql deleted file mode 100644 index afe702f..0000000 --- a/OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_EstateStore.sql +++ /dev/null | |||
@@ -1,71 +0,0 @@ | |||
1 | CREATE TABLE EstateSettings ( | ||
2 | EstateID INT NOT NULL, | ||
3 | ParentEstateID INT DEFAULT NULL, | ||
4 | EstateOwnerID VARCHAR(36) DEFAULT NULL, | ||
5 | Name VARCHAR(64) DEFAULT NULL, | ||
6 | RedirectGridX INT DEFAULT NULL, | ||
7 | RedirectGridY INT DEFAULT NULL, | ||
8 | BillableFactor DOUBLE DEFAULT NULL, | ||
9 | PricePerMeter INT DEFAULT NULL, | ||
10 | SunPosition DOUBLE DEFAULT NULL, | ||
11 | |||
12 | UseGlobalTime BIT DEFAULT NULL, | ||
13 | FixedSun BIT DEFAULT NULL, | ||
14 | AllowVoice BIT DEFAULT NULL, | ||
15 | AllowDirectTeleport BIT DEFAULT NULL, | ||
16 | ResetHomeOnTeleport BIT DEFAULT NULL, | ||
17 | PublicAccess BIT DEFAULT NULL, | ||
18 | DenyAnonymous BIT DEFAULT NULL, | ||
19 | DenyIdentified BIT DEFAULT NULL, | ||
20 | DenyTransacted BIT DEFAULT NULL, | ||
21 | DenyMinors BIT DEFAULT NULL, | ||
22 | BlockDwell BIT DEFAULT NULL, | ||
23 | EstateSkipScripts BIT DEFAULT NULL, | ||
24 | TaxFree BIT DEFAULT NULL, | ||
25 | AbuseEmailToEstateOwner BIT DEFAULT NULL, | ||
26 | |||
27 | AbuseEmail VARCHAR(255) DEFAULT NULL, | ||
28 | |||
29 | PRIMARY KEY (EstateID) | ||
30 | ); | ||
31 | |||
32 | CREATE TABLE EstateRegionLink ( | ||
33 | EstateRegionLinkID VARCHAR(36) NOT NULL, | ||
34 | EstateID INT DEFAULT NULL, | ||
35 | RegionID VARCHAR(36) DEFAULT NULL, | ||
36 | PRIMARY KEY (EstateRegionLinkID) | ||
37 | ); | ||
38 | |||
39 | CREATE INDEX EstateRegionLinkEstateIDIndex ON EstateRegionLink (EstateID); | ||
40 | CREATE INDEX EstateRegionLinkERegionIDIndex ON EstateRegionLink (RegionID); | ||
41 | |||
42 | CREATE TABLE EstateManagers ( | ||
43 | EstateID INT NOT NULL, | ||
44 | ManagerID VARCHAR(36) NOT NULL, | ||
45 | ArrayIndex INT NOT NULL, | ||
46 | PRIMARY KEY (EstateID,ArrayIndex) | ||
47 | ); | ||
48 | |||
49 | CREATE TABLE EstateUsers ( | ||
50 | EstateID INT NOT NULL, | ||
51 | UserID VARCHAR(36) NOT NULL, | ||
52 | ArrayIndex INT NOT NULL, | ||
53 | PRIMARY KEY (EstateID,ArrayIndex) | ||
54 | ); | ||
55 | |||
56 | CREATE TABLE EstateGroups ( | ||
57 | EstateID INT NOT NULL, | ||
58 | GroupID VARCHAR(36) NOT NULL, | ||
59 | ArrayIndex INT NOT NULL, | ||
60 | PRIMARY KEY (EstateID,ArrayIndex) | ||
61 | ); | ||
62 | |||
63 | CREATE TABLE EstateBans ( | ||
64 | EstateID INT NOT NULL, | ||
65 | ArrayIndex INT NOT NULL, | ||
66 | BannedUserID VARCHAR(36) NOT NULL, | ||
67 | BannedHostAddress VARCHAR(16) NOT NULL, | ||
68 | BannedHostIPMask VARCHAR(16) NOT NULL, | ||
69 | BannedHostNameMask VARCHAR(16) NOT NULL, | ||
70 | PRIMARY KEY (EstateID,ArrayIndex) | ||
71 | ); | ||
diff --git a/OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_GridStore.sql b/OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_GridStore.sql deleted file mode 100644 index 4f09848..0000000 --- a/OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_GridStore.sql +++ /dev/null | |||
@@ -1,35 +0,0 @@ | |||
1 | CREATE TABLE Regions ( | ||
2 | RegionId VARCHAR(36) NOT NULL, | ||
3 | RegionHandle BIGINT UNSIGNED NOT NULL, | ||
4 | RegionName VARCHAR(32) DEFAULT NULL, | ||
5 | RegionRecvKey VARCHAR(128) DEFAULT NULL, | ||
6 | RegionSendKey VARCHAR(128) DEFAULT NULL, | ||
7 | RegionSecret VARCHAR(128) DEFAULT NULL, | ||
8 | RegionDataURI VARCHAR(255) DEFAULT NULL, | ||
9 | ServerIP VARCHAR(64) DEFAULT NULL, | ||
10 | ServerPort INT UNSIGNED DEFAULT NULL, | ||
11 | ServerURI VARCHAR(255) DEFAULT NULL, | ||
12 | RegionLocX INT UNSIGNED DEFAULT NULL, | ||
13 | RegionLocY INT UNSIGNED DEFAULT NULL, | ||
14 | RegionLocZ INT UNSIGNED DEFAULT NULL, | ||
15 | EastOverrideHandle BIGINT UNSIGNED DEFAULT NULL, | ||
16 | WestOverrideHandle BIGINT UNSIGNED DEFAULT NULL, | ||
17 | SouthOverrideHandle BIGINT UNSIGNED DEFAULT NULL, | ||
18 | NorthOverrideHandle BIGINT UNSIGNED DEFAULT NULL, | ||
19 | RegionAssetURI VARCHAR(255) DEFAULT NULL, | ||
20 | RegionAssetRecvKey VARCHAR(128) DEFAULT NULL, | ||
21 | RegionAssetSendKey VARCHAR(128) DEFAULT NULL, | ||
22 | RegionUserURI VARCHAR(255) DEFAULT NULL, | ||
23 | RegionUserRecvKey VARCHAR(128) DEFAULT NULL, | ||
24 | RegionUserSendKey VARCHAR(128) DEFAULT NULL, | ||
25 | RegionMapTextureId VARCHAR(36) DEFAULT NULL, | ||
26 | ServerHttpPort INT DEFAULT NULL, | ||
27 | ServerRemotingPort INT DEFAULT NULL, | ||
28 | OwnerID VARCHAR(36) DEFAULT NULL, | ||
29 | OriginID VARCHAR(36) DEFAULT NULL, | ||
30 | PRIMARY KEY (RegionId) | ||
31 | ); | ||
32 | |||
33 | CREATE INDEX RegionNameIndex ON Regions (RegionName); | ||
34 | CREATE INDEX RegionHandleIndex ON Regions (RegionHandle); | ||
35 | CREATE INDEX RegionHandlesIndex ON Regions (EastOverrideHandle,WestOverrideHandle,SouthOverrideHandle,NorthOverrideHandle); | ||
diff --git a/OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_InventoryStore.sql b/OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_InventoryStore.sql deleted file mode 100644 index 38978ee..0000000 --- a/OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_InventoryStore.sql +++ /dev/null | |||
@@ -1,39 +0,0 @@ | |||
1 | CREATE TABLE InventoryFolders ( | ||
2 | ID VARCHAR(36) NOT NULL, | ||
3 | Type SMALLINT DEFAULT NULL, | ||
4 | Version INT DEFAULT NULL, | ||
5 | ParentID VARCHAR(36) DEFAULT NULL, | ||
6 | Owner VARCHAR(36) DEFAULT NULL, | ||
7 | Name VARCHAR(64) DEFAULT NULL, | ||
8 | PRIMARY KEY (ID) | ||
9 | ); | ||
10 | |||
11 | CREATE INDEX InventoryFoldersOwnerIdIndex ON InventoryFolders (Owner); | ||
12 | CREATE INDEX InventoryFoldersParentIdIndex ON InventoryFolders (ParentID); | ||
13 | |||
14 | CREATE TABLE InventoryItems ( | ||
15 | ID VARCHAR(36) NOT NULL, | ||
16 | InvType INT DEFAULT NULL, | ||
17 | AssetType INT DEFAULT NULL, | ||
18 | AssetID VARCHAR(36) DEFAULT NULL, | ||
19 | Folder VARCHAR(36) DEFAULT NULL, | ||
20 | Owner VARCHAR(36) DEFAULT NULL, | ||
21 | Creator VARCHAR(36) DEFAULT NULL, | ||
22 | Name VARCHAR(64) DEFAULT NULL, | ||
23 | Description VARCHAR(64) DEFAULT NULL, | ||
24 | NextPermissions INT DEFAULT NULL, | ||
25 | CurrentPermissions INT DEFAULT NULL, | ||
26 | BasePermissions INT DEFAULT NULL, | ||
27 | EveryOnePermissions INT DEFAULT NULL, | ||
28 | GroupID VARCHAR(36) DEFAULT NULL, | ||
29 | GroupOwned BIT DEFAULT NULL, | ||
30 | SalePrice INT DEFAULT NULL, | ||
31 | SaleType TINYINT DEFAULT NULL, | ||
32 | Flags INT DEFAULT NULL, | ||
33 | CreationDate INT DEFAULT NULL, | ||
34 | PRIMARY KEY (ID) | ||
35 | ); | ||
36 | |||
37 | CREATE INDEX InventoryItemsGroupIdIndex ON InventoryItems (GroupID); | ||
38 | CREATE INDEX InventoryItemsOwnerIdIndex ON InventoryItems (Owner); | ||
39 | CREATE INDEX InventoryItemsFolderIdIndex ON InventoryItems (Folder); | ||
diff --git a/OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_RegionStore.sql b/OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_RegionStore.sql deleted file mode 100644 index 2b8e62a..0000000 --- a/OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_RegionStore.sql +++ /dev/null | |||
@@ -1,168 +0,0 @@ | |||
1 | CREATE TABLE Prims ( | ||
2 | UUID VARCHAR(36) NOT NULL, | ||
3 | RegionID VARCHAR(36) DEFAULT NULL, | ||
4 | GroupID VARCHAR(36) DEFAULT NULL, | ||
5 | ParentID INT DEFAULT NULL, | ||
6 | ParentUUID VARCHAR(36) DEFAULT NULL, | ||
7 | OwnerID VARCHAR(36) DEFAULT NULL, | ||
8 | LastOwnerID VARCHAR(36) DEFAULT NULL, | ||
9 | CreatorID VARCHAR(36) DEFAULT NULL, | ||
10 | CreationDate INT DEFAULT NULL, | ||
11 | LinkNum INT DEFAULT NULL, | ||
12 | Name VARCHAR(255) DEFAULT NULL, | ||
13 | Text VARCHAR(255) DEFAULT NULL, | ||
14 | Description VARCHAR(255) DEFAULT NULL, | ||
15 | SitName VARCHAR(255) DEFAULT NULL, | ||
16 | TouchName VARCHAR(255) DEFAULT NULL, | ||
17 | ObjectFlags INT DEFAULT NULL, | ||
18 | OwnerMask INT DEFAULT NULL, | ||
19 | NextOwnerMask INT DEFAULT NULL, | ||
20 | GroupMask INT DEFAULT NULL, | ||
21 | EveryoneMask INT DEFAULT NULL, | ||
22 | BaseMask INT DEFAULT NULL, | ||
23 | Material TINYINT DEFAULT NULL, | ||
24 | ScriptAccessPin INT DEFAULT NULL, | ||
25 | TextureAnimation BLOB, | ||
26 | ParticleSystem BLOB, | ||
27 | ClickAction TINYINT DEFAULT NULL, | ||
28 | Color INT DEFAULT NULL, | ||
29 | PositionX DOUBLE DEFAULT NULL, | ||
30 | PositionY DOUBLE DEFAULT NULL, | ||
31 | PositionZ DOUBLE DEFAULT NULL, | ||
32 | GroupPositionX DOUBLE DEFAULT NULL, | ||
33 | GroupPositionY DOUBLE DEFAULT NULL, | ||
34 | GroupPositionZ DOUBLE DEFAULT NULL, | ||
35 | VelocityX DOUBLE DEFAULT NULL, | ||
36 | VelocityY DOUBLE DEFAULT NULL, | ||
37 | VelocityZ DOUBLE DEFAULT NULL, | ||
38 | AngularVelocityX DOUBLE DEFAULT NULL, | ||
39 | AngularVelocityY DOUBLE DEFAULT NULL, | ||
40 | AngularVelocityZ DOUBLE DEFAULT NULL, | ||
41 | AccelerationX DOUBLE DEFAULT NULL, | ||
42 | AccelerationY DOUBLE DEFAULT NULL, | ||
43 | AccelerationZ DOUBLE DEFAULT NULL, | ||
44 | RotationX DOUBLE DEFAULT NULL, | ||
45 | RotationY DOUBLE DEFAULT NULL, | ||
46 | RotationZ DOUBLE DEFAULT NULL, | ||
47 | RotationW DOUBLE DEFAULT NULL, | ||
48 | SitTargetOffsetX DOUBLE DEFAULT NULL, | ||
49 | SitTargetOffsetY DOUBLE DEFAULT NULL, | ||
50 | SitTargetOffsetZ DOUBLE DEFAULT NULL, | ||
51 | SitTargetOrientW DOUBLE DEFAULT NULL, | ||
52 | SitTargetOrientX DOUBLE DEFAULT NULL, | ||
53 | SitTargetOrientY DOUBLE DEFAULT NULL, | ||
54 | SitTargetOrientZ DOUBLE DEFAULT NULL, | ||
55 | -- this is the shape | ||
56 | Shape INT DEFAULT NULL, | ||
57 | ScaleX DOUBLE DEFAULT NULL, | ||
58 | ScaleY DOUBLE DEFAULT NULL, | ||
59 | ScaleZ DOUBLE DEFAULT NULL, | ||
60 | PCode INT DEFAULT NULL, | ||
61 | PathBegin INT DEFAULT NULL, | ||
62 | PathEnd INT DEFAULT NULL, | ||
63 | PathScaleX INT DEFAULT NULL, | ||
64 | PathScaleY INT DEFAULT NULL, | ||
65 | PathShearX INT DEFAULT NULL, | ||
66 | PathShearY INT DEFAULT NULL, | ||
67 | PathSkew INT DEFAULT NULL, | ||
68 | PathCurve INT DEFAULT NULL, | ||
69 | PathRadiusOffset INT DEFAULT NULL, | ||
70 | PathRevolutions INT DEFAULT NULL, | ||
71 | PathTaperX INT DEFAULT NULL, | ||
72 | PathTaperY INT DEFAULT NULL, | ||
73 | PathTwist INT DEFAULT NULL, | ||
74 | ProfileBegin INT DEFAULT NULL, | ||
75 | ProfileEnd INT DEFAULT NULL, | ||
76 | ProfileCurve INT DEFAULT NULL, | ||
77 | ProfileHollow INT DEFAULT NULL, | ||
78 | State INT DEFAULT NULL, | ||
79 | Texture BLOB, | ||
80 | ExtraParams BLOB, | ||
81 | PRIMARY KEY (UUID) | ||
82 | ); | ||
83 | |||
84 | CREATE INDEX PrimsRegionIdIndex ON Prims (RegionID); | ||
85 | CREATE INDEX PrimsRegionParentUuidIndex ON Prims (ParentUUID); | ||
86 | |||
87 | CREATE TABLE Terrain ( | ||
88 | RegionID VARCHAR(36) NOT NULL, | ||
89 | MapData BLOB, | ||
90 | PRIMARY KEY (RegionID) | ||
91 | ); | ||
92 | |||
93 | CREATE TABLE PrimItems ( | ||
94 | ItemID VARCHAR(36) NOT NULL, | ||
95 | GroupID VARCHAR(36) DEFAULT NULL, | ||
96 | PrimID VARCHAR(36) DEFAULT NULL, | ||
97 | ParentFolderID VARCHAR(36) DEFAULT NULL, | ||
98 | AssetID VARCHAR(36) DEFAULT NULL, | ||
99 | OwnerID VARCHAR(36) DEFAULT NULL, | ||
100 | LastOwnerID VARCHAR(36) DEFAULT NULL, | ||
101 | CreatorID VARCHAR(36) DEFAULT NULL, | ||
102 | CreationDate BIGINT DEFAULT NULL, | ||
103 | Type INT DEFAULT NULL, | ||
104 | InvType INT DEFAULT NULL, | ||
105 | Name VARCHAR(255) DEFAULT NULL, | ||
106 | Description VARCHAR(255) DEFAULT NULL, | ||
107 | NextPermissions INT DEFAULT NULL, | ||
108 | CurrentPermissions INT DEFAULT NULL, | ||
109 | BasePermissions INT DEFAULT NULL, | ||
110 | EveryonePermissions INT DEFAULT NULL, | ||
111 | GroupPermissions INT DEFAULT NULL, | ||
112 | Flags INT DEFAULT NULL, | ||
113 | PRIMARY KEY (ItemID) | ||
114 | ); | ||
115 | |||
116 | CREATE INDEX PrimItemsPrimIdIndex ON PrimItems (PrimID); | ||
117 | |||
118 | CREATE TABLE RegionSettings ( | ||
119 | RegionID VARCHAR(36) NOT NULL, | ||
120 | |||
121 | BlockTerraform BIT DEFAULT NULL, | ||
122 | BlockFly BIT DEFAULT NULL, | ||
123 | AllowDamage BIT DEFAULT NULL, | ||
124 | RestrictPushing BIT DEFAULT NULL, | ||
125 | AllowLandResell BIT DEFAULT NULL, | ||
126 | AllowLandJoinDivide BIT DEFAULT NULL, | ||
127 | BlockShowInSearch BIT DEFAULT NULL, | ||
128 | |||
129 | AgentLimit INT DEFAULT NULL, | ||
130 | ObjectBonus DOUBLE DEFAULT NULL, | ||
131 | Maturity INT DEFAULT NULL, | ||
132 | |||
133 | DisableScripts BIT DEFAULT NULL, | ||
134 | DisableCollisions BIT DEFAULT NULL, | ||
135 | DisablePhysics BIT DEFAULT NULL, | ||
136 | |||
137 | TerrainTexture1 VARCHAR(36) DEFAULT NULL, | ||
138 | TerrainTexture2 VARCHAR(36) DEFAULT NULL, | ||
139 | TerrainTexture3 VARCHAR(36) DEFAULT NULL, | ||
140 | TerrainTexture4 VARCHAR(36) DEFAULT NULL, | ||
141 | |||
142 | Elevation1NW DOUBLE DEFAULT NULL, | ||
143 | Elevation2NW DOUBLE DEFAULT NULL, | ||
144 | Elevation1NE DOUBLE DEFAULT NULL, | ||
145 | Elevation2NE DOUBLE DEFAULT NULL, | ||
146 | Elevation1SE DOUBLE DEFAULT NULL, | ||
147 | Elevation2SE DOUBLE DEFAULT NULL, | ||
148 | Elevation1SW DOUBLE DEFAULT NULL, | ||
149 | Elevation2SW DOUBLE DEFAULT NULL, | ||
150 | |||
151 | WaterHeight DOUBLE DEFAULT NULL, | ||
152 | TerrainRaiseLimit DOUBLE DEFAULT NULL, | ||
153 | TerrainLowerLimit DOUBLE DEFAULT NULL, | ||
154 | |||
155 | UseEstateSun BIT DEFAULT NULL, | ||
156 | Sandbox BIT DEFAULT NULL, | ||
157 | |||
158 | SunVectorX DOUBLE DEFAULT NULL, | ||
159 | SunVectorY DOUBLE DEFAULT NULL, | ||
160 | SunVectorZ DOUBLE DEFAULT NULL, | ||
161 | |||
162 | FixedSun BIT DEFAULT NULL, | ||
163 | SunPosition DOUBLE DEFAULT NULL, | ||
164 | |||
165 | Covenant VARCHAR(36) DEFAULT NULL, | ||
166 | |||
167 | PRIMARY KEY (RegionID) | ||
168 | ); | ||
diff --git a/OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_UserStore.sql b/OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_UserStore.sql deleted file mode 100644 index 6084886..0000000 --- a/OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_UserStore.sql +++ /dev/null | |||
@@ -1,104 +0,0 @@ | |||
1 | CREATE TABLE UserAgents ( | ||
2 | ProfileID VARCHAR(36) NOT NULL, | ||
3 | AgentIP VARCHAR(24) DEFAULT NULL, | ||
4 | AgentPort INT DEFAULT NULL, | ||
5 | AgentOnline BIT DEFAULT NULL, | ||
6 | SessionID VARCHAR(36) DEFAULT NULL, | ||
7 | SecureSessionID VARCHAR(36) DEFAULT NULL, | ||
8 | InitialRegion VARCHAR(255) DEFAULT NULL, | ||
9 | Region VARCHAR(255) DEFAULT NULL, | ||
10 | LoginTime INT DEFAULT NULL, | ||
11 | LogoutTime INT DEFAULT NULL, | ||
12 | Handle BIGINT DEFAULT NULL, | ||
13 | PositionX DOUBLE DEFAULT NULL, | ||
14 | PositionY DOUBLE DEFAULT NULL, | ||
15 | PositionZ DOUBLE DEFAULT NULL, | ||
16 | LookAtX DOUBLE DEFAULT NULL, | ||
17 | LookAtY DOUBLE DEFAULT NULL, | ||
18 | LookAtZ DOUBLE DEFAULT NULL, | ||
19 | PRIMARY KEY (ProfileID) | ||
20 | ); | ||
21 | |||
22 | CREATE TABLE UserProfiles ( | ||
23 | ID VARCHAR(36) NOT NULL, | ||
24 | WebLoginKey VARCHAR(36) DEFAULT NULL, | ||
25 | FirstName VARCHAR(32) DEFAULT NULL, | ||
26 | SurName VARCHAR(32) DEFAULT NULL, | ||
27 | Email VARCHAR(250) DEFAULT NULL, | ||
28 | PasswordHash VARCHAR(32) DEFAULT NULL, | ||
29 | PasswordSalt VARCHAR(32) DEFAULT NULL, | ||
30 | HomeRegionID VARCHAR(36) DEFAULT NULL, | ||
31 | HomeRegionX INT DEFAULT NULL, | ||
32 | HomeRegionY INT DEFAULT NULL, | ||
33 | HomeLocationX DOUBLE DEFAULT NULL, | ||
34 | HomeLocationY DOUBLE DEFAULT NULL, | ||
35 | HomeLocationZ DOUBLE DEFAULT NULL, | ||
36 | HomeLookAtX DOUBLE DEFAULT NULL, | ||
37 | HomeLookAtY DOUBLE DEFAULT NULL, | ||
38 | HomeLookAtZ DOUBLE DEFAULT NULL, | ||
39 | Created INT DEFAULT NULL, | ||
40 | LastLogin INT DEFAULT NULL, | ||
41 | UserInventoryURI VARCHAR(255) DEFAULT NULL, | ||
42 | UserAssetURI VARCHAR(255) DEFAULT NULL, | ||
43 | Image VARCHAR(36) DEFAULT NULL, | ||
44 | FirstLifeImage VARCHAR(36) DEFAULT NULL, | ||
45 | AboutText TEXT DEFAULT NULL, | ||
46 | FirstLifeAboutText TEXT DEFAULT NULL, | ||
47 | CanDoMask INT DEFAULT NULL, | ||
48 | WantDoMask INT DEFAULT NULL, | ||
49 | UserFlags INT DEFAULT NULL, | ||
50 | GodLevel INT DEFAULT NULL, | ||
51 | CustomType VARCHAR(32) DEFAULT NULL, | ||
52 | Partner VARCHAR(36) DEFAULT NULL, | ||
53 | RootInventoryFolderID VARCHAR(36) DEFAULT NULL, | ||
54 | PRIMARY KEY (ID) | ||
55 | ); | ||
56 | |||
57 | CREATE INDEX UserSurnameIndex ON UserProfiles (SurName); | ||
58 | CREATE INDEX UserFirstNameIndex ON UserProfiles (FirstName); | ||
59 | CREATE UNIQUE INDEX UserFullNameIndex ON UserProfiles (SurName,FirstName); | ||
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 | ); | ||
95 | |||
96 | CREATE TABLE UserFriends ( | ||
97 | UserFriendID VARCHAR(36) NOT NULL, | ||
98 | OwnerID VARCHAR(36) DEFAULT NULL, | ||
99 | FriendID VARCHAR(36) DEFAULT NULL, | ||
100 | FriendPermissions INT DEFAULT NULL, | ||
101 | PRIMARY KEY (UserFriendID) | ||
102 | ); | ||
103 | |||
104 | CREATE UNIQUE INDEX UserFriendsOwnerIdFriendIdIndex ON UserFriends (OwnerID,FriendID); | ||