1 files changed, 169 insertions, 169 deletions
diff --git a/OpenSim/Data/NHibernate/Resources/PostgreSQLDialect/001_RegionStore.sql b/OpenSim/Data/NHibernate/Resources/PostgreSQLDialect/001_RegionStore.sql
index 42c999b..ff227c1 100644
--- a/OpenSim/Data/NHibernate/Resources/PostgreSQLDialect/001_RegionStore.sql
+++ b/OpenSim/Data/NHibernate/Resources/PostgreSQLDialect/001_RegionStore.sql
@@ -1,169 +1,169 @@
-CREATE TABLE Prims (
+CREATE TABLE Prims (
-  UUID VARCHAR(36) NOT NULL,
+  UUID VARCHAR(36) NOT NULL,
-  RegionID VARCHAR(36) DEFAULT NULL,
+  RegionID VARCHAR(36) DEFAULT NULL,
-  GroupID VARCHAR(36) DEFAULT NULL,
+  GroupID VARCHAR(36) DEFAULT NULL,
-  ParentID INT DEFAULT NULL,
+  ParentID INT DEFAULT NULL,
-  ParentUUID VARCHAR(36) DEFAULT NULL,
+  ParentUUID VARCHAR(36) DEFAULT NULL,
-  OwnerID VARCHAR(36) DEFAULT NULL,
+  OwnerID VARCHAR(36) DEFAULT NULL,
-  LastOwnerID VARCHAR(36) DEFAULT NULL,
+  LastOwnerID VARCHAR(36) DEFAULT NULL,
-  CreatorID VARCHAR(36) DEFAULT NULL,
+  CreatorID VARCHAR(36) DEFAULT NULL,
-  CreationDate INT DEFAULT NULL,
+  CreationDate INT DEFAULT NULL,
-  LinkNum INT DEFAULT NULL,
+  LinkNum INT DEFAULT NULL,
-  Name VARCHAR(255) DEFAULT NULL,
+  Name VARCHAR(255) DEFAULT NULL,
-  Text VARCHAR(255) DEFAULT NULL,
+  Text VARCHAR(255) DEFAULT NULL,
-  Description VARCHAR(255) DEFAULT NULL,
+  Description VARCHAR(255) DEFAULT NULL,
-  SitName VARCHAR(255) DEFAULT NULL,
+  SitName VARCHAR(255) DEFAULT NULL,
-  TouchName VARCHAR(255) DEFAULT NULL,
+  TouchName VARCHAR(255) DEFAULT NULL,
-  ObjectFlags INT DEFAULT NULL,
+  ObjectFlags INT DEFAULT NULL,
-  OwnerMask INT DEFAULT NULL,
+  OwnerMask INT DEFAULT NULL,
-  NextOwnerMask INT DEFAULT NULL,
+  NextOwnerMask INT DEFAULT NULL,
-  GroupMask INT DEFAULT NULL,
+  GroupMask INT DEFAULT NULL,
-  EveryoneMask INT DEFAULT NULL,
+  EveryoneMask INT DEFAULT NULL,
-  BaseMask INT DEFAULT NULL,
+  BaseMask INT DEFAULT NULL,
-  Material SMALLINT DEFAULT NULL,  
+  Material SMALLINT DEFAULT NULL,  
-  ScriptAccessPin INT DEFAULT NULL,
+  ScriptAccessPin INT DEFAULT NULL,
-  TextureAnimation BYTEA,
+  TextureAnimation BYTEA,
-  ParticleSystem BYTEA,
+  ParticleSystem BYTEA,
-  ClickAction SMALLINT DEFAULT NULL,  
+  ClickAction SMALLINT DEFAULT NULL,  
-  Color INT DEFAULT NULL,
+  Color INT DEFAULT NULL,
-  PositionX DOUBLE PRECISION DEFAULT NULL,
+  PositionX DOUBLE PRECISION DEFAULT NULL,
-  PositionY DOUBLE PRECISION DEFAULT NULL,
+  PositionY DOUBLE PRECISION DEFAULT NULL,
-  PositionZ DOUBLE PRECISION DEFAULT NULL,
+  PositionZ DOUBLE PRECISION DEFAULT NULL,
-  GroupPositionX DOUBLE PRECISION DEFAULT NULL,
+  GroupPositionX DOUBLE PRECISION DEFAULT NULL,
-  GroupPositionY DOUBLE PRECISION DEFAULT NULL,
+  GroupPositionY DOUBLE PRECISION DEFAULT NULL,
-  GroupPositionZ DOUBLE PRECISION DEFAULT NULL,
+  GroupPositionZ DOUBLE PRECISION DEFAULT NULL,
-  VelocityX DOUBLE PRECISION DEFAULT NULL,
+  VelocityX DOUBLE PRECISION DEFAULT NULL,
-  VelocityY DOUBLE PRECISION DEFAULT NULL,
+  VelocityY DOUBLE PRECISION DEFAULT NULL,
-  VelocityZ DOUBLE PRECISION DEFAULT NULL,
+  VelocityZ DOUBLE PRECISION DEFAULT NULL,
-  AngularVelocityX DOUBLE PRECISION DEFAULT NULL,
+  AngularVelocityX DOUBLE PRECISION DEFAULT NULL,
-  AngularVelocityY DOUBLE PRECISION DEFAULT NULL,
+  AngularVelocityY DOUBLE PRECISION DEFAULT NULL,
-  AngularVelocityZ DOUBLE PRECISION DEFAULT NULL,
+  AngularVelocityZ DOUBLE PRECISION DEFAULT NULL,
-  AccelerationX DOUBLE PRECISION DEFAULT NULL,
+  AccelerationX DOUBLE PRECISION DEFAULT NULL,
-  AccelerationY DOUBLE PRECISION DEFAULT NULL,
+  AccelerationY DOUBLE PRECISION DEFAULT NULL,
-  AccelerationZ DOUBLE PRECISION DEFAULT NULL,
+  AccelerationZ DOUBLE PRECISION DEFAULT NULL,
-  RotationX DOUBLE PRECISION DEFAULT NULL,
+  RotationX DOUBLE PRECISION DEFAULT NULL,
-  RotationY DOUBLE PRECISION DEFAULT NULL,
+  RotationY DOUBLE PRECISION DEFAULT NULL,
-  RotationZ DOUBLE PRECISION DEFAULT NULL,
+  RotationZ DOUBLE PRECISION DEFAULT NULL,
-  RotationW DOUBLE PRECISION DEFAULT NULL,
+  RotationW DOUBLE PRECISION DEFAULT NULL,
-  SitTargetOffsetX DOUBLE PRECISION DEFAULT NULL,
+  SitTargetOffsetX DOUBLE PRECISION DEFAULT NULL,
-  SitTargetOffsetY DOUBLE PRECISION DEFAULT NULL,
+  SitTargetOffsetY DOUBLE PRECISION DEFAULT NULL,
-  SitTargetOffsetZ DOUBLE PRECISION DEFAULT NULL,
+  SitTargetOffsetZ DOUBLE PRECISION DEFAULT NULL,
-  SitTargetOrientW DOUBLE PRECISION DEFAULT NULL,
+  SitTargetOrientW DOUBLE PRECISION DEFAULT NULL,
-  SitTargetOrientX DOUBLE PRECISION DEFAULT NULL,
+  SitTargetOrientX DOUBLE PRECISION DEFAULT NULL,
-  SitTargetOrientY DOUBLE PRECISION DEFAULT NULL,
+  SitTargetOrientY DOUBLE PRECISION DEFAULT NULL,
-  SitTargetOrientZ DOUBLE PRECISION DEFAULT NULL,
+  SitTargetOrientZ DOUBLE PRECISION DEFAULT NULL,
-  -- this is the shape
+  -- this is the shape
-  Shape INT DEFAULT NULL,
+  Shape INT DEFAULT NULL,
-  ScaleX DOUBLE PRECISION DEFAULT NULL,
+  ScaleX DOUBLE PRECISION DEFAULT NULL,
-  ScaleY DOUBLE PRECISION DEFAULT NULL,
+  ScaleY DOUBLE PRECISION DEFAULT NULL,
-  ScaleZ DOUBLE PRECISION DEFAULT NULL,
+  ScaleZ DOUBLE PRECISION DEFAULT NULL,
-  PCode INT DEFAULT NULL,
+  PCode INT DEFAULT NULL,
-  PathBegin SMALLINT DEFAULT NULL,
+  PathBegin SMALLINT DEFAULT NULL,
-  PathEnd SMALLINT DEFAULT NULL,
+  PathEnd SMALLINT DEFAULT NULL,
-  PathScaleX INT DEFAULT NULL,
+  PathScaleX INT DEFAULT NULL,
-  PathScaleY INT DEFAULT NULL,
+  PathScaleY INT DEFAULT NULL,
-  PathShearX INT DEFAULT NULL,
+  PathShearX INT DEFAULT NULL,
-  PathShearY INT DEFAULT NULL,
+  PathShearY INT DEFAULT NULL,
-  PathSkew SMALLINT DEFAULT NULL,
+  PathSkew SMALLINT DEFAULT NULL,
-  PathCurve INT DEFAULT NULL,
+  PathCurve INT DEFAULT NULL,
-  PathRadiusOffset SMALLINT DEFAULT NULL,
+  PathRadiusOffset SMALLINT DEFAULT NULL,
-  PathRevolutions INT DEFAULT NULL,
+  PathRevolutions INT DEFAULT NULL,
-  PathTaperX SMALLINT DEFAULT NULL,
+  PathTaperX SMALLINT DEFAULT NULL,
-  PathTaperY SMALLINT DEFAULT NULL,
+  PathTaperY SMALLINT DEFAULT NULL,
-  PathTwist SMALLINT DEFAULT NULL,
+  PathTwist SMALLINT DEFAULT NULL,
-  PathTwistBegin INT DEFAULT NULL,
+  PathTwistBegin INT DEFAULT NULL,
-  ProfileBegin SMALLINT DEFAULT NULL,
+  ProfileBegin SMALLINT DEFAULT NULL,
-  ProfileEnd SMALLINT DEFAULT NULL,
+  ProfileEnd SMALLINT DEFAULT NULL,
-  ProfileCurve INT DEFAULT NULL,
+  ProfileCurve INT DEFAULT NULL,
-  ProfileHollow SMALLINT DEFAULT NULL,
+  ProfileHollow SMALLINT DEFAULT NULL,
-  State INT DEFAULT NULL,
+  State INT DEFAULT NULL,
-  Texture BYTEA,
+  Texture BYTEA,
-  ExtraParams BYTEA,
+  ExtraParams BYTEA,
-  PRIMARY KEY (UUID)
+  PRIMARY KEY (UUID)
-);
+);
-CREATE INDEX PrimsRegionIdIndex ON Prims (RegionID);
+CREATE INDEX PrimsRegionIdIndex ON Prims (RegionID);
-CREATE INDEX PrimsRegionParentUuidIndex ON Prims (ParentUUID);
+CREATE INDEX PrimsRegionParentUuidIndex ON Prims (ParentUUID);
-CREATE TABLE Terrain (
+CREATE TABLE Terrain (
-  RegionID VARCHAR(36) not null,
+  RegionID VARCHAR(36) not null,
-  MapData BYTEA,
+  MapData BYTEA,
-  PRIMARY KEY (RegionID)
+  PRIMARY KEY (RegionID)
-);
+);
-CREATE TABLE PrimItems (
+CREATE TABLE PrimItems (
-  ItemID VARCHAR(36) NOT NULL,
+  ItemID VARCHAR(36) NOT NULL,
-  GroupID VARCHAR(36) DEFAULT NULL,
+  GroupID VARCHAR(36) DEFAULT NULL,
-  PrimID VARCHAR(36) DEFAULT NULL,
+  PrimID VARCHAR(36) DEFAULT NULL,
-  ParentFolderID VARCHAR(36) DEFAULT NULL,
+  ParentFolderID VARCHAR(36) DEFAULT NULL,
-  AssetID VARCHAR(36) DEFAULT NULL,
+  AssetID VARCHAR(36) DEFAULT NULL,
-  OwnerID VARCHAR(36) DEFAULT NULL,
+  OwnerID VARCHAR(36) DEFAULT NULL,
-  LastOwnerID VARCHAR(36) DEFAULT NULL,
+  LastOwnerID VARCHAR(36) DEFAULT NULL,
-  CreatorID VARCHAR(36) DEFAULT NULL,
+  CreatorID VARCHAR(36) DEFAULT NULL,
-  CreationDate INT DEFAULT NULL,
+  CreationDate INT DEFAULT NULL,
-  InvType INT DEFAULT NULL,
+  InvType INT DEFAULT NULL,
-  Name VARCHAR(255) DEFAULT NULL,
+  Name VARCHAR(255) DEFAULT NULL,
-  Description VARCHAR(255) DEFAULT NULL,
+  Description VARCHAR(255) DEFAULT NULL,
-  NextPermissions INT DEFAULT NULL,
+  NextPermissions INT DEFAULT NULL,
-  CurrentPermissions INT DEFAULT NULL,
+  CurrentPermissions INT DEFAULT NULL,
-  BasePermissions INT DEFAULT NULL,
+  BasePermissions INT DEFAULT NULL,
-  EveryonePermissions INT DEFAULT NULL,
+  EveryonePermissions INT DEFAULT NULL,
-  GroupPermissions INT DEFAULT NULL,
+  GroupPermissions INT DEFAULT NULL,
-  Flags INT DEFAULT NULL,
+  Flags INT DEFAULT NULL,
-  PRIMARY KEY (ItemID)
+  PRIMARY KEY (ItemID)
-);
+);
-CREATE INDEX PrimItemsPrimIdIndex ON PrimItems (PrimID);
+CREATE INDEX PrimItemsPrimIdIndex ON PrimItems (PrimID);
-CREATE TABLE RegionSettings (
+CREATE TABLE RegionSettings (
-  RegionID VARCHAR(36) NOT NULL,
+  RegionID VARCHAR(36) NOT NULL,
-  
+  
-  BlockTerraform BOOLEAN DEFAULT NULL,
+  BlockTerraform BOOLEAN DEFAULT NULL,
-  BlockFly BOOLEAN DEFAULT NULL,
+  BlockFly BOOLEAN DEFAULT NULL,
-  AllowDamage BOOLEAN DEFAULT NULL,
+  AllowDamage BOOLEAN DEFAULT NULL,
-  RestrictPushing BOOLEAN DEFAULT NULL,
+  RestrictPushing BOOLEAN DEFAULT NULL,
-  AllowLandResell BOOLEAN DEFAULT NULL,
+  AllowLandResell BOOLEAN DEFAULT NULL,
-  AllowLandJoinDivide BOOLEAN DEFAULT NULL,
+  AllowLandJoinDivide BOOLEAN DEFAULT NULL,
-  BlockShowInSearch BOOLEAN DEFAULT NULL,
+  BlockShowInSearch BOOLEAN DEFAULT NULL,
-  
+  
-  AgentLimit INT DEFAULT NULL,
+  AgentLimit INT DEFAULT NULL,
-  ObjectBonus DOUBLE PRECISION DEFAULT NULL,
+  ObjectBonus DOUBLE PRECISION DEFAULT NULL,
-  Maturity INT DEFAULT NULL,
+  Maturity INT DEFAULT NULL,
-  
+  
-  DisableScripts BOOLEAN DEFAULT NULL,
+  DisableScripts BOOLEAN DEFAULT NULL,
-  DisableCollisions BOOLEAN DEFAULT NULL,
+  DisableCollisions BOOLEAN DEFAULT NULL,
-  DisablePhysics BOOLEAN DEFAULT NULL,
+  DisablePhysics BOOLEAN DEFAULT NULL,
-  TerrainTexture1 VARCHAR(36) DEFAULT NULL,
+  TerrainTexture1 VARCHAR(36) DEFAULT NULL,
-  TerrainTexture2 VARCHAR(36) DEFAULT NULL,
+  TerrainTexture2 VARCHAR(36) DEFAULT NULL,
-  TerrainTexture3 VARCHAR(36) DEFAULT NULL,
+  TerrainTexture3 VARCHAR(36) DEFAULT NULL,
-  TerrainTexture4 VARCHAR(36) DEFAULT NULL,
+  TerrainTexture4 VARCHAR(36) DEFAULT NULL,
-  Elevation1NW DOUBLE PRECISION DEFAULT NULL,
+  Elevation1NW DOUBLE PRECISION DEFAULT NULL,
-  Elevation2NW DOUBLE PRECISION DEFAULT NULL,
+  Elevation2NW DOUBLE PRECISION DEFAULT NULL,
-  Elevation1NE DOUBLE PRECISION DEFAULT NULL,
+  Elevation1NE DOUBLE PRECISION DEFAULT NULL,
-  Elevation2NE DOUBLE PRECISION DEFAULT NULL,
+  Elevation2NE DOUBLE PRECISION DEFAULT NULL,
-  Elevation1SE DOUBLE PRECISION DEFAULT NULL,
+  Elevation1SE DOUBLE PRECISION DEFAULT NULL,
-  Elevation2SE DOUBLE PRECISION DEFAULT NULL,
+  Elevation2SE DOUBLE PRECISION DEFAULT NULL,
-  Elevation1SW DOUBLE PRECISION DEFAULT NULL,
+  Elevation1SW DOUBLE PRECISION DEFAULT NULL,
-  Elevation2SW DOUBLE PRECISION DEFAULT NULL,
+  Elevation2SW DOUBLE PRECISION DEFAULT NULL,
-  
+  
-  WaterHeight DOUBLE PRECISION DEFAULT NULL,
+  WaterHeight DOUBLE PRECISION DEFAULT NULL,
-  TerrainRaiseLimit DOUBLE PRECISION DEFAULT NULL,
+  TerrainRaiseLimit DOUBLE PRECISION DEFAULT NULL,
-  TerrainLowerLimit DOUBLE PRECISION DEFAULT NULL,    
+  TerrainLowerLimit DOUBLE PRECISION DEFAULT NULL,    
-  UseEstateSun BOOLEAN DEFAULT NULL,
+  UseEstateSun BOOLEAN DEFAULT NULL,
-  Sandbox BOOLEAN DEFAULT NULL,
+  Sandbox BOOLEAN DEFAULT NULL,
-  SunVectorX DOUBLE PRECISION DEFAULT NULL,
+  SunVectorX DOUBLE PRECISION DEFAULT NULL,
-  SunVectorY DOUBLE PRECISION DEFAULT NULL,
+  SunVectorY DOUBLE PRECISION DEFAULT NULL,
-  SunVectorZ DOUBLE PRECISION DEFAULT NULL,
+  SunVectorZ DOUBLE PRECISION DEFAULT NULL,
- 
+ 
-  FixedSun BOOLEAN DEFAULT NULL, 
+  FixedSun BOOLEAN DEFAULT NULL, 
-  SunPosition DOUBLE PRECISION DEFAULT NULL, 
+  SunPosition DOUBLE PRECISION DEFAULT NULL, 
- 
+ 
-  Covenant VARCHAR(36) DEFAULT NULL,
+  Covenant VARCHAR(36) DEFAULT NULL,
-   
+   
-  PRIMARY KEY  (RegionID)
+  PRIMARY KEY  (RegionID)
-);
+);

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