diff options
author | John Hurliman | 2009-10-19 16:52:27 -0700 |
---|---|---|
committer | John Hurliman | 2009-10-19 16:52:27 -0700 |
commit | fdce1be3db287bed901332b90ba57165e201d3fc (patch) | |
tree | 8f0792e4c4ac4c14a50559f8439573740a7b3326 /OpenSim/Data/NHibernate/Resources/PostgreSQLDialect/001_RegionStore.sql | |
parent | Merge branch 'prioritization' of ssh://opensimulator.org/var/git/opensim into... (diff) | |
download | opensim-SC_OLD-fdce1be3db287bed901332b90ba57165e201d3fc.zip opensim-SC_OLD-fdce1be3db287bed901332b90ba57165e201d3fc.tar.gz opensim-SC_OLD-fdce1be3db287bed901332b90ba57165e201d3fc.tar.bz2 opensim-SC_OLD-fdce1be3db287bed901332b90ba57165e201d3fc.tar.xz |
* Removed OpenSim.Data.NHibernate
* Replaced calls to ThreadPool.QueueUserWorkItem() with ThreadPool.UnsafeQueueUserWorkItem() since OpenSim does not use Code Access Security sandboxing
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, 0 insertions, 169 deletions
diff --git a/OpenSim/Data/NHibernate/Resources/PostgreSQLDialect/001_RegionStore.sql b/OpenSim/Data/NHibernate/Resources/PostgreSQLDialect/001_RegionStore.sql deleted file mode 100644 index f4a0e68..0000000 --- a/OpenSim/Data/NHibernate/Resources/PostgreSQLDialect/001_RegionStore.sql +++ /dev/null | |||
@@ -1,169 +0,0 @@ | |||
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 INT DEFAULT NULL, | ||
62 | PathEnd INT 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 | ProfileBegin INT DEFAULT NULL, | ||
75 | ProfileEnd INT DEFAULT NULL, | ||
76 | ProfileCurve INT DEFAULT NULL, | ||
77 | ProfileHollow INT DEFAULT NULL, | ||
78 | State INT DEFAULT NULL, | ||
79 | Texture BYTEA, | ||
80 | ExtraParams BYTEA, | ||
81 | PRIMARY KEY (UUID) | ||
82 | ); | ||
83 | |||
84 | CREATE INDEX PrimsRegionIdIndex ON Prims (RegionID); | ||
85 | CREATE INDEX PrimsRegionParentUuidIndex ON Prims (ParentUUID); | ||
86 | |||
87 | CREATE TABLE Terrain ( | ||
88 | RegionID VARCHAR(36) not null, | ||
89 | MapData BYTEA, | ||
90 | PRIMARY KEY (RegionID) | ||
91 | ); | ||
92 | |||
93 | CREATE TABLE PrimItems ( | ||
94 | ItemID VARCHAR(36) NOT NULL, | ||
95 | GroupID VARCHAR(36) DEFAULT NULL, | ||
96 | PrimID VARCHAR(36) DEFAULT NULL, | ||
97 | ParentFolderID VARCHAR(36) DEFAULT NULL, | ||
98 | AssetID VARCHAR(36) DEFAULT NULL, | ||
99 | OwnerID VARCHAR(36) DEFAULT NULL, | ||
100 | LastOwnerID VARCHAR(36) DEFAULT NULL, | ||
101 | CreatorID VARCHAR(36) DEFAULT NULL, | ||
102 | CreationDate INT DEFAULT NULL, | ||
103 | Type 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 | |||