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/AgentPrefs.migrations2
-rw-r--r--OpenSim/Data/SQLite/Resources/AssetStore.migrations71
-rw-r--r--OpenSim/Data/SQLite/Resources/EstateStore.migrations68
-rw-r--r--OpenSim/Data/SQLite/Resources/InventoryStore.migrations92
-rw-r--r--OpenSim/Data/SQLite/Resources/RegionStore.migrations549
-rw-r--r--OpenSim/Data/SQLite/Resources/UserAccount.migrations8
-rw-r--r--OpenSim/Data/SQLite/Resources/UserProfiles.migrations2
-rw-r--r--OpenSim/Data/SQLite/Resources/UserStore.migrations169
8 files changed, 198 insertions, 763 deletions
diff --git a/OpenSim/Data/SQLite/Resources/AgentPrefs.migrations b/OpenSim/Data/SQLite/Resources/AgentPrefs.migrations
index 7e0525d..8c2663e 100644
--- a/OpenSim/Data/SQLite/Resources/AgentPrefs.migrations
+++ b/OpenSim/Data/SQLite/Resources/AgentPrefs.migrations
@@ -11,7 +11,7 @@ CREATE TABLE `AgentPrefs` (
11 `PermEveryone` INT(6) NOT NULL DEFAULT 0, 11 `PermEveryone` INT(6) NOT NULL DEFAULT 0,
12 `PermGroup` INT(6) NOT NULL DEFAULT 0, 12 `PermGroup` INT(6) NOT NULL DEFAULT 0,
13 `PermNextOwner` INT(6) NOT NULL DEFAULT 532480, 13 `PermNextOwner` INT(6) NOT NULL DEFAULT 532480,
14 UNIQUE KEY `PrincipalID` (`PrincipalID`), 14 UNIQUE (`PrincipalID`),
15 PRIMARY KEY(`PrincipalID`)); 15 PRIMARY KEY(`PrincipalID`));
16 16
17COMMIT; 17COMMIT;
diff --git a/OpenSim/Data/SQLite/Resources/AssetStore.migrations b/OpenSim/Data/SQLite/Resources/AssetStore.migrations
index f20631c..0743c45 100644
--- a/OpenSim/Data/SQLite/Resources/AssetStore.migrations
+++ b/OpenSim/Data/SQLite/Resources/AssetStore.migrations
@@ -1,66 +1,17 @@
1:VERSION 1 1:VERSION 6
2 2
3BEGIN TRANSACTION; 3BEGIN TRANSACTION;
4CREATE TABLE assets(
5 UUID varchar(255) primary key,
6 Name varchar(255),
7 Description varchar(255),
8 Type integer,
9 InvType integer,
10 Local integer,
11 Temporary integer,
12 Data blob);
13 4
14COMMIT; 5CREATE TABLE IF NOT EXISTS assets(
15 6 UUID NOT NULL PRIMARY KEY,
16:VERSION 2 7 Name,
17 8 Description,
18BEGIN TRANSACTION; 9 Type,
19 10 Local,
20CREATE TEMPORARY TABLE assets_backup(UUID,Name,Description,Type,Local,Temporary,Data); 11 Temporary,
21INSERT INTO assets_backup SELECT UUID,Name,Description,Type,Local,Temporary,Data FROM assets; 12 asset_flags INTEGER NOT NULL DEFAULT 0,
22DROP TABLE assets; 13 CreatorID varchar(128) default '',
23CREATE TABLE assets(UUID,Name,Description,Type,Local,Temporary,Data); 14 Data);
24INSERT INTO assets SELECT UUID,Name,Description,Type,Local,Temporary,Data FROM assets_backup;
25DROP TABLE assets_backup;
26
27COMMIT;
28
29:VERSION 3
30
31DELETE FROM assets WHERE UUID = 'dc4b9f0bd00845c696a401dd947ac621'
32
33:VERSION 4
34
35BEGIN;
36
37update assets
38 set UUID = substr(UUID, 1, 8) || "-" || substr(UUID, 9, 4) || "-" || substr(UUID, 13, 4) || "-" || substr(UUID, 17, 4) || "-" || substr(UUID, 21, 12)
39 where UUID not like '%-%';
40
41COMMIT;
42
43:VERSION 5
44
45BEGIN TRANSACTION;
46
47CREATE TEMPORARY TABLE assets_backup(UUID,Name,Description,Type,Local,Temporary,Data);
48INSERT INTO assets_backup SELECT UUID,Name,Description,Type,Local,Temporary,Data FROM assets;
49DROP TABLE assets;
50CREATE TABLE assets(
51 UUID NOT NULL PRIMARY KEY,
52 Name,
53 Description,
54 Type,
55 Local,
56 Temporary,
57 asset_flags INTEGER NOT NULL DEFAULT 0,
58 CreatorID varchar(128) default '',
59 Data);
60
61INSERT INTO assets(UUID,Name,Description,Type,Local,Temporary,Data)
62SELECT UUID,Name,Description,Type,Local,Temporary,Data FROM assets_backup;
63DROP TABLE assets_backup;
64 15
65COMMIT; 16COMMIT;
66 17
diff --git a/OpenSim/Data/SQLite/Resources/EstateStore.migrations b/OpenSim/Data/SQLite/Resources/EstateStore.migrations
index 0aec49b..37fa1d9 100644
--- a/OpenSim/Data/SQLite/Resources/EstateStore.migrations
+++ b/OpenSim/Data/SQLite/Resources/EstateStore.migrations
@@ -1,23 +1,27 @@
1:VERSION 6 1:VERSION 10
2 2
3BEGIN TRANSACTION; 3BEGIN TRANSACTION;
4 4
5CREATE TABLE estate_groups ( 5CREATE TABLE IF NOT EXISTS estate_groups (
6 EstateID int(10) NOT NULL, 6 EstateID int(10) NOT NULL,
7 uuid char(36) NOT NULL 7 uuid char(36) NOT NULL
8); 8);
9CREATE INDEX estate_groups_estate_id on estate_groups(EstateID);
9 10
10CREATE TABLE estate_managers ( 11CREATE TABLE IF NOT EXISTS estate_managers (
11 EstateID int(10) NOT NULL, 12 EstateID int(10) NOT NULL,
12 uuid char(36) NOT NULL 13 uuid char(36) NOT NULL
13); 14);
15CREATE INDEX estate_managers_estate_id on estate_managers(EstateID);
14 16
15CREATE TABLE estate_map ( 17CREATE TABLE IF NOT EXISTS estate_map (
16 RegionID char(36) NOT NULL default '00000000-0000-0000-0000-000000000000', 18 RegionID char(36) NOT NULL default '00000000-0000-0000-0000-000000000000',
17 EstateID int(11) NOT NULL 19 EstateID int(11) NOT NULL
18); 20);
21CREATE INDEX estate_map_estate_id on estate_map(EstateID);
22CREATE UNIQUE INDEX estate_map_region_id on estate_map(RegionID);
19 23
20CREATE TABLE estate_settings ( 24CREATE TABLE IF NOT EXISTS estate_settings (
21 EstateID INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, 25 EstateID INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
22 EstateName varchar(64) default NULL, 26 EstateName varchar(64) default NULL,
23 AbuseEmailToEstateOwner tinyint(4) NOT NULL, 27 AbuseEmailToEstateOwner tinyint(4) NOT NULL,
@@ -38,60 +42,28 @@ CREATE TABLE estate_settings (
38 SunPosition double NOT NULL, 42 SunPosition double NOT NULL,
39 EstateSkipScripts tinyint(4) NOT NULL, 43 EstateSkipScripts tinyint(4) NOT NULL,
40 BillableFactor float NOT NULL, 44 BillableFactor float NOT NULL,
41 PublicAccess tinyint(4) NOT NULL 45 PublicAccess tinyint(4) NOT NULL,
42); 46 AbuseEmail varchar(255) not null default '',
43 47 EstateOwner varchar(36) not null default '',
44insert into estate_settings ( 48 DenyMinors tinyint not null default 0,
45 EstateID,EstateName,AbuseEmailToEstateOwner,DenyAnonymous,ResetHomeOnTeleport,FixedSun,DenyTransacted,BlockDwell,DenyIdentified,AllowVoice,UseGlobalTime,PricePerMeter,TaxFree,AllowDirectTeleport,RedirectGridX,RedirectGridY,ParentEstateID,SunPosition,PublicAccess,EstateSkipScripts,BillableFactor) 49 AllowLandmark tinyint not null default '1',
46 values ( 99, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''); 50 AllowParcelChanges tinyint not null default '1',
47delete from estate_settings; 51 AllowSetHome tinyint not null default '1');
48 52
49CREATE TABLE estate_users ( 53CREATE TABLE IF NOT EXISTS estate_users (
50 EstateID int(10) NOT NULL, 54 EstateID int(10) NOT NULL,
51 uuid char(36) NOT NULL 55 uuid char(36) NOT NULL
52); 56);
57CREATE INDEX estate_users_estate_id on estate_users(EstateID);
53 58
54CREATE TABLE estateban ( 59CREATE TABLE IF NOT EXISTS estateban (
55 EstateID int(10) NOT NULL, 60 EstateID int(10) NOT NULL,
56 bannedUUID varchar(36) NOT NULL, 61 bannedUUID varchar(36) NOT NULL,
57 bannedIp varchar(16) NOT NULL, 62 bannedIp varchar(16) NOT NULL,
58 bannedIpHostMask varchar(16) NOT NULL, 63 bannedIpHostMask varchar(16) NOT NULL,
59 bannedNameMask varchar(64) default NULL 64 bannedNameMask varchar(64) default NULL
60); 65);
61
62CREATE INDEX estate_ban_estate_id on estateban(EstateID); 66CREATE INDEX estate_ban_estate_id on estateban(EstateID);
63CREATE INDEX estate_groups_estate_id on estate_groups(EstateID);
64CREATE INDEX estate_managers_estate_id on estate_managers(EstateID);
65CREATE INDEX estate_map_estate_id on estate_map(EstateID);
66CREATE UNIQUE INDEX estate_map_region_id on estate_map(RegionID);
67CREATE INDEX estate_users_estate_id on estate_users(EstateID);
68 67
69COMMIT; 68COMMIT;
70 69
71
72:VERSION 7
73
74begin;
75
76alter table estate_settings add column AbuseEmail varchar(255) not null default '';
77
78alter table estate_settings add column EstateOwner varchar(36) not null default '';
79
80commit;
81
82:VERSION 8
83
84begin;
85
86alter table estate_settings add column DenyMinors tinyint not null default 0;
87
88commit;
89
90:VERSION 9
91
92begin;
93alter table estate_settings add column AllowLandmark tinyint not null default '1';
94alter table estate_settings add column AllowParcelChanges tinyint not null default '1';
95alter table estate_settings add column AllowSetHome tinyint not null default '1';
96commit;
97
diff --git a/OpenSim/Data/SQLite/Resources/InventoryStore.migrations b/OpenSim/Data/SQLite/Resources/InventoryStore.migrations
deleted file mode 100644
index 585ac49..0000000
--- a/OpenSim/Data/SQLite/Resources/InventoryStore.migrations
+++ /dev/null
@@ -1,92 +0,0 @@
1:VERSION 1
2
3BEGIN TRANSACTION;
4
5CREATE TABLE inventoryfolders(
6 UUID varchar(255) primary key,
7 name varchar(255),
8 agentID varchar(255),
9 parentID varchar(255),
10 type integer,
11 version integer);
12
13CREATE TABLE inventoryitems(
14 UUID varchar(255) primary key,
15 assetID varchar(255),
16 assetType integer,
17 invType integer,
18 parentFolderID varchar(255),
19 avatarID varchar(255),
20 creatorsID varchar(255),
21 inventoryName varchar(255),
22 inventoryDescription varchar(255),
23 inventoryNextPermissions integer,
24 inventoryCurrentPermissions integer,
25 inventoryBasePermissions integer,
26 inventoryEveryOnePermissions integer,
27 salePrice integer default 99,
28 saleType integer default 0,
29 creationDate integer default 2000,
30 groupID varchar(255) default '00000000-0000-0000-0000-000000000000',
31 groupOwned integer default 0,
32 flags integer default 0);
33
34COMMIT;
35
36:VERSION 2
37
38BEGIN TRANSACTION;
39
40create index inventoryfolders_agentid on inventoryfolders(agentid);
41create index inventoryfolders_parentid on inventoryfolders(parentid);
42create index inventoryitems_parentfolderid on inventoryitems(parentfolderid);
43create index inventoryitems_avatarid on inventoryitems(avatarid);
44
45COMMIT;
46
47:VERSION 3
48
49BEGIN;
50
51alter table inventoryitems add column inventoryGroupPermissions integer unsigned not null default 0;
52
53COMMIT;
54
55:VERSION 4
56
57BEGIN;
58
59update inventoryitems
60 set UUID = substr(UUID, 1, 8) || "-" || substr(UUID, 9, 4) || "-" || substr(UUID, 13, 4) || "-" || substr(UUID, 17, 4) || "-" || substr(UUID, 21, 12)
61 where UUID not like '%-%';
62
63update inventoryitems
64 set assetID = substr(assetID, 1, 8) || "-" || substr(assetID, 9, 4) || "-" || substr(assetID, 13, 4) || "-" || substr(assetID, 17, 4) || "-" || substr(assetID, 21, 12)
65 where assetID not like '%-%';
66
67update inventoryitems
68 set parentFolderID = substr(parentFolderID, 1, 8) || "-" || substr(parentFolderID, 9, 4) || "-" || substr(parentFolderID, 13, 4) || "-" || substr(parentFolderID, 17, 4) || "-" || substr(parentFolderID, 21, 12)
69 where parentFolderID not like '%-%';
70
71update inventoryitems
72 set avatarID = substr(avatarID, 1, 8) || "-" || substr(avatarID, 9, 4) || "-" || substr(avatarID, 13, 4) || "-" || substr(avatarID, 17, 4) || "-" || substr(avatarID, 21, 12)
73 where avatarID not like '%-%';
74
75update inventoryitems
76 set creatorsID = substr(creatorsID, 1, 8) || "-" || substr(creatorsID, 9, 4) || "-" || substr(creatorsID, 13, 4) || "-" || substr(creatorsID, 17, 4) || "-" || substr(creatorsID, 21, 12)
77 where creatorsID not like '%-%';
78
79
80update inventoryfolders
81 set UUID = substr(UUID, 1, 8) || "-" || substr(UUID, 9, 4) || "-" || substr(UUID, 13, 4) || "-" || substr(UUID, 17, 4) || "-" || substr(UUID, 21, 12)
82 where UUID not like '%-%';
83
84update inventoryfolders
85 set agentID = substr(agentID, 1, 8) || "-" || substr(agentID, 9, 4) || "-" || substr(agentID, 13, 4) || "-" || substr(agentID, 17, 4) || "-" || substr(agentID, 21, 12)
86 where agentID not like '%-%';
87
88update inventoryfolders
89 set parentID = substr(parentID, 1, 8) || "-" || substr(parentID, 9, 4) || "-" || substr(parentID, 13, 4) || "-" || substr(parentID, 17, 4) || "-" || substr(parentID, 21, 12)
90 where parentID not like '%-%';
91
92COMMIT;
diff --git a/OpenSim/Data/SQLite/Resources/RegionStore.migrations b/OpenSim/Data/SQLite/Resources/RegionStore.migrations
index 901068f..fb154cf 100644
--- a/OpenSim/Data/SQLite/Resources/RegionStore.migrations
+++ b/OpenSim/Data/SQLite/Resources/RegionStore.migrations
@@ -1,56 +1,99 @@
1:VERSION 1 1:VERSION 31
2 2
3BEGIN TRANSACTION; 3BEGIN TRANSACTION;
4 4
5CREATE TABLE prims( 5CREATE TABLE IF NOT EXISTS prims(
6 UUID varchar(255) primary key, 6 UUID varchar(255) primary key,
7 RegionUUID varchar(255), 7 RegionUUID varchar(255),
8 ParentID integer, 8 CreationDate integer,
9 CreationDate integer, 9 Name varchar(255),
10 Name varchar(255), 10 SceneGroupID varchar(255),
11 SceneGroupID varchar(255), 11 Text varchar(255),
12 Text varchar(255), 12 Description varchar(255),
13 Description varchar(255), 13 SitName varchar(255),
14 SitName varchar(255), 14 TouchName varchar(255),
15 TouchName varchar(255), 15 CreatorID varchar(255),
16 CreatorID varchar(255), 16 OwnerID varchar(255),
17 OwnerID varchar(255), 17 GroupID varchar(255),
18 GroupID varchar(255), 18 LastOwnerID varchar(255),
19 LastOwnerID varchar(255), 19 OwnerMask integer,
20 OwnerMask integer, 20 NextOwnerMask integer,
21 NextOwnerMask integer, 21 GroupMask integer,
22 GroupMask integer, 22 EveryoneMask integer,
23 EveryoneMask integer, 23 BaseMask integer,
24 BaseMask integer, 24 PositionX float,
25 PositionX float, 25 PositionY float,
26 PositionY float, 26 PositionZ float,
27 PositionZ float, 27 GroupPositionX float,
28 GroupPositionX float, 28 GroupPositionY float,
29 GroupPositionY float, 29 GroupPositionZ float,
30 GroupPositionZ float, 30 VelocityX float,
31 VelocityX float, 31 VelocityY float,
32 VelocityY float, 32 VelocityZ float,
33 VelocityZ float, 33 AngularVelocityX float,
34 AngularVelocityX float, 34 AngularVelocityY float,
35 AngularVelocityY float, 35 AngularVelocityZ float,
36 AngularVelocityZ float, 36 AccelerationX float,
37 AccelerationX float, 37 AccelerationY float,
38 AccelerationY float, 38 AccelerationZ float,
39 AccelerationZ float, 39 RotationX float,
40 RotationX float, 40 RotationY float,
41 RotationY float, 41 RotationZ float,
42 RotationZ float, 42 RotationW float,
43 RotationW float, 43 ObjectFlags integer,
44 ObjectFlags integer, 44 SitTargetOffsetX float NOT NULL default 0,
45 SitTargetOffsetX float NOT NULL default 0, 45 SitTargetOffsetY float NOT NULL default 0,
46 SitTargetOffsetY float NOT NULL default 0, 46 SitTargetOffsetZ float NOT NULL default 0,
47 SitTargetOffsetZ float NOT NULL default 0, 47 SitTargetOrientW float NOT NULL default 0,
48 SitTargetOrientW float NOT NULL default 0, 48 SitTargetOrientX float NOT NULL default 0,
49 SitTargetOrientX float NOT NULL default 0, 49 SitTargetOrientY float NOT NULL default 0,
50 SitTargetOrientY float NOT NULL default 0, 50 SitTargetOrientZ float NOT NULL default 0,
51 SitTargetOrientZ float NOT NULL default 0); 51 ColorR integer not null default 0,
52 52 ColorG integer not null default 0,
53CREATE TABLE primshapes( 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(
54 UUID varchar(255) primary key, 97 UUID varchar(255) primary key,
55 Shape integer, 98 Shape integer,
56 ScaleX float, 99 ScaleX float,
@@ -76,10 +119,12 @@ CREATE TABLE primshapes(
76 ProfileCurve integer, 119 ProfileCurve integer,
77 ProfileHollow integer, 120 ProfileHollow integer,
78 Texture blob, 121 Texture blob,
79 ExtraParams blob, 122 ExtraParams blob,
80 State Integer NOT NULL default 0); 123 State Integer NOT NULL default 0,
124 Media TEXT,
125 LastAttachPoint int not null default '0');
81 126
82CREATE TABLE primitems( 127CREATE TABLE IF NOT EXISTS primitems(
83 itemID varchar(255) primary key, 128 itemID varchar(255) primary key,
84 primID varchar(255), 129 primID varchar(255),
85 assetID varchar(255), 130 assetID varchar(255),
@@ -97,14 +142,15 @@ CREATE TABLE primitems(
97 currentPermissions string, 142 currentPermissions string,
98 basePermissions string, 143 basePermissions string,
99 everyonePermissions string, 144 everyonePermissions string,
100 groupPermissions string); 145 groupPermissions string,
146 flags integer not null default 0);
101 147
102CREATE TABLE terrain( 148CREATE TABLE IF NOT EXISTS terrain(
103 RegionUUID varchar(255), 149 RegionUUID varchar(255),
104 Revision integer, 150 Revision integer,
105 Heightfield blob); 151 Heightfield blob);
106 152
107CREATE TABLE land( 153CREATE TABLE IF NOT EXISTS land(
108 UUID varchar(255) primary key, 154 UUID varchar(255) primary key,
109 RegionUUID varchar(255), 155 RegionUUID varchar(255),
110 LocalLandID string, 156 LocalLandID string,
@@ -135,92 +181,30 @@ CREATE TABLE land(
135 UserLocationZ float, 181 UserLocationZ float,
136 UserLookAtX float, 182 UserLookAtX float,
137 UserLookAtY float, 183 UserLookAtY float,
138 UserLookAtZ float, 184 UserLookAtZ float,
139 AuthbuyerID varchar(36) NOT NULL default '00000000-0000-0000-0000-000000000000'); 185 AuthbuyerID varchar(36) NOT NULL default '00000000-0000-0000-0000-000000000000',
140 186 OtherCleanTime INTEGER NOT NULL default 0,
141CREATE TABLE landaccesslist( 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(
142 LandUUID varchar(255), 196 LandUUID varchar(255),
143 AccessUUID varchar(255), 197 AccessUUID varchar(255),
144 Flags string); 198 Flags string);
145 199
146COMMIT; 200CREATE TABLE IF NOT EXISTS regionban(
147 201 regionUUID varchar (255),
148:VERSION 2 202 bannedUUID varchar (255),
149 203 bannedIp varchar (255),
150BEGIN TRANSACTION; 204 bannedIpHostMask varchar (255)
151 205 );
152CREATE TABLE regionban(
153 regionUUID varchar (255),
154 bannedUUID varchar (255),
155 bannedIp varchar (255),
156 bannedIpHostMask varchar (255)
157 );
158
159COMMIT;
160
161:VERSION 3
162
163BEGIN;
164
165ALTER TABLE primitems add flags integer not null default 0;
166
167COMMIT;
168
169:VERSION 4
170
171BEGIN;
172
173create table regionsettings (
174 regionUUID char(36) not null,
175 block_terraform integer not null,
176 block_fly integer not null,
177 allow_damage integer not null,
178 restrict_pushing integer not null,
179 allow_land_resell integer not null,
180 allow_land_join_divide integer not null,
181 block_show_in_search integer not null,
182 agent_limit integer not null,
183 object_bonus float not null,
184 maturity integer not null,
185 disable_scripts integer not null,
186 disable_collisions integer not null,
187 disable_physics integer not null,
188 terrain_texture_1 char(36) not null,
189 terrain_texture_2 char(36) not null,
190 terrain_texture_3 char(36) not null,
191 terrain_texture_4 char(36) not null,
192 elevation_1_nw float not null,
193 elevation_2_nw float not null,
194 elevation_1_ne float not null,
195 elevation_2_ne float not null,
196 elevation_1_se float not null,
197 elevation_2_se float not null,
198 elevation_1_sw float not null,
199 elevation_2_sw float not null,
200 water_height float not null,
201 terrain_raise_limit float not null,
202 terrain_lower_limit float not null,
203 use_estate_sun integer not null,
204 fixed_sun integer not null,
205 sun_position float not null,
206 covenant char(36));
207
208COMMIT;
209
210:VERSION 5
211
212BEGIN;
213
214delete from regionsettings;
215
216COMMIT;
217
218:VERSION 6
219 206
220BEGIN TRANSACTION; 207CREATE TABLE IF NOT EXISTS regionsettings (
221
222drop table regionsettings;
223CREATE TABLE regionsettings (
224 regionUUID char(36) NOT NULL, 208 regionUUID char(36) NOT NULL,
225 block_terraform int(11) NOT NULL, 209 block_terraform int(11) NOT NULL,
226 block_fly int(11) NOT NULL, 210 block_fly int(11) NOT NULL,
@@ -254,228 +238,18 @@ CREATE TABLE regionsettings (
254 fixed_sun int(11) NOT NULL, 238 fixed_sun int(11) NOT NULL,
255 sun_position float NOT NULL, 239 sun_position float NOT NULL,
256 covenant char(36) default NULL, 240 covenant char(36) default NULL,
257 sandbox tinyint(4) NOT 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',
258 PRIMARY KEY (regionUUID) 249 PRIMARY KEY (regionUUID)
259); 250);
260 251
261COMMIT; 252CREATE TABLE IF NOT EXISTS regionwindlight (
262
263:VERSION 9
264
265BEGIN;
266
267ALTER TABLE prims ADD COLUMN ColorR integer not null default 0;
268ALTER TABLE prims ADD COLUMN ColorG integer not null default 0;
269ALTER TABLE prims ADD COLUMN ColorB integer not null default 0;
270ALTER TABLE prims ADD COLUMN ColorA integer not null default 0;
271
272COMMIT;
273
274:VERSION 10
275
276BEGIN;
277
278ALTER TABLE prims ADD COLUMN ClickAction INTEGER NOT NULL default 0;
279
280COMMIT;
281
282:VERSION 11
283
284BEGIN;
285
286ALTER TABLE prims ADD COLUMN PayPrice INTEGER NOT NULL default 0;
287ALTER TABLE prims ADD COLUMN PayButton1 INTEGER NOT NULL default 0;
288ALTER TABLE prims ADD COLUMN PayButton2 INTEGER NOT NULL default 0;
289ALTER TABLE prims ADD COLUMN PayButton3 INTEGER NOT NULL default 0;
290ALTER TABLE prims ADD COLUMN PayButton4 INTEGER NOT NULL default 0;
291ALTER TABLE prims ADD COLUMN LoopedSound varchar(36) NOT NULL default '00000000-0000-0000-0000-000000000000';
292ALTER TABLE prims ADD COLUMN LoopedSoundGain float NOT NULL default 0;
293ALTER TABLE prims ADD COLUMN TextureAnimation string;
294ALTER TABLE prims ADD COLUMN ParticleSystem string;
295ALTER TABLE prims ADD COLUMN OmegaX float NOT NULL default 0;
296ALTER TABLE prims ADD COLUMN OmegaY float NOT NULL default 0;
297ALTER TABLE prims ADD COLUMN OmegaZ float NOT NULL default 0;
298ALTER TABLE prims ADD COLUMN CameraEyeOffsetX float NOT NULL default 0;
299ALTER TABLE prims ADD COLUMN CameraEyeOffsetY float NOT NULL default 0;
300ALTER TABLE prims ADD COLUMN CameraEyeOffsetZ float NOT NULL default 0;
301ALTER TABLE prims ADD COLUMN CameraAtOffsetX float NOT NULL default 0;
302ALTER TABLE prims ADD COLUMN CameraAtOffsetY float NOT NULL default 0;
303ALTER TABLE prims ADD COLUMN CameraAtOffsetZ float NOT NULL default 0;
304ALTER TABLE prims ADD COLUMN ForceMouselook string NOT NULL default 0;
305ALTER TABLE prims ADD COLUMN ScriptAccessPin INTEGER NOT NULL default 0;
306ALTER TABLE prims ADD COLUMN AllowedDrop INTEGER NOT NULL default 0;
307ALTER TABLE prims ADD COLUMN DieAtEdge string NOT NULL default 0;
308ALTER TABLE prims ADD COLUMN SalePrice INTEGER NOT NULL default 0;
309ALTER TABLE prims ADD COLUMN SaleType string NOT NULL default 0;
310
311COMMIT;
312
313:VERSION 12
314
315BEGIN;
316
317ALTER TABLE prims ADD COLUMN Material INTEGER NOT NULL default 3;
318
319COMMIT;
320
321:VERSION 13
322
323BEGIN;
324
325ALTER TABLE land ADD COLUMN OtherCleanTime INTEGER NOT NULL default 0;
326ALTER TABLE land ADD COLUMN Dwell INTEGER NOT NULL default 0;
327
328COMMIT;
329
330:VERSION 14
331
332begin;
333
334ALTER TABLE regionsettings ADD COLUMN sunvectorx double NOT NULL default 0;
335ALTER TABLE regionsettings ADD COLUMN sunvectory double NOT NULL default 0;
336ALTER TABLE regionsettings ADD COLUMN sunvectorz double NOT NULL default 0;
337
338commit;
339
340:VERSION 15
341
342BEGIN;
343
344ALTER TABLE prims ADD COLUMN CollisionSound varchar(36) NOT NULL default '00000000-0000-0000-0000-000000000000';
345ALTER TABLE prims ADD COLUMN CollisionSoundVolume float NOT NULL default 0;
346
347COMMIT;
348
349:VERSION 16
350
351BEGIN;
352
353ALTER TABLE prims ADD COLUMN VolumeDetect INTEGER NOT NULL DEFAULT 0;
354
355COMMIT;
356
357:VERSION 17
358
359BEGIN;
360CREATE TEMPORARY TABLE prims_backup(UUID,RegionUUID,CreationDate,Name,SceneGroupID,Text,Description,SitName,TouchName,CreatorID,OwnerID,GroupID,LastOwnerID,OwnerMask,NextOwnerMask,GroupMask,EveryoneMask,BaseMask,PositionX,PositionY,PositionZ,GroupPositionX,GroupPositionY,GroupPositionZ,VelocityX,VelocityY,VelocityZ,AngularVelocityX,AngularVelocityY,AngularVelocityZ,AccelerationX,AccelerationY,AccelerationZ,RotationX,RotationY,RotationZ,RotationW,ObjectFlags,SitTargetOffsetX,SitTargetOffsetY,SitTargetOffsetZ,SitTargetOrientW,SitTargetOrientX,SitTargetOrientY,SitTargetOrientZ,ColorR,ColorG,ColorB,ColorA,ClickAction,PayPrice,PayButton1,PayButton2,PayButton3,PayButton4,LoopedSound,LoopedSoundGain,TextureAnimation,ParticleSystem,OmegaX,OmegaY,OmegaZ,CameraEyeOffsetX,CameraEyeOffsetY,CameraEyeOffsetZ,CameraAtOffsetX,CameraAtOffsetY,CameraAtOffsetZ,ForceMouselook,ScriptAccessPin,AllowedDrop,DieAtEdge,SalePrice,SaleType,Material,CollisionSound,CollisionSoundVolume,VolumeDetect);
361INSERT INTO prims_backup SELECT UUID,RegionUUID,CreationDate,Name,SceneGroupID,Text,Description,SitName,TouchName,CreatorID,OwnerID,GroupID,LastOwnerID,OwnerMask,NextOwnerMask,GroupMask,EveryoneMask,BaseMask,PositionX,PositionY,PositionZ,GroupPositionX,GroupPositionY,GroupPositionZ,VelocityX,VelocityY,VelocityZ,AngularVelocityX,AngularVelocityY,AngularVelocityZ,AccelerationX,AccelerationY,AccelerationZ,RotationX,RotationY,RotationZ,RotationW,ObjectFlags,SitTargetOffsetX,SitTargetOffsetY,SitTargetOffsetZ,SitTargetOrientW,SitTargetOrientX,SitTargetOrientY,SitTargetOrientZ,ColorR,ColorG,ColorB,ColorA,ClickAction,PayPrice,PayButton1,PayButton2,PayButton3,PayButton4,LoopedSound,LoopedSoundGain,TextureAnimation,ParticleSystem,OmegaX,OmegaY,OmegaZ,CameraEyeOffsetX,CameraEyeOffsetY,CameraEyeOffsetZ,CameraAtOffsetX,CameraAtOffsetY,CameraAtOffsetZ,ForceMouselook,ScriptAccessPin,AllowedDrop,DieAtEdge,SalePrice,SaleType,Material,CollisionSound,CollisionSoundVolume,VolumeDetect FROM prims;
362DROP TABLE prims;
363CREATE TABLE prims(UUID,RegionUUID,CreationDate,Name,SceneGroupID,Text,Description,SitName,TouchName,CreatorID,OwnerID,GroupID,LastOwnerID,OwnerMask,NextOwnerMask,GroupMask,EveryoneMask,BaseMask,PositionX,PositionY,PositionZ,GroupPositionX,GroupPositionY,GroupPositionZ,VelocityX,VelocityY,VelocityZ,AngularVelocityX,AngularVelocityY,AngularVelocityZ,AccelerationX,AccelerationY,AccelerationZ,RotationX,RotationY,RotationZ,RotationW,ObjectFlags,SitTargetOffsetX,SitTargetOffsetY,SitTargetOffsetZ,SitTargetOrientW,SitTargetOrientX,SitTargetOrientY,SitTargetOrientZ,ColorR,ColorG,ColorB,ColorA,ClickAction,PayPrice,PayButton1,PayButton2,PayButton3,PayButton4,LoopedSound,LoopedSoundGain,TextureAnimation,ParticleSystem,OmegaX,OmegaY,OmegaZ,CameraEyeOffsetX,CameraEyeOffsetY,CameraEyeOffsetZ,CameraAtOffsetX,CameraAtOffsetY,CameraAtOffsetZ,ForceMouselook,ScriptAccessPin,AllowedDrop,DieAtEdge,SalePrice,SaleType,Material,CollisionSound,CollisionSoundVolume,VolumeDetect);
364INSERT INTO prims SELECT UUID,RegionUUID,CreationDate,Name,SceneGroupID,Text,Description,SitName,TouchName,CreatorID,OwnerID,GroupID,LastOwnerID,OwnerMask,NextOwnerMask,GroupMask,EveryoneMask,BaseMask,PositionX,PositionY,PositionZ,GroupPositionX,GroupPositionY,GroupPositionZ,VelocityX,VelocityY,VelocityZ,AngularVelocityX,AngularVelocityY,AngularVelocityZ,AccelerationX,AccelerationY,AccelerationZ,RotationX,RotationY,RotationZ,RotationW,ObjectFlags,SitTargetOffsetX,SitTargetOffsetY,SitTargetOffsetZ,SitTargetOrientW,SitTargetOrientX,SitTargetOrientY,SitTargetOrientZ,ColorR,ColorG,ColorB,ColorA,ClickAction,PayPrice,PayButton1,PayButton2,PayButton3,PayButton4,LoopedSound,LoopedSoundGain,TextureAnimation,ParticleSystem,OmegaX,OmegaY,OmegaZ,CameraEyeOffsetX,CameraEyeOffsetY,CameraEyeOffsetZ,CameraAtOffsetX,CameraAtOffsetY,CameraAtOffsetZ,ForceMouselook,ScriptAccessPin,AllowedDrop,DieAtEdge,SalePrice,SaleType,Material,CollisionSound,CollisionSoundVolume,VolumeDetect FROM prims_backup;
365DROP TABLE prims_backup;
366COMMIT;
367
368:VERSION 18
369
370BEGIN;
371
372update terrain
373 set RegionUUID = substr(RegionUUID, 1, 8) || "-" || substr(RegionUUID, 9, 4) || "-" || substr(RegionUUID, 13, 4) || "-" || substr(RegionUUID, 17, 4) || "-" || substr(RegionUUID, 21, 12)
374 where RegionUUID not like '%-%';
375
376
377update landaccesslist
378 set LandUUID = substr(LandUUID, 1, 8) || "-" || substr(LandUUID, 9, 4) || "-" || substr(LandUUID, 13, 4) || "-" || substr(LandUUID, 17, 4) || "-" || substr(LandUUID, 21, 12)
379 where LandUUID not like '%-%';
380
381update landaccesslist
382 set AccessUUID = substr(AccessUUID, 1, 8) || "-" || substr(AccessUUID, 9, 4) || "-" || substr(AccessUUID, 13, 4) || "-" || substr(AccessUUID, 17, 4) || "-" || substr(AccessUUID, 21, 12)
383 where AccessUUID not like '%-%';
384
385
386update prims
387 set UUID = substr(UUID, 1, 8) || "-" || substr(UUID, 9, 4) || "-" || substr(UUID, 13, 4) || "-" || substr(UUID, 17, 4) || "-" || substr(UUID, 21, 12)
388 where UUID not like '%-%';
389
390update prims
391 set RegionUUID = substr(RegionUUID, 1, 8) || "-" || substr(RegionUUID, 9, 4) || "-" || substr(RegionUUID, 13, 4) || "-" || substr(RegionUUID, 17, 4) || "-" || substr(RegionUUID, 21, 12)
392 where RegionUUID not like '%-%';
393
394update prims
395 set SceneGroupID = substr(SceneGroupID, 1, 8) || "-" || substr(SceneGroupID, 9, 4) || "-" || substr(SceneGroupID, 13, 4) || "-" || substr(SceneGroupID, 17, 4) || "-" || substr(SceneGroupID, 21, 12)
396 where SceneGroupID not like '%-%';
397
398update prims
399 set CreatorID = substr(CreatorID, 1, 8) || "-" || substr(CreatorID, 9, 4) || "-" || substr(CreatorID, 13, 4) || "-" || substr(CreatorID, 17, 4) || "-" || substr(CreatorID, 21, 12)
400 where CreatorID not like '%-%';
401
402update prims
403 set OwnerID = substr(OwnerID, 1, 8) || "-" || substr(OwnerID, 9, 4) || "-" || substr(OwnerID, 13, 4) || "-" || substr(OwnerID, 17, 4) || "-" || substr(OwnerID, 21, 12)
404 where OwnerID not like '%-%';
405
406update prims
407 set GroupID = substr(GroupID, 1, 8) || "-" || substr(GroupID, 9, 4) || "-" || substr(GroupID, 13, 4) || "-" || substr(GroupID, 17, 4) || "-" || substr(GroupID, 21, 12)
408 where GroupID not like '%-%';
409
410update prims
411 set LastOwnerID = substr(LastOwnerID, 1, 8) || "-" || substr(LastOwnerID, 9, 4) || "-" || substr(LastOwnerID, 13, 4) || "-" || substr(LastOwnerID, 17, 4) || "-" || substr(LastOwnerID, 21, 12)
412 where LastOwnerID not like '%-%';
413
414
415update primshapes
416 set UUID = substr(UUID, 1, 8) || "-" || substr(UUID, 9, 4) || "-" || substr(UUID, 13, 4) || "-" || substr(UUID, 17, 4) || "-" || substr(UUID, 21, 12)
417 where UUID not like '%-%';
418
419
420update land
421 set UUID = substr(UUID, 1, 8) || "-" || substr(UUID, 9, 4) || "-" || substr(UUID, 13, 4) || "-" || substr(UUID, 17, 4) || "-" || substr(UUID, 21, 12)
422 where UUID not like '%-%';
423
424update land
425 set RegionUUID = substr(RegionUUID, 1, 8) || "-" || substr(RegionUUID, 9, 4) || "-" || substr(RegionUUID, 13, 4) || "-" || substr(RegionUUID, 17, 4) || "-" || substr(RegionUUID, 21, 12)
426 where RegionUUID not like '%-%';
427
428update land
429 set OwnerUUID = substr(OwnerUUID, 1, 8) || "-" || substr(OwnerUUID, 9, 4) || "-" || substr(OwnerUUID, 13, 4) || "-" || substr(OwnerUUID, 17, 4) || "-" || substr(OwnerUUID, 21, 12)
430 where OwnerUUID not like '%-%';
431
432update land
433 set GroupUUID = substr(GroupUUID, 1, 8) || "-" || substr(GroupUUID, 9, 4) || "-" || substr(GroupUUID, 13, 4) || "-" || substr(GroupUUID, 17, 4) || "-" || substr(GroupUUID, 21, 12)
434 where GroupUUID not like '%-%';
435
436update land
437 set MediaTextureUUID = substr(MediaTextureUUID, 1, 8) || "-" || substr(MediaTextureUUID, 9, 4) || "-" || substr(MediaTextureUUID, 13, 4) || "-" || substr(MediaTextureUUID, 17, 4) || "-" || substr(MediaTextureUUID, 21, 12)
438 where MediaTextureUUID not like '%-%';
439
440update land
441 set SnapshotUUID = substr(SnapshotUUID, 1, 8) || "-" || substr(SnapshotUUID, 9, 4) || "-" || substr(SnapshotUUID, 13, 4) || "-" || substr(SnapshotUUID, 17, 4) || "-" || substr(SnapshotUUID, 21, 12)
442 where SnapshotUUID not like '%-%';
443
444update land
445 set AuthbuyerID = substr(AuthbuyerID, 1, 8) || "-" || substr(AuthbuyerID, 9, 4) || "-" || substr(AuthbuyerID, 13, 4) || "-" || substr(AuthbuyerID, 17, 4) || "-" || substr(AuthbuyerID, 21, 12)
446 where AuthbuyerID not like '%-%';
447
448COMMIT;
449
450:VERSION 19
451BEGIN;
452ALTER TABLE regionsettings ADD COLUMN map_tile_ID varchar(36) NOT NULL default '00000000-0000-0000-0000-000000000000';
453COMMIT;
454
455:VERSION 20
456BEGIN;
457ALTER TABLE prims ADD COLUMN MediaURL varchar(255);
458ALTER TABLE primshapes ADD COLUMN Media TEXT;
459COMMIT;
460
461:VERSION 21
462BEGIN;
463ALTER TABLE `land` ADD COLUMN `MediaType` VARCHAR(32) NOT NULL DEFAULT 'none/none';
464ALTER TABLE `land` ADD COLUMN `MediaDescription` VARCHAR(255) NOT NULL DEFAULT '';
465ALTER TABLE `land` ADD COLUMN `MediaSize` VARCHAR(16) NOT NULL DEFAULT '0,0';
466ALTER TABLE `land` ADD COLUMN `MediaLoop` BOOLEAN NOT NULL DEFAULT FALSE;
467ALTER TABLE `land` ADD COLUMN `ObscureMusic` BOOLEAN NOT NULL DEFAULT FALSE;
468ALTER TABLE `land` ADD COLUMN `ObscureMedia` BOOLEAN NOT NULL DEFAULT FALSE;
469COMMIT;
470
471:VERSION 22
472BEGIN;
473ALTER TABLE regionsettings ADD COLUMN covenant_datetime INTEGER NOT NULL default 0;
474COMMIT;
475
476:VERSION 23
477BEGIN;
478CREATE TABLE regionwindlight (
479 region_id VARCHAR(36) NOT NULL DEFAULT '000000-0000-0000-0000-000000000000' PRIMARY KEY, 253 region_id VARCHAR(36) NOT NULL DEFAULT '000000-0000-0000-0000-000000000000' PRIMARY KEY,
480 water_color_r FLOAT NOT NULL DEFAULT '4.000000', 254 water_color_r FLOAT NOT NULL DEFAULT '4.000000',
481 water_color_g FLOAT NOT NULL DEFAULT '38.000000', 255 water_color_g FLOAT NOT NULL DEFAULT '38.000000',
@@ -541,13 +315,6 @@ CREATE TABLE regionwindlight (
541 cloud_scroll_y_lock INTEGER NOT NULL DEFAULT '0', 315 cloud_scroll_y_lock INTEGER NOT NULL DEFAULT '0',
542 draw_classic_clouds INTEGER NOT NULL DEFAULT '1'); 316 draw_classic_clouds INTEGER NOT NULL DEFAULT '1');
543 317
544COMMIT;
545
546
547:VERSION 24
548
549BEGIN;
550
551CREATE TABLE IF NOT EXISTS `spawn_points` ( 318CREATE TABLE IF NOT EXISTS `spawn_points` (
552 `RegionID` varchar(36) NOT NULL DEFAULT '000000-0000-0000-0000-000000000000', 319 `RegionID` varchar(36) NOT NULL DEFAULT '000000-0000-0000-0000-000000000000',
553 `Yaw` float NOT NULL, 320 `Yaw` float NOT NULL,
@@ -555,60 +322,58 @@ CREATE TABLE IF NOT EXISTS `spawn_points` (
555 `Distance` float NOT NULL 322 `Distance` float NOT NULL
556); 323);
557 324
558ALTER TABLE `regionsettings` ADD COLUMN `TelehubObject` varchar(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000'; 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);
559 329
560COMMIT; 330COMMIT;
561 331
562:VERSION 25
563
564BEGIN;
565ALTER TABLE `regionsettings` ADD COLUMN `parcel_tile_ID` char(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000';
566COMMIT;
567 332
568:VERSION 26 333:VERSION 32 #---- avination fields plus a few others
569 334
570BEGIN; 335BEGIN;
571 336
572CREATE TABLE `regionenvironment` ( 337ALTER TABLE `prims` ADD COLUMN `PassTouches` BOOLEAN NOT NULL DEFAULT FALSE;
573 `region_id` varchar(36) NOT NULL DEFAULT '000000-0000-0000-0000-000000000000' PRIMARY KEY, 338ALTER TABLE `prims` ADD COLUMN `PassCollisions`BOOLEAN NOT NULL DEFAULT FALSE;
574 `llsd_settings` TEXT NOT NULL 339ALTER TABLE `prims` ADD COLUMN `Vehicle` TEXT default NULL;
575); 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;
576 345
577COMMIT; 346COMMIT;
578 347
579:VERSION 27 348:VERSION 33 #---- Rotation axis locks
580BEGIN;
581ALTER TABLE prims ADD COLUMN DynAttrs TEXT;
582COMMIT;
583
584:VERSION 28
585 349
586BEGIN; 350BEGIN;
587 351
588ALTER TABLE prims ADD COLUMN `PhysicsShapeType` tinyint(4) NOT NULL default '0'; 352ALTER TABLE prims ADD COLUMN `RotationAxisLocks` tinyint(4) NOT NULL default '0';
589ALTER TABLE prims ADD COLUMN `Density` double NOT NULL default '1000';
590ALTER TABLE prims ADD COLUMN `GravityModifier` double NOT NULL default '1';
591ALTER TABLE prims ADD COLUMN `Friction` double NOT NULL default '0.6';
592ALTER TABLE prims ADD COLUMN `Restitution` double NOT NULL default '0.5';
593 353
594COMMIT; 354COMMIT;
595 355
596:VERSION 29 #---------------- Keyframes 356:VERSION 34 #---- add baked terrain store
597 357
598BEGIN; 358BEGIN;
599 359
600ALTER TABLE prims ADD COLUMN `KeyframeMotion` blob; 360CREATE TABLE IF NOT EXISTS bakedterrain(
361 RegionUUID varchar(255),
362 Revision integer,
363 Heightfield blob);
601 364
602COMMIT; 365COMMIT;
603 366
604:VERSION 30 #---------------- Save Attachment info 367:VERSION 35 #----- Add RezzerID field in table prims
605 368
606BEGIN; 369BEGIN;
607 370
608ALTER TABLE prims ADD COLUMN AttachedPosX double default '0'; 371ALTER TABLE `prims` ADD COLUMN `RezzerID` char(36) DEFAULT NULL;
609ALTER TABLE prims ADD COLUMN AttachedPosY double default '0';
610ALTER TABLE prims ADD COLUMN AttachedPosZ double default '0';
611ALTER TABLE primshapes ADD COLUMN LastAttachPoint int not null default '0';
612 372
613COMMIT; 373COMMIT;
614 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
index 854fe69..f37a222 100644
--- a/OpenSim/Data/SQLite/Resources/UserAccount.migrations
+++ b/OpenSim/Data/SQLite/Resources/UserAccount.migrations
@@ -25,3 +25,11 @@ BEGIN TRANSACTION;
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; 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 26
27COMMIT; 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
index 86434e8..207dde0 100644
--- a/OpenSim/Data/SQLite/Resources/UserProfiles.migrations
+++ b/OpenSim/Data/SQLite/Resources/UserProfiles.migrations
@@ -99,4 +99,4 @@ CREATE TABLE IF NOT EXISTS usersettings (
99 email varchar(254) NOT NULL, 99 email varchar(254) NOT NULL,
100 PRIMARY KEY (useruuid) 100 PRIMARY KEY (useruuid)
101) 101)
102commit; \ No newline at end of file 102commit;
diff --git a/OpenSim/Data/SQLite/Resources/UserStore.migrations b/OpenSim/Data/SQLite/Resources/UserStore.migrations
deleted file mode 100644
index 73d35e8..0000000
--- a/OpenSim/Data/SQLite/Resources/UserStore.migrations
+++ /dev/null
@@ -1,169 +0,0 @@
1:VERSION 1
2
3BEGIN TRANSACTION;
4
5-- users table
6CREATE TABLE users(
7 UUID varchar(255) primary key,
8 username varchar(255),
9 surname varchar(255),
10 passwordHash varchar(255),
11 passwordSalt varchar(255),
12 homeRegionX integer,
13 homeRegionY integer,
14 homeLocationX float,
15 homeLocationY float,
16 homeLocationZ float,
17 homeLookAtX float,
18 homeLookAtY float,
19 homeLookAtZ float,
20 created integer,
21 lastLogin integer,
22 rootInventoryFolderID varchar(255),
23 userInventoryURI varchar(255),
24 userAssetURI varchar(255),
25 profileCanDoMask integer,
26 profileWantDoMask integer,
27 profileAboutText varchar(255),
28 profileFirstText varchar(255),
29 profileImage varchar(255),
30 profileFirstImage varchar(255),
31 webLoginKey text default '00000000-0000-0000-0000-000000000000');
32-- friends table
33CREATE TABLE userfriends(
34 ownerID varchar(255),
35 friendID varchar(255),
36 friendPerms integer,
37 ownerPerms integer,
38 datetimestamp integer);
39
40COMMIT;
41
42:VERSION 2
43
44BEGIN;
45
46ALTER TABLE users add homeRegionID varchar(36) NOT NULL default '00000000-0000-0000-0000-000000000000';
47
48COMMIT;
49
50:VERSION 3
51
52BEGIN;
53
54ALTER TABLE users add userFlags integer NOT NULL default 0;
55ALTER TABLE users add godLevel integer NOT NULL default 0;
56
57COMMIT;
58
59:VERSION 4
60
61BEGIN;
62
63ALTER TABLE users add customType varchar(32) not null default '';
64ALTER TABLE users add partner char(36) not null default '00000000-0000-0000-0000-000000000000';
65
66COMMIT;
67
68:VERSION 5
69
70BEGIN;
71
72CREATE TABLE `avatarattachments` (`UUID` char(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000', `attachpoint` int(11) NOT NULL DEFAULT 0, `item` char(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000', `asset` char(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000');
73
74COMMIT;
75
76:VERSION 6
77
78BEGIN TRANSACTION;
79
80-- usersagents table
81CREATE TABLE IF NOT EXISTS useragents(
82 UUID varchar(255) primary key,
83 agentIP varchar(255),
84 agentPort integer,
85 agentOnline boolean,
86 sessionID varchar(255),
87 secureSessionID varchar(255),
88 regionID varchar(255),
89 loginTime integer,
90 logoutTime integer,
91 currentRegion varchar(255),
92 currentHandle varchar(255),
93 currentPosX float,
94 currentPosY float,
95 currentPosZ float);
96
97COMMIT;
98
99:VERSION 7
100
101BEGIN TRANSACTION;
102
103ALTER TABLE useragents add currentLookAtX float not null default 128;
104ALTER TABLE useragents add currentLookAtY float not null default 128;
105ALTER TABLE useragents add currentLookAtZ float not null default 70;
106
107COMMIT;
108
109:VERSION 8
110
111BEGIN TRANSACTION;
112
113ALTER TABLE users add email varchar(250);
114
115COMMIT;
116
117:VERSION 9
118
119BEGIN;
120
121update users
122 set UUID = substr(UUID, 1, 8) || "-" || substr(UUID, 9, 4) || "-" || substr(UUID, 13, 4) || "-" || substr(UUID, 17, 4) || "-" || substr(UUID, 21, 12)
123 where UUID not like '%-%';
124
125update useragents
126 set UUID = substr(UUID, 1, 8) || "-" || substr(UUID, 9, 4) || "-" || substr(UUID, 13, 4) || "-" || substr(UUID, 17, 4) || "-" || substr(UUID, 21, 12)
127 where UUID not like '%-%';
128
129COMMIT;
130
131:VERSION 10
132
133BEGIN TRANSACTION;
134
135CREATE TABLE IF NOT EXISTS avatarappearance(
136 Owner varchar(36) NOT NULL primary key,
137 BodyItem varchar(36) DEFAULT NULL,
138 BodyAsset varchar(36) DEFAULT NULL,
139 SkinItem varchar(36) DEFAULT NULL,
140 SkinAsset varchar(36) DEFAULT NULL,
141 HairItem varchar(36) DEFAULT NULL,
142 HairAsset varchar(36) DEFAULT NULL,
143 EyesItem varchar(36) DEFAULT NULL,
144 EyesAsset varchar(36) DEFAULT NULL,
145 ShirtItem varchar(36) DEFAULT NULL,
146 ShirtAsset varchar(36) DEFAULT NULL,
147 PantsItem varchar(36) DEFAULT NULL,
148 PantsAsset varchar(36) DEFAULT NULL,
149 ShoesItem varchar(36) DEFAULT NULL,
150 ShoesAsset varchar(36) DEFAULT NULL,
151 SocksItem varchar(36) DEFAULT NULL,
152 SocksAsset varchar(36) DEFAULT NULL,
153 JacketItem varchar(36) DEFAULT NULL,
154 JacketAsset varchar(36) DEFAULT NULL,
155 GlovesItem varchar(36) DEFAULT NULL,
156 GlovesAsset varchar(36) DEFAULT NULL,
157 UnderShirtItem varchar(36) DEFAULT NULL,
158 UnderShirtAsset varchar(36) DEFAULT NULL,
159 UnderPantsItem varchar(36) DEFAULT NULL,
160 UnderPantsAsset varchar(36) DEFAULT NULL,
161 SkirtItem varchar(36) DEFAULT NULL,
162 SkirtAsset varchar(36) DEFAULT NULL,
163 Texture blob,
164 VisualParams blob,
165 Serial int DEFAULT NULL,
166 AvatarHeight float DEFAULT NULL
167);
168
169COMMIT;
generated by cgit v1.1 at 2024-12-24 00:00:54 +0000