aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/SQLite/Resources
diff options
context:
space:
mode:
Diffstat (limited to 'OpenSim/Data/SQLite/Resources')
-rw-r--r--OpenSim/Data/SQLite/Resources/001_GridUserStore.sql16
-rw-r--r--OpenSim/Data/SQLite/Resources/AgentPrefs.migrations36
-rw-r--r--OpenSim/Data/SQLite/Resources/AssetStore.migrations18
-rw-r--r--OpenSim/Data/SQLite/Resources/AuthStore.migrations29
-rw-r--r--OpenSim/Data/SQLite/Resources/Avatar.migrations11
-rw-r--r--OpenSim/Data/SQLite/Resources/EstateStore.migrations69
-rw-r--r--OpenSim/Data/SQLite/Resources/FriendsStore.migrations20
-rw-r--r--OpenSim/Data/SQLite/Resources/HGTravelStore.migrations18
-rw-r--r--OpenSim/Data/SQLite/Resources/RegionStore.migrations379
-rw-r--r--OpenSim/Data/SQLite/Resources/UserAccount.migrations35
-rw-r--r--OpenSim/Data/SQLite/Resources/UserProfiles.migrations102
-rw-r--r--OpenSim/Data/SQLite/Resources/XInventoryStore.migrations49
12 files changed, 782 insertions, 0 deletions
diff --git a/OpenSim/Data/SQLite/Resources/001_GridUserStore.sql b/OpenSim/Data/SQLite/Resources/001_GridUserStore.sql
new file mode 100644
index 0000000..1a24613
--- /dev/null
+++ b/OpenSim/Data/SQLite/Resources/001_GridUserStore.sql
@@ -0,0 +1,16 @@
1BEGIN TRANSACTION;
2
3CREATE TABLE GridUser (
4 UserID VARCHAR(255) primary key,
5 HomeRegionID CHAR(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000',
6 HomePosition CHAR(64) NOT NULL DEFAULT '<0,0,0>',
7 HomeLookAt CHAR(64) NOT NULL DEFAULT '<0,0,0>',
8 LastRegionID CHAR(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000',
9 LastPosition CHAR(64) NOT NULL DEFAULT '<0,0,0>',
10 LastLookAt CHAR(64) NOT NULL DEFAULT '<0,0,0>',
11 Online CHAR(5) NOT NULL DEFAULT 'false',
12 Login CHAR(16) NOT NULL DEFAULT '0',
13 Logout CHAR(16) NOT NULL DEFAULT '0'
14) ;
15
16COMMIT;
diff --git a/OpenSim/Data/SQLite/Resources/AgentPrefs.migrations b/OpenSim/Data/SQLite/Resources/AgentPrefs.migrations
new file mode 100644
index 0000000..8c2663e
--- /dev/null
+++ b/OpenSim/Data/SQLite/Resources/AgentPrefs.migrations
@@ -0,0 +1,36 @@
1:VERSION 1
2
3BEGIN TRANSACTION;
4
5CREATE TABLE `AgentPrefs` (
6 `PrincipalID` CHAR(36) NOT NULL,
7 `AccessPrefs` CHAR(2) NOT NULL DEFAULT 'M',
8 `HoverHeight` DOUBLE(30, 27) NOT NULL DEFAULT 0,
9 `Language` CHAR(5) NOT NULL DEFAULT 'en-us',
10 `LanguageIsPublic` BOOLEAN NOT NULL DEFAULT 1,
11 `PermEveryone` INT(6) NOT NULL DEFAULT 0,
12 `PermGroup` INT(6) NOT NULL DEFAULT 0,
13 `PermNextOwner` INT(6) NOT NULL DEFAULT 532480,
14 UNIQUE (`PrincipalID`),
15 PRIMARY KEY(`PrincipalID`));
16
17COMMIT;
18
19:VERSION 2
20
21BEGIN;
22
23CREATE TABLE AgentPrefs(
24 PrincipalID CHAR(36) NOT NULL,
25 AccessPrefs CHAR(2) NOT NULL DEFAULT 'M',
26 HoverHeight DOUBLE(30, 27) NOT NULL DEFAULT 0,
27 Language CHAR(5) NOT NULL DEFAULT 'en-us',
28 LanguageIsPublic BOOLEAN NOT NULL DEFAULT 1,
29 PermEveryone INT(6) NOT NULL DEFAULT 0,
30 PermGroup INT(6) NOT NULL DEFAULT 0,
31 PermNextOwner INT(6) NOT NULL DEFAULT 532480,
32 UNIQUE(PrincipalID),
33 PRIMARY KEY(PrincipalID)
34);
35
36COMMIT;
diff --git a/OpenSim/Data/SQLite/Resources/AssetStore.migrations b/OpenSim/Data/SQLite/Resources/AssetStore.migrations
new file mode 100644
index 0000000..0743c45
--- /dev/null
+++ b/OpenSim/Data/SQLite/Resources/AssetStore.migrations
@@ -0,0 +1,18 @@
1:VERSION 6
2
3BEGIN TRANSACTION;
4
5CREATE TABLE IF NOT EXISTS assets(
6 UUID NOT NULL PRIMARY KEY,
7 Name,
8 Description,
9 Type,
10 Local,
11 Temporary,
12 asset_flags INTEGER NOT NULL DEFAULT 0,
13 CreatorID varchar(128) default '',
14 Data);
15
16COMMIT;
17
18
diff --git a/OpenSim/Data/SQLite/Resources/AuthStore.migrations b/OpenSim/Data/SQLite/Resources/AuthStore.migrations
new file mode 100644
index 0000000..ca6bdf5
--- /dev/null
+++ b/OpenSim/Data/SQLite/Resources/AuthStore.migrations
@@ -0,0 +1,29 @@
1:VERSION 1
2
3BEGIN TRANSACTION;
4
5CREATE TABLE auth (
6 UUID char(36) NOT NULL,
7 passwordHash char(32) NOT NULL default '',
8 passwordSalt char(32) NOT NULL default '',
9 webLoginKey varchar(255) NOT NULL default '',
10 accountType VARCHAR(32) NOT NULL DEFAULT 'UserAccount',
11 PRIMARY KEY (`UUID`)
12);
13
14CREATE TABLE tokens (
15 UUID char(36) NOT NULL,
16 token varchar(255) NOT NULL,
17 validity datetime NOT NULL
18);
19
20COMMIT;
21
22:VERSION 2
23
24BEGIN TRANSACTION;
25
26INSERT INTO auth (UUID, passwordHash, passwordSalt, webLoginKey) SELECT `UUID` AS UUID, `passwordHash` AS passwordHash, `passwordSalt` AS passwordSalt, `webLoginKey` AS webLoginKey FROM users;
27
28COMMIT;
29
diff --git a/OpenSim/Data/SQLite/Resources/Avatar.migrations b/OpenSim/Data/SQLite/Resources/Avatar.migrations
new file mode 100644
index 0000000..13b4196
--- /dev/null
+++ b/OpenSim/Data/SQLite/Resources/Avatar.migrations
@@ -0,0 +1,11 @@
1:VERSION 1
2
3BEGIN TRANSACTION;
4
5CREATE TABLE Avatars (
6 PrincipalID CHAR(36) NOT NULL,
7 Name VARCHAR(32) NOT NULL,
8 Value VARCHAR(255) NOT NULL DEFAULT '',
9 PRIMARY KEY(PrincipalID, Name));
10
11COMMIT;
diff --git a/OpenSim/Data/SQLite/Resources/EstateStore.migrations b/OpenSim/Data/SQLite/Resources/EstateStore.migrations
new file mode 100644
index 0000000..37fa1d9
--- /dev/null
+++ b/OpenSim/Data/SQLite/Resources/EstateStore.migrations
@@ -0,0 +1,69 @@
1:VERSION 10
2
3BEGIN TRANSACTION;
4
5CREATE TABLE IF NOT EXISTS estate_groups (
6 EstateID int(10) NOT NULL,
7 uuid char(36) NOT NULL
8);
9CREATE INDEX estate_groups_estate_id on estate_groups(EstateID);
10
11CREATE TABLE IF NOT EXISTS estate_managers (
12 EstateID int(10) NOT NULL,
13 uuid char(36) NOT NULL
14);
15CREATE INDEX estate_managers_estate_id on estate_managers(EstateID);
16
17CREATE TABLE IF NOT EXISTS estate_map (
18 RegionID char(36) NOT NULL default '00000000-0000-0000-0000-000000000000',
19 EstateID int(11) NOT NULL
20);
21CREATE INDEX estate_map_estate_id on estate_map(EstateID);
22CREATE UNIQUE INDEX estate_map_region_id on estate_map(RegionID);
23
24CREATE TABLE IF NOT EXISTS estate_settings (
25 EstateID INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
26 EstateName varchar(64) default NULL,
27 AbuseEmailToEstateOwner tinyint(4) NOT NULL,
28 DenyAnonymous tinyint(4) NOT NULL,
29 ResetHomeOnTeleport tinyint(4) NOT NULL,
30 FixedSun tinyint(4) NOT NULL,
31 DenyTransacted tinyint(4) NOT NULL,
32 BlockDwell tinyint(4) NOT NULL,
33 DenyIdentified tinyint(4) NOT NULL,
34 AllowVoice tinyint(4) NOT NULL,
35 UseGlobalTime tinyint(4) NOT NULL,
36 PricePerMeter int(11) NOT NULL,
37 TaxFree tinyint(4) NOT NULL,
38 AllowDirectTeleport tinyint(4) NOT NULL,
39 RedirectGridX int(11) NOT NULL,
40 RedirectGridY int(11) NOT NULL,
41 ParentEstateID int(10) NOT NULL,
42 SunPosition double NOT NULL,
43 EstateSkipScripts tinyint(4) NOT NULL,
44 BillableFactor float NOT NULL,
45 PublicAccess tinyint(4) NOT NULL,
46 AbuseEmail varchar(255) not null default '',
47 EstateOwner varchar(36) not null default '',
48 DenyMinors tinyint not null default 0,
49 AllowLandmark tinyint not null default '1',
50 AllowParcelChanges tinyint not null default '1',
51 AllowSetHome tinyint not null default '1');
52
53CREATE TABLE IF NOT EXISTS estate_users (
54 EstateID int(10) NOT NULL,
55 uuid char(36) NOT NULL
56);
57CREATE INDEX estate_users_estate_id on estate_users(EstateID);
58
59CREATE TABLE IF NOT EXISTS estateban (
60 EstateID int(10) NOT NULL,
61 bannedUUID varchar(36) NOT NULL,
62 bannedIp varchar(16) NOT NULL,
63 bannedIpHostMask varchar(16) NOT NULL,
64 bannedNameMask varchar(64) default NULL
65);
66CREATE INDEX estate_ban_estate_id on estateban(EstateID);
67
68COMMIT;
69
diff --git a/OpenSim/Data/SQLite/Resources/FriendsStore.migrations b/OpenSim/Data/SQLite/Resources/FriendsStore.migrations
new file mode 100644
index 0000000..3eb4352
--- /dev/null
+++ b/OpenSim/Data/SQLite/Resources/FriendsStore.migrations
@@ -0,0 +1,20 @@
1:VERSION 1
2
3BEGIN TRANSACTION;
4
5CREATE TABLE `Friends` (
6 `PrincipalID` CHAR(36) NOT NULL,
7 `Friend` VARCHAR(255) NOT NULL,
8 `Flags` VARCHAR(16) NOT NULL DEFAULT 0,
9 `Offered` VARCHAR(32) NOT NULL DEFAULT 0,
10 PRIMARY KEY(`PrincipalID`, `Friend`));
11
12COMMIT;
13
14:VERSION 2
15
16BEGIN TRANSACTION;
17
18INSERT INTO `Friends` SELECT `ownerID`, `friendID`, `friendPerms`, 0 FROM `userfriends`;
19
20COMMIT;
diff --git a/OpenSim/Data/SQLite/Resources/HGTravelStore.migrations b/OpenSim/Data/SQLite/Resources/HGTravelStore.migrations
new file mode 100644
index 0000000..02612ce
--- /dev/null
+++ b/OpenSim/Data/SQLite/Resources/HGTravelStore.migrations
@@ -0,0 +1,18 @@
1:VERSION 2 # --------------------------
2
3BEGIN;
4
5CREATE TABLE hg_traveling_data(
6 SessionID VARCHAR(36) NOT NULL,
7 UserID VARCHAR(36) NOT NULL,
8 GridExternalName VARCHAR(255) NOT NULL DEFAULT "",
9 ServiceToken VARCHAR(255) NOT NULL DEFAULT "",
10 ClientIPAddress VARCHAR(16) NOT NULL DEFAULT "",
11 MyIPAddress VARCHAR(16) NOT NULL DEFAULT "",
12 TMStamp TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
13 PRIMARY KEY(SessionID),
14 UNIQUE(UserID)
15);
16
17COMMIT;
18
diff --git a/OpenSim/Data/SQLite/Resources/RegionStore.migrations b/OpenSim/Data/SQLite/Resources/RegionStore.migrations
new file mode 100644
index 0000000..fb154cf
--- /dev/null
+++ b/OpenSim/Data/SQLite/Resources/RegionStore.migrations
@@ -0,0 +1,379 @@
1:VERSION 31
2
3BEGIN TRANSACTION;
4
5CREATE TABLE IF NOT EXISTS prims(
6 UUID varchar(255) primary key,
7 RegionUUID varchar(255),
8 CreationDate integer,
9 Name varchar(255),
10 SceneGroupID varchar(255),
11 Text varchar(255),
12 Description varchar(255),
13 SitName varchar(255),
14 TouchName varchar(255),
15 CreatorID varchar(255),
16 OwnerID varchar(255),
17 GroupID varchar(255),
18 LastOwnerID varchar(255),
19 OwnerMask integer,
20 NextOwnerMask integer,
21 GroupMask integer,
22 EveryoneMask integer,
23 BaseMask integer,
24 PositionX float,
25 PositionY float,
26 PositionZ float,
27 GroupPositionX float,
28 GroupPositionY float,
29 GroupPositionZ float,
30 VelocityX float,
31 VelocityY float,
32 VelocityZ float,
33 AngularVelocityX float,
34 AngularVelocityY float,
35 AngularVelocityZ float,
36 AccelerationX float,
37 AccelerationY float,
38 AccelerationZ float,
39 RotationX float,
40 RotationY float,
41 RotationZ float,
42 RotationW float,
43 ObjectFlags integer,
44 SitTargetOffsetX float NOT NULL default 0,
45 SitTargetOffsetY float NOT NULL default 0,
46 SitTargetOffsetZ float NOT NULL default 0,
47 SitTargetOrientW float NOT NULL default 0,
48 SitTargetOrientX float NOT NULL default 0,
49 SitTargetOrientY float NOT NULL default 0,
50 SitTargetOrientZ float NOT NULL default 0,
51 ColorR integer not null default 0,
52 ColorG integer not null default 0,
53 ColorB integer not null default 0,
54 ColorA integer not null default 0,
55 ClickAction integer not null default 0,
56 PayPrice integer not null default 0,
57 PayButton1 integer not null default 0,
58 PayButton2 integer not null default 0,
59 PayButton3 integer not null default 0,
60 PayButton4 integer not null default 0,
61 LoopedSound varchar(36) NOT NULL default '00000000-0000-0000-0000-000000000000',
62 LoopedSoundGain float NOT NULL default 0,
63 TextureAnimation string,
64 ParticleSystem string,
65 OmegaX float NOT NULL default 0,
66 OmegaY float NOT NULL default 0,
67 OmegaZ float NOT NULL default 0,
68 CameraEyeOffsetX float NOT NULL default 0,
69 CameraEyeOffsetY float NOT NULL default 0,
70 CameraEyeOffsetZ float NOT NULL default 0,
71 CameraAtOffsetX float NOT NULL default 0,
72 CameraAtOffsetY float NOT NULL default 0,
73 CameraAtOffsetZ float NOT NULL default 0,
74 ForceMouselook string NOT NULL default 0,
75 ScriptAccessPin INTEGER NOT NULL default 0,
76 AllowedDrop INTEGER NOT NULL default 0,
77 DieAtEdge string NOT NULL default 0,
78 SalePrice INTEGER NOT NULL default 0,
79 SaleType string NOT NULL default 0,
80 Material INTEGER NOT NULL default 3,
81 CollisionSound varchar(36) NOT NULL default '00000000-0000-0000-0000-000000000000',
82 CollisionSoundVolume float NOT NULL default 0,
83 VolumeDetect INTEGER NOT NULL DEFAULT 0,
84 MediaURL varchar(255),
85 DynAttrs TEXT,
86 `PhysicsShapeType` tinyint(4) NOT NULL default '0',
87 `Density` double NOT NULL default '1000',
88 `GravityModifier` double NOT NULL default '1',
89 `Friction` double NOT NULL default '0.6',
90 `Restitution` double NOT NULL default '0.5',
91 `KeyframeMotion` blob,
92 AttachedPosX double default '0',
93 AttachedPosY double default '0',
94 AttachedPosZ double default '0');
95
96CREATE TABLE IF NOT EXISTS primshapes(
97 UUID varchar(255) primary key,
98 Shape integer,
99 ScaleX float,
100 ScaleY float,
101 ScaleZ float,
102 PCode integer,
103 PathBegin integer,
104 PathEnd integer,
105 PathScaleX integer,
106 PathScaleY integer,
107 PathShearX integer,
108 PathShearY integer,
109 PathSkew integer,
110 PathCurve integer,
111 PathRadiusOffset integer,
112 PathRevolutions integer,
113 PathTaperX integer,
114 PathTaperY integer,
115 PathTwist integer,
116 PathTwistBegin integer,
117 ProfileBegin integer,
118 ProfileEnd integer,
119 ProfileCurve integer,
120 ProfileHollow integer,
121 Texture blob,
122 ExtraParams blob,
123 State Integer NOT NULL default 0,
124 Media TEXT,
125 LastAttachPoint int not null default '0');
126
127CREATE TABLE IF NOT EXISTS primitems(
128 itemID varchar(255) primary key,
129 primID varchar(255),
130 assetID varchar(255),
131 parentFolderID varchar(255),
132 invType integer,
133 assetType integer,
134 name varchar(255),
135 description varchar(255),
136 creationDate integer,
137 creatorID varchar(255),
138 ownerID varchar(255),
139 lastOwnerID varchar(255),
140 groupID varchar(255),
141 nextPermissions string,
142 currentPermissions string,
143 basePermissions string,
144 everyonePermissions string,
145 groupPermissions string,
146 flags integer not null default 0);
147
148CREATE TABLE IF NOT EXISTS terrain(
149 RegionUUID varchar(255),
150 Revision integer,
151 Heightfield blob);
152
153CREATE TABLE IF NOT EXISTS land(
154 UUID varchar(255) primary key,
155 RegionUUID varchar(255),
156 LocalLandID string,
157 Bitmap blob,
158 Name varchar(255),
159 Desc varchar(255),
160 OwnerUUID varchar(255),
161 IsGroupOwned string,
162 Area integer,
163 AuctionID integer,
164 Category integer,
165 ClaimDate integer,
166 ClaimPrice integer,
167 GroupUUID varchar(255),
168 SalePrice integer,
169 LandStatus integer,
170 LandFlags string,
171 LandingType string,
172 MediaAutoScale string,
173 MediaTextureUUID varchar(255),
174 MediaURL varchar(255),
175 MusicURL varchar(255),
176 PassHours float,
177 PassPrice string,
178 SnapshotUUID varchar(255),
179 UserLocationX float,
180 UserLocationY float,
181 UserLocationZ float,
182 UserLookAtX float,
183 UserLookAtY float,
184 UserLookAtZ float,
185 AuthbuyerID varchar(36) NOT NULL default '00000000-0000-0000-0000-000000000000',
186 OtherCleanTime INTEGER NOT NULL default 0,
187 Dwell INTEGER NOT NULL default 0,
188 `MediaType` VARCHAR(32) NOT NULL DEFAULT 'none/none',
189 `MediaDescription` VARCHAR(255) NOT NULL DEFAULT '',
190 `MediaSize` VARCHAR(16) NOT NULL DEFAULT '0,0',
191 `MediaLoop` BOOLEAN NOT NULL DEFAULT FALSE,
192 `ObscureMusic` BOOLEAN NOT NULL DEFAULT FALSE,
193 `ObscureMedia` BOOLEAN NOT NULL DEFAULT FALSE);
194
195CREATE TABLE IF NOT EXISTS landaccesslist(
196 LandUUID varchar(255),
197 AccessUUID varchar(255),
198 Flags string);
199
200CREATE TABLE IF NOT EXISTS regionban(
201 regionUUID varchar (255),
202 bannedUUID varchar (255),
203 bannedIp varchar (255),
204 bannedIpHostMask varchar (255)
205 );
206
207CREATE TABLE IF NOT EXISTS regionsettings (
208 regionUUID char(36) NOT NULL,
209 block_terraform int(11) NOT NULL,
210 block_fly int(11) NOT NULL,
211 allow_damage int(11) NOT NULL,
212 restrict_pushing int(11) NOT NULL,
213 allow_land_resell int(11) NOT NULL,
214 allow_land_join_divide int(11) NOT NULL,
215 block_show_in_search int(11) NOT NULL,
216 agent_limit int(11) NOT NULL,
217 object_bonus float NOT NULL,
218 maturity int(11) NOT NULL,
219 disable_scripts int(11) NOT NULL,
220 disable_collisions int(11) NOT NULL,
221 disable_physics int(11) NOT NULL,
222 terrain_texture_1 char(36) NOT NULL,
223 terrain_texture_2 char(36) NOT NULL,
224 terrain_texture_3 char(36) NOT NULL,
225 terrain_texture_4 char(36) NOT NULL,
226 elevation_1_nw float NOT NULL,
227 elevation_2_nw float NOT NULL,
228 elevation_1_ne float NOT NULL,
229 elevation_2_ne float NOT NULL,
230 elevation_1_se float NOT NULL,
231 elevation_2_se float NOT NULL,
232 elevation_1_sw float NOT NULL,
233 elevation_2_sw float NOT NULL,
234 water_height float NOT NULL,
235 terrain_raise_limit float NOT NULL,
236 terrain_lower_limit float NOT NULL,
237 use_estate_sun int(11) NOT NULL,
238 fixed_sun int(11) NOT NULL,
239 sun_position float NOT NULL,
240 covenant char(36) default NULL,
241 sandbox tinyint(4) NOT NULL,
242 sunvectorx double NOT NULL default 0,
243 sunvectory double NOT NULL default 0,
244 sunvectorz double NOT NULL default 0,
245 map_tile_ID varchar(36) NOT NULL default '00000000-0000-0000-0000-000000000000',
246 covenant_datetime INTEGER NOT NULL default 0,
247 `TelehubObject` varchar(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000',
248 `parcel_tile_ID` char(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000',
249 PRIMARY KEY (regionUUID)
250);
251
252CREATE TABLE IF NOT EXISTS regionwindlight (
253 region_id VARCHAR(36) NOT NULL DEFAULT '000000-0000-0000-0000-000000000000' PRIMARY KEY,
254 water_color_r FLOAT NOT NULL DEFAULT '4.000000',
255 water_color_g FLOAT NOT NULL DEFAULT '38.000000',
256 water_color_b FLOAT NOT NULL DEFAULT '64.000000',
257 water_color_i FLOAT NOT NULL DEFAULT '1.000000',
258 water_fog_density_exponent FLOAT NOT NULL DEFAULT '4.0',
259 underwater_fog_modifier FLOAT NOT NULL DEFAULT '0.25',
260 reflection_wavelet_scale_1 FLOAT NOT NULL DEFAULT '2.0',
261 reflection_wavelet_scale_2 FLOAT NOT NULL DEFAULT '2.0',
262 reflection_wavelet_scale_3 FLOAT NOT NULL DEFAULT '2.0',
263 fresnel_scale FLOAT NOT NULL DEFAULT '0.40',
264 fresnel_offset FLOAT NOT NULL DEFAULT '0.50',
265 refract_scale_above FLOAT NOT NULL DEFAULT '0.03',
266 refract_scale_below FLOAT NOT NULL DEFAULT '0.20',
267 blur_multiplier FLOAT NOT NULL DEFAULT '0.040',
268 big_wave_direction_x FLOAT NOT NULL DEFAULT '1.05',
269 big_wave_direction_y FLOAT NOT NULL DEFAULT '-0.42',
270 little_wave_direction_x FLOAT NOT NULL DEFAULT '1.11',
271 little_wave_direction_y FLOAT NOT NULL DEFAULT '-1.16',
272 normal_map_texture VARCHAR(36) NOT NULL DEFAULT '822ded49-9a6c-f61c-cb89-6df54f42cdf4',
273 horizon_r FLOAT NOT NULL DEFAULT '0.25',
274 horizon_g FLOAT NOT NULL DEFAULT '0.25',
275 horizon_b FLOAT NOT NULL DEFAULT '0.32',
276 horizon_i FLOAT NOT NULL DEFAULT '0.32',
277 haze_horizon FLOAT NOT NULL DEFAULT '0.19',
278 blue_density_r FLOAT NOT NULL DEFAULT '0.12',
279 blue_density_g FLOAT NOT NULL DEFAULT '0.22',
280 blue_density_b FLOAT NOT NULL DEFAULT '0.38',
281 blue_density_i FLOAT NOT NULL DEFAULT '0.38',
282 haze_density FLOAT NOT NULL DEFAULT '0.70',
283 density_multiplier FLOAT NOT NULL DEFAULT '0.18',
284 distance_multiplier FLOAT NOT NULL DEFAULT '0.8',
285 max_altitude INTEGER NOT NULL DEFAULT '1605',
286 sun_moon_color_r FLOAT NOT NULL DEFAULT '0.24',
287 sun_moon_color_g FLOAT NOT NULL DEFAULT '0.26',
288 sun_moon_color_b FLOAT NOT NULL DEFAULT '0.30',
289 sun_moon_color_i FLOAT NOT NULL DEFAULT '0.30',
290 sun_moon_position FLOAT NOT NULL DEFAULT '0.317',
291 ambient_r FLOAT NOT NULL DEFAULT '0.35',
292 ambient_g FLOAT NOT NULL DEFAULT '0.35',
293 ambient_b FLOAT NOT NULL DEFAULT '0.35',
294 ambient_i FLOAT NOT NULL DEFAULT '0.35',
295 east_angle FLOAT NOT NULL DEFAULT '0.00',
296 sun_glow_focus FLOAT NOT NULL DEFAULT '0.10',
297 sun_glow_size FLOAT NOT NULL DEFAULT '1.75',
298 scene_gamma FLOAT NOT NULL DEFAULT '1.00',
299 star_brightness FLOAT NOT NULL DEFAULT '0.00',
300 cloud_color_r FLOAT NOT NULL DEFAULT '0.41',
301 cloud_color_g FLOAT NOT NULL DEFAULT '0.41',
302 cloud_color_b FLOAT NOT NULL DEFAULT '0.41',
303 cloud_color_i FLOAT NOT NULL DEFAULT '0.41',
304 cloud_x FLOAT NOT NULL DEFAULT '1.00',
305 cloud_y FLOAT NOT NULL DEFAULT '0.53',
306 cloud_density FLOAT NOT NULL DEFAULT '1.00',
307 cloud_coverage FLOAT NOT NULL DEFAULT '0.27',
308 cloud_scale FLOAT NOT NULL DEFAULT '0.42',
309 cloud_detail_x FLOAT NOT NULL DEFAULT '1.00',
310 cloud_detail_y FLOAT NOT NULL DEFAULT '0.53',
311 cloud_detail_density FLOAT NOT NULL DEFAULT '0.12',
312 cloud_scroll_x FLOAT NOT NULL DEFAULT '0.20',
313 cloud_scroll_x_lock INTEGER NOT NULL DEFAULT '0',
314 cloud_scroll_y FLOAT NOT NULL DEFAULT '0.01',
315 cloud_scroll_y_lock INTEGER NOT NULL DEFAULT '0',
316 draw_classic_clouds INTEGER NOT NULL DEFAULT '1');
317
318CREATE TABLE IF NOT EXISTS `spawn_points` (
319 `RegionID` varchar(36) NOT NULL DEFAULT '000000-0000-0000-0000-000000000000',
320 `Yaw` float NOT NULL,
321 `Pitch` float NOT NULL,
322 `Distance` float NOT NULL
323);
324
325CREATE TABLE IF NOT EXISTS `regionenvironment` (
326 `region_id` varchar(36) NOT NULL DEFAULT '000000-0000-0000-0000-000000000000' PRIMARY KEY,
327 `llsd_settings` TEXT NOT NULL
328);
329
330COMMIT;
331
332
333:VERSION 32 #---- avination fields plus a few others
334
335BEGIN;
336
337ALTER TABLE `prims` ADD COLUMN `PassTouches` BOOLEAN NOT NULL DEFAULT FALSE;
338ALTER TABLE `prims` ADD COLUMN `PassCollisions`BOOLEAN NOT NULL DEFAULT FALSE;
339ALTER TABLE `prims` ADD COLUMN `Vehicle` TEXT default NULL;
340ALTER TABLE `regionsettings` ADD COLUMN `block_search` BOOLEAN NOT NULL DEFAULT FALSE;;
341ALTER TABLE `regionsettings` ADD COLUMN `casino` BOOLEAN NOT NULL DEFAULT FALSE;;
342ALTER TABLE `land` ADD COLUMN `SeeAVs` BOOLEAN NOT NULL DEFAULT TRUE;
343ALTER TABLE `land` ADD COLUMN `AnyAVSounds` BOOLEAN NOT NULL DEFAULT TRUE;
344ALTER TABLE `land` ADD COLUMN `GroupAVSounds` BOOLEAN NOT NULL DEFAULT TRUE;
345
346COMMIT;
347
348:VERSION 33 #---- Rotation axis locks
349
350BEGIN;
351
352ALTER TABLE prims ADD COLUMN `RotationAxisLocks` tinyint(4) NOT NULL default '0';
353
354COMMIT;
355
356:VERSION 34 #---- add baked terrain store
357
358BEGIN;
359
360CREATE TABLE IF NOT EXISTS bakedterrain(
361 RegionUUID varchar(255),
362 Revision integer,
363 Heightfield blob);
364
365COMMIT;
366
367:VERSION 35 #----- Add RezzerID field in table prims
368
369BEGIN;
370
371ALTER TABLE `prims` ADD COLUMN `RezzerID` char(36) DEFAULT NULL;
372
373COMMIT;
374
375:VERSION 36 #----- Add physics inertia data
376
377BEGIN;
378ALTER TABLE `prims` ADD COLUMN `PhysInertia` TEXT default NULL;
379COMMIT;
diff --git a/OpenSim/Data/SQLite/Resources/UserAccount.migrations b/OpenSim/Data/SQLite/Resources/UserAccount.migrations
new file mode 100644
index 0000000..f37a222
--- /dev/null
+++ b/OpenSim/Data/SQLite/Resources/UserAccount.migrations
@@ -0,0 +1,35 @@
1:VERSION 1
2
3BEGIN TRANSACTION;
4
5-- useraccounts table
6CREATE TABLE UserAccounts (
7 PrincipalID CHAR(36) primary key,
8 ScopeID CHAR(36) NOT NULL,
9 FirstName VARCHAR(64) NOT NULL,
10 LastName VARCHAR(64) NOT NULL,
11 Email VARCHAR(64),
12 ServiceURLs TEXT,
13 Created INT(11),
14 UserLevel integer NOT NULL DEFAULT 0,
15 UserFlags integer NOT NULL DEFAULT 0,
16 UserTitle varchar(64) NOT NULL DEFAULT ''
17);
18
19COMMIT;
20
21:VERSION 2
22
23BEGIN TRANSACTION;
24
25INSERT INTO UserAccounts (PrincipalID, ScopeID, FirstName, LastName, Email, ServiceURLs, Created) SELECT `UUID` AS PrincipalID, '00000000-0000-0000-0000-000000000000' AS ScopeID, username AS FirstName, surname AS LastName, '' as Email, '' AS ServiceURLs, created as Created FROM users;
26
27COMMIT;
28
29:VERSION 3 # -------------------------
30
31BEGIN;
32
33ALTER TABLE `UserAccounts` ADD `active` BOOLEAN NOT NULL DEFAULT TRUE;
34
35COMMIT; \ No newline at end of file
diff --git a/OpenSim/Data/SQLite/Resources/UserProfiles.migrations b/OpenSim/Data/SQLite/Resources/UserProfiles.migrations
new file mode 100644
index 0000000..207dde0
--- /dev/null
+++ b/OpenSim/Data/SQLite/Resources/UserProfiles.migrations
@@ -0,0 +1,102 @@
1:VERSION 1 # -------------------------------
2
3begin;
4
5CREATE TABLE IF NOT EXISTS classifieds (
6 classifieduuid char(36) NOT NULL PRIMARY KEY,
7 creatoruuid char(36) NOT NULL,
8 creationdate int(20) NOT NULL,
9 expirationdate int(20) NOT NULL,
10 category varchar(20) NOT NULL,
11 name varchar(255) NOT NULL,
12 description text NOT NULL,
13 parceluuid char(36) NOT NULL,
14 parentestate int(11) NOT NULL,
15 snapshotuuid char(36) NOT NULL,
16 simname varchar(255) NOT NULL,
17 posglobal varchar(255) NOT NULL,
18 parcelname varchar(255) NOT NULL,
19 classifiedflags int(8) NOT NULL,
20 priceforlisting int(5) NOT NULL
21);
22
23commit;
24
25begin;
26
27CREATE TABLE IF NOT EXISTS usernotes (
28 useruuid varchar(36) NOT NULL,
29 targetuuid varchar(36) NOT NULL,
30 notes text NOT NULL,
31 UNIQUE (useruuid,targetuuid) ON CONFLICT REPLACE
32);
33
34commit;
35
36begin;
37
38CREATE TABLE IF NOT EXISTS userpicks (
39 pickuuid varchar(36) NOT NULL PRIMARY KEY,
40 creatoruuid varchar(36) NOT NULL,
41 toppick int NOT NULL,
42 parceluuid varchar(36) NOT NULL,
43 name varchar(255) NOT NULL,
44 description text NOT NULL,
45 snapshotuuid varchar(36) NOT NULL,
46 user varchar(255) NOT NULL,
47 originalname varchar(255) NOT NULL,
48 simname varchar(255) NOT NULL,
49 posglobal varchar(255) NOT NULL,
50 sortorder int(2) NOT NULL,
51 enabled int NOT NULL
52);
53
54commit;
55
56begin;
57
58CREATE TABLE IF NOT EXISTS userprofile (
59 useruuid varchar(36) NOT NULL PRIMARY KEY,
60 profilePartner varchar(36) NOT NULL,
61 profileAllowPublish binary(1) NOT NULL,
62 profileMaturePublish binary(1) NOT NULL,
63 profileURL varchar(255) NOT NULL,
64 profileWantToMask int(3) NOT NULL,
65 profileWantToText text NOT NULL,
66 profileSkillsMask int(3) NOT NULL,
67 profileSkillsText text NOT NULL,
68 profileLanguages text NOT NULL,
69 profileImage varchar(36) NOT NULL,
70 profileAboutText text NOT NULL,
71 profileFirstImage varchar(36) NOT NULL,
72 profileFirstText text NOT NULL
73);
74
75commit;
76
77:VERSION 2 # -------------------------------
78
79begin;
80
81CREATE TABLE IF NOT EXISTS userdata (
82 UserId char(36) NOT NULL,
83 TagId varchar(64) NOT NULL,
84 DataKey varchar(255),
85 DataVal varchar(255),
86 PRIMARY KEY (UserId,TagId)
87);
88
89commit;
90
91
92:VERSION 3 # -------------------------------
93
94begin;
95CREATE TABLE IF NOT EXISTS usersettings (
96 useruuid char(36) NOT NULL,
97 imviaemail binary(1) NOT NULL,
98 visible binary(1) NOT NULL,
99 email varchar(254) NOT NULL,
100 PRIMARY KEY (useruuid)
101)
102commit;
diff --git a/OpenSim/Data/SQLite/Resources/XInventoryStore.migrations b/OpenSim/Data/SQLite/Resources/XInventoryStore.migrations
new file mode 100644
index 0000000..de44982
--- /dev/null
+++ b/OpenSim/Data/SQLite/Resources/XInventoryStore.migrations
@@ -0,0 +1,49 @@
1:VERSION 1
2
3BEGIN TRANSACTION;
4
5CREATE TABLE inventoryfolders(
6 folderName varchar(64),
7 type integer,
8 version integer,
9 folderID varchar(36) primary key,
10 agentID varchar(36) not null default '00000000-0000-0000-0000-000000000000',
11 parentFolderID varchar(36) not null default '00000000-0000-0000-0000-000000000000');
12
13CREATE TABLE inventoryitems(
14 assetID varchar(36),
15 assetType integer,
16 inventoryName varchar(64),
17 inventoryDescription varchar(128),
18 inventoryNextPermissions integer,
19 inventoryCurrentPermissions integer,
20 invType integer,
21 creatorID varchar(128),
22 inventoryBasePermissions integer,
23 inventoryEveryOnePermissions integer,
24 salePrice integer default 99,
25 saleType integer default 0,
26 creationDate integer default 2000,
27 groupID varchar(36) default '00000000-0000-0000-0000-000000000000',
28 groupOwned integer default 0,
29 flags integer default 0,
30 inventoryID varchar(36) primary key,
31 parentFolderID varchar(36) not null default '00000000-0000-0000-0000-000000000000',
32 avatarID varchar(36) not null default '00000000-0000-0000-0000-000000000000',
33 inventoryGroupPermissions integer not null default 0);
34
35create index inventoryfolders_agentid on inventoryfolders(agentID);
36create index inventoryfolders_parentid on inventoryfolders(parentFolderID);
37create index inventoryitems_parentfolderid on inventoryitems(parentFolderID);
38create index inventoryitems_avatarid on inventoryitems(avatarID);
39
40COMMIT;
41
42:VERSION 2
43
44BEGIN TRANSACTION;
45
46INSERT INTO inventoryfolders (folderName, type, version, folderID, agentID, parentFolderID) SELECT `name` AS folderName, `type` AS type, `version` AS version, `UUID` AS folderID, `agentID` AS agentID, `parentID` AS parentFolderID from old.inventoryfolders;
47INSERT INTO inventoryitems (assetID, assetType, inventoryName, inventoryDescription, inventoryNextPermissions, inventoryCurrentPermissions, invType, creatorID, inventoryBasePermissions, inventoryEveryOnePermissions, salePrice, saleType, creationDate, groupID, groupOwned, flags, inventoryID, parentFolderID, avatarID, inventoryGroupPermissions) SELECT `assetID`, `assetType` AS assetType, `inventoryName` AS inventoryName, `inventoryDescription` AS inventoryDescription, `inventoryNextPermissions` AS inventoryNextPermissions, `inventoryCurrentPermissions` AS inventoryCurrentPermissions, `invType` AS invType, `creatorsID` AS creatorID, `inventoryBasePermissions` AS inventoryBasePermissions, `inventoryEveryOnePermissions` AS inventoryEveryOnePermissions, `salePrice` AS salePrice, `saleType` AS saleType, `creationDate` AS creationDate, `groupID` AS groupID, `groupOwned` AS groupOwned, `flags` AS flags, `UUID` AS inventoryID, `parentFolderID` AS parentFolderID, `avatarID` AS avatarID, `inventoryGroupPermissions` AS inventoryGroupPermissions FROM old.inventoryitems;
48
49COMMIT;
generated by cgit v1.1 at 2025-01-15 19:34:24 +0000