aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_RegionStore.sql
diff options
context:
space:
mode:
Diffstat (limited to 'OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_RegionStore.sql')
-rw-r--r--OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_RegionStore.sql306
1 files changed, 162 insertions, 144 deletions
diff --git a/OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_RegionStore.sql b/OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_RegionStore.sql
index eaa0964..7b591be 100644
--- a/OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_RegionStore.sql
+++ b/OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_RegionStore.sql
@@ -1,150 +1,168 @@
1BEGIN TRANSACTION; 1CREATE TABLE Prims (
2 2 UUID VARCHAR(36) NOT NULL,
3create table Prims ( 3 RegionID VARCHAR(36) DEFAULT NULL,
4 UUID TEXT not null, 4 GroupID VARCHAR(36) DEFAULT NULL,
5 RegionID TEXT, 5 ParentID INT DEFAULT NULL,
6 GroupID TEXT, 6 ParentUUID VARCHAR(36) DEFAULT NULL,
7 ParentID INTEGER, 7 OwnerID VARCHAR(36) DEFAULT NULL,
8 ParentUUID TEXT, 8 LastOwnerID VARCHAR(36) DEFAULT NULL,
9 OwnerID TEXT, 9 CreatorID VARCHAR(36) DEFAULT NULL,
10 LastOwnerID TEXT, 10 CreationDate INT DEFAULT NULL,
11 CreatorID TEXT, 11 LinkNum INT DEFAULT NULL,
12 CreationDate INTEGER, 12 Name VARCHAR(255) DEFAULT NULL,
13 LinkNum INTEGER, 13 Text VARCHAR(255) DEFAULT NULL,
14 Name TEXT, 14 Description VARCHAR(255) DEFAULT NULL,
15 Text TEXT, 15 SitName VARCHAR(255) DEFAULT NULL,
16 Description TEXT, 16 TouchName VARCHAR(255) DEFAULT NULL,
17 SitName TEXT, 17 ObjectFlags INT DEFAULT NULL,
18 TouchName TEXT, 18 OwnerMask INT DEFAULT NULL,
19 ObjectFlags INTEGER, 19 NextOwnerMask INT DEFAULT NULL,
20 OwnerMask INTEGER, 20 GroupMask INT DEFAULT NULL,
21 NextOwnerMask INTEGER, 21 EveryoneMask INT DEFAULT NULL,
22 GroupMask INTEGER, 22 BaseMask INT DEFAULT NULL,
23 EveryoneMask INTEGER, 23 Material TINYINT DEFAULT NULL,
24 BaseMask INTEGER, 24 ScriptAccessPin INT DEFAULT NULL,
25 Material INTEGER, 25 TextureAnimation BLOB,
26 ScriptAccessPin INTEGER, 26 ParticleSystem BLOB,
27 TextureAnimation BLOB, 27 ClickAction TINYINT DEFAULT NULL,
28 ParticleSystem BLOB, 28 Color INT DEFAULT NULL,
29 ClickAction INTEGER, 29 PositionX DOUBLE DEFAULT NULL,
30 Color INTEGER, 30 PositionY DOUBLE DEFAULT NULL,
31 PositionX NUMERIC, 31 PositionZ DOUBLE DEFAULT NULL,
32 PositionY NUMERIC, 32 GroupPositionX DOUBLE DEFAULT NULL,
33 PositionZ NUMERIC, 33 GroupPositionY DOUBLE DEFAULT NULL,
34 GroupPositionX NUMERIC, 34 GroupPositionZ DOUBLE DEFAULT NULL,
35 GroupPositionY NUMERIC, 35 VelocityX DOUBLE DEFAULT NULL,
36 GroupPositionZ NUMERIC, 36 VelocityY DOUBLE DEFAULT NULL,
37 VelocityX NUMERIC, 37 VelocityZ DOUBLE DEFAULT NULL,
38 VelocityY NUMERIC, 38 AngularVelocityX DOUBLE DEFAULT NULL,
39 VelocityZ NUMERIC, 39 AngularVelocityY DOUBLE DEFAULT NULL,
40 AngularVelocityX NUMERIC, 40 AngularVelocityZ DOUBLE DEFAULT NULL,
41 AngularVelocityY NUMERIC, 41 AccelerationX DOUBLE DEFAULT NULL,
42 AngularVelocityZ NUMERIC, 42 AccelerationY DOUBLE DEFAULT NULL,
43 AccelerationX NUMERIC, 43 AccelerationZ DOUBLE DEFAULT NULL,
44 AccelerationY NUMERIC, 44 RotationX DOUBLE DEFAULT NULL,
45 AccelerationZ NUMERIC, 45 RotationY DOUBLE DEFAULT NULL,
46 SitTargetOffsetX NUMERIC, 46 RotationZ DOUBLE DEFAULT NULL,
47 SitTargetOffsetY NUMERIC, 47 RotationW DOUBLE DEFAULT NULL,
48 SitTargetOffsetZ NUMERIC, 48 SitTargetOffsetX DOUBLE DEFAULT NULL,
49 RotationX NUMERIC, 49 SitTargetOffsetY DOUBLE DEFAULT NULL,
50 RotationY NUMERIC, 50 SitTargetOffsetZ DOUBLE DEFAULT NULL,
51 RotationZ NUMERIC, 51 SitTargetOrientW DOUBLE DEFAULT NULL,
52 RotationW NUMERIC, 52 SitTargetOrientX DOUBLE DEFAULT NULL,
53 SitTargetOrientX NUMERIC, 53 SitTargetOrientY DOUBLE DEFAULT NULL,
54 SitTargetOrientY NUMERIC, 54 SitTargetOrientZ DOUBLE DEFAULT NULL,
55 SitTargetOrientZ NUMERIC, 55 -- this is the shape
56 SitTargetOrientW NUMERIC, 56 Shape INT DEFAULT NULL,
57 ScaleX NUMERIC, 57 ScaleX DOUBLE DEFAULT NULL,
58 ScaleY NUMERIC, 58 ScaleY DOUBLE DEFAULT NULL,
59 ScaleZ NUMERIC, 59 ScaleZ DOUBLE DEFAULT NULL,
60 PCode INTEGER, 60 PCode INT DEFAULT NULL,
61 PathBegin INTEGER, 61 PathBegin INT DEFAULT NULL,
62 PathEnd INTEGER, 62 PathEnd INT DEFAULT NULL,
63 PathScaleX INTEGER, 63 PathScaleX INT DEFAULT NULL,
64 PathScaleY INTEGER, 64 PathScaleY INT DEFAULT NULL,
65 PathShearX INTEGER, 65 PathShearX INT DEFAULT NULL,
66 PathShearY INTEGER, 66 PathShearY INT DEFAULT NULL,
67 PathSkew INTEGER, 67 PathSkew INT DEFAULT NULL,
68 PathCurve INTEGER, 68 PathCurve INT DEFAULT NULL,
69 PathRadiusOffset INTEGER, 69 PathRadiusOffset INT DEFAULT NULL,
70 PathRevolutions INTEGER, 70 PathRevolutions INT DEFAULT NULL,
71 PathTaperX INTEGER, 71 PathTaperX INT DEFAULT NULL,
72 PathTwist INTEGER, 72 PathTaperY INT DEFAULT NULL,
73 ProfileBegin INTEGER, 73 PathTwist INT DEFAULT NULL,
74 ProfileEnd INTEGER, 74 PathTwistBegin INT DEFAULT NULL,
75 ProfileCurve INTEGER, 75 ProfileBegin INT DEFAULT NULL,
76 ProfileHollow INTEGER, 76 ProfileEnd INT DEFAULT NULL,
77 Texture BLOB, 77 ProfileCurve INT DEFAULT NULL,
78 ExtraParams BLOB, 78 ProfileHollow INT DEFAULT NULL,
79 State INTEGER, 79 State INT DEFAULT NULL,
80 primary key (UUID) 80 Texture BLOB,
81 ExtraParams BLOB,
82 PRIMARY KEY (UUID)
81); 83);
82create table Terrain ( 84
83 RegionID TEXT not null, 85CREATE INDEX PrimsRegionIdIndex ON Prims (RegionID);
84 MapData BLOB, 86CREATE INDEX PrimsRegionParentUuidIndex ON Prims (ParentUUID);
85 primary key (RegionID) 87
88CREATE TABLE Terrain (
89 RegionID VARCHAR(36) NOT NULL,
90 MapData BLOB,
91 PRIMARY KEY (RegionID)
86); 92);
87create table PrimItems ( 93
88 ItemID TEXT not null, 94CREATE TABLE PrimItems (
89 PrimID TEXT, 95 ItemID VARCHAR(36) NOT NULL,
90 AssetID TEXT, 96 GroupID VARCHAR(36) DEFAULT NULL,
91 ParentFolderID TEXT, 97 PrimID VARCHAR(36) DEFAULT NULL,
92 CreatorID TEXT, 98 ParentFolderID VARCHAR(36) DEFAULT NULL,
93 OwnerID TEXT, 99 AssetID VARCHAR(36) DEFAULT NULL,
94 GroupID TEXT, 100 OwnerID VARCHAR(36) DEFAULT NULL,
95 LastOwnerID TEXT, 101 LastOwnerID VARCHAR(36) DEFAULT NULL,
96 CurrentPermissions INTEGER, 102 CreatorID VARCHAR(36) DEFAULT NULL,
97 BasePermissions INTEGER, 103 CreationDate BIGINT DEFAULT NULL,
98 EveryonePermissions INTEGER, 104 InvType INT DEFAULT NULL,
99 GroupPermissions INTEGER, 105 Name VARCHAR(255) DEFAULT NULL,
100 NextPermissions INTEGER, 106 Description VARCHAR(255) DEFAULT NULL,
101 Name TEXT, 107 NextPermissions INT DEFAULT NULL,
102 Description TEXT, 108 CurrentPermissions INT DEFAULT NULL,
103 CreationDate INTEGER, 109 BasePermissions INT DEFAULT NULL,
104 Flags INTEGER, 110 EveryonePermissions INT DEFAULT NULL,
105 InvType INTEGER, 111 GroupPermissions INT DEFAULT NULL,
106 primary key (ItemID) 112 Flags INT DEFAULT NULL,
113 PRIMARY KEY (ItemID)
107); 114);
108 115
116CREATE INDEX PrimItemsPrimIdIndex ON PrimItems (PrimID);
117
109CREATE TABLE RegionSettings ( 118CREATE TABLE RegionSettings (
110 RegionID TEXT not null, 119 RegionID VARCHAR(36) NOT NULL,
111 BlockTerraform BIT, 120
112 BlockFly BIT, 121 BlockTerraform BIT DEFAULT NULL,
113 AllowDamage BIT, 122 BlockFly BIT DEFAULT NULL,
114 RestrictPushing BIT, 123 AllowDamage BIT DEFAULT NULL,
115 AllowLandResell BIT, 124 RestrictPushing BIT DEFAULT NULL,
116 AllowLandJoinDivide BIT, 125 AllowLandResell BIT DEFAULT NULL,
117 BlockShowInSearch BIT, 126 AllowLandJoinDivide BIT DEFAULT NULL,
118 AgentLimit INTEGER, 127 BlockShowInSearch BIT DEFAULT NULL,
119 ObjectBonus NUMERIC, 128
120 Maturity INTEGER, 129 AgentLimit INT DEFAULT NULL,
121 DisableScripts BIT, 130 ObjectBonus DOUBLE DEFAULT NULL,
122 DisableCollisions BIT, 131 Maturity INT DEFAULT NULL,
123 DisablePhysics BIT, 132
124 TerrainTexture1 TEXT, 133 DisableScripts BIT DEFAULT NULL,
125 TerrainTexture2 TEXT, 134 DisableCollisions BIT DEFAULT NULL,
126 TerrainTexture3 TEXT, 135 DisablePhysics BIT DEFAULT NULL,
127 TerrainTexture4 TEXT, 136
128 Elevation1NW NUMERIC, 137 TerrainTexture1 VARCHAR(36) DEFAULT NULL,
129 Elevation2NW NUMERIC, 138 TerrainTexture2 VARCHAR(36) DEFAULT NULL,
130 Elevation1NE NUMERIC, 139 TerrainTexture3 VARCHAR(36) DEFAULT NULL,
131 Elevation2NE NUMERIC, 140 TerrainTexture4 VARCHAR(36) DEFAULT NULL,
132 Elevation1SE NUMERIC, 141
133 Elevation2SE NUMERIC, 142 Elevation1NW DOUBLE DEFAULT NULL,
134 Elevation1SW NUMERIC, 143 Elevation2NW DOUBLE DEFAULT NULL,
135 Elevation2SW NUMERIC, 144 Elevation1NE DOUBLE DEFAULT NULL,
136 WaterHeight NUMERIC, 145 Elevation2NE DOUBLE DEFAULT NULL,
137 TerrainRaiseLimit NUMERIC, 146 Elevation1SE DOUBLE DEFAULT NULL,
138 TerrainLowerLimit NUMERIC, 147 Elevation2SE DOUBLE DEFAULT NULL,
139 UseEstateSun BIT, 148 Elevation1SW DOUBLE DEFAULT NULL,
140 Sandbox BIT, 149 Elevation2SW DOUBLE DEFAULT NULL,
141 SunVectorX NUMERIC, 150
142 SunVectorY NUMERIC, 151 WaterHeight DOUBLE DEFAULT NULL,
143 SunVectorZ NUMERIC, 152 TerrainRaiseLimit DOUBLE DEFAULT NULL,
144 FixedSun BIT, 153 TerrainLowerLimit DOUBLE DEFAULT NULL,
145 SunPosition NUMERIC,
146 Covenant TEXT,
147 primary key (RegionID)
148);
149 154
150COMMIT; 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);
generated by cgit v1.1 at 2025-01-03 21:16:59 +0000