diff options
Diffstat (limited to 'OpenSim/Data/NHibernate/Resources/PostgreSQLDialect/001_RegionStore.sql')
-rw-r--r-- | OpenSim/Data/NHibernate/Resources/PostgreSQLDialect/001_RegionStore.sql | 169 |
1 files changed, 169 insertions, 0 deletions
diff --git a/OpenSim/Data/NHibernate/Resources/PostgreSQLDialect/001_RegionStore.sql b/OpenSim/Data/NHibernate/Resources/PostgreSQLDialect/001_RegionStore.sql new file mode 100644 index 0000000..42c999b --- /dev/null +++ b/OpenSim/Data/NHibernate/Resources/PostgreSQLDialect/001_RegionStore.sql | |||
@@ -0,0 +1,169 @@ | |||
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 SMALLINT DEFAULT NULL, | ||
24 | ScriptAccessPin INT DEFAULT NULL, | ||
25 | TextureAnimation BYTEA, | ||
26 | ParticleSystem BYTEA, | ||
27 | ClickAction SMALLINT DEFAULT NULL, | ||
28 | Color INT DEFAULT NULL, | ||
29 | PositionX DOUBLE PRECISION DEFAULT NULL, | ||
30 | PositionY DOUBLE PRECISION DEFAULT NULL, | ||
31 | PositionZ DOUBLE PRECISION DEFAULT NULL, | ||
32 | GroupPositionX DOUBLE PRECISION DEFAULT NULL, | ||
33 | GroupPositionY DOUBLE PRECISION DEFAULT NULL, | ||
34 | GroupPositionZ DOUBLE PRECISION DEFAULT NULL, | ||
35 | VelocityX DOUBLE PRECISION DEFAULT NULL, | ||
36 | VelocityY DOUBLE PRECISION DEFAULT NULL, | ||
37 | VelocityZ DOUBLE PRECISION DEFAULT NULL, | ||
38 | AngularVelocityX DOUBLE PRECISION DEFAULT NULL, | ||
39 | AngularVelocityY DOUBLE PRECISION DEFAULT NULL, | ||
40 | AngularVelocityZ DOUBLE PRECISION DEFAULT NULL, | ||
41 | AccelerationX DOUBLE PRECISION DEFAULT NULL, | ||
42 | AccelerationY DOUBLE PRECISION DEFAULT NULL, | ||
43 | AccelerationZ DOUBLE PRECISION DEFAULT NULL, | ||
44 | RotationX DOUBLE PRECISION DEFAULT NULL, | ||
45 | RotationY DOUBLE PRECISION DEFAULT NULL, | ||
46 | RotationZ DOUBLE PRECISION DEFAULT NULL, | ||
47 | RotationW DOUBLE PRECISION DEFAULT NULL, | ||
48 | SitTargetOffsetX DOUBLE PRECISION DEFAULT NULL, | ||
49 | SitTargetOffsetY DOUBLE PRECISION DEFAULT NULL, | ||
50 | SitTargetOffsetZ DOUBLE PRECISION DEFAULT NULL, | ||
51 | SitTargetOrientW DOUBLE PRECISION DEFAULT NULL, | ||
52 | SitTargetOrientX DOUBLE PRECISION DEFAULT NULL, | ||
53 | SitTargetOrientY DOUBLE PRECISION DEFAULT NULL, | ||
54 | SitTargetOrientZ DOUBLE PRECISION DEFAULT NULL, | ||
55 | -- this is the shape | ||
56 | Shape INT DEFAULT NULL, | ||
57 | ScaleX DOUBLE PRECISION DEFAULT NULL, | ||
58 | ScaleY DOUBLE PRECISION DEFAULT NULL, | ||
59 | ScaleZ DOUBLE PRECISION DEFAULT NULL, | ||
60 | PCode INT DEFAULT NULL, | ||
61 | PathBegin SMALLINT DEFAULT NULL, | ||
62 | PathEnd SMALLINT DEFAULT NULL, | ||
63 | PathScaleX INT DEFAULT NULL, | ||
64 | PathScaleY INT DEFAULT NULL, | ||
65 | PathShearX INT DEFAULT NULL, | ||
66 | PathShearY INT DEFAULT NULL, | ||
67 | PathSkew SMALLINT DEFAULT NULL, | ||
68 | PathCurve INT DEFAULT NULL, | ||
69 | PathRadiusOffset SMALLINT DEFAULT NULL, | ||
70 | PathRevolutions INT DEFAULT NULL, | ||
71 | PathTaperX SMALLINT DEFAULT NULL, | ||
72 | PathTaperY SMALLINT DEFAULT NULL, | ||
73 | PathTwist SMALLINT DEFAULT NULL, | ||
74 | PathTwistBegin INT DEFAULT NULL, | ||
75 | ProfileBegin SMALLINT DEFAULT NULL, | ||
76 | ProfileEnd SMALLINT DEFAULT NULL, | ||
77 | ProfileCurve INT DEFAULT NULL, | ||
78 | ProfileHollow SMALLINT DEFAULT NULL, | ||
79 | State INT DEFAULT NULL, | ||
80 | Texture BYTEA, | ||
81 | ExtraParams BYTEA, | ||
82 | PRIMARY KEY (UUID) | ||
83 | ); | ||
84 | |||
85 | CREATE INDEX PrimsRegionIdIndex ON Prims (RegionID); | ||
86 | CREATE INDEX PrimsRegionParentUuidIndex ON Prims (ParentUUID); | ||
87 | |||
88 | CREATE TABLE Terrain ( | ||
89 | RegionID VARCHAR(36) not null, | ||
90 | MapData BYTEA, | ||
91 | PRIMARY KEY (RegionID) | ||
92 | ); | ||
93 | |||
94 | CREATE TABLE PrimItems ( | ||
95 | ItemID VARCHAR(36) NOT NULL, | ||
96 | GroupID VARCHAR(36) DEFAULT NULL, | ||
97 | PrimID VARCHAR(36) DEFAULT NULL, | ||
98 | ParentFolderID VARCHAR(36) DEFAULT NULL, | ||
99 | AssetID VARCHAR(36) DEFAULT NULL, | ||
100 | OwnerID VARCHAR(36) DEFAULT NULL, | ||
101 | LastOwnerID VARCHAR(36) DEFAULT NULL, | ||
102 | CreatorID VARCHAR(36) DEFAULT NULL, | ||
103 | CreationDate 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 BOOLEAN DEFAULT NULL, | ||
122 | BlockFly BOOLEAN DEFAULT NULL, | ||
123 | AllowDamage BOOLEAN DEFAULT NULL, | ||
124 | RestrictPushing BOOLEAN DEFAULT NULL, | ||
125 | AllowLandResell BOOLEAN DEFAULT NULL, | ||
126 | AllowLandJoinDivide BOOLEAN DEFAULT NULL, | ||
127 | BlockShowInSearch BOOLEAN DEFAULT NULL, | ||
128 | |||
129 | AgentLimit INT DEFAULT NULL, | ||
130 | ObjectBonus DOUBLE PRECISION DEFAULT NULL, | ||
131 | Maturity INT DEFAULT NULL, | ||
132 | |||
133 | DisableScripts BOOLEAN DEFAULT NULL, | ||
134 | DisableCollisions BOOLEAN DEFAULT NULL, | ||
135 | DisablePhysics BOOLEAN 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 PRECISION DEFAULT NULL, | ||
143 | Elevation2NW DOUBLE PRECISION DEFAULT NULL, | ||
144 | Elevation1NE DOUBLE PRECISION DEFAULT NULL, | ||
145 | Elevation2NE DOUBLE PRECISION DEFAULT NULL, | ||
146 | Elevation1SE DOUBLE PRECISION DEFAULT NULL, | ||
147 | Elevation2SE DOUBLE PRECISION DEFAULT NULL, | ||
148 | Elevation1SW DOUBLE PRECISION DEFAULT NULL, | ||
149 | Elevation2SW DOUBLE PRECISION DEFAULT NULL, | ||
150 | |||
151 | WaterHeight DOUBLE PRECISION DEFAULT NULL, | ||
152 | TerrainRaiseLimit DOUBLE PRECISION DEFAULT NULL, | ||
153 | TerrainLowerLimit DOUBLE PRECISION DEFAULT NULL, | ||
154 | |||
155 | UseEstateSun BOOLEAN DEFAULT NULL, | ||
156 | Sandbox BOOLEAN DEFAULT NULL, | ||
157 | |||
158 | SunVectorX DOUBLE PRECISION DEFAULT NULL, | ||
159 | SunVectorY DOUBLE PRECISION DEFAULT NULL, | ||
160 | SunVectorZ DOUBLE PRECISION DEFAULT NULL, | ||
161 | |||
162 | FixedSun BOOLEAN DEFAULT NULL, | ||
163 | SunPosition DOUBLE PRECISION DEFAULT NULL, | ||
164 | |||
165 | Covenant VARCHAR(36) DEFAULT NULL, | ||
166 | |||
167 | PRIMARY KEY (RegionID) | ||
168 | ); | ||
169 | |||