diff options
author | Jeff Ames | 2009-01-24 08:18:41 +0000 |
---|---|---|
committer | Jeff Ames | 2009-01-24 08:18:41 +0000 |
commit | 676b7c107358fa29e5716e68f65b39da586aa99a (patch) | |
tree | 366fd52db79cd2f35ebe3b8342dc26db810e14e7 /OpenSim/Data/NHibernate/Resources/PostgreSQLDialect/001_RegionStore.sql | |
parent | * minor: remove mono compiler warning (diff) | |
download | opensim-SC_OLD-676b7c107358fa29e5716e68f65b39da586aa99a.zip opensim-SC_OLD-676b7c107358fa29e5716e68f65b39da586aa99a.tar.gz opensim-SC_OLD-676b7c107358fa29e5716e68f65b39da586aa99a.tar.bz2 opensim-SC_OLD-676b7c107358fa29e5716e68f65b39da586aa99a.tar.xz |
Update svn properties.
Diffstat (limited to '')
-rw-r--r-- | OpenSim/Data/NHibernate/Resources/PostgreSQLDialect/001_RegionStore.sql | 338 |
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 @@ | |||
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 | ||